About this Dataset

Transportation Planning Agencies' Net Pension Asset And Liability For Fiscal Years 2020-21 To 2021-22

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:12:30.456218
Tags: california-state-controllers-office, net-pension-asset-and-liability, npl, tpa, transportation-planning-agencies

Tables

Transportation Planning Agencies' Net Pension Asset And Liability For Fiscal Years 2020-21 To 2021-22

@usgov.ca_gov_transportation_planning_agencies_net_pension_as_f41cf6c5.transportation_planning_agencies_net_pension_asset_and_8915b2b6

7.87 kB
147 rows
6 columns

CREATE TABLE transportation_planning_agencies_net_pension_asset_and_8915b2b6 (
  "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)$
);