PMT_STAT_CNT_VW (SQL View)	Index Back
Payment Status Count View

PMT_STAT_CNT_VW

(SQL View)

Payment Status Count View

SELECT COUNT(*) ,PMT_STATUS FROM PS_PMT_DETAIL_TBL WHERE PYMNT_DT >= %CurrentDateIn GROUP BY PMT_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

2 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
2	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process