GPNZ_PDR_EEFILE(SQL Table) |
Index Back |
---|---|
PDR Employment File DTLHeader Record for DTL Employment File |
# | 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 | PYMT_DT | Date(10) | DATE | Payment Date |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | GPNZ_TAX_SCALE | Character(4) | VARCHAR2(4) NOT NULL | New Zealand Tax Scale |
6 | GPNZ_DET_ID | Character(3) | VARCHAR2(3) NOT NULL | Literal field 'DTR' |
7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
9 | 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. |
10 | GPNZ_IRD_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | New Zealand IRD Number |
11 | GPNZ_NAME | Character(20) | VARCHAR2(20) NOT NULL | Name char field for IR348 download. Contains 'firstname surname', without commas. |
12 | GPNZ_START_DT | Date(10) | DATE | Start Date for employees that have commenced employment during the month |
13 | GPNZ_FINISH_DT | Date(10) | DATE | Finish Date for employees terminated during the month |
14 | GPNZ_TAX_GROSS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Taxable Gross Amount from Taxable Gross MTD Accumulator |
15 | GPNZ_GROSS_NO_EP | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from Retire/Redund MTD Accumulator |
16 | 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 |
17 | GPNZ_PAYE_TAX_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | PAYE Tax Amount from PAYE Tax MTD Accumulator |
18 | GPNZ_CHILD_SUP_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Child Support Amount from Child Support MTD Accumulator |
19 | 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 |
20 | GPNZ_STUD_LOAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
21 | GPNZ_KIWI_EE_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD EE from KIWI DD EE MTD accumulator |
22 | GPNZ_KIWI_ER_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
23 | 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. |
24 | GPNZ_TX_CRDT_PG | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Field to hold the tax credit for payroll giving |
25 | GPNZ_FAM_ASST_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Family Assist Amount |
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_PP_PAYE_ADJ | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Prior Period Payee Adjustments |
29 | GPNZ_PP_GRS_ADJ | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Prior Period Gross Adjustments |
30 | GPNZ_GROSS_ESS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from ESS MTD Accumulator |
31 | GPNZ_PAID_HOURS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Paid Hours |