GPNZ_IRD_HEADER

(SQL Table)
Index Back

IRD Header

IRD header table to hold data to be reported to the NZ IRD for each Pay Entity.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 GPNZ_YEARCD Character(4) VARCHAR2(4) NOT NULL Year code
3 GPNZ_MONTHCD Character(2) VARCHAR2(2) NOT NULL Month code
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
4 GPNZ_PAYE_TAX_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 amounts for the PAYE Tax First Half month
5 GPNZ_TXCDT_PG_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL PG Tax Credit First Half
6 GPNZ_STUD_LOAN_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 student loan amounts for the First Half month
7 GPNZ_SLBOR_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 student loan amounts for the First Half month
8 GPNZ_SLCIR_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 student loan amounts for the First Half month
9 GPNZ_CHILD_SUP_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 child support amounts for the First Half month
10 GPNZ_SSCWT_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 SSCWT amounts for the First Half month
11 GPNZ_KIWI_EE_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD EE from KIWI DD EE MTD accumulator
12 GPNZ_KIWI_ER_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
13 GPNZ_KIWI_ETC_1ST Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
14 GPNZ_PAYE_TAX_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 amounts for the PAYE Tax First Half month
15 GPNZ_TXCDT_PG_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL PG Tax Credit Second Half
16 GPNZ_TX_CRDT_PG Signed Number(16,2) DECIMAL(14,2) NOT NULL Field to hold the tax credit for payroll giving
17 GPNZ_STUD_LOAN_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 student loan amounts for the Second Half month
18 GPNZ_SLBOR_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 student loan amounts for the Second Half month
19 GPNZ_SLCIR_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 student loan amounts for the Second Half month
20 GPNZ_CHILD_SUP_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 child support amounts for the Second Half month
21 GPNZ_SSCWT_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL IR 345/6 SSCWT amounts for the Second Half month
22 GPNZ_KIWI_EE_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD EE from KIWI DD EE MTD accumulator
23 GPNZ_KIWI_ER_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
24 GPNZ_KIWI_ETC_2ND Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
25 GPNZ_TAX_GROSS Signed Number(16,2) DECIMAL(14,2) NOT NULL Taxable Gross Amount from Taxable Gross MTD Accumulator
26 GPNZ_GROSS_NO_EP Signed Number(16,2) DECIMAL(14,2) NOT NULL Gross Not Liable EP Amount from Retire/Redund MTD Accumulator
27 GPNZ_ISSUE_STATUS Character(1) VARCHAR2(1) NOT NULL Issue status describes the level of the report. 4 levels on whether a report has been issued First Half Created, IR348 Ready, IR348 Issued or Not Issued.
1=First Half Created
2=IRD348 Ready
3=IR348 Issued
4=Not to be Issued
28 GPNZ_DT_1ST_CREATE Date(10) DATE Date record first created
29 GPNZ_DT_2ND_CREATE Date(10) DATE Date second created
30 GPNZ_DT_IR_ISSUED Date(10) DATE Date IR 348 Issued