Student Absence 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 Absence State file.
Field # | Field Name | Required? | CALPADS Updatable? | eSchoolPlus | eSchoolPlus Column | Where to find data in eSchoolPlus |
---|---|---|---|---|---|---|
13.01 | Record Type Code | Y | Always STAS | |||
13.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. | |||
13.03 | Local Record ID | N | Y | Not being sent in files created in eSchoolPlus. | ||
13.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, selecting a building and clicking on the Preferences tab. | |
13.05 | School of Attendance | Y | 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. |
13.06 | Academic Year ID | Y | Y | From the School Year prompt on CALPADS extract/state file page. | ||
13.07 | SSID | Y | reg_personal | state_report_id | Registration > Entry & Reports > Student Demographic > Personal—SSID field. | |
13.08 | Local Student ID | Y | reg_entry_with | student_id | Student ID field | |
13.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. | |
13.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. | |
13.11 | Student Birth Date | Y | reg | birthdate | Registration > Entry & Reports > Student Demographic > Registration—Birth Date field. | |
13.12 | Student Gender Code | Y | reg | gender | Registration > Entry & Reports > Student Demographic > Registration—Gender field | |
13.13 | Student Absence Summary Data Collection Exemption Indicator | N | System-calculated | System-calculated | Populated with Y if the student meets one of the following criteria:
| |
13.14 | Hourly Attendance School Type Indicator | If 13.13 is null, then Y. | Reported based on reg_user_building where page_number = 200 | Reported based on field_value where field_number = 13 | Administration > Registration Setup > Building District Defined > CA Institution: Continuation School | |
13.15 | Expected Attendance Days | If 13.13 is null, then Y. | System-calculated | System-calculated | The extract totals the membership attendance days on which the student is enrolled for the School of Attendance. | |
13.16 | Days Attended In-Person | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.17 | Days Absent Out-of-School Suspension | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.18 | Days in Attendance In-School Suspension | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.19 | Days Absent In-Person Excused Non-Suspension | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.20 | Days Absent In-Person Unexcused Non-Suspension | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.21 | Non-ADA Generating Independent Study Days | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.22 | ADA Generating Independent Study Days | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
| |
13.23 | Period-by-Period Attendance Method Indicator | If 13.13 is null, then Y. | System-calculated | System-calculated | Refer to the section Calculating Student Absence File Fields – Continuation Building for information on hourly attendance buildings.
|
Additional Information
If the Period Type is P-Period, the Period-by-Period Attendance Method Indicator calculates the ADA-Generating Independent Study Days in the Student Absence download.
The California Independent Study Attendance Collection (ISAC) option to run Student Absence monthly is added under the Date Submission field on the CA Create CALPADS Extract/State Files page.