046 – Student Disciplinary Action
Introduction
This extract includes a record for each disciplinary log entry created for students during the current school year. You need to set up the Reporting Discipline mode to capture data from either the Log types/log entry fields or the Incident management fields. Set up the Reporting Discipline mode in Start Page > District Setup > District Info > Reporting Discipline. Depending on the discipline mode selected this report will publish data.
Report Input
For help with navigation and extract generation, see Create Selected Student Related Extract File.
Extract Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Length | Track |
|---|---|---|---|---|---|
1 | Record ID | The identifier of this record. | Always "046" | 3 | N |
2 | Record Version | The version of this record. | Always "01" | 2 | N |
3 | Record Type | One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data:
| N/A | 1 | N |
4 | Filler | N/A | N/A | 2 | N |
5 | District ID | The district number. | [Prefs]Value [Prefs]Name=districtnumber | 3 | N |
6 | School ID | The school number. | [Schools]Alternate_School_Number - if populated Otherwise: [Log]SchoolID | 4 | N |
7 | School Year | The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information. | [Terms]FirstDay [Terms]LastDay | 4 | N |
8 | Instructional Program Number | The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06. | [Students]Track | 2 | N |
9 | Student Social Security Number | The student's social security number. | [Students]SSN | 9 | N |
10 | Student PIN | The student's PIN, if the social security number is not provided or reported. | [S_TN_STU_X]StudentPIN | 9 | N |
11 | Local Student Key | The internal ID assigned to the student's record in the PowerSchool database. | [Students]ID | 10 | N |
12 | Disciplinary Action Type | The disciplinary action taken as a result of the student's incident. Refer to the Appendix for valid values. Note: If state reportable and non-state reportable actions are associated with an incident, the state reportable action is extracted in the report. In case of multiple state reportable actions associated with an incident, all state reportable actions and their associated elements (behavior, attributes) will pull on the 046 as one record per SR action/behavior association. | [Log]Discipline_ActionTaken OR [Inicident]Incident_ActionTaken | 1 | Y |
13 | Disciplinary Begin Date | The date that the disciplinary action began. | [Log]Discipline_ActionDate | 8 | Y |
14 | Disciplinary End Date | The date that the disciplinary action ended. | [Log]Discipline_ActionTakenEndDate | 8 | Y |
15 | Disciplinary Primary Reason | The type of incident requiring discipline that occurred. Note: All state reportable behavior, actions, and their associated attributes are pulled on the 046 extract even if none of them are marked as primary while creating the incident. | [Log]Discipline_IncidentTypeCategory OR [incident]Behavior — PSRW_INCIDENTBEHAVIOR.State_detail_report_code =17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, or 38 | 2 | Y |
16 | Disciplinary Offense Date | The date that the incident occurred that caused one or more disciplinary actions. | [Log]Discipline_IncidentDate OR [incident]Date — psrw_incident.incident_ts | 8 | Y |
17 | State Assigned Student ID | The student's state assigned identifier. | [Students]State_Studentnumber | 9 | N |
18 | Zero Tolerance Indicator | Indicates if the act falls under a zero tolerance policy. | [S_TN_LOG_X]ZeroTolerance_YN OR [Inicident]ZeroTolerance_YN | 1 | Y |
19 | SE Modified Action | Indicate if the Action is modified as a result of Special Education status. | [S_TN_LOG_X]ModifiedAction_YN | 1 | Y |
20 | SE Disciplinary Action Authority | Indicate if the SE Disciplinary Action Authority is involved. | [S_TN_LOG_X]DisciplinaryActAuthority | 1 | Y |
18 | Filler | N/A | N/A | 8 | N |