BENEFIT_PLANPrompt Table: BENEF_PLAN_TBL
PA_PEN_PLANS_VW(SQL View) |
Index Back |
|---|---|
Pension Benefit Plans no effdtPA_PEN_PLAN_VW joins the PENSION_PLN_TBL and the BENEF_PLAN_TBL to retrieve data for US Pension Plans. The view retrieves US qualified and non-qualified plans from PENSION_PLN_TBL |
| select distinct a.benefit_plan, b.descr from PS_PENSION_PLN_TBL a, ps_benef_plan_tbl b, ps_pa_proc c where a.benefit_plan=b.benefit_plan and a.benefit_plan = c.benefit_plan and a.pension_type in ('N', 'Q') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |