GPNZ_RCN_E_VW

(SQL View)
 Index Back

reconcilitaion empoyee view

Processed employees for reconciliation report

SELECT A.PROCESS_INSTANCE , A.PAY_ENTITY , A.EMPLID , B.NAME , A.GPNZ_RCN_RW_TYP , A.PYMT_DT , 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_EE_DTL A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# 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_RCN_RW_TYP Character(1) VARCHAR2(1) NOT NULL Reconciliation Row Type
P=Payroll Register
R=PDR
6 PYMT_DT Date(10) DATE Payment Date
7 GPNZ_TAX_GROSS Signed Number(16,2) DECIMAL(14,2) NOT NULL Taxable Gross Amount from Taxable Gross MTD Accumulator
8 GPNZ_PAYE_TAX_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL PAYE Tax Amount from PAYE Tax MTD Accumulator
9 GPNZ_CHILD_SUP_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Child Support Amount from Child Support MTD Accumulator
10 GPNZ_STUD_LOAN_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
11 GPNZ_SSCWT_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL SSCWT Amount
12 GPNZ_KIWI_EE_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD EE from KIWI DD EE MTD accumulator
13 GPNZ_KIWI_ER_DED Signed Number(16,2) DECIMAL(14,2) NOT NULL KIWI DD ER from KIWI DD ER MTD accumulator
14 GPNZ_SLBOR_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
15 GPNZ_SLCIR_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Student Loan Amount from Student Loan MTD Accumulator
16 GPNZ_GROSS_ESS Signed Number(16,2) DECIMAL(14,2) NOT NULL Gross Not Liable EP Amount from ESS MTD Accumulator
17 GPNZ_FAM_ASST_AMT Number(15,2) DECIMAL(14,2) NOT NULL Family Assist Amount