academy:midyear_submission

State Reporting > Crosswalks

Build any necessary local crosswalk tables. For LEAs that adhere to the Financial Accounting Resource (FAR) Guide for account coding, crosswalk tables are generally not used. See online Help for more information.

Crosswalks are retained from year to year. If tables exist from prior years, ensure that they are up to date.
Crosswalk tables must be created or updated before they are used.

For the midyear submission, the following tables can be used:

059 Actual - Fund/SO to Prog
060 Actual - Fund to Fund
061 Actual - Org to Org
062 Actual - Obj to Obj
063 Actual - Fund to Prog
064 Actual - Func to Func
066 Actual - Fund/Func/SO to Prog
067 Actual - Funds not to report
070 Actual - Fund/Prog to Prog

Crosswalk Type	Select the crosswalk table for which you want to convert data.

The selected crosswalk table is displayed. The list can be re-sorted.

You can re-sort the grid by clicking on an underlined column heading. It will sort in ascending order. Click it again to sort in descending order.

A white triangle next to the column heading indicates the column by which the grid is currently sorted and whether it is sorted in ascending or descending order.
A blank row is added to the bottom of the grid.

Row Nbr	The rows are automatically numbered.
From	Type the district code you want to convert.
To	Type the TEA format code to which you want to convert. The From and To values must be different.

❏ Click +Add to add a new row.

❏ Click Save.

Print	Print the crosswalk report. Review the report using the following buttons: Click to go to the first page of the report. Click to go back one page. Click to go forward one page. Click to go to the last page of the report. The report can be viewed and saved in various file formats. Click to save and print the report in PDF format. Click to save and print the report in CSV format. (This option is not available for all reports.) When a report is exported to the CSV format, the report headers may not be included. Click to close the report window. Some reports may have a Close Report, Exit, or Cancel button instead.
Retrieve	Retrieve data from the last save. Discard unsaved changes, and retrieve information since the last time data was saved.
	Delete a row. Click to delete a row. The row is shaded red to indicate that it will be deleted when the record is saved. Click Save.