X_SR_MIS_WBL_SG21_DISTINCT

Query Name

X_SR_MIS_WBL_SG21_DISTINCT

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

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.

SG21 Campus

Identifies College or Campus (CE) listed

Term

Identifies Term – used in Join

ID

Identifies Emplid – used in Join

What it does:

This query provides a list of IDs with at least one student level SG21 subcategory reported at an SG21 Campus and term. It does not provide information about which SG21 subcategory was recorded or how many SG21 subcategories a student received. This list is unduplicated at the SG21 Campus level (if a student was given an SG21 subcategory at CITY and MESA in the same term they will appear in each SG21 campus list. This is also true for the CE Campuses). The following unduplicated lists will have to be created manually (Districtwide, All Credit Colleges, SDCCE).

Joins Needed

Please perform a join with Student Basic or Enrollment via:

to X_SR_MIS_WBL_SG21_DISTINCT.Term

to X_SR_MIS_WBL_SG21_DISTINCT.ID

Recoding may need to happen to link SG21 Campus to specific colleges

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 unduplicate at SG21 Campus and ID.

Validation:

Marc validated these query values to what he sees when he counts distinct IDs from X_SR_MIS_WBL_SG21.

Additional Resources:

None