Location File (A)

The following table shows the CEDARS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Location File (A) State file.

Field #	Field Name	Required?	eSchoolPlus Table	eSchoolPlus Column	Where to Find in eSchoolPlus
A01	School Year	Yes			From the School Year prompt on page
A02	County District Code	Yes	reg	district	Administration > General Setup > District > District (cannot be updated through the software)
A03	District Name	Yes	reg_district	name	Administration > General Setup > District > District (cannot be updated through the software)
A04	Location ID	Yes	reg_building	building	Administration > Registration Setup > Building > Building Definition
A05	School Code	Yes	reg_building	state_code_equiv	Administration > Registration Setup > Building > Building Definition > Preferences panel: State Equivalency Code
A06	School Name	Yes	reg_building	name	Administration > Registration Setup > Building > Building Definition > General panel: Building Name
A07	Initial School Start Date	Yes	reg_cal_days	Earliest cal_date where membership_day = Y If processing a single building, use reg_building.calendar. If running for all buildings, use sec_user.building to determine which reg_building.calendar to reference.	To view detailed calendar information for a single date: Administration > Registration Setup > Calendars > Calendar > click appropriate Calendar link > click View Detail > click link for appropriate calendar date To view a building's Default Calendar: Administration > Registration Setup > Building > Building Definition > Preferences panel: Default Calendar To view your default building: Administration > Security > Users > Security Profile > Profile panel: Default Building
A08	Final School End Date	Yes	reg_cal_days	Latest cal_date where membership_day = Y If processing a single building, use reg_building.calendar. If running for all buildings, use sec_user.building to determine which reg_building.calendar to reference.	To view detailed calendar information for a single date: Administration > Registration Setup > Calendars > Calendar > click appropriate Calendar link > click View Detail > click link for appropriate calendar date To view a building's Default Calendar: Administration > Registration Setup > Building > Building Definition > Preferences panel: Default Calendar To view your default building: Administration > Security > Users > Security Profile > Profile panel: Default Building