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

Order

Naviance Field

Requirement

Definition

SIS Data Field List Options

Default Selection

1

Class Year (four digits)

Required

The 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

2

Enrollment Status

Required

The 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

3

High School Student ID

Required

The student number known to students and staff, not internally generated IDs.

reg.student_id

Student ID

4

Last Name

Required

The legal last name of the student.

reg.last_name

Last Name

5

School ID

Required

The ID of the school that the student attends within the district.

reg.building

reg_entry_with.building

Building

6

City

Optional

The student's physical or mailing address.

(Do not import)

reg_contact.city

Mailing Address (City)

7

Counselor

Optional

The name or employee ID of student's assigned counselor.

(Do not import)

reg.counselor

(Do not import)


8

Date of Birth

Optional

The student's date of birth.

(Do not import)

reg.birthdate

Birthdate

9

Decile

Optional

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

(Do not import)

mr_stu_gpa.cum_decile


(Do not import)


10

Email

Optional

The 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

11

Ethnicity

Optional

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

12

Federation ID

Optional

This 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)

13

First Name

Required for eDocs but otherwise optional.

The student's egal name. required for college applications.

(Do not import)

reg.first_name

First Name

14

Gender

Optional

The gender of student:

  • Male

  • Female

  • Non-binary

(Do not import)

reg.gender_identity

Gender

15

Home Phone

Optional

The 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

16

Middle Name

Required for eDocs but otherwise optional.

The student's legal name.

(Do not import)

reg.middle_name

Middle Name

17

Mobile Phone

Optional

The mobile phone number of student.

(Do not import)

Select custom field

(Do not import)

18

Original Class Year

Optional

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)

19

Rank

Optional

The integer representing the student's rank in class​.

(Do not import)

mr_stu_gpa.cum_rank

(Do not import)

20

State

Optional

The student's physical or mailing address.

(Do not import)

reg_contact.state

Mailing Address (State)

21

State Student ID

Optional

The student's state student ID Number.

(Do not import)

reg_personal.state_report_id

State Reporting ID

22

Street Address

Optional

The student's physical or mailing address.

(Do not import)

reg_contact.street_number

street_prefix

street_name

street_suffix

street_type

Mailing Address (Street)

23

Unweighted GPA

Optional

The 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)

24

Weighted GPA

Optional

The weighted student grade-point average. Include up to four decimal places. ​

(Do not import)

mr_stu_gpa.cum_gpa

(Do not import)


25

Zip

Optional

The student's physical or mailing address.

(Do not import)

reg_contact.zip

Mailing Address (Zip)


26

Groups

Optional

The Student Group ID code set up in Naviance.

(Do not import)

The field that corresponds to your group.

(Do not import)

27

Naviance Student Username

Optional

This 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

28

Homeroom

Optional

The 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

Order

Naviance Field

Requirement

Definition

SIS Data Field List Options

Default Selection

1

Date of Birth

Required

The student's date of birth.

reg.birthdate

Birthdate

2

Diploma Type

Required

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_code

Diploma Type

3

FERPA Block Requested

Optional

A yes or no indicator of whether the student requested a FERPA Block. ​Unless you indicate yes, the system defaults to no.

reg_personal.ferpa_name

Ferpa Name

4

First Name

Required

The student's legal first name.

reg.first_name

First_Name

5

Graduation Date

Required

The student's date of high school graduation.​

reg_academic.graduation_date

Graduation Date

Student Data Fields Not Supported by Data Integration

Data Field

Requirement

Example

Information

Nickname

Optional

Nita

The nickname of the student.

Country

Optional

US

The student's physical or mailing address.

Citizenship 1

Optional

US

Enter the two-letter ISO country code for primary and secondary citizenships.

Citizenship 2

Optional

CA

Enter the two-letter ISO country code for primary and secondary citizenships.

AP Courses

Optional

4

1

Enter the number of AP or Honors classes the student is enrolled.

Counselor Comments

Optional

No example.

No information.

JavaScript errors detected

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

If this problem persists, please contact our support.