GPNZ_PYENT_DTL

(SQL Table)
Index Back

NZ Pay entity details

Detail store for NZ pay entity

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 EFFDT Date(10) DATE NOT NULL Effective Date
3 GPNZ_IRD_NUMBER Character(9) VARCHAR2(9) NOT NULL New Zealand IRD Number
4 GPNZ_CONTACT_ID Character(11) VARCHAR2(11) NOT NULL Contact ID using PERSONAL DATA

Prompt Table: PERSON_NAME

5 GPNZ_CONTACT_PHONE Character(12) VARCHAR2(12) NOT NULL IR Contact Phone Number