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_PR_STD_PRG_AWD_AIM_V

Object Details

Object Name:	IGS_PR_STD_PRG_AWD_AIM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PR_STD_PRG_AWD_AIM_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)		Rowid
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number from HZ_PARTIES. This is the PARTY_NUMBER column.
COURSE_CD	VARCHAR2	(6)	Yes	A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
VERSION_NUMBER	NUMBER	(3)	Yes	The version number of the course in which the student is enrolled.
COURSE_VERSION	VARCHAR2	(47)		The Course Code and Version Number concatenated together.
AWARD_CD	VARCHAR2	(10)		Unique identifier for the award.
NAME	VARCHAR2	(360)	Yes	The Student's Name from HZ_PARTIES. This is the PARTY_NAME column.
COURSE_TYPE	VARCHAR2	(10)	Yes	Program Type of the Student Program Attempt.
UNIT_SET_CD	VARCHAR2	(10)		Unit Set Code for the Student Unit Set Attempt.
US_VERSION_NUMBER	NUMBER	(3)		Version Number of the Unit Set for the Student Unit Set 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
START_DT	DATE
END_DT	DATE
AWARD_MARK	NUMBER	(6)
AWARD_GRADE	VARCHAR2	(5)
GRADING_SCHEMA_CD	VARCHAR2	(10)
GS_VERSION_NUMBER	NUMBER	(3)
COURSE_RQRMNT_COMPLETE_IND	VARCHAR2	(1)	Yes
COMPLETE_IND	VARCHAR2	(1)
CONFERRAL_DATE	DATE

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      COURSE_CD
,      VERSION_NUMBER
,      COURSE_VERSION
,      AWARD_CD
,      NAME
,      COURSE_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      START_DT
,      END_DT
,      AWARD_MARK
,      AWARD_GRADE
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      COURSE_RQRMNT_COMPLETE_IND
,      COMPLETE_IND
,      CONFERRAL_DATE
FROM APPS.IGS_PR_STD_PRG_AWD_AIM_V;

Dependencies

[top of page]

APPS.IGS_PR_STD_PRG_AWD_AIM_V references the following:

APPS: HZ_PARTIES; IGS_AS_SU_SETATMPT; IGS_EN_SPA_AWD_AIM_V; IGS_EN_STDNT_PS_ATT_SV; IGS_PS_VER

APPS.IGS_PR_STD_PRG_AWD_AIM_V is not referenced by any database object