Tool Search: Unique ID Extract
The Unique ID Extract is used to gather Student State ID data.
Unique ID ExtractReport Logic
Any student without a State ID reports, even if they have State Exclude on their enrollment or grade level. Students do not report if the Calendar of Summer School is marked Exclude.
Generating the Extract
- Select the Format from the dropdown. Use State Format (Tab Delimited) for submission to the state or CSV, XML, and HTML for data review and verification.
- Select an Ad Hoc Filter to limit students reported to those in an existing Ad hoc Filter.
- Indicate if Demographics fields should Report Student Legal Identities.
- Choose what Calendar(s) to include in the extract.
- Click Generate Report to view the report in the selected format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting a Unique ID Extract to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Example of the Unique ID Extract - State Format (Tab Delimited)
Example of the Unique ID Extract - CSV Format
Example of the Unique ID Extract - XML Format
Example of the Unique ID Extract - HTML Format
Extract Layout
If the Report Student Legal Identities is marked, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information
| Element | Description & Format | Campus Location |
|---|---|---|
| SLF Status | Currently reports as 1. Numeric, 1 digit | Not dynamically stored |
| Record Type | Currently reports as 1. Numeric, 1 digit | Not dynamically stored |
| State ID | The student's WDE state-assigned person identifier. Numeric, 8 digits | Demographics > State ID Person.stateID |
| Local ID | The student's local identification number. Alphanumeric, 20 characters | Demographics > Local Student Number Person.studentNumber |
| First Name | The student's first name. Alphanumeric, 50 characters | Demographics > First Name Identity.firstName |
| Middle Name | The student's middle name. Alphanumeric, 50 characters | Demographics > Middle Name Identity.middleName |
| Last Name | The student's last name. Alphanumeric, 20 characters | Demographics > Last Name Identity.lastName |
| Suffix | The student's suffix. Alphanumeric, 6 characters | Demographics > Suffix Identity.suffix |
| Former Last Name | The student's previous last name, if applicable. Reports the student's last name from the their most recent prior Identity record with an Effective Date on or before the extract effective date. Alphanumeric, 25 Characters | Identities > Last Name Identity.lastName |
| Gender | The student's gender. If 'Report Student Legal Identities' is marked, reports the Legal Gender from the Protected Identity Information. Alphanumeric, 1 character M or F | Demographics > Gender Identity.gender |
| Birth Date | The student's birth date. Date Field, 10 characters MM/DD/YYYY | Demographics > Birth Date Identity.birthDate |
| Birth Place | The name of the city where the student was born. Currently reports as null. | N/A |
| Race AI AN | Indicates if the student's race is American Indian or Alaska Native. Reports as True or False. Alphanumeric, 5 characters | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race Asian | Indicates if the student's race is Asian. Reports as True or False. Alphanumeric, 5 characters | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race Black | Indicates if the student's race is Black or African American. Reports as True or False. Alphanumeric, 5 characters | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race NH PI | Indicates if the student's race is Native Hawaiian or Pacific Islander. Reports as True or False. Alphanumeric, 5 characters | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race White | Indicates if the student's race is White. Reports as True or False. Alphanumeric, 5 characters | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Ethnic Hispanic | Indicates if the student's ethnicity is Hispanic. Reports as True or False. Alphanumeric, 5 characters | Demographics > Hispanic/Latino Identity.hispanicEthnicity |
| Job Grade Level | The grade level in which the student is enrolled. Reports the state value the student's grade level is mapped to. Alphanumeric, 4 characters | Calendar Information > State Grade Level; Enrollments > Grade GradeLevel.stateGrade |
| Res Org Code | The district state identification number of the student's Resident District Numeric, 7 digits | Enrollments > Resident District ID District Information > State District Number Enrollment.residentDistrict |
| Cur Org Code | The district identification number of the reporting district. Must match Resident District. Numeric, 7 digits | District Information > State District Number District.number |
| SSN | The student's social security number. Alphanumeric, 12 characters XXXXXXXXX | Demographics > Soc Sec Number Identity.ssn |
| Title | Currently reports as null. | N/A |
| Currently reports as null. | N/A |
