GPAR_GARN_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GPAR_GARNISH_NBR	Number(3,0)	SMALLINT NOT NULL	Garnishment Number
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	GPAR_GARNISH_STAT	Character(2)	VARCHAR2(2) NOT NULL	Garnishment Status AC=Active CA=Canceled CU=Accomplished PE=Pending Default Value: AC
6	REASON_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Reason Description
7	GPAR_AMOUNT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	GPAR_INTEREST	Number(19,6)	DECIMAL(18,6) NOT NULL	Interest
10	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	GPAR_TOTAL	Number(19,6)	DECIMAL(18,6) NOT NULL	Total Amount
12	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	GPAR_GARNISH_PERC	Number(5,2)	DECIMAL(4,2) NOT NULL	Percentage
14	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPAR_GARNEL_VW
15	PAYMENT_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of payment.
16	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code
17	BANK_ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
18	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
19	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: BANK_BRANCH_TBL