Student Courses 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 Student Courses State file.
Field # | Field Name | Required? | eSchoolPlus | eSchoolPlus Column | Where to find data in eSchoolPlus |
---|---|---|---|---|---|
10.01 | Record Type Code | Y |
|
| Not found in eSchoolPlus. For the Fall Submission, the value will be SCSE and for the End of Year Submission it will be SCSC. |
10.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. |
10.03 | Local Record ID | N |
|
| Not being sent in files created in eSchoolPlus |
10.04 | Reporting LEA | Y | reg_entry_with | building | First 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
10.05 | School of Course Delivery | Y | reg_v_programs | prog_value where state_code_equiv = 'ca(code)_schl' (see 3.13 for list of codes) | Last 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
10.06 | Academic Year ID | Y |
|
| From the School Year prompt on CALPADS extract/download page. |
10.07 | SSID | Y | reg_personal | state_report_id | Registration > Entry & Reports > Student Demographic > Personal—SSID field. |
10.08 | Local Student ID | Y | reg_entry_with | student_id | Student ID field |
10.09 | Student Legal First Name | Y | reg | first_name | Registration > Entry & Reports > Student Demographic > Registration—First Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes any other characters in this field will be stripped out for the State File. |
10.10 | Student Legal Last Name | Y | reg | last_name | Registration > Entry & Reports > Student Demographic > Registration—Last Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes any other characters in this field will be stripped out for the State File. |
10.11 | Student Birth Date | Y | reg | birthdate | Registration > Entry & Reports > Student Demographic > Registration—Birth Date field. Student Age must be between 0 and 22. If Grade Level is AD, student age must be between 15 and 80. |
10.12 | Student Gender Code | Y | reg | gender | Registration > Entry & Reports > Student Demographic > Registration—Gender field |
10.13 | Local Course ID | Y | schd_ms | course | Scheduling > Courses > Course Sections > Master Schedule—Course field. |
10.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. |
10.15 | Academic Term Code | Y | ca_v_ms_user | course_term/crs_seq_term | Scheduling > Courses > Course Sections > CA Course—Course Term and Course Sequence Term fields. |
10.16 | Student Credits Attempted | If End of Year Submission then Y | mr_stu_hdr | Count(att_credit) | Mark Reporting > Entry & Reports > Student > Report Card Summary—Attempted Credit field. |
10.17 | Student Credits Earned | If End of Year Submission then Y | mr_stu_hdr | Count(earn_credit) | Mark Reporting > Entry & Reports > Student > Report Card Summary—Earned Credit field. |
10.18 | Student Course Final Grade | If End of Year Submission then Y | mr_stu_marks | mark_value | Mark Reporting > Entry & Reports > Student > Report Card Summary—Mark field. |
10.19 | UC/CSU Admission Requirement Code | N | ca_v_ms_user | uccsu_app_crs | Scheduling > Courses > Course Sections > Master Schedule—UC/CSU Approved Course field. |
10.20 | Marking Period Code | If End of Year Submission then Y | reg_mp_weeks | state_code_equiv | Administration > Registration Setup > Calendars > Marking Periods – State Code Equivalent field. |