EMS - Monthly Finance Measures

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id 2mb6-tu96
Name EMS - Monthly Finance Measures
Attribution Austin-Travis County EMS
Category Public Safety
Tags ems, atcems, revenue collection, business processes, finance, administration
Created 2017-02-02T22:36:13Z
Publication Date 2017-02-02T22:38:14Z

Description

This table contains performance data related to ATCEMS revenue collection processes.

Columns

| Included | Schema Type    | Field Name                                   | Name                                    | Data Type     | Render Type   |
| ======== | ============== | ============================================ | ======================================= | ============= | ============= |
| Yes      | numeric metric | month_key                                    | Month Key                               | number        | number        |
| Yes      | time           | month_start_date                             | Month-Year                              | calendar_date | calendar_date |
| Yes      | numeric metric | count_patients_billed                        | Count - Patients Billed                 | number        | number        |
| Yes      | numeric metric | average_bill_processing_days                 | Average Bill Processing Interval        | number        | number        |
| Yes      | numeric metric | average_bill_processing_days_target          | Average Bill Processing Interval Target | number        | number        |
| Yes      | numeric metric | percent_county_revenue_collected_fytd        | County Revenue Collected FYTD           | percent       | percent       |
| Yes      | numeric metric | percent_county_revenue_collected_fytd_target | Target - County Revenue Collected FYTD  | percent       | percent       |

Time Field

Value = month_start_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Data Commands

series e:2mb6-tu96 d:2013-10-01T00:00:00.000Z m:percent_county_revenue_collected_fytd_target=100 m:average_bill_processing_days=4.783532 m:count_patients_billed=7627 m:percent_county_revenue_collected_fytd=115.17 m:average_bill_processing_days_target=10 m:month_key=201310

series e:2mb6-tu96 d:2013-11-01T00:00:00.000Z m:percent_county_revenue_collected_fytd_target=100 m:average_bill_processing_days=5.443706 m:count_patients_billed=5871 m:percent_county_revenue_collected_fytd=100.67 m:average_bill_processing_days_target=10 m:month_key=201311

series e:2mb6-tu96 d:2013-12-01T00:00:00.000Z m:percent_county_revenue_collected_fytd_target=100 m:average_bill_processing_days=6.343944 m:count_patients_billed=6754 m:percent_county_revenue_collected_fytd=105.45 m:average_bill_processing_days_target=10 m:month_key=201312

Meta Commands

metric m:month_key p:integer l:"Month Key" d:"Year and month for record in <yyyymm> format (e.g. 201407). This format is useful for sorting records." t:dataTypeName=number

metric m:count_patients_billed p:integer l:"Count - Patients Billed" d:"Count of patient bills generated by ATCEMS billing personnel for the month." t:dataTypeName=number

metric m:average_bill_processing_days p:float l:"Average Bill Processing Interval" d:"Average number of days between patient contact and generation of first bill for the month." t:dataTypeName=number

metric m:average_bill_processing_days_target p:integer l:"Average Bill Processing Interval Target" d:"Performance target for the average number of days between patient contact and generation of first bill for the month." t:dataTypeName=number

metric m:percent_county_revenue_collected_fytd p:float l:"County Revenue Collected FYTD" d:"Percent of anticipated revenue for Travis County collected for the fiscal year to date. Anticipated revenue is based on the Patient Fees-Ground Transport revenue listed in the Travis County budget, divided by 12 to obtain a monthly average, and then summed for the completed months of the fiscal year." t:dataTypeName=percent

metric m:percent_county_revenue_collected_fytd_target p:integer l:"Target - County Revenue Collected FYTD" d:"Performance target for percent of anticipated revenue for Travis County collected for the fiscal year to date." t:dataTypeName=percent

entity e:2mb6-tu96 l:"EMS - Monthly Finance Measures" t:attribution="Austin-Travis County EMS" t:url=https://data.austintexas.gov/api/views/2mb6-tu96

property e:2mb6-tu96 t:meta.view v:id=2mb6-tu96 v:category="Public Safety" v:averageRating=0 v:name="EMS - Monthly Finance Measures" v:attribution="Austin-Travis County EMS"

property e:2mb6-tu96 t:meta.view.owner v:id=4zcf-8die v:profileImageUrlMedium=/api/users/4zcf-8die/profile_images/THUMB v:profileImageUrlLarge=/api/users/4zcf-8die/profile_images/LARGE v:screenName="Austin-Travis County EMS" v:profileImageUrlSmall=/api/users/4zcf-8die/profile_images/TINY v:displayName="Austin-Travis County EMS"

property e:2mb6-tu96 t:meta.view.tableauthor v:id=4zcf-8die v:profileImageUrlMedium=/api/users/4zcf-8die/profile_images/THUMB v:profileImageUrlLarge=/api/users/4zcf-8die/profile_images/LARGE v:screenName="Austin-Travis County EMS" v:profileImageUrlSmall=/api/users/4zcf-8die/profile_images/TINY v:roleName=publisher_stories v:displayName="Austin-Travis County EMS"

Top Records

| month_key | month_start_date    | count_patients_billed | average_bill_processing_days | average_bill_processing_days_target | percent_county_revenue_collected_fytd | percent_county_revenue_collected_fytd_target | 
| ========= | =================== | ===================== | ============================ | =================================== | ===================================== | ============================================ | 
| 201310    | 2013-10-01T00:00:00 | 7627                  | 4.783532                     | 10                                  | 115.17                                | 100                                          | 
| 201311    | 2013-11-01T00:00:00 | 5871                  | 5.443706                     | 10                                  | 100.67                                | 100                                          | 
| 201312    | 2013-12-01T00:00:00 | 6754                  | 6.343944                     | 10                                  | 105.45                                | 100                                          | 
| 201401    | 2014-01-01T00:00:00 | 7878                  | 6.210459                     | 10                                  | 108.82                                | 100                                          | 
| 201402    | 2014-02-01T00:00:00 | 6481                  | 5.152291                     | 10                                  | 104.90                                | 100                                          | 
| 201403    | 2014-03-01T00:00:00 | 6343                  | 4.842188                     | 10                                  | 106.22                                | 100                                          | 
| 201404    | 2014-04-01T00:00:00 | 7013                  | 5.577356                     | 10                                  | 106.54                                | 100                                          | 
| 201405    | 2014-05-01T00:00:00 | 7512                  | 5.205404                     | 10                                  | 106.91                                | 100                                          | 
| 201406    | 2014-06-01T00:00:00 | 6933                  | 5.064474                     | 10                                  | 107.28                                | 100                                          | 
| 201407    | 2014-07-01T00:00:00 | 7810                  | 5.985659                     | 10                                  | 107.02                                | 100                                          |