[Home] [Help] [Dependency Information]
Object Name: | IGS_RE_THS_EXAM_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_RE_THS_EXAM_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_RE_THS_EXAM_HIST_ALL describes the history of statuses of the thesis examination.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_RE_THS_EXAM_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
CA_SEQUENCE_NUMBER THE_SEQUENCE_NUMBER CREATION_DT HIST_START_DT |
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 | |
HIST_START_DT | DATE | Yes | The effective start date and time of the history record | |
HIST_END_DT | DATE | Yes | The effective end date and time of the history record | |
HIST_WHO | NUMBER | (15) | Yes | The 'updated by' person at the time of the history |
SUBMISSION_DT | DATE | Describes the date on the thesis has been submitted for examination | ||
THESIS_EXAM_TYPE | VARCHAR2 | (10) | Describes the type of examination that is being undertaken. For example, written, performance, oral. | |
THESIS_PANEL_TYPE | VARCHAR2 | (10) | Describes the type of panel used for the thesis examination | |
TRACKING_ID | NUMBER | (10) | 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 returned their recommended outcomes | |
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 PERSON_ID
, CA_SEQUENCE_NUMBER
, THE_SEQUENCE_NUMBER
, CREATION_DT
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, SUBMISSION_DT
, THESIS_EXAM_TYPE
, THESIS_PANEL_TYPE
, TRACKING_ID
, THESIS_RESULT_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_RE_THS_EXAM_HIST_ALL;
IGS.IGS_RE_THS_EXAM_HIST_ALL does not reference any database object
IGS.IGS_RE_THS_EXAM_HIST_ALL is referenced by following:
|
|
|