X_SR_MIS_WBL_SG21_COUNTS
Query Information
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 |
Query Search Fields
Term | Term as in SDCCD_IRD (e.g. 2207, 2213, etc) |
Query Fields of Interest
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. |
Information about Query
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 |
Known Issues, Related Details, and Other Notes
Feel free to reach out to Marc if you have any questions.