Tool Search: SLDS
The CIRS Offenders extract enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data. This extract reports person information for Behavior incidents.
Example Extract EditorReport Logic
This extract reports person information for Behavior incidents when the following are true.
- The related incident date is on or after the first instructional day of the selected calendar.
- The related incident date is on or before the Effective Date selected on the extract editor.
- The selected Role for the person is one of the following: O1, O2, O3, O4, or O5.
Behavior Referrals in Draft status are excluded.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report. |
| Extract Type | 17 CIRS Offenders |
| Effective Date | The date from which data is pulled for the report. |
| Format | Determines the format for the report. Use State Submission when submitting the final data. Use HTML for data review and testing. |
| Report Legal Identities | When this checkbox is marked, Campus reports the legal name entered on the Census > People > Identities tab. If only one part of the Protected Identity Information is entered, that part reports and the other name fields report blank. For example, if the Legal First Name is entered but the middle and last name fields are empty, then only the first name reports and the middle and last names report blank.
|
| Select Calendars | The calendar(s) from which data is pulled for the report. This option is only available when you select HTML for the File Format and can assist you with verifying data for individual calendars. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. |
Report Layout
| Element | Logic | Format and Length | Campus Database | Campus Location | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. | Alphanumeric, 6 characters | District.number | School & District Information > District Information > District Detail > State District Number | ||||||||||||
| off_IDNUM | A unique identifier assigned by the school to each offender involved in an individual incident. | Alphanumeric, 10 characters | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID | ||||||||||||
| Incident_Num | A unique identifier assigned by the school to each incident in a school year. | Numeric, 15 digits | BehaviorEvent.eventID | Student Information > General > Behavior > Behavior Event > Event ID | ||||||||||||
| ENRORGID | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. | Alphanumeric, 6 characters | School.number | School & District Information > School > School Detail > State School Number | ||||||||||||
| off_LastName | The offender's last name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 36 characters | Identity.lastName OR Identity.legalLastName | Census > People > Demographics > Person Information > First Name OR Census > People > Identities > Protected Identity Information > Legal Last Name | ||||||||||||
| off_FirstName | The offender's first name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 20 characters | Identity.firstName OR Identity.legalFirstName | Census > People > Demographics > Person Information > First Name OR Census > People > Identities > Protected Identity Information > Legal First Name | ||||||||||||
| off_MName | The offender's middle name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab. | Alphanumeric, 20 characters | Identity.middleName OR Identity.legalMiddletName | Census > People > Demographics > Person Information > Middle Name OR Census > People > Identities > Protected Identity Information > Legal Middle Name | ||||||||||||
| off_DOB | The month, day, and year on which an offender was born. | Date Field MM/DD/YYYY | Identity.birthdate | Census > People > Demographics > Person Information > Birth Date | ||||||||||||
| off_Grade | The offender's grade level. | Numeric, 2 digits | Enrollment.stateGrade | Student Information > Enrollments > State Reporting Fields > Grade | ||||||||||||
| off_Gender | The offender's gender. Campus reports the gender entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the gender reports from the Demographics tab. | Alphanumeric, 1 character | Identity.gender OR Identity.legalGender | Census > People > Demographics > Person Information > Gender OR Census > People > Identities > Protected Identity Information > Legal Gender | ||||||||||||
| off_Type | The type of offender as it relates to the individual's relationship and status with the reporting institution.
| Alphanumeric, 1 character | BehaviorRole.role | Behavior > Behavior Management > New Participant/Event > Role | ||||||||||||
| off_Injury | Indicates whether an injury was incurred by an offender during an incident and the extent of that injury.
| Alphanumeric, 1 character | BehaviorRole.injury | Behavior > Behavior Management > New Participant/Event > Injury | ||||||||||||
| off_IEP | Indicates whether an offender was on an Individual Education Plan (IEP) at the time the incident occurred. If the Student has a locked IEP with a start date that is on or before the Incident Date, Y reports. Otherwise, N reports. | Alphanumeric, 1 character | Plan | Special Education > IEP | ||||||||||||
| off_ID | A unique identifier assigned by the school to each offender that persists across all incidents in which an offender is involved in a school year. | Alphanumeric, 10 characters | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID | ||||||||||||
| off_AmIndAKNat | Indicates whether the offender is identified as an American Indian or Alaskan Native. | Alphanumeric, 1 character | IdentityRaceEthnicity.identityRaceID RaceEthnicity.code Identity.identityID | Census > People > Demographics > Person Information > Race Ethnicity or Race/Ethnicity | ||||||||||||
| off_Asian | Indicates whether the offender is identified as Asian. | Alphanumeric, 1 character | IdentityRaceEthnicity.identityRaceID RaceEthnicity.code Identity.identityID | Census > People > Demographics > Person Information > Race Ethnicity or Race/Ethnicity | ||||||||||||
| off_Black | Indicates whether the offender is identified as Black or African American. | Alphanumeric, 1 character | IdentityRaceEthnicity.identityRaceID RaceEthnicity.code Identity.identityID | Census > People > Demographics > Person Information > Race Ethnicity or Race/Ethnicity | ||||||||||||
| off_White | Indicates whether the offender is identified as White. | Alphanumeric, 1 character | IdentityRaceEthnicity.identityRaceID RaceEthnicity.code Identity.identityID | Census > People > Demographics > Person Information > Race Ethnicity or Race/Ethnicity | ||||||||||||
| off_Hispanic | Indicates whether the offender is identified as Hispanic. | Alphanumeric, 1 character | Identity.hispanicEthnicity | Census > People > Demographics > Person Information > Race Ethnicity or Race/Ethnicity | ||||||||||||
| off_Hawaiian | Indicates whether the offender is identified as Hawaiian or Other Pacific Islander. | Alphanumeric, 1 character | IdentityRaceEthnicity.identityRaceID RaceEthnicity.code Identity.identityID | Census > People > Demographics > Person Information > Race Ethnicity or Race/Ethnicity | ||||||||||||
| off_Disability | The nature of an offender's disability if the offender is on an Individual Education Plan (IEP) at the time the incident occurred. Otherwise, this field reports blank. | Alphanumeric, 2 characters | Enrollment.diability1 | Student Information > General > Enrollments > Special Ed Fields > Special Ed Status and Primary Disability | ||||||||||||
| off_ELL | Indicates whether an offender was an English Language Learner (ELL) student at the time the incident occurred. | Alphanumeric, 1 character Y or N | lep.programStatus = LEP | Student Information > Program Participation > ELL > Active ELL Record > Program Status | ||||||||||||
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | Calendar.endYear - 1 | N/A |
