| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
EMPL_CO_VW
|
| 3 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 4 |
LIMIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Limit Type
401=401(a) Limit
401G=401(a) Limit Grandfather Plan
402=402(g) Limit
403=403(b) Limit
415=415(c) Limit
415Z=415(c) Limit for 403(b) plans
457=457 Limit
CH01=User Defined Per Check Limit 1
CH02=User Defined Per Check Limit 2
CH03=User Defined Per Check Limit 3
CH04=User Defined Per Check Limit 4
CH05=User Defined Per Check Limit 5
USER=User Defined Limit
Default Value: 402
Prompt Table:
EXP_LMT_TYP_VW
|
| 5 |
LIMIT_EXT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Extension Type
A=Catch Up - Extend Limit
B=Age 50 - Extend Limit
E=Adjust Eligible Earnings YTD
H=Hardship - Reduce Limit
Default Value: B
Prompt Table:
%EDITTABLE
|
| 6 |
EXT_AMOUNT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Extension Amount
|
| 7 |
EXT_ELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Extension Election
Y/N Table Edit
Default Value: Y
|
| 8 |
LMT_AMT_OVRD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Limit Amount Override
|
| 9 |
LTD_SERVICE_YEARS |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Service Years LTD
|
| 10 |
YTD_SERVICE_YEARS |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Service Years YTD
|
| 11 |
GRS_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Gross Earnings YTD
|
| 12 |
DED_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Deduction Balance YTD
|
| 13 |
DED_YTD_NON_ELECT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Ded YTD Non-Elect
|
| 14 |
DED_YTD_ER |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Ded YTD Employer
|
| 15 |
DED_LTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Deduction Balance LTD
|
| 16 |
DED_LTD_NON_ELECT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Ded LTD Non Elect
|
| 17 |
DED_LTD_ER |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Ded LTD Employer
|
| 18 |
DED_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Deduction Adjustment Balance field.
|
| 19 |
DED_ADJ_NON_ELECT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Deduction Balance Non-Elect
|
| 20 |
DED_ADJ_ER |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Deduction Balance Employer
|
| 21 |
DED_ADJ_PA |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Deduction Adj from PA
|
| 22 |
SERVICE_YRS_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Service Years Calc
Y/N Table Edit
Default Value: N
|
| 23 |
YTD_402G_CAP_USED |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
402(g) Cap Extension Used YTD
|
| 24 |
LTD_402G_CAP_USED |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
402(g) Cap Extension Used LTD
|
| 25 |
YTD_402G_DED |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
402(g) Deduction Year to Date
|
| 26 |
LTD_402G_DED |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
402(g) Deductions LTD
|
| 27 |
YTD_415_DED |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
415 Deductions YTD
|
| 28 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 29 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 30 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|