TX Interchange Finance

The interchange schema for Finance information is used to exchange financial data such as actual, budget, and shared services arrangement actual.

Report Input

Each of the available run options and data fields for the report are described below.

Field	Description
Collection Code	Choose the Collection from the pop-up menu for the report generated. This option controls the naming of the file. FALL1 is for Submission 1, FALL2 is for Re-Submission, and FALL3 is for Working Collection, MDYR1, MDYR2, and MDYR3 are for the Mid-Year collections.
School Year	Choose the school year. This value is used in the file name as well as determining which year to use for the data extraction.
Run Now	Select this option if the user wants to run the report immediately.
Schedule	Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

Report Output: XML for PEIMS

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.

Filename for PEIMS:

The filename must be in the following format:

District Code: Position 1-6

Underscore: Position 7, 11, 21 and 34.

Campus ID: Position 8-10 – If the file is generated by a user from the District Office, this value is 000. If the file is generated by a user from a school, this value is the three-digit campus id for that user. This allows partial files to be submitted that contain data only for one school.

Collection Code: Position 12-20. This starts with the ending year of the school year followed by the five characters Collection Code (i.e. FALL1).

Timestamp: Position 22-33 – This is YYYYMMDDHHMM where YYYY is year, MM is month, DD is day, HH is hour, and MM is minute.

Interchange: Position 35 starts the name of the Interchange – InterchangeFinanceExtension.xml

Data Element	Description	Collection
Budget Extension
	TX LEA Reference
	Educational Org Identity
State Organization ID	District Number	FALL1, FALL2, FALL3
TX-Fiscal Year	The fiscal year for this record.	FALL1, FALL2, FALL3
TX-Amount	The budget amount for this record.	FALL1, FALL2, FALL3
TX-Fund Code	The fund code for this record.	FALL1, FALL2, FALL3
TX-Function Code	The function code for this record.	FALL1, FALL2, FALL3
TX-Object Code	The object code for this record.	FALL1, FALL2, FALL3
TX-Organization Code	The organization code for this record.	FALL1, FALL2, FALL3
TX-Program Intent Code	The program intent code for this record.	FALL1, FALL2, FALL3
Actual Extension
	TX LEA Reference
	Educational Org Identity
State Organization ID	District Number	MDYR1, MDYR2, MDYR3
TX-Fiscal Year	The fiscal year for this record.	MDYR1, MDYR2, MDYR3
TX-Amount	The actual amount for this record.	MDYR1, MDYR2, MDYR3
TX-Fund Code	The fund code for this record.	MDYR1, MDYR2, MDYR3
TX-Function Code	The function code for this record.	MDYR1, MDYR2, MDYR3
TX-Object Code	The object code for this record.	MDYR1, MDYR2, MDYR3
TX-Organization Code	The organization code for this record.	MDYR1, MDYR2, MDYR3
TX-Program Intent Code	The program intent code for this record.	MDYR1, MDYR2, MDYR3