Before you begin, for a reminder on the file structure notes and automating subsequent exports, check out Build Data Export Files
Build the course code data files by following the format indicated below.
CourseCodes (.txt or .csv)
This file is a list of all courses offered for the upcoming year. If the upcoming year is not yet available, then it should reflect the current course offering. CourseCodes is only required from high schools.
| Column Name | Type | Description |
|---|---|---|
| SchoolCode | char(15) | The code of the school where the course is offered. |
| CourseCode | char(50) | The course code from the course curriculum. The course code should be unique within a school and what is visible on a student's transcript. |
| CourseName | char(250) | Course name or title. |
| CreditValue | Numeric | The number of credits student receives upon successful completion of course. |
| GradeLower | Int |
If the course is offered to multiple grades, specify the lowest grade level the course is offered.
If only a single grade is offered, set both GradeLower and GradeUpper to the same value. |
| GradeUpper | Int |
If the course is offered to multiple grades, specify the highest grade level the course is offered.
If only a single grade is offered, set both GradeLower and GradeUpper to the same value. |
Example:
123|ENG56|EnglishLit|0.5|9|12