EMIS Receipt Table Report - File Layout and Data Mapping

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

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

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

Column	Column Name	Description	Data Source or Valid Values
A	FUND	The fund code associated with the receipt. 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 Receipt Table form.
B	SPECIAL COST CENTER	The special cost center code that further categorizes the receipt.	Retrieved from the Special Cost Center field on the EMIS Receipt Table form.
C	RECEIPT	The receipt code identifying the type of revenue being reported.	Retrieved from the Receipt field on the EMIS Receipt Table form.
D	SUBJECT	The six-digit EMIS Subject Area code associated with the receipt.	Retrieved from the Subject field on the EMIS Receipt Table form.
E	OPERATIONAL UNIT	The three-digit Operational Unit code identifying which operational unit the receipt is associated with.	Retrieved from the OPU field on the EMIS Receipt Table form.
F	FISCAL YEAR ESTIMATED REVENUE	The estimated revenue amount for the fiscal year.	Retrieved from the Fiscal Year Estimated Revenue field on the EMIS Receipt Table form.
G	FISCAL YEAR ACTUAL RECEIPTS	The actual receipt amount received during the fiscal year.	Retrieved from the Fiscal Year Actual Receipt field on the EMIS Receipt Table form.
H	FISCAL YEAR RECEIVEABLES	The actual receivables amount (amounts owed but not yet received) for the fiscal year.	Retrieved from the Fiscal Year Actual Receivables field on the EMIS Receipt Table form.
I	GEN FUND DEBT-BOND RETIRE FUND	Indicates whether this fund is a general fund debt-bond retirement fund. 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 Receipt Table form.
J	UNIQUE RECORD NUMBER	The system-generated sequential number that uniquely identifies each receipt record.	Retrieved from the Record Number field on the EMIS Receipt Table form.