This information is specific to South Dakota users.
PATH: Census > Tools > Staff Data Extract > Staff Course Extract Type
The Staff Course Extract gathers information about the courses to which a staff member is assigned, such as course name and number and the grade level(s) taught. The Extract generated from this editor can be used in the Staff Courses Import (South Dakota).
Image 1: Staff Course Extract - CSV Format
The following table lists the data elements included in the data extract:
Element Name | Description | Format, Type and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
Year | End year of the school year for which data is being imported. | Numeric, 4 digits | calendar.year | System Administration > Calendar > Calendar > Calendar > End Date |
SchoolNumber | State-assigned number associated with the school building. | Numeric, 4 digits | school.number | System Administration > Resources > School > Number |
StaffStateID | Staff member's state-assigned identification number. | Numeric, 6 digits | person.stateStaffID | Census > People > Demographics > Person Identifiers > Staff State ID |
StateCourseCode | State-assigned code/number assigned to a course. | Numeric, 15 digits | course.stateCode | Scheduling > Courses > Course > State Code |
CourseName | Name of a course. | Alphanumeric, 20 characters | course.name | Scheduling > Courses > Course > Name |
FederalSubject | Category of the teaching assignment used for HQ (Highly Qualified) status determination. Options include:
| Alphanumeric, 3 characters | course.subjectType | Scheduling > Course > Course > Subject Type |
LocalCourseNumber | Number assigned to a course by the district. | Numeric, 10 digits | course.number | Scheduling > Courses > Course > Number |
LocalSectionNumber | Number assigned to the section of a course by the district. | Numeric, 10 digits | course.section | Scheduling > Courses > Course > Section > Number |
GradeLevelCode | Not applicable. | Not applicable. | Not applicable. | Not applicable. |
CourseType | Type of course. Options are E: Elective or R: Required. | Alphanumeric, 1 character | course.type | Scheduling > Courses > Course > Type |
