| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
|
| 2 |
CALC_SEQ_NUM |
Number(9,0) |
DECIMAL(9) NOT NULL |
Calc Seq Num
Default Value: PA_CALCULATION.CALC_SEQ_NUM
|
| 3 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
PA_PLAN_ORDER
|
| 4 |
BEN_CMCMNT_AGE |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Benefit Commencement Age/YY.MM
|
| 5 |
LUMP_SUM_AGE |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Lump Sum Age(YY.MM)
|
| 6 |
BEN_CMDT_DATE |
Date(10) |
DATE |
Benefit Commencement Date
|
| 7 |
LUMP_SUM_DT |
Date(10) |
DATE |
Lump Sum Date
|
| 8 |
USE_NRD_OR_ERD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Default NRD or ERD
E=Default Early Retirement Date
N=Default Normal Retirement Date
U=User Specified Commencement Dt
Default Value: U
|
| 9 |
CONT_ASMP_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Assumed Contributions Pct
|
| 10 |
CLC_PLN_ORD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Calc Plan Order Number
|
| 11 |
ERISA_QUAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Type
N=Non Qualified
Q=Qualified
Default Value: PA_PEN_PLAN_VW.PENSION_TYPE
|
| 12 |
USE_OVERRIDE_SECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Function Overrides
Y/N Table Edit
Default Value: N
|
| 13 |
USE_PROCESS_SECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Process Selection
Y/N Table Edit
Default Value: N
|
| 14 |
PA_SS_ELIG_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Surviving Spouse Eligibility
N=Override to Ineligible
Y=Override to Eligible
|
| 15 |
PA_BENEF_DOB |
Date(10) |
DATE |
Beneficiary Birth Date
|
| 16 |
PA_BENEF_SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Beneficiary Gender
F=Female
M=Male
|
| 17 |
PA_CB_CONT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Contingent Beneficiaries
|
| 18 |
BEN_CMDT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Benefit Commencement Dt Alias
Prompt Table:
PA_DTDB_ALS_VW
|
| 19 |
BEN_CMDT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Ben Com Dt Alias Type
|
| 20 |
LUMP_SUM_DT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Lump Sum Date Alias
Prompt Table:
PA_DTDB_ALS_VW
|
| 21 |
LUMP_SUM_DT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Lump Sum Dt Alias Type
|
| 22 |
USE_ADJUST_SECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Adjustments
Y/N Table Edit
Default Value: N
|