PA_PEN_PLAN_VW(SQL View) |
Index Back |
|---|---|
Pension Benefit Plan ParametrsPA_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 A.BENEFIT_PLAN , C.EFFDT , B.DESCR , A.ERNCD_SPCL , A.PENS_RT_TBL_TYPE , A.EE_PCT_UNDER_YMPE , A.EE_PCT_OVER_YMPE , A.PCT_UP_TO_STEP , A.PCT_OVER_STEP , A.VOLUN_CNTR_ALLOWED , A.PENSION_TYPE , A.PLN_YR_BEGIN_MONTH , A.PLN_YR_BEGIN_DAY , A.PLN_YR_END_MONTH , A.PLN_YR_END_DAY , A.PA_CB_CONT_SW FROM PS_PENSION_PLN_TBL A , PS_BENEF_PLAN_TBL B , PS_PA_PROC C WHERE A.PLAN_TYPE LIKE '8%' AND A.PLAN_TYPE = B.PLAN_TYPE AND A.BENEFIT_PLAN = B.BENEFIT_PLAN AND A.BENEFIT_PLAN = C.BENEFIT_PLAN AND A.PENSION_TYPE IN ('N', 'Q') AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PENSION_PLN_TBL WHERE PLAN_TYPE = A.PLAN_TYPE AND BENEFIT_PLAN = A.BENEFIT_PLAN) AND B.PLAN_TYPE = A.PLAN_TYPE AND B.BENEFIT_PLAN = A.BENEFIT_PLAN AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BENEF_PLAN_TBL WHERE PLAN_TYPE = B.PLAN_TYPE AND BENEFIT_PLAN = B.BENEFIT_PLAN) |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ERNCD_SPCL | Character(3) | VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table: SPCL_EARNS_TBL |
| 5 | PENS_RT_TBL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Pension Rate Table Type
F=Fixed Rate N=None S=Slide Rate Default Value: N |
| 6 | EE_PCT_UNDER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | EE Pct for Earns under YMPE |
| 7 | EE_PCT_OVER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | EE Pct for Earns over YMPE |
| 8 | PCT_UP_TO_STEP | Number(7,3) | DECIMAL(6,3) NOT NULL | Pct up to Contribution Step |
| 9 | PCT_OVER_STEP | Number(7,3) | DECIMAL(6,3) NOT NULL | Pct Over Contribution Step |
| 10 | VOLUN_CNTR_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL |
Voluntary Contributns Allowed
Y/N Table Edit Default Value: N |
| 11 | PENSION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Pension Type
B=Defined Benefit M=Money Purchase N=Non Qualified Q=Qualified Default Value: M |
| 12 | PLN_YR_BEGIN_MONTH | Number(2,0) | SMALLINT NOT NULL |
Month Plan Year Begins
Default Value: 1 |
| 13 | PLN_YR_BEGIN_DAY | Number(2,0) | SMALLINT NOT NULL |
Day Plan Year Begins
Default Value: 1 |
| 14 | PLN_YR_END_MONTH | Number(2,0) | SMALLINT NOT NULL |
Month Plan Year Ends
Default Value: 1 |
| 15 | PLN_YR_END_DAY | Number(2,0) | SMALLINT NOT NULL |
Day Plan Year Ends
Default Value: 1 |
| 16 | PA_CB_CONT_SW | Character(1) | VARCHAR2(1) NOT NULL | Allow Contingent Beneficiaries |