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
| 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 |
| 2 | Course_ID | Required | The local course number used in your course catalog. |
| [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 |
| 4 | Term | Recommended | The term during which the student is enrolled in the course. |
| [StoredGrades]StoreCode |
| 5 | Course_Name | Optional | The course name or title. The course name is displayed to students in Naviance. |
| [StoredGrades]Course_Name |
| 6 | Teacher | Optional | The course instructor's name. |
| [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 |
| 8 | Credits_Earned | Required | The numerical value indicating the credits awarded for completion of the course. The value can include decimals. |
| [StoredGrades]EarnedCrHrs |
| 9 | Letter_Grade | Optional | The letter grade awarded for completion of the course. |
| [StoredGrades]Grade |
| 10 | Score | Optional | The number grades awarded for completion of the course. |
| [StoredGrades]Percent |
| 11 | Course_Status | Required | The status must be Completed or In Progress. |
| Course_Status |
| 12 | Section | Optional | The course section ID. The section is used to ensure duplicates are not imported. |
| [StoredGrades]SectionID |
| 13 | School_Year | Optional | The school year the student completed the course. |
| [StoredGrades]TermID |
| 14 | Credit_Type | Optional | The credit type awarded for the course. |
| [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 |
| 2 | Course_ID | Required | The local course number used in your course catalog. |
| [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 |
| 4 | Term | Recommended | 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 |
| 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 |
| 6 | Teacher | Optional | The course instructor's name. |
| [Teachers]LastFirst |
| 7 | Credits_Attempted | Optional | The letter grade awarded for completion of the course. |
| [Courses]Credit_Hours |
| 8 | Course_Status | Required | The number grades awarded for completion of the course. |
| Course_Status |
| 9 | Section | Optional | The course section ID. The section ID is used to ensure duplicates are not imported. |
| [CC]SectionID |
| 10 | School_Year | Optional | The school year the student completed the course. |
| [CC]TermID |
| 11 | Credit_Type | Optional | The credit type awarded for the course. |
| [Courses]Credit_Type |