Unique ID Extract (Wyoming)

Tool Search: Unique ID Extract

The Unique ID Extract is used to gather Student State ID data.

Screenshot of Unique ID Extract.Unique ID Extract

Report 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

  1. 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.
  2. Select an Ad Hoc Filter to limit students reported to those in an existing Ad hoc Filter.
  3. Indicate if Demographics fields should Report Student Legal Identities.
  4. Choose what Calendar(s) to include in the extract.
  5. 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.

Screenshot of Unique ID Extract in State Format (Tab Delimited).Example of the Unique ID Extract - State Format (Tab Delimited)


Screenshot of Example of the Unique ID Extract in CSV Format.Example of the Unique ID Extract - CSV Format


Screnshot of Unique ID Extract in XML Format.Example of the Unique ID Extract - XML Format


Screenshot of Unique ID Extract in HTML 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

ElementDescription & Format
Campus Location
SLF StatusCurrently reports as 1.

Numeric, 1 digit

Not dynamically stored

Record TypeCurrently reports as 1.

Numeric, 1 digit
Not dynamically stored
State IDThe student's WDE state-assigned person identifier.

Numeric, 8 digits
Demographics > State ID

Person.stateID
Local IDThe student's local identification number.

Alphanumeric, 20 characters
Demographics > Local Student Number

Person.studentNumber
First NameThe student's first name.

Alphanumeric, 50 characters
Demographics > First Name

Identity.firstName
Middle NameThe student's middle name.

Alphanumeric, 50 characters
Demographics > Middle Name

Identity.middleName
Last NameThe student's last name.

Alphanumeric, 20 characters
Demographics > Last Name

Identity.lastName
SuffixThe student's suffix.

Alphanumeric, 6 characters
Demographics > Suffix

Identity.suffix
Former Last NameThe 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 DateThe student's birth date.

Date Field, 10 characters MM/DD/YYYY
Demographics > Birth Date

Identity.birthDate
Birth PlaceThe 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 HispanicIndicates if the student's ethnicity is Hispanic. Reports as True or False. 

Alphanumeric, 5 characters

Demographics > Hispanic/Latino

Identity.hispanicEthnicity
Job Grade LevelThe 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 CodeThe 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 CodeThe district identification number of the reporting district. Must match Resident District. 

Numeric, 7 digits

District Information > State District Number


District.number

SSNThe student's social security number.

Alphanumeric, 12 characters XXXXXXXXX
Demographics > Soc Sec Number

Identity.ssn
TitleCurrently reports as null.N/A
EmailCurrently reports as null.N/A