About this Dataset

Special Districts' Net Pension Asset And Liability For Fiscal Years 2017-18 To 2019-20

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-29T02:03:52.605604
Tags: california-state-controllers-office, net-pension-asset-and-liability, npl, special-districts

Tables

Special Districts' Net Pension Asset And Liability For Fiscal Years 2017-18 To 2019-20

@usgov.ca_gov_special_districts_net_pension_asset_and_liabili_f52e4a63.special_districts_net_pension_asset_and_liability_for__09c6f667

171.7 kB
20,547 rows
12 columns

CREATE TABLE special_districts_net_pension_asset_and_liability_for__09c6f667 (
  "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" VARCHAR  -- Enterprise Funds (Net Pension Asset) $,
  "enterprise_funds_net_pension_liability" DOUBLE  -- Enterprise Funds (Net Pension Liability) $,
  "intenal_service_funds_net_pension_asset" VARCHAR  -- Intenal Service Funds (Net Pension Asset) $,
  "intenal_service_funds_net_pension_liability" DOUBLE  -- Intenal Service Funds (Net Pension Liability) $,
  "fiduciary_funds_net_pension_asset" VARCHAR  -- Fiduciary Funds (Net Pension Asset)$,
  "fiduciary_funds_net_pension_liability" VARCHAR  -- Fiduciary Funds (Net Pension Liability)$,
  "total_net_pension_asset" DOUBLE  -- Total Net Pension Asset $,
  "total_net_pension_liability" DOUBLE  -- Total Net Pension Liability $
);