SSID Student File
Contents
Introduction
Generates the SSID file in a consolidated student file format. The report scans for currently active students or for students active on a date specified at run time. One row is exported for each student. The report may be run at the district or school level.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] and [ReEnrollments] tables that occurred during the current school year, based on the following criteria:
When a selection of students is provided to the report then that selection is used.
When a start date and end date are provided to the report then students with enrollments within the date range are selection for report inclusion.
The Start Date must be on or before the last day of the current term.
The End Date must be on or after the last day of the current term.
The Start Date must be before the End Date.
The Report Run Date must be between the student enrollment start and end Date.
Report Input
To generate the Consolidated SSID Student File Collection report, do the following:
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools* | Choose one of the following:
Note: The All Schools option is only available when running the report from the District Office. |
Students to Include* | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Report Start Date* | Enter a date in the format mm/dd/yyyy. |
Scheduling | Choose a time to run the report from the following options:
|
Output File Name | OR_SSID_[SchoolID/DistrictNumber]_[Timestamp].csv |
Destination | The report defaults to the Reporting Queue. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Data Type | Field Length |
1 | Secure Student Identifier (SSID) | ODE assigned Secure Student Identifier (SSID) with a trailing check digit. | [Students]State_StudentNumber | int | 10 |
2 | District/Local Student Identifier | Identifier, assigned by the district, used to uniquely identify the student. | [Students]Student_Number | varchar | 10 |
3 | Resident District Institution Identifier | ODE assigned Institution Identifier for the Resident District. The District responsible for the education of the student and also is the basis on which the State School Fund, the Common School Fund, and the County School Fund are distributed to local districts. Special provisions apply as defined in ORS 339.133, 338.155(1), and 338.165. | [S_OR_STU_X]ResdDistInstID [S_OR_REN_X]ResdDistInstID | int | 10 |
4 | Resident School Institution Identifier | ODE assigned Institution Identifier for the Resident School. The School responsible for the education of the student and also is the basis on which the State School Fund, the Common School Fund, and the County School Fund are distributed to local districts. Special provisions apply as defined in ORS 339.133, 338.155(1), and 338.165. | [S_OR_STU_X]ResdSchlInstID [S_OR_REN_X]ResdSchlInstID | int | 10 |
5 | Attending District Institution Identifier | ODE assigned Institution Identifier for the Attending District. The District where the student is receiving instruction and where state assessments are administered. | [S_OR_STU_X]AttndDistInstID [S_OR_REN_X]AttndDistInstID | int | 10 |
6 | Attending School Institution Identifier | ODE assigned Institution Identifier for the Attending School. The School where the student is receiving instruction and where state assessments are administered. | [S_OR_STU_X]AttndSchlInstID [S_OR_REN_X]AttndSchlInstID | int | 10 |
7 | Institution Filler | Reserved for future use. | [S_OR_STU_X]InstFill [S_OR_REN_X]InstFill | varchar | 20 |
8 | Legal Last Name | Legal last name of the student. | [Students]Last_Name | varchar | 50 |
9 | Legal First Name | Legal first name of the student. | [Students]First_Name | varchar | 40 |
10 | Legal Middle Name | Legal middle name of the student. | [Students]Middle_Name | varchar | 40 |
11 | Generation Code | Name suffix of the student (i.e. Jr., II, III). | [S_OR_STU_X]GenerationCd | varchar | 4 |
12 | Preferred Last Name | Preferred last name of the student. | [S_OR_STU_X]Preferred_LNm | varchar | 50 |
13 | Preferred First Name | Preferred first name of the student. | [S_OR_STU_X]Preferred_FNm | varchar | 40 |
14 | Preferred Middle Name | Preferred middle name of the student. | [S_OR_STU_X]PreferredMNm | varchar | 40 |
15 | Date of Birth | Date the student was born. Format=mmddyyyy | [Students]DOB | datetime | 8 |
16 | Gender Code | Code indicating the gender of the student. | [Students]Gender | char | 1 |
17 | Hispanic/Latino Ethnic Flag | Indicates a student of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. The term, “Spanish origin,” can be used in addition to “Hispanic or Latino.” | [Students]FedEthnicity | char | 1 |
18 | American Indian/Alaskan Native Race Flag | Indicates a student having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment. | [StudentRace]RaceCd When [StudentRace]RaceCd = I | char | 1 |
19 | Asian Race Flag | Indicates a student having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. | [StudentRace]RaceCd When [StudentRace]RaceCd=A | char | 1 |
20 | African American Race Flag | Indicates a student having origins in any of the black racial groups of Africa. | [StudentRace]RaceCd When [StudentRace]RaceCd=B | char | 1 |
21 | White Race Flag | Indicates a student having origins in any of the original peoples of Europe, the Middle East, or North Africa. | [StudentRace]RaceCd When [StudentRace]RaceCd=W | char | 1 |
22 | Native Hawaiian/Other Pacific Islander Race Flag | Indicates a student having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. | [StudentRace]RaceCd When [StudentRace]RaceCd=P | char | 1 |
23 | Race Filler | Reserved for future use. | N/A | char | 1 |
24 | Language of Origin Code | Code indicating the first language spoken in an individual's home in their early or earliest childhood. One's first language or native language. | [StudentCoreFields]PrimaryLanguage | varchar | 4 |
25 | Partial Social Security Number | Last four (4) digits of the Social Security Number of the student. | [Students]SSN | varchar | 4 |
26 | Enrolled Grade Code | Code indicating the enrolled grade level of the student; or a grade level assigned to an ungraded student based on student age. | [S_OR_STU_X]EnrlGrdCd [S_OR_REN_X]EnrlGrdCd [Students]Grade_Level [ReEnrollments]Grade_Level | char | 2 |
27 | Street Address | Street address of the student's primary residence. | [Students]Street | varchar | 45 |
28 | City | City where the student's primary residence is located. | [Students]City | varchar | 20 |
29 | Zip Code | First five digits of the postal zip code of the student's primary residence. | [Students]Zip | varchar | 5 |
30 | Zip Plus Four Code | Plus four portion of the postal zip code of the student's primary residence. | [Students]Zip | varchar | 4 |
31 | Resident County Code | Code indicating the county of legal residence of the student's parent or legal guardian or the county of residence of an emancipated minor student. Note: If unspecified, the district county code from the District Info page is reported. | [S_OR_STU_X]ResdCnty [S_OR_REN_X]ResdCnty | varchar | 2 |
32 | Phone Number | Phone Number (Area Code, Prefix, and Exchange) of the student. | [Students]Home_Phone | varchar | 10 |
33 | Teacher Filler | Reserved for future use. | [S_OR_STU_X]TchrFill [S_OR_REN_X]TchrFill | varchar | 50 |
34 | High School Entry Cohort School Year | School year the student entered high school in the format XXYY. (i.e. 1011 for the 2010-2011 school year). Indicates the ninth grade cohort group associated with the student. | [S_OR_STU_X]HSEntrySchlYr | varchar | 4 |
35 | Student Filler | Reserved for future use. | [S_OR_STU_X]Fill [S_OR_REN_X]Fill | varchar | 16 |
36 | Economically Disadvantaged Flag | Indicates student participation in a Free or Reduced Lunch program. | [S_OR_STU_X]EconDsvntg [S_OR_REN_X]EconDsvntg | char | 1 |
37 | Title I Flag | Indicates that the student is served by a targeted assistance program (TAS) and not the complete student population in Title I designated schools (SWP). This value is based on the student’s Special Program enrollments; otherwise the value is based on the checkboxes from the Programs and Participations page. | [S_OR_STU_X]Title1Fg [S_OR_REN_X]Title1Fg [SpEnrollments]ProgramID [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date | char | 1 |
38 | Special Education Flag | Indicates student participation in an Individualized Education Plan (IEP/IFSP). This value is based on the student’s Special Program enrollments; otherwise the value is based on the checkboxes from the Programs and Participations page. | [S_OR_STU_X]SpEdFg [S_OR_REN_X]SpEdFg [SpEnrollments]ProgramID [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date | char | 1 |
39 | Section 504 Flag | Indicates student eligibility for Section 504 services. This value is based on the student’s Special Program enrollments; otherwise the value is based on the checkboxes from the Programs and Participations page. | [S_OR_STU_X]Sect504Fg [S_OR_REN_X]Sect504Fg [SpEnrollments]ProgramID [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date | char | 1 |
40 | Migrant Education Flag | Indicates student participation in a program designed to assure that migratory children receive full and appropriate opportunity to meet the state academic content and student academic achievement standards. This value is based on the student’s Special Program enrollments; otherwise the value is based on the checkboxes from the Programs and Participations page. | [S_OR_STU_X]MigrntEdFg [S_OR_REN_X]MigrntEdFg [SpEnrollments]ProgramID [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date | char | 1 |
41 | Indian Education Flag | Indicates student participation in a program designed to meet the unique educational and culturally related academic needs of American Indians. This value is based on the student’s Special Program enrollments; otherwise the value is based on the checkboxes from the Programs and Participations page. | [S_OR_STU_X]IndianEdFg [S_OR_REN_X]IndianEdFg [SpEnrollments]ProgramID [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date | char | 1 |
42 | English Learner Flag | Indicates a child who is an English Learner. This value is based on the student’s Special Program enrollments; otherwise the value is based on the checkboxes from the Programs and Participations page. | [S_OR_STU_X]ELFg [S_OR_REN_X]ELFg [SpEnrollments]ProgramID [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date | char | 1 |
43 | Distance Learning Flag | Indicates student participation in a distance learning program or a program that includes online coursework. | [S_OR_STU_X]DstncLrnFg [S_OR_REN_X]DstncLrnFg | char | 1 |
44 | Homeschooling Flag | Indicates that the student is registered to receive home school instruction. | [S_OR_STU_X]HomeSchlFg [S_OR_REN_X]HomeSchlFg | char | 1 |
45 | Transition Program Flag | Indicates a Special Education student of high school or post high school age (up through the age of 21) who has not graduated with a regular diploma and are not working towards a regular or modified diploma. | [S_OR_STU_X]TrnstnProgFg [S_OR_REN_X]TrnstnProgFg | char | 1 |
46 | Alternative Education Program Flag | Indicates that the student has been placed by the district in an Alternative Education Program(s) based on criteria described in OAR 581-022-1350 (5). | [S_OR_STU_X]AltEdProgFg [S_OR_REN_X]AltEdProgFg | char | 1 |
47 | American Indian Tribal Membership Code | Indicates whether the student is affiliated with an American Indian tribe. | [S_OR_STU_X]AmerIndianTrbMbrshpCd | char | 3 |
48 | Talented and Gifted Flag | Indicates that the student is identified as Academically Talented or Intellectually Gifted as determined by school district policy. | [S_OR_STU_X]TAGFg | boolean | |
49 | Additional Language Code | This is an additional language field for students who have more than one language of origin. | [S_OR_STU_X]AddnLangCd | char | 4 |
50 | Demographic Filler | Reserved for future use. | [S_OR_STU_X]DemogFill [S_OR_REN_X]DemogFill | varchar | 18 |