X_SR_WBL_SG21_CLASS_ATTRIBUTES
- irp
Query Information
Query Names | X_SR_WBL_SG21_CLASS_ATTRIBUTES |
Contributing Institution | District Office |
Contributing Analyst | Marc Grabiel |
Maintenance/Upkeep Required | None known |
Query Entry Last Updated | 7/21/2021 |
Query Search Fields
Term | Term as in SDCCD_IRD (e.g. 2207, 2213, etc) |
Query Fields of Interest
Crse Attr | Identifies Course Attribute SG21 |
CrsAtr Val | Identifies which SG21 subcategory value |
Class Nbr | Identifies Classnbr – used in Join |
Campus | Credit College or CE Campus |
Term | Identifies Term – used in Join |
Subject | Identifies Subject |
Catalog | Identifies Catnum |
Enrl Stat | Identifies if the section is open for enrollment or not |
Class Stat | Identifies Classstat |
Tot Enrl | Identifies Enrlcur |
Information about Query
What it does: | This query identifies sections that have SG21 subcategory course attribute coded to a section. A section can have more than one course attribute added and each row represents a single SG21 subcategory value for a section. |
Joins Needed | Please perform a join with Course section via: Course_Section.Term to X_SR_WBL_SG21_CLASS_ATTRIBUTES.Term Course_Section.Classnbr to X_SR_WBL_SG21_CLASS_ATTRIBUTES.Class_Nbr |
Source Table in Campus Solutions | CLASS_ATTRIBUTE – Class Attribute Table
However, you must filter CRSE_ATTR = SG21. |
Validation: | Marc validated section lists provided by Mesa College with lists appearing in the query. All Active sections matched the information provided in the list. Sections that were not Active did not appear in the query. |
Additional Resources: | None |
Known Issues, Related Details, and Other Notes
Credit college course attribute values should be added prior to student enrollments. CE Course attributes can be coded until the end of a term.
Currently the query is only displaying Class stat = “Active”. Cancelled or non-active section must be found by going to the source table in Campus Solutions.
Feel free to reach out to Marc if you have any questions.