Update Master Schedule Sections
Effective 2019/2020, six additional Course fields were added for CALPADS course submissions.
- Content Sub Category (CRS.CSC)
- Standards Grade Range (CRS.SGR)
- Content Standards Alignment (CRS.CSA)
- AP/IB Crs Code Cross Reference (CRS.ACC)
- Middle School Core (CRS.MSC) Yes/No
- Charter Non-Core (CRS.CNC) Yes/No
Update Course Table ↑
To update the fields on a Course, run the following query at a High School and at a Middle School (to populate the Middle School Core (CRS.MSC) field). Use the fields provided in the query to assist with populating the new Course fields.
Run this LIST query first:
LIST CRS MST TCH MST.SE MST.CN CRS.CO CRS.C3 CRS.S1 CRS.S1? TCH.TE CRS.CSC CRS.SGR CRS.CSA CRS.ACC CRS.MSC CRS.CNC BY CRS.S1
After obtaining the LIST results, click the Change button.
In Change mode, lock the Course# (CRS.CN), Course Title (CRS.CO) , State Course Code CRS (CRS.C3), Subject Area 1 (CRS.S1), and Teacher Name (TCH.TE) fields.
Update the Content Sub Category (CRS.CSC), Standards Grade Range (CRS.SGR), Content Standards Alignment (CRS.CSA), AP/IB Crs Code Cross Reference (CRS.ACC), Middle School Core (CRS.MSC), and Charter Non-Core (CRS.CNC) fields for each course accordingly. Exit to Save the changes.
Update Master Schedule Sections ↑
For schools using a Master Schedule (MST), each section may need the three newly added Course fields to be populated with the applicable information. In addition, Middle Schools may need to also populate the Middle School Core (MST.MSC) field.
- Content Sub Category (MST.CSC)
- Charter Non-Core (MST.CNC) Yes/No
- AP/IB Crs Code Cross Reference (MST.ACC)
- Middle School Core (MST.MSC)
If the newly added fields on the Section (MST.SE) at a High School or Middle School need to be updated with a value that is different than what is populated on the Course (CRS), the following query includes the corresponding populated Course (CRS) fields which can be used to assist with populating the newly added Section fields.
In addition, the Section has three new fields that must also be populated. These fields are included these fields in the query so that districts can address all the changes at one time.
- Online Course Instruction Type (MST.OIT)
- Local Assignment Option (MST.NCA)
- Highly Quality CTE Course (MST.HQC)
To view and populate the newly added fields, run this LIST query first:
LIST CRS MST TCH MST.SE MST.CN CRS.CO CRS.C3 CRS.S1 CRS.S1? TCH.TE CRS.CSC MST.CSC CRS.SGR CRS.CSA CRS.ACC MST.ACC CRS.MSC MST.MSC CRS.CNC MST.CNC MST.OIT MST.NCA MST.HQC BY CRS.S1
After obtaining the LIST results, click the Change button.
In Change mode, lock the Course# (CRS.CO), Course Title (CRS.CO), State Course Code (CRS.C3), Subject Area 1 (CRS.S1), Teacher Name (TCH.TE), Content Sub Category (CRS.CSC), Standard Grade Range (CRS.SGR), Content Standards Alignment (CRS.CSA), AP/IB Crs Code Cross Reference (CRS.ACC), Middle School Core (CRS.MSC) and Charter Non-Core (CRS.CNC) fields.
Update the Content Sub Category (MST.CSC), AP/IB Crs Code Cross Reference (MST.ACC), Middle School Core (MST.MSC), Charter Non-Core (MST.CNC), Online Course Instruction Type (MST.OIT), Local Assignment Option (MST.NCA) and High Quality CTE Course (MST.HQC) fields for each course accordingly. Exit to Save the changes.
To view and populate the Content Sub Category (MST.CSC) field for the 23 Course Group State courses that require the Content Sub Category to be populated, the following query can be run:
LIST CRS CRS.CN CRS.CO CRS.C3 CRS.S1 CRS.S1? CRS.CSC CRS.SGR CRS.CSA CRS.ACC CRS.MSC CRS.CNC BY CRS.S1 IF ( CRS.C3 = 9000 OR CRS.C3 = 9051 OR CRS.C3 = 9080 OR CRS.C3 = 9090 OR CRS.C3 = 9130 OR CRS.C3 = 9131 OR CRS.C3 = 9132 OR CRS.C3 = 9133 OR CRS.C3 = 9134 OR CRS.C3 = 9135 OR CRS.C3 = 9136 OR CRS.C3 = 9137 OR CRS.C3 = 9155 OR CRS.C3 = 9156 OR CRS.C3 = 9157 OR CRS.C3 = 9222 OR CRS.C3 = 9223 OR CRS.C3 = 9291 OR CRS.C3 = 9292 OR CRS.C3 = 9293 OR CRS.C3 = 9294 OR CRS.C3 = 9316 OR CRS.C3 = 9381 )
Please refer to the CALPADS documentation for more information: CALPADS System Documentation