PA_DFN_EEBENEFI

(SQL Table)
 Index Back

Employee Paid Benefit

This is a setup table containing Employee Paid Benefit parameters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEFINITION_NAME Character(10) VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 EMPL_ACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL Employee Contribution Account

Prompt Table: PA_EMPLACCT_SRC

4 EE_ROC_ASOF_DT_NAM Character(10) VARCHAR2(10) NOT NULL EE Split and ROC Asof Date Nam

Prompt Table: PA_DT_AND_AL_VW

5 DETERM_DT_INT Character(10) VARCHAR2(10) NOT NULL Determination Date Int Method

Prompt Table: PA_TBL_ALS_SRCH

6 PROJ_DT_IND Character(1) VARCHAR2(1) NOT NULL Porjection Date Indicator
L=Use Lump Sum date for project
N=Project to NRD
7 BAL_VALUE_ML_TYPE Character(1) VARCHAR2(1) NOT NULL Balance Value More/Less Type
L=Less Valuable of
M=More Valuable of
O=One Method

Default Value: O

8 BAL_PROJ_TBL1 Character(10) VARCHAR2(10) NOT NULL Balance Table Lookup 1

Prompt Table: PA_TBL_LOOKUP

9 BAL_PROJ_TBL2 Character(10) VARCHAR2(10) NOT NULL Balance Table Lookup 2

Prompt Table: PA_TBL_LOOKUP

10 USE_PBGC_GRAD1 Character(1) VARCHAR2(1) NOT NULL Use PBGC Grading

Y/N Table Edit

Default Value: N

11 USE_PBGC_GRAD2 Character(1) VARCHAR2(1) NOT NULL Use PBGC Grading

Y/N Table Edit

Default Value: N

12 ANNUTY_VAL_ML_TYPE Character(1) VARCHAR2(1) NOT NULL Annuity Value More/Less Flag
L=Less valuable factor of
M=More valuable factor of
O=One ANNUITY method

Default Value: O

13 ANNUTY_ACT_ASM1 Character(10) VARCHAR2(10) NOT NULL Annuity Actuarial Assumption 1

Prompt Table: PA_FACTOR_SETUP

14 ANNUTY_ACT_ASM2 Character(10) VARCHAR2(10) NOT NULL Annuity Actuarial Assumption 2

Prompt Table: PA_FACTOR_SETUP