Tool Search: Unique ID Import
The Unique ID Import is used to import Student State ID data.
Unique ID Import
Importing a File
- Click the Choose File button. Directs the user to select a file to be uploaded from its locally stored location.
- Select the appropriate file and click the Open button. The file name appears next to the Choose File button.
- Click the Upload button. Data imports into Infinite Campus within the fields described in the Unique ID Import Layout table below.
Import Layout
| Element | Description & Format | Campus Location |
|---|---|---|
| SLF Status | Reports as 1. | N/A |
| Record Type | Reports as 1. | N/A |
| State ID | The state-assigned student record identifier. This field also updates the Ed-Fi ID. Alphanumeric, 8 characters | Census > People > Demographics > Person Identifiers > Student State ID, Ed-Fi ID Person.stateID |
| Local ID | The student's local identification number. Numeric, 20 digits | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber |
| First Name | The student's first name. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > First Name Identity.firstName |
| Middle Name | The student's middle name. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName |
| Last Name | The student's last name. Alphanumeric, 20 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName |
| Suffix | The student's suffix. Alphanumeric, 6 characters | Census > People > Demographics > Person Information > 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 | Census > People > Identities > Last Name Identity.lastName |
| Gender | The student's gender. Alphanumeric, 1 character M or F | Census > People > Demographics > Person Information > Gender Identity.gender |
| SSN | The student's social security number. Alphanumeric, 12 characters XXX-XX-XXXX | Census > People > Demographics > Person Information > Soc Sec Number Identity.ssn |
| Birth Date | The student's birth date. Date Field, 10 characters MM/DD/YYYY | Census > People > Demographics > Person Information > 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. Alphanumeric, 1 character Y or N | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Race Asian | Indicates if the student's race is Asian. Alphanumeric, 1 character Y or N | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Race Black | Indicates if the student's race is Black or African American. Alphanumeric, 1 character Y or N | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Race NH PI | Indicates if the student's race is Native Hawaiian or Pacific Islander. Alphanumeric, 1 character Y or N | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Race White | Indicates if the student's race is White. Alphanumeric, 1 character Y or N | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| Ethnic Hispanic | Indicates if the student's ethnicity is Hispanic Alphanumeric, 1 character Y or N | Census > People > Demographics > Person Information > 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 | System Administration > Calendar > Calendar > State Grade Level; Student Information > General > Enrollments > Grade GradeLevel.stateGrade |
| Res Org Code | The district state identification number of the student's Resident District Numeric, 7 digits | Student Information > General > Enrollments > Resident District ID System Administration > Resources > District > State District Number Enrollment.residentDistrict |
| Cur Org Code | The district identification number of the reporting district. Must match Resident District. Numeric, 7 digits | System Administration > District Information > State District Number District.number |
| SSN | The student's social security number. Alphanumeric, 12 characters XXX-XX-XXXX | Census > People > Demographics > Person Information > Soc Sec Number Identity.ssn |
| Title | Currently reports as null. | N/A |
| Currently reports as null. | N/A |
