[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_THS_PNL_TYPE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_THS_PNL_TYPE |
Subobject Name: | |
Status: | VALID |
IGS_RE_THS_PNL_TYPE describes the types of thesis panels that can be used for thesis examinations.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_THS_PNL_TYPE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | THESIS_PANEL_TYPE |
IGS_RE_THS_PNL_TYPE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRACKING_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
THESIS_PANEL_TYPE | VARCHAR2 | (10) | Yes | Describes the type of thesis panel |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the thesis panel type |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if the thesis panel type is open or closed. Selecting the check box closes the thesis panel type and prevents further thesis examinations being assigned the thesis panel type. |
RECOMMENDED_PANEL_SIZE | NUMBER | (2) | The recommended size of the relevant type of thesis examination panel | |
TRACKING_TYPE | VARCHAR2 | (10) | Describes the tracking type to be used for tracking of thesis examination processes and documents. Only tracking types that have been mapped to the system tracking type of RES_TEX provide functionality. | |
SELECTION_CRITERIA | VARCHAR2 | (2000) | Describes textually the selection criteria for members of the examination pane. For example, include required qualifications, years of experience. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT THESIS_PANEL_TYPE
, DESCRIPTION
, CLOSED_IND
, RECOMMENDED_PANEL_SIZE
, TRACKING_TYPE
, SELECTION_CRITERIA
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_RE_THS_PNL_TYPE;
IGS.IGS_RE_THS_PNL_TYPE does not reference any database object
IGS.IGS_RE_THS_PNL_TYPE is referenced by following:
|
|
|