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.IGSBV_UNIT_CALENDAR_OFFERINGS

Object Details

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

View Type

A Business Intelligence System view

This is a base view, which describes Unit Offerring Pattern of a unit offering option.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_CODE	VARCHAR2	(10)	Yes	The unit code the unit offering pattern applies to. A unit code is an institution-defined unique identifier of unit of study.
VERSION_NUMBER	NUMBER	(3)	Yes	The version of the unit the unit offering pattern applies to. Students are normally enrolled in the current version. Prior versions of the unit are end-dated.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	The calendar type of the calendar instance in which the unit is offered. Units can only be offered in instances of calendars categorised as TEACHING calendars. Examples include SEM-1 (semester 1 teaching period), SEM-2 (semester 2 teaching period) and SUM (summer teaching period).
CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The sequence number of the calendar instance for the unit offering pattern. The sequence number is unique identifer of the calendar instance.
CAL_INST_START_DATE	DATE		Yes	The start date of the teaching calendar instance that applies to the unit offering pattern. It is the date from which the calendar instance becomes effective.
CAL_INST_END_DATE	DATE		Yes	The end date of the teaching calendar instance that applies to the unit offering pattern. It is the date from which the calendar instance is no longer effective. E.g. teaching period semester 1 1996, may end on 30/6/96
WAITLIST_ALLOWED	VARCHAR2	(1)		An indicator to show whether waitlist is allowed for the unit offering pattern or not.
MAX_STUDENTS_PER_WAITLIST	NUMBER	(6)		The maximum number of students who can be waitlisted.
ABORT_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the Unit Offering Pattern is ABORTED.
UNIT_TITLE	VARCHAR2	(90)	Yes	Title of the unit
CALENDAR_DESCRIPTION	VARCHAR2	(60)	Yes	Description of the calendar type.
CAL_INST_DESCRIPTION	VARCHAR2	(30)		Description of the calendar instance.
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
,      CALENDAR_TYPE
,      CAL_INST_SEQUENCE_NUMBER
,      CAL_INST_START_DATE
,      CAL_INST_END_DATE
,      WAITLIST_ALLOWED
,      MAX_STUDENTS_PER_WAITLIST
,      ABORT_FLAG
,      UNIT_TITLE
,      CALENDAR_DESCRIPTION
,      CAL_INST_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_UNIT_CALENDAR_OFFERINGS;

Dependencies

[top of page]

APPS.IGSBV_UNIT_CALENDAR_OFFERINGS references the following:

APPS: IGS_CA_INST_ALL; IGS_CA_TYPE; IGS_PS_UNIT_OFR_PAT_ALL; IGS_PS_UNIT_VER_ALL

APPS.IGSBV_UNIT_CALENDAR_OFFERINGS is not referenced by any database object