EMIS Expenditure Table Report - File Layout and Data Mapping

The default file names for the EMIS Expenditure Table report are:

PDF:
EMIS Expenditure Table Report_<MMDDYYYY>_<hhmmss>.pdf
Excel:
EMIS Expenditure Table Report_<MMDDYYYY>_<hhmmss>.csv

The following table shows the columns, column names, descriptions, and data source or valid values for the EMIS Expenditure Table report’s .csv file format.

Column	Column Name	Description	Data Source or Valid Values
A	FUND	The three-digit EMIS Fund code that identifies the fund from which the expenditure is made. If the value is 002, the GEN FUND DEBT-BOND RETIRE FUND field value must be Y.	Retrieved from the Fund field on the EMIS Expenditure Table form.
B	SPECIAL COST CENTER	The four-digit EMIS Special Cost Center code that provides additional classification for expenditures within a fund.	Retrieved from the Special Cost Center field on the EMIS Expenditure Table form.
C	FUNCTION	The four-digit EMIS Function code that identifies the purpose or activity for which the expenditure is made.	Retrieved from the Function field on the EMIS Expenditure Table form.
D	OBJECT	The three-digit EMIS Object code that identifies the type of expenditure.	Retrieved from the Object field on the EMIS Expenditure Table form.
E	SUBJECT	The six-digit EMIS Subject Area code that identifies the subject matter associated with the expenditure.	Retrieved from the Subject field on the EMIS Expenditure Table form.
F	OPERATIONAL UNIT	The three-digit EMIS Operational Unit code that identifies the specific operational unit or building associated with the expenditure.	Retrieved from the Operational Unit field on the EMIS Expenditure Table form.
G	INSTRUCTIONAL LEVEL	The two-digit EMIS Instructional Level code that identifies the grade level or instructional level associated with the expenditure.	Retrieved from the Instructional Level field on the EMIS Expenditure Table form.
H	JOB	The three-digit EMIS Job Classification code that identifies the job classification associated with the expenditure.	Retrieved from the Job field on the EMIS Expenditure Table form.
I	PRIOR FISCAL YR ENCUMBERED	The total dollar amount of encumbrances carried forward from the prior fiscal year for this expenditure account.	Retrieved from the Prior Fiscal Year Encumbered field on the EMIS Expenditure Table form.
J	FISCAL YEAR TOTAL APPROPRIATION	The total dollar amount of appropriations (budgeted amounts) for the current fiscal year for this expenditure account.	Retrieved from the Fiscal Year Total Appropriate field on the EMIS Expenditure Table form.
K	FISCAL YEAR ACTUAL EXPENSE	The total dollar amount of actual expenditures incurred during the current fiscal year for this expenditure account.	Retrieved from the Fiscal Year Actual Expenditure field on the EMIS Expenditure Table form.
L	CURRENT ENCUMBERED	The total dollar amount of current encumbrances (outstanding purchase orders and contracts) for this expenditure account.	Retrieved from the Current Encumbered field on the EMIS Expenditure Table form.
M	GEN FUND DEBT-BOND RETIRE FUND	Indicates whether the expenditure is related to General Fund Debt or Bond Retirement. Required if the value in the Fund field is 002.	The valid value is Y if the Fund field contains 002. Retrieved from the General Fund Debt-Bond Retirement field on the EMIS Expenditure Table form.
N	UNIQUE RECORD NUMBER	The system-generated record number unique for the financial record type, reporting period, and fiscal year.	Retrieved from the Record Number field on the EMIS Expenditure Table form.