SSR_HE_VENUE_VW

(SQL View)
Index Back

Record view for Venue

Record view for Venue

SELECT A.SSR_HE_VENUEID , A.SSR_HE_VENUENAME FROM PS_SSR_HE_VENUE A WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_SSR_HE_INTN A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_HE_VENUEID Character(50) VARCHAR2(50) NOT NULL Venue ID
2 SSR_HE_VENUENAME Character(250) VARCHAR2(250) NOT NULL Venue Name