GPNZ_PDR_EEFILE

(SQL Table)
Index Back

PDR Employment File DTL

Header Record for DTL Employment File

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 GPNZ_PDR_YEAR Character(4) VARCHAR2(4) NOT NULL Year code
3 PYMT_DT Date(10) DATE Payment Date
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 GPNZ_TAX_SCALE Character(4) VARCHAR2(4) NOT NULL New Zealand Tax Scale
6 GPNZ_DET_ID Character(3) VARCHAR2(3) NOT NULL Literal field 'DTR'
7 PRD_BGN_DT Date(10) DATE Period Begin Date
8 PRD_END_DT Date(10) DATE Pay Period End Date
9 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
10 GPNZ_IRD_NUMBER Character(9) VARCHAR2(9) NOT NULL New Zealand IRD Number
11 GPNZ_NAME Character(20) VARCHAR2(20) NOT NULL Name char field for IR348 download. Contains 'firstname surname', without commas.
12 GPNZ_START_DT Date(10) DATE Start Date for employees that have commenced employment during the month
13 GPNZ_FINISH_DT Date(10) DATE Finish Date for employees terminated during the month
14 GPNZ_TAX_GROSS Signed Number(16,2) DECIMAL(14,2) NOT NULL Taxable Gross Amount from Taxable Gross MTD Accumulator
15 GPNZ_GROSS_NO_EP Signed Number(16,2) DECIMAL(14,2) NOT NULL Gross Not Liable EP Amount from Retire/Redund MTD Accumulator
16 GPNZ_LUMP_SUM_FLAG Character(1) VARCHAR2(1) NOT NULL GPNZ Lump Sum Indicator
0=Lump Sum Off
1=Lump Sum On
N=Lum Sum Off
Y=Lump Sum On
17 GPNZ_PAYE_TAX_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL PAYE Tax Amount from PAYE Tax MTD Accumulator
18 GPNZ_CHILD_SUP_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Child Support Amount from Child Support MTD Accumulator
19 GPNZ_CHILD_SUP_VAR Character(1) VARCHAR2(1) NOT NULL Describes the variation key for child support
A=Advance Pay
C=Ceased Employment
D=Deducted previously
O=Other
P=Protected Earnings
S=Short Term Absence
20 GPNZ_STUD_LOAN_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
21 GPNZ_KIWI_EE_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD EE from KIWI DD EE MTD accumulator
22 GPNZ_KIWI_ER_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
23 GPNZ_KIWI_ECST_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL This field is used to capture ECST deduction made on the KiwiSaver Employer Contributions.
24 GPNZ_TX_CRDT_PG Signed Number(16,2) DECIMAL(14,2) NOT NULL Field to hold the tax credit for payroll giving
25 GPNZ_FAM_ASST_AMT Number(15,2) DECIMAL(14,2) NOT NULL Family Assist Amount
26 GPNZ_SLBOR_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
27 GPNZ_SLCIR_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
28 GPNZ_PP_PAYE_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Prior Period Payee Adjustments
29 GPNZ_PP_GRS_ADJ Signed Number(16,2) DECIMAL(14,2) NOT NULL Prior Period Gross Adjustments
30 GPNZ_GROSS_ESS Signed Number(16,2) DECIMAL(14,2) NOT NULL Gross Not Liable EP Amount from ESS MTD Accumulator
31 GPNZ_PAID_HOURS Signed Number(12,2) DECIMAL(10,2) NOT NULL Paid Hours