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.IGSFV_GR_GRADUAND

Object Details

Object Name:	IGSFV_GR_GRADUAND
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_GR_GRADUAND
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Describes Graduand

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NAME	VARCHAR2	(360)	Yes	Describes the person name.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number.
CREATE_DT	DATE		Yes	Describes the date the Graduand record was created.
GRD_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the Graduation Calendar Type.
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the Graduation Calendar Instance Sequence Number.
GRADUATION_CALENDAR	VARCHAR2	(30)		Describes the Graduation Calendar.
PROGRAM_CODE	VARCHAR2	(6)		Describes the program which is being completed.
PROGRAM_TITLE	VARCHAR2	(90)		Describes the program which is being completed.
AWARD_PROGRAM_CODE	VARCHAR2	(6)		Describes the program which the award is being conferred.
AWARD_PROGRAM_VERSION_NUMBER	NUMBER	(3)		Describes the program which the award is being conferred.
AWARD_PROGRAM_TITLE	VARCHAR2	(90)		Describes the program which the award is being conferred.
AWARD_CD	VARCHAR2	(10)	Yes	Describes the award is being conferred.
AWARD_TITLE	VARCHAR2	(90)	Yes	Describes the award is being conferred.
HONOURS_LEVEL	VARCHAR2	(3)		No longer in use
HONOURS_LEVEL_DESCRIPTION	VARCHAR2	(60)		No longer in use
CONFERRAL_DT	DATE			No longer in use
GRADUAND_STATUS	VARCHAR2	(10)	Yes	Describes the Status of the Graduand.
GRADUAND_APPR_STATUS	VARCHAR2	(10)	Yes	Describes the Status of the Approval to Graduate.
S_GRADUAND_TYPE	VARCHAR2	(10)	Yes	Describes the Type of Graduand.
GRADUATION_NAME	VARCHAR2	(80)	Yes	Describes the Name the Graduand wishes to be presented as.
_LA:PROXY_AWARD_IND	CHAR	(55)		Describes that the Award is being presented to a Proxy.
PROXY_AWARD_PERSON_NAME	VARCHAR2	(360)		Describes the Person the Award is being presented to in Proxy.
PROXY_AWARD_PERSON_NUMBER	VARCHAR2	(30)		Describes the Person the Award is being presented to in Proxy.
PREVIOUS_QUALIFICATIONS	VARCHAR2	(2000)		Describes the Previous Qualifications of the Graduand.
_LA:CONVOCATION_MEMBER_IND	CHAR	(66)		Describes that Convocation Membership is desired by the Graduand.
SUR_FOR_PROGRAM_CODE	VARCHAR2	(6)		Describes the Program Code of the previous Award which is being surrendered for this Award.
SUR_FOR_PROGRAM_VERSION_NUMBER	NUMBER	(3)		Describes the Program Version of the previous Award which is being surrendered for this Award.
SUR_FOR_PROGRAM_TITLE	VARCHAR2	(90)		Describes the Program Code of the previous Award which is being surrendered for this Award.
SUR_FOR_AWARD_CD	VARCHAR2	(10)		Describes the previous Award which is being surrendered for this Award.
SUR_FOR_AWARD_TITLE	VARCHAR2	(90)		Describes the previous Award which is being surrendered for this Award.
COMMENTS	VARCHAR2	(2000)		Describes the Comments related to this Graduand.
PERSON_ID	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person.
PROXY_AWARD_PERSON_ID	NUMBER	(15)		Describes the Person the Award is being presented to in Proxy.
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

Query Text

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


SELECT PERSON_NAME
,      PERSON_NUMBER
,      CREATE_DT
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      GRADUATION_CALENDAR
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      AWARD_PROGRAM_CODE
,      AWARD_PROGRAM_VERSION_NUMBER
,      AWARD_PROGRAM_TITLE
,      AWARD_CD
,      AWARD_TITLE
,      HONOURS_LEVEL
,      HONOURS_LEVEL_DESCRIPTION
,      CONFERRAL_DT
,      GRADUAND_STATUS
,      GRADUAND_APPR_STATUS
,      S_GRADUAND_TYPE
,      GRADUATION_NAME
,      _LA:PROXY_AWARD_IND
,      PROXY_AWARD_PERSON_NAME
,      PROXY_AWARD_PERSON_NUMBER
,      PREVIOUS_QUALIFICATIONS
,      _LA:CONVOCATION_MEMBER_IND
,      SUR_FOR_PROGRAM_CODE
,      SUR_FOR_PROGRAM_VERSION_NUMBER
,      SUR_FOR_PROGRAM_TITLE
,      SUR_FOR_AWARD_CD
,      SUR_FOR_AWARD_TITLE
,      COMMENTS
,      PERSON_ID
,      PROXY_AWARD_PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_GR_GRADUAND;

Dependencies

[top of page]

APPS.IGSFV_GR_GRADUAND references the following:

APPS: HZ_PARTIES; IGS_CA_INST_ALL; IGS_EN_STDNT_PS_ATT_ALL; IGS_GR_GRADUAND_ALL; IGS_GR_HONOURS_LEVEL_ALL; IGS_PS_AWD; IGS_PS_VER_ALL

APPS.IGSFV_GR_GRADUAND is not referenced by any database object