X_CM_LCMP_CLASSES
Query Information
Query Name | X_CM_LCMP_CLASSES |
Contributing Institution | District Office |
Contributing Analyst | Stephen Bass |
Maintenance/Upkeep Required | None known |
Query Entry Last Updated | 4/26/2021 |
Query Search Fields
Term | Term as in SDCCD_IRD (e.g. 2207, 2213, etc) |
Offer Nbr (Optional) | 1, 2, or 3 |
Course ID (Optional) | Six digits, returns all similar Subnum sections for that term. |
Query Fields of Interest
Term | Identifies Term – used in Join |
Offer Nbr | Identifies College |
CrsAtr Val | Identifies the Parent LCMP section Class Nbr |
Class Nbr | Identifies Class Number of one of the LCOM child sections |
Information about Query
What it does: | This query identifies parent LCMP sections and their participating child LCOM sections. Students enroll in the parent LCMP section and will later on be enrolled in these “bundled” learning community sections. All of the information after CrsAtr (Column F) should be about those child LCOM sections. |
Joins Needed | Please perform a join with Course section via: Course_Section.Term to X_CM_LCMP_CLASSES.Term Course_Section.Classnbr to X_CM_LCMP_CLASSES.CrsAtr_Val (for join to parent) Or Course_Section.Classnbr to X_CM_LCMP_CLASSES.Class_nbr (for join to child) |
Source Table in Campus Solutions | CLASS_ATTRIBUTE |
Validation: | Marc validated several of the sections that appeared in this query as LCMP/LCOM through the Course Attr LCOM and Crse Attr LCMP fields in the Daily Downloads. The sections and categories that appear in the query match what is seen in the Daily Downloads. |
Additional Resources: | List of Math and English LCMP sections at City College for Fall 2019 are below: R:\Campus Solutions Portal\Special Run Queries - Support Documentation\X_CM_LCMP_CLASSES |
Known Issues, Related Details, and Other Notes
LCMP values are incomplete for City in Fall 2019. Please look at the additional resources for the filepath to some of City’s Fall 2019 LCMP sections.
In the CLASS_ATTRIBUTE table parent sections will have the CRSE_ATTR listed as “LCOM” and CRSE_ATTR_VALUE listed as “YES”. Child sections will have the CRSE_ATTR listed as “LCMP” and CRSE_ATTR_VALUE state the Classnbr of the larent section.