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_CANDIDATURE_ALL

Object Details

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

IGS_RE_CANDIDATURE_ALL describes the candidature details of a research student.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_RE_CANDIDATURE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID SEQUENCE_NUMBER
IGS_RE_CANDIDATURE_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCA_COURSE_CD
IGS_RE_CANDIDATURE_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_TYPE_OF_ACTIVITY_CD
IGS_RE_CANDIDATURE_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID ACAI_ADMISSION_APPL_NUMBER ACAI_NOMINATED_COURSE_CD ACAI_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the candidate person identification number
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes a unique sequence number used to
SCA_COURSE_CD	VARCHAR2	(6)		Describes the student program attempt program code within the research is being performed. This link is populated when a student is pre-enrolled in a new program attempt.
ACAI_ADMISSION_APPL_NUMBER	NUMBER	(2)		Describes the admissions application number from that the candidature originated
ACAI_NOMINATED_COURSE_CD	VARCHAR2	(6)		Describes the admissions nominated program code from that the candidature originated
ACAI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the admissions application sequence number that resulted in the candidature
ATTENDANCE_PERCENTAGE	NUMBER	(5)		Describes the current attendance percentage of the candidate. The attendance percentage represents the total attendance of the research candidature and program work unit attempts. Default percentages for each attendance type are entered in the maintain attendance types windows. The default values can be overridden.
GOVT_TYPE_OF_ACTIVITY_CD	VARCHAR2	(10)		Describes the Government type of activity code that best reflects the research undertaken by the candidate
MAX_SUBMISSION_DT	DATE			Describes the latest date the thesis can be submitted. This system derived value can be overridden.
MIN_SUBMISSION_DT	DATE			Describes the earliest date the thesis can be submitted. This system date can be overridden.
RESEARCH_TOPIC	VARCHAR2	(2000)		Describes the broad research topic of the candidature. More detailed descriptions are entered against the thesis details. This field is required for candidature details.
INDUSTRY_LINKS	VARCHAR2	(2000)		Describes any industries associated with the thesis
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      SEQUENCE_NUMBER
,      SCA_COURSE_CD
,      ACAI_ADMISSION_APPL_NUMBER
,      ACAI_NOMINATED_COURSE_CD
,      ACAI_SEQUENCE_NUMBER
,      ATTENDANCE_PERCENTAGE
,      GOVT_TYPE_OF_ACTIVITY_CD
,      MAX_SUBMISSION_DT
,      MIN_SUBMISSION_DT
,      RESEARCH_TOPIC
,      INDUSTRY_LINKS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM IGS.IGS_RE_CANDIDATURE_ALL;

Dependencies

[top of page]

IGS.IGS_RE_CANDIDATURE_ALL does not reference any database object

IGS.IGS_RE_CANDIDATURE_ALL is referenced by following:

APPS: IGS_RE_CANDIDATURE_ALL