SSID File Layout
Data Element Name | Field Length | Required | Zero Padded | Field position | eSchoolPlus Table.Column | Download Table.Column | Where in eSchoolPlus? |
---|---|---|---|---|---|---|---|
Secure Student Identifier (SSID) | 10 | Y | Y | 1 - 10 | reg_personal. | 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 | |
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. | or_ssid_download.economic_disadv | Registration > Entry & Reports > Student Demographic > Programs > Meal Status - Programs: ELIGIBLE |
Title I Flag | 1 | N | N | 528 - 528 | reg_programs. | or_ssid_download.title1 | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: Title 1 |
Special Education Flag | 1 | Y | N | 529 - 529 | reg_programs. | or_ssid_download.special_ed | Registration > Entry & Reports > Student Demographic > Programs > OR Special Education - Programs: Special Education |
Section 504 Flag | 1 | N | N | 530 - 530 | reg_programs. | or_ssid_download.section_504 | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: 504 Plan (Eligibility) |
Migrant Education Flag | 1 | Y | N | 531 - 531 | reg_programs. | or_ssid_download.migrant_ed | Registration > Entry & Reports > Student Demographic > Programs > Migrant - Programs: Migrant Education |
Indian Education Flag | 1 | Y | N | 532 - 532 | reg_programs. | or_ssid_download.indian_ed | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: Indian Education Flag |
Limited English Proficiency Flag | 1 | N | N | 533 - 533 | reg_programs. | or_ssid_download.lep | Registration > Entry & Reports > Student Demographic > Programs > OR LEP - Programs: Limited English Proficiency |
Distance Learning Flag | 1 | N | N | 534 - 534 | reg_programs. | or_ssid_download.dist_learn | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: Distance Learning |
Homeschooling Flag | 1 | N | N | 535 - 535 | reg_programs. | or_ssid_download.home_school | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: Home Schooling |
Transition Program Flag | 1 | N | N | 536 - 536 | reg_programs. | or_ssid_download.transition_program | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: Transition Program |
Alternative Education Program Flag | 1 | N | N | 537 - 537 | reg_programs. | or_ssid_download.alt_ed | Registration > Entry & Reports > Student Demographic > Programs > OR Demographics - Programs: Alternative Education Program |
Amer-Indian Trbl Mmbrshp Code | 3 | N | Y | 538 - 540 | 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 Mmbrshp Code |
Talented and Gifted Flag Note: This field is retrieved from the TAG File Layout. | 1 | Y | N | 541 - 541 | reg_user.screen_number = 701 and field_number=8 | or_tag_down.TAG_FLAG | Registration > Entry & Reports > Student District Defined > OR Talented and Gifted: Talented and Gifted Flag |
Additional Language Code | 4 | N | Y | 542 - 545 | reg.native_language | or_ssid_download. ADD_LANG_CODE | Registration > Entry & Reports > Student Demographic > Registration: Native Language |
Demographic Filler | 11 | N | N | 546 - 556 | N/A | N/A | Blank |