PA_SSV_PLN_INPT

(SQL Table)
Index Back

WEB Calculation Inputs by Plan

This is a parameter table containing WEB Calc Input Parameters which are plan specific.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PA_WEB_CALC_NAME Character(3) VARCHAR2(3) NOT NULL Web Calculation Name
WEB=Web Calculation Defaults
2 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Prompt Table: PA_PLAN_ORDER

3 CONT_ASMP_PCT Number(6,2) DECIMAL(5,2) NOT NULL Assumed Contributions Pct
4 CLC_PLN_ORD_NUM Number(3,0) SMALLINT NOT NULL Calc Plan Order Number
5 ERISA_QUAL_IND Character(1) VARCHAR2(1) NOT NULL Pension Type
N=Non Qualified
Q=Qualified

Default Value: PA_PEN_PLAN_VW.PENSION_TYPE

6 USE_PROCESS_SECT Character(1) VARCHAR2(1) NOT NULL Use Process Selection

Y/N Table Edit

Default Value: N