eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_VENUES

Product:	IGS - Student System (Obsolete)
Description:	This entity describes the physical venue where an examination or graduation ceremony can be accommodated. A venue can exist within a location (eg. campus) or examination location (eg. Town Hall).
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT VEN.VENUE_CD VENUE_CODE
, VEN.DESCRIPTION
, VEN.EXAM_LOCATION_CD EXAM_LOCATION_CODE
, VEN.NUMBER_OF_SEATS
, VEN.BOOKING_COST
, VEN.SUPERVISOR_LIMIT
, VEN.PRIORITY_CD PRIORITY_CODE
, VEN.CLOSED_IND CLOSED_INDICATOR
, VEN.COMMENTS
, VEN.RESOURCES_AVAILABLE
, VEN.ANNOUNCEMENTS
, VEN.SEATING_INFORMATION
, VEN.BOOKING_INFORMATION
, VEN.INSTRUCTIONS
, LOC.DESCRIPTION EXAM_LOCATION_DESC
, HP.PARTY_NUMBER COORDINATE_PERSON_NUMBER
, VEN.COORD_PERSON_ID COORDINATE_PERSON_IDENTIFIER
, VEN.CREATED_BY
, VEN.CREATION_DATE
, VEN.LAST_UPDATED_BY
, VEN.LAST_UPDATE_DATE
FROM IGS_GR_VENUE_ALL VEN
, IGS_AD_LOCATION_ALL LOC
, HZ_PARTIES HP
WHERE VEN.EXAM_LOCATION_CD = LOC.LOCATION_CD
AND VEN.COORD_PERSON_ID = HP.PARTY_ID(+) WITH READ ONLY

Columns

Name
VENUE_CODE
DESCRIPTION
EXAM_LOCATION_CODE
NUMBER_OF_SEATS
BOOKING_COST
SUPERVISOR_LIMIT
PRIORITY_CODE
CLOSED_INDICATOR
COMMENTS
RESOURCES_AVAILABLE
ANNOUNCEMENTS
SEATING_INFORMATION
BOOKING_INFORMATION
INSTRUCTIONS
EXAM_LOCATION_DESC
COORDINATE_PERSON_NUMBER
COORDINATE_PERSON_IDENTIFIER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE