PA_PEN_PLN_SRCH (SQL View)	Index Back
Distinct pension pln tbl vw PENSION_PLN_TBL is a record that defines the attributes of a Canadian pension plan, including type of pension and contribution parameters (employer vs. employee percentages). The contribution rates applicable to a plan are defined separately on associated PENSION_RTE_TBL records. Both record types are populated online through the Pension Plan Table panel.

PA_PEN_PLN_SRCH

(SQL View)

Distinct pension pln tbl vw

PENSION_PLN_TBL is a record that defines the attributes of a Canadian pension plan, including type of pension and contribution parameters (employer vs. employee percentages). The contribution rates applicable to a plan are defined separately on associated PENSION_RTE_TBL records. Both record types are populated online through the Pension Plan Table panel.

select distinct benefit_plan from PS_PENSION_PLN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: PA_BENEF_VW