GPNZ_WT_RATE_VW (SQL View)	Index Back
New Zealand WT Rate View This table is a view of the nature of payment rates table GPNZ_WT_RATE without any peoplecodes. This is used as a prompt table when entering the Nature of Payment at the employees IRD details.

GPNZ_WT_RATE_VW

(SQL View)

New Zealand WT Rate View

This table is a view of the nature of payment rates table GPNZ_WT_RATE without any peoplecodes. This is used as a prompt table when entering the Nature of Payment at the employees IRD details.

SELECT DISTINCT GPNZ_PAY_NATURE , DESCR50 FROM PS_GPNZ_WT_RATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPNZ_PAY_NATURE Character(6) VARCHAR2(6) NOT NULL New Zealand Nature of Payment

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPNZ_PAY_NATURE	Character(6)	VARCHAR2(6) NOT NULL	New Zealand Nature of Payment
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50