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 | Demographics > Student State ID, Ed-Fi ID Person.stateID |
| Local ID | The student's local identification number. Numeric, 20 digits | 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. Alphanumeric, 1 character M or F | Demographics > Gender Identity.gender |
| SSN | The student's social security number. Alphanumeric, 12 characters XXX-XX-XXXX | Demographics > Soc Sec Number Identity.ssn |
| 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. Alphanumeric, 1 character Y or N | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race Asian | Indicates if the student's race is Asian. Alphanumeric, 1 character Y or N | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race Black | Indicates if the student's race is Black or African American. Alphanumeric, 1 character Y or N | Demographics > 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 | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Race White | Indicates if the student's race is White. Alphanumeric, 1 character Y or N | Demographics > Race/Ethnicity Identity.raceEthnicity |
| Ethnic Hispanic | Indicates if the student's ethnicity is Hispanic Alphanumeric, 1 character Y or N | 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 XXX-XX-XXXX | Demographics > Soc Sec Number Identity.ssn |
| Title | Currently reports as null. | N/A |
| Currently reports as null. | N/A |
