[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_SCH_MWC_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_SCH_MWC_ALL |
Subobject Name: | |
Status: | VALID |
Contains Unit Section Meet With information to be used by the third party scheduling interface.The corresponding production table is IGS_PS_USO_CLAS_MEET.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export Scheduling Meet-With Class Detail
Category: BUSINESS_ENTITY IGS_UNIT
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_SCH_MWC_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | MWC_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MWC_GROUP_ID | NUMBER | Yes | Sequence generated number to uniquely identify a meet with group | |
MEET_WITH_CLASS_GROUP_NAME | VARCHAR2 | (150) | Yes | Meet With Class Group Name |
HOST_USO_ID | NUMBER | (10) | Identifier of Host Unit Section Occurrence of Meet With Class Group - Obsolete | |
GUEST_USO_ID | NUMBER | (10) | Identifier of Guest Unit Section Occurrence of Meet With Class Group - Obsolete | |
MWC_MAX_ENROLLMENT_NUMBER | NUMBER | (6) | Maximum Enrollment associated with meet with group | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
INT_OCCURS_ID | NUMBER | Unique identifier for the Unit Section Occurrence in scheduling interface - Obsolete | ||
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 | |
HOST_UOO_ID | NUMBER | (10) | Identifier for Host Unit Section of Meet With Class Group | |
GUEST_UOO_ID | NUMBER | (10) | Identifier for Guest Unit Section of Meet with Class Group | |
INT_USEC_ID | NUMBER | Unique Identifier for the Unit Section in the Scheduling Interface |
Cut, paste (and edit) the following text to query this object:
SELECT MWC_GROUP_ID
, MEET_WITH_CLASS_GROUP_NAME
, HOST_USO_ID
, GUEST_USO_ID
, MWC_MAX_ENROLLMENT_NUMBER
, ORG_ID
, INT_OCCURS_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, HOST_UOO_ID
, GUEST_UOO_ID
, INT_USEC_ID
FROM IGS.IGS_PS_SCH_MWC_ALL;
IGS.IGS_PS_SCH_MWC_ALL does not reference any database object
IGS.IGS_PS_SCH_MWC_ALL is referenced by following:
|
|
|