Course Section File Layout
The following table shows the CALPADS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Course Section State file.
Field # | Field Name | Required? | eSchoolPlus | eSchoolPlus | Where to Find in eSchoolPlus |
|---|---|---|---|---|---|
9.01 | Record Type Code | Y |
|
| Not found in eSchoolPlus. For the Fall Submission, the value will be CRSE and for the End of Year Submission it will be CRSC. |
9.02 | Transaction Type Code | N |
|
| Not found in eSchoolPlus. This field tells CALPADS if the data being sent is an update, deletion or new record. |
9.03 | Local Record ID | N |
|
| Not being sent in files created in eSchoolPlus |
9.04 | Reporting LEA | Y | schd_ms | building | First 7 characters of State Equivalency Code for the building on the master course record being reported. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
9.05 | School of Course Delivery | Y | schd_ms | building | Last 7 characters of State Equivalency Code for the building on the master course record being reported. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
9.06 | Academic Year ID | Y |
|
| From the School Year prompt on CALPADS extract/download page. |
9.07 | CRS-State Course Code | If local Course ID is not mapped to state course code in CALPADS Then Y Else N | ca_v_ms_user | cbed_subj_area | Scheduling > Courses > Course Sections > CA Course—CBEDS Subject Area field. |
9.08 | CRS - Local Course ID | Y | schd_ms | course | Scheduling > Courses > Course Sections > Master Schedule—Course field. |
9.09 | CRS - Course Name | N | schd_ms | description | Scheduling > Courses > Course Sections > Master Schedule—Description field. |
9.10 | CRS - Course Content Code | Y | ca_v_ms_user | cbed_subj_area | Based on Scheduling > Courses > Course Sections > CA Course: State Course Code mapping to CBEDS Subject Area Assignment validation table record with the CTE box selected. |
9.11 | CRS - NCLB Core Course Instructional Level Code | If Record Type Code (9.1) = CRSE, then Y. Otherwise, this field's contents are not collected. | ca_v_ms_user | nclb_core_crs | Scheduling > Courses > Course Sections > CA Course—NCLB Core Course field. Required if field 9.28 is populated, NCLB Core Course Instructional Level Code must be E or S. |
9.12 | CRS-CTE Technical Preparation Course Indicator | N | ca_v_ms_user | cte_prep | Scheduling > Courses > Course Sections > CA Course—CTE Technical Preparation field. |
9.13 | CRS-UC CSU Approved Indicator | N | ca_v_ms_user | if uccsu_app_crs has values in (A - G) then set this flag to a Y else it is N | Scheduling > Courses > Course Sections > CA Course—If UC/CSU Approved Course field has a value from A to G, then this field will be Y, otherwise it will be N. |
9.14 | Course Section ID | Y | schd_ms | section_key | Not seen from the eSchoolPlus software. This field is a unique identifier for the course behind the scenes throughout the software. |
9.15 | Academic term code | Y | ca_v_ms_user | course_term | Scheduling > Courses > Course Sections > CA Course—Course Term field. Will use the CALPADS Equiv Code from the Course Term validation table on the California State Reporting tab. |
9.16 | SEID | Y | reg_staff | staff_state_id | Administration > Registration Setup > Building > Staff—Staff State ID field. |
9.17 | Local Staff ID | Y | schd_ms_session. Or schd_ms_staff | schd_ms_session.Primary-staff_id or schd_ms_staff.staff_id | Scheduling > Courses > Course Sections > Master Schedule—Primary Staff field. |
9.18 | Class ID | If submission type code = E Then Y Else N | schd_ms | Concatenate (Section_key - Course_section) | Section Key cannot be seen from the eSchoolPlus software. Wwe will concatenate this field and the section for the course |
9.19 | Course Section Instructional level Code | N | ca_v_ms_user | crs_level2 | Scheduling > Courses > Course Sections > CA Course—Academic Course Level 2 field. Will use the CALPADS Equiv Code from the Course Term validation table on the California State Reporting tab. |
9.20 | Education Service Code | If Record Type Code = CRSE and Instructional Strategy (9.22) = 400, 500, 600, or 650, then Y; else N | ca_v_ms_user | ed_serv_code | Scheduling > Courses > Course Sections > CA Course—Education Service field. |
9.21 | Language of instruction code | If Record Type Code = CRSE AND (Education Service Code = 1 | ca_v_ms_user | language | Scheduling > Courses > Course Sections > CA Course—Language of Instruction field. |
9.22 | Instructional Strategy Code | If Record Type Code = CRSE and Education Service is not null, then Y. | ca_v_ms_user | instr_strat_code | Scheduling > Courses > Course Sections > CA Course—Instructional Strategy field. |
9.23 | Independent Study Indicator | Y | ca_v_ms_user | indep_study_indic | Scheduling > Courses > Course Sections > CA Course—Independent Study Indicator field. |
9.24 | Distance Learning Indicator | Y | ca_v_ms_user | dist_learn | Scheduling > Courses > Course Sections > CA Course—Distance Learning field. |
9.25 | Multiple Teacher Code | N | ca_v_ms_user | mult_teacher_stat | Scheduling > Courses > Course Sections > CA Course—Multiple Teacher Status field. |
9.26 | Education Program Funding Source Code | N | ca_v_ms_user | ed_prg_fund_src | Scheduling > Courses > Course Sections > CA Course—Education Program Funding field. |
9.27 | CTE Course Section Provider Code | If Course Content Code = 154 or a CTE State Course Code is populated (i.e., 4010-5955) | ca_v_ms_user | crs_sect_prov_code | Scheduling > Courses > Course Sections > CA Course—CTE Course Section field. |
9.28 | HQT Competency Code | If NCLB Core Course Instructional Level Code = E (Elementary Core) or S (Secondary Core)Then Y;Else N | reg_user_staff | page_number = 206 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Highly Qualified, Highly Qualified field |