Location Fact

Field #	Field Name	Required?	Field Length	eSchoolPLUS table.column	Validation Table	Where in eSchoolPlus?
1	Submitting AUN	R	20	disc_incident.district	State Code Equiv from reg_district	Administration > General Setup > District > District > Preferences panel > Other panel: State Code Equivalent
2	School Number	R	12	disc_incident.building	State Code Equiv from reg_building	Interventions > All > Office > Incident Detail: Building
3	School Year Date	R	10	N/A		June 30, current school year. Thus for school year 2019-2020 the date is 06.30.2020
4	Category 1	R	100			Key field not from eSchoolPLUS. Values are TRUANCY, EXPULSION, SUSPENSION: Truant – must have an INCIDENT CODE with a state code equiv of TRUANT Expulsion – must have an INCIDENT CODE with a state code equiv of either C or A and an Offense Action with a state code equiv of S5, S6, or S7 Suspension - must have an INCIDENT CODE with a state code equiv of either C or A and an Offense Action with a state code equiv of S4
5	Category 2	R	100			Key field not from eSchoolPLUS. Values are: GRADE GENDER ETHNICITY
6	Category 3	R	100	Reg_entry_with.grade when Category 2 is GradeReg.gender when Category 2 is Gender. Reg_personal.ethnic_code converted using regtb_ethnicity when Category 2 is Ethnicity	State Code Equiv from reg_grade
7	Category 4	CR	100	Disc_off_code.offense_code	State Code Equiv from disc_incident_code	Required when Category 1 is Expulsion or Suspension. Valid values Academic, Conduct. All offense codes that are academic reported as ACADEMIC. Same for CONDUCT.
8-13	Filler					Not collected
14	Measure Type	R	10	N/A		Use constant “COUNT”
15	Count	R	7,0			Count of students that meet the criteria being reported.