X_SR_MIS_WBL_SG21_CE

Query Information

Query Name	X_SR_MIS_WBL_SG21_CE
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
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”)

What it does:	This query provides 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. It is CE specific.
Joins Needed	Please perform a join with Student Basic or Enrollment via: to X_SR_MIS_WBL_SG21_CE.Term to X_SR_MIS_WBL_SG21_CE.ID
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 filter out CITY, MESA, and MIRA.
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

This query is the same as X_SR_MIS_WBL_SG21 except it only shows the different Campuses for CE. X_SR_MIS_WBL_SG21_CE orders by Campus and then ID.
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 a different campus with term “2007”.
Feel free to reach out to Marc if you have any questions.