GPNZ_NRP_GR2_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
5	EFFDT	Date(10)	DATE	Effective Date
6	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
7	GPNZ_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	GP NZL - Garnishment Processing Status 10=Approved 20=Completed 30=Rejected 40=Received 50=Suspended
8	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
9	GPNZ_ORDER_REF_NO	Character(25)	VARCHAR2(25) NOT NULL	Garnishment Order Reference Number
10	GPNZ_RCVD_DTTM	DateTime(26)	TIMESTAMP	GP NZL - Garnishment Received date and time.
11	GPNZ_RSP_REQ_DTTM	DateTime(26)	TIMESTAMP	GP NZL - Garnishment Response required date and time.
12	COMMENTS	Long Character	CLOB	Comment
13	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
14	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
15	GPNZ_FEES	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP NZL - Garnishement fees