Body
Summary
The Dashboard displays Orientation Data for different Semesters, based on Enrollment Day. It provides a clear snapshot of admitted students' progress in the enrollment and orientation process.
Detailed Description
The "Orientation Dashboard" provides a detailed overview of the registration, attendance, and participation rates for various student orientation programs
The dashboard displays the following columns for Different Event_Types:
- Total headcount for the event, Count of students who indicated they will attend,
- Count of students who actually attended, Count of students who canceled
- Count of students with U01/U02 advising holds
- Count of students with O12 (Orientation Launchpad) hold
- Count of students with R17 (TSI) hold
- Number of students flagged as enrollment-ready
- Number of students who completed Step 1
- Number of students who completed Step 2
- Students who didn’t complete Step 2 but were advised (not enrolled)
- Number of students who completed Step 3
- Number of students who did not complete Step 3
Data Lineage
Note: A link will be provided in the future that will allow users to view the lineage of the data.
Data Transformation Source: Database: sqldw-prd\sql19dwprod
Schema: PeopleSoft (PS) CS
- Table Name(s):
- E_PS_ACAD_PROG
- E_PS_ACAD_PROG_EFF
- PS_CAMPUS_EVENT
- PS_CAMPUS_MTG_SEL
- PS_EVENT_MTG
- PS_SESSION_TBL
- PS_SRVC_IND_DATA
- PS_STDNT_CAR_TERM
- PS_STDNT_GRPS_HIST
- PS_TERM_TBL
- PS_UHS_ORIENT_RQST
- Fact Tables (from Data Warehouse)
- F_ORIENTATION_COUNTS
- F_ORIENTATION_EVENT_TYPES
- F_ORIENTATION_ADMITTED
- F_ORIENTATION_REGISTERED_CURRENT
Schema: SECURE
- Table Name(s):
- CS.MS_ORIENTATION_COUNTS - Contains Orientation Counts table has the Students who have registered for Orienatation.
- View Name(s):
- CS.R_ORIENTATION_COUNTS – View to return data from Orientation_Counts table.
- CS.R_ORIENTATION_ADMITTED – View that returns Admitted Students info
- CS.R_ORIENTATION_EVENT_TYPES – View to return Event Types
- CS.R_ORIENTATION_REGISTERED_CURRENT – View for Registered Current Students.
Dashboard Criteria:
- Key sections of the dashboard include:
- Summary of Students Orientation Attendance
- First-Year Student Orientation Attendance
- Transfer Student Orientation Attendance
- International Student Orientation Attendance
- Student Overview
- Admit Data
- Registration Summary
- Orientation Dashboard is based on the following inputs:
- STRM - Term code
- SEMESTER_Year - Semester and year (e.g., Fall 2025)
- EVENT_TYPE - Type of orientation event (FSO, ISO, TSO)
- CAMPUS_EVENT_NBR - Unique ID for the campus event
- EVENT_MTG - Meeting number associated with the campus event
- DAYOFENRL - Number of days relative to enrollment
- COLLEGE - College name (e.g., HSH, SOE)
Recommended Dashboards/Reports
Currently, there are no similar dashboards or reports.
Similar Dashboards/Reports
Currently, there are no similar dashboards or reports.