About this Dataset

Counties' Net Other Postemployment Benefit Asset And Liability For Fiscal Years 2017-18 To 2019-20

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-29T02:09:01.755980
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 2017-18 To 2019-20

@usgov.ca_gov_counties_net_other_postemployment_benefit_asset_8a503609.counties_net_other_postemployment_benefit_asset_and_li_1bc42f92

15.49 kB
170 rows
12 columns

CREATE TABLE counties_net_other_postemployment_benefit_asset_and_li_1bc42f92 (
  "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" VARCHAR  -- Enterprise Funds (Net OPEB Asset) $,
  "enterprise_funds_net_opeb_liability" DOUBLE  -- Enterprise Funds (Net OPEB Liability) $,
  "intenal_service_funds_net_opeb_asset" VARCHAR  -- Intenal Service Funds (Net OPEB Asset) $,
  "intenal_service_funds_net_opeb_liability" DOUBLE  -- Intenal Service Funds (Net OPEB Liability) $,
  "fiduciary_funds_net_opeb_asset" VARCHAR  -- Fiduciary Funds (Net OPEB Asset)$,
  "fiduciary_funds_net_opeb_liability" VARCHAR  -- Fiduciary Funds (Net OPEB Liability)$,
  "total_net_opeb_asset" BIGINT  -- Total Net OPEB Asset $,
  "total_net_opeb_liability" BIGINT  -- Total Net OPEB Liability $
);