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:
- 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.
- Once the USIDs have been assigned, use the Unique Staff Identifier Import to assign the USIDs to the staff.
Unique 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
| Field | Description |
|---|---|
| Extract | Indicates which report is being generated. For this instance, choose Unique Staff Identifier (USID). |
| File Type | Determines which students report in the extract.
|
| Format | Indicates how the report generates. Options include CSV (state format), XML, and HTML |
| Apply All Excludes | When marked, staff who are marked as one of the following are included in the report:
When NOT marked, staff marked as Exclude are NOT included in the report. |
| Report Generation | To 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
- Select Unique Staff Identifier (USID) from the Extract dropdown list.
- Select the desired Format.
- Select the desired File Type.
- Mark the Apply All Excludes checkbox to include enrollments, grade levels and calendars that are marked as State Exclude in the report.
- 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.
Unique Staff ID Extract - HTML Format
Unique Staff ID Extract - CSV Format
Report Layout
| Data Element | Description | Location |
|---|---|---|
| Check Digit Staff Identifier | Lists 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 ID | Lists 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 ID | Reports 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 ID | Reports the staff person's person ID. Numeric, 10 digits | Demographics > Person Information > Person ID Person.personID |
| SSN | Reports 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 Date | Reports the staff person's date of birth. Date field, 8 digits (MMDDYYYY) | Demographics > Person Information > Birth Date Identity.birthDate |
| Gender Code | Reports 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.
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 Flag | Reports 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 Flag | Reports 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 Flag | Reports 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 Flag | Reports 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 Filler | N/A | N/A |
