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_EN_UNIT_SET_HIST_V

Object Details

Object Name:	IGS_EN_UNIT_SET_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_EN_UNIT_SET_HIST_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	Comments
UNIT_SET_CD	VARCHAR2	(10)	The code of a unit set. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used to represent concepts such as majors, minors, strands, streams,and lists.
VERSION_NUMBER	NUMBER	(3)	This field is used to uniquely identify each version of a unit set.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		The effective end date/time of the history record.
HIST_WHO	NUMBER	(15)	The Oracle username of the person who created the history record.
UNIT_SET_STATUS	VARCHAR2	(150)	This field describes the institution defined unit set status. The unit set status is attributed to each version to define its currency in the system. Unit set status maps to a system unit set status with its associated functionality.
UNIT_SET_CAT	VARCHAR2	(10)	The code of a category of unit set. Unit set categories are institution defined and may include, for example, Major, Minor, Strand, and Stream.
START_DT	DATE		This field records the date on which the unit set version is created.
REVIEW_DT	DATE		This field records the date on which the unit set version is to be reviewed. No automated action will result from this date, rather it is expected to trigger notification of the need for review.
EXPIRY_DT	DATE		This field records the date on which the unit set version expires. This date would be entered as part of the process of expiring one version and creating a new one. Students may still exist in expired unit set versions until the time when the version is finally ended. No new students can select an expired unit set.
END_DT	DATE		This field records the date on which the unit set version is finally closed. All student unit sets must be completed or ended before an end date can be entered.
TITLE	VARCHAR2	(90)	The title of a unit set. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams,and lists.
SHORT_TITLE	VARCHAR2	(40)	This field describes the unit set short title.
ABBREVIATION	VARCHAR2	(20)	This field describes the unit set abbreviation.
RESPONSIBLE_ORG_UNIT_CD	VARCHAR2	(30)	The code of an academic or administrative organisational unit operating within the University structure which is responsible for a unit set.
RESPONSIBLE_OU_START_DT	DATE		This field records the date on which the unit set version is to be reviewed. No automated action will result from this date, rather it is expected to trigger notification of the need for review.
OU_DESCRIPTION	VARCHAR2	(360)	The description of an organisational unit. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date,description, status, organisational type and member type. An institution code may be assigned to an organisational unit.
ADMINISTRATIVE_IND	VARCHAR2	(1)	An indicator which specifies whether the unit set is administrative or academic in nature. Setting the checkbox ticked classifies the unit set as administrative. Administrative unit sets typically do notappear on official documents such as transcripts or other statements of results.
AUTHORISATION_RQRD_IND	VARCHAR2	(1)	An indicator which specifies whether authorisation is required before a student can select a unit set as part of their course. Setting the checkbox ticked enforces authorisation. Example- Approval to select an advanced major by be required from the faculty on a student by student basis.
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who column

Query Text

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


SELECT UNIT_SET_CD
,      VERSION_NUMBER
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      UNIT_SET_STATUS
,      UNIT_SET_CAT
,      START_DT
,      REVIEW_DT
,      EXPIRY_DT
,      END_DT
,      TITLE
,      SHORT_TITLE
,      ABBREVIATION
,      RESPONSIBLE_ORG_UNIT_CD
,      RESPONSIBLE_OU_START_DT
,      OU_DESCRIPTION
,      ADMINISTRATIVE_IND
,      AUTHORISATION_RQRD_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_UNIT_SET_HIST_V;

Dependencies

[top of page]

APPS.IGS_EN_UNIT_SET_HIST_V references the following:

APPS: IGS_AU_GEN_004 - show dependent code; IGS_EN_UNIT_SET; IGS_EN_UNIT_SET_HIST; IGS_GE_DATE - show dependent code; IGS_OR_UNIT

APPS.IGS_EN_UNIT_SET_HIST_V is not referenced by any database object