[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_CAT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_UNIT_CAT |
Subobject Name: | |
Status: | VALID |
IGS_PS_UNIT_CAT describes user defined unit categories, that are used to categorize all units offered by the university.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_UNIT_CAT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_CAT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CAT | VARCHAR2 | (10) | Yes | Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Name of the unit category. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the unit category is open or closed. Setting the checkbox to closed prevents the use of the category in new records. |
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_CAT
, DESCRIPTION
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_UNIT_CAT;
IGS.IGS_PS_UNIT_CAT does not reference any database object
IGS.IGS_PS_UNIT_CAT is referenced by following:
|
|
|