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_ACAD_UNIT_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains Student Unit Attempt details with statistics and grades.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
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.
COURSE_TYPE	VARCHAR2	(10)	Yes	Program Type
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code
VERSION_NUMBER	NUMBER	(3)	Yes	Unit version number
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Teaching calendar type
TEACH_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Teaching calendar identifier
TEACH_DESCRIPTION	VARCHAR2	(30)		Teaching calendar description
TEACH_ALTERNATE_CODE	VARCHAR2	(10)		Teaching calendar alternate code
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	Unit Attempt Status
TITLE	VARCHAR2	(4000)		Title
LOCATION_CD	VARCHAR2	(10)	Yes	Location code
UNIT_CLASS	VARCHAR2	(10)	Yes	Location Class
UOO_ID	NUMBER	(7)	Yes	The unique identifier of the unit offering option.
CALL_NUMBER	NUMBER			This is the unique identifier needed to support interactive voice registration.
LOAD_CAL_TYPE	VARCHAR2	(10)	Yes	Load calendar
LOAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Load calendar unique identifier
LOAD_DESCRIPTION	VARCHAR2	(30)		Load calendar description
LOAD_ALTERNATE_CODE	VARCHAR2	(10)		Alternate code for load calendar
YEAR_OF_PROGRAM	VARCHAR2	(4000)		Program year
MARK	NUMBER			Marks
GRADE	VARCHAR2	(4000)		Grade
GPA	NUMBER			Grade point average
GPA_CP	NUMBER			Grade point average credit points
GPA_QP	NUMBER			Grade point average
EARNED_CP	NUMBER			Earned credit points
ATTEMPTED_CP	NUMBER			Attempted credit points
STATISTICS_FLAG	VARCHAR2	(1)		Statistic flag
TRANSFERRED_FLAG	VARCHAR2	(1)		Transferred flag

Query Text

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


SELECT PERSON_NUMBER
,      PERSON_ID
,      COURSE_CD
,      COURSE_TYPE
,      UNIT_CD
,      VERSION_NUMBER
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      TEACH_DESCRIPTION
,      TEACH_ALTERNATE_CODE
,      UNIT_ATTEMPT_STATUS
,      TITLE
,      LOCATION_CD
,      UNIT_CLASS
,      UOO_ID
,      CALL_NUMBER
,      LOAD_CAL_TYPE
,      LOAD_CI_SEQUENCE_NUMBER
,      LOAD_DESCRIPTION
,      LOAD_ALTERNATE_CODE
,      YEAR_OF_PROGRAM
,      MARK
,      GRADE
,      GPA
,      GPA_CP
,      GPA_QP
,      EARNED_CP
,      ATTEMPTED_CP
,      STATISTICS_FLAG
,      TRANSFERRED_FLAG
FROM APPS.IGS_PR_ACAD_UNIT_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_UNIT_V references the following:

APPS: HZ_PARTIES; IGS_CA_TEACH_TO_LOAD_V; IGS_EN_STDNT_PS_ATT; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_SU_ATTEMPT_ALL; IGS_PR_ACAD_DETAILS - show dependent code; IGS_PS_PRG_UNIT_REL; IGS_PS_STDNT_UNT_TRN; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_VER; IGS_PS_VER_ALL; IGS_SS_ENR_DETAILS - show dependent code

APPS.IGS_PR_ACAD_UNIT_V is not referenced by any database object