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