Student Data Import Fields
Instructions
- Review the details of student data fields that you can import into Naviance.
- Note the required data fields and determine the recommended and optional fields you also want to import for students.
- Download the student data import template from the Naviance Knowledge Base in the PowerSchool Community. Select PowerSchool Community from the Get Help menu in Naviance to access the Community.
- Prepare the data to import using the template as a guide. The school-level student data import supports over 50k rows of data.
Import the data via a manual data import or an automated data import using SchoolSync.
To import data fields not supported by Clever, eSchoolPlus SIS, or PowerSchool SIS, Naviance recommends importing those fields using a manual data import or by setting up an automated data import with SchoolSync™.
Student import fields
Alternatively, review the PowerSchool SIS Student Data Field Mapping information or the eSchoolPlus SIS Student Data Field Mapping information if importing your student course data via a PowerSchool Data Integration.
| Data field | Requirement | Example | Information | Import method |
|---|---|---|---|---|
| Student ID | Required | 340LJ10 | The unique identification number that is assigned to a student by the school or district. | |
| Class Year | Required | 2022 | Must use a four-digit class year, not a grade level. | |
| Last Name | Required | Garcia | The last name of the student. | |
| School ID | Required in a district-level import only. | 925 | Use the School ID numbers entered in your account settings. | |
| Enrollment Status | Optional | Graduated Active | The enrollment status of the student in the Student Information System. This is used to determine if a student is active, inactivate, graduated, or transferred out of the school or district. | |
| First Name | Recommended | Anita | The student's legal name. Required for college applications. | |
| Date of Birth | Required for eDocs otherwise recommended | 11/15/2005 | Must use one of these formats:
| |
| Student Email | Required if setting up SAML SSO and using email as the Federation Type, otherwise recommended | anita.garcia@naviance.com | Students managing their username and password can reset their own password when an email address is available in their Naviance account. | |
| Federated ID | Required if setting up SAML SSO and using Federated ID as the Federation Type, otherwise not needed | hobsonss00000012349 | If setting up SAML SSO, do not add Federated ID if you use email as the Federation Type. | |
| Naviance Student Username | Required if setting up SAML SSO otherwise optional | angarcia | If you assign students a username, you must generate and distribute temporary passwords for students. | |
| Middle Name | Optional | Rose | The legal name required for college applications. | |
| Nickname | Optional | Nita | The nickname of the student. | |
| State Student ID | Optional | 483923 | The state assigned student identification number. | |
| Gender | Optional | X | Use a consistent code for this field. The standard gender categories are:
| |
| Counselor ID | Optional | Gardner 892140 | Create counselor accounts in Naviance before importing student counselor assignments. Counselor ID can be the employee ID number if entered when creating the user account. | |
| Original Class Year | Optional | 2021 | The year the student is expected to graduate upon entering the 9th grade. Sometimes referred to as a Cohort Year. | |
| Homeroom | Optional | Garcia A103 204 | Set up homerooms in individual school accounts first. Homerooms that you import must match the homerooms set up in Naviance. | |
| Ethnicity | Optional | BLA HIS ASN | Use a consistent code. Standard ethnicity categories are:
| |
| Street Address 1 | Optional | 123 19th St. SW 2400 Maple Lane | The student's physical or mailing address. | |
| Street Address 2 | Optional | #45 | The student's physical or mailing address. | |
| City | Optional | Lincoln Washington | The student's physical or mailing address. | |
| State | Optional | NE Maine | The student's physical or mailing address. | |
| Zip Code | Optional | 20041 | The student's physical or mailing address. | |
| 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. | |
| GPA | Optional | 3.9 | The student's grade-point average, enter up to four decimal places. | |
| Weighted GPA | Optional | 4.2 | The student's weighted student grade-point average, enter up to four decimal places. | |
| Rank | Optional | 150 | An integer representing the student's rank in class. | |
| Decile | Optional | 5 | An integer representing the student's rank in terms of decile. | |
| AP Courses | Optional | 4 1 | Enter the number of AP or Honors classes the student is enrolled in. | |
| Home Phone | Optional | 202-123-4567 | The home phone number of the student. | |
| Mobile Phone | Optional | 301-345-2345 | The mobile phone number of the student. | |
| Counselor Comments | Optional | Anita is a member of the National Junior Tennis Team. | A note about the student. | |
| Group 1 | Optional | LUN ATH | To assign students to a group, create Groups in Naviance first. If assigning students to more than one group, add additional data columns labeled Group 2, Group 3, etc. | |
| FERPA Block Requested | Required for Alumni Tracker otherwise optional | Yes No | Use a consistent code in this field. The standard request statuses are no and yes. If blank, FERPA Block Requested will be no. | |
| Graduation Date | Required for Alumni Tracker otherwise optional | 6/29/2022 | Use one of these six formats:
| |
| Diploma Type | Required for Alumni Tracker otherwise optional | GED Regular Diploma | Use a consistent code in this field. Standard diploma types are:
|