GPNZ_RCN_ER_DTL(SQL Table) |
Index Back |
|---|---|
RCN DataEmployer Data Level for Reconciliation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity | |
| 3 | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation Row Type
P=Payroll Register R=PDR |
|
| 4 | GPNZ_TAX_GROSS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Taxable Gross Amount from Taxable Gross MTD Accumulator |
| 5 | GPNZ_PAYE_TAX_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | PAYE Tax Amount from PAYE Tax MTD Accumulator |
| 6 | GPNZ_CHILD_SUP_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Child Support Amount from Child Support MTD Accumulator |
| 7 | GPNZ_STUD_LOAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 8 | GPNZ_SSCWT_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | SSCWT Amount |
| 9 | GPNZ_KIWI_EE_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD EE from KIWI DD EE MTD accumulator |
| 10 | GPNZ_KIWI_ER_DED | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | KIWI DD ER from KIWI DD ER MTD accumulator |
| 11 | GPNZ_SLBOR_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 12 | GPNZ_SLCIR_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Student Loan Amount from Student Loan MTD Accumulator |
| 13 | GPNZ_GROSS_ESS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Gross Not Liable EP Amount from ESS MTD Accumulator |
| 14 | GPNZ_FAM_ASST_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Family Assist Amount |