SIRS Student Class Entry Exit (New York) [.2215 and previous]

Classic View: NY State Reporting >SIRS Extracts > Student Class Entry Exit

Search Term: SIRS Extract

The Student Class Entry Exit extract reports a record for each roster record a student has in every class.

Student Class Entry Exit Editor

Report Logic

  • A record for each roster record a student has in every class (Course/Section combination) reports.
  • Only records where the student's Enrollment Start Date is less than or equal to the extract editor's Effective Date report.
  • If the student has multiple Enrollments, information reports from the Enrollment with the first Service Type listed below:
  • P: Primary
  • S: Partial
  • N: Special Ed
  • If multiple Enrollments have the same Service Type, information reports from the Enrollment with the most recent Start Date.
  • If multiple Enrollments have the same Start Date, information reports from the Enrollment with the lowest Enrollment ID.
  • Only classes where Course State Code IS NOT NULL report.
  • Only classes where the course is marked as Active report.
  • The class's section must be scheduled in a calendar selected on the extract editor.
  • Records are NOT reported if
    • the enrollment record is marked as State Exclude;
    • the enrollment record is marked as No Show;
    • the Grade Level of enrollment is marked as State Exclude;
    • the Calendar of enrollment is marked as State Exclude;
    • the Enrollment End Date falls before the class starts;
    • the Start Date of the first Term in which the class is scheduled is greater than the extract editor's Effective Date;
    • the student's Roster End Date falls before the first day on which the class is scheduled; OR
    • the student's Roster Start Date is greater than the extract editor's Effective Date.

Extract Editor Field Descriptions

FieldDescription
Extract TypeThe SIRS Extract to be run
Effective DateThe date for which information reports.
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.

Extract Layout

Element NameDescriptionType, Format, and LengthCampus DatabaseCampus Location
DistrictCodeThe identification number of the district. The prefix "NY" is added to the district number. For example, if the district number is 662001, the District Code is NY662001.Numeric, 8 digits

District.number

System Administration > Resources > District Information > District Number

LocationCode

The Location Code of the school to which the class course is tied.

The Enrollment Location Override value reports if it's populated. If the Enrollment Location Override is NULL, the value reports from System Administration > Resources > School > Location Code of the school to which the Class Course is tied.

Numeric, 6 digits

School.locationCode

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

System Administration > Resources > School > Location Code

CourseCodeThe Class's Course Number.

Numeric, 12 digits

Course.number

Scheduling > Courses > Course > Course Number

SchoolYearDateDefault date is June 30 of the reporting school year. For example, if the 1617 Calendar is selected, the School Year Date is 2017-06-30.

Date field, 10 characters

YYYY-MM-DD

Calendar.endDate

System Administration > Calendar > Calendar > Calendar > End Date

SupplementaryCourse
Differentiator
The code used to indicate that the course code is offered in more than one session during the school year. This field reports NA.N/AN/AN/A
SectionCodeThe class section's Section Number.Alphanumeric, 25 charactersSection.numberScheduling > Courses > Section > Section Number
StudentIDThe unique identifier assigned by the Local Education Agency in which the student is enrolled. Reports the student's Local Student Number.Alphanumeric, 10 charactersPerson.studentNumberCensus > Demographics > Local Student Number
ClassEntryDateThe Date on which the student entered the class.

Reports the latest date from the following locations:

  • Student's Roster Start Date
  • Term Start Date of the first Term in which the class is scheduled

Date,  10 characters

YYYY-MM-DD

Roster.startDate

Term.startDate

Scheduling > Courses > Section > Roster > Start Date

System Administration > Calendar > Calendar > Terms > Term Detail > Start Date

ClassEntryTypeCode This field reports blank.N/AN/AN/A
ClassEntryComment This field reports blank.N/AN/AN/A
ClassExitDateProvides the Date on which the Student Exited (is no longer enrolled) in the class. If one of the following dates is less than or equal to the Effective Date entered on the extract editor, the earliest date reports:
  • Student's Roster End Date
  • Term End Date of the last Term the class is scheduled in

Otherwise, this field reports blank.

Date,  10 characters

YYYY-MM-DD

Roster.endDate

Term.endDate

Scheduling > Courses > Section > Roster > End Date

System Administration > Calendar > Calendar > Terms > Term Detail > End Date

ClassExitTypeCode This field reports blank.N/AN/AN/A
ClassExitComment This field reports blank.N/AN/AN/A
ClassPeriod This field reports blank.N/AN/AN/A
CourseDeliveryModelCode This field reports blank.N/AN/AN/A
CourseContentCode This field reports blank.N/AN/AN/A
CourseInclusionCode This field reports blank.N/AN/AN/A
SpecialProgramCode This field reports blank.N/AN/AN/A
AlternateCreditCourseCode This field reports blank.N/AN/AN/A
CourseInstructorSnapshotDate This field reports blank.N/AN/AN/A
HomeroomIndicator This field reports blank.N/AN/AN/A
StudentGradeLevelCodeWhenTaken This field reports blank.N/AN/AN/A
ExcludeFromEvaluationIndicator This field reports blank.N/AN/AN/A
TermCodeThe code used to identify the school calendar term for which a course/section is being reported. The Term Code of the last term in which the class is scheduled reports.Alphanumeric, 20 charactersTerm.stateCodeCalendar > Calendar > Terms > Term Code
MarkingPeriodCode

This field reports NA.

N/A

N/A

N/A

Dual/Concurrent Credit Indicator

Indicates whether the student is taking a course resulting in postsecondary credit toward high school graduation.

  • If the Dual/Concurrent Credit checkbox is marked on the course, Y reports.
    OR
  • If the Dual Credit checkbox is marked on the student's roster, Y reports.

Otherwise, this element reports N.

Alphanumeric, 3 characters

Course.dualEnrollmentCourse

Roster.status

Scheduling > Courses > Course > Dual/Concurrent Credit

Scheduling > Courses > Course > Section > Roster Batch Edit

Student Information > General > Schedule > Walk-in Scheduler > Roster Edit

Student District Code (Course District)This field reports NY and the first six digits of the State District Number tied to the Calendar; e.g., NY123456.Alphanumeric, 8 characters

District.number

System Administration > Resources > District Information > District Number