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).

This information is current as of the Campus.2323 (June 2023) release.

Staff Courses Extract

Generate 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 (YYYY)	Calendar Information > Calendar > Calendar > End Date Calendar.year
SchoolNumber	State-assigned number associated with the school building. Numeric, 4 digits	System Administration > Resources > School > 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	Scheduling > Courses > Course > 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: NA: Not Applicable CORE: Core Academic Subject Area ELEM: Basic Elementary Curriculum SPED: Special Education Alphanumeric, 3 characters	Course Information > Subject Type Course.subjectType Course.coreSubject
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 Section.number
GradeLevelCode	N/A	N/A
CourseType	Type of course. Options are E: Elective or R: Required. Alphanumeric, 1 character	Course Information > Type Course.type

Element Name

Description

Location

Year

End year of the school year for which data is being imported.

Numeric, 4 digits
(YYYY)

Calendar Information > Calendar > Calendar > End Date

Calendar.year

SchoolNumber

State-assigned number associated with the school building.

Numeric, 4 digits

System Administration > Resources > School > 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

Scheduling > Courses > Course > 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:

NA: Not Applicable
CORE: Core Academic Subject Area
ELEM: Basic Elementary Curriculum
SPED: Special Education

Alphanumeric, 3 characters

Course Information > Subject Type

Course.subjectType

Course.coreSubject

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

Section.number

GradeLevelCode

N/A

CourseType

Type of course. Options are E: Elective or R: Required.

Alphanumeric, 1 character

Course Information > Type

Course.type

Staff Course Extract (South Dakota)

Generate the Extract

Report Format

Related Articles