TB (Textbook Reimbursement) (Indiana)

This report is no longer supported or updated by Infinite Campus. The Indiana flat file reports will remain available in the Infinite Campus system so schools can continue to use them as needed.

Data Exchange was designated as the sole source of truth for all data for the purposes of required reports beginning with the 2021-2022 school year. Please refer to the Indiana Ed-Fi documentation for additional information about current state reporting practices/procedures using the Data Exchange Ed-Fi System. 

Tool Search: Textbook Reimbursement

This data collection gathers information required for textbook reimbursement by identifying 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 FilterSelecting 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 charactersPerson.stateIDCensus > 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/AIdentity.lastNameCensus > People > Demographics > Last Name

First Name

The student's first name.

 

This field is only included in the HTML format.

Alphanumeric, N/AIdentity.firstNameCensus > 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 characterNot dynamically storedCensus > 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 digitsenrollment.GradeStudent 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 charactersFreeReducedApplication.
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 charactersfreeReducedApplication
.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 characterNot 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 characterNot dynamically stored.FRAM > Household Application > Application > No SSN
SchoolIDThe School's ID number.Numeric, 4 digitsSchool.numberSystem Administration > Resources > School > School Detail > State School Number