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_CONCENTRATIONS

Object Details

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

View Type

A Business Intelligence System view

This view describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules, which govern its completion via the Rules Sub-system. - Obsolete

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_SET_CODE	VARCHAR2	(10)	Yes	The unit set code, which is being attempted. 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)	Yes	Describes the unit set version number which is being attempted
UNIT_SET_STATUS	VARCHAR2	(150)	Yes	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_CATEGORY	VARCHAR2	(10)	Yes	Code of a category of unit set. Unit set categories are institution-defined and might include, for example, MAJOR, MINOR, STRAND and STREAM.
START_DATE	DATE		Yes	Enters the date on that the unit set version is created
REVIEW_DATE	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_DATE	DATE			Enters the date on that the unit set version expires. This date would be entered as part of process of expiring one version and creating a new one. Students may still exist in expired unit set versions until the version is finally ended.
END_DATE	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.
UNIT_SET_TITLE	VARCHAR2	(90)	Yes	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 represent concepts such as majors, minors, strands, streams and lists.
UNIT_SET_SHORT_TITLE	VARCHAR2	(40)	Yes	Describes the unit set short title
UNIT_SET_ABBREVIATION	VARCHAR2	(20)	Yes	Describes the unit set abbreviation
RESPONSIBLE_ORG_UNIT_CODE	VARCHAR2	(30)		Code of an academic or administrative organizational unit operating within the university structure that is responsible for a unit set.
RESPONSIBLE_OU_START_DATE	DATE			Describes the date from that the organizational unit is effective.
ADMINISTRATIVE_INDICATOR	VARCHAR2	(1)	Yes	Indicator that specifies whether the unit set is administrative or academic in nature. Setting the checkbox ticked classifies the unit set as administrative.
_LA:ADMINISTRATIVE_IND_DESC	CHAR	(55)		Description for Administrative Indicator.
AUTHORISATION_RQRD_INDICATOR	VARCHAR2	(1)	Yes	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.
_LA:AUTH_RQR_IND_DES	CHAR	(59)		Description for Authorisation required indicator.
UNIT_SET_STATUS_DESC	VARCHAR2	(60)	Yes	The status of the Unit Set.
UNIT_SET_CATEGORY_DESC	VARCHAR2	(60)	Yes	Description of the Unit set category
RESP_ORG_NAME	VARCHAR2	(360)	Yes	Name of the Responsible organization
_DF	CHAR	(33)		Descriptive Flex Field
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_SET_CODE
,      VERSION_NUMBER
,      UNIT_SET_STATUS
,      UNIT_SET_CATEGORY
,      START_DATE
,      REVIEW_DATE
,      EXPIRY_DATE
,      END_DATE
,      UNIT_SET_TITLE
,      UNIT_SET_SHORT_TITLE
,      UNIT_SET_ABBREVIATION
,      RESPONSIBLE_ORG_UNIT_CODE
,      RESPONSIBLE_OU_START_DATE
,      ADMINISTRATIVE_INDICATOR
,      _LA:ADMINISTRATIVE_IND_DESC
,      AUTHORISATION_RQRD_INDICATOR
,      _LA:AUTH_RQR_IND_DES
,      UNIT_SET_STATUS_DESC
,      UNIT_SET_CATEGORY_DESC
,      RESP_ORG_NAME
,      _DF
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CONCENTRATIONS;

Dependencies

[top of page]

APPS.IGSFV_CONCENTRATIONS references the following:

APPS: HZ_PARTIES; IGS_EN_UNIT_SET_ALL; IGS_EN_UNIT_SET_CAT; IGS_EN_UNIT_SET_STAT; IGS_PE_HZ_PARTIES

APPS.IGSFV_CONCENTRATIONS is not referenced by any database object