GPNZ_RCN_ER_DTL

(SQL Table)
Index Back

RCN Data

Employer Data Level for Reconciliation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
3 GPNZ_RCN_RW_TYP 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