Flat file data set of the data found in the Austin Finance Online eCheckbook application. The data contained in this dataset is for informational purposes only and contains expenditure information for the City of Austin. Certain Austin Energy transactions have been excluded as competitive matters under Texas Government Code Section 552.133 and City Council Resolution 20051201-002; therefore, the line amounts may not reflect the total check amount if certain Austin Energy invoices were included on the check. Please visit the Austin Finance Online website for a searchable front end to this data set.
This dataset has the following 34 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
FY_DC | fy_dc | text | 2009 2010 2011 2016 2015 view top 100 |
PER_CD | per_cd | number | 1 6 11 12 3 view top 100 |
DEPT_CD | dept_cd | number | 63 22 78 56 11 view top 100 |
DEPT_NM | dept_nm | text | Watershed Protection Austin Water Fleet Services Communications & Technology Management Austin Energy view top 100 |
FUND_CD | fund_cd | text | 4850 8641 8560 5330 4975 view top 100 |
FUND_NM | fund_nm | text | Drainage Cip GGCIP - Communications and Technology Mgmt GCP-General Govt Proj Floodplain Home Buyout Program E-Capital Equipment Additions view top 100 |
DIV_CD | div_cd | text | ZZZZ 0250 9501 5101 9MGT view top 100 |
DIV_NM | div_nm | text | Miscellaneous Critical Technology Replace Buyout Parent Fy2001 Support Services Parent Support Services view top 100 |
GP_CD | gp_cd | text | ZZZZ SUPP 9502 DIST 9ADM view top 100 |
GP_NM | gp_nm | text | Miscellaneous Support Services Onion Creek-$60M Distribution Departmental Support Services view top 100 |
OCAT_CD | ocat_cd | number | 158 view top 100 |
OCAT_NM | ocat_nm | text | Non-CIP Capital view top 100 |
OBJ_CD | obj_cd | text | 9031 9051 9045 9003 9001 view top 100 |
OBJ_NM | obj_nm | text | Vehicle/Motored Equipment Other Equipment Computer Hardware Land-Relocation Cost Land view top 100 |
LGL_NM | lgl_nm | text | SILSBEE FORD INC PHILPOTT MOTORS LTD INSIGHT PUBLIC SECTOR INC DELL MARKETING LP CALENCE L L C view top 100 |
VEND_CUST_CD | vend_cust_cd | text | MIS0000004 V00000918757 PHI8312538 DEL1512250 COM7062925 view top 100 |
VEND_CUST_IND | vend_cust_ind | text | V view top 100 |
RFED_DOC_CD | rfed_doc_cd | text | PRM GAX PRC TPP view top 100 |
RFED_DOC_DEPT_CD | rfed_doc_dept_cd | number | 7800 5600 6300 1100 2200 view top 100 |
RFED_DOC_ID | rfed_doc_id | text | 09030219718 14040418939 17072428342 10030416393 11011911010 view top 100 |
COMM_CD | comm_cd | text | 57863 92045 20464 2045373 20811 view top 100 |
COMM_DSCR | comm_dscr | text | Real Estate: Land and Improvements Software Maintenance/Support Network Components: Adapter Cards, Bridges, Connec Trucks (One Ton and Less Capacity) SERVERS, FILE, MICROCOMPUTER view top 100 |
CHK_EFT_ISS_DT | chk_eft_iss_dt | date | 2009-03-03T00:00:00.000Z 2017-07-25T00:00:00.000Z 2010-03-05T00:00:00.000Z 2014-04-07T00:00:00.000Z 2011-10-11T00:00:00.000Z view top 100 |
CVL_CHK_STA_DV | cvl_chk_sta_dv | text | Paid Outstanding Escheat view top 100 |
RFED_VEND_LN_NO | rfed_vend_ln_no | number | 1 view top 100 |
RFED_COMM_LN_NO | rfed_comm_ln_no | number | 1 0 2 3 4 view top 100 |
RFED_ACTG_LN_NO | rfed_actg_ln_no | number | 1 2 3 4 5 view top 100 |
RF_DOC_CD | rf_doc_cd | text | DO CT PO DOM CTM view top 100 |
RF_DOC_DEPT_CD | rf_doc_dept_cd | text | 7800 5600 1100 2200 6400 view top 100 |
RF_DOC_ID | rf_doc_id | text | 13110500071 11050300928 14112500113 16120100103 19032208198 view top 100 |
ACTG_LN_DSCR | actg_ln_dscr | text | Land-Relocation Cost Real Estate: Land and Improvements Software Maintenance/Support Land Network Components: Adapter Cards, Bridges, Connec view top 100 |
AMOUNT | amount | number | 25901.87 800 30831.25 30293 25327.71 view top 100 |
CAL_YEAR | cal_year | text | 2009 2010 2011 2016 2015 view top 100 |
CAL_MONTH | cal_month | number | 10 3 8 9 12 view top 100 |