LACERS Key Facts And Figures From Year End Financial Reports by US Government | Finance and Economics

About this Dataset

LACERS Key Facts And Figures From Year End Financial Reports

This is a collection of data reported in LACERS Annual Financial Report since Fiscal Year End 1990, which includes selective data from the yearly Actuarial Valuation, Audited Financial Statement, and Investments Reporting generated after the end of each Fiscal Year. Average Healthcare Subsidies data are the exception and are pulled from Health division dashboards at fiscal year end. Yearly and multi-year investment return averages are based on time-weighted reporting. Some figures are rounded, as reported in the documents referenced above. Actuarial Valuations and Annual Financial Report documents, in electronic form, can be found on the LACERS.org website at https://www.lacers.org/reports-and-statistics.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:07.468932
Tags: lacers, opeb, pension, retirees, retirement, tier-1, tier-2, tier-3, uaal

Tables

Table 1

@usgov.city_of_los_angeles_lacers_key_facts_and_figures_from__3e28a25d.table_1

61.7 KB
35 rows
58 columns


CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "fiduciary_net_position_retirement_plan" DOUBLE,
  "fiduciary_net_position_healthcare_plan" DOUBLE,
  "fiduciary_net_position_family_death_benefit_plan" DOUBLE,
  "fiduciary_net_position_total_lacers_plans" BIGINT,
  "under_over_funded_actuarial_accrued_liability_retireme_0e52dc68" BIGINT,
  "under_over_funded_actuarial_accrued_liability_healthca_45f2fca1" BIGINT,
  "under_over_funded_actuarial_accrued_liability_total_la_d04fb24f" BIGINT,
  "funded_ratio_retirement_plan" DOUBLE,
  "funded_ratio_healthcare_plan" DOUBLE,
  "funded_ratio_total_lacers_plans" DOUBLE,
  "city_contributions_retirement_plan" BIGINT,
  "city_contributions_healthcare_plan" BIGINT,
  "city_contributions_total_lacers_plan" BIGINT,
  "actual_employer_retirement_plan_contribution_rate_combined" DOUBLE,
  "actual_employer_health_plan_contribution_rate_combined" DOUBLE,
  "member_contributions_retirement_plan" BIGINT,
  "member_contributions_healthcare_plan" BIGINT,
  "net_investment_income_loss_retirement_plan" DOUBLE,
  "net_investment_income_loss_healthcare_plan" DOUBLE,
  "net_investment_income_loss_total_lacers_plan" DOUBLE,
  "n_1_yr_return_gross_of_fees" DOUBLE,
  "n_1_yr_return_net_of_fees" DOUBLE,
  "n_3_yr_return_gross_of_fees" DOUBLE,
  "n_3_yr_return_net_of_fees" DOUBLE,
  "n_5_yr_return_gross_of_fees" DOUBLE,
  "n_5_yr_return_net_of_fees" DOUBLE,
  "n_10_yr_return_gross_of_fees" DOUBLE,
  "n_10_yr_return_net_of_fees" DOUBLE,
  "n_15_yr_return_gross_of_fees" DOUBLE,
  "n_15_yr_return_net_of_fees" DOUBLE,
  "average_monthly_retirement_allowance_service_retirees" DOUBLE,
  "average_monthly_retirement_allowance_survivor_cont" DOUBLE,
  "average_monthly_retirement_allowance_disability_retirees" DOUBLE,
  "average_monthly_retirement_allowance_weighted_avg" BIGINT,
  "annual_retirement_benefits" BIGINT,
  "average_monthly_health_subsidy_over_65_with_medicare_a_b" DOUBLE,
  "average_monthly_health_subsidy_under_65_non_medicare" DOUBLE,
  "average_monthly_survivor_healthcare_subsidy_under_65_n_3a4a4a93" DOUBLE,
  "maximum_monthly_retiree_healthcare_subsidy_under_65_no_db3320b6" DOUBLE,
  "maximum_monthly_survivor_healthcare_subsidy_under_65_n_4d6c2610" DOUBLE,
  "annual_healthcare_benefits" BIGINT,
  "active_members_tier_1" BIGINT,
  "active_members_tier_2" DOUBLE,
  "active_members_tier_3" DOUBLE,
  "active_members_all_tiers" BIGINT,
  "inactive_members_tier_1" DOUBLE,
  "inactive_members_tier_2" DOUBLE,
  "inactive_members_tier_3" DOUBLE,
  "inactive_members_all_tiers" DOUBLE,
  "covered_payroll" BIGINT,
  "actuarially_projected_annual_payroll" DOUBLE,
  "number_of_service_retirees" DOUBLE,
  "number_of_disability_retirees" DOUBLE,
  "number_of_beneficiaries" DOUBLE,
  "average_retirement_age" DOUBLE,
  "average_age_of_service_retirees" DOUBLE,
  "average_age_of_beneficiaries" DOUBLE
);