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

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ORG_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)	Yes
CREATE_DT	DATE		Yes
GRD_CAL_TYPE	VARCHAR2	(10)	Yes
GRD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes
COURSE_CD	VARCHAR2	(6)
AWARD_COURSE_CD	VARCHAR2	(6)
AWARD_CRS_VERSION_NUMBER	NUMBER	(3)
AWARD_CD	VARCHAR2	(10)	Yes
HONOURS_LEVEL	VARCHAR2	(3)		No longer in use
CONFERRAL_DT	DATE
GRADUAND_STATUS	VARCHAR2	(10)	Yes
GRADUAND_APPR_STATUS	VARCHAR2	(10)	Yes
S_GRADUAND_TYPE	VARCHAR2	(10)	Yes
GRADUATION_NAME	VARCHAR2	(80)	Yes
PROXY_AWARD_IND	VARCHAR2	(1)	Yes
PROXY_AWARD_PERSON_ID	NUMBER	(15)
PREVIOUS_QUALIFICATIONS	VARCHAR2	(2000)
CONVOCATION_MEMBERSHIP_IND	VARCHAR2	(1)	Yes
SUR_FOR_COURSE_CD	VARCHAR2	(6)
SUR_FOR_CRS_VERSION_NUMBER	NUMBER	(3)
SUR_FOR_AWARD_CD	VARCHAR2	(10)
COMMENTS	VARCHAR2	(2000)
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)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
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.

Query Text

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


SELECT ROW_ID
,      ORG_ID
,      PERSON_ID
,      CREATE_DT
,      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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM APPS.IGS_GR_GRADUAND;

Dependencies

[top of page]

APPS.IGS_GR_GRADUAND references the following:

APPS: IGS_EN_SPA_AWD_AIM; IGS_GR_GRADUAND_ALL

APPS.IGS_GR_GRADUAND is referenced by following:

APPS: IGS_AS_PRC_TRANSCRPT - show dependent code; IGS_AS_PRC_TRANSCRPT - show dependent code; IGS_EN_FUTURE_DT_TRANS - show dependent code; IGS_GR_GEN_002 - show dependent code; IGS_GR_GRADUANDS_V; IGS_GR_GRADUAND_V; IGS_GR_GRADUATE_REGISTER_RPT_V; IGS_GR_GRD_LGCY_PUB - show dependent code; IGS_GR_HIST_V; IGS_GR_PRC_GAC - show dependent code; IGS_GR_VAL_GAC - show dependent code; IGS_GR_VAL_GR - show dependent code; IGS_PR_ACAD_PROGRAM_V; IGS_PR_VAL_SCA - show dependent code; IGS_PS_VAL_AW - show dependent code