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]

VIEW: APPS.IGS_GR_HIST_V

Object Details

Object Name:	IGS_GR_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_GR_HIST_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	Comments
PERSON_ID	NUMBER	(15)	The person id of the graduand.
CREATE_DT	DATE		This field describes the date this graduand record was created. This with the person id uniquely identifies a graduand.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		The effective end date/time of the history record.
HIST_WHO	NUMBER	(15)	The Oracle username of the person who created the history record.
GRD_CAL_TYPE	VARCHAR2	(10)	This field describes the graduation calendar type the ceremony round is for.
GRD_CI_SEQUENCE_NUMBER	NUMBER		This field describes the calendar instance of the graduation calendar the ceremony round is for.
COURSE_CD	VARCHAR2	(6)	Describes the course code for the student course attempt the graduand is completing.
AWARD_COURSE_CD	VARCHAR2	(6)	Describes the course code for the award which the graduand is receiving.
AWARD_CRS_VERSION_NUMBER	NUMBER		Describes the version number of the course for the award which the graduand is receiving.
AWARD_CD	VARCHAR2	(10)	The unique identifier for the award which the graduand is receiving.
HONOURS_LEVEL	VARCHAR2	(3)	No longer in use
CONFERRAL_DT	DATE		No longer in use
GRADUAND_STATUS	VARCHAR2	(10)	This field describes the current status of this graduand.
GRADUAND_APPR_STATUS	VARCHAR2	(10)	This field describes the status of the graduands approval to graduate.
S_GRADUAND_TYPE	VARCHAR2	(10)	This is the type of graduand. This has system defined types of UNKNOWN, ATTENDING, INABSENTIA, DEFERRED, SURRENDERD and RENOUNCED. This is determined by the graduands reponse and has a default value of UNKNOWN.
GRADUATION_NAME	VARCHAR2	(80)	The graduand name to appear on the testamur or certificate. The default graduand name is derived from the person's given names and surname, but it may be overridden.
PROXY_AWARD_IND	VARCHAR2	(1)	This field indicates whether or not the award is to be presented to a proxy (identified by the proxy award person id).
PROXY_AWARD_PERSON_ID	NUMBER		This field describes the ID of the person to collect the award by proxy.
PREVIOUS_QUALIFICATIONS	VARCHAR2	(2000)	This field describes any previous degree to thesis title obtained by the graduand. Details will be announced or included with the award.
CONVOCATION_MEMBERSHIP_IND	VARCHAR2	(1)	This field describes whether or not the graduate wants to have convocation membership.
SUR_FOR_COURSE_CD	VARCHAR2	(6)	Describes the course code for the award which the graduand is surrendering this award for.
SUR_FOR_CRS_VERSION_NUMBER	NUMBER		Describes the course version for the award which the graduand is surrendering this award for.
SUR_FOR_AWARD_CD	VARCHAR2	(10)	Describes the award code which the graduand is surrendering this award for.
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
COMMENTS	VARCHAR2	(2000)	Any additional detail for this graduand. Examples: AOU reason for rejecting a graduand, notes on acceptance of early exit or awards not linked to a student course attempt.

Query Text

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


SELECT PERSON_ID
,      CREATE_DT
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      COURSE_CD
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      HONOURS_LEVEL
,      CONFERRAL_DT
,      GRADUAND_STATUS
,      GRADUAND_APPR_STATUS
,      S_GRADUAND_TYPE
,      GRADUATION_NAME
,      PROXY_AWARD_IND
,      PROXY_AWARD_PERSON_ID
,      PREVIOUS_QUALIFICATIONS
,      CONVOCATION_MEMBERSHIP_IND
,      SUR_FOR_COURSE_CD
,      SUR_FOR_CRS_VERSION_NUMBER
,      SUR_FOR_AWARD_CD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMMENTS
FROM APPS.IGS_GR_HIST_V;

Dependencies

[top of page]

APPS.IGS_GR_HIST_V references the following:

APPS: IGS_AU_GEN_003 - show dependent code; IGS_GE_DATE - show dependent code; IGS_GR_GRADUAND; IGS_GR_GRADUAND_HIST

APPS.IGS_GR_HIST_V is not referenced by any database object