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_GRADUAND_DTL_V

Object Details

Object Name:	IGS_GR_GRADUAND_DTL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_GR_GRADUAND_DTL_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)
PERSON_ID	NUMBER	(15)	Yes
PERSON_NUMBER	VARCHAR2	(30)	Yes
AWARD_COURSE_CD	VARCHAR2	(6)
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)
AWARD_CD	VARCHAR2	(10)	Yes
COURSE_CD	VARCHAR2	(6)
S_GRADUAND_TYPE	VARCHAR2	(10)	Yes
CONVOCATION_MEMBERSHIP_IND	VARCHAR2	(1)	Yes
GRADUAND_STATUS	VARCHAR2	(10)	Yes
GRADUAND_APPR_STATUS	VARCHAR2	(10)	Yes
CREATE_DT	DATE		Yes
CONFERRAL_DT	DATE
GRADUATION_NAME	VARCHAR2	(80)	Yes
PREVIOUS_QUALIFICATIONS	VARCHAR2	(2000)
COMMENTS	VARCHAR2	(2000)
GRD_CAL_TYPE	VARCHAR2	(10)	Yes
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes
PROXY_AWARD_IND	VARCHAR2	(1)	Yes
PROXY_AWARD_PERSON_ID	NUMBER	(15)
PROXY_AWARD_PERSON_NUMBER	VARCHAR2	(30)
SUR_FOR_COURSE_CD	VARCHAR2	(6)
SUR_FOR_CRS_VERSION_NUMBER	NUMBER	(3)
SUR_FOR_AWARD_CD	VARCHAR2	(10)
HONOURS_LEVEL	VARCHAR2	(3)		No longer in use
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)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard Descriptive Flex Field Column.
ATTRIBUTE1	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE2	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE3	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE4	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE5	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE6	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE7	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE8	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE9	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE10	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE11	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE12	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE13	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE14	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE15	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE16	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE17	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE18	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE19	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
ATTRIBUTE20	VARCHAR2	(150)		Standard Descriptive Flex Field Column.
AWARD_MARK	NUMBER	(6)		Award Mark for the student.
AWARD_GRADE	VARCHAR2	(5)		Award Grade for the student.
COMPLETE_IND	VARCHAR2	(1)

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      COURSE_CD
,      S_GRADUAND_TYPE
,      CONVOCATION_MEMBERSHIP_IND
,      GRADUAND_STATUS
,      GRADUAND_APPR_STATUS
,      CREATE_DT
,      CONFERRAL_DT
,      GRADUATION_NAME
,      PREVIOUS_QUALIFICATIONS
,      COMMENTS
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      PROXY_AWARD_IND
,      PROXY_AWARD_PERSON_ID
,      PROXY_AWARD_PERSON_NUMBER
,      SUR_FOR_COURSE_CD
,      SUR_FOR_CRS_VERSION_NUMBER
,      SUR_FOR_AWARD_CD
,      HONOURS_LEVEL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      AWARD_MARK
,      AWARD_GRADE
,      COMPLETE_IND
FROM APPS.IGS_GR_GRADUAND_DTL_V;

Dependencies

[top of page]

APPS.IGS_GR_GRADUAND_DTL_V references the following:

APPS: HZ_PARTIES; IGS_EN_SPA_AWD_AIM; IGS_GR_GRADUAND_ALL

APPS.IGS_GR_GRADUAND_DTL_V is not referenced by any database object