Skip to main content
Skip table of contents

eSchoolPlus SIS Student Field Mapping

Instructions

  1. Review the data fields supported by the Naviance and eSchoolPlus SIS integration.

    To import student data fields not supported by eSchoolPlus SIS, Naviance recommends importing those fields using a manual data import or by an automated data import with SchoolSync™.
  2. Note the required data field and determine any additional data fields to import for students.
  3. Complete the pre-integration preparation steps.
  4. Configure the integration in Naviance.

If you are a Clever user and take advantage of eSchoolPlus SIS Integration:

  • You cannot sync student data with Clever.
  • You cannot use the new Clever integration for staff.
  • You can continue to use Clever for single sign-on (SSO).
    1. To set up the Clever SSO experience, create a SAML connection in Naviance and then use the External Link feature in Clever to add Naviance.
    2. To retrieve the Naviance link needed for the Clever external link feature, set up student SAML and retrieve the Bookmark URL.

Student Data Fields for Integration

OrderNaviance FieldRequirementDefinitionSIS Data Field List OptionsDefault Selection
1Class Year (four digits)RequiredThe year the student is expected to graduate; associated with the student's grade.

Varies:

For Active students, convert grade (reg.grade) to Class Year in Naviance

If current date is between Jan 1 and Jul 15, then Class Year = Current Year + (12 - Grade)

If current date is between Jul 15 and Dec 31, Then Class Year = Current Year + 1 + (12-Grade)

For Graduated students, get class year from reg_academic.graduation_date

Class Year based on Current Grade
2Enrollment StatusRequiredThe field to track student's enrollment status, such as Currently enrolled, Graduated, or Transferred out.

Currently enrolled students:

reg.current_status = P (Preregistered) or A (Active)

Graduated students:

reg.current_status =G (Graduated)

reg.current_status = I (Inactive)

reg_entry_with.withdrawal_code

Status
3High School Student IDRequiredThe student number known to students and staff, not internally generated IDs.reg.student_idStudent ID
4Last NameRequiredThe legal last name of the student.reg.last_nameLast Name
5School IDRequiredThe ID of the school that the student attends within the district.

reg.building

reg_entry_with.building

Building
6CityOptionalThe student's physical or mailing address.

(Do not import)

reg_contact.city

Mailing Address (City)

7CounselorOptionalThe name or employee ID of student's assigned counselor.

(Do not import)

reg.counselor

(Do not import)


8Date of BirthOptionalThe student's date of birth.

(Do not import)

reg.birthdate

Birthdate

9DecileOptionalThe integer representing the student's rank in terms of decile.

(Do not import)

mr_stu_gpa.cum_decile


(Do not import)


10EmailOptionalThe preferred email address of student for receiving emails from the school; can be a school email address or student's personal email address.

(Do not import)

reg_contact.email

Email Address

11EthnicityOptional

The standard ethnicity categories are:

  • N/A
  • White
  • Black/African American
  • Hispanic/Latino
  • Asian
  • American Indian/Alaska Native
  • Pacific Islander/Native Hawaiian
  • Filipino
  • Multi-Racial
  • Other

(Do not import)

reg_personal.hispanic

reg_ethnicity.ethnic_code

reg_personal.fed_race_ethnic

Federal Race

12Federation IDOptionalThis ID is required if 'Federated ID' is the Federation Type used for SAML SSO Setup.

(Do not import)

sec_global_id.global_id

(Do not import)
13First NameRequired for eDocs but otherwise optional.The student's egal name. required for college applications.

(Do not import)

reg.first_name

First Name

14GenderOptional

The gender of student:

  • Male
  • Female
  • Non-binary

(Do not import)

reg.gender_identity

Gender

15Home PhoneOptionalThe home phone number of student.

(Do not import)

reg_contact_phone

Phone_type must be the code your district uses for home phone, usually H.

Home_Phone

16Middle NameRequired for eDocs but otherwise optional.The student's legal name.

(Do not import)

reg.middle_name

Middle Name

17Mobile PhoneOptionalThe mobile phone number of student.

(Do not import)

Select custom field

(Do not import)
18Original Class YearOptional

The year the student expected to graduate upon entering grade 9, sometimes called the Cohort Year.

(Do not import)

reg_academic.graduation_year

(Do not import)
19RankOptionalThe integer representing the student's rank in class​.

(Do not import)

mr_stu_gpa.cum_rank

(Do not import)
20StateOptionalThe student's physical or mailing address.

(Do not import)

reg_contact.state

Mailing Address (State)

21State Student IDOptionalThe student's state student ID Number.

(Do not import)

reg_personal.state_report_id

State Reporting ID

22Street AddressOptionalThe student's physical or mailing address.

(Do not import)

reg_contact.street_number

street_prefix

street_name

street_suffix

street_type

Mailing Address (Street)

23Unweighted GPAOptionalThe student's grade-point average. Include up to four decimal places. ​

(Do not import)

mr_stu_gpa.cum_gpa

Gpa_type must be the same code used for unweighted GPA.
(Do not import)
24Weighted GPAOptionalThe weighted student grade-point average. Include up to four decimal places. ​

(Do not import)

mr_stu_gpa.cum_gpa

(Do not import)


25ZipOptionalThe student's physical or mailing address.

(Do not import)

reg_contact.zip

Mailing Address (Zip)


26GroupsOptionalThe Student Group ID code set up in Naviance.

(Do not import)

The field that corresponds to your group.

(Do not import)
27Naviance Student UsernameOptionalThis ID is required if Federated ID is the Federation Type used for SAML SSO setup.

(Do not import)

reg_contact.login_id

No student login created
28HomeroomOptionalThe homeroom of student. Set up homerooms in individual school accounts first.

(Do not import)

reg.homeroom_primary

(Do not import)

Alumni Student Data Fields for Integration

OrderNaviance FieldRequirementDefinitionSIS Data Field List OptionsDefault Selection
1Date of BirthRequiredThe student's date of birth.

reg.birthdate

Birthdate

2Diploma TypeRequired

The supported diploma types are:

  • N/A
  • Endorsed/Advanced Diploma,
  • General Education Development (GED) Credential
  • High School Equivalency Credential
  • International Baccalaureate
  • Modified Diploma
  • Regular Diploma
  • Vocational Certificate
  • Other​
reg_entry_with.withdrawal_codeDiploma Type
3FERPA Block RequestedOptionalA yes or no indicator of whether the student requested a FERPA Block. ​Unless you indicate yes, the system defaults to no.reg_personal.ferpa_nameFerpa Name
4First NameRequiredThe student's legal first name.reg.first_name

First_Name

5Graduation DateRequiredThe student's date of high school graduation.​reg_academic.graduation_dateGraduation Date

Student Data Fields Not Supported by Data Integration

Data FieldRequirementExampleInformation
NicknameOptionalNitaThe nickname of the student.
CountryOptionalUSThe student's physical or mailing address.
Citizenship 1OptionalUSEnter the two-letter ISO country code for primary and secondary citizenships.
Citizenship 2OptionalCAEnter the two-letter ISO country code for primary and secondary citizenships.
AP CoursesOptional

4

1

Enter the number of AP or Honors classes the student is enrolled.
Counselor CommentsOptionalNo example.No information.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.