About this Dataset

EMS - Monthly Finance Measures

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

When using this data for research or other purposes, please cite it as:

Emergency Medical Services Department. (2017). EMS - Monthly Finance Measures [Data set]. City of Austin, Texas Open Data Portal. https://doi.org/10.26000/001.000008.

Since this table is updated on a monthly basis, include the date that the table was accessed in the citation.
Organization: City of Austin
Last updated: 2020-11-12T13:20:44.367526
Tags: 911, administration, ambulance, atcems, austin, business-processes, emergency-medical-services, ems, finance, revenue-collection, travis-county

Tables

Table 1

@usgov.city_of_austin_ems_monthly_finance_measures.table_1

22.88 kB
73 rows
18 columns

CREATE TABLE table_1 (
  "month_key" BIGINT,
  "month_year" VARCHAR,
  "count_total_patients_billed" BIGINT  -- Count - Total Patients Billed,
  "average_bill_processing_interval_all_areas" DOUBLE  -- Average Bill Processing Interval - All Areas,
  "average_bill_processing_interval_target" BIGINT,
  "count_patients_billed_city_of_austin" BIGINT  -- Count - Patients Billed - City Of Austin,
  "average_bill_processing_interval_city_of_austin" DOUBLE  -- Average Bill Processing Interval - City Of Austin,
  "average_bill_processing_interval_target_city_of_austin" BIGINT  -- Average Bill Processing Interval Target - City Of Austin,
  "count_patients_billed_travis_county" BIGINT  -- Count - Patients Billed - Travis County,
  "average_bill_processing_interval_travis_county" DOUBLE  -- Average Bill Processing Interval - Travis County,
  "average_bill_processing_interval_target_travis_county" BIGINT  -- Average Bill Processing Interval Target - Travis County,
  "count_bill_processing_interval_target_met_county" BIGINT  -- Count - Bill Processing Interval Target Met - County,
  "percent_bill_processing_interval_target_met_county" DOUBLE  -- Percent - Bill Processing Interval Target Met - County,
  "count_patients_billed_other_areas" BIGINT  -- Count - Patients Billed - Other Areas,
  "average_bill_processing_interval_other_areas" DOUBLE  -- Average Bill Processing Interval - Other Areas,
  "average_bill_processing_interval_target_other_areas" BIGINT  -- Average Bill Processing Interval Target - Other Areas,
  "county_revenue_collected_fytd" DOUBLE,
  "target_county_revenue_collected_fytd" BIGINT  -- Target - County Revenue Collected FYTD
);