[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_THESIS_EXAM |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_THESIS_EXAM |
Subobject Name: | |
Status: | VALID |
IGS_RE_THESIS_EXAM describes the thesis examination and its actions.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_THESIS_EXAM_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
CA_SEQUENCE_NUMBER THE_SEQUENCE_NUMBER CREATION_DT |
IGS_RE_THESIS_EXAM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | THESIS_EXAM_TYPE |
IGS_RE_THESIS_EXAM_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | THESIS_RESULT_CD |
IGS_RE_THESIS_EXAM_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | THESIS_PANEL_TYPE |
IGS_RE_THESIS_EXAM_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRACKING_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Describes the person identifier number of the research candidate whose thesis is under examination |
CA_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the candidature sequence number |
THE_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the thesis sequence number |
CREATION_DT | DATE | Yes | Describes the date the panel was created for the thesis examination | |
SUBMISSION_DT | DATE | Describes the date that the thesis was submitted for examination | ||
THESIS_EXAM_TYPE | VARCHAR2 | (10) | Yes | Describes the type of examination which is being undertaken. For example, written, performance, oral. |
THESIS_PANEL_TYPE | VARCHAR2 | (10) | Yes | Describes the type of panel used for the thesis examination |
TRACKING_ID | NUMBER | (9) | The system generated identification number of the tracking item associated with the thesis examination process | |
THESIS_RESULT_CD | VARCHAR2 | (10) | Describes the thesis result that is an outcome of the panel members having provided their recommended results | |
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_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, CA_SEQUENCE_NUMBER
, THE_SEQUENCE_NUMBER
, CREATION_DT
, SUBMISSION_DT
, THESIS_EXAM_TYPE
, THESIS_PANEL_TYPE
, TRACKING_ID
, THESIS_RESULT_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM IGS.IGS_RE_THESIS_EXAM;
IGS.IGS_RE_THESIS_EXAM does not reference any database object
IGS.IGS_RE_THESIS_EXAM is referenced by following:
|
|
|