SIRS Staff Student Course (New York)

Classic View: NY State Reporting >SIRS Extracts > Staff Student Course

Search Term: SIRS Extract

The Staff Student Course extract reports the details about the relationship between a staff member and a student in a class (course/section). These details can be used as part of the evaluation of each staff member.

Staff Student Course Editor

Reporting Logic

  • Overlapping relationship details report for each staff and student in classes (Course/Section combination)
  • Only classes where the Course State Code maps to a value found in the following table report.

    Assessment Type Reports Students in Courses with these State Codes
    January Regents

    02052CC, 02056CC, 02072CC, 02106

    3-8 ELA

    51031, 51032, 51033, 51034, 51035, 51036

    3-8 Mathematics

    02052CC, 02056CC, 02072CC, 02106, 52033, 52034, 52035, 52036, 52037, 52038

    June Regents

    02052CC, 02056CC, 02072CC

  • Only Active courses report.
  • To report, the class's Section must be scheduled in a Calendar selected on the extract editor.
  • A record does not report if the Start Date of the first Term in which the class is scheduled is greater than the extract editor's Effective Date.
  • Records do not report if the Calendar is marked as Exclude.

Students

  • A record reports for each roster record a student has. If a student re-enrolls into a class that they previously dropped, each roster record reports separately.

  • Student's are NOT included if

    • their enrollment record is marked as State Exclude;

      This rule does not apply if Ignore Enrollment State Exclude is marked on the extract editor.

    • their enrollment End Date falls before the class starts;
    • their roster Start Date or Enrollment Start Date, whichever is later, is greater than the extract editor's Effective Date;
    • their enrollment record is marked as No Show;

    • their Grade Level of enrollment is marked as State Exclude; or

    • their Calendar of enrollment is marked as State Exclude.

Staff

  • A record reports for each Staff History record a staff member has.
  • Staff are NOT included if
    • their Teacher Role is 99: Exclude from State Reporting;
    • their Staff History Staff Type is  Section Staff;
    • their Staff History End Date falls before the the class starts;
    • their Staff History Start Date is greater than the extract editor's Effective Date.
  • If a class has multiple staff members, a record is produced for each student with their associated relationship dates.
  • If a staff member is reassigned to a class that they previously dropped, each Staff History record reports separately.

Roster Verification Examples

If a Roster Verification Event only partially overlaps courses, the event is treated as a separate relationship if the staff member has a Roster Verification Event where

  • the Code is SSC AND

  • the event overlaps but does not completely encompass a staff-student course roster relationship AND

  • the Staff History Detail Percent does not equal the Roster Verification Amount OR is Null and the Roster Verification Amount = 100.
    Otherwise, only the relationships found on the Staff History report.

If the staff member... Then the relationship reports...
does not have a Roster Verification Event associated with the section based on the overlap with the student's roster.
as a Roster Verification Event where the window completely encompasses the section's schedule based on the overlap with the student's roster.
has a Roster Verification Event where the window covers the first half of the section's schedule and the Amount differs from Staff History Percent as two records using the Roster Verification Event's Window End Date as the last day of that relationship.
has a Roster Verification Event where the window covers the second half of the section's schedule and the Amount differs from Staff History Percent as two records using the Roster Verification Event's Window Start Date as the first day of that relationship.
has a Roster Verification Event where the window falls in the middle of the section's schedule and the Amount differs from Staff History Percent as three records using the Roster Verification Event's Window Start Date and End Date as that relationship's start date and end date. The Roster Verification Event acts as an override event, splitting the single Staff History Record into two halves on either end.

How Student Instructional Time is Calculated and Reported

  • Only attendance codes given the status of Absent are subtracted from the scheduled course time. The calculation for this report does not include other statuses.
  • Excuse types do not affect the calculation.
  • Present Minutes can be assigned on the student Attendance tool. However, the only time they are accounted for is when the assigned Attendance Code is mapped to a status of Absent.

Extract Editor Field Descriptions

Field Description
Extract Type The SIRS Extract to be run
Effective Date The date for which information reports.
Assessment Date
Assessment Type
Included State Grade Levels

Identifies the state grade levels to include in the report.

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).
Ignore Enrollment State Exclude When this checkbox is marked, enrollment records with "State Exclude" selected ARE included.

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.

Staff Student Course Extract Layout

Element Name

Description

Type, Length and Format

Campus Database

Campus Location

Staff District Code

The code that identifies the district that employs the teacher. The prefix "NY" is added to the first six digits in the State District Number field. For example, if the district number is 662001123456, the District Code is NY662001.

Alphanumeric, 8 characters

District.number

System Administration > Resources > District Information > State District Number

Staff ID

A Staff ID is a unique number assigned to individuals employed by a school or district.

If the Staff ID is less than 9 digits, the field is left padded with zeros.

Numeric, 12 digits

Person.staffStateID 

Census > Demographics > Person Identifiers > Staff State ID

Student District Code

The code that identifies the district. The prefix "NY" is added to the first six digits in the State District Number field. For example, if the district number is 662001123456, the District Code is NY662001.

Alphanumeric, 8 characters

District.number

System Administration > Resources > District Information > State District Number

Student ID

The student's Local Student Number.

Alphanumeric,12 characters

Person.studentNumber

Census > People > Demographics > Person Identifiers > Local Student Number

School Year Date

This field always reports as "June 30" of the reported school year.

Date field, 10 characters
yyyy-06-30

Calendar.endDate

System Administration > Calendar > Calendar > End Date (year only)

Course District Code

The code that identifies the district. The prefix "NY" is added to the first six digits in the State District Number field. For example, if the district number is 662001123456, the District Code is NY662001.

Alphanumeric, 8 characters

District.number

System Administration > Resources > District Information > State District Number

Course Location Code

The Location Code of the School to which the Course is tied. If the Enrollment Location Override is NULL, the value reports from System Administration > Resources > School > Location Code.

Alphanumeric, 12 characters

CustomSchool.value

Student Information > General > Enrollments > State Reporting Fields > Location Override

System Administration > Resources > School > Location Code

Course Code

Local course code.

The Scheduling > Courses > Course > Course Number field accepts 13 characters; however, this report only includes the first 12 numbers from that field.

Alphanumeric, 12 characters

Course.number

Scheduling > Courses > Course > Course Number

Supplementary Course Differentiator

This field reports "NA."

Alphanumeric, 3 characters

N/A

N/A

Section Code

Local section code.

Alphanumeric, 25 characters

Section.number

Scheduling > Courses > Section > Section Number

Reporting Date

The Assessment Date selected on the editor when generating the report.

Date field, 10 characters
yyyy-mm-dd

N/A

NY State Reporting > SIRS Extracts > Assessment Date

Relationship Start Date

This field reports the student's start date of enrollment in the section.

If the date is after the Effective Date entered on the extract editor, a record does not report.

Date field, 10 characters
yyyy-mm-dd

Startdate.startDate

Scheduling > Courses > Course > Section > Roster > Start Date

Relationship End Date

The last day where the teacher AND student are both tied to the course. The Assessment Date reports unless one of the following occurs.

If... Then...
the student dropped the class before the Assessment Date the  Roster End Date reports. 
the teacher stopped teaching prior to the Assessment Date the primary teacher's Staff History End Date reports.

 

Date field, 10 characters
yyyy-mm-dd

Roster.endDate

Calendar.endDate

NY State Reporting > SIRS Extracts > Assessment Date

Scheduling > Courses > Sections > Section > Roster > End Date

Staff History > End Date

Potential Student Instructional Time (Enrollment Linkage Duration)

The sum of the scheduled instructional minutes from the   Relationship Start Date  to the  Relationship End Date   if the dates are before the Assessment Date selected on the report editor. If the Relationship End Date and the Assessment Date are the same, Campus uses the day before the Assessment Date for the calculation.

 Lunch time minutes are not included in this calculation. 

Calendar Days must be marked as BOTH Instructional AND Attendance to be included in this calculation.

Numeric, 8 characters

N/A

N/A

Actual Student Instructional Time (Attendance Linkage Duration)

This field reports the potential student instructional time minus the minutes the student was absent. For example, if the potential minutes equal 300 and the student was absent for 50 minutes, this field reports 250.

Student instruction minutes are calculated from the Relationship Start Date to the Relationship End Date if the dates are before the Assessment Date. If the Relationship End Date is the same as the Assessment Date, the minutes are calculated from a day before the Assessment Date.

Calendar Days must be marked as BOTH Instructional AND Attendance to be included in this calculation.

  • If the Calendar Day's Start Time is not NULL, period minutes that fall before the entered time for that day are not included. If the Calendar Day's Start Time falls in the middle of a period, the calculation uses the Calendar Day Start Time instead of Period Start Time to calculate that period's instructional minutes for that day (Period End Time - Day Start Time - Period Lunch minutes).
  • If the Calendar Day's End Time is not NULL, period minutes that fall after the entered time for that day are not included. If the Calendar Day's End Time falls in the middle of a period, Calendar Day End Time is used instead of Period End Time to calculate that period's instructional minutes for that day (Day End Time - Period Start Time - Period Lunch minutes).
  • If the Calendar Day's Start Time and End Time are not NULL AND both fall within the same period, the Calendar Day Start Time and End Time are used instead of Period Start Time and End Time to calculate that period's instructional minutes for that day. (Day End Time - Day Start Time - Period Lunch minutes).
  • Manually entered Present Minutes cannot exceed the calculated instructional minutes for the day. Period instructional minutes cannot be less than zero.

Numeric, 8 characters

N/A

N/A

Instructional Responsibility Weight (Linkage Duration Adjustment)

This field reports the percentage of class time the teacher is directly responsible for instructing the student.

When the Roster Verification Detail is SSC (System Administration > Roster > Roster Verification Event Log > Roster Verification Detail) and the Instruction Percent is not null (Campus Instruction > Roster Verification > Instructional Percent) the Instruction Percent reports.

If the Instruction Percent is null, the value from Scheduling > Courses > Section > Staff History > Percent reports.

If both areas are null, the default value "1" reports.

Numeric, 6 characters

RosterVerification
Request.code

RosterVerification
SectionStudent.amount

SectionStaffHistory.
percent

System Administration > Roster > Roster Verification Event Log > Roster Verification Detail

Instruction > Roster Verification > Instructional Percent

Scheduling > Courses > Sections > Staff History

 Exclude From Evaluation Indicator 

This field reports blank.

 N/A 

N/A

N/A

Total Planned Class Time (Course Duration through Assessment Reporting Date)

The total scheduled instructional minutes from the course Start Date to the day before the Assessment Date selected in the extract editor.

Calendar Days must be marked as BOTH Instructional AND Attendance to be included in this calculation.

Numeric, 8 characters

N/A

N/A

Term Code

The Term Code from the final term of the calendar; e.g., 1-7. If a calendar's Summer School checkbox is marked, this field reports S.

Alphanumeric, 20 characters

Term.stateCode

System Administration > Calendar > Term > Term Code

Instructional Relationship Weight  This field reports blank. N/A N/A N/A






Save

Save