GPNZ_PDRFLE_AET(SQL Table) |
Index Back |
|---|---|
PDR Employment File AETState Record for PDR Employment File process |
| # | 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 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 6 | GPNZ_PDR_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Year code |
| 7 | PYMT_DT | Date(10) | DATE | Payment Date |
| 8 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 9 | GPNZ_PDR_FL_RNTYP | Character(1) | VARCHAR2(1) NOT NULL |
PDR Employment File Run Control - Run Type
P=Production T=Test |
| 10 | GPNZ_PDR_RNTYP | Character(3) | VARCHAR2(3) NOT NULL |
PDR Run Type
AMD=Amendment NRM=Original OVR=Override |
| 11 | GPNZ_PDR_FL_TYP | Character(4) | VARCHAR2(4) NOT NULL |
PDR Employment File Run Control - File Type
CSV=CSV XLS=XLS XML=XML |
| 12 | GPNZ_PDR_FINRET_ER | Character(1) | VARCHAR2(1) NOT NULL |
PDR Employment File Run Control - Final Return Indicator
Y/N Table Edit |
| 13 | GPNZ_PDR_NILRET_ER | Character(1) | VARCHAR2(1) NOT NULL |
PDR Employment File Run Control - Nil Return Indicator
Y/N Table Edit |
| 14 | GPNZ_PDR_IN_IRDNBR | Character(9) | VARCHAR2(9) NOT NULL | PDR Employment File Run Control - Intermediary IRD Number |
| 15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 16 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 17 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 18 | 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. |
| 19 | GPNZ_TAX_SCALE | Character(4) | VARCHAR2(4) NOT NULL | New Zealand Tax Scale |
| 20 | GPNZ_TAX_GROSS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Taxable Gross Amount from Taxable Gross MTD Accumulator |
| 21 | GPNZ_GROSS_ESS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from ESS MTD Accumulator |
| 22 | GPNZ_STLN_ESS_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount for ESS from Student Loan MTD Accumulator |
| 23 | GPNZ_GROSS_NO_EP | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from Retire/Redund MTD Accumulator |
| 24 | 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 |
| 25 | GPNZ_PAYE_TAX_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | PAYE Tax Amount from PAYE Tax MTD Accumulator |
| 26 | GPNZ_TX_CRDT_PG | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Field to hold the tax credit for payroll giving |
| 27 | GPNZ_CHILD_SUP_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Child Support Amount from Child Support MTD Accumulator |
| 28 | 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 |
| 29 | GPNZ_STUD_LOAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 30 | GPNZ_SLBOR_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 31 | GPNZ_SLCIR_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 32 | GPNZ_SLBOR_ESS_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan BOR Amount on ESS from Student Loan MTD Accumulator for ESS |
| 33 | GPNZ_SLCIR_ESS_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan CIR Amount for ESS from Student Loan MTD Accumulator |
| 34 | GPNZ_XE_ESS_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Extra Emolument on ESS from Extra Emolument on ESS MTD Accumulator |
| 35 | GPNZ_SSCWT_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | SSCWT Amount |
| 36 | GPNZ_KIWI_EE_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD EE from KIWI DD EE MTD accumulator |
| 37 | GPNZ_KIWI_ER_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 38 | GPNZ_KIWI_ETC | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 39 | GPNZ_START_DT | Date(10) | DATE | Start Date for employees that have commenced employment during the month |
| 40 | GPNZ_FINISH_DT | Date(10) | DATE | Finish Date for employees terminated during the month |
| 41 | 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 |
| 42 | GPNZ_FAM_ASST_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Family Assist Amount |
| 43 | 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. |
| 44 | GPNZ_EE_LUMP_SUM | Number(15,2) | DECIMAL(14,2) NOT NULL | EE Lump Sum from EE Lump Sum Accumulator |
| 45 | GPNZ_IRD_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | New Zealand IRD Number |
| 46 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 47 | GPNZ_NAME | Character(20) | VARCHAR2(20) NOT NULL | Name char field for IR348 download. Contains 'firstname surname', without commas. |
| 48 | GPNZ_CONTACT_PHONE | Character(12) | VARCHAR2(12) NOT NULL | IR Contact Phone Number |
| 49 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 50 | GPNZ_PDR_EMAILID | Character(60) | VARCHAR2(60) NOT NULL | Email Id for Intermediary IRD created for Pay day Reporting NZL |
| 51 | GPNZ_PROD_TYPE | Character(80) | VARCHAR2(80) NOT NULL | Software product Type |
| 52 | GPNZ_PDR_TOT_EMPLN | Number(14,0) | DECIMAL(14) NOT NULL | New Field added for PDR |
| 53 | GPNZ_PDR_SQL_TEXT1 | Long Character | CLOB | To store SQL Text in AET during Application Engine Processing. |
| 54 | GPNZ_PDR_SQL_TEXT2 | Long Character | CLOB | To store SQL Text in AET during Application Engine Processing. |
| 55 | GPNZ_PDR_SQL_TEXT3 | Long Character | CLOB | To store SQL Text in AET during Application Engine Processing. |
| 56 | GPNZ_HDR_ID | Character(4) | VARCHAR2(4) NOT NULL | New Zealand IRD Number |
| 57 | GPNZ_PDR_V2 | Character(1) | VARCHAR2(1) NOT NULL | FIle Generation |