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
SUM(COUNT (DISTINCT (CASE WHEN "Academic Program"."Academic Program Code" in ('POPEN','UOPEN','PMSTR') THEN "Scholar"."Scholar Number" ELSE NULL END )))
OBIEE Folder and Column
Folder Heading:N/A
Column Heading:Calculated

See Also