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 Table	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 OR reg_programs	Building OR program_value	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 Populate whenever the Entry Code has a State Code Equiv of 1, 2, or 3 in the Registration Entries validation table.

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.