Dept Grad % represents the percentage of students in a given subject that have graduated and are no longer enrolled.
| Metadata |
|---|
| 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 |
|---|
| 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}['@'])) |
| Dataset Folder and Field Name |
|---|
| Dataset Folder: | N/A |
|---|
| Field Name: | "@{MyStudVar6}" |
|---|
|
|
See Also