[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_LEVEL_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_UNIT_LEVEL_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_UNIT_LEVEL_ALL describes the available university unit levels.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_UNIT_LEVEL_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_LEVEL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_LEVEL | VARCHAR2 | (4) | Yes | Normal year level of the unit. For example, 1 - a first year unit within a program, 2 - a second year unit within a program. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Explanation of the unit level. |
WAM_WEIGHTING | NUMBER | (8) | Weighting attributed to the unit level for the purposes of calculating weighted average marks ( WAM). | |
CLOSED_IND | VARCHAR2 | (1) | 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. |
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_LEVEL
, DESCRIPTION
, WAM_WEIGHTING
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_PS_UNIT_LEVEL_ALL;
IGS.IGS_PS_UNIT_LEVEL_ALL does not reference any database object
IGS.IGS_PS_UNIT_LEVEL_ALL is referenced by following:
|
|
|