Skip to main content
Skip table of contents

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

1Transfer in from outside of Washington state
2Transfer in from private-school in Washington state
3Transfer in from home-school in Washington state

C11 - School Choice Code

Code

School Choice

0Not Applicable 
1School Choice (Federal requirement). Parents have selected this school because the student’s school has failed to meet accountability requirements as defined under federal accountability.
2Persistently 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.
3Student 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.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.