About this Dataset

Transportation Planning Agencies' 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:09:39.350437
Tags: california-state-controllers-office, net-pension-asset-and-liability, transportation, transportation-planning-agencies

Tables

Transportation Planning Agencies' Net Pension Asset And Liability For Fiscal Years 2017-18 To 2019-20

@usgov.ca_gov_transportation_planning_agencies_net_pension_as_9cde5389.transportation_planning_agencies_net_pension_asset_and_9d7a47c3

11.27 kB
147 rows
10 columns

CREATE TABLE transportation_planning_agencies_net_pension_asset_and_9d7a47c3 (
  "entity_name" VARCHAR,
  "fiscal_year" BIGINT,
  "governmental_funds_net_pension_asset" VARCHAR  -- 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) $,
  "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" BIGINT  -- Total Net Pension Asset $,
  "total_net_pension_liability" BIGINT  -- Total Net Pension Liability $
);