Skip to main content
Skip table of contents

A - Location File 2019-2020

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 13 CEDARS files.

Note: 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 selection criteria for analysis of report results when 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

Default is Run Now. Select Schedule to run the report on a specific date and time.

Report Output

Each of the fields displayed in the output of the report are 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.

Note: 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 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

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.