[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_UNIT_SET_CAT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_EN_UNIT_SET_CAT |
Subobject Name: | |
Status: | VALID |
IGS_EN_UNIT_SET_CAT describes the available categories of unit sets. For example, major, minor, stream, list.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_EN_UNIT_SET_CAT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_SET_CAT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_SET_CAT | VARCHAR2 | (10) | Yes | Code of a category of unit set. Unit set categories are institution defined and may include, for example, Major, Minor, Strand and Stream. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides a description of the categories used to classify unit sets. Unit set categories are institution defined and may include for example, Major, Minor, Strand, and Stream. |
S_UNIT_SET_CAT | VARCHAR2 | (10) | System Unit Set Category like MAJOR, MINOR etc | |
RANK | NUMBER | (3) | Yes | Describes the relative rank of the unit set category in relation to other categories. For example, a Major may have a higher rank than a Minor. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit set category is open or closed. Setting the checkbox ticked closes the unit set category and prevents further unit sets from being assigned to the category. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_SET_CAT
, DESCRIPTION
, S_UNIT_SET_CAT
, RANK
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_UNIT_SET_CAT;
IGS.IGS_EN_UNIT_SET_CAT does not reference any database object
IGS.IGS_EN_UNIT_SET_CAT is referenced by following:
|
|
|