PATH: IN State Reporting > TB
This data collection gathers information required for Textbook Reimbursement by retrieving information on students who are eligible to receive free or reduced-price meals through the United States Department of Agriculture (USDA). In Indiana, students who are eligible for free meals under the USDA program are entitled to free textbooks and this collection is the funding mechanism.
TB - Textbook Reimbursement Report Editor
Report Logic
- Students report when they have an active enrollment as of the Effective Date selected on the report editor.
- Students in State Grade: PK do NOT report.
- Enrollments marked as State Excluded or No Show will not be reported.
Report Editor Details
Editor Field |
Description |
|---|---|
Effective Date |
The date from which data is pulled for the report. |
| Ad Hoc Filter | Selecting an Ad hoc Filter returns only those students who are included in that filter and meet the reporting requirements of the report itself. |
Format |
The format in which the report will generate. Options include Fixed Width, HTML, Comma Separated and XML. HTML, CSV and XML formats are used for data review and verification, while Fixed Width should be used when submitting reports to the state. |
Calendars |
The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year. |
Report Examples
CSV Example
Fixed Width Example
HTML Example
Report Layout
|
Element Name |
Description |
Type, Format and Length |
Campus Database |
Campus Application |
|---|---|---|---|---|
Student STN |
A student's unique test number assigned to a student by the state Department of Education. | Number, 9 characters | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
Last Name |
The student's last name. This field is only included in the HTML format. |
Alphanumeric, N/A | Identity.lastName | Census > People > Demographics > Last Name |
First Name |
The student's first name. This field is only included in the HTML format. |
Alphanumeric, N/A | Identity.firstName | Census > People > Demographics > Person Information > First Name |
LiveParents |
This field indicates whether the student is living with their parents and reports Y or N. |
Alphanumeric, 1 character | Not dynamically stored | Census > People > Relationships > Primary Household |
| Grade | The student's grade level. If the student has multiple enrollments in the current year and calendar, the Primary Enrollment reports first, then the secondary and finally the special ed enrollment. |
Numeric, 2 digits | enrollment.Grade | Student Information > General > Enrollments Tab > General Enrollment Information > Grade |
AppNumber |
The reference number for the FRAM Household Application. This field is only included in the HTML format. |
Alphanumeric, | freeReducedApplication .referenceNumber |
FRAM > Household Application > Application > SNAP/ FDPIR/TANF # OR FRAM > Household Application > Application > Ref # |
TANF |
The SNAP, FDPIR, or TANF number. |
Alphanumeric,16 characters | FreeReducedApplication. householdAssistanceCode |
FRAM > Household Application > Application > Case Number |
SSN |
The last 4 digits of the Social Security Number of an Adult Household Member. If the No Signer SSN checkchmark is selected OR no Adult Household Members have an SSN entered on their Demographics tab, this field reports blank.
|
Numeric, 4 characters | freeReducedApplication .NoSSN |
FRAM > Household Application > Application > App Sign > Last 4 digits FRAM > Household Application > Application > No Signer SSN Census > People > Relationships > Primary Household > Guardian Census > People > Demographics > SSN |
FreeMeal |
Indicates whether the student has any records scheduled for Free/Reduced Meals. If the FRAM Eligibility record for the student is active on the report's Effective Date, this field reports Y; otherwise, this field reports N. |
Alphanumeric, 1 character | Not dynamically stored. | FRAM > Eligibility > Eligibility |
NoSSN |
Indicates whether the social security number is included on the application. If the SSN element reports blank, this field reports Y. If the SSN field is populated, N reports. |
Alphanumeric, 1 character | Not dynamically stored. | FRAM > Household Application > Application > No SSN |
| SchoolID | The School's ID number. | Numeric, 4 digits | School.number | System Administration > Resources > School > School Detail > State School Number |
