About this Dataset

Cities' Net Other Postemployment Benefit Asset And Liability For Fiscal Years 2020-21 To 2021-22

Net Other Postemployment Benefit (OPEB) Asset is the amount in excess of the amount owed to a defined benefit OPEB plan based on the actuarial present value (or other method) of the projected benefit payments for plan members and their beneficiaries less the plan’s net position. Net OPEB Liability is the amount owed to a defined benefit OPEB plan based on the actuarial present value (or other method) of the projected benefit payments for plan members and their beneficiaries less the plan’s net position.
Organization: State of California
Last updated: 2023-07-29T01:11:21.939425
Tags: california-state-controllers-office, cities, net-other-postemployment-benefit-asset-and-liability, opeb

Tables

Cities' Net Other Postemployment Benefit Asset And Liability For Fiscal Years 2020-21 To 2021-22

@usgov.ca_gov_cities_net_other_postemployment_benefit_asset_a_df2f444c.cities_net_other_postemployment_benefit_asset_and_liab_c6c20b95

37.47 kB
1,443 rows
16 columns

CREATE TABLE cities_net_other_postemployment_benefit_asset_and_liab_c6c20b95 (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "governmental_funds_net_opeb_asset" DOUBLE  -- Governmental Funds (Net OPEB Asset) $,
  "governmental_funds_net_opeb_liability" DOUBLE  -- Governmental Funds (Net OPEB Liability) $,
  "enterprise_funds_net_opeb_asset" DOUBLE  -- Enterprise Funds (Net OPEB Asset) $,
  "enterprise_funds_net_opeb_liability" DOUBLE  -- Enterprise Funds (Net OPEB Liability) $,
  "internal_service_funds_net_opeb_asset" DOUBLE  -- Internal Service Funds (Net OPEB Asset) $,
  "internal_service_funds_net_opeb_liability" DOUBLE  -- Internal Service Funds (Net OPEB Liability) $,
  "pension_and_oeb_trust_funds_net_opeb_asset" VARCHAR  -- Pension And OEB Trust Funds (Net OPEB Asset) $,
  "pension_and_oeb_trust_funds_net_opeb_liability" DOUBLE  -- Pension And OEB Trust Funds (Net OPEB Liability) $,
  "investment_trust_funds_net_opeb_asset" VARCHAR  -- Investment Trust Funds (Net OPEB Asset) $,
  "investment_trust_funds_net_opeb_liability" VARCHAR  -- Investment Trust Funds (Net OPEB Liability) $,
  "private_purpose_trust_funds_net_opeb_asset" DOUBLE  -- Private Purpose Trust Funds (Net OPEB Asset) $,
  "private_purpose_trust_funds_net_opeb_liability" DOUBLE  -- Private Purpose Trust Funds (Net OPEB Liability) $,
  "custodial_funds_net_opeb_asset" VARCHAR  -- Custodial Funds (Net OPEB Asset) $,
  "custodial_funds_net_opeb_liability" DOUBLE  -- Custodial Funds (Net OPEB Liability) $
);