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_GR_GRADUAND_HIST_ALL

Object Details

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

IGS_GR_GRADUAND_HIST_ALL describes graduand details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_GR_GRADUAND_HIST_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID CREATE_DT HIST_START_DT

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	The person ID of the graduand
CREATE_DT	DATE		Yes	Describes the date this graduand record was created. This with the person ID uniquely identifies a graduand.
HIST_START_DT	DATE		Yes	The effective start date and time of the history record.
HIST_END_DT	DATE		Yes	The effective end date and time of the history record
HIST_WHO	NUMBER	(15)	Yes	The Oracle username of the person who created the history record
GRD_CAL_TYPE	VARCHAR2	(10)		Describes the graduation calendar type the ceremony round is for
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)		Describes the calendar instance of the graduation calendar the ceremony round is for
COURSE_CD	VARCHAR2	(6)		Describes the course code for the student program attempt the graduandis completing
AWARD_COURSE_CD	VARCHAR2	(6)		Describes the program code for the award that the graduand is receiving
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)		Describes the version number of the program for the award that the graduand is receiving
AWARD_CD	VARCHAR2	(10)		The unique identifier for the award that the graduand is receiving
HONOURS_LEVEL	VARCHAR2	(3)		Describes the honors level granted to a graduating student. --Obsolete
CONFERRAL_DT	DATE			Describes the date the award is conferred. --Obsolete
GRADUAND_STATUS	VARCHAR2	(10)		Describes the current status of this graduand
GRADUAND_APPR_STATUS	VARCHAR2	(10)		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 can be overridden.
PROXY_AWARD_IND	VARCHAR2	(1)		Indicates if or not the award is to be presented to a proxy that is identified by the proxy award person ID
PROXY_AWARD_PERSON_ID	NUMBER	(15)		Describes the ID of the person to collect the award by proxy
PREVIOUS_QUALIFICATIONS	VARCHAR2	(2000)		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)		Describes if or not the granduate wants to have convocation membership
SUR_FOR_COURSE_CD	VARCHAR2	(6)		Describes the program code for the award that the graduand issurrendering this award for
SUR_FOR_CRS_VERSION_NUMBER	NUMBER	(3)		Describes the program version for the award that the graduand is surrendering this award for.
SUR_FOR_AWARD_CD	VARCHAR2	(10)		Describes the award code that the graduand is surrendering this award for
COMMENTS	VARCHAR2	(2000)		Any additional detail for this graduand. For example, AOU reason for rejecting a graduand, notes on acceptance of early exit or awards not linked to a student program attempt.
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
,      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
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_GR_GRADUAND_HIST_ALL;

Dependencies

[top of page]

IGS.IGS_GR_GRADUAND_HIST_ALL does not reference any database object

IGS.IGS_GR_GRADUAND_HIST_ALL is referenced by following:

APPS: IGS_GR_GRADUAND_HIST_ALL