_id	FIELD_NAME	FIELD_TYPE	DESCRIPTION	NOTES
1	ACCOUNT	VARCHAR(10)	Account ID	Ex: 519722
2	ACCOUNT_NAME	VARCHAR(40)	Account name corresponding to ACCOUNT.	Ex: 'Health Savings Account'
3	AGENCY_NAME_GL	VARCHAR(5000)	Assigned Business Unit name in PeopleSoft.	Ex: 'Dept of Workforce Development'
4	ALT_NAME	VARCHAR(5000)	Assigned name to vendors in PeopleSoft.	""
5	AMOUNT	DECIMAL(26, 3)	The dollar amount of the expenditure.	""
6	BUSINESS_UNIT	VARCHAR(5)	Business unit ID.	Ex: 00510
7	BUSINESS_UNIT_GL	VARCHAR(5)	General ledger assigned business unit ID from PeopleSoft project resource data.	Ex: 00510
8	CFDA_NBR	DECIMAL(5, 3)	Catalog of Federal Domestic Assistance ID.	Ex: '93.354'
9	ETL_RUN_TIMESTAMP	TIMESTAMP(27)	The most recent time this dataset was created or refreshed.	""
10	EXPENDITURE	VARCHAR(1)	A binary flag to indicate whether or not this row was flagged as an expenditure.	Dataset was filterd to only show rows with a value of 'Y', short for yes.
11	EXPEND_SUB_CAT	VARCHAR(20)	The system assigned value for the expenditure account's subcategory.	Ex: 'FRINGE_BENEFITS'
12	EXPEND_SUB_CAT_DESC	VARCHAR(60)	The descriptive value for the expenditure account's subcategory.	Ex: 'Fringe Benefits'
13	FEDERAL_AGENCY	VARCHAR(200)	The Federal Agency corresponding to the CFDA_NBR.	Ex: 'Employment and Training Administration'
14	FISCAL_YEAR	DECIMAL(28, 0)	Fiscal year that the expenditure falls within, based on the JOURNAL_DATE.	Fiscal years run from July 1st to June 30th.
15	FUNCTION_GOVT	VARCHAR(20)	The abbreviated value for the function of government related to the expenditure's funds.	Ex: 'CCD'
16	FUNCTION_GOVT_DESCR	VARCHAR(60)	The descriptive value for FUNCTION_GOVT.	Ex: 'Conservation, Culture and Development'
17	FUNDING_TYPE	VARCHAR(2)	The abbreviated value for the type of funding classification.	Ex: 'ST'
18	FUND_CODE	VARCHAR(5)	The assigned ID for the funding type.	Ex: '62410'
19	FUND_DESCR	VARCHAR(5000)	The descriptive value for FUND_CODE.	Ex: 'DWD DOL Fund'
20	FUND_SOURCE	VARCHAR(6)	The unique ID for the source of the fund.	Ex: '012076'
21	FUND_SOURCE_DESCR	VARCHAR(60)	The descriptive value for FUND_SOURCE.	Ex: 'Federal Funds'
22	JOURNAL_DATE	TIMESTAMP(27)	The date in which the expenditure was recorded.	""
23	JOURNAL_ID	VARCHAR(10)	The unique ID for the journal to record the transaction.	Ex: 'APV6502055'
24	LEGAL_FUND	VARCHAR(20)	The unique ID of the legal fund.	Ex: '8017'
25	LEGAL_FUND_DESCR	VARCHAR(5000)	The descriptive value of the LEGAL_FUND.	Ex: 'Department Of Labor'
26	MAJOR_EXPENSE_CATEGORY	VARCHAR(47)	Assigned categories based on ACCOUNT.	Defined by the State Comptroller
27	PARENT_SHORTNAME	VARCHAR(20)	Parent entity of the FEDERAL_AGENCY.	Ex: 'DOL'
28	PROGRAM_TITLE	VARCHAR(200)	The name of the program corresponding to the CFDA_NBR.	Ex: 'WIOA Dislocated Worker Formula Grants'
29	VENDOR_ID	VARCHAR(10)	The assigned ID of the expenditure's listed ALT_NAME.	Ex: '9948'