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 |