About this Dataset

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

Demographic assumption rates for Service Retirement, Disability Retirement (ordinary and service), Mortality of Active Members (ordinary and service), and Withdrawal (Termination) based on the age of active members.
Organization: State of California
Last updated: 2023-07-29T02:05:01.591977
Tags: california-state-controllers-office

Tables

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

@usgov.ca_gov_demographic_assumption_rates_age_for_fiscal_yea_c309ef87.demographic_assumption_rates_age_for_fiscal_years_2016_a5e93287

55.97 kB
11,738 rows
13 columns

CREATE TABLE demographic_assumption_rates_age_for_fiscal_years_2016_a5e93287 (
  "entity_name" VARCHAR,
  "entity_id" BIGINT,
  "fiscal_year" BIGINT,
  "member_type_demographic_assumption_rates_age" VARCHAR  -- Member Type Demographic Assumption Rates - Age,
  "gender_demographic_assumption_rates_age" VARCHAR  -- Gender Demographic Assumption Rates - Age,
  "age_demographic_assumption_rates_age" BIGINT  -- Age Demographic Assumption Rates - Age,
  "service_retirement_rate_demographic_assumption_rates_age" VARCHAR  -- Service Retirement Rate Demographic Assumption Rates - Age,
  "ordinary_disability_retirement_rate_demographic_assump_8f3d560e" VARCHAR  -- Ordinary Disability Retirement Rate Demographic Assumption Rates - Age,
  "service_disability_retirement_rate_demographic_assumpt_681fe5bc" VARCHAR  -- Service Disability Retirement Rate Demographic Assumption Rates - Age,
  "ordinary_mortality_of_active_members_rate_demographic__ee9d2dcb" VARCHAR  -- Ordinary Mortality Of Active Members Rate Demographic Assumption Rates - Age,
  "service_mortality_of_active_members_rate_demographic_a_9c2f7e17" VARCHAR  -- Service Mortality Of Active Members Rate Demographic Assumption Rates - Age,
  "withdrawal_termination_rate_demographic_assumption_rates_age" VARCHAR  -- Withdrawal (Termination) Rate Demographic Assumption Rates - Age,
  "line_id_demographic_assumption_rates_age" BIGINT  -- Line ID Demographic Assumption Rates - Age
);