[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_GR_VENUE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_GR_VENUE_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_GR_VENUE_ALL describes the physical venue where an examination, graduation ceremony, and others can be accomodated. A venue can exist within a location, for example, campus or examination location Town Hall.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_GR_VENUE_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 VENUE_CD
|
| IGS_GR_VENUE_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EXAM_LOCATION_CD
|
| IGS_GR_VENUE_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COORD_PERSON_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VENUE_CD | VARCHAR2 | (10) | Yes | The code that uniquely identifies the examination or graduation venue. |
| EXAM_LOCATION_CD | VARCHAR2 | (10) | Yes | The code of the venue's parent examination location. An open venue must always have an open parent exam location. |
| DESCRIPTION | VARCHAR2 | (60) | Yes | The full name of the venue |
| NUMBER_OF_SEATS | NUMBER | (4) | Yes | The maximum number of seats in the venue. A value must be entered in this field. |
| BOOKING_COST | NUMBER | (7) | The cost of hiring the venue | |
| PRIORITY_CD | NUMBER | (3) | The priority assigned to the venue indicating an order of preference when allocating examinations. There is no associated system functionality. | |
| SUPERVISOR_LIMIT | NUMBER | (2) | The maximum number of supervisors that should normally be allocated to the venue. When allocating supervisors to a venue for an exam session, the system raises a warning if the limit is about to be exceeded. | |
| COORD_PERSON_ID | NUMBER | (15) | The ID of the person responsible for the co-ordination of the venue.This person can be different from the contact person's recorded as part of the address details, and can or can not be the parent location co-ordinator. | |
| CLOSED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if or not the venue is closed. Selecting the checkbox, closes the venue and prevents further use. |
| 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 to be made before examinations. | |
| BOOKING_INFORMATION | VARCHAR2 | (2000) | A text facility for entering any information relating to the booking of the venue. For example, contact details. | |
| 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. | |
| INSTRUCTIONS | VARCHAR2 | (2000) | A text facility to enter any venue specific instructions. | |
| 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 | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT VENUE_CD
, 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
, ORG_ID
FROM IGS.IGS_GR_VENUE_ALL;
IGS.IGS_GR_VENUE_ALL does not reference any database object
IGS.IGS_GR_VENUE_ALL is referenced by following:
APPS
IGS_GR_VENUE_ALL
|
|
|
|