{
  "fields": [{"id":"_id","type":"int"},{"id":"FIELD_NAME","type":"text"},{"id":"FIELD_TYPE","type":"text"},{"id":"DESCRIPTION","type":"text"},{"id":"NOTES","type":"text"}],
  "records": [
    [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'"]
]}