Skip to main content
Skip table of contents

A - Location File 2022-2023

Introduction

The Location file contains information about districts with an OSPI assigned County-District Code. Each school with enrolled students in those districts is reported using the OSPI assigned school code. Additional district and school information is collected through the Education Data System (EDS) Profile. The Location file is necessary to link data between the other CEDARS files.

Placeholder records used for programs or sub-sets of schools should not be reported in this file.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to the selection criteria for an analysis of report results in cases where the report does not return the correct records.

School Selection

The report selects records from the [Schools] table that are not excluded from state reporting.

Report Input

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

Field

Description

Scheduling

Select Schedule to run the report on a specific date and time. The default selection is "Run Now."

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.

Item

Data Element

Description

[Table]FieldName

Reqd

Field Type

Length

A01

School Year

The four-digit year in which the school year ends.

[Terms]LastDay

Yes

Char

4

A02

County District Code

The County District code for the district submitting the data.

[Prefs]Value

[Prefs]Name=districtnumber

Yes

Char

5

A03

District Name

The school district name assigned to the county district code.

Data provided in this element is not stored in CEDARS.

[Prefs]Value

[Prefs]Name=districtname

Opt

VarChar

250

A04

Location ID

The Location ID for the school, as generated by the District's Student Information System (SIS).

[Schools]School_Number

Yes

VarChar

4

A05

School Code

The four-digit code assigned to the school by the Office of the Superintendent of Public Instruction (OSPI).

[Schools]AlternateSchoolNumber

else

[Schools]School_Number

Yes

Char

4

A06

School Name

The name of the school.

[Schools]Name

Opt

VarChar

250

A07

Initial School Start Date

The date on which instruction first begins for students.

[Terms]FirstDay

[calendar_day]InSession=1

Yes

Date

10

A08

Last School End Date

The final instructional date on which classes for students are scheduled to end.

[Terms]LastDay

[calendar_day]InSession=1

Yes

Date

10

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.