SSDR - Incident Record
The following table contains the SSDR fields provided by the Massachusetts Department of Education, the associated title, and the location in the PowerSchool database where the field is found.
MA Field | Title | PS DB Location |
|---|---|---|
OFF ID | Incident ID | [Incidents]Incident_ID |
OFF DATE | Incident Date | [Incidents]Incident_TS |
SCH NAME | School Name | [Schools]Name |
SCH CODE | School Code | [Incident]School_Number |
OFF IND | Offense Indicator | Hardcode value Y |
DISC IND | Discipline Indicator | Y/N value based on Incident_Action.Incident ID |
OT1 | Offense Code 1 | Logical field - Auto Calculated based on the Incident. |
OT2 | Offense Code 2 | Logical field - Auto Calculated based on the Incident. |
OT3 | Offense Code 3 | Logical field - Auto Calculated based on the Incident. |
OT4 | Offense Code 4 | Logical field - Auto Calculated based on the Incident. |
OT5 | Offense Code 5 | Logical field - Auto Calculated based on the Incident. |
VS | Count of Student Victims | Logical field - Auto Calculated based on the Incident. |
VSCHP | Count of School Personnel Victims | Logical field - Auto Calculated based on the Incident. |
VNSCHP | Count of Non-School Personnel Victims | Logical field - Auto Calculated based on the Incident. |
VU | Count of Unknown Victims | Logical field - Auto Calculated based on the Incident. |
OFFES | Count of Student Offenders | Logical field - Auto Calculated based on the Incident. |
OFFENS | Count of Non-Student Offenders | Logical field - Auto Calculated based on the Incident. |
OFFEU | Count of Unknown Offenders | Logical field - Auto Calculated based on the Incident. |
OFF DESC | Description for Offense Code 1 | Logical field - Auto Calculated based on the Incident. |
PHYS INJ | Physical Injury Indicator | Logical field - Auto Calculated based on the Incident. |
OFF DESC2 | Description for Offense Code 2 | Logical field - Auto Calculated based on the Incident. |
OFF DESC3 | Description for Offense Code 3 | Logical field - Auto Calculated based on the Incident. |
OFF DESC4 | Description for Offense Code 4 | Logical field - Auto Calculated based on the Incident. |
OFF DESC5 | Description for Offense Code 5 | Logical field - Auto Calculated based on the Incident. |
INC DESC | Incident Description | Incident.Incident_Detail_Desc |