Total Open University Headcount

From CSUMB Data Glossary
Jump to navigation Jump to search

Total Open University Headcount provides the headcount of students enrolled in Open University courses.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:
Other Reports:N/A
Data Custodian
Office of the Registrar
Data Source
Source System:CMS - SA
Source Table Name:PS_ACAD_PROG_TBL PS_PERSONAL_DATA
Source Field Name:ACAD_PROG EMPLID
Census Process:N/A
Logical Transformation / Calculation
count(distinct case when W_ACAD_PROG_CODE = 'PMSTR' then SCHOLAR_ID else NULL end )

from W_SIA_ACAD_PROG_D,

W_SIA_SCHOLAR_D
OBIEE Folder and Column
Folder Heading:N/A
Column Heading:N/A

See Also