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: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Notes: If your district uses Sub-District functionality, see Report Input for Sub-District Functionality. The All Schools option is only available when running the report from the District Office.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The Selected [number] of Students Only All Students (default) Note: If running the report for a single student, or group of students, select the students prior to running report.

Back to Top

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 30^th. 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 30^th. 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

Back to Top