GPNZ_IRD_HEADER(SQL Table) |
Index Back |
---|---|
IRD HeaderIRD 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 |