Hofidar Cost Center Report

CREATE TABLE table_1 (
  "year" BIGINT,
  "license_number" BIGINT,
  "hospital_name" VARCHAR,
  "acct" BIGINT  -- Acct #,
  "cost_center" VARCHAR,
  "id_fte_s" DOUBLE,
  "units_of_measure" BIGINT,
  "salaries_wages" BIGINT,
  "employee_benefits" BIGINT,
  "professional_fees" BIGINT,
  "supplies" BIGINT,
  "purch_serv_utilities" BIGINT,
  "purch_serv_other" BIGINT,
  "rentals_leases" BIGINT,
  "depreciation_expense" BIGINT,
  "other_direct_exp" BIGINT,
  "total_revenue" BIGINT,
  "inpatient_revenue" BIGINT,
  "blood_supplies" BIGINT,
  "contract_staffing" BIGINT,
  "information_technology_including_licenses_and_maintenance" BIGINT,
  "insurance_and_professional_liability" BIGINT,
  "laundry_services" BIGINT,
  "legal_audit_and_tax_services" BIGINT,
  "purchased_laboratory_services" BIGINT,
  "repairs_and_maintenance" BIGINT,
  "shared_services_or_system_office_allocation" BIGINT,
  "staff_recruitment" BIGINT,
  "training_costs" BIGINT,
  "taxes" BIGINT,
  "utilities" BIGINT,
  "other_noncategorized_expenses" BIGINT,
  "cost_recoveries" BIGINT,
  "operating_expenses" BIGINT,
  "allocated_expenses" BIGINT,
  "plant_sq_feet" BIGINT,
  "dietary_meals" BIGINT,
  "housekeeping_hours" BIGINT,
  "laundry_dry_lbs" BIGINT,
  "nursing_fte_s" DOUBLE
);