This dataset has the following 47 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| UniqueId | uniqueid | text | 163154-18208277-33360-1-1-159343 71353-828876-11255-3242-5665-71391 124812-10515198-30856-352-352-122812 142666-14250284-11204-2936-4437-141274 148937-15456191-14015-1-1-147229 view top 100 |
| Entity | entity | text | City Charter Schools view top 100 |
| CharacterCode | charactercode | text | 5B 4I 5C 5A 4Q view top 100 |
| CharacterCodeDescription | charactercodedescription | text | OPERATING SPECIAL ASSESSMENTS CAPITAL OUTLAY SALARIES & BENEFITS MISCELLANEOUS view top 100 |
| ObjectCode | objectcode | text | 552199 540105 546103 534120 552113 view top 100 |
| Object | object | text | Other Operating Mat & Supplies Travel Costs Building Maintenance Outside Services Uniforms view top 100 |
| OrganizationCode | organizationcode | text | 51130501 00121001 00170005 00122045 40036011 view top 100 |
| Organization | organization | text | FacMgmt PW FacMaint Public Works GenFnd Police PolAdmin GenFnd Parks ParksMaint DCD view top 100 |
| ProjectCode | projectcode | text | NDEG FP PMED LM CL view top 100 |
| Project | project | text | UNKNOWN Non-Degree Festival Park Paramedic Sub Lot Mowing view top 100 |
| FullAccount | fullaccount | text | 511-30501-546103-30-51-519030-000-000- 001-21001-540105-21-52-521030-000-000- 421-81311-425102-81-71-325100-000-000- 516-30511-534120-30-51-519030-000-000- 421-81211-425102-81-71-325100-000-000- view top 100 |
| FundCode | fundcode | text | 001 400 511 171 440 view top 100 |
| Fund | fund | text | General Fund Water & Sewer Fund Facilities Management Fund Park & Rec Program Fund Stormwater Fund view top 100 |
| Segment2Code | segment2code | text | 30 70 36 21 22 view top 100 |
| Segment2 | segment2 | text | Public Works Parks & Rec Utilities Police Fire view top 100 |
| Segment3Code | segment3code | text | 30501 21001 22045 70005 70125 view top 100 |
| Segment3 | segment3 | text | Facility Maintenance Police Administration Fire - Operations Parks Maintenance William Austin Youth Center view top 100 |
| Segment4Code | segment4code | text | 000 100 213 401 505 view top 100 |
| Segment4 | segment4 | text | No Future Non Program Specific Special Events Gift Shop Sales Creative Cub Care view top 100 |
| Segment5Code | segment5code | text | 000 view top 100 |
| Segment5 | segment5 | text | No Future2 view top 100 |
| Segment6Code | segment6code | text | 51 56 70 52 53 view top 100 |
| Segment6 | segment6 | text | General Government Parks & Recreation Water & Sewer Operations Public Safety Police Public Safety Fire view top 100 |
| Segment7Code | segment7code | text | 521030 572030 519030 522030 513030 view top 100 |
| Segment7 | segment7 | text | Law Enforcement - OP Parks/Recreation - OP Other General Government - OP Fire Control - OP Financial and Admin - OP view top 100 |
| Segment8Code | segment8code | text | -1 view top 100 |
| Segment8 | segment8 | text | UNKNOWN view top 100 |
| AccountType | accounttype | text | Expense Revenue view top 100 |
| AccountStatus | accountstatus | text | Active Inactive view top 100 |
| FiscalYear | fiscalyear | number | 2023 2021 2022 2024 view top 100 |
| FiscalPeriod | fiscalperiod | number | 7 6 3 4 5 view top 100 |
| Date | date | calendar_date | 2023-04-17T00:00:00.000 2023-09-30T00:00:00.000 2021-09-30T00:00:00.000 2022-09-30T00:00:00.000 2022-11-30T00:00:00.000 view top 100 |
| VendorId | vendorid | text | 999999 1643 1681 99993 1899 view top 100 |
| InvoiceId | invoiceid | text | 113288 149391 102421 153428 164268 view top 100 |
| Description | description | text | FIRST AID AND SAFETY EQUIPMENT FOODS: STAPLE GROCERY AND GROC ROAD AND HIGHWAY ASPHALT AND C ELECTRIC SERVICE JANITORIAL SUPPLIES, GENERAL L view top 100 |
| EntryType | entrytype | text | D C view top 100 |
| VendorName | vendorname | text | P-CARD ONE TIME PAYMENT BANK OF AMERICA JM TODD INC ASSESSMENT REFUND ONE TIME PAY LOWES view top 100 |
| InvoiceStatus | invoicestatus | text | Paid Void Approved view top 100 |
| PaymentCheckNumber | paymentchecknumber | text | 0 1543 1923 1390 1980 view top 100 |
| Actual | actual | number | 90.00 318.02 584.55 50.00 237.37 view top 100 |
| Department | department | text | view top 100 |
| DepartmentGroup | departmentgroup | text | view top 100 |
| FunctionDescription | functiondescription | text | view top 100 |
| FunctionGroup | functiongroup | text | view top 100 |
| FundGroup | fundgroup | text | view top 100 |
| VendorType | vendortype | text | ENGINEERS MERCHANDISE AUTO REPAIR AND MAINTENANCE UTILITIES CONTRACTORS view top 100 |
| Employee | employee | checkbox | false view top 100 |