| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
GPES_COURT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Court Order ID
|
| 3 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
Default Value: %date
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
END_DT |
Date(10) |
DATE |
end date
|
| 6 |
GPES_PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority Number
|
| 7 |
GPES_TYPE_OF_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnishment calculation type
1=Based on Ranges of SMI
2=Amount
3=Percentage
4=Other
|
| 8 |
GPES_GRN_AMOUNT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Garnishment Amount
|
| 9 |
GPES_GRN_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Percentage
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
GPES_ENT_TYPE_PCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Seniority duration entry type
Prompt Table:
GPES_GRPCTEL_VW
|
| 12 |
GPES_ENT_TYPE_GEN |
Character(3) |
VARCHAR2(3) NOT NULL |
Seniority duration entry type
Prompt Table:
GPES_GROTHEL_VW
|
| 13 |
GPES_ALIMONY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Alimony Flag
Y/N Table Edit
|
| 14 |
GPES_ALIMONY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Alomony Type
C=Children Support
S=Spouse Support
|
| 15 |
GPES_TAKE_XTRPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Advance/Loan repayment at extra periods option
Y/N Table Edit
|
| 16 |
GPES_ENT_TYPE_GRN |
Character(3) |
VARCHAR2(3) NOT NULL |
Seniority duration entry type
Prompt Table:
GPES_GRN_EL_VW
|
| 17 |
GPES_GRN_PERIODCTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnishment periodicity
O=One Time
R=Recurrent
|
| 18 |
GPES_GRN_TOT_AMT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Garnishment Total Amount
|
| 19 |
GPES_DISCNT_PYROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount from Payroll
Y/N Table Edit
|
| 20 |
GPES_GRN_MORTGAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag identifying court order is due non-paid home Mortgage
Y/N Table Edit
Default Value: N
|
| 21 |
GPES_GRN_DEPN_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Number of dependants
|
| 22 |
GPES_PIN_SMI |
Number(8,0) |
INTEGER NOT NULL |
Garnishment SMI Pin Number
Prompt Table:
%GP_EDIT_FLD3
|
| 23 |
GPES_PIN_GENELT |
Number(8,0) |
INTEGER NOT NULL |
General Element Calculation
Prompt Table:
%GP_EDIT_FLD2
|
| 24 |
GPES_PIN_PCTELT |
Number(8,0) |
INTEGER NOT NULL |
Element to apply percentage
Prompt Table:
%GP_EDIT_FLD4
|
| 25 |
GPES_GRN_SMISCALE1 |
Number(3,0) |
SMALLINT NOT NULL |
Garnishment scale 1 percentage
|
| 26 |
GPES_GRN_SMISCALE2 |
Number(3,0) |
SMALLINT NOT NULL |
Garnishment scale 2 percentage
|
| 27 |
GPES_GRN_SMISCALE3 |
Number(3,0) |
SMALLINT NOT NULL |
Garnishment scale 3 percentage
|
| 28 |
GPES_GRN_SMISCALE4 |
Number(3,0) |
SMALLINT NOT NULL |
Garnishment scale 4 percentage
|
| 29 |
GPES_GRN_SMISCALE5 |
Number(3,0) |
SMALLINT NOT NULL |
Garnishment scale 5 percentage
|
| 30 |
GPES_GRN_RECPNT_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Garnishment recipient code
Prompt Table:
GP_RCPPYEDTL_VW
|
| 31 |
GPES_GRN_SRC_CRTID |
Character(4) |
VARCHAR2(4) NOT NULL |
Source Court ID for Garnishment
|
| 32 |
GPES_GRN_SRCCRTORD |
Character(44) |
VARCHAR2(44) NOT NULL |
Court order source
|
| 33 |
GPES_GRN_ORGANISM |
Character(4) |
VARCHAR2(4) NOT NULL |
Organism for Garnishment
|
| 34 |
GPES_GRN_CNTRL_DGT |
Character(4) |
VARCHAR2(4) NOT NULL |
Control Digit
Default Value: 0000
|
| 35 |
GPES_GRN_PRCTYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Procedure Type
|
| 36 |
GPES_GRN_FILE_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
File Code for Garnishment.
|
| 37 |
GPES_GRN_CREATN_YR |
Number(2,0) |
SMALLINT NOT NULL |
Creation Year
|
| 38 |
GPES_GRN_SUBJECT |
Character(2) |
VARCHAR2(2) NOT NULL |
Subject
01=Principal Sum
02=On account of Principal
03=Intrest
04=On account of Intrest
05=Court Fees
06=On account of court Fees
07=Serverance
08=Jur appeal
09=Transfer
10=Bond Refund
11=Spare Amount
12=On account of fees and intrest
13=Rent
14=Fines
15=Refund of Income
16=Other
|