Skip to main content
Skip table of contents

PowerSchool SIS Student Course Data Field Mapping


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

Course history

OrderNaviance fieldRequirementDefinitionSIS data field optionsNaviance default field
1Student_IDRequiredThe student number known to students and staff. Do not use internally generated IDs.
  • [Students]Student_Number
[Students]Student_Number
2Course_IDRequiredThe local course number used in your course catalog.
  • [StoredGrades]Course_Number
[StoredGrades]Course_Number
3Grade_Level_TakenRequiredThe grade level of the student upon completion of the course. Use a digit to indicate the grade.
  • [StoredGrades]Grade_Level
[StoredGrades]Grade_Level
4TermRecommended

The term during which the student is enrolled in the course.


The term is critical 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.
  • [StoredGrades]StoreCode
  • (Do not import)
[StoredGrades]StoreCode
5Course_NameOptionalThe course name or title. The course name is displayed to students in Naviance.
  • [StoredGrades]Course_Name
  • (Do not import)
[StoredGrades]Course_Name
6TeacherOptionalThe course instructor's name.
  • [StoredGrades]Teacher_Name
  • (Do not import)
[StoredGrades]Teacher_Name
7Credits_AttemptedRequiredThe numerical value indicating the credits attempted for the course. The value is used to calculate credit deficiency.
  • [StoredGrades]PotentialCrHrs
[StoredGrades]PotentialCrHrs
8Credits_EarnedRequiredThe numerical value indicating the credits awarded for completion of the course. The value can include decimals.
  • [StoredGrades]EarnedCrHrs
[StoredGrades]EarnedCrHrs
9Letter_GradeOptionalThe letter grade awarded for completion of the course.
  • [StoredGrades]Grade
  • (Do not import)
[StoredGrades]Grade
10ScoreOptionalThe number grades awarded for completion of the course.
  • [StoredGrades]Percent
  • (Do not import)
[StoredGrades]Percent
11Course_StatusRequiredThe status must be Completed or In Progress.
  • (Static Value)
Course_Status
12SectionOptionalThe course section ID. The section is used to ensure duplicates are not imported.
  • [StoredGrades]SectionID
  • (Do not import)
[StoredGrades]SectionID
13School_YearOptionalThe school year the student completed the course.
  • [StoredGrades]TermID
  • (Do not import)
[StoredGrades]TermID
14Credit_TypeOptionalThe credit type awarded for the course.
  • [StoredGrades]Credit_Type
  • (Do not import)
[StoredGrades]Credit_Type

Current courses

OrderNaviance fieldRequirementDefinitionSIS data field optionsNaviance default field
1Student_IDRequiredThe student number known to students and staff, not an internally generated ID.
  • [Students]Student_Number
[Students]Student_Number
2Course_IDRequiredThe local course number used in your course catalog.
  • [CC]Course_Number
[CC]Course_Number
3Grade_Level_TakenRequiredThe grade level of the student upon completion of the course. Enter a digit to indicate the grade.
  • [Students]Grade_Level
[Students]Grade_Level
4TermRecommended

The term during which the student is enrolled in the course.

The term is critical 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.
  • [Terms]Abbreviation
  • (Do not import)
  • Select custom field
[Terms]Abbreviation
5Course_NameOptionalThe 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
6TeacherOptionalThe course instructor's name.
  • [Teachers]LastFirst
  • (Do not import)
  • Select custom field
[Teachers]LastFirst
7Credits_AttemptedOptionalThe letter grade awarded for completion of the course.
  • [Courses]Credit_Hours
  • (Do not import)
  • Select custom field
[Courses]Credit_Hours
8Course_StatusRequiredThe number grades awarded for completion of the course.
  • Course_Status
Course_Status
9SectionOptionalThe course section ID. The section ID is used to ensure duplicates are not imported.
  • [CC]SectionID
  • (Do not import)
  • Select custom field
[CC]SectionID
10School_YearOptionalThe school year the student completed the course.
  • [CC]TermID
  • (Do not import)
  • Select custom field
[CC]TermID
11Credit_TypeOptionalThe credit type awarded for the course.
  • [Courses]Credit_Type
  • (Do not import)
[Courses]Credit_Type
JavaScript errors detected

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

If this problem persists, please contact our support.