Tool Search: Staff Data Extract
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).
Staff Courses ExtractGenerate the Extract
- Select the Extract Type from the dropdown list. See the following table for extract options.
- Indicate the Format in which the report should generate, CSV, XML or HTML.
- Click Generate Extract to generate the report in the desired format.
Report Format
Element Name | Description | Location |
|---|---|---|
Year | End year of the school year for which data is being imported. Numeric, 4 digits | Calendar Information > > End Date Calendar.year |
SchoolNumber | State-assigned number associated with the school building. Numeric, 4 digits | School Information > Number School.number |
StaffStateID | Staff member's state-assigned identification number. Numeric, 6 digits | Demographics > Person Identifiers > Staff State ID Person.stateStaffID |
StateCourseCode | State-assigned code/number assigned to a course. Numeric, 15 digits | Course Information > State Code Course.stateCode |
CourseName | Name of a course. Alphanumeric, 20 characters | Course Information > Name Course.name |
FederalSubject | Category of the teaching assignment used for HQ (Highly Qualified) status determination. Options include:
Alphanumeric, 3 characters | Course Information > Subject Type Course.subjectType |
LocalCourseNumber | Number assigned to a course by the district. Numeric, 10 digits | Course Information > Number Course.number |
LocalSectionNumber | Number assigned to the section of a course by the district. Numeric, 10 digits | Course Information > Section > Number Sourse.section |
GradeLevelCode | N/A | N/A |
CourseType | Type of course. Options are E: Elective or R: Required. Alphanumeric, 1 character | Course Information > Type Course.type |
