School Student File (C)
The following table shows the CEDARS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the School Student File (C) State file.
Field # | Field Name | Required? | eSchoolPlus | eSchoolPlus Column | Where to find data in eSchoolPlus |
---|---|---|---|---|---|
C01 | School Year | Yes | From the School Year prompt on page | ||
C02 | Serving County District Code | Yes | reg_district | state_code_equiv | Administration > General Setup > District > District (cannot be updated through the software) |
C03 | District Student Code | Yes | reg | student_id | Student ID field |
C04 | SSID | Yes | reg_personal | state_report_id | Registration > Entry & Reports > Student Demographic > Personal: State ID field. |
C05 | Location ID | Yes | Reg_entry_with | Building | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building OR if there is a value in the Location ID value line on the District Student program page. |
C06 | Date Student Enrolled in School | Yes | reg_entry_with | entry_date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Entry Date |
C07 | No longer collected | N/A | N/A | N/A | N/A |
C08 | School Exit Date | Conditional. Must be greater than or equal to the data in Element C06. | reg_entry_with | withdrawal_date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Date |
C09 | School Withdrawal Code | Conditional. If date entered in C08, this value may not be left blank. | reg_entry_with | withdrawal_code | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Code field |
C10 | Is this the School that is Primarily Responsible for the student? | Yes | reg_programs | Program_value | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Primary School field |
C11 | School Choice Code | Yes | reg_programs | Program_value | Registration > Entry & Reports > Student District Defined > WA Student Information: School Choice hyperlink to Value field |
C12 | Cumulative Days Present this Enrollment Period | Yes | Membership - Absence = Days present | Calculated by subtracting unexcused and excused student days absent from membership days. Can verify by going to Attendance > All > Student > Day Totals. The system will use the Unexcused and Excused Attendance Codes that you enter on the CEDARS Download/Extract page. The value in this field will be larger for most students with each subsequent submission since it is a cumulative total, not just a total for the submission period. | |
C13 | No longer an active data element | N/A | N/A | N/A | N/A |
C14 | Confirmed Transfer In | Required if student was last in school outside WA state, a private school within the state, or a home-school within the state. | Reg_entry_with converted to regtb_entry | Entry_code converted to state_code_equiv | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > click School Year link > Enrollment panel: Entry Code |
C14 - Confirmed Transfer In
Code | Confirmed Transfer In Type |
---|---|
1 | Transfer in from outside of Washington state |
2 | Transfer in from private-school in Washington state |
3 | Transfer in from home-school in Washington state |
C11 - School Choice Code
Code | School Choice |
---|---|
0 | Not Applicable |
1 | School Choice (Federal requirement). Parents have selected this school because the student’s school has failed to meet accountability requirements as defined under federal accountability. |
2 | Persistently Dangerous Schools (Federal requirement). Parents have selected this school because the student’s school of geographic residence has been identified as “Persistently Dangerous” as defined under federal accountability. |
3 | Student Enrollment Options (State Law). Parents have selected this district and school because the student/parents choose to have the student attend school in another district based on the provisions of RCW 28A.225.310. |