Title I Extract
Contents
Introduction
The Title I extract is used to track the various Title I services that may be received by a student. The extract is generated in a comma-delimited format.
Selection Criteria
Selection criteria determine which database records are used in the report.
Student Selection
The Student Summary Attendance extract includes student records from the [Students] table that meet the following criteria:
- Students who are not excluded from state reporting.
- Students who are enrolled in a school that is not excluded from state reporting.
- Students whose school enrollment Exit Date is after the report start date.
- Students whose school enrollment Entry Date is on or before the report end date.
- Students whose school enrollment Exit Date is after the Entry Date.
- Students who are a participant in at least one Title I program (at least one Title I Program field on the Title I State Student page has a value of Yes saved in the database).
Report Input
For help with navigation and report generation, see How to Find and Generate a Report.
Field | Description |
Data to be Filled | Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All. |
Select Schools
| Choose one of the following:
Notes:
|
Current Selection Students | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
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.
Element # | Data Element | Description | [Table]FieldName |
1 | District Code | NDE Number for the district. | [Prefs]Name=districtnumber [Prefs]Value |
2 | School Year | This value is automatically extracted as June 30th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. Extracted in the format YYYY-MM-DD. | [Terms]LastDay |
3 | Student ID | State assigned student number. | [Students]State_StudentNumber |
4 | Reporting Date | This value is automatically extracted as June 30th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. Extracted in the format YYYY-MM-DD. | [Terms]LastDay |
5 | Title I Reading ELA | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Part_Code_RELA |
6 | Title I Math | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Part_Code_Math |
7 | Title I Science | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Part_Code_Sci |
8 | Title I Civics Govt. | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Part_Code_CG |
9 | Title I History | Not collected. | N/A |
10 | Title I Geography | Not collected. | N/A |
11 | Title I Other | Not collected. | N/A |
12 | Title I Counseling Social Work | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Part_Code_GCSW |
13 | Title I Health Dental | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Part_Code_HD |
14 | Title I Nutrition | Not collected. | N/A |
15 | Title I Pupil Transportation | Not collected. | N/A |
16 | Title I Job Preparation | Not collected. | N/A |
17 | Title I GED | Not collected. | N/A |
18 | Title I Environment Code | Value indicates neglected or delinquent under Title I Part A or Title I Part D. | [S_NE_STU_TITLEI_X]T1_Environment |
19 | Title I General Tutoring | Not collected. | N/A |
20 | Title I Early Childhood Ed | Valid values: Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [Students]NE_T1EarlyChildhoodEd |
21 | Title I Vocational Career | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLEI_X]T1_Voc_Career |
22 | Title I Support Other | Valid values: Y – 1 N – 2 If the field is not populated, the value is 2. | [S_NE_STU_TITLE1_X]TA_Support_Other |
23 | Title I Instructional Other Desc | Not collected. | N/A |
24 | Title I Support Other Desc |
| [S_NE_STU_TITLEI_X]T1_Support_Other_Desc |