| Purpose | Loads courses that students are currently enrolled in so that these courses will appear in students’ course plans. |
|---|---|
| Filename | current_year_student_courses.csv |
| What to Include | All courses students are currently enrolled in for students that will be using Course Planner and all current 12th grade students. |
| What to Exclude | Elementary courses do not need to be included. Courses taken in grades 6-8 can be excluded if you are not using Course Planner for middle school students and the middle school courses do not get used for high school placement or credit. |
| Minimum Upload Frequency | During initial Course Planner configuration, and again immediately before students begin using Course Planner. |
| Recommended Upload Frequency | Nightly to ensure that any changes to student courses in your SIS are updated in SchooLinks. |
| Partial Data | Partial data is not supported. You must send the entire set of data each time the file is sent. Any previously included courses that are not included in a later upload will be removed. |
Choose the template that matches how you intend to pass student identifiers. If you are unsure which identifiers to use, check the Example Identifiers tab in the Data Upload tool on SchooLinks to see which identifiers have data loaded that match what you’ll be exporting.
student_number
current_year_student_courses.csv
student_sis_id
current_year_student_courses.csv
| Column Name | Required | Data Type | Description | |
|---|---|---|---|---|
student_number OR student_sis_id |
REQUIRED | STRING | The type of identifier must match the column name being used (an SIS ID, or student number). |
Indicates the student this course is for. ****
64 characters maximum length. | |
| course_id | REQUIRED | STRING | The course ID for the course being taken by the student. For courses your district offers, should match the course_id specified in the course master data. ****
64 characters maximum length. | |
| course_name | REQUIRED | STRING | The name or title of the course.
100 characters maximum length. Quoted if it contains commas. | |
| course_subject | OPTIONAL | STRING | The subject area of the course, which can be used for courses that do not appear in your course master.
100 characters maximum length. Quoted if it contains commas. | |
| school_year | REQUIRED | INTEGER | The school year the course was taken in, using the ending year. Always passed as a 4-digit year.
For example, for a course taken during the 2022-2023 school year, pass 2023 in this column. | |
| grade_year | REQUIRED | INTEGER | The grade year in which the student took the course. ****
Not required, but optional to maintain consistency with the historical courses schema. If not passed, the student’s current grade year will be used.
Examples include 9, 10, 11, etc. | |
| academic_term | REQUIRED | INTEGER | The academic terms this course is being taken in, based on the number of academic terms configured in your Course Planner configuration.
Examples: Blank or 1 for a full-year course (starts in the first semester), 1 for a course taken in the Fall, 2 for a course taken in the spring. | |
| outside_credit_type | OPTIONAL | STRING | One of: middle school, external, or blank. ****
When blank, this course will appear as taken or planned in an actual academic year. ****
When specified, this will prevent a course from taking up credit in an academic year (credit will still count for graduation). | |