Skip to main content
Skip table of contents

Freshman On Track File Layout

Data Element Name

Field Length

Req'd

Zero Padded

Field position

eSchoolPlus Table.Column

Download Table.Column

Where in eSchoolPlus?

Secure Student Identifier (SSID)

10

Y

Y

1 - 10

reg_personal.state_report_id

or_ssid_download.ssid


District/Local Student Identifier

10

N

N

11 - 20

reg.student_id

or_ssid_download.student_id


Resident District Institution Identifier

10

Y

Y

21 - 30

reg.home_district

or_ssid_download.resi_district_id


Resident School Institution Identifier

10

Y

Y

31 - 40

reg.state_res_bldg

or_ssid_download.resi_school_id


Attending District Institution Identifier

10

Y

Y

41 - 50

reg.attending_district

or_ssid_download.atten_district_id


Attending School Institution Identifier

10

Y

Y

51 - 60

reg.building

or_ssid_download.atten_school_id


Institution Filler

20

N

N

61 - 80

.

.


Legal Last Name

50

Y

N

81 - 130

reg.last_name

or_ssid_download.legal_last_name


Legal First Name

40

Y

N

131 - 170

reg.first_name

or_ssid_download.legal_first_name


Legal Middle Name

40

N

N

171 - 210

reg.middle_name

or_ssid_download.legal_middle_name


Generation Code

4

N

N

211 - 214

reg.generation

or_ssid_download.generation_code


Preferred Last Name

50

N

N

215 - 264

reg.last_name.

or_ssid_download. pref_last_name


Preferred First Name

40

N

N

265 - 304

reg.nickname

or_ssid_download.pref_first_name


Preferred Middle Name

40

N

N

305 - 344

reg.middle_name.

or_ssid_download.pref_middle_name


Date of Birth

8

Y

Y

345 - 352

reg.birthdate

or_ssid_download.birthdate


Gender Code

1

Y

N

353 - 353

reg.gender

or_ssid_download.gender


Hispanic/Latino Ethnic Flag

1

Y

N

354 - 354

reg_hispanic Currently implemented for only WA has to be done for OR by start of school.hispanic_code

or_ssid_download.hispanic


American Indian/Alaskan Native Race Flag

1

Y

N

355 - 355

reg_ethnicity.ethnic_code converted to its state code.

or_ssid_download.ameri_ind_alaskan


Asian Race Flag

1

Y

N

356 - 356

reg_ethnicity.ethnic_code converted to its state code.

or_ssid_download.asian


African American Race Flag

1

Y

N

357 - 357

reg_ethnicity.ethnic_code converted to its state code.

or_ssid_download.african_american


White Race Flag

1

Y

N

358 - 358

reg_ethnicity.ethnic_code converted to its state code.

or_ssid_download.white


Native Hawaiian/ Other Pacific Islander Race Flag

1

N

N

359 - 359

reg_ethnicity.ethnic_code converted to its state code.

or_ssid_download.pacific_isld


Race Filler

1

Y

N

360 - 360




Language of Origin Code

4

Y

Y

361 - 364

reg.language

or_ssid_download.language_of_origin


Partial Social Security Number

4

N

Y

365 - 368

reg_personal.ssn

or_ssid_download.ssn


Enrolled Grade Code

2

Y

Y

369 - 370

reg_entry_with.grade

or_ssid_download.grade


Street Address

45

N

N

371 - 415

reg_contact.

or_ssid_download.street_address


City

20

N

N

416 - 435

reg_contact.

or_ssid_download.city


Zip Code

5

N

Y

436 - 440

reg_contact.

or_ssid_download.zipcode


Zip Plus Four Code

4

N

Y

441 - 444

reg_contact.

or_ssid_download.zip_plus


Resident County Code

2

Y

Y

445 - 446

reg.res_county_code

or_ssid_download.resident_county


Phone Number

10

N

N

447 - 456

reg_contact.

or_ssid_download.phone_number


Teacher Filler

50

N

Y

457 - 506

N/A

N/A

Blank

High School Entry Cohort School Year

4

N

Y

507 - 510

reg_academic.Expected Graduation Year / Ninth Grade Year   

or_ssid_download.high_school_entry


Student Filler

16

N

N

511 - 526




Economically Disadvantaged Flag

1

N

N

527 - 527

reg_programs.program_value where state_code_equiv=
ORCONDIS

or_ssid_download.economic_disadv


Title I Flag

1

N

N

528 - 528

reg_programs.program_value where state_code_equiv=
ORTITLE1

or_ssid_download.title1


Special Education Flag

1

Y

N

529 - 529

reg_programs.program_value where state_code_equiv=
ORSPED

or_ssid_download.special_ed


Section 504 Flag

1

N

N

530 - 530

reg_programs.program_value where state_code_equiv=
ORPLANE

or_ssid_download.section_504


Migrant Education Flag

1

Y

N

531 - 531

reg_programs.program_value where state_code_equiv=
ORMIG

or_ssid_download.migrant_ed


Indian Education Flag

1

Y

N

532 - 532

reg_programs.program_value where state_code_equiv=
ORINED

or_ssid_download.indian_ed


Limited English Proficiency Flag

(English Learner)

1

N

N

533 - 533

reg_programs.program_value where state_code_equiv=
ORLEPLEP

or_ssid_download.lep


Distance Learning Flag

1

N

N

534 - 534

reg_programs.program_value where state_code_equiv=
ORLER

or_ssid_download.dist_learn


Homeschooling Flag

1

N

N

535 - 535

reg_programs.program_value where state_code_equiv=
ORLHSC

or_ssid_download.home_school


Potentially Talented and Gifted Flag

(No longer used - Null value)

1

N

N

536 – 536

reg_programs.program_value where state_code_equiv=
ORTAGPT

or_tag_down.potential_tag


Intellectually Gifted Flag

(No longer used - Null value)

1

N

N

537 – 537

reg_programs.program_value
where state_code_equiv=
ORTAGIG

or_tag_down.intellect_gifted


Academically Talented Reading Flag

(No longer used - Null value)

1

N

N

538 – 538

reg_programs.program_value
where state_code_equiv=
ORTAGTR

or_tag_down.acad_talent_read


Academically Talented Math Flag

(No longer used - Null value)

1

N

N

539 – 539

reg_programs.program_value
where state_code_equiv=
ORTAGTM

or_tag_down.acad_talent_math


Creative Ability Flag

(No longer used - Null value)

1

N

N

540 – 540

reg_programs.program_value
where state_code_equiv=
ORTAGCA

or_tag_down.creative_ability


Leadership Ability Flag

(No longer used - Null value)

1

N

N

541 – 541

reg_programs.program_value
where state_code_equiv=
ORTAGLA

or_tag_down.leadership_ability


Visual and Performing Arts Ability Flag

(No longer used - Null value)

1

N

N

542 - 542

reg_programs.program_value
where state_code_equiv=
ORTAVPA

or_tag_down.visual_perf_arts


Transition Program Flag

1

N

N

543 - 543

reg_programs.program_value where state_code_equiv=
ORLTRP

or_ssid_download.transition_program


Alternative Education Program Flag

1

N

N

544 - 544

reg_programs.program_value where state_code_equiv= 
 ORLAEP

or_ssid_download.alt_ed


Amer-Indian Trbl Mmbrshp Code

3

N

N

545 - 547

reg_user.screen_number = 700 and field_number=22

or_ssid_download.AMER_IND_TRBMEMBCD

Registration > Entry & Reports > Student District Defined > OR Demographics

Amer-Indian Trbl Enrlmnt Nmbr

(No longer used - Null value)

4

N

Y

548 - 551

Reg_user.screen_number = 700 and field_number=23

or_ssid_download. AMER_IND_TRBENRLNO

Registration > Entry & Reports > Student District Defined > OR Demographics

Talented and Gifted Flag1NN552 - 552


Additional Language Code4NY553 - 556


Demographic Filler

11

N

N

557 - 567

N/A

N/A

Blank

 

JavaScript errors detected

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

If this problem persists, please contact our support.