# |
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
|
3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
4 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
5 |
FUNCTN_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
|
6 |
FLD_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Field Sequence Number
|
7 |
FLD_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
8 |
FLD_VAL_DEC_NOVRD |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Value - No Override
|