| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table:
GPNZ_EEPYENT_VW
|
| 4 |
BALANCE_GRP_NUM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field will be used to determine the grouping of balances from the different jobs of the employee.
Prompt Table:
GPNZ_EEBLGRP_VW
|
| 5 |
GPNZ_TAX_SCALE |
Character(4) |
VARCHAR2(4) NOT NULL |
New Zealand Tax Scale
|
| 6 |
GPNZ_PAY_NATURE |
Character(6) |
VARCHAR2(6) NOT NULL |
New Zealand Nature of Payment
Prompt Table:
GPNZ_WT_RATE_VW
|
| 7 |
GPNZ_TAX_OVRD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand Tax Override Type
C=PAYE Tax Code
N=None
R=PAYE Tax Rate
W=Withholding Tax Rate
Default Value: N
|
| 8 |
GPNZ_OVRD_TAX_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
New Zealand Override Tax Code
CAE=Casual Agricultural / Shearing
EDW=Election Day Worker
M=Main
ME=Main income - IETC
MESL=Main Income-Student Loan-IETC
ML=Main, Low Income
ML=Main, Low Income
MLSL=Main,Low Income,Student Loan
MLSL=Main,Low Income,Student Loan
MSL=Main, Student Loan
NSW=Non-resident Seasonal worker
S=Secondary
SB=Lower Secondary Tax
SBSL=Lower Secondary Tax,SL
SH=Secondary, High Bracket
SHSL=Secondary, High, Student Loan
SSL=Secondary, Student Loan
ST=Secondary, Top Bracket
STSL=Secondary, Top, Student Loan
|
| 9 |
GPNZ_OVRD_PAY_RATE |
Signed Number(6,4) |
DECIMAL(4,4) NOT NULL |
New Zealand Override PAYE Tax Rate
|
| 10 |
GPNZ_OVRD_WT_RATE |
Signed Number(6,4) |
DECIMAL(4,4) NOT NULL |
New Zealand Override Withholding Tax Rate
|
| 11 |
GPNZ_SL_OVRD_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand Student Loan Override Flag
Y/N Table Edit
Default Value: N
|
| 12 |
GPNZ_ADV_BUTTON |
Character(1) |
VARCHAR2(1) NOT NULL |
This is used as a Push-Button for calculating Absence Advances on the GP NZL Absence Advance page.
Y/N Table Edit
|
| 13 |
GPNZ_SL_OVRD_RATE |
Signed Number(6,4) |
DECIMAL(4,4) NOT NULL |
New Zealand Student Loan Override Rate
|
| 14 |
GPNZ_SL_ADDL_AMT |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Student Loan Extra Dollar
|
| 15 |
GPNZ_EP_OVRD_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand Earner Premium Override Flag
Y/N Table Edit
Default Value: N
|
| 16 |
GPNZ_EP_OVRD_RATE |
Signed Number(6,4) |
DECIMAL(4,4) NOT NULL |
New Zealand Earner Premium Override Rate
|
| 17 |
GPNZ_IR23_CERT_NO |
Character(8) |
VARCHAR2(8) NOT NULL |
New Zealand IR23 Certificate Number
|
| 18 |
GPNZ_IR23_EXP_DT |
Date(10) |
DATE |
New Zealand IR23 Expiry Date
|
| 19 |
GPNZ_WT_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand Withholding Tax Exempt
Y/N Table Edit
Default Value: N
|
| 20 |
GPNZ_IR331_CERT_NO |
Character(8) |
VARCHAR2(8) NOT NULL |
New Zealand IR331 Certificate Number
|
| 21 |
GPNZ_IR331_EXP_DT |
Date(10) |
DATE |
New Zealand IR331 Expiry Date
|
| 22 |
GPNZ_EE_TAX_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand Extra Emolument Tax Option
1=Normal EE Rate
2=Use Tax Rate 30%
3=Use Tax Rate 33%
4=Use Tax Rate 17.5%
Default Value: 1
|