| # |
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 |
Projection Date Option
L=Use Lump Sum Date
N=Project to NRD
|
| 7 |
BAL_VALUE_ML_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Projection Option
L=Less Valuable of 2 Selected
M=More Valuable of 2 Selected
O=Single Lookup Table
Default Value: O
|
| 8 |
BAL_PROJ_TBL1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Lookup Table
Prompt Table:
PA_TBL_LOOKUP
|
| 9 |
BAL_PROJ_TBL2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Lookup Table 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 |
Convertion Option
L=Less Valuable of 2 Selected
M=More Valuable of 2 Selected
O=Single Factor
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
|