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_HGR_ED_PR_TY_UNT_LEVELS

Object Details

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

View Type

A Business Intelligence System view

This is the full view which describes the level of a unit within a particular university program type. This value will override the default value stored against the unit.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_CODE	VARCHAR2	(10)	Yes	The code of the unit for which the level is specified.
VERSION_NUMBER	NUMBER	(3)	Yes	Version Number is used to uniquely identify each version of a unit.
PROGRAM_TYPE	VARCHAR2	(10)		The course type for which the unit level is specified. Enables the definition of different year levels for a unit when undertaken in courses of different types. For example, a unit may normally be defined as Level1, but when taken in a postgraduate diploma course is defined as a Level 5 unit.
UNIT_LEVEL	VARCHAR2	(4)	Yes	The unit level assigned to a unit when it is undertaken in a course of a specified type.
WAM_WEIGHTING	NUMBER	(8)		Describes the weighting of the course unit level for the purposes of a weighted average mark calculation.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Program code for what the unit level for a unit code is overridden for a unit code.
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Program version number.
UNIT_TITLE	VARCHAR2	(90)	Yes	The title of the unit.
PROGRAM_TYPE_DESCRIPTION	VARCHAR2	(60)		A description of the institution-defined course type. A course type indicates the type of higher education course. Examples: Bachelor's Pass, Graduate Certificate, Higher Degree by Research.
UNIT_LEVEL_DESCRIPTION	VARCHAR2	(60)	Yes	An expansion of the unit level.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the program version.
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 UNIT_CODE
,      VERSION_NUMBER
,      PROGRAM_TYPE
,      UNIT_LEVEL
,      WAM_WEIGHTING
,      PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      UNIT_TITLE
,      PROGRAM_TYPE_DESCRIPTION
,      UNIT_LEVEL_DESCRIPTION
,      PROGRAM_TITLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_HGR_ED_PR_TY_UNT_LEVELS;

Dependencies

[top of page]

APPS.IGSFV_HGR_ED_PR_TY_UNT_LEVELS references the following:

APPS: IGS_PS_TYPE_ALL; IGS_PS_UNIT_LEVEL_ALL; IGS_PS_UNIT_LVL_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_VER_ALL

APPS.IGSFV_HGR_ED_PR_TY_UNT_LEVELS is not referenced by any database object