X_SR_MIS_WBL_SG21_DISTINCT_CE and X_SR_MIS_WBL_SG21_CE_CAMP_ID

Query Names

X_SR_MIS_WBL_SG21_DISTINCT_CE

X_SR_MIS_WBL_SG21_CE_CAMP_ID

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)

SG21 CE Campus

Identifies CE Campus listed

Term

Identifies Term – used in Join

ID

Identifies Emplid – used in Join

What it does:

These queries are the same as X_SR_MIS_WBL_SG21_DISTINCT except it does not include any of the credit colleges in SG21 CE Campus. These query provides a list of IDs with at least one student level SG21 subcategory reported at an SG21 Campus and term. They do not provide information about which SG21 subcategory was recorded or how many SG21 subcategories a student received. This list is unduplicated at the SG21 CE Campus level (if a student was given an SG21 subcategory at CCHAV and MCITY in the same term they will appear in each SG21 CE Campus list). An SDCCE unduplicated lists will have to be created manually.

Joins Needed

Please perform a join with Student Basic or Enrollment via:

to X_SR_MIS_WBL_SG21_DISTINCT_CE.Term

to X_SR_MIS_WBL_SG21_DISTINCT_CE.ID

Recoding may need to happen to link SG21 CE Campus to specific campuses

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 CE 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