Tool Search: SIRS Extracts
The Course Instructor Assignment extract reports a roster of all staff members assigned to course with a State Code.
Report Logic
- To report, the course must meet the following requirements.
- The State Code field on the course must be populated.
- The Active checkbox on the course must be marked.
- The class section must be scheduled in the Calendar selected on the extract editor.
- The Section must have at least one Staff History record where the Staff Type is P.
- At least one student must have an active roster record for at least one day in which the class is scheduled unless the No Roster checkbox is marked on the course.
- A record does NOT report if
- the calendar is marked as Exclude.
- the Staff Type on the Staff History Record is SS.
- the Staff History role is 99: Exclude from State Reporting.
- the staff member's Staff History End Date falls before the the class starts.
- the staff member's Staff History Start Date is after the extract editor's Effective Date.
- the Start Date of the first Term in which the class is scheduled is greater than the extract editor's Effective Date.
- If a teacher has multiple Staff History records in a single class, all Staff History records that qualify in the selection criteria report.
Extract Editor Field Descriptions
| Field | Descriptions |
|---|---|
| Extract Type | The extract to be run. |
| Effective Date | The date for which information reports. |
| Format | The Format in which the report should generate. Options are State Format (CSV) and HTML. Use State Format for reporting information to the state and the other types for data review and verification. |
| Ad Hoc Filter | Selecting a filter limits the results to only those included in the filter. |
| Column Headers | Indicates whether Column Headers should be included in the report. This dropdown list applies to State Format (CSV). |
Generate Extract/ Submit to Batch | Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
| Select Calendars | Identifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year. |
Report Layout
| Element | Logic | Type, Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| DISTRICT CODE | The code that identifies the district and its schools for reporting purposes. The prefix "NY" is added to the district number. For example, if the district number is 662001, the District Code is NY662001. | Alphanumeric, 8 digits | District.number | District Information > State District Number |
| COURSE LOCATION CODE | The local building code that uniquely identifies the location associated with the course sections for which the staff person is responsible. | Alphanumeric, 6 digits | School.locationCode | School Information > Location Code |
| SCHOOL YEAR DATE | This field always reports as "June 30" of the reported school year. | Date field, 10 characters YYYY-06-30 | Calendar.endYear | Calendar Information > Calendar |
| COURSE CODE | The local course code that uniquely identifies the course. | Alphanumeric, 12 digits | Course.number | Scheduling > Courses > Course > Number |
| SUPPLEMENTARY COURSE DIFFERENTIATOR | The code used to indicate that the course code is offered in more than one session during the school year. This field always reports NA. | N/A | N/A | N/A |
| SECTION CODE | The local section code. | Alphanumeric, 25 digits | Section.number | Scheduling > Courses > Section > Section Number |
| TERM CODE | The code used to identify the school calendar term for which a course/section is reporting. Reports the Term Code of the last term in which the class is scheduled. | Alphanumeric, 20 digits | Term.stateCode | Calendar > Calendar > Terms > Term Code |
| MARKING PERIOD CODE | This field reports NA. | N/A | N/A | N/A |
| INSTRUCTOR DISTRICT CODE | The District Code of the entity which has primary control of the primary instructor’s course/section assignments. This code is the same as the District Code. | Alphanumeric, 8 digits | N/A | N/A |
| INSTRUCTOR ID | The staff member's Staff State ID. | Alphanumeric, 9 digits | Person.staffStateID | Demographics > Staff State ID |
| INSTRUCTOR START DATE | The staff member's Staff History Start Date for the class. If the Staff History Start Date is NULL, the Start Date of the first Term the class is scheduled in reports. | Date field, 10 characters YYYY-MM-DD | SectionStaffHistory.startDate Term.startDate | Scheduling > Courses > Section > Staff History > Start Date Calendar Information > Terms > Term Detail > Start Date |
| INSTRUCTOR END DATE | The last date in this course/section assignment for the staff person. This field only reports if the staff person’s responsibility for the assignment has ended. If a new staff person will serve as a replacement for the position/assignments, that person can report with the appropriate start date. Generally this is a long-term or permanent replacement. To report, one of the following dates must be less than or equal to the Effective Date entered on the extract editor:
Otherwise, this field reports blank. | Date field, 10 characters YYYY-MM-DD | SectionStaffHistory.endDate Term.endDate | Scheduling > Courses > Section > Staff History > End Date Calendar Information > Terms > Term Detail > End Date |
| PRIMARY INSTRUCTOR INDICATOR | Indicates whether the staff person has primary responsibility for the course. At least one Staff ID record for each course/section reports with a "Y" in this field. If the teacher is the primary teacher or assigned to one of the following Teacher Roles, Y reports.
Otherwise, N reports. | Alphanumeric, 3 digits | SectionStaffHistory.staffType SectionStaffHistory.role | Scheduling > Courses > Section > Staff History > Primary Teacher Scheduling > Courses > Section > Staff History > Teacher Role |
| PRIMARY SPECIAL EDUCATION INDICATOR | Indicates whether the staff person is the special education instructor for the course/section. If the teacher has a Staff History assigned to one of the following Teacher Roles, Y reports.
Otherwise, N reports. | Alphanumeric, 3 digits | SectionStaffHistory.role | Scheduling > Courses > Section > Staff History > Teacher Role |
| PRIMARY INSTRUCTION DELIVERY METHOD CODE | The delivery method of the instruction. | Alphanumeric, 20 digits | Section.instructionalSetting CustomCourse.value | Scheduling > Courses > Course > Section > Section Editor > Primary Instruction Delivery Method Override Scheduling > Courses > Course > Course Information > Primary Instruction Delivery Method |
| PRIMARY ENL INSTRUCTOR INDICATOR | Identifies the ENL instructors for the course/section. Teaching aides and assistants are not reported. A "Y" in this field will subject the staff to an ESL/ENL certification match as required by State and federal reporting. A Y reports if the Teacher Role is one of the following:
| Alphanumeric, 3 digits | SectionStaffHistory.role | Scheduling > Courses > Section > Staff History > Teacher Role |
| PRIMARY COURSE INSTRUCTION LANGUAGE INDICATOR (PRIMARY INSTRUCTION LANGUAGE CODE) | The Primary language used for providing instruction in the course. For Bilingual courses, this is the language other than English that is being used. | Alphanumeric, 20 characters | Section.mediumOfInstruction | Scheduling > Courses > Course > Section > Section Editor > Primary Instruction Language |
| ALTERNATIVE INSTRUCTION LANGUAGE CODE | This field reports blank. | N/A | N/A | N/A |
INCIDENTAL TEACHING ASSIGNMENT INDICATOR | Identifies whether the staff assignment is an Incidental Teaching assignment. This column reports the value set on the Staff History Detail. If the dropdown list is Null, N reports. | Alphanumeric Y or N | SectionStaffHistory.nonCertified | Scheduling > Courses > Sections > Staff History > State Reporting Fields > Incidental Teaching Assignment |
