Course Section validations verify that data for specific fields used in the Course Section extract is populated correctly based on CALPADS rules.
|
Error Message |
Description |
[Table]Field |
|---|---|---|
|
School of Course Delivery |
|
|
|
School of Course Delivery is blank. |
Populate the seven-digit School Number field on the Edit School page at the district. |
[S_CA_SCH_X]StateSchoolNumber |
|
School of Course Delivery must be 7 digits. Check the 7-digit School Number on the Edit School page at the District. |
Populate the seven-digit School Number field on the Edit School page at the district. |
[S_CA_SCH_X]StateSchoolNumber |
|
State Course Code |
|
|
|
State Course Code cannot be blank. |
Verify the value entered for the Course Number and/or Alternate Course Number field on the Edit Course District Information page. The Alternate Course Number field is reported, if populated, otherwise the Course Number field is reported. |
[Courses]Alt_Course_Number [Courses]Course_Number |
|
State Course Code is invalid. The value must be a valid state course code. |
Verify the value entered for the Course Number and/or Alternate Course Number field on the Edit Course District Information page. The Alternate Course Number field is reported, if populated, otherwise the Course Number field is reported. |
[Courses]Alt_Course_Number [Courses]Course_Number |
|
Local Course ID |
|
|
|
Local Course ID cannot be blank. |
Populate the Course Number field on the Edit Course District Information page. |
[Courses]Course_Number |
|
Local Course ID cannot be greater than ten characters in length. |
Verify that the Course Number field on the Edit Course District Information page does not exceed ten characters. |
[Courses]Course_Number |
|
Course Name |
|
|
|
Course Name cannot be blank. |
Populate the Course Name field on the Edit Course District Information page. |
[Courses]Course_Name |
|
CTE Postsecondary Articulated Course Indicator |
|
|
|
CTE Technical Preparation Course Indicator is invalid. If populated, the value must be Y or N. |
Choose either Does Not Apply, (Y) Yes, or (N) from the pop-up menu for the CTE Technical Preparation Indicator field on the Edit Course District Information page. |
[S_CA_CRS_X]CTETechPrep |
|
UC CSU Approved Indicator |
|
|
|
UC CSU Approved Indicator cannot be blank. |
Choose a subject area (A-G) or Does Not Apply for the UC/CSU Approved Course Subject Area (Grades 7-12) field on the Edit Course District Information page. |
[S_CA_CRS_X]UCCSU_Area |
|
UC CSU Approved Indicator is invalid. The value must be Y or N. |
Choose a subject area (A-G) or Does Not Apply for the UC/CSU Approved Course Subject Area (Grades 7-12) field on the Edit Course District Information page. Any selected letter value is reported as Y. |
[S_CA_CRS_X]UCCSU_Area |
|
Local Staff ID |
|
|
|
Staff's ID cannot be blank. |
|
[Users]DCID |
|
Course Section Instructional Level Code |
|
|
|
Instructional Level Code is invalid. |
Choose a valid value from the Instructional Level Code pop-up menu on the Edit Section and/or Course District Information page. |
[S_CA_SEC_X]NS_Instructional_Lvl [S_CA_CRS_X]NS_Instructional_Lvl |
|
Education Service Code (Record Type CRSE Only) |
|
|
|
Education Service Code is invalid. Education Service Code must equal 1, 2, 3, 4, 5, or 6. |
Choose a valid value from the Education Service Code pop-up menu on the Edit Section and/or Course District Information page. |
[S_CA_CRS_X]EdServiceCode [S_CA_SEC_X]EdServiceCode |
|
Language of Instruction Code (Record Type CRSE Only) |
|
|
|
Language of Instruction Code is required if Education Service Code is 1 or Instructional Strategy is 600. |
Verify that either 1 is chosen for the Education Service Code or 600 is chosen for Instructional Strategy Code on the Edit Section and/or Course page. If either value is true, then choose a valid value from the Language of Instruction Code pop-up menu. |
If [S_CA_SEC_X]EdServiceCode=1 or if [S_CA_SEC_X]InstStrategy=600, then [S_CA_SEC_X]LangInstruction cannot be blank. Note: The Sections table fields are interchangeable with Courses table fields. |
|
Language of Instruction Code is invalid. |
Choose a valid value from the Language of Instruction Code pop-up menu on the Edit Section and/or Course page. |
[S_CA_SEC_X]LangInstruction [S_CA_CRS_X]LangInstruction |
|
Instructional Strategy Code (Record Type CRSE Only) |
|
|
|
Instructional Strategy Code cannot be blank if Education Service Code is 1, 2, 3, or 4. |
Choose a valid value from the Instructional Strategy Code pop-up menu on the Edit Section or Course page. |
[S_CA_SEC_X]InstStrategy [S_CA_CRS_X]InstStrategy [S_CA_SEC_X]EdServiceCode [S_CA_CRS_X]EdServiceCode |
|
Instructional Strategy Code is invalid. |
Choose a valid value from the Instructional Strategy Code pop-up menu on the Edit Section and/or Course page. |
[S_CA_SEC_X]InstStrategy [S_CA_CRS_X]InstStrategy |
|
Independent Study Indicator |
|
|
|
Independent Study Indicator cannot be blank. |
Choose a valid Independent Study Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]IndependentStudy [S_CA_SEC_X]IndependentStudy |
|
Independent Study Indicator is invalid. The value must be Y or N. |
Choose a valid Independent Study Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]IndependentStudy [S_CA_SEC_X]IndependentStudy |
|
Distance Learning Indicator |
|
|
|
Distance Learning Indicator cannot be blank. |
Choose a valid Distance/Online Learning Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]DistanceLearning [S_CA_SEC_X]DistanceLearning |
|
Distance Learning Indicator is invalid. The value must be Y or N. |
Choose a valid Distance/Online Learning Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]DistanceLearning [S_CA_SEC_X]DistanceLearning |
|
Multiple Teacher Code (Record Type CRSE Only) |
|
|
|
Multiple Teacher Code is invalid. |
Choose a value from the Multiple Teacher Status pop-up menu on the Edit Section page. |
[S_CA_SEC_X]MultipleTeacherStatus |
|
When Multiple Teacher Code is populated, two or more Course Selection records with the same Class ID must be submitted with different SEIDs (Exception when SEID = 9999999999). |
|
|
|
Education Program Funding Source Code |
|
|
|
Education Program Funding Source Code is invalid. |
Choose a value from the Education Program Funding Source Code pop-up menu on the Edit Section and/or Course page. |
[S_CA_SEC_X]FundingSource [S_CA_CRS_X]FundingSource |
|
CTE Course Section Provider Code |
|
|
|
CTE Course Section Provider Code is invalid. |
Choose a value from the Education CTE Provider Code pop-up menu on the Edit Section and/or Course page. |
[S_CA_SEC_X]CTEProvider [S_CA_CRS_X]CTEProvider |
|
CTE Course Section Provider Code cannot be blank when the State Course Code is <State Course Code>. |
Verify that the Course Content Code 154 on the Edit Course District Information page. If this value is valid, then choose a value for CTE Provider Code on the Edit Section and/or Course page. |
[S_CA_SEC_X]CTEProvider [S_CA_CRS_X]CTEProvider [S_CA_CRS_X]ContentCode=154 |
|
Course Content Area Subcategory Code |
|
|
|
Course Content Area Subcategory Code is invalid. |
Choose a valid Content Area Subcategory Code on the Edit Section and/or Course page. |
[S_CA_CRS_X]Content_Subcategory_Code [S_CA_SEC_X]Content_Subcategory_Code |
|
Course Content Area Subcategory Code cannot be blank when the State Course Code is <State Course Code>. |
There must a valid Content Area Subcategory Code entered if the State Course Code equals 9000, 9051, 9080, 9090, 9130-37, 9155, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400. |
[S_CA_CRS_X]Content_Subcategory_Code [S_CA_SEC_X]Content_Subcategory_Code |
|
Course Content Area Subcategory Code must be blank when the State Course Code is <State Course Code>. |
The Content Area Subcategory Code should not be populated if the State Course Code does not equal 9000, 9051, 9080, 9090, 9130-37, 9155, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400. |
[S_CA_CRS_X]Content_Subcategory_Code [S_CA_SEC_X]Content_Subcategory_Code |
|
Departmentalized Course Standards Grade Level Range Code |
|
|
|
Departmentalized Course Standards Grade Level Range Code cannot be blank. |
Choose a valid Departmentalized Course Standards Grade Level Range Code on the Edit Course page. |
[S_CA_CRS_X]Dept_Grade_Lvl_Range |
|
Departmentalized Course Standards Grade Level Range Code is invalid. |
Choose a valid Departmentalized Course Standards Grade Level Range Code on the Edit Course page. |
[S_CA_CRS_X]Dept_Grade_Lvl_Range |
|
Content Standards Alignment Code |
|
|
|
Content Standards Alignment Code cannot be blank. |
Choose a valid Content Standards Alignment Code on the Edit Course page. |
[S_CA_CRS_X]Content_Std_Alignment |
|
Content Standards Alignment Code is invalid. |
Choose a valid Content Standards Alignment Code on the Edit Course page. |
[S_CA_CRS_X]Content_Std_Alignment |
|
Charter Non-Core, Non-College Prep Course Indicator |
|
|
|
Charter Non-Core, Non-College Prep Course Indicator cannot be blank if the school is identified as a charter. |
Choose a valid Charter Non-Core, Non-College Prep Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]Charter_Prep_Ind [S_CA_SEC_X]Charter_Prep_Ind |
|
Charter Non-Core, Non-College Prep Course Indicator is invalid. The value must be Y or N. |
Choose a valid Charter Non-Core, Non-College Prep Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]Charter_Prep_Ind [S_CA_SEC_X]Charter_Prep_Ind |
|
AP/IB Course Code Cross Reference |
|
|
|
AP/IB Course Code Cross Reference is invalid. |
Choose a valid AP/IB Course Code Cross Reference code on the Edit Section and/or Course page. |
[S_CA_CRS_X]AP_IB_Code_Reference [S_CA_SEC_X]AP_IB_Code_Reference |
|
State Course Code cannot be <State Course Code> when AP/IB Course Code Cross Reference is populated. |
If AP/IB Course Code Cross Reference is populated, then the State Course Code must be 7000-8999 |
[S_CA_CRS_X]AP_IB_Code_Reference [S_CA_SEC_X]AP_IB_Code_Reference |
|
Online Course Instruction Type Code |
|
|
|
Online Course Instruction Type Code is invalid. |
Choose a valid Online Course Instruction Type Code on the Edit Section and/or Course page. |
[S_CA_CRS_X]Online_Instruction_Type [S_CA_SEC_X]Online_Instruction_Type |
|
Online Course Instruction Type Code cannot be blank if Distance Learning Indicator = Y. |
The Online Course Instruction Type Code must e populated if Distance/Online Learning Indicator equals Y. |
[S_CA_CRS_X]Online_Instruction_Type [S_CA_SEC_X]Online_Instruction_Type |
|
Online Course Instruction Type Code must be blank if Distance Learning Indicator = N or null. |
The Online Course Instruction Type Code must be blank if the Distance/Online Learning Indicator is blank or N.
|
[S_CA_CRS_X]Online_Instruction_Type [S_CA_SEC_X]Online_Instruction_Type |
|
Middle School Core Setting Indicator |
|
|
|
Middle School Core Course Indicator cannot be blank if Departmentalized Course Standards Grade Level Range = MID. |
Choose a valid Middle School Core Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]Middle_School_Ind [S_CA_SEC_X]Middle_School_Ind |
|
Local Assignment Option Code |
|
|
|
Local Assignment Option Code is invalid. |
Choose a valid Local Assignment Option Code on the Edit Section and/or Course page. |
[S_CA_CRS_X]Local_Assignment_Opt_Code [S_CA_SEC_X]Local_Assignment_Opt_Code |
|
High Quality CTE Course Indicator |
|
|
|
High Quality CTE Course Indicator is invalid. The value must be Y or N. |
Choose a valid High Quality CTE Course Indicator on the Edit Section and/or Course page. |
[S_CA_CRS_X]High_Quality_CTE_Ind [S_CA_SEC_X]High_Quality_CTE_Ind |
|
High Quality CTE Course Indicator cannot be blank when the State Course Code is <State Course Code>. |
The High Quality CTE Course Indicator must be populated if the State Course Code is between 7000-8999. |
[S_CA_CRS_X]High_Quality_CTE_Ind [S_CA_SEC_X]High_Quality_CTE_Ind |
|
High Quality CTE Course Indicator must be blank when the State Course Code is <State Course Code>. |
The High Quality CTE Course Indicator must be blank if the State Course Code is not between 7000-8999. |
[S_CA_CRS_X]High_Quality_CTE_Ind [S_CA_SEC_X]High_Quality_CTE_Ind |