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]

TABLE: IGS.IGS_EN_UNIT_SET_HIST_ALL

Object Details

Object Name:	IGS_EN_UNIT_SET_HIST_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_EN_UNIT_SET_HIST_ALL
Subobject Name:
Status:	VALID

IGS_EN_UNIT_SET_HIST_ALL describes the history of change to a unit set version.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_UNIT_SET_HIST_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_SET_CD VERSION_NUMBER HIST_START_DT

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_SET_CD	VARCHAR2	(10)	Yes	Code of a unit set. Unit sets comprise lists of units or rules that 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)	Yes	Uniquely identify each version of a unit set
HIST_START_DT	DATE		Yes	Effective start date and time of the history record
HIST_END_DT	DATE		Yes	Effective end date and time of the history record
HIST_WHO	NUMBER	(15)	Yes	Oracle username of the person who created the history record
UNIT_SET_STATUS	VARCHAR2	(10)		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)		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			Enters the date on that the unit set version is created
REVIEW_DT	DATE			Enters the date on that 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			Enters the date on that 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			Enters the date on that 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)		Title of a unit set. Unit sets comprise lists of units or rules that 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)		Describes the unit set short title
ABBREVIATION	VARCHAR2	(20)		Describes the unit set abbreviation
RESPONSIBLE_ORG_UNIT_CD	VARCHAR2	(30)		Code of an academic or administrative organizational unit operating within the university structure that is responsible for a unit set.
ORG_ID	NUMBER	(15)		Operating unit identifier
RESPONSIBLE_OU_START_DT	DATE			Enters the date on that 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	(60)		Description of an organizational unit. An organizational unit is a business unit of an institution or organization. Common organizational units in tertiary institutions are faculties, schools, departments, and divisions. Each organizational unit must be assigned a start date, description, status, organizational type and member type. Aninstitution code may be assigned to an organizational unit.
ADMINISTRATIVE_IND	VARCHAR2	(1)		Indicator that specifies whether the unit set is administrative or academic in nature. Setting the checkbox ticked classifies the unit set as administrative.
AUTHORISATION_RQRD_IND	VARCHAR2	(1)		Indicator that specifies whether authorization is required before a student can select a unit set as part of their program. Setting the checkbox ticked enforces authorization.
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

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
,      ORG_ID
,      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 IGS.IGS_EN_UNIT_SET_HIST_ALL;

Dependencies

[top of page]

IGS.IGS_EN_UNIT_SET_HIST_ALL does not reference any database object

IGS.IGS_EN_UNIT_SET_HIST_ALL is referenced by following:

APPS: IGS_EN_UNIT_SET_HIST_ALL