X_CM_CE_4CBE_CLASSES
- irp
Query Information
Query Name | X_CM_CE_4CBE_CLASSES |
Contributing Institution | District Office |
Contributing Analyst | Marc Grabiel |
Maintenance/Upkeep Required | None known |
Query Entry Last Updated | 12/10/2021 |
Query Search Fields
Term (FYI – it’s optional) | Term as in SDCCD_IRD (e.g. 2207, 2213, etc) |
Query Fields of Interest
Term | Identifies Term – used in Join |
Campus | SDCCE Campus (CS017) |
Location | Location – used to identify Modality mostly (CS019) |
Subject | Subject (CS006) |
Catalog | Catnum (CS007) |
Course Description | Crsetitle (CS022) |
Class Nbr | Classnbr (CS008) – used in Join |
Class Stat | Classstat (CS010) |
Start Date | Startdate (CS020) |
End Date | Enddate (CS021) |
Assign Seq # | Sequence of Faculty role assigned – used to distinguish different professors for the same class or if the same profesor name but different number, for multiple assignment |
Instructor Name | Name (FA009) |
4CBE Type | Course Attribute Value of Course Attribute 4CBE |
4CBE Description | Number of courses and college relationship for noncredit-credit agreement |
Tot Enrl | Enrlcur (CS014) – Number of students currently enrolled (Enrlstatus = E) |
Information about Query
What it does: | This query identifies sections that have an SDCCE CTE Transitions Credit by Exam agreement. It is triggered by having the Course Attribute 4CBE added to the section and the Course Attribute Value is used to identify the number of CE courses required to fulfill the agreement, the number of Credit college courses it awards and to which college that credit goes to because of the agreement. Letter meaning: CE_Courses-to-College_Courses A: 1-to-1 agreement, B: n-to-1 agreement, C: 1-to-n agreement, D: n-to-n agreement # meaning: to which college (1 – City, 2 – Mesa, 3 – Miramar) -3: to Miramar, -2,3: to Mesa or Miramar Examples: C-3, 1CE:nMiramar – 1 CE course to multiple Miramar courses B-1,2, nCE:1City/1Mesa – many CE courses to 1 course at City or Mesa It also allows you to use it for validation of sections with values added (original intent) by being able to see which agreements are assigned to the course and see faculty assignment numbers so if there is repetition you can visually distinguish it. It also has the number enrolled so it can be used for enrollment counts (but appropriate de-duplcation of rows must occur first (remove duplicates by Class Nbr). |
Joins Needed | Please perform a join with Course section via: Course_Section.Term to X_CM_CE_4CBE_CLASSES.Term Course_Section.Classnbr to X_CM_CE_4CBE_CLASSES.Class_Nbr |
Source Table in Campus Solutions | CLASS_ATTRIBUTE Filter by CRSE_ATTR = 4CBE |
Validation: | Marc validated this query to ensure that it served its original intent (list of sections with duplication on faculty assignments and when courses may have multiple 4CBE course attribute values). |
Additional Resources: | Credit by Exam webpage: |
Known Issues, Related Details, and Other Notes
Feel free to reach out to Marc if you have any questions.