SSR_HE_VNEXT_VW

(SQL View)
Index Back

Venue Extract View

Venue Extract View

SELECT VENEXT.INSTITUTION , VENEXT.SSR_HE_RET_NAME , VENEXT.SSR_HE_VENUEID , VENEXT.SSR_HE_ACTIVE ,INSTHER.SSR_HE_RET_TYPE , INSTHER.SSR_HE_PRD_CODE , VEN.SSR_HE_VENUENAME ,VENEXT.SSR_HE_ENT_STATUS FROM PS_SSR_HE_VENU_EXT VENEXT , PS_SSR_HE_INST_HER INSTHER , PS_SSR_HE_VENUE VEN WHERE VENEXT.INSTITUTION= INSTHER.INSTITUTION AND VENEXT.SSR_HE_RET_NAME= INSTHER.SSR_HE_RET_NAME AND VEN.INSTITUTION=VENEXT.INSTITUTION AND VEN.SSR_HE_VENUEID=VENEXT.SSR_HE_VENUEID AND VEN.EFFDT=( SELECT MAX(VEN1.EFFDT) FROM PS_SSR_HE_VENUE VEN1 WHERE VEN1.INSTITUTION=VEN.INSTITUTION AND VEN1.SSR_HE_VENUEID=VEN.SSR_HE_VENUEID AND VEN1.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 SSR_HE_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name

Prompt Table: SSR_HE_STURETVW

3 SSR_HE_VENUEID Character(50) VARCHAR2(50) NOT NULL Venue ID
4 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

5 SSR_HE_RET_TYPE Character(10) VARCHAR2(10) NOT NULL Return Type

Prompt Table: SSR_HE_RETURNS

6 SSR_HE_PRD_CODE Character(10) VARCHAR2(10) NOT NULL Reporting Period

Prompt Table: SSR_HE_REP_PRDS

7 SSR_HE_VENUENAME Character(250) VARCHAR2(250) NOT NULL Venue Name
8 SSR_HE_ENT_STATUS Character(1) VARCHAR2(1) NOT NULL Entity Status
A=Amended
D=Delete
E=Error
I=Identify
N=New
U=Unchanged