GPNZ_RCN_VE_VW

(SQL View)
 Index Back

variance report

list of variance employees for reconciliation report

SELECT A.PROCESS_INSTANCE , A.PAY_ENTITY , A.EMPLID , A.NAME , A.GPNZ_TAX_GROSS , A.GPNZ_PAYE_TAX_AMT , A.GPNZ_CHILD_SUP_AMT , A.GPNZ_STUD_LOAN_AMT , A.GPNZ_SSCWT_AMT , A.GPNZ_KIWI_EE_DED , A.GPNZ_KIWI_ER_DED , A.GPNZ_SLBOR_AMT , A.GPNZ_SLCIR_AMT , A.GPNZ_GROSS_ESS , A.GPNZ_FAM_ASST_AMT FROM PS_GPNZ_RCN_E_VW A WHERE A.GPNZ_RCN_RW_TYP = 'R' %Sql(GPNZ_RCN_CMPR_SQL) SELECT B.PROCESS_INSTANCE , B.PAY_ENTITY , B.EMPLID , B.NAME , B.GPNZ_TAX_GROSS , B.GPNZ_PAYE_TAX_AMT , B.GPNZ_CHILD_SUP_AMT , B.GPNZ_STUD_LOAN_AMT , B.GPNZ_SSCWT_AMT , B.GPNZ_KIWI_EE_DED , B.GPNZ_KIWI_ER_DED , B.GPNZ_SLBOR_AMT , B.GPNZ_SLCIR_AMT , B.GPNZ_GROSS_ESS , B.GPNZ_FAM_ASST_AMT FROM PS_GPNZ_RCN_E_VW B WHERE B.GPNZ_RCN_RW_TYP = 'P'

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 GPNZ_TAX_GROSS Signed Number(16,2) DECIMAL(14,2) NOT NULL Taxable Gross Amount from Taxable Gross MTD Accumulator
6 GPNZ_PAYE_TAX_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL PAYE Tax Amount from PAYE Tax MTD Accumulator
7 GPNZ_CHILD_SUP_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Child Support Amount from Child Support MTD Accumulator
8 GPNZ_STUD_LOAN_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
9 GPNZ_SSCWT_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL SSCWT Amount
10 GPNZ_KIWI_EE_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD EE from KIWI DD EE MTD accumulator
11 GPNZ_KIWI_ER_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
12 GPNZ_SLBOR_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
13 GPNZ_SLCIR_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
14 GPNZ_GROSS_ESS Signed Number(16,2) DECIMAL(14,2) NOT NULL Gross Not Liable EP Amount from ESS MTD Accumulator
15 GPNZ_FAM_ASST_AMT Number(15,2) DECIMAL(14,2) NOT NULL Family Assist Amount