Body
Summary
The Census Enrollment Snapshot offers the user a semester overview of the institution's student body profile. This snapshot is based on the institution's Texas Higher Education Coordinating Board (THECB) certified data as of the official reporting date (ORD).
Detailed Description
The Census Enrollment Snapshot is based on the Texas Higher Education Coordinating Board (THECB) certified CBM001/0C1 Census Student Report data. The data is certified as of the Official Reporting Date (ORD) and excludes Flex Entry enrollment in accordance with THECB reporting practices. The Census Enrollment Snapshot dashboard offers users a term view of the institution's student body demographics.
Data Lineage
Note: A link will be provided in the future that will allow users to view the lineage of the data.
Data Source: PeopleSoft (PS) CS
Table Name(s):
- PS_UHCB_001
- PS_UHCB_STDNT_HIST
- PS_STDNT_GRPS_HIST
- PS_TERM_TBL
- PS_EMAIL_ADDRESSES
- PS_PERSONAL_DATA
- PS_EXT_ORG_TBL
Data Transformation Source:
- Database: sqldw-prd\sql19dwprod
- Schema: SECURE
- Table Name(s):
- CS.MQ_CB01Stdnt - Contains the CBM001/0C1 Student Census data transformation.
- View Name(s):
- CS.D_TERM - Provides friendly display names for the term selector
Dashboard Criteria:
- UHCB_FLEX_ENTRY NOT IN ('1', '3', '7')
- REPORT_YN = 'Y'
- STRM = [current term]
Recommended Dashboards/Reports
Facts at a Glance (FaaG) - offers users a 5-term trend overview of the institution's student body profile.
Similar Dashboards/Reports
Currently, there are no similar dashboards or reports.