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 |
|
SASID |
State Assigned Student Identifier |
[Students]State_StudentNumber |
|
FN |
First Name |
[Students]First_Name |
|
LN |
Last Name |
[Students]Last_Name |
|
DOB |
Date of Birth |
[Students]DOB |
|
PST |
Program Status Code |
Auto Calculated |
|
DAT |
Disciplinary Action Taken |
[Incident_Lu_Sub_Code]State_Detail_Report_Code |
|
BI OFF |
Bodily Injury Indicator |
Discontinued |
|
SD |
Start Date of Discipline |
[Incident_Action]Action_Plan_Begin_DT |
|
RD |
Discipline End Date |
[Incident_Action]Action_Plan_End_DT |
|
ERD |
Eligible to Return Date |
Discontinued |
|
DM |
Days Missed |
[Incident_Action]Duration_Assigned |
|
AEINC |
Education Services Indicator |
Discontinued |
|
AE |
Education Services Provided |
Auto Calculated |
|
NAE |
Education Services Not Provided |
Discontinued |
|
ERDX |
Extra Suspension Days |
Discontinued |
|
ARREST |
School-Related Arrest (replaces discontinued ERDX) |
Auto Calculated |
|
APPEAL |
Appeal Indicator |
Discontinued |
|
AEX |
Education Services Description |
Discontinued |
|
SOT1 |
Offense Code 1 |
Auto Calculated |
|
SOT2 |
Offense Code 2 |
Auto Calculated |
|
SOT3 |
Offense Code 3 |
Auto Calculated |
|
SOT4 |
Offense Code 4 |
Auto Calculated |
|
SOT5 |
Offense Code 5 |
Auto Calculated |