GPNZ_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 Prompt Table: GPNZ_DED_SRCH
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
5	GPNZ_GARN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	GP NZL - Garnishment type 10=Assignment 20=Bankruptcy 30=Child Support 40=Dependant 50=Tax Levy 60=Writ
6	GPNZ_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	GP NZL - 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	GPNZ_ORDER_REF_NO	Character(25)	VARCHAR2(25) NOT NULL	Garnishment Order Reference Number
9	GPNZ_RCVD_DTTM	DateTime(26)	TIMESTAMP	GP NZL - Garnishment Received date and time.
10	GPNZ_RSP_REQ_DTTM	DateTime(26)	TIMESTAMP	GP NZL - 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	GPNZ_FEES	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP NZL - Garnishement fees