GP_PMT_NPS_VW

(SQL View)
Index Back

Net Pay Summary View

Net Pay summarised.

SELECT A.CAL_RUN_ID ,A.EMPLID ,A.EMPL_RCD ,SUM(A.GP_PMT_AMT) ,A.CURRENCY_CD ,A.CAL_PRD_ID ,A.PAYMENT_MTHD ,A.SRC_BANK_ID ,A.PMT_STATUS FROM PS_GP_PAYMENT A WHERE A.PMT_TYPE = '01' GROUP BY A.CAL_RUN_ID ,A.EMPLID ,A.EMPL_RCD, A.CAL_PRD_ID, A.CURRENCY_CD , A.SRC_BANK_ID, A.PAYMENT_MTHD, A.PMT_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
7 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
8 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
9 PMT_STATUS Character(1) VARCHAR2(1) NOT NULL Status field for a generated payment transaction
F=Finalized
M=Manually Paid
N=No Active Allocations
P=Prepared
T=Payment Transferred
V=Hold
W=Void