GPNZ_PDR_EEDTMP(SQL Table) |
Index Back |
|---|---|
PDR New Depart File Temp TblNew Zealand - New and Departing Employee File - Detail Temp Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 5 | 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. |
| 6 | GPNZ_IRD_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | New Zealand IRD Number |
| 7 | GPNZ_NAME | Character(20) | VARCHAR2(20) NOT NULL | Name char field for IR348 download. Contains 'firstname surname', without commas. |
| 8 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Name Title |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 10 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 11 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 12 | DATE_OF_BIRTH | Date(10) | DATE | Date of Birth |
| 13 | GPNZ_TAX_SCALE | Character(4) | VARCHAR2(4) NOT NULL | New Zealand Tax Scale |
| 14 | GPNZ_START_DT | Date(10) | DATE | Start Date for employees that have commenced employment during the month |
| 15 | GPNZ_FINISH_DT | Date(10) | DATE | Finish Date for employees terminated during the month |
| 16 | GPNZ_PDR_KIWI_ST | Character(22) | VARCHAR2(22) NOT NULL | PDR KIWI Status Description |
| 17 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 18 | GPNZ_PDR_MOB_CNTR | Character(30) | VARCHAR2(30) NOT NULL | PDR Mobile Phone |
| 19 | GPNZ_PDR_MOB_AC | Character(10) | VARCHAR2(10) NOT NULL | PDR Mobile Phone |
| 20 | GPNZ_PDR_MOB_NBR | Character(30) | VARCHAR2(30) NOT NULL | PDR Mobile PhoneNumber |
| 21 | GPNZ_PDR_MOB_EXT | Character(20) | VARCHAR2(20) NOT NULL | PDR Mobile PhoneExtn |
| 22 | GPNZ_PDR_DTPH_CNTR | Character(30) | VARCHAR2(30) NOT NULL | PDR DayTime Phone |
| 23 | GPNZ_PDR_DTPH_AC | Character(10) | VARCHAR2(10) NOT NULL | PDR DayTime Phone |
| 24 | GPNZ_PDR_DTPH_NBR | Character(30) | VARCHAR2(30) NOT NULL | PDR DayTime PhoneNumber |
| 25 | GPNZ_PDR_DTPH_EXT | Character(20) | VARCHAR2(20) NOT NULL | PDR DayTime PhoneExtn |
| 26 | GPNZ_PDR_UNIT_TYP | Character(50) | VARCHAR2(50) NOT NULL | PDR Employee File Unit Type |
| 27 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 28 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 29 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 30 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 31 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 32 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 33 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 34 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 35 | ACCOUNT_TYPE_PYE | Character(1) | VARCHAR2(1) NOT NULL |
Payee Bank Account Type
A=Current Account B=Building Society Roll Number C=Checking G=Giro Account R=Regular S=Savings T=Salary Account |
| 36 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 37 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 38 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 39 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 40 | GPNZ_PDR_KIWI_EG | Character(22) | VARCHAR2(22) NOT NULL | PDR KIWI Eligibility code |
| 41 | GPNZ_EXEMPT_CD | Character(25) | VARCHAR2(25) NOT NULL | This Field records Income exemption code |
| 42 | GPNZ_KIW_OPTYN | Character(1) | VARCHAR2(1) NOT NULL | This Field records the option chosen by the user regarding the Kiwisaver. |
| 43 | GPNZ_OPTOUT_DT | Date(10) | DATE | Kiwisaver optout date |
| 44 | 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 |
| 45 | GPNZ_OPTOUT_DESCR | Long Character(500) | VARCHAR2(500) | Employee Kiwisaver optout reason description when optout reason is other than the specified given reason. |