[Home] [Help]
View: IGS_GR_VENUE_V
Product: | IGS - Student System (Obsolete) |
Description: | IGS_GR_VENUE_V is used to maintain venues. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT VE.ROWID
, VE.VENUE_CD
, PE.PERSON_NUMBER
, PE.PREFERRED_NAME
, VE.EXAM_LOCATION_CD
, VE.DESCRIPTION
, VE.NUMBER_OF_SEATS
, VE.BOOKING_COST
, VE.PRIORITY_CD
, VE.SUPERVISOR_LIMIT
, VE.COORD_PERSON_ID
, VE.CLOSED_IND
, VE.COMMENTS
, VE.RESOURCES_AVAILABLE
, VE.ANNOUNCEMENTS
, VE.BOOKING_INFORMATION
, VE.SEATING_INFORMATION
, VE.INSTRUCTIONS
, VE.CREATED_BY
, VE.CREATION_DATE
, VE.LAST_UPDATED_BY
, VE.LAST_UPDATE_DATE
, VE.LAST_UPDATE_LOGIN
FROM IGS_GR_VENUE VE
, IGS_PE_PERSON_V PE
WHERE VE.COORD_PERSON_ID = PE.PERSON_ID(+)
Columns
Name |
ROW_ID |
VENUE_CD |
PERSON_NUMBER |
PREFERRED_NAME |
EXAM_LOCATION_CD |
DESCRIPTION |
NUMBER_OF_SEATS |
BOOKING_COST |
PRIORITY_CD |
SUPERVISOR_LIMIT |
COORD_PERSON_ID |
CLOSED_IND |
COMMENTS |
RESOURCES_AVAILABLE |
ANNOUNCEMENTS |
BOOKING_INFORMATION |
SEATING_INFORMATION |
INSTRUCTIONS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |