SSR_HE_VENRL_VW

(SQL View)
Index Back

Venue percentage view

Venue percentage view

SELECT A.SSR_HE_VENUEID , A.SSR_HE_VENUENAME , A.SSR_HE_VENUETYPE FROM PS_SSR_HE_VENUE A WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_SSR_HE_INTN A1 WHERE A1.INSTITUTION=A.INSTITUTION)

# 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
3 SSR_HE_VENUETYPE Character(2) VARCHAR2(2) NOT NULL Venue Type