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

TABLE: IGS.IGS_PS_RSV_EXT

Object Details
Object Name: IGS_PS_RSV_EXT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_PS_RSV_EXT
Subobject Name:
Status: VALID


Contains the seats used for each reserve seating category.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PS_RSV_EXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREFERENCE_ID
ColumnPRIORITY_ID
ColumnRSV_LEVEL
ColumnUOO_ID
IGS_PS_RSV_EXT_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRSV_EXT_ID
Columns
Name Datatype Length Mandatory Comments
RSV_EXT_ID NUMBER (15) Yes Primary Key
UOO_ID NUMBER (15) Yes Unit Section ID for which the actual enrollment against reservation is created.
PRIORITY_ID NUMBER (15) Yes Priority ID of Reserve Seating set up
PREFERENCE_ID NUMBER (15) Yes Preference ID of Reserve Seating set up
RSV_LEVEL VARCHAR2 (10) Yes The level at which priority and preferences are defined.(USEC, UOPT, ORG)
ACTUAL_SEAT_ENROLLED NUMBER (6) Yes Actual number of seats enrolled against the priority and preference of reservation
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
Query Text

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


SELECT RSV_EXT_ID
,      UOO_ID
,      PRIORITY_ID
,      PREFERENCE_ID
,      RSV_LEVEL
,      ACTUAL_SEAT_ENROLLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_RSV_EXT;

Dependencies

[top of page]

IGS.IGS_PS_RSV_EXT does not reference any database object

IGS.IGS_PS_RSV_EXT is referenced by following:

SchemaAPPS
SynonymIGS_PS_RSV_EXT