Univ Grad % represents the percentage of students across the university that have graduated and are no longer enrolled.
| Metadata |
|---|
| Where Term Appears |
|---|
| CSUMB Data Warehouse Dashboards: |
|
|---|
| Other Reports: | N/A |
|---|
|
| Data Custodian |
|---|
| Data Warehouse |
| Data Source |
|---|
| Source System: | CMS - SA |
|---|
| Source Table Name: | N/A |
|---|
| Source Field Name: | N/A |
|---|
| Census Process: | N/A |
|---|
|
| Logical Transformation / Calculation |
|---|
| REPORT_AGGREGATE(100*count(distinct case when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Enrolled Count"=1 then "SIA - Student Records - Class Enrollment"."Scholar"."Scholar Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Subject Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Catalog Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Class Section Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Term Code" else null end)/count(distinct case when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Graduated Count"=1 or "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Enrolled Count" =1 or "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."Not Grad Enrolled Count"=1 then "SIA - Student Records - Class Enrollment"."Scholar"."Scholar Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Subject Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Catalog Number"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Class Section Code"||'~'||"SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Term Code" else null end) BY "SIA - Student Records - Class Enrollment"."Dim - SIA - Academic Class-FSSD"."Term Descr", case when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."EOP"='Enrolled' then 'Yes' when "SIA - Student Records - Class Enrollment"."Dim - Cohort Fac-Stdnt Success"."EOP"='Not Enrolled' then 'No' ELSE 'Unknown' end) |
| OBIEE Folder and Column |
|---|
| Folder Heading: | N/A |
|---|
| Column Heading: | "@{MyStudVar}" |
|---|
|
|
See Also