17_CIRS_Offenders

Field

Description

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

• All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Select Students

Choose one of the following:

• The Selected [x] Students Only – Run the report for students in the current selection.

• All Students – Run the report for all students in the current school or district.

Start Date

Enter the start date for the report date range.

End Date

Enter the end date for the report date range.

File Path

Enter the file path. If applicable, select the associated checkbox to save as the default value.

Data Collection Name

Choose the applicable Data Collection from the pop-up menu.

• 03_NightlyCollection_Unofficial

• 04_YearEndCollection_Official

SFTP Connections

Choose a selection from the pop-up menu. The default value is Disable.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

 1

ADMINID

The district's SU/SD ID.

[S_VT_District_S]AdminID

String

6

 2

OFF_IDNUM

Offender ID number by school

[PSRW_IncidentParticipant]ID

Number

10

 3

INCIDENT_NUM

The incident ID.

[PSRW_IncidentParticipant]Incident_ID

Number

15

 4

ENRORGID

The enrolling org ID.

[S_VT_Schools_X]EnrOrgID

String

6

 5

OFF_LASTNAME

The offender's last name.

[PSRW_IncidentParticipant]Last_Name

String

36

 6

OFF_FIRSTNAME

The offender's first name.

[PSRW_IncidentParticipant]First_Name

String

20 

 7

OFF_MNAME

The offender's middle name.

[PSRW_IncidentParticipant]Middle_Name

String

20

 8

OFF_DOB

The offender's date of birth.

Note: MM/DD/YYYY format.

[PSRW_IncidentParticipant]DOB

Date

N/A 

 9

OFF_GRADE

The offender's grade level.

[PSRW_IncidentParticipant]Grade_Level

String

2 

 10

OFF_GENDER

The offender's gender.

[PSRW_IncidentParticipant]Gender

String

1

 11 

OFF_TYPE

Code set for type of offender.

[PSRW_IncidentAttribute]State_Detail_Report_Code

Number

1 

 12

OFF_INJURY

Offender injury during incident.

[PSRW_IncidentAttribute]State_Detail_Report_Code

Number

1 

 13

OFF_IEP

The offender's IEP at the time of the incident. DECIDED offender on IEP at time of incident

[S_VT_STU_X]IEP

String 

1 

 14

OFF_ID

The offender's state assigned student ID, if known.

[Students]State_StudentNumber

Number

10

 15

OFF_AMINDAKNAT

Native American offender indicator.

[StudentRace]

[TeacherRace]

String

1

 16

OFF_ASIAN

Asian offender indicator.

[StudentRace]

[TeacherRace]

String

1

 17

OFF_BLACK 

Black offender indicator.

[StudentRace]

[TeacherRace]  

String

1

 18

OFF_WHITE 

White offender indicator.

[StudentRace]

[TeacherRace]  

String

1

 19

OFF_HISPANIC 

Hispanic offender indicator.

[StudentRace]

[TeacherRace]  

String 

1

 20

OFF_HAWAIIAN 

Hawaiian offender indicator.

[StudentRace]

[TeacherRace]  

String 

1

 21

OFF_DISABILITY 

Code set for offender disability.

[ParticipantAttributeCode]State_Detail_Report_Code 

Number

2

 22

OFF_ELL 

The offender's ELL status.

[StudentCoreFields]LEP_Status

String

1

 23

SY

The school year.

[S_VT_District_S]SY

Number

4