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

VIEW: APPS.IGS_RE_SPRVSR_V

Object Details
Object Name: IGS_RE_SPRVSR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_RE_SPRVSR_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CA_PERSON_ID NUMBER (15) Yes This field describes the candidate person ID.
CA_SEQUENCE_NUMBER NUMBER (6) Yes This field describes the candidature sequence number.
PERSON_ID NUMBER (15) Yes This field describes the person ID of the research supervisor
PERSON_NUMBER VARCHAR2 (30) Yes
SEQUENCE_NUMBER NUMBER (6) Yes This field uniquely defines the research supervisor for a person id.
SURNAME VARCHAR2 (150)
The surname (family name) of the person.
GIVEN_NAMES VARCHAR2 (150)
The given names of the person.
CONTEXT_BLOCK_NAME VARCHAR2 (455)
PERSON.SURNAME
STAFF_MEMBER_IND VARCHAR2 (4000)
An indicator which specifies whether or not the person is a staff member of the home (local) institution. Setting the checkbox (ticked) means the person is a staff member.
START_DT DATE
Yes This field describes the date a supervisor becomes effective for a student.
END_DT DATE

If the end date is given the supervisor is no longer a supervisor for this candidature.
RESEARCH_SUPERVISOR_TYPE VARCHAR2 (10) Yes This field describes the type of supervisor that the related person is.
SUPERVISOR_PROFESSION VARCHAR2 (60)
This field describes the supervisors profession.
SUPERVISION_PERCENTAGE NUMBER (5)
This field describes the supervision percentage of the person .This is recorded for the purposes of calculating the research load incurred by supervisors within an institution.
FUNDING_PERCENTAGE NUMBER (5)
This field describes the percentage of the research load which is apportioned for funding purposes to the specified organisational unit.
ORG_UNIT_CD VARCHAR2 (30)
This field describes the organisational unit code for whom the supervisor is working when performing the supervision.
OU_START_DT DATE

This field describes the organisational unit start date.
REPLACED_CA_PERSON_ID VARCHAR2 (40)
This field describes the candidate person ID.
REPLACED_CA_SEQUENCE_NUMBER VARCHAR2 (40)
This field describes the candidature sequence number.
REPLACED_PERSON_ID NUMBER (15)
This field describes the supervisor person ID who has been replaced by the current supervisor, allowing a history of supervision roles for the duration of a candidature.
REPLACED_SEQUENCE_NUMBER NUMBER (6)
This field describes the unique identifier of the supervisor being replaced.
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
COMMENTS VARCHAR2 (2000)
This field describes any comments relating to the supervision arrangements between the candidate and supervisor.
Query Text

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


SELECT ROW_ID
,      CA_PERSON_ID
,      CA_SEQUENCE_NUMBER
,      PERSON_ID
,      PERSON_NUMBER
,      SEQUENCE_NUMBER
,      SURNAME
,      GIVEN_NAMES
,      CONTEXT_BLOCK_NAME
,      STAFF_MEMBER_IND
,      START_DT
,      END_DT
,      RESEARCH_SUPERVISOR_TYPE
,      SUPERVISOR_PROFESSION
,      SUPERVISION_PERCENTAGE
,      FUNDING_PERCENTAGE
,      ORG_UNIT_CD
,      OU_START_DT
,      REPLACED_CA_PERSON_ID
,      REPLACED_CA_SEQUENCE_NUMBER
,      REPLACED_PERSON_ID
,      REPLACED_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMMENTS
FROM APPS.IGS_RE_SPRVSR_V;

Dependencies

[top of page]

APPS.IGS_RE_SPRVSR_V references the following:

SchemaAPPS
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
PL/SQL PackageIGS_EN_GEN_007 - show dependent code
ViewIGS_PE_PERSON_V
SynonymIGS_RE_SPRVSR

APPS.IGS_RE_SPRVSR_V is not referenced by any database object