AV_EP_M_DSES_VW

(SQL View)
 Index Back

EPay Mbr Declined Session View

This view will select from all Posted Mbr Sessions Declined available on the AV_EP_MBR_DTL record.

SELECT DISTINCT A.BUSINESS_UNIT ,A.SESSION_NO ,B.LAST_MOD_DT ,A.INSTITUTION FROM PS_AV_EP_MBR_DTL A ,PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.AV_SESS_TYPE IN ('M','AM') AND B.SESS_STATUS = 'P' AND A.PROCESS_INSTANCE = 0 AND A.SEQ_NO = ( SELECT MAX(A1.SEQ_NO) FROM PS_AV_EP_MBR_DTL A1 WHERE A1.BUSINESS_UNIT = A.BUSINESS_UNIT AND A1.MBR_PMT_NO = A.MBR_PMT_NO) AND A.AV_PAYMENT_STATUS = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
3 LAST_MOD_DT Date(10) DATE Last Modification Date
4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution