About this Dataset

CalPERS Supplement - Contracting Agencies' Benefits For Fiscal Years 2002-03 To 2021-22

This dataset compares selected benefits of all the local public agencies that contracted with CalPERS. Agencies are listed alphabetically and include the plan types (miscellaneous or safety) and a five-digit code used for identification by CalPERS of the various benefit formulas.
Organization: State of California
Last updated: 2023-07-29T01:20:07.901243
Tags: california-state-controllers-office, calpers-supplement, prperscont

Tables

CalPERS Supplement - Contracting Agencies' Benefits For Fiscal Years 2002-03 To 2021-22

@usgov.ca_gov_calpers_supplement_contracting_agencies_benefit_2340faf1.calpers_supplement_contracting_agencies_benefits_for_f_89def317

1.31 MB
141,513 rows
16 columns

CREATE TABLE calpers_supplement_contracting_agencies_benefits_for_f_89def317 (
  "employer_name" VARCHAR,
  "fiscal_year" BIGINT,
  "coverage_type" VARCHAR,
  "benefit_formula" VARCHAR,
  "final_compensation_offset" VARCHAR,
  "final_compensation_period" DOUBLE,
  "cola" BIGINT,
  "pre_retirement_option_2" VARCHAR,
  "sick_leave_credit" VARCHAR,
  "post_retirement_survivor_allowance" VARCHAR,
  "ordinary_disability_increase" VARCHAR,
  "n_1959_survivor_benefit" VARCHAR  -- 1959 Survivor Benefit,
  "member" VARCHAR,
  "employer" DOUBLE,
  "employer_code" BIGINT,
  "coverage_group" BIGINT
);