Discipline Incident Offender
Field # | Field Name | Required? | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPlus? |
---|---|---|---|---|---|---|
1 | Submitting AUN | R | 9 | reg_district.state_equiv_code | reg_district | Menu path: select Administration from the main menu, select General Setup submenu, select District, and then select District. You must select the Preferences panel and then select the Other panel for State Code Equivalent values |
2 | Incident ID | R | disc_incident.incident_id | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail: Incident ID | ||
3 | Offender ID | R | disc_offender.person_id | |||
4 | School Year Date | R | 10 | Prompted value | ||
5 | Offender Type | R | 1 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Offender Type | ||
6 | Age at Time of Incident | CR | 2 | disc_incident.incident_date minus reg.birthdate | Calculated | |
7 | Grade Level at Time of Incident | CR | 3 | reg_grade.state_code_equiv or null/blank if unknown | Menu path: select Registration from the main menu, select Entry & Reports submenu, select Student Demographic, and then select Entry/Withdrawal: Grade | |
8 | LLE Notified Indicator | R | 1 | disc_user 100 Type O field 15 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Reported to Police | |
9 | Name of LLE Office Contacted | CR | 255 | disc_user 100 Type O field 16 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Police Department | |
10 | Arrested Code | R | 2 | disc_user 100 Type O field 3 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Arrested Code | |
11 | Adjudication Code | CR | 1 | disc_user 100 Type O field 6, 9, 10, 11, 12, 13, 14 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Adjudication fields | |
12 | Assigned to Alternative Education Indicator | R | 1 | disc_user 100 Type O field 2 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Alt Education Indicator | |
13 | Weapon Detected Method Code | CR | 1 | disc_user 100 Type O field 4 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Detection of Weapon | |
14 | Weapon Detected Comment | CR | 500 | disc_user 100 Type O field 5 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Weapon Detection Comment | |
16 | Primary Disability Code | CR | 4 | Registration > Entry & Reports > Student Demographic > Emergency > Disability panel: Disability Code & Description | ||
21 | Sending District or Charter AUN | CR | 9 | reg_programs.value where state_code_equiv = ‘RESD’ where DIC_OFFENDER.IS_STUDENT = 'Y' and DISC_OFFENDER.PERSON_ID = REG_PROGRAMS.STUDENT_ID If DISC_OFFENDER.IS_STUDENT = 'N', then field is blank. | Menu path: select Registration from the main menu, select Entry & Reports submenu, select Student Demographic, and then select Programs. | |
22 | Primary Placement Type | CR | 1 | disc_user 100 Type O field 17 | Menu path: select Interventions from the main menu, select All submenu, select Office, and then select Incident Detail. You must click the Detail icon for Offender: Primary Placement |