PAY_ENTITYGPNZ_PDR_YEARCAL_RUN_IDPYMT_DTGPNZ_PDR_RNTYPAMD=Amendment
NRM=Original
OVR=Override
Default Value: NRM
GPNZ_PDR_VERSIONGPNZ_PDR_STATUS3=PDR File Generated
4=PDR Ready
GPNZ_PDR_ER_SMR(SQL View) |
Index Back |
|---|---|
IRD Employee DetailsHeader data for NZ PDR |
| SELECT PAY_ENTITY , GPNZ_PDR_YEAR , CAL_RUN_ID , PYMT_DT , GPNZ_PDR_RNTYP , GPNZ_PDR_VERSION , GPNZ_PDR_STATUS , GPNZ_IRD_NUMBER , GPNZ_PAYE_TAX_AMT , GPNZ_CHILD_SUP_AMT , GPNZ_STUD_LOAN_AMT , GPNZ_KIWI_EE_DED , GPNZ_KIWI_ER_DED , GPNZ_SSCWT_AMT , GPNZ_PDR_TOT_DED , GPNZ_TX_CRDT_PG , GPNZ_FAM_ASST_AMT , GPNZ_TAX_GROSS , GPNZ_GROSS_NO_EP , GPNZ_KIWI_ETC , GPNZ_SLBOR_AMT , GPNZ_SLCIR_AMT , GPNZ_GROSS_ESS FROM PS_GPNZ_PDR_ER_DTL WHERE EXISTS( SELECT CL.CAL_RUN_ID FROM PS_GP_CAL_RUN CL WHERE CL.CAL_RUN_ID = PS_GPNZ_PDR_ER_DTL.CAL_RUN_ID AND (CL.RUN_OPEN_IND = 'Y' OR CL.RUN_FINALIZED_IND = 'Y')) |
| # | 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 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | PYMT_DT |
Date(10) | DATE | Payment Date |
| 5 | GPNZ_PDR_RNTYP |
Character(3) | VARCHAR2(3) NOT NULL |
PDR Run Type
AMD=Amendment NRM=Original OVR=Override Default Value: NRM |
| 6 | GPNZ_PDR_VERSION |
Number(10,0) | DECIMAL(10) NOT NULL | New Field - Version added for PDR |
| 7 | GPNZ_PDR_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Issue status describes the level of the report.PDR Issued status
3=PDR File Generated 4=PDR Ready |
| 8 | GPNZ_IRD_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | New Zealand IRD Number |
| 9 | GPNZ_PAYE_TAX_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | PAYE Tax Amount from PAYE Tax MTD Accumulator |
| 10 | GPNZ_CHILD_SUP_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Child Support Amount from Child Support MTD Accumulator |
| 11 | GPNZ_STUD_LOAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 12 | GPNZ_KIWI_EE_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD EE from KIWI DD EE MTD accumulator |
| 13 | GPNZ_KIWI_ER_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 14 | GPNZ_SSCWT_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | SSCWT Amount |
| 15 | GPNZ_PDR_TOT_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | New Field added for PDR |
| 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_FAM_ASST_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Family Assist Amount |
| 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_KIWI_ETC | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 21 | GPNZ_SLBOR_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 22 | GPNZ_SLCIR_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 23 | GPNZ_GROSS_ESS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from ESS MTD Accumulator |