Skip to main content
Skip table of contents

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:

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

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.