Strategic Measure Financial Stability Of The City Of Austin Employees' Retirement Systems by US Government | Demographics and Population Studies

About this Dataset

Strategic Measure Financial Stability Of The City Of Austin Employees' Retirement Systems

This dataset contains information about the financial stability of the City of Austin's employees' retirement systems, including the City of Austin Employees' Retirement System (COAERS), the Austin Firefighters Retirement System (AFRS), and the Austin Police Retirement System (APRS). It uses the total funded ratio, which is equal to the total actuarial value of assets as a percentage of the total actuarial accrued liability. This data supports the SD23 measure GTQ.A.6. Having a funded ratio of below 80% could potentially impact credit rating agencies' evaluation of the City's pension liabilities, so this ratio is important to measure through annual actuarial valuation reports for all three retirement systems. View more details and insights related to this dataset on the story page: https://data.austintexas.gov/stories/s/d4mh-eiif
Organization: City of Austin
Last updated: 2020-11-12T13:26:10.312126
Tags: sd23

Tables

Table 1

@usgov.city_of_austin_strategic_measure_financial_stability_o_81962430.table_1

10.57 KB
8 rows
10 columns


CREATE TABLE table_1 (
  "fiscal_year" VARCHAR,
  "actuarial_value_of_assets_city_of_austin_employees_ret_c3b3c606" BIGINT,
  "actuarial_value_of_assets_austin_firefighters_retireme_f8af2434" BIGINT,
  "actuarial_value_of_assets_austin_police_retirement_system_aprs" BIGINT,
  "total_actuarial_values_of_assets" BIGINT,
  "actuarial_accrued_liability_coaers" BIGINT,
  "actuarial_accrued_liability_afrs" BIGINT,
  "actuarial_accrued_liability_aprs" BIGINT,
  "total_actuarial_accrued_liability" BIGINT,
  "total_funded_ratio" DOUBLE
);