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_SPRVSR

Object Details

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

IGS_RE_SPRVSR describes a research student's supervisor.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_RE_SPRVSR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CA_PERSON_ID CA_SEQUENCE_NUMBER PERSON_ID SEQUENCE_NUMBER
IGS_RE_SPRVSR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
IGS_RE_SPRVSR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPLACED_PERSON_ID REPLACED_SEQUENCE_NUMBER
IGS_RE_SPRVSR_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_UNIT_CD OU_START_DT
IGS_RE_SPRVSR_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESEARCH_SUPERVISOR_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CA_PERSON_ID	NUMBER	(15)	Yes	Describes the candidate person identifier number.
CA_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the candidature sequence number
PERSON_ID	NUMBER	(15)	Yes	Describes the person identifier number of the research supervisor
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely defines the research supervisor for a person identifier number
START_DT	DATE		Yes	Describes the date a supervisor becomes effective for the student candidature
END_DT	DATE			If recorded, this field indicates the date of which the person stopped supervising the candidate
RESEARCH_SUPERVISOR_TYPE	VARCHAR2	(10)	Yes	Describes the supervisor type. For example, include principal supervisor, associate supervisor, external supervisor.
SUPERVISOR_PROFESSION	VARCHAR2	(60)		Describes the supervisor's profession
SUPERVISION_PERCENTAGE	NUMBER	(5)		Describes the supervision percentage of the person. This is entered for the purposes of calculating the research load incurred by supervisors within an institution.
FUNDING_PERCENTAGE	NUMBER	(5)		Describes the percentage of the research load that is apportioned for funding purposes to the specified organizational unit.
ORG_UNIT_CD	VARCHAR2	(30)		Describes the organizational unit code for whom the supervisor is working when performing the supervision
OU_START_DT	DATE			Describes the organizational unit start date
REPLACED_PERSON_ID	NUMBER	(15)		Describes the unique person ID of the replaced supervisor allowing creation and maintenance of a supervision history for the candidature
REPLACED_SEQUENCE_NUMBER	NUMBER	(6)		Describes the unique identifier of the supervisor being replaced
COMMENTS	VARCHAR2	(2000)		Describes any comments relating to the supervision arrangements between the candidate and supervisor
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

Query Text

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


SELECT CA_PERSON_ID
,      CA_SEQUENCE_NUMBER
,      PERSON_ID
,      SEQUENCE_NUMBER
,      START_DT
,      END_DT
,      RESEARCH_SUPERVISOR_TYPE
,      SUPERVISOR_PROFESSION
,      SUPERVISION_PERCENTAGE
,      FUNDING_PERCENTAGE
,      ORG_UNIT_CD
,      OU_START_DT
,      REPLACED_PERSON_ID
,      REPLACED_SEQUENCE_NUMBER
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_RE_SPRVSR;

Dependencies

[top of page]

IGS.IGS_RE_SPRVSR does not reference any database object

IGS.IGS_RE_SPRVSR is referenced by following:

APPS: IGS_RE_SPRVSR