Course Data Details (CRSE and CRSC)

#

Field Name

Code Set

Required

Validation/Business Rule

Course Information: Editing Course level data elements will affect all related Course Sections

1       

Academic Year ID

N/A

Y

N/A

2       

Submission Type

Enrollment or Completion

Y

N/A

3       

Reporting LEA

Education Service Identifier

Y

N/A

4       

School of Course Delivery

Education Service Identifier

Y

N/A

5       

CRS - State Course Code

Course Group State

Required If Local Course ID is not mapped to State Course Code in CALPADS

Field must meet the specified CALPADS’ data validations and rules requirements. State Course Code is concatenated with State Course Name to create dropdown (sort ascending sequence by State Course Code).

6       

CRS - Local Course ID

NA

Y

Field must meet the specified CALPADS’ data validations and rules requirements.

7       

*CRS - Course Name

N/A

Y

All records with the same Academic Year, School of Delivery and CRS-Local Course ID must have identical CRS-Course Names.

8       

CRS - UC CSU Approved Indicator

Yes; No

Y

1) If the State Course Code is considered by CDE as likely to meet UC and CSU requirements (per the Master Course Combos in CALPADS Valid Code Combinations), then this field should equal “Y”.

2) All records with the same Academic Year, School of Delivery and CRS-Local Course ID must have identical CRS-UC CSU Approved Indicators.

9       

CRS - CTE  Postsecondary Articulated Course Indicator

Not Applicable, Yes; No

N

“Y” indicates that this is a Postsecondary Articulated Course; “N” or blank indicates that it is not.

10    

CRS – Departmentalized Course Standards Grade Level Range Code

Departmentalized Course Standards Grade Level Range

Y

Must be a valid combination in the CrsGrpSt – StndsGrdLvlRange combinations in the CALPADS Valid Code Combinations.

11    

CRS – Content Standards Alignment Code 

Content Standards Alignment

Y

1) If CRS – Departmentalized Course Standards Grade Level Range Code = NOT – Not Applicable, then CRS – Content Standards Alignment Code must = 3 - Not Content Standards-Aligned or Not Applicable.

2) If CRS – Departmentalized Course Standards Grade Level Range Code is not = NOT – Not Applicable, then CRS – Content Standards Alignment Code cannot = 3 - Not Content Standards-Aligned or Not Applicable.

#

Field Name

Code Set

Required

Validation/Business Rule

Course Section Information

12

Course Section ID

N/A

Y

Field must meet the specified CALPADS’ data validations and rules requirements.

13

Academic Term Code

Academic Term

Y

N/A

14

Class ID

N/A

Required If Record Type Code = CRSE

Field must meet the specified CALPADS’ data validations and rules requirements.

15

SEID

N/A

Y

1) SEID must be a valid SEID in the CCTC file or SEID equal 9999999999

2) Staff Demographic record should exist for the same SEID in the Course Section Record during upload/input except when the SEID equals 9999999999

SEID equal “9999999999”  should only be submitted in the following conditions:

• Charter School teacher teaching non-core classes as defined by the charter
• Course Section taught by a teacher that is not an employee of the LEA (i.e. ROC/P teacher, College Professor, COE Special Education teacher, Distance Learning teacher, or private contractor)

SEID not yet provided by CCTC

16

Staff Name

N/A

N

If a Staff Demographic Record exists, the Staff Name will be populated.

17

Local Staff ID

N/A

N

If a Staff Demographic Record exists, the Local Staff ID will be populated.  If not, the user must input the Local Staff ID. If multiple teachers are associated with the section, both Local Staff IDs will display

18

Independent Study Indicator

Yes; No

Y

Field must meet the specified CALPADS’ data validations and rules requirements.

19

Distance Learning Indicator

Yes; No

Y

Field must meet the specified CALPADS’ data validations and rules requirements.

20

Education Service Code

Education Service English Learners

N

N/A

21

Course Instructional Level Code

Course Non Standard Instructional Level

N

N/A

22

Language of Instruction Code

Language

Required, If Education Service Code = 1

Field must meet the specified CALPADS’ data validations and rules requirements.

23

Instructional Strategy Code

Instructional Strategy

N

REMINDER: Instructional Strategy code 700 should ONLY be used for courses specifically designed for students with disabilities where all students enrolled are students with disabilities

24

Multiple Teacher Code

Multiple Teacher Instruction Strategy Category

N

If Record Type Code = CRSE

AND If Multiple Teacher Code is populated
Then two or more Course Section records with the same Class ID must be submitted with different SEIDs (Exception when SEID = 9999999999)

25

Education Program Funding Source Code

Education Program Funding Source

N

n/a

26

CTE Course Section Provider Code

Career Technical Education Funding Provider Category

Required If CTE State Course Code is populated (i.e. 7000-8999)

n/a

27

Course Content Area Subcategory Code  

Course Content Area Subcategory

Required If State Course Code = 9000, 9051, 9080, 9090, 9130-37, 9155, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400

1) If populated, must be a valid combination per the CrsGrpSt - ContentSubctgy combinations in the CALPADS Valid Code Combinations.

2) If State Course Code <> 9000, 9002, 9051, 9080, 9090, 9130-37, 9155, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400 then this field must be blank

28

Charter Non-Core, Non-College Prep Course Indicator

Not Applicable, Yes, No

If the school is identified as a charter school, Charter Non-Core, Non-College Prep Course Indicator must = Y or N

n/a

29

AP/IB Course Code Cross Reference

AP/IB Course Code Cross Reference

N

If populated, CRS - State Course Code must equal a CTE State Course Code 7000-8999.

If populated, must be equal to an active course identified as an AP or IB course in the AP or IB columns in the Course Group Master Combos in the CALPADS Valid Code Combinations

30

Online Course Instruction Type Code

Online Course Instruction Type

Required If Distance Learning Indicator = Y,

If Distance Learning Indicator = N or null, then this field must be blank.

31

Middle School Core Course Indicator

Not Applicable, Yes, No

If Departmentalized Course Standards Grade Level Range = MID (Middle Grades 5-8), Middle School Core Course Indicator must = Y or N

n/a

32

High Quality CTE Course Indicator

Not Applicable, Yes, No

If the CRS-State Course Code associated with the Course Section is in range of 7000-8999, High Quality CTE Course Indicator must = Y or N

If the CRS-State Course Code associated with the Course Section is not in range of 7000-8999, High Quality CTE Course Indicator must be blank. 

33

Local Assignment Option Code

Local Assignment Option

N

n/a