AV_EP_MSLOG_VW (SQL View)	Index Back
EPay Mbr Sessn Trans Log View This view will select from all Posted Mbr / Adj Mbr Sessions available on the AV_EP_TRANS_LOG record.

AV_EP_MSLOG_VW

(SQL View)

EPay Mbr Sessn Trans Log View

This view will select from all Posted Mbr / Adj Mbr Sessions available on the AV_EP_TRANS_LOG record.

SELECT DISTINCT A.BUSINESS_UNIT ,A.SESSION_NO ,B.LAST_MOD_DT ,A.INSTITUTION FROM PS_AV_EP_TRANS_LOG 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')

# 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

#	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