[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_INT_LVL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_UNIT_INT_LVL |
Subobject Name: | |
Status: | VALID |
IGS_PS_UNIT_INT_LVL describes the grouping of units in terms of program level for WEFTSU.
WEFSTU = EFTSU * discipline.funding_index * unit_course_level.factor.
For example,
YEARS 1 & 2 UG COURSEWORK ( 1.0)
OTHD COURSEWORK (1.2)
HONS & HD COURSEWORK (1.4)
RESEARCH (1.8)
LEVEL UNKNOWN (1.0)
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_UNIT_INT_LVL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_INT_COURSE_LEVEL_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_INT_COURSE_LEVEL_CD | VARCHAR2 | (10) | Yes | Internal program level code. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Description, or name, of the unit internal program level. Internal program levels are used in the determination of WEFTSU. |
WEFTSU_FACTOR | NUMBER | (3) | Yes | Factor associated with the internal program level grouping used in the determination of WEFTSU. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_INT_COURSE_LEVEL_CD
, DESCRIPTION
, WEFTSU_FACTOR
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_UNIT_INT_LVL;
IGS.IGS_PS_UNIT_INT_LVL does not reference any database object
IGS.IGS_PS_UNIT_INT_LVL is referenced by following:
|
|
|