At-Risk Interchange File

Introduction

The At-Risk Interchange File reports the census block data (state, county, track, and block codes) associated with each student’s primary physical address. This data is required for the neighborhood socioeconomic status index information to implement the new at-risk measure. This new measure is implemented and included in the Total Program funding calculation as described in the Public-School Finance Act, which will continue to utilize student-level data reported through the Student October Count data collection.

Note: This report should be run after the process for the Bulk Update of Census Block Data has been run.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] or [ReEnrollments] table based on the following criteria:

The student is not flagged as Exclude from State Reporting.
The school is not flagged as Exclude from State Reporting.
The student's school enrollment falls within the Report Start and End Dates.
The student enrollment status must be “0” or “-1”.

Report Input

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

Field	Description
Select Schools*	Select one, all or a selection of Schools. A school selection will only be offered at District Office. When running at a school, only that school will be available.
Select Students*	Indicate which students to include in the report by selecting one of the following options: The Selected x Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running the report.
Mode	The following report modes are available: State Submission Status Report (not for submission) When the report is run in the Status Report mode, an additional column Census_Status from the student extension table is appended to the report output.

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.

Data Element	Description	[Table]FieldName	Required (R)/Optional (O)	Field Length
DISTRICT_CODE	Reporting School District Code (CDE state district code)	District Number from District Info Page	R	4
SASID	Student’s State ID (SASID)	State ID (SASID) from Student's CO State Information Page	R	10
STATE_CODE	State Code (two-digit state code, as defined by the US census bureau)	To be fetched from Geocode API call and stored in DB. These fields will be displayed in read-only mode on the CO Demographics Page.	R	2
COUNTY_CODE	County Code (three-digit county code, as defined and returned by the US census bureau)		R	3
TRACT_CODE	Tract Code (six-digit track number, which is a small relatively permanent statistical subdivision of a county)		R	6
BLOCK_CODE	Block Code (four-digit block code, which is a statistical area bounded by both visible and nonvisible features and is small in area)		R	4

Note: If there is no value for any of the above elements, zero is displayed in the output. Leading zeros are filled to meet the field length requirement.

Output Format

The report is generated in the CSV format and the output file name format is - At-Risk_File_[DistrictNumber_or_School_Abbr]_[Timestamp].

Back to Top