When you submit the ED166 Disciplinary Offense Record extract, the state will return the file with state-assigned incident numbers entered in the State Incident Tracking Number field. After receiving this file, you can import the discipline incidents into PowerSchool.
Before importing the file, verify the following:
-
There is no header record in the import file.
-
There are no extraneous blank fields or blank padded fields in the import file.
-
The file format is comma-delimited and the extension is .txt.
Use the following table for creating the import file.
|
Column Header |
Definition |
Related PowerSchool Field |
|---|---|---|
|
State Assigned Student ID (SASID) |
The state-assigned student number. |
[Students]State_StudentNumber |
|
Date of Birth |
The student's date of birth. |
[Students]DOB |
|
Reporting District |
The state-assigned reporting district. |
[Prefs]Value (where [Prefs]Name=districtnumber) |
|
Facility Code |
The state-assigned facility/school code. |
[S_CT_LOG_X]FacilityCodeOverride [Log]CT_Facility_Code_1 [Schools] Alternate_School_Number [S_CT_STU_X]FacilityCode1 [Students]SchoolID [Schools]School_Number |
|
Local Incident Number |
The unique identifier assigned to the incident by the district. |
[S_CT_LOG_X]LocalIncidentNumber |
|
Date of Incident |
The date the incident occurred. |
[S_CT_LOG_X]IncidentDate |
|
Time of Incident |
The time the incident occurred. |
[S_CT_LOG_X]IncidentTime |
|
Bullying |
Identify if this incident involves Bullying |
[S_CT_LOG_X]BullyingFlag |
|
Incident Type – part 1 |
The primary type of incident. |
[S_CT_LOG_X]IncidentType1 |
|
Incident Type – part 2 |
The secondary type of incident, if applicable. |
[S_CT_LOG_X]IncidentType1 |
|
Weapon Involvement |
The weapon involved in the incident, if applicable. |
[S_CT_LOG_X]WeaponInvolvement |
|
Substance Involvement |
The appropriate code if the discipline offense involved the suspicion, possession, or use of drugs, alcohol, or tobacco. |
[S_CT_LOG_X]SubstanceInvolvement |
|
Victim – Other Student |
Y if the student was a victim in the incident. |
[S_CT_LOG_X]OtherStudentVictim |
|
Victim – Certified Staff |
Y if a certified staff member was a victim in the incident. |
[S_CT_LOG_X]CertifiedStaffVictim |
|
Victim – Substitute Teacher |
Y if a substitute teacher was a victim in the incident. |
[S_CT_LOG_X]SubstitueTeacherVictim |
|
Victim – Other Staff |
Y if another staff member was a victim in the incident. |
[S_CT_LOG_X]OtherStaffVictim |
|
Victim – Non-School |
Y if a non-school person was a victim in the incident. |
[S_CT_LOG_X]NonSchoolVictim |
|
Arrested |
Y if a student arrest was part of the incident. |
[S_CT_LOG_X]StudentArrested |
|
Location of Incident |
The location of the incident. |
[S_CT_LOG_X]OffenseLocation |
|
School Sponsored Activity |
Y if the incident occurred at a school-sponsored activity. |
[S_CT_LOG_X]SchoolSponsoredActivity |
|
Sanction Type (part 1) |
The most severe type of sanction/discipline the student received for his/her offense. |
[S_CT_LOG_X]SanctionType1 |
|
Education Provided (part 1) |
The type of education provided to the student involved in the incident. |
[S_CT_LOG_X]EducationProvided1 |
|
Number of Days Sanctioned (part 1) |
The number of days the student was suspended or expelled. |
[S_CT_LOG_X]DaysSanctioned1 |
|
Number of Days Served (part 1) |
The number of days the student served sentence. |
[S_CT_LOG_X]DaysServed1 |
|
Number of Days to Carryover (part 1) |
The number of days sanctioned that the student carried over to the new school year. |
[S_CT_LOG_X]DaysServedCarryover1 |
|
Sanction Type (part 2) |
The code for the most severe type of sanction/discipline the student received for their secondary offense. |
[S_CT_LOG_X]SanctionType2 |
|
Education Provided (part 2) |
The code for the type of education the student received during their secondary out-of-school suspension or expulsion. |
[S_CT_LOG_X]EducationProvided2 |
|
The number of partial/full days the student is assigned for their secondary offense. |
[S_CT_LOG_X]DaysSanctioned2 |
|
The number of partial/full days the student served for this secondary offense. |
[S_CT_LOG_X]DaysServed2 |
|
The number of partial/full days the student will serve in the following school year. |
[S_CT_LOG_X]DaysServedCarryover2 |
|
Referring Party |
The party that referred the student for discipline. |
[S_CT_LOG_X]ReferringParty |
|
Party Taking Action |
The party responsible for initiating the sanction. |
[S_CT_LOG_X]PartyTakingAction |
|
Memo field |
Additional details about the incident. |
[S_CT_LOG_X]IncidentMemo |
|
Incident Tracking Number (ITN) |
The state-assigned incident number used to track the discipline incident. |
[S_CT_LOG_X]StateIncTrackNumber |
|
District Student ID |
The district-assigned student number. |
[Students]Student_Number |
|
Reserve |
The log ID assigned to the incident in PowerSchool. |
[Log]ID |
|
End of Record Marker |
An X marks the end of each record in the file. |
N/A |