...
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 for at City College for Fall 2019 are below: R:\Campus Solutions Portal\Special Run Queries - Support Documentation\X_CM_LCMP_CLASSES |
...