X_SR_MIS_WBL_SG21_COUNTS

Query Names

X_SR_MIS_WBL_SG21_COUNTS

Contributing Institution

District Office

Contributing Analyst

Marc Grabiel

Maintenance/Upkeep Required

None known

Query Entry Last Updated

7/21/2021

Term

Term as in SDCCD_IRD (e.g. 2207, 2213, etc)

Campus

Identifies College or Campus (CE)

Term

Identifies Term – used in Join

WBL

States MIS DED# SG21

Attr Value

States SG21 Subcategory value

Descr

States SG21 Subcategory value description

Count ID

Provides the number of rows with the subcategory in a term at each institution.

What it does:

This query provides a pivot table of student level reporting for SG21 subcategories (X_SR_MIS_WBL_SG21) counts by Campus and Attr_Value. Students may receive multiple SG21 subcategories and may receive multiple of the same SG21 subcategory in a term. Each entry will be included in this count. The following counts will have to be tallied manually (Districtwide, All Credit Colleges, SDCCE).

Joins Needed

N/A

Source Table in Campus Solutions

CES_STDNT_ATTR – Student Attribute table

However, you must filter for “SG21” at “STDNT_ATTR – Student Attribute”, remove any “EFFDT - Effective Date” filtering and then construct the pivot table.

Validation:

Marc validated these query values to what he sees when he counts the values like this in X_SR_MIS_WBL.

Additional Resources:

None