Title 1 Extract (Colorado) [.2148 - .2227]

Classic View: CO State Reporting > Data Pipeline > Title 1

Search Terms: Title 1

The Title 1 Data Pipeline report identifies students who receive Title 1 targeted assistance funding. Only students receiving services funded by the Title 1 targeted assistance monies funds are included in the report.

Title 1 Extract

Report Logic

Students who qualify for Title 1 Services at any point during the reporting school year report.

One record is reported for all students who have a Title 1 Service record associated with the school selected in the report editor and enrolled in the selected calendar year. If a student has more than one eligible Title 1 Service, only 1 record is reported.

Report Editor

The following fields are available for selection on the Title 1 Report Editor.

FieldDescription
Report Legal NameWhen marked, the student's name and gender report from the Protected Identity Information section on the student's Identities record.
FormatThe School Association report can be generated in either CSV or HTML formats.
Ad hoc FilterSelect a saved ad hoc filter to only include those students in the filter in the report, assuming those students meet the reporting logic and business rules of this report.
Select School YearSelect a school year in which to generate the report.
Calendar SelectionAt least one calendar needs to be selected in order to generate the report. Reports can be selected by Active Year, School or Year.
Report GenerationThe extract can be generated immediately using the Generate Report button. Or, use the Submit to Batch button to select when the report is generated. See the Batch Queue article for more information on this functionality.

Generate the Report

  1. Mark the Report Legal Name checkbox, if desired.
  2. Select the Format for the report.
  3. If desired, select an Ad hoc Filter.
  4. Select the School Year in which to run the report. 
  5. Select the desired Calendar(s) from which to report Title 1 data.
  6. Click the Generate Extract button, or use the Submit to Batch button. The report generates in the selected format. 

Title 1 Extract - CSV Format

Title 1 Extract - HTML Format

Report Layout

Data ElementDescriptionLocation
District CodeThe number assigned to a school district by the state department of education.

Numeric, 4 digits
System Administration > Resources > District Information > District Information > State District Number

District.number
School CodeNumber assigned to the school building by the Department of Education.

Numeric, 4 digits
System Administration > Resources > School > State School Number

School.number
SASIDA unique number assigned to a student by the Department of Education.

Numeric, 10 digits
Census > People > Demographics > Person Identifiers > Student State ID

Person.stateID
First Name

Reports the student's first name.


When the Report Legal Name checkbox is marked, the student's First Name reports from the Legal First Name field.


Alphanumeric, 30 characters

Census > People > Demographics > Person Information > First Name


Identity.first Name


Census > People > Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

Last Name

Reports the student's last name.


When the Report Legal Name checkbox is marked, the student's Last Name reports from the Legal Last Name field.


Alphanumeric, 30 characters

Census > People > Demographics > Person Information > Last Name


Identity.last Name


Census > People > Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

Gender

Reports the student's gender.

  • 01 - Female
  • 02 - Male

When the Report Legal Name checkbox is marked, the student's Gender reports from the Legal Gender field. 


Numeric, 2 digits

Census > People > Demographics > Person Information > Gender


Identity.gender


Census > People > Identities > Protected Identity Information > Legal Gender


Identity.legalGender

Birth DateStudent's date of birth.

Date field, 8 characters (MMDDYYYY)


Census > People > Demographics > Person Information > Birth Date

Identity.birthDate
Census > People > Identities > Identities Editor > Birth Date

Identity.birthDate
Services - Mathematics

Indicates the student receives Title 1 Services for Mathematics.

  • Reports 0 when Mathematics checkbox is not marked.
  • Reports 1 when Mathematics checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Mathematics

Title1CO.mathematics
Services - Reading/ Language Arts

Indicates the student receives Title 1 Services for Reading/Language Arts.

  • Reports 0 when Reading/Language Arts checkbox is not marked.
  • Reports 1 when Reading/Language Arts checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Reading/Language Arts

Title1CO.readingLanguageArts
Services - Science

Indicates the student receives Title 1 Services for Science.

  • Reports 0 when Science checkbox is not marked.
  • Reports 1 when Science checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Science

Title1CO.science
Services - Social Studies

Indicates the student receives Title 1 Services for Social Studies.

  • Reports 0 when Social Studies checkbox is not marked.
  • Reports 1 when Social Studies checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Social Studies

Title1CO.socialStudies
Services - Vocational/ Career

Indicates the student receives Title 1 Services for Vocational/Career.

  • Reports 0 when Vocational/Career checkbox is not marked.
  • Reports 1 when Vocational/Career checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Vocational/Career

Title1CO.vocationalCareer
Other Instructional Services

Indicates the student receives Title 1 Services for Other Instructional Services.

  • Reports 0 when Other Instructional Services checkbox is not marked.
  • Reports 1 when Other Instructional Services checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Other Instructional Services

Title1CO.otherInstructionalServices
Support Services - Health, Dental and Eye Care

Indicates the student receives Title 1 Services for Health, Dental and Eye Care Services.

  • Reports 0 when Health, Dental and Eye Care Services checkbox is not marked.
  • Reports 1 when Health, Dental and Eye Care Services checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Health, Dental and Eye Care Services

Title1CO.healthDentalEyeCare
Support Services - Guidance/ Advocacy

Indicates the student receives Title 1 Services for Guidance/Advocacy.

  • Reports 0 when Guidance/Advocacy checkbox is not marked.
  • Reports 1 when Guidance/Advocacycheckbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Guidance/Advocacy

Title1CO.guidanceAdvocacy
Support Services - Other Support Services

Indicates the student receives Title 1 Services for Other Support Services.

  • Reports 0 when Other Support Services checkbox is not marked.
  • Reports 1 when Other Support Services checkbox is marked.

Numeric, 1 digit

Student Information > Program Participation > Title 1 > Other Support Services

Title1CO.otherSupportServices