DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_EN_UNIT_SET_ALL

Object Details
Object Name: IGS_EN_UNIT_SET_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_EN_UNIT_SET_ALL
Subobject Name:
Status: VALID


IGS_EN_UNIT_SET_ALL describes a unit-set, being a logical sub-grouping of proram. For example, major, minor,stream, strand. A unit-set is typically related to the rules that govern its completion via the rules sub-system.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_EN_UNIT_SET_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_SET_CD
ColumnVERSION_NUMBER
IGS_EN_UNIT_SET_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSIBLE_ORG_UNIT_CD
ColumnRESPONSIBLE_OU_START_DT
IGS_EN_UNIT_SET_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_SET_CAT
IGS_EN_UNIT_SET_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_SET_STATUS
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 Used to uniquely identify each version of a unit set
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_CAT 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_DT DATE
Yes 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 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_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) 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.
SHORT_TITLE VARCHAR2 (40) Yes Describes the unit set short title
ABBREVIATION VARCHAR2 (20) Yes 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

Describes the date from that the organizational unit is effective.
ADMINISTRATIVE_IND 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.
AUTHORISATION_RQRD_IND 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.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE16 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE17 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE18 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE19 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE20 VARCHAR2 (150)
Standard DFF Column
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
,      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
,      ADMINISTRATIVE_IND
,      AUTHORISATION_RQRD_IND
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_UNIT_SET_ALL;

Dependencies

[top of page]

IGS.IGS_EN_UNIT_SET_ALL does not reference any database object

IGS.IGS_EN_UNIT_SET_ALL is referenced by following:

SchemaAPPS
SynonymIGS_EN_UNIT_SET_ALL