Tool Search: Adviser PersonID Import
The Adviser PersonID Import inserts or updates student identification numbers as they appear on the Nebraska Adviser SSID documents. This import matches the student's unique ID, name fields, gender, date of birth, and grade level in the import file and updates the student's Ed-Fi ID as available. After the upload, a Results Summary is generated, detailing the number of Student IDs inserted/changed and any errors or warnings.
Adviser PersonID Import Extract Editor
Import a PersonID File
- Click the Choose File button. A File Upload window appears.
- Select the file to import and click the Open button on the File Upload window.
- Select the type of file being imported, either Tab Delimited or Comma Delimited.
- Select the Import Type of Insert or Update.
- Click the Upload button. The Import will perform a match on the PersonUniqueID, legalFirstName, legalLastName, legalMiddleName, legalSuffix, legalGender, personDateOfBirth, and gradeLevel fields. A Results Summary window displays, noting any warnings or errors that were found and how many new state IDs were inserted or changed.
Results Summary Report
The Adviser PersonID Import file returns a Results Summary Report after the data has been uploaded. The Results Summary displays how many state IDs were inserted or changed and any warnings or errors that may have occurred.
Summary Report Example
Results Summary Layout
Field | Description |
|---|---|
State IDs Inserted | Reports the number of new state IDs inserted per report logic. |
State IDs Changed | Reports the number of state IDs that were modified per report logic. |
Warning Count | Reports the number of warnings generated per report logic. |
Error Count | Reports the number of errors generated per report logic. |
Error Detail | Reports the line and issue for each record in the import file that caused an error to report. |
Warning Detail | Reports the line and issue for each record in the import file that caused a warning to report. |
Import Logic
Element | Import Rule | Campus Interface |
|---|---|---|
| Person Unique ID | Imports the student's SSID.
| Demographics > Ed-Fi ID Demographics > State ID edfiID stateiID |
| Person Last Name | Matching element to match the student's last name. | Demographics > Person Information > Last Name
Identity.lastName Identity.legalLastName |
| Person First Name | Matching element to match the student's first name. | Demographics > Person Information > First Name
Identity.legalFirstName Identity.firstName |
| Person Middle Name | Matching element to match the student's middle name.
| Identities > Identities Editor > Protected Identity Information > Legal Middle Name Identity.legalMiddleName |
| Person Name Suffix | Matching element to match the student's suffix.
| Identities > Identities Editor > Protected Identitiy Information > Legal Suffix Identity.legalSuffix |
| Gender | Matching element to match the student's gender. | Demographics > Person Information > Gender
Identity.legalGender Identity.gender |
| Person Date of Birth | Matching element to match the student's birth date. | Demographics > Person Information > Birth Date
Identity.birthdate |
| Person School Year | Not necessary for matching. | School Years > Start Year School Years > End Year SchoolYear.startYear SchoolYear.endYear |
| Person District Code | Not necessary for matching. | District Information > State District Number District.number |
| District Of Residence | Not necessary for matching. | Enrollments > State Reporting Fields > Home District Enrollment.residentDistrict |
| Person School Code | Not necessary for matching. | School Information > State School Number School.number |
| Grade Level | Matching element to match the student's grade level. | Enrollments > Enrollment Editor > General Enrollment Information > Grade GradeLevel.stateGrade Enrollment.grade |
| Person Local ID | Not necessary for matching. | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
| preferredFirstName | Not necessary for matching. | Identities > firstName identity.firstName |
| preferredLastName | Not necessary for matching. | Identities > lastName identity.lastName |
