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_PNL_MR_HS_ALL

Object Details

Object Name:	IGS_RE_THS_PNL_MR_HS_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_RE_THS_PNL_MR_HS_ALL
Subobject Name:
Status:	VALID

IGS_RE_THS_PNL_MR_HS_ALL describes the history of the selected members of a thesis panel.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_RE_THS_PNL_MR_HS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CA_PERSON_ID CA_SEQUENCE_NUMBER THE_SEQUENCE_NUMBER CREATION_DATE PERSON_ID HIST_START_DT

Columns

Name	Datatype	Length	Mandatory	Comments
CA_PERSON_ID	NUMBER	(15)	Yes	Describes the candidate person identification number who is the subject of the 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 thesis examination creation date
PERSON_ID	NUMBER	(15)	Yes	Describes the person identifier number of the examiner
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
PANEL_MEMBER_TYPE	VARCHAR2	(10)		Describes the role of the panel member
CONFIRMED_DT	DATE			Describes the date the thesis panel member was selected to become a member of the thesis panel
DECLINED_DT	DATE			Indicates that the proposed panel member has declined the place on the panel
ANONYMITY_IND	VARCHAR2	(1)		Indicates and specifies if the panel member has requested anonymity. Selecting the indicator means that the panel member wishes to remain anonymous as far as the candidate is concerned.
THESIS_RESULT_CD	VARCHAR2	(10)		Contains the recommended result submitted by the examiner of the thesis
PAID_DT	DATE			Records the date the panel member when paid
TRACKING_ID	NUMBER	(9)		The system generated identification number of the tracking item associated with contact with the thesis panel member
RECOMMENDATION_SUMMARY	VARCHAR2	(2000)		Contains a summary of the examiner's comments in support of their recommended result
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 CA_PERSON_ID
,      CA_SEQUENCE_NUMBER
,      THE_SEQUENCE_NUMBER
,      CREATION_DT
,      PERSON_ID
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      PANEL_MEMBER_TYPE
,      CONFIRMED_DT
,      DECLINED_DT
,      ANONYMITY_IND
,      THESIS_RESULT_CD
,      PAID_DT
,      TRACKING_ID
,      RECOMMENDATION_SUMMARY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_RE_THS_PNL_MR_HS_ALL;

Dependencies

[top of page]

IGS.IGS_RE_THS_PNL_MR_HS_ALL does not reference any database object

IGS.IGS_RE_THS_PNL_MR_HS_ALL is referenced by following:

APPS: IGS_RE_THS_PNL_MR_HS_ALL