GPNZ_IRD_RC_AET(SQL Table) |
Index Back |
|---|---|
Run CNTL- Process CR8 IRD DataRun control record for Process Create IRD data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 8 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 9 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 10 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 11 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 12 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 13 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 14 | GPNZ_YEARCD | Character(4) | VARCHAR2(4) NOT NULL | Year code |
| 15 | 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 |
| 16 | GPNZ_HALF_MONTH | Character(1) | VARCHAR2(1) NOT NULL |
This field to indicate if the process is to be run for the first half of the month or the second half of the month.
1=First 2=Second |
| 17 | GPNZ_TAX_SCALE | Character(4) | VARCHAR2(4) NOT NULL | New Zealand Tax Scale |
| 18 | GPNZ_TAX_GROSS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Taxable Gross Amount from Taxable Gross MTD Accumulator |
| 19 | GPNZ_GROSS_NO_EP | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from Retire/Redund MTD Accumulator |
| 20 | 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 |
| 21 | GPNZ_PAYE_TAX_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | PAYE Tax Amount from PAYE Tax MTD Accumulator |
| 22 | GPNZ_TX_CRDT_PG | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Tax Credit for Payroll Giving |
| 23 | GPNZ_CHILD_SUP_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Child Support Amount from Child Support MTD Accumulator |
| 24 | 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 |
| 25 | GPNZ_STUD_LOAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 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_SSCWT_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | SSCWT Amount |
| 29 | GPNZ_KIWI_EE_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD EE from KIWI DD EE MTD accumulator |
| 30 | GPNZ_KIWI_ER_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 31 | GPNZ_KIWI_ETC | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 32 | GPNZ_START_DT | Date(10) | DATE | Start Date for employees that have commenced employment during the month |
| 33 | GPNZ_FINISH_DT | Date(10) | DATE | Finish Date for employees terminated during the month |
| 34 | GPNZ_EXCEPTION_CD | Character(1) | VARCHAR2(1) NOT NULL |
Describes the exception code for IRD reporting
1=Negative value 2=Child support variation 3=No Tax Details 4=No IRD Number 5=Changed since issue |
| 35 | GPNZ_DT_IR_ISSUED | Date(10) | DATE | Date IR 348 Issued |
| 36 | GPNZ_RUN_TYPE_IR | Character(3) | VARCHAR2(3) NOT NULL |
Parameter field for create IRD Data process where it has two values:
"Actuals" or "Exceptions".
00=Actuals 01=Exceptions |
| 37 | GPNZ_RECREATE | Character(1) | VARCHAR2(1) NOT NULL |
Parameter field to indicate if the process is to be run again.
N=No Y=Yes |
| 38 | GPNZ_TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary flag |
| 39 | GPNZ_1HM_DT_BEGIN | Date(10) | DATE | Begin 1 Half Month Date for IR 348 Issued |
| 40 | GPNZ_1HM_DT_END | Date(10) | DATE | End 1st Half Month Date for IR 348 Issued |
| 41 | GPNZ_LAST_DAY_MTH | Date(10) | DATE | Last day of Month Date |
| 42 | GPNZ_2HM_DT_REFEND | Date(10) | DATE | Reference End 2nd Half Month Date for IR 348 Issued |
| 43 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 44 | GPNZ_ACUM_PIN_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number |
| 45 | GPNZ_CHILD_SUP_REG | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | This field is used as a work field in the year end process |