PowerSchool SIS Student Field Mapping

Instructions

Review the data fields supported by the Naviance and PowerSchool SIS integration.

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

If you are a Clever user and you take advantage of PowerSchool SIS Integration, you cannot sync student data with Clever, however, you can continue to use Clever for single sign-on (SSO).

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.
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 student's forecasted year of graduation. This can change if the student moves ahead a grade or is held back.	[Students]ClassOf [Students]Sched_YearOfGraduation [StudentCoreFields]Graduation_Year Select custom field	ClassOf
2	Enrollment Status	Required	The field to track students' enrollment status, ex. Currently enrolled, Graduated, Transferred out, etc.	Currently enrolled students: reg.current_status = P (Preregistered) or A (Active) Graduated students: reg.current_status = P (Preregistered) or A (Active) reg.current_status = I (Inactive) reg_entry_with.withdrawal_code has specific codes for graduated students in validation table (custom for each client)	Entroll_Status
3	High School Student ID	Required	The student ID that is known to students and staff.	reg.student_id	Student_Number
4	Last Name	Required when using eDocs, otherwise optional.	The legal last name of the student.	[Students]Last_Name [StudentCoreFields]PSCore_Legal_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	SchoolID
6	City	Optional	The physical or mailing address, depends on district preference.	(Do not import) [Students]City [Students]Mailing_City [Students]Mailing_City (if available) or [Students]City	City
7	Counselor	Optional	The student's assigned counselor.	(Do not import) [StudentCounselor]UserDCID Select custom field	(Do not import)
8	Date of Birth	Optional	The student's birthday.	(Do not import) [Students]DOB	DOB
9	Decile	Optional	The decile would indicate the % rank of the student, such as top 10%, 20%, 30% etc.	(Do not import) Select custom field	(Do not import)
10	Email	Optional	The student's email address.	(Do not import) [PSM_StudentContact]Email [EmailAddress]EmailAddress Select custom field	[EmailAddress]EmailAddress
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, and Other.	(Do not import) [Students]Ethnicity [Students]FedEthnicity and [StudentRace]RaceCD	[Students]FedEthnicity and [StudentRace]RaceCD
12	Federation ID	Optional	The ID is required if 'Federated ID' is the Federation Type used for SAML SSO Setup.	(Do not import) [Students]Student_Number [Students]DCID Select custom field	(Do not import)
13	First Name	Required when using eDocs, otherwise optional.	The legal first name of the student.	(Do not import) [Students]First_Name [StudentCoreFields]PSCore_Legal_First_Name	First_Name
14	Gender	Required when using eDocs, otherwise optional.	The legal gender of student.	(Do not import) [Students]Gender [StudentCoreFields]PSCore_Legal_Gender	Gender
15	Home Phone	Optional	The home phone number of student. Set up homerooms in individual school accounts first.	(Do not import) [Students]Home_Phone Select custom field	Home_Phone
16	Home Room	Optional	The homeroom of student.	(Do not import) [Students]Home_Room Select custom field	Home_Room
17	Middle Name	Required when using eDocs, otherwise optional.	The legal middle name of the student.	(Do not import) [Students]Middle_Name [StudentCoreFields]PSCore_Legal_Middle_Name	Middle_Name
18	Mobile Phone	Optional	The mobile phone number of student.	(Do not import) Select custom field	(Do not import)
19	Original Class Year	Optional	The forecasted year of graduation upon entering grade 9. This does not change (used for calculating on-time graduation).	(Do not import) [Students]ClassOf [Students]Sched_YearOfGraduation [StudentCoreFields]Graduation_Year Select custom field	(Do not import)
20	Rank	Optional	The student's class rank.	(Do not import) (List of Class Rank Methods) Select custom field	(Do not import)
21	State	Optional	The physical or mailing address, depends on district preference.	(Do not import) [Students]State [Students]Mailing_State [Students]Mailing_State (if available) or [Students]State	State
22	State Student ID	Optional	State Student ID Number.	(Do not import) [Students]State_StudentNumber Select custom field	State_StudentNumber
23	Street Address	Optional	The physical or mailing address, depends on district preference.	(Do not import) [Students]Street [Students]Mailing_Street [Students]Mailing_Street (if available) or [Students]Street	Street
24	Unweighted GPA	Optional	The student's cumulative GPA.	(Do not import) (List of GPA Calculation Methods associated with a Class Rank Method) Select custom field	(Do not import)
25	Weighted GPA	Optional	The student's weighted GPA.	(Do not import) (List of GPA Calculation Methods associated with a Class Rank Method) Select custom field	(Do not import)
26	Zip	Optional	The physical or mailing address, depends on district preference.	(Do not import) [Students]Zip [Students]Mailing_Zip [Students]Mailing_Zip (if available) or[Students] Zip	Zip
27	Group	Optional	The Student Group ID code set up in Naviance.	(Do not import) Select custom field	(Do not import)
28	Naviance Student Username	Optional	The username that student uses when signing in directly to Naviance.	(No student login created) [Students]student_web_id [Students]email [Students]student_number Select custom field	(No student login created)

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 birthday.	[Students]DOB	[Students]DOB
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	[Students]ExitCode Select custom field	[Students]ExitCode
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.	Select custom field	Ferpa_Status
4	First Name	Required	The student's legal first name.	[Students]First_Name [StudentCoreFields]PSCore_Legal_First_Name	[Students]First_Name
5	Graduation Date	Required	The student's expected date of high school graduation.	[Students]ExitDate Select custom field	[Students]ExitDate

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.