SSR_HE_VENUE

(SQL Table)
Index Back

HESA Institution Venue

HESA Institution Venue

# 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: OPR_DEF_TBL_CS

2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 SSR_HE_VENUEID Character(50) VARCHAR2(50) NOT NULL Venue ID
4 SSR_HE_VENUENAME Character(250) VARCHAR2(250) NOT NULL Venue Name
5 SSR_HE_VENUETYPE Character(2) VARCHAR2(2) NOT NULL Venue Type

Prompt Table: SSR_HE_VNTYP_VW

6 SSR_HE_POSTCODE Character(8) VARCHAR2(8) NOT NULL Postcode
7 SSR_HE_UKPRN Character(20) VARCHAR2(20) NOT NULL UKPRN
8 SSR_HE_OWNVENUEID Character(50) VARCHAR2(50) NOT NULL Own Venue ID