| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
GPNZ_EMPL_UND18 |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Under 18 Field
Y/N Table Edit
|
| 5 |
GPNZ_KIW_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
This Field records the option chosen by the user regarding the Kiwisaver.
C=Savings Suspension
C=Contribution Holiday
I=Opting In
N=New Enrollment
O=Opting out
Default Value: N
|
| 6 |
GPNZ_KIW_TOT_RATE |
Number(2,0) |
SMALLINT NOT NULL |
This field is used to store Kiwisaver Contribution rate
|
| 7 |
GPNZ_KIW_ER_ADD_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
This Field is used to record whether the Employer Contribution is in addition to the Total Contribution.
Default Value: N
|
| 8 |
GPNZ_KIW_ER_RATE |
Number(2,0) |
SMALLINT NOT NULL |
This field is used to store Kiwisaver Employer Contribution rate
Default Value: 0
|
| 9 |
GPNZ_KIW_ER_FLAT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
KIWI DD ER from KIWI DD ER MTD accumulator
|
| 10 |
GPNZ_OPTOUT_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Employee Kiwisaver optout reason
CRIT=Criteria not met
ERIS=No invst stmt from Employer
EVNT=Out of control events
INER=<18 Yrs-Incorrectly controlled
INFO=No KS Info from Employer
IRIS=No invst stmt from IR
OTHR=Other Information
|
| 11 |
GPNZ_OPTOUT_DESCR |
Long Character(500) |
VARCHAR2(500) |
Employee Kiwisaver optout reason description when optout reason is other than the specified given reason.
|
| 12 |
GPNZ_OVRIDE_KS_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Override Kiwisaver Option - Only for PDR file
AE=Auto-Enroll
AK=Existing Kiwisaver Member
CT=Casual Employee
NK=Not Eligible for Kiwisaver
OK=Opt into Kiwisaver
|