[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_THS_PNL_MR_TP_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_THS_PNL_MR_TP_ALL |
Subobject Name: | |
Status: | VALID |
IGS_RE_THS_PNL_MR_TP_ALL describes the various member types of a thesis examination panel.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_THS_PNL_MR_TP_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PANEL_MEMBER_TYPE |
IGS_RE_THS_PNL_MR_TP_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRACKING_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PANEL_MEMBER_TYPE | VARCHAR2 | (10) | Yes | Describes the various user-defined types of members on a thesis panel. For example, include chair, ordinary, reserve. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the thesis panel member type |
PANEL_CHAIR_IND | VARCHAR2 | (1) | Yes | Describes if a panel member of this type is the chair person of the panel |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if the thesis panel member type is open or closed. Selecting the check box closes the thesis panel member type and prevents further panel members being assigned the thesis panel member type. |
TRACKING_TYPE | VARCHAR2 | (10) | Describes the tracking type used to track processes or documents associated with the thesis panel member type | |
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 PANEL_MEMBER_TYPE
, DESCRIPTION
, PANEL_CHAIR_IND
, CLOSED_IND
, TRACKING_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_RE_THS_PNL_MR_TP_ALL;
IGS.IGS_RE_THS_PNL_MR_TP_ALL does not reference any database object
IGS.IGS_RE_THS_PNL_MR_TP_ALL is referenced by following:
|
|
|