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_THESIS_ALL

Object Details

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

IGS_RE_THESIS_ALL describes the thesis details for a research student.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_RE_THESIS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID CA_SEQUENCE_NUMBER SEQUENCE_NUMBER
IGS_RE_THESIS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THESIS_RESULT_CD

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the person identifier number of the candidate preparing the thesis
CA_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the candidature sequence number
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the sequence number allocated to the thesis to give it uniqueness
TITLE	VARCHAR2	(2000)	Yes	Describes the title of the research student's thesis
FINAL_TITLE_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the nominated title is the final title for the thesis, or a working title. Selecting the check box indicates the thesis title is final.
SHORT_TITLE	VARCHAR2	(100)		Describes the short title of the thesis
ABBREVIATED_TITLE	VARCHAR2	(40)		Contains the abbreviated title of the thesis
THESIS_RESULT_CD	VARCHAR2	(10)		Describes the final result that has been allocated to the thesis. This result must be mapped to a system result of type final.
EXPECTED_SUBMISSION_DT	DATE			The date that the thesis is expected to be submitted. This field would be entered once the student had given notification of intention to submit.
LIBRARY_LODGEMENT_DT	DATE			Contains the date the research students thesis was lodged in the library
LIBRARY_CATALOGUE_NUMBER	VARCHAR2	(300)		Contains the library catalogue number of the thesis
EMBARGO_EXPIRY_DT	DATE			The expiry date of any embargo placed on the release of the thesis
THESIS_FORMAT	VARCHAR2	(60)		Describes the format of the thesis
LOGICAL_DELETE_DT	DATE			Contains the date the record was logically deleted
EMBARGO_DETAILS	VARCHAR2	(2000)		Records the details of any embargo placed on the release of the thesis
THESIS_TOPIC	VARCHAR2	(2000)		Describes the topic of the thesis
CITATION	VARCHAR2	(2000)		Contains citation information to be read during a graduation ceremony
COMMENTS	VARCHAR2	(2000)		Provides any comments about the thesis for the research student
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
,      SEQUENCE_NUMBER
,      TITLE
,      FINAL_TITLE_IND
,      SHORT_TITLE
,      ABBREVIATED_TITLE
,      THESIS_RESULT_CD
,      EXPECTED_SUBMISSION_DT
,      LIBRARY_LODGEMENT_DT
,      LIBRARY_CATALOGUE_NUMBER
,      EMBARGO_EXPIRY_DT
,      THESIS_FORMAT
,      LOGICAL_DELETE_DT
,      EMBARGO_DETAILS
,      THESIS_TOPIC
,      CITATION
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_RE_THESIS_ALL;

Dependencies

[top of page]

IGS.IGS_RE_THESIS_ALL does not reference any database object

IGS.IGS_RE_THESIS_ALL is referenced by following:

APPS: IGS_RE_THESIS_ALL