| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 2 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
DED_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Deduction Priority
Default Value: 500
|
| 7 |
SPCL_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Process
B=Bond
G=Garnishment
U=Union Dues
|
| 8 |
MAX_PAYBACK |
Character(1) |
VARCHAR2(1) NOT NULL |
Maximum Arrears Payback
F=Factor x Regular Deduction
N=No Maximum
Y=Flat Maximum for Payback
Default Value: N
|
| 9 |
MAX_ARREARS_PAYBK |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Maximum Arrears Payback
|
| 10 |
MAX_ARREARS_FACTOR |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Max Payback - Factor x Reg Ded
|
| 11 |
GVT_DIST_DEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Destinations
N=Not Applicable
R=OPM/RITS Interface
S=Thrift Savings Board Interface
T=U.S. Department of Treasury
Default Value: N
|
| 12 |
GVT_REPORTING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reporting Code
Default Value: NA
|
| 13 |
GVT_TIME_SENSITIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identify General Deductions that are processed by the Treasury Interface that are of time sensitive nature
Y/N Table Edit
Default Value: N
|
| 14 |
PERMANENCY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Permanency is used for HR Netherlands to track for Earnings and Deductions which are incidental, permanent or both.
B=Both
I=Incidental
P=Permanent
Default Value: B
|
| 15 |
TAX_CLASS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Class is used for HR Netherlands to be tracked for Earnings and Deductions.
1=Wage Tax and Social Security
2=Wage Tax, No Social Security
3=No Wage Tax, Social Security
4=No Wage Tax,No Social Security
Default Value: 1
|
| 16 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
UNION_TBL
|