LA EdLink Discipline

Contents

Introduction

This report collects incident and discipline information and creates extract files for submission to the EdLink warehouse. Use PowerSchool's Remote Connection Management feature to set up a SFTP connection to allow for automatic uploading of files to EdLink. Use with the report's scheduling feature to set up a recurring upload of files to EdLink.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table that meet the following criteria:

The student’s school exit date must occur after the school year start date.
The student’s school entry date must occur on or before the school year end date.
The student’s school exit date must occur after their school entry date.
The student, the student’s school, and the student’s school enrollment must not be excluded from state reporting.

Incident Selection

The report selects records from the Incident Management tables that meet the following criteria:

The incident must be associated with the Incident Type “LA State Reporting”.
The incident must have an Offender defined, even if the perpetrator is unknown (such as in the case of graffiti).
The incident must occur within the report date range.
Incidents must have location, time frame and duration values specified.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. Only available when running the report from the District Office. If sub-districts are enabled: Select Sub-district – Select sub-districts to include in the report. To select a single sub-district, click that sub-district. To select multiple schools, use Ctrl+Click and select each sub-district to be included. Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. Only available when running the report from the District Office.
Select Students	Indicate which students to include in the report by selecting one of the following options: The Selected [number] 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 that meet the selection criteria. If you are running the report for a single student, or a group of students, select the students before running the report.
Output File Name	Select the extract to generate.
School Year	Select the school year for which to run the report. The options are controlled by the current Term selected.
Identify as a Partial File	Select Enabled to create and submit an EdLink file containing only a subset of the students without overwriting the complete file or another partial file. This field is unchecked by default. If this field is selected, the word '_partial' and a unique number are added to the end of the file name (e.g. discipline_actions_partial26.txt).
SFTP connection	If the extract is to be automatically uploaded to EdLink, select the SFTP connection that has been defined for reporting to EdLink.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Discipline_Incidents

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
LOCAL_SCHOOL_KEY	The school’s site code. Required.	[S_LA_SCH_X]SiteCode
OFFENSE_DATE	The date of the behavior incident. Required.	[Incident]Incident_TS
OFFENSE_TIME	A code representing the time of the school day that the incident happened.	[Incident_LU_Sub_Code] State_Detail_Report_Code
INCIDENT_ID	The ID number for the global disciplinary incident. This may involve multiple students or none (if a school incident). Required.	[Incident]Incident_ID
DISCIPLINE_INCIDENT_LOCATION	The location where the incident occurred. Required.	[Incident_LU_Sub_Code] State_Detail_Report_Code

Discipline_Incidents_Ext

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
OFFENSE_TIME_CODE	A code representing the time of the school day when the incident happened. Valid values: 01 – Before School (but on grounds) 02 – During Class 03 – Between Classes 04 – After Normal School Hours (while under supervision or at a sponsored activity) 05 – In transit (to or from school) 06 – At the bus stop or transfer station 07 – At Extracurricular Event or Assembly (during normal school hours) 08 – At Recess, club, or free-time period 09 – Homeroom 10 – Breakfast or Lunch 99 – Outside of school hours and supervision	[Incident_LU_Sub_Code] State_Detail_Report_Code

Discipline_Actions

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
LOCAL_DISCIPLINE_ACTION_KEY	A value that uniquely identifies each disciplinary action record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; EventIDNum; PerpetratorIDNum; ActionInterventionCd [Terms]FirstDay [Incident]Incident_ID [Students]State_StudentNumber [PSRW_ParticipantBehaviorAction] State_Detail_Report_Code
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
LOCAL_SCHOOL_KEY	The school’s site code. Required.	[S_LA_SCH_X]SiteCode
LOCAL_STUDENT_KEY	The student’s state-assigned identifier. Required.	[Students]State_StudentNumber
ACTION_DATE	The calendar date the discipline was administered. Required.	[PSRW_ParticpantActionAttr]Date_Attribute
CALENDAR_CODE	The calendar associated with the school and the student. Required.	[S_LA_STU_X]CalendarCode or [S_LA_REN_X]CalendarCode depending on the date of the incident
DISCIPLINE_START_DATE	The date the disciplinary action is to start. Required.	[PSRW_ParticipantBehaviorAction] Action_Plan_Begin_DT
DISCIPLINE_ACTION_TYPE_CODE	The code for the action type assigned in eSIS. Required.	[PSRW_ParticipantBehaviorAction] State_Detail_Report_Code
DISCIPLINE_END_DATE	The date the disciplinary action is to end. Required.	[PSRW_ParticipantBehaviorAction] Action_Plan_End_DT
DISCIPLINE_EXPECT_RETURN_DATE	The date the student is expected to return from disciplinary action such as a suspension or expulsion. This date does not apply to discipline which does not require notable out-of-class time such as time-outs or detention. Required. For suspensions (codes 002, 004, and 006) that are in effect on the last day of school, this field field displays the next day after the school’s last day. For expulsions (codes 003, 005, and 007) that are in effect on the last day of school, this field displays the first day of the next school year.	[PSRW_ParticipantBehaviorAction] Action_Plan_End_DT [PSRW_ParticpantActionAttr]Date_Attribute
DISCIPLINE_SUSPENSION_IND	An indicator of whether the Disciplinary Action is classified as a suspension as defined by the district. Required.	If [PSRW_ParticipantBehaviorAction] State_Detail_Report_Code equals 002, 004, 006, 008, 009, or 010, then "Y" is reported. Otherwise, "N" is reported.
DISCIPLINE_EXPULSION_IND	An indicator of whether the Disciplinary Action is classified as an expulsion as defined by the district. Required.	If [PSRW_ParticipantBehaviorAction] State_Detail_Report_Code equals 003, 005, or 007, then "Y" is reported. Otherwise, "N" is reported.
DISCIPLINE_ACTION_LOCATION	A value that identifies the location when the DISCIPLINE_ACTION_TYPE_CODE indicates an alternate site is involved (e.g., 006 - Suspension - Alternate Site, 007 - Expulsion - Alternate Site, or 010 - Suspension - Alt S (partial day)).	[PSRW_ParticipantBehaviorAction]AlternateSiteCd

Discipline_Actions_Ext

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
LOCAL_DISCIPLINE_ACTION_KEY	A value that uniquely identifies each disciplinary action record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; EventIDNum; PerpetratorIDNum; ActionInterventionCd [Terms]FirstDay [Incident]Incident_ID [Students]State_StudentNumber [PSRW_ParticipantBehaviorAction] State_Detail_Report_Code
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
CP_ADMIN_LAST_NAME	The last name of the person administering the action or intervention. In Incident Management, this is the Corporal Punishment Administrator Last Name. Required.	[PSRW_ParticipantActionAttr]Text_Attribute
CP_ADMIN_FIRST_NAME	The first name of the person administering the action or intervention. In Incident Management, this is the Corporal Punishment Administrator First Name. Required.	[PSRW_ParticipantActionAttr]Text_Attribute
MANIFESTATION_HEARING_DATE	The date that the Manifestation Hearing was held (for SPED students to determine if the behavior was related to disability for removals). Required.	[PSRW_ParticipantActionAttr]Date_Attribute
DISABILITY_RELATED_INDICATOR	An indicator of whether the LEA determined, by an MDR hearing, that the student’s behavior was related to their disability. Required.	[PSRW_ParticipantActionAttr] Is_yes1_no0_attribute
MINUTES_REMOVED	The number of minutes a student was removed from class from their regular setting. Required.	[PSRW_ParticipantActionAttr]Number_Attribute If empty then calculated from [PS_Memberhip_Default]
CP_ADMIN_TYPE_CODE	The role of the person administering corporal punishment. In Incident Management, this is an Action Attribute.	[PSRW_ParticipantActionAttr] State_Detail_Report_Code If Action/Intervention Code = 90, 95, 100, or 180. Otherwise published as blank.
CP_ADMIN_AUTHORIZED_INDICATOR	Indicates whether the corporal punishment was reviewed by a third party and warranted. In Incident Management, this is an Action Attribute.	[PSRW_ParticipantActionAttr] Is_yes1_noo_attribute

Discipline_Offenses

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
LOCAL_DISCIPLINE_OFFENSE_KEY	A value that uniquely identifies each disciplinary offense record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; EventIDNum; PerpetratorIdNum; PrimaryReasonCd [Terms]FirstDay [Incident]Incident_ID [Students]State_StudentNumber [PSRW_ParticipantBehavior]State_Aggregate_RPT_code
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
LOCAL_SCHOOL_KEY	The school’s site code. Required.	[S_LA_SCH_X]SiteCode
LOCAL_STUDENT_KEY	The student’s state-assigned identifier. Required.	[Students]State_StudentNumber
CALENDAR_CODE	Calendar code associated with the school and the student. Required.	[S_LA_STU_X]CalendarCode or [S_LA_REN_X]CalendarCode depending on the date of the incident.
DISCIPLINE_OFFENSE_TYPE_CODE	The code for the primary incident offense type assigned in eSIS. Required.	[PSRW_ParticipantAttr]Incident_Category

Discipline_Offenses_Ext

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
LOCAL_DISCIPLINE_OFFENSE_KEY	A value that uniquely identifies each disciplinary offense record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; EventIDNum; PerpetratorIdNum; PrimaryReasonCd [Terms]FirstDay [Incident]Incident_ID [Students]State_StudentNumber [PSRW_ParticipantBehavior]State_Aggregate_RPT_code
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
WEAPON_FIREARM_TYPE_CODE	A code to describe firearms and explosives weapons. Reported if DISCIPLINE_OFFENSE_TYPE_CODE is 13 or 30. Valid values: 02 - Receiver of Explosive Weapon 03 - Firearm muffler or silencer 04 - Explosive: bomb, grenade, rocket, missle 05 - Explosive weapon: bore one-half inch 06 - Parts that convert devices to explosives 07 - Handguns 08 - Rifles/Shotguns	[PSRW_Participantbehavior]State_Detail_Report_Code
WEAPON_OTHER_TYPE_CODE	A code used to describe a weapon other than an explosive or firearm that was used or found in the course of the event. Reported if DISCIPLINE_OFFENSE_TYPE_CODE is 14, 15, 30, or 31.	[PSRW_Participantbehavior]State_Detail_Report_Code
BULLYING_CODE	Indicates if bullying was involved in the incident. In Incident Management, this is a Participant Attribute Code. Reported when the student's incident behavior code is ‘35 - Bullying’ or '36 - Cyberbullying’	[PSRW_ParticpantBehavior]State_Detail_Report_Code
ELECTRONIC_AGGRESS_INDICATOR	Indicates if the event involved text messages, e-mails, or other forms of electronic communication such as offensive or threatening messages, rumors, degrading images, or assuming someone else’s identity with intent to cause harm. In Incident Management, this is a Participant Attribute Subcode.	[PSRW_ParticipantAttr]Incident_Category
EMOTIONAL_AGGRESS_INDICATOR	An indicator to show if the event was emotional in nature. In Incident Management, this is a Participant Attribute Subcode.	[PSRW_ParticipantAttr]Incident_Category
PHYSICAL_AGGRESS_INDICATOR	An indicator to show if the event had a physical component. In Incident Management, this is a Participant Attribute Subcode.	[PSRW_ParticipantAttr]Incident_Category
VERBAL_AGGRESS_INDICATOR	An indicator to show if the event contained a Verbal component such as name-calling, taunting or ridiculing, mocking, making offensive comments, teasing, demeaning comments, etc. In Incident Management, this is a Participant Attribute Subcode.	[PSRW_ParticipantAttr]Incident_Category
WITNESS_COUNT	The total number of witnesses interviewed in connection with an event.	[PSRW_IncidentParticpant] = Witness (Count)
PHYSICAL_EVIDENCE_CODE	This is the code indicating the primary source of physical evidence of the event. In Incident Management, this is a Participant Attribute Subcode.	[PSRW_ParticipantAttr]State_Detail_Report_Code
PARENT_CONTACTED_INDICATOR	Indicates if a parent was contacted in regards to the event. Required.	[PSRW_ParticipantAttr]Incident_Category
LAW_ENFORCE_REPORT_INDICATOR	Indicates if the event was reported to law enforcement. Required.	[PSRW_ParticipantAttr]Incident_Category
ARRESTED_INDICATOR	Indicates if the event resulted in arrest of the perpetrator, regardless of guilt determination. Required.	[PSRW_ParticipantAttr]Incident_Category
SERIOUS_INJURY_INDICATOR	Indicates if a serious injury to the perpetrator or victim resulted from the event. Required.	[PSRW_ParticipantAttr]Incident_Category

Discipline_Persons

Data Element	Description	[Table]FieldName
LOCAL_DISCIPLINE_INCIDENT_KEY	A value that uniquely identifies each disciplinary incident record submitted. If multiple codes/values are required to uniquely identify an incident within a district and academic year, then the codes are concatenated. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID
LOCAL_DISCIPLINE_PERSON_KEY	A value that uniquely identifies each person involved in a disciplinary event. Required.	Derived as BeginningSchoolSessionYear; SiteCD; EventIDNum; PerpetratorIdNum/VictimIdNum [Terms]FirstDay [S_LA_SCH_X]SiteCode [Incident]Incident_ID [Students]State_StudentNumber
SCHOOL_YEAR	The year of a school session. Required.	[Terms]FirstDay [Terms]LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
LOCAL_STUDENT_KEY	The student’s state-assigned identifier. Required.	[Students]State_StudentNumber
LOCAL_STAFF_KEY	A unique identifier for a staff member within the district applications. Required.	[Teachers]ID
INCIDENT_PERSON_TYPE	The type of person involved in this incident. Required. Valid values: Staff Student	[Incident_LU_SUB_Code]State_Detail_Report_Code
INCIDENT_PERSON_ROLE_TYPE_CODE	This is the code describing the type of victim involved in the event. Required. Valid values: 01 – Student Enrolled at this Site 02 – Student Enrolled at another Site in LEA than where Event transpired or where the Perpetrator attends (i.e., cyber bullying may take place with students from one school harassing other students electronically) 03 – Student Enrolled at a nonpublic Site 10 – Teacher or Instructor (includes coaches and band directors) 13 – Non-Instructional Office Staff (Principal, Counselor, secretary, janitor, cafeteria workers, etc.) 15 – Other LEA Employee not assigned to this Site, exclusively 17 – Contractor or Vendor 20 – Parent or legal guardian of enrolled student 21 – Non-Custodial parent of enrolled student 23 – Other Relative of staff or student other than parent of Victim 99 – Other	[Incident_LU_SUB_Code]State_Detail_Report_Code
INCIDENT_PERSON_IN_DIST_IND	Indicates if this person is either a student or staff within the district.	If person exists in SIS.StudentProfile or PEP.Staff then 'Y' else 'N'
INCIDENT_PERSON_ANON_IND	Indicates if this person is to remain anonymous.	Defaults to "N"
INCIDENT_MEDICAL_TREATMENT_IND	Indicates if this person received medical treatment. Required.	[PSRW_ParticipantAttr]Incident_Category