About this Dataset

Counties' 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:25.663389
Tags: california-state-controllers-office, counties, net-other-postemployment-benefit-asset-and-liability, opeb

Tables

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

@usgov.ca_gov_counties_net_other_postemployment_benefit_asset_3fe5dc08.counties_net_other_postemployment_benefit_asset_and_li_4392eaca

18.92 kB
169 rows
16 columns

CREATE TABLE counties_net_other_postemployment_benefit_asset_and_li_4392eaca (
  "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" DOUBLE  -- 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" DOUBLE  -- Investment Trust Funds (Net OPEB Asset) $,
  "investment_trust_funds_net_opeb_liability" DOUBLE  -- 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" DOUBLE  -- Custodial Funds (Net OPEB Asset) $,
  "custodial_funds_net_opeb_liability" DOUBLE  -- Custodial Funds (Net OPEB Liability) $
);