X_SR_MIS_STDNT_ATTR_WBL_SG21 and X_SR_MIS_WBL_SG21
Query Information
Query Names | X_SR_MIS_STDNT_ATTR_WBL_SG21 X_SR_MIS_WBL_SG21 |
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) |
Campus | CE, CITY, MESA, MIRA, (or leave blank for all) Note. CE Specific campuses are not an option and “CE” does not pull up each CE Campus. |
Query Fields of Interest
Campus | Identifies College or Campus (CE) |
Term | Identifies Term – used in Join |
ID | Identifies Emplid – used in Join |
WBL | States MIS DED# SG21 |
Attr Value | States SG21 Subcategory value |
Descr | States SG21 Subcategory value description |
Notes | Additional notes provided. Is used as short-term method to identify if entry is tied to a class section (“IS”) |
Information about Query
What it does: | These queries provide student level reporting for SG21 subcategories. Each row represents a single SG21 subcategory entry. Students may receive multiple SG21 subcategories and may receive multiple of the same SG21 subcategory in a term. |
Joins Needed | Please perform a join with Student Basic or Enrollment via: to X_SR_MIS_STDNT_ATTR_WBL_SG21.Term to X_SR_MIS_STDNT_ATTR_WBL_SG21.ID |
Source Table in Campus Solutions | CES_STDNT_ATTR – Student Attribute table
However, you must filter for “SG21” at “STDNT_ATTR – Student Attribute” and remove any “EFFDT - Effective Date” filtering. |
Validation: | Marc validated this source and query with each Career and Technical Education lead. No lead found an issue with the numbers provided with their own internal validation. |
Additional Resources: | None |
Known Issues, Related Details, and Other Notes
These two queries are the same thing except they appear in a different order. X_SR_MIS_WBL_SG21 orders by Campus and then ID. It is unclear how X_SR_MIS_STDNT_ATTR_WBL_SG21 orders. Marc believes it is the order data was added.
Marc found that some teams performing entry input needed support in how to input multiple rows of data at the same time when the practice first began.
Term values may be off as they are manually input. Marc found one value from term “2007”.
Feel free to reach out to Marc if you have any questions.