PowerSchool SIS Course Catalog Field Mapping
Review the Course Catalog 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.
Order | Naviance Field | Requirement | Definition | SIS Data Field Options | Naviance Default Field |
|---|---|---|---|---|---|
1 | Course_id | Required | The local course number for the course. |
| [Courses]Course_Number |
2 | Academic Year | Required |
| [School_Course]YearID | |
3 | Course_Name | Required | The long description of the course name. The course name is presented to students when browsing the Naviance course catalog. |
| [Courses]Course_Name |
4 | Subject_Area | Required | The name of the course subject area. The subject area is presented to students when browsing the Naviance course catalog. |
If Sced_Subject Area is selected, SCED_Subject_AREA is a required field for this import. | [Courses]Sched_Department |
5 | Credits | Required | The numerical value indicating the credits awarded upon successful completion of the course. The value can include decimals. |
| [Courses]Credit_Hours |
6 | Grade_Low | Required | The lowest grade in which a student can enroll in the course. |
| Lowest grade of previously enrolled students |
7 | Grade_High | Required | The highest grade in which the student can enroll in the course. |
| Highest grade of previously enrolled students |
8 | State_id | Optional | The unique, state-assigned, course ID numbers. The number can be alphanumeric. |
| [CoursesCoreFields]Alt_Course_Number |
9 | SCED_Subject_Area | Required when Create based on Sced_SubjectARea is selected for Subject_Area. Otherwise, optional. | The subject areas of the SCED framework as defined by the National Center for Education Statistics. If it is included, subject areas will be auto-created in Naviance. |
Do not import is no longer an option when SCED_Subject_Area is a required field. | Do not import |
10 | SCED_Course_Identifier | Optional | The SCED Course Code or Course Identifier as defined by the National Center for Education Statistics. |
| Do not import |
11 | Status | Optional | The status of the course. Enter Y for active courses. Otherwise, leave the cell empty. |
| Active if [School_Course]YearID is current academic year |
12 | Description | Optional | The text description. The description is presented to students when browsing the Naviance course catalog. |
| Do not import |
13 | Instructional_Level | Optional | The course rigor level. Enter the following:
|
| Digits part of Course_Number |
14 | CTE | Optional | The indicator of a CTE course. Enter Y for a CTE course. Otherwise, leave the cell empty. |
| [Courses]Vocational |
15 | Prereq_Text | Optional | The text description for any prerequisite courses. |
| Do not import |
16 | Prereq_ID | Optional | The text description for any prerequisite courses. |
| Do not import |
17 | Coreq_ID | Optional | The local course ID for any corequisite courses. Use and, or, and parenthesis for multiple corequisites. |
| Do not import |
18 | Recommendation_Required | Optional | The course requires a recommendation for enrollment. Enter Y for yes. Otherwise, leave the cell empty. |
| Do not import |
19 | Repeatable | Optional | The course can be taken more than once. Enter Y for yes. Otherwise, leave the cell empty. |
| Do not import |
20 | Equivalents | Optional | The course number equivalent of another course. Use the pipe (|) symbol for multiple courses. |
| Do not import |
21 | Credit_Type | Optional | The credit type assigned to the course. This information is used to filter course data. |
| [Courses] Credit_Type |
