PowerSchool SIS Student Course Data Field Mapping

On this page:

Review the Student Course Data Field Mapping to learn how your PowerSchool Student Information System (SIS) fields match with Naviance fields. After reviewing the field mapping, continue with the preparation steps.

Course History

Order	Naviance Field	Requirement	Definition	SIS Data Field Options	Naviance Default Field
1	Student_ID	Required	The student number known to students and staff. Do not use internally generated IDs.	[Students]Student_Number	[Students]Student_Number
2	Course_ID	Required	The local course number used in your course catalog.	[StoredGrades]Course_Number	[StoredGrades]Course_Number
3	Grade_Level_Taken	Required	The grade level of the student upon completion of the course. Use a digit to indicate the grade.	[StoredGrades]Grade_Level	[StoredGrades]Grade_Level
4	Term	Recommended	The term during which the student is enrolled in the course. When importing multiple records for the same course in the same grade level for a given student, such as a record per semester for two semesters of Biology in grade 11 for student 82457, the term is critical.	[StoredGrades]StoreCode (Do not import)	[StoredGrades]StoreCode
5	Course_Name	Optional	The course name or title. The course name id displayed to students in Naviance.	[StoredGrades]Course_Name (Do not import)	[StoredGrades]Course_Name
6	Teacher	Optional	The course instructor name.	[StoredGrades]Teacher_Name (Do not import)	[StoredGrades]Teacher_Name
7	Credits_Attempted	Required	The numerical value indicating the credits attempted for the course. The value is used to calculate credit deficiency.	[StoredGrades]PotentialCrHrs	[StoredGrades]PotentialCrHrs
8	Credits_Earned	Required	The numerical value indicating the credits awarded for completion of the course. The value can include decimals.	[StoredGrades]EarnedCrHrs	[StoredGrades]EarnedCrHrs
9	Letter_Grade	Optional	The letter grade awarded for completion of the course.	[StoredGrades]Grade (Do not import)	[StoredGrades]Grade
10	Score	Optional	The number grade awarded for completion of the course.	[StoredGrades]Percent (Do not import)	[StoredGrades]Percent
11	Course_Status	Required	The status must be Completed or In Progress.	(Static Value)	Course_Status
12	Section	Optional	The course section ID. The section is used to ensure duplicates are not imported.	[StoredGrades]SectionID (Do not import)	[StoredGrades]SectionID
13	School_Year	Optional	The school year the student completed the course.	[StoredGrades]TermID (Do not import)	[StoredGrades]TermID
14	Credit_Type	Optional	The credit type awarded for the course.	[StoredGrades]Credit_Type (Do not import)	[StoredGrades]Credit_Type

Current Courses

Order	Naviance Field	Requirement	Definition	SIS Data Field Options	Naviance Default Field
1	Student_ID	Required	The student number known to students and staff, not an internally generated ID.	[Students]Student_Number	[Students]Student_Number
2	Course_ID	Required	The local course number used in your course catalog.	[CC]Course_Number	[CC]Course_Number
3	Grade_Level_Taken	Required	The grade level of the student upon completion of the course. Enter a digit to indicate the grade.	[Students]Grade_Level	[Students]Grade_Level
4	Term	Recommended	The term during which the student is enrolled in the course. When importing multiple records for the same course in the same grade level for a given student, such as a record per semester for two semesters of Biology in grade 11 for student 82457, the term is critical.	[Terms]Abbreviation (Do not import) Select custom field	[Terms]Abbreviation
5	Course_Name	Optional	The long description of the course name or title. The name is displayed to students when browsing the course catalog in Naviance.	[Courses]Course_Name (Do not import) Select custom field	[Courses]Course_Name
6	Teacher	Optional	The course instructor name.	[Teachers]LastFirst (Do not import) Select custom field	[Teachers]LastFirst
7	Credits_Attempted	Optional	The letter grade awarded for completion of the course.	[Courses]Credit_Hours (Do not import) Select custom field	[Courses]Credit_Hours
8	Course_Status	Required	The number grade awarded for completion of the course.	Course_Status	Course_Status
9	Section	Optional	The course section ID. The section ID is used to ensure duplicates are not imported.	[CC]SectionID (Do not import) Select custom field	[CC]SectionID
10	School_Year	Optional	The school year the student completed the course.	[CC]TermID (Do not import) Select custom field	[CC]TermID
11	Credit_Type	Optional	The credit type awarded for the course.	[Courses]Credit_Type (Do not import)	[Courses]Credit_Type