GPAU_GARN_DTLS

#	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 Rcd Nbr
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Default Value: GP_RCP_PYE_DTL.PIN_NUM Prompt Table: GPAU_DED_SRCH
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: GP_RCP_PYE_DTL.EFFDT
5	GPAU_GARN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	GP Australia - Garnishment type 10=Assignment 20=Bankruptcy 30=Child Support 40=Dependant 50=Tax Levy 60=Writ
6	GPAU_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	GP Australia - Garnishment Processing Status 10=Approved 20=Completed 30=Rejected 40=Received 50=Suspended
7	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
8	GPAU_ORDER_REF_NO	Character(25)	VARCHAR2(25) NOT NULL	Garnishment Order Reference Number
9	GPAU_RCVD_DT_TM	DateTime(26)	TIMESTAMP	GP Australia - Garnishment Received date and time.
10	GPAU_RSP_REQ_DT_TM	DateTime(26)	TIMESTAMP	GP Australia - Garnishment Response required date and time.
11	COMMENTS	Long Character	CLOB	Comment
12	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
13	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
14	GPAU_FEES	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP Australia - Garnishement fees