| # |
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 |
Garnishment 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
|
| 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 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 16 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 17 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 18 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 19 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 20 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 21 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 22 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 23 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 24 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 25 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 26 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 27 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 28 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 29 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 30 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 31 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 32 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 33 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 34 |
GARN_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Garnishment priority.
|
| 35 |
CMPNY_INCL_DE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Company Fee Within DE
Y/N Table Edit
Default Value: Y
|
| 36 |
PAYEE_INCL_DE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Payee Fee Within DE
Y/N Table Edit
Default Value: Y
|
| 37 |
GARN_LIMIT_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Limit Amount
|
| 38 |
GARN_LIMIT_BAL |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Limit Balance
|
| 39 |
GARN_MTH_LIM_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnish Monthly Limit Amount
|
| 40 |
CMPNY_MTH_LIM_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Company Fee Monthly Limit Amt
|
| 41 |
PAYEE_MTH_LIM_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Payee Fee Monthly Limit Amount
|
| 42 |
PY_GARN_ANNUAL_LIM |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Annual Limit
|
| 43 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 44 |
STOP_DT |
Date(10) |
DATE |
Stop Date
|
| 45 |
AUTO_CALC_STOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Calc Stop Date
Y/N Table Edit
Default Value: N
|
| 46 |
AUT_CALC_STOP_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Auto Calc Stop Days
|
| 47 |
GARN_DED_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnish Deduction Schedule
A=Deduct on All Payrolls
S=Deduct by Schedule
Default Value: A
|
| 48 |
GARN_DED_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction calculation 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
Prompt Table:
PY_GARN_CALC_VW
|
| 49 |
GARN_DED_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Garnishment deduction percent.
|
| 50 |
GARN_DED_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garnishment flat amount.
|
| 51 |
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
|
| 52 |
CMPNY_FEE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Company's voucher fee percent.
|
| 53 |
CMPNY_FEE_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Company's voucher fee amount.
|
| 54 |
PAYEE_FEE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Payee's voucher fee percent.
|
| 55 |
PAYEE_FEE_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Payee's voucher fee amount.
|
| 56 |
GARN_REMARKS |
Long Character |
CLOB |
Garnish Remarks
|
| 57 |
PRORATE_INEFF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Garn proration-in-effect sw
|
| 58 |
STATE_GARN_PRORATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Proration Rule State
|
| 59 |
GARN_PRORATE_RL_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Garnishment Proration Rule ID
Prompt Table:
PY_GARN_PROR_VW
|
| 60 |
GARN_SUPPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Garnishment Support Type
A=Arrears Order
C=Current Order
Default Value: C
|
| 61 |
PRORATE_OVRD_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Garn prorate override percent
|
| 62 |
PRORATE_OVRD_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Garn prorate override amount
|
| 63 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
GARN_DEDCD_VW
|
| 64 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 65 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_GARN_VW
|
| 66 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
PY_GARN_LOC_VW
|
| 67 |
ADDRESS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Address Sequence Number
Prompt Table:
PY_GARN_ADD_VW
|
| 68 |
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
Prompt Table:
PAY_MODE_VW
|
| 69 |
AP_PAYMENT_DT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
AP Payment Date Type
C=Check Date
P=Pay Period End Date
|
| 70 |
SEPARATE_AP_PAYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate AP Payment
Y/N Table Edit
|
| 71 |
GARN_PAYEE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Garnishment Payee Name
|
| 72 |
EFT_PAYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Funds Transfer Info
Y/N Table Edit
Default Value: N
|
| 73 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 74 |
ACCOUNT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
Account Number
|
| 75 |
ACCOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
Default Value: C
|
| 76 |
CASE_IDENTIFIER |
Character(20) |
VARCHAR2(20) NOT NULL |
Case Identifier
|
| 77 |
FIPS_CODE |
Character(7) |
VARCHAR2(7) NOT NULL |
FIPS Code
|
| 78 |
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
|
| 79 |
PY_BANKACCCRYPT |
Character(100) |
VARCHAR2(100) NOT NULL |
Encrypted Bank Account
|