About this Dataset

Demographic Assumption Rates – Years Of Service For Fiscal Years 2016-17 To 2019-20

Demographic assumption rates for Service Retirement and Withdrawal (Termination) based on the years of service of active members.
Organization: State of California
Last updated: 2023-07-29T02:05:05.157171
Tags: california-state-controllers-office

Tables

Demographic Assumption Rates – Years Of Service For Fiscal Years 2016-17 To 2019-20

@usgov.ca_gov_demographic_assumption_rates_years_of_service_f_f1e468df.demographic_assumption_rates_years_of_service_for_fisc_c8722f71

24.23 kB
7,941 rows
9 columns

CREATE TABLE demographic_assumption_rates_years_of_service_for_fisc_c8722f71 (
  "entity_name" VARCHAR,
  "entity_id" BIGINT,
  "fiscal_year" BIGINT,
  "member_type_demographic_assumption_rates_years_of_service" VARCHAR  -- Member Type Demographic Assumption Rates - Years Of Service,
  "gender_demographic_assumption_rates_years_of_service" VARCHAR  -- Gender Demographic Assumption Rates - Years Of Service,
  "age_demographic_assumption_rates_years_of_service" BIGINT  -- Age Demographic Assumption Rates - Years Of Service,
  "service_retirement_rate_demographic_assumption_rates_y_17ef11ca" VARCHAR  -- Service Retirement Rate Demographic Assumption Rates - Years Of Service,
  "withdrawal_termination_rate_demographic_assumption_rat_6e6cdff9" DOUBLE  -- Withdrawal (Termination) Rate Demographic Assumption Rates - Years Of Service,
  "line_id_demographic_assumption_rates_years_of_service" BIGINT  -- Line ID Demographic Assumption Rates - Years Of Service
);