042 – Student Ineligibility Funding Status

Introduction

This extract includes a record for each student with an ineligibility funding status.

Report Input

For help with navigation and extract generation, see Create Selected Student Related Extract File.

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

Item #	Data Element	Description	[Table]FieldName	Field Length	Track
1	Record ID	The identifier of this record.	Always "042"	3	N
2	Record Version	The version of this record.	Always "01"	2	N
3	Record Type	One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data: N – New E – Edit D – Delete	N/A	1	N
4	Filler	N/A	N/A	2	N
5	District ID	The district number.	[Prefs]Value [Prefs]Name=districtnumber	3	N
6	School ID	The school number. If the student has a concurrent enrollment, then the concurrent school number is reported, otherwise the primary school number is reported.	[Schools]Alternate_School_Number - if populated Otherwise: [Students]Enrollment_SchoolID [S_TN_STU_ConcurrentEnroll_C]PrimarySchoolID	4	N
7	School Year	The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information.	[Terms]FirstDay [Terms]LastDay	4	N
8	Instructional Program Number	The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06. If the student has a concurrent enrollment, then the concurrent track is reported, otherwise the primary track is reported.	[Students]Track [S_TN_STU_ConcurrentEnroll_C]ConTrack (Service School Instructional Program Number)	2	N
9	Student Social Security Number	The student's social security number.	[Students]SSN	9	N
10	Student PIN	The student's PIN, if the social security number is not provided or reported.	[S_TN_STU_X]StudentPIN	9	N
11	Local Student Key	The internal ID assigned to the student's record in the PowerSchool database.	[Students]ID	10	N
12	Fund Inelig Status	Indicates whether the student is eligible for state funding. Valid values: 0 – Not Excluded 1 – Excluded – Out-of-State 2 – Excluded – I20 Student	[S_TN_STU_X]FundIneligStatus	1	Y
13	Fund Inelig Being Date	The start date for this funding status.	[S_TN_STU_X]FundIneligBeginDate	8	Y
14	Fund Inelig End Date	The end date for this funding status.	[S_TN_STU_X]FundIneligEndDate	8	Y
15	State Assigned Student ID	The state assigned student identifier.	[Students]State_Studentnumber	9	N
16	Filler	N/A	N/A	11	N

Back to Top