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

63.18 kB
35 rows
58 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "fiduciary_net_position_retirement_plan" DOUBLE  -- Fiduciary Net Position - Retirement Plan,
  "fiduciary_net_position_healthcare_plan" DOUBLE  -- Fiduciary Net Position - Healthcare Plan,
  "fiduciary_net_position_family_death_benefit_plan" DOUBLE  -- Fiduciary Net Position - Family Death Benefit Plan,
  "fiduciary_net_position_total_lacers_plans" BIGINT  -- Fiduciary Net Position - Total LACERS Plans,
  "under_over_funded_actuarial_accrued_liability_retireme_0e52dc68" BIGINT  -- Under/(Over) Funded Actuarial Accrued Liability-Retirement Plan (Net Pension Liability),
  "under_over_funded_actuarial_accrued_liability_healthca_45f2fca1" BIGINT  -- Under/(Over) Funded Actuarial Accrued Liability-Healthcare Plan (Net OPEB Liability),
  "under_over_funded_actuarial_accrued_liability_total_la_d04fb24f" BIGINT  -- Under/(Over) Funded Actuarial Accrued Liability-Total LACERS Plan (Net Pension And OPEB Liability),
  "funded_ratio_retirement_plan" DOUBLE  -- Funded Ratio - Retirement Plan,
  "funded_ratio_healthcare_plan" DOUBLE  -- Funded Ratio - Healthcare Plan,
  "funded_ratio_total_lacers_plans" DOUBLE  -- Funded Ratio - Total LACERS Plans,
  "city_contributions_retirement_plan" BIGINT  -- City Contributions - Retirement Plan,
  "city_contributions_healthcare_plan" BIGINT  -- City Contributions - Healthcare Plan,
  "city_contributions_total_lacers_plan" BIGINT  -- City Contributions - Total LACERS Plan,
  "actual_employer_retirement_plan_contribution_rate_combined" DOUBLE,
  "actual_employer_health_plan_contribution_rate_combined" DOUBLE,
  "member_contributions_retirement_plan" BIGINT  -- Member Contributions - Retirement Plan,
  "member_contributions_healthcare_plan" BIGINT  -- Member Contributions - Healthcare Plan,
  "net_investment_income_loss_retirement_plan" DOUBLE  -- Net Investment Income (Loss) - Retirement Plan,
  "net_investment_income_loss_healthcare_plan" DOUBLE  -- Net Investment Income (Loss) - Healthcare Plan,
  "net_investment_income_loss_total_lacers_plan" DOUBLE  -- Net Investment Income (Loss) - Total LACERS Plan,
  "n_1_yr_return_gross_of_fees" DOUBLE  -- 1 Yr. Return - Gross Of Fees,
  "n_1_yr_return_net_of_fees" DOUBLE  -- 1 Yr. Return - Net Of Fees,
  "n_3_yr_return_gross_of_fees" DOUBLE  -- 3 Yr. Return - Gross Of Fees,
  "n_3_yr_return_net_of_fees" DOUBLE  -- 3 Yr. Return - Net Of Fees,
  "n_5_yr_return_gross_of_fees" DOUBLE  -- 5 Yr. Return - Gross Of Fees,
  "n_5_yr_return_net_of_fees" DOUBLE  -- 5 Yr. Return (Net Of Fees,
  "n_10_yr_return_gross_of_fees" DOUBLE  -- 10 Yr. Return - Gross Of Fees,
  "n_10_yr_return_net_of_fees" DOUBLE  -- 10 Yr. Return - Net Of Fees,
  "n_15_yr_return_gross_of_fees" DOUBLE  -- 15 Yr. Return - Gross Of Fees,
  "n_15_yr_return_net_of_fees" DOUBLE  -- 15 Yr. Return - Net Of Fees,
  "average_monthly_retirement_allowance_service_retirees" DOUBLE  -- Average Monthly Retirement Allowance - Service Retirees,
  "average_monthly_retirement_allowance_survivor_cont" DOUBLE  -- Average Monthly Retirement Allowance - Survivor Cont.,
  "average_monthly_retirement_allowance_disability_retirees" DOUBLE  -- Average Monthly Retirement Allowance - Disability Retirees,
  "average_monthly_retirement_allowance_weighted_avg" BIGINT  -- Average Monthly Retirement Allowance - Weighted Avg.,
  "annual_retirement_benefits" BIGINT,
  "average_monthly_health_subsidy_over_65_with_medicare_a_b" DOUBLE  -- Average Monthly Health Subsidy Over 65 With Medicare A & B,
  "average_monthly_health_subsidy_under_65_non_medicare" DOUBLE,
  "average_monthly_survivor_healthcare_subsidy_under_65_n_3a4a4a93" DOUBLE  -- Average Monthly Survivor Healthcare Subsidy Under 65 Non-Medicare,
  "maximum_monthly_retiree_healthcare_subsidy_under_65_no_db3320b6" DOUBLE  -- Maximum Monthly Retiree Healthcare Subsidy Under 65 Non-Medicare,
  "maximum_monthly_survivor_healthcare_subsidy_under_65_n_4d6c2610" DOUBLE  -- Maximum Monthly Survivor Healthcare Subsidy Under 65 Non-Medicare,
  "annual_healthcare_benefits" BIGINT,
  "active_members_tier_1" BIGINT  -- Active Members - Tier 1,
  "active_members_tier_2" DOUBLE  -- Active Members - Tier 2,
  "active_members_tier_3" DOUBLE  -- Active Members - Tier 3,
  "active_members_all_tiers" BIGINT  -- Active Members - All Tiers,
  "inactive_members_tier_1" DOUBLE  -- Inactive Members - Tier 1,
  "inactive_members_tier_2" DOUBLE  -- Inactive Members - Tier 2,
  "inactive_members_tier_3" DOUBLE  -- Inactive Members - Tier 3,
  "inactive_members_all_tiers" DOUBLE  -- Inactive Members - All Tiers,
  "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
);