PA_PRSA_PLN_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, 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 from PS_PENSION_PLN_TBL a, ps_benef_plan_tbl b, ps_pa_proc c where 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(d.effdt) from ps_benef_plan_tbl d where a.plan_type = d.plan_type and a.benefit_plan = d.benefit_plan) and c.effdt >= (select max(f.effdt) from ps_pa_proc f where c.benefit_plan = f.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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | ERNCD_SPCL | Character(3) | VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table: SPCL_EARNS_TBL |
| 4 | 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 |
| 5 | EE_PCT_UNDER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | Contributions Up To YMPE |
| 6 | EE_PCT_OVER_YMPE | Number(7,3) | DECIMAL(6,3) NOT NULL | Contributions Over YMPE |
| 7 | PCT_UP_TO_STEP | Number(7,3) | DECIMAL(6,3) NOT NULL | Pct up to Contribution Step |
| 8 | PCT_OVER_STEP | Number(7,3) | DECIMAL(6,3) NOT NULL | Pct Over Contribution Step |
| 9 | VOLUN_CNTR_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL |
Voluntary Contributns Allowed
Y/N Table Edit Default Value: N |
| 10 | PENSION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Pension Type
B=Defined Benefit M=Money Purchase N=Non Qualified Q=Qualified Default Value: M |
| 11 | PLN_YR_BEGIN_MONTH | Number(2,0) | SMALLINT NOT NULL |
Month Plan Year Begins
Default Value: 1 |
| 12 | PLN_YR_BEGIN_DAY | Number(2,0) | SMALLINT NOT NULL |
Day Plan Year Begins
Default Value: 1 |
| 13 | PLN_YR_END_MONTH | Number(2,0) | SMALLINT NOT NULL |
Month Plan Year Ends
Default Value: 1 |
| 14 | PLN_YR_END_DAY | Number(2,0) | SMALLINT NOT NULL |
Day Plan Year Ends
Default Value: 1 |