Student Career Technical Education 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 Career Technical Education state file.
Field # | Field Name | Required? | eSchoolPlus | eSchoolPlus Column | Where to find data in eSchoolPlus |
---|---|---|---|---|---|
11.01 | Record Type Code | Y |
|
| Not found in eSchoolPlus. This value will always be SCTE. |
11.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. |
11.03 | Local Record ID | N |
|
| Not being sent in files created in eSchoolPlus |
11.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. |
11.05 | School of Attendance | Y | reg_entry_with | building | 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. |
11.06 | Academic Year ID | Y |
|
| From the School Year prompt on CALPADS extract/download page. |
11.07 | SSID | Y | reg_personal | state_report_id | Registration > Entry & Reports > Student Demographic > Personal—SSID field. |
11.08 | Local Student ID | Y | reg_entry_with | student_id | Student ID field |
11.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. |
11.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. |
11.11 | Student Birth Date | Y | reg | birthdate | Registration > Entry & Reports > Student Demographic > Registration—Birth Date field. |
11.12 | Student Gender Code | Y | reg | gender | Registration > Entry & Reports > Student Demographic > Registration—Gender field |
11.13 | CTE Pathway Code | Y | reg_user | field_value where page_number = 210 and field_number = 1 | Registration > Entry & Reports > Student District Defined > CA CTE Completer– CTE Pathway field. |
11.14 | CTE Pathway Completion Academic Year ID | Y | reg_user | field_value where page_number = 210 and field_number = 4 | Registration > Entry & Reports > Student District Defined > CA CTE Completer– Academic Year ID field. |