Cohort Tracking as used on the Faculty Student Success dashboard indicates a student's enrollment or graduation tracking status as "Enrolled Not Graduated", "Neither Enrolled Nor Graduated", or "Graduated".
Metadata |
---|
Where Term Appears |
---|
CSUMB Data Warehouse Dashboards: |
|
---|
Other Reports: | N/A |
---|
|
Data Custodian |
---|
Institutional Assessment and Research |
Data Source |
---|
Source System: | CMS - SA |
---|
Source Table Name: | N/A |
---|
Source Field Name: | N/A |
---|
Census Process: | N/A |
---|
|
Logical Transformation / Calculation |
---|
distinct case when NOT_GRAD_ENR_CNT = 0 and GRADUATED_CNT = 0 and ENROLLED_CNT = 1 then 'Enrolled Not Graduated' when NOT_GRAD_ENR_CNT = 0 and GRADUATED_CNT = 1 and ENROLLED_CNT = 0 then 'Graduated' when NOT_GRAD_ENR_CNT = 1 and GRADUATED_CNT = 0 and ENROLLED_CNT = 0 then 'Not Graduated Not Enrolled' else 'Enrolled Not Graduated' end |
OBIEE Folder and Column |
---|
Folder Heading: | "Dim - Cohort Fac-Stdnt Success" |
---|
Column Heading: | "Cohort Status" |
---|
|
|
Recently matriculated cohorts would be expected to have a greater percentage of "Enrolled Not Graduated" students while older matriculated cohorts would be expected to have greater percentages of "Graduated" students and perhaps "Neither Enrolled Nor Graduated" students.
Examples
- Enrolled Not Graduated
- Neither Enrolled Nor Graduated
- Graduated