Adviser PersonID Import

Classic View: System Administration > Ed-Fi > Ed-Fi Reports > Adviser PersonID Import

Search Terms Adviser PersonID Import

The Adviser PersonID Import is used to insert or update 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.

   

Import a PersonID File

  1. Click the Choose File button. A File Upload window appears. 
  2. Select the file to import and click the Open button on the File Upload window. 
  3. Select the type of file being imported, either Tab Delimited or Comma Delimited.
  4. Select the Import Type of Insert or Update.
  5. 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.

 

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 RuleCampus DatabaseCampus Interface
Person Unique IDImports the student's SSID.
  1. If an SSID exists, a warning displays - "SSID already exists, do you want to continue?"
    1. If yes, updates the Ed-Fi ID and State ID fields to the value in the import file.
    2. If no, do not update for that student.

edfiID


stateiID

Census > People > Demographics > Ed-Fi ID


Census > People > Demographics > State  ID

Person Last NameMatching element to match the student's last name.

Identity.lastName

Identity.legalLastName 

Census > People > Demographics > Person Information > Last Name


Census > People > Identities >  Identities Editor > Protected Identitiy Information > Legal Last Name

Person First NameMatching element to match the student's first name.

Identity.legalFirstName

Identity.firstName

Census > People > Demographics > Person Information > First Name


Census > People > Identities >  Identities Editor > Protected Identitiy Information > Legal First Name

Person Middle Name

Matching element to match the student's middle name.

  1. If no match in Campus, ignore.

Identity.legalMiddleName


Census > People > Identities >  Identities Editor > Protected Identitiy Information > Legal Middle Name

Person Name Suffix

Matching element to match the student's suffix.

  1. If no match in Campus, ignore.

Identity.legalSuffix


Census > People > Identities >  Identities Editor > Protected Identitiy Information > Legal Suffix
GenderMatching element to match the student's gender.

Identity.legalGender

Identity.gender

Census > People > Demographics > Person Information > Gender


Census > People > Identities >  Identities Editor > Protected Identitiy Information > Legal Gender

Person Date of BirthMatching element to match the student's birth date.Identity.birthdate

Census > People > Demographics > Person Information > Birth Date


Census > People > Identities >  Identities Editor > Identity Information > Birth Date

Person School Year Not necessary for matching.SchoolYear.startYear
SchoolYear.endYear
System Administration > Calendar > School Years > Start Year

System Administration > Calendar > School Years > End Year
Person District Code Not necessary for matching.District.numberSystem Administration > Resources > District Information > State District Number
District Of Residence Not necessary for matching.Enrollment.residentDistrictStudent Information > General > Enrollments > State Reporting Fields > Home District
Person School Code Not necessary for matching.School.numberSystem Administration > Resources > School > State School Number
Grade Level

Matching element to match the student's grade level.

GradeLevel.stateGrade

Enrollment.grade

Student Information > General > Enrollments > Enrollment Editor > General Enrollment Information > Grade
Person Local IDNot necessary for matching.Person.studentNumberCensus > People > Demographics > Person Identifiers > Local Student Number
preferredFirstName 






Not necessary for matching.Census > People > Identities > firstNameidentity.firstName
preferredLastName




Not necessary for matching.Census > People > Identities > lastNameidentity.lastName