| # |
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 |
L415_DEFINITION |
Character(10) |
VARCHAR2(10) NOT NULL |
415 Limit Definition
|
| 5 |
MAX_LIMIT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Maximum 415(b) Limit
|
| 6 |
FAE_LIMIT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
FAE Limit
|
| 7 |
MAX_ADJ |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Maximum 415(b) Limit Adjusted
|
| 8 |
FAE_ADJ |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
FAE Limit Adjusted
|
| 9 |
COLA_ADJ |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Cost of Living Adjustment
|
| 10 |
DB_FRACTION |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Defined Benefit Fraction
|
| 11 |
DC_FRACTION |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Defined Contribution Fraction
|
| 12 |
DB_415E_LIMIT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Historical 415(e) Limit
|
| 13 |
SLA_AMOUNT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Total SLA Benefit
|
| 14 |
USED_415_LIMIT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Limit Amount used in 415
|
| 15 |
REDUCTION_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
415 Reduction Amount
|