SIRS Staff Student Course (New York)

PATH: NY State Reporting > SIRS Extracts > Staff Student Course

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

Students

Staff

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

If the staff member...Then the relationship reports...
does not have a Roster Verification Event associated with the sectionbased on the overlap with the student's roster.
as a Roster Verification Event where the window completely encompasses the section's schedulebased 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 Percentas 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 Percentas 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 Percentas 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

Extract Editor Field Descriptions

FieldDescription
Extract TypeThe SIRS Extract to be run
Effective DateThe date for which information reports.
Assessment Date
Assessment Type
Included State Grade Levels

Identifies the state grade levels to include in the report.

FormatThe 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 HeadersIndicates whether Column Headers should be included in the report. This dropdown list applies to State Format (CSV).
Ignore Enrollment State ExcludeWhen 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 CalendarsIdentifies 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

Local building code used by the Data Warehouse, uniquely identifying the building where the instructor is located.

For course records that tie to a calendar/student who has multiple enrollment records overlapping the time period covered by the course, Campus uses the following hierarchy to determine which override field to use:

  1. P: Primary
  2. S: Partial
  3. N: SPED

If there are multiple enrollments with the same Service Type in this hierarchy, the most recent enrollment is used.

Alphanumeric, 12 characters

CustomSchool.value

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 > Effective 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 Datethe Roster End Date reports. 
the teacher stopped teaching prior to the Assessment Datethe 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/AN/AN/A






Save

Save


Feedback