Skip to main content
Skip table of contents

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.

Back to Top

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:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

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:

  • The Selected [number] Students Only – Run the report for students in the current selection.

  • All Students (Default) – Run the report for all students in the current school or district that meet the selection criteria.

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:

  • Run Now (default)

  • Schedule

Output File Name

OR_SSID_[SchoolID/DistrictNumber]_[Timestamp].csv

Destination

The report defaults to the Reporting Queue.

Back to Top

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

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.