PA_SSV_PLN_INPT(SQL Table) |
Index Back |
---|---|
WEB Calculation Inputs by PlanThis 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 |