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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_VENUES

Object Details

Object Name:	IGSFV_VENUES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_VENUES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

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).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VENUE_CODE	VARCHAR2	(10)	Yes	The code that uniquely identifies the examination or graduation venue.
DESCRIPTION	VARCHAR2	(60)	Yes	The description of the venue
EXAM_LOCATION_CODE	VARCHAR2	(10)	Yes	The code of the venue's parent examination/graduation location. An open venue must always have an open parent examination/graduation location.
NUMBER_OF_SEATS	NUMBER	(4)	Yes	The maximum number of seats in the venue.
BOOKING_COST	NUMBER	(7)		The cost of booking the venue
SUPERVISOR_LIMIT	NUMBER	(2)		The maximum number of supervisors that should normally be allocated to the venue.
PRIORITY_CODE	NUMBER	(3)		The priority assigned to the venue indicating an order of preference when allocating examinations.
CLOSED_INDICATOR	VARCHAR2	(1)	Yes	Indicates if the venue is closed.
COMMENTS	VARCHAR2	(2000)		A text facility for entering any additional comments about the venue
RESOURCES_AVAILABLE	VARCHAR2	(2000)		A text facility for entering the resources available at the venue. For example, chairs, tables, and heating.
ANNOUNCEMENTS	VARCHAR2	(2000)		A text facility for entering any venue specific announcements.
SEATING_INFORMATION	VARCHAR2	(2000)		A text facility for entering any additional information about the seating at the venue. For example, seating layout, seat number range.
BOOKING_INFORMATION	VARCHAR2	(2000)		A text facility for entering any information relating to the booking of the venue. For example, contact details.
INSTRUCTIONS	VARCHAR2	(2000)		A text facility to enter any venue specific instructions
EXAM_LOCATION_DESC	VARCHAR2	(60)	Yes	The description of the venue's parent examination location.
COORDINATE_PERSON_NUMBER	VARCHAR2	(30)		The Identification Number of the person responsible for the co-ordination of the venue. This person can be different from the contact person recorded as part of the address details, and may not be the parent location co-ordinator.
COORDINATE_PERSON_IDENTIFIER	NUMBER	(15)		The ID of the person responsible for the co-ordination of the venue. This person can be different from the contact person recorded as part of the address details, and may not be the parent location co-ordinator.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.IGSFV_VENUES;

Dependencies

[top of page]

APPS.IGSFV_VENUES references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_GR_VENUE_ALL

APPS.IGSFV_VENUES is not referenced by any database object