About this Dataset

Funding Positions Of CalPERS Contracting Agencies For Fiscal Years 2002-03 To 2021-22

This dataset contains the Actuarial Liabilities, Actuarial Value of Assets, Unfunded Liabilities, and Funding Ratios for each Local Contracting Agency.
Organization: State of California
Last updated: 2023-07-29T01:20:11.696316
Tags: california-state-controllers-office, calpers-supplement, prpersfratio

Tables

Funding Positions Of CalPERS Contracting Agencies For Fiscal Years 2002-03 To 2021-22

@usgov.ca_gov_funding_positions_of_calpers_contracting_agenci_9f613df0.funding_positions_of_calpers_contracting_agencies_for__bf4bdf29

439.1 kB
12,134 rows
11 columns

CREATE TABLE funding_positions_of_calpers_contracting_agencies_for__bf4bdf29 (
  "employer_name" VARCHAR,
  "fiscal_year" BIGINT,
  "category" BIGINT,
  "actuarial_liabilities" BIGINT,
  "market_value_of_assets" DOUBLE,
  "unfunded_liabilities" DOUBLE,
  "current_year" DOUBLE,
  "prior_year_1" DOUBLE,
  "prior_year_2" DOUBLE,
  "prior_year_3" DOUBLE,
  "employer_code" BIGINT
);