eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_RE_THS_EXAM_HIST_ALL

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

IGS.IGS_RE_THS_EXAM_HIST_ALL does not reference any database object

IGS.IGS_RE_THS_EXAM_HIST_ALL is referenced by following:

APPS: IGS_RE_THS_EXAM_HIST_ALL