Unique Staff Identifier Extract (Oregon)

Tool Search: SSID/USID/IUID Extracts

The Unique Staff Identifier (USID) File provides a way to request a Unique Staff Identifiers (SSID) for staff who have never had a USID record assigned to them by the state of Oregon. This file generates for the entire district for the School Year in the Campus toolbar. 

This is a two-fold process: 

  1. Generate the Unique Staff Identifier Extract to find the staff who DO NOT already have USIDs. This is then sent to the state to request the IDs.
  2. Once the USIDs have been assigned, use the Unique Staff Identifier Import to assign the USIDs to the staff.

Screenshot of the USID Extract, located at Reporting, OR State Reporting, SSID/USID/IUID ExtractsUnique Staff Identifier (USID) Extract

Read - Access and generate the Consolidated SSID/USID/IUID Extracts.
Write - N/A
Add - N/A
Delete - N/A

For more information about Tool Rights and how they function, see the Tool Rights article.

Report Logic

A record reports for each unique staff person where the Staff State ID is blank AND where the staff person has at least ONE active District Employment record at the time of report generation for the School Year selected in the Campus toolbar.

Report Editor

FieldDescription
ExtractIndicates which report is being generated. For this instance, choose Unique Staff Identifier (USID).
File TypeDetermines which students report in the extract. 
  • Choose Web Submission (New Staff - USID Request) for staff who DO NOT have an existing USID.
  • Choose Record Maintenance (Returning Students - Update Information) for students who DO have an existing SSID.
FormatIndicates how the report generates. Options include CSV (state format), XML, and HTML 
Apply All ExcludesWhen marked, staff who are marked as  one of the following are included in the report: 
  • Exclude is marked on the District Assignment record.
  • Calendar is marked as Exclude.

When NOT marked, staff marked as Exclude are NOT included in the report.

Report GenerationTo generate the report immediately, use the Generate Extract option. To choose when the report generates, use the Submit to Batch option. Submit to Batch is useful when generating the report for several calendars or for larger amounts of data being reported. See the Batch Queue article for more information.

Generate the Report

  1. Select Unique Staff Identifier (USID) from the Extract dropdown list.
  2. Select the desired Format.
  3. Select the desired File Type.
  4. Mark the Apply All Excludes checkbox to include enrollments, grade levels and calendars that are marked as State Exclude in the report.
  5. Click the Generate Extract button to display the results of the report immediately, or click the Submit to Batch button to choose when the report generates.

Screenshot of an example Unique Staff ID Extract  in HTML FormatUnique Staff ID Extract - HTML Format

Screenshot of an example Unique Staff ID Extract in CSV FormatUnique Staff ID Extract - CSV Format

Report Layout

Data ElementDescriptionLocation
Check Digit Staff IdentifierLists the staff person's state-issued identification number.

This field reports blank as the staff included do not have a State State ID.

Numeric, 10 digits
N/A
TSPC Account IDLists the staff person's Teacher Standards and Practices Commission assigned account number.

This field reports blank. Districts need to manually add this information to the file prior to the state submission. This data is not collected in Campus.

Numeric, 10 digits
N/A
Employer Institution IDReports the ODE Institution Identification number for the district employing the staff person.

This field reports blank. Districts need to manually add this information to the file prior to the state submission. This data is not collected in Campus.

Numeric, 10 digits
N/A
Employer Staff IDReports the staff person's person ID.

Numeric, 10 digits
Demographics > Person Information > Person ID

Person.personID
SSNReports the last four digits of the staff person's Social Security number.

Numeric, 4 digits
Demographics > Person Information > Soc Sec Number

Person.SSN
Last Name

Reports the staff person's legal last name.


When the Legal Last Name field is not populated, information reports from the Last Name field.


Alphanumeric, 50 characters

Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName


Demographics > Person Information > Last Name


Identity.lastName

First Name

Reports the staff person's legal first name.


When the Legal First Name field is not populated, information reports from First Name field.


Alphanumeric, 30 characters

Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName


Demographics > Person Information > First Name


Identity.firstName

Middle Initial

Reports the staff person's legal middle initial.


When the Legal Middle Name field is not populated, information reports from the Middle Name field. 


Alphanumeric, 30 characters


Identities > Identity Information > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName


Demographics > Person Information > Middle Name


Identity.middleName

Birth DateReports the staff person's date of birth.

Date field, 8 digits (MMDDYYYY)

Demographics > Person Information > Birth Date


Identity.birthDate

Gender CodeReports the staff person's Legal Gender as either Male (M), Female (F) or Non-Binary (X).

When the Legal Gender field is not populated, information reports from the Gender field.

When the Legal Gender or Gender fields are not populated, reports a value of X.

Alphanumeric, 1 character (M, F, X)
Identities > Identity Information > Protected Identity Information > Legal Gender


Identity.legalGender


Demographics > Person Information > Gender


Identity.Gender

Hispanic/Latino Ethnicity Flag

An indication of whether a staff person identifies as having a Hispanic ethnicity.

  • Reports a value of Y when Is the individual Hispanic/Latino? is set to Yes. 
  • Reports a value of N when Is the individual Hispanic/Latino? is set to No or is not populated.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Is the individual Hispanic/Latino?


Identity.hispanicEthnicity


American Indian/Alaskan Native Flag Reports a value of Y when the American Indian or Alaskan Native checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > American Indian or Alaska Native


Identity.raceEthnicity


Asian Race FlagReports a value of Y when the Asian checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > Asian


Identity.raceEthnicity


Black Race FlagReports a value of Y when the Black/African American checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > Black or African American


Identity.raceEthnicity


White Race FlagReports a value of Y when the White checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > White


Identity.raceEthnicity


Native Hawaiian/Other Pacific Islander Race FlagReports a value of Y when the Native Hawaiian or Other Pacific Islander checkbox is marked.

Reports a value of N when it is not marked.

Alphanumeric, 1 character (Y or N)

Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander


Identity.raceEthnicity


USID FillerN/AN/A