18_CIRS_Actions

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

ACTION_NUM

Unique id number for action by school.

[PSRW_IncidentAction]ID

Number

15 

 3

INCIDENT_NUM

The incident ID.

[PSRW_IncidentAction]INCIDENT_ID

Number

15 

 4

OFF_IDNUM

Offender ID number by school.

[PSRW_IncidentParticipant]Participant_Number

Number

15

 5

ENRORGID

The enrolling org ID.

[S_VT_Schools_X]EnrOrgID

String

6

 6

ACTION_TYPE

The incident action type.

[PSRW_IncidentAction]State_Detail_Report_Code

Number

2 

 7

ACTION_START_DATE

The incident action start date.

Note: MM/DD/YYYY format.

[PSRW_IncidentAction]Action_Plan_Begin_DT

Date

N/A

 8

ACTION_END_DATE

The incident action end date.

Note: MM/DD/YYYY format.

[PSRW_IncidentAction]Action_Plan_End_DT

Date

N/A

 9

SUSP_RED

Suspension reduction indicator.

[PSRW_IncidentActionAttribute]State_Detail_Report_Code

String

1 

 10

SUSP_LENGTH

The incident suspension length.

[PSRW_IncidentAction]ActualDuration

Number

3,2 

 11 

EXP_SVCS

Expulsion services indicator.

[PSRW_IncidentActionAttribute]State_Detail_Report_Code

String

1 

 12

SY 

The school year.

[S_VT_District_S]SY

Number

4

 13

SECLUSION

Seclusionary timeout indicator.

[PSRW_IncidentActionAttribute]State_Detail_Report_Code

String 

1 

 14

RESTRAINT

Restraint indicator.

[PSRW_IncidentActionAttribute]State_Detail_Report_Code

String

1