GPNZ_PYENT_DTL(SQL Table) |
Index Back |
---|---|
NZ Pay entity detailsDetail 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 |