| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 3 |
GARNID |
Character(6) |
VARCHAR2(6) NOT NULL |
Garnish ID
|
| 4 |
GARN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnish Status
A=Garnishment Request Approved
C=Garnishment Deduct Completed
J=Garnishment Request Rejected
L=Garnishment Request Released
R=Garnishment Request Received
S=Garnishment Deduct Suspended
T=Garnishment Request Terminated
X=Garnishment Request Cancelled
Default Value: R
|
| 5 |
GARN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnish Type
A=Wage Assignment
B=Chapter 13 Bankruptcy
C=Child Support
D=Dependent Support
E=Social Security (AWG)
L=Tax Levy
S=Spousal Support
T=Student Loan Repayment
W=Writ of Garnishment
Default Value: W
|
| 6 |
COURT_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Court Name Issuing Order
|
| 7 |
COURT_DOC_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Court Document ID
|
| 8 |
COURT_DOC_ID2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Court Secondary Document ID
|
| 9 |
DOC_RCVD_DT |
Date(10) |
DATE NOT NULL |
Document Received Date
|
| 10 |
DOC_RCVD_HR |
Number(2,0) |
SMALLINT NOT NULL |
Document Received Hour
|
| 11 |
DOC_RCVD_MN |
Character(2) |
VARCHAR2(2) NOT NULL |
Document Received Minute
|
| 12 |
RESP_REQ_DT |
Date(10) |
DATE NOT NULL |
Response Required By Date
|
| 13 |
RESP_REQ_HR |
Number(2,0) |
SMALLINT NOT NULL |
Response Required by Hour
|
| 14 |
RESP_REQ_MN |
Character(2) |
VARCHAR2(2) NOT NULL |
Response Required By Minute
|
| 15 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 16 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 17 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 18 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 19 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 20 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 21 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 22 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 23 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 24 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 25 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 26 |
GARN_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Garnish Priority
|
| 27 |
CMPNY_INCL_DE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Company Fee Within DE
Y/N Table Edit
Default Value: Y
|
| 28 |
PAYEE_INCL_DE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Payee Fee Within DE
Y/N Table Edit
Default Value: Y
|
| 29 |
GARN_LIMIT_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Limit Amount
|
| 30 |
GARN_LIMIT_BAL |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Limit Balance
|
| 31 |
GARN_MTH_LIM_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Monthly Limit Amount
|
| 32 |
CMPNY_MTH_LIM_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Company Fee Monthly Limit Amt
|
| 33 |
PAYEE_MTH_LIM_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Payee Fee Monthly Limit Amount
|
| 34 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 35 |
STOP_DT |
Date(10) |
DATE |
Stop Date
|
| 36 |
AUTO_CALC_STOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Calc Stop Date
Y/N Table Edit
Default Value: N
|
| 37 |
AUT_CALC_STOP_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Auto Calc Stop Days
|
| 38 |
GARN_DED_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnish Deduction Schedule
A=Deduct on All Payrolls
S=Deduct by Schedule
Default Value: A
|
| 39 |
GARN_DED_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnish Deduction Calc Routine
G=Greater of %DE or Amount
H=Greater of %Gross or Amount
M=Maximum Allowed
P=% DE + Amount
R=% Gross + Amount
S=No exempt; %DE + Amt
T=No exempt; % of Gross
Default Value: M
|
| 40 |
GARN_DED_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Garnish Deduct DE Percent
|
| 41 |
GARN_DED_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Flat Deduction Amount
|
| 42 |
GARN_VAR_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnishment variable frequency.
D=Daily
M=Monthly
W=Weekly
Default Value: M
Prompt Table:
GRN_VAR_FREQ_VW
|
| 43 |
CMPNY_FEE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Company's Voucher Fee Percent
|
| 44 |
CMPNY_FEE_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Company's Voucher Fee Amount
|
| 45 |
PAYEE_FEE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Payee's Voucher Fee Percent
|
| 46 |
PAYEE_FEE_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Payee's Voucher Fee Amount
|
| 47 |
GARN_REMARKS |
Long Character |
CLOB |
Garnish Remarks
|
| 48 |
PRORATE_INEFF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Garn proration-in-effect sw
|
| 49 |
STATE_GARN_PRORATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Proration Rule State
|
| 50 |
GARN_PRORATE_RL_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Garnishment Proration Rule ID
Prompt Table:
PY_GARN_PROR_VW
|
| 51 |
GARN_SUPPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnishment Support Type
A=Arrears Order
C=Current Order
Default Value: C
|
| 52 |
PRORATE_OVRD_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Garn prorate override percent
|
| 53 |
PRORATE_OVRD_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garn prorate override amount
|
| 54 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
GARN_DEDCD_VW
|
| 55 |
PAY_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Mode
B=Pay when Bond Price met
C=Pay when Collection Completed
D=Pay as Deducted
S=Pay at Specified Date
Default Value: D
Prompt Table:
PAY_MODE_VW
|
| 56 |
GARN_PAYEE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Garnishment Payee Name
|
| 57 |
GVT_PYMNT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Method
C=Check
E=Electronic Funds Transfer
N=None
Default Value: E
|
| 58 |
GVT_CHK_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
GVT Check Payee Name
|
| 59 |
GVT_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
GVT Address Line 1
|
| 60 |
GVT_ADDRESS2 |
Character(35) |
VARCHAR2(35) NOT NULL |
GVT Address Line 2
|
| 61 |
GVT_ADDRESS_CITY |
Character(16) |
VARCHAR2(16) NOT NULL |
GVT Address City
|
| 62 |
GVT_ADDRESS_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
GVT Address State
Prompt Table:
STATE_NM_US_VW
|
| 63 |
GVT_ADDRESS_ZIP |
Character(10) |
VARCHAR2(10) NOT NULL |
GVT Address Zip
|
| 64 |
GVT_ADDRESS_CNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Address Country
Default Value: OPR_DEF_TBL_HR.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 65 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 66 |
ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Account Number
|
| 67 |
ACCOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
|
| 68 |
GVT_PAYEE_ID_NO |
Character(9) |
VARCHAR2(9) NOT NULL |
GVT EFT Payee ID Number
|
| 69 |
GVT_PAYEE_NAME |
Character(22) |
VARCHAR2(22) NOT NULL |
GVT EFT Account Holder
|
| 70 |
GVT_ALLOT_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT Allotment Pushbutton
|
| 71 |
CASE_IDENTIFIER |
Character(20) |
VARCHAR2(20) NOT NULL |
Case Identifier
|
| 72 |
FIPS_CODE |
Character(7) |
VARCHAR2(7) NOT NULL |
FIPS Code
|
| 73 |
EFT_REMIT_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Remittance State
IL=Illinois
IN=Indiana
MA=Massachusetts
NA=Select one
Prompt Table:
REMIT_STATE_TBL
|