Dept Grad %

From CSUMB Data Glossary
Jump to navigation Jump to search

Dept Grad % represents the percentage of students in a given subject 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
SET VARIABLE DISABLE_CACHE_HIT=1;select 100*cast(count(distinct case when "Dim - Cohort Fac-Stdnt Success"."Graduated Count"=1 then "Scholar"."Scholar Number" else null end)as double) /cast(count(distinct "Scholar"."Scholar Number") as double) FROM "SIA - Student Records - Class Enrollment" WHERE ("Dim - SIA - Academic Class-FSSD"."Term Descr" in (@{MyStudVar3})) AND (NOT "Grade"."Grade Code" = '__NOT_APPLICABLE__') AND ("Dim - SIA - Academic Class-FSSD"."Subject Code" IN (@{MyStudVar5}['@']))
OBIEE Folder and Column
Folder Heading:N/A
Column Heading:"@{MyStudVar6}"

See Also