Austin Finance Online eCheckbook Column Definitions

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id 567b-4d24
Name Austin Finance Online eCheckbook Column Definitions
Attribution City of Austin Financial Services
Category Financial
Tags financial, echeckbook, checkbook, transparency, expenses, expenditures, finance, payment, checks, payments, austin finance online
Created 2013-11-18T22:42:38Z
Publication Date 2014-04-15T22:12:32Z

Description

Column definitions for the lat file data set - Austin Finance Online eCheckbook - found on the data portal . The data contained in this dataset is for informational purposes only. Please visit the Austin Finance Online website for a searchable front end to this data set.

Columns

| Included | Schema Type | Field Name       | Name                   | Data Type | Render Type |
| ======== | =========== | ================ | ====================== | ========= | =========== |
| No       | time        | :updated_at      | updated_at             | meta_data | meta_data   |
| Yes      | series tag  | data_portal_code | eCheckbook Column Name | text      | text        |
| Yes      | series tag  | definition       | Definition             | text      | text        |
| Yes      | series tag  | notes            | Notes                  | text      | text        |

Time Field

Value = updated_at
Format & Zone = seconds

Data Commands

series e:567b-4d24 d:2013-11-18T14:42:41.000Z t:definition="Fiscal Year" t:data_portal_code=FY_DC t:notes="Fiscal year is from Oct. 1 - Sep. 30" m:row_number.567b-4d24=1

series e:567b-4d24 d:2013-11-18T14:42:41.000Z t:definition="Fiscal Month" t:data_portal_code=PER_CD t:notes="Oct is PER_CD = 1, Sept is PER_CD = 12" m:row_number.567b-4d24=2

series e:567b-4d24 d:2013-11-18T14:42:41.000Z t:definition="Department code" t:data_portal_code=DEPT_CD t:notes="A department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department." m:row_number.567b-4d24=3

Meta Commands

metric m:row_number.567b-4d24 p:long l:"Row Number"

entity e:567b-4d24 l:"Austin Finance Online eCheckbook Column Definitions" t:attribution="City of Austin Financial Services" t:url=https://data.austintexas.gov/api/views/567b-4d24

property e:567b-4d24 t:meta.view v:id=567b-4d24 v:category=Financial v:attributionLink=https://www.austintexas.gov/financeonline/checkbook/index.cfm v:averageRating=0 v:name="Austin Finance Online eCheckbook Column Definitions" v:attribution="City of Austin Financial Services"

property e:567b-4d24 t:meta.view.owner v:id=t5rb-t58r v:screenName=Chris v:displayName=Chris

property e:567b-4d24 t:meta.view.tableauthor v:id=t5rb-t58r v:screenName=Chris v:roleName=publisher v:displayName=Chris

Top Records

| :updated_at | data_portal_code | definition                   | notes                                                                                                                                                                                                                                                                                                                                                                        | 
| =========== | ================ | ============================ | ============================================================================================================================================================================================================================================================================================================================================================================ | 
| 1384785761  | FY_DC            | Fiscal Year                  | Fiscal year is from Oct. 1 - Sep. 30                                                                                                                                                                                                                                                                                                                                         | 
| 1384785761  | PER_CD           | Fiscal Month                 | Oct is PER_CD = 1, Sept is PER_CD = 12                                                                                                                                                                                                                                                                                                                                       | 
| 1384785761  | DEPT_CD          | Department code              | A department is a primary organizational unit used by the City of Austin. Examples of various departments are Parks and Recreation and Austin Police Department.                                                                                                                                                                                                             | 
| 1384785761  | DEPT_NM          | Department name              |                                                                                                                                                                                                                                                                                                                                                                              | 
| 1384785761  | FUND_CD          | Fund code                    | A fund is a high level chart of accounts structure. Funds help organize the City's finances. Some examples include the General Fund, Drainage Fund, and the Airport Operating Fund.                                                                                                                                                                                          | 
| 1384785761  | FUND_NM          | Fund name                    |                                                                                                                                                                                                                                                                                                                                                                              | 
| 1384785761  | DIV_CD           | Division code / Program Code | A program is the secondary organizational unit used by the City of Austin. Each department has one or more programs within it. For example, Parks and Recreation have Acquatics, Cultural Arts Services, Facilities Services, etc. A program can be an organizational entity within a department, or an administrative entity in which expenses can be captured and tracked. | 
| 1384785761  | DIV_NM           | Division name / Program Name | Program Name                                                                                                                                                                                                                                                                                                                                                                 | 
| 1384785761  | GP_CD            | Group Code/Activity Code     | An activity is a sub-group under programs that further segregates the organization to track the City of Austin's functions and expenses.                                                                                                                                                                                                                                     | 
| 1384785761  | GP_NM            | Group Name/Activity Name     | Activity Name                                                                                                                                                                                                                                                                                                                                                                |