About this Dataset

Special Districts' Net Pension Asset And Liability For Fiscal Year 2020-21

Net Pension Asset (NPA) is the amount in excess of the amount owed to a defined benefit pension plan based on the actuarial present value of projected benefit payments for plan members and their beneficiaries less the plan’s net position. Net Pension Liability (NPL) is the amount owed to a defined benefit pension plan based on the actuarial present value of 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:17.231665
Tags: california-state-controllers-office, net-pension-asset-and-liability, npl, special-districts

Tables

Special Districts' Net Pension Asset And Liability For Fiscal Year 2020-21

@usgov.ca_gov_special_districts_net_pension_asset_and_liabili_102873f7.special_districts_net_pension_asset_and_liability_for__177afe7e

112.85 kB
5,179 rows
18 columns

CREATE TABLE special_districts_net_pension_asset_and_liability_for__177afe7e (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "governmental_funds_net_pension_asset" DOUBLE  -- Governmental Funds (Net Pension Asset) $,
  "governmental_funds_net_pension_liability" DOUBLE  -- Governmental Funds (Net Pension Liability) $,
  "enterprise_funds_net_pension_asset" DOUBLE  -- Enterprise Funds (Net Pension Asset) $,
  "enterprise_funds_net_pension_liability" DOUBLE  -- Enterprise Funds (Net Pension Liability) $,
  "internal_service_funds_net_pension_asset" DOUBLE  -- Internal Service Funds (Net Pension Asset) $,
  "internal_service_funds_net_pension_liability" DOUBLE  -- Internal Service Funds (Net Pension Liability) $,
  "pension_and_oeb_trust_funds_net_pension_asset" VARCHAR  -- Pension And OEB Trust Funds (Net Pension Asset) $,
  "pension_and_oeb_trust_funds_net_pension_liability" VARCHAR  -- Pension And OEB Trust Funds (Net Pension Liability) $,
  "investment_trust_funds_net_pension_asset" VARCHAR  -- Investment Trust Funds (Net Pension Asset) $,
  "investment_trust_funds_net_pension_liability" VARCHAR  -- Investment Trust Funds (Net Pension Liability) $,
  "private_purpose_trust_funds_net_pension_asset" VARCHAR  -- Private Purpose Trust Funds (Net Pension Asset) $,
  "private_purpose_trust_funds_net_pension_liability" VARCHAR  -- Private Purpose Trust Funds (Net Pension Liability) $,
  "custodial_funds_net_pension_asset" VARCHAR  -- Custodial Funds (Net Pension Asset) $,
  "custodial_funds_net_pension_liability" VARCHAR  -- Custodial Funds (Net Pension Liability) $,
  "total_net_pension_asset" BIGINT  -- Total Net Pension Asset $,
  "total_net_pension_liability" BIGINT  -- Total Net Pension Liability $
);