[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_LVL_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_UNIT_LVL_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_UNIT_LVL_HIST_ALL describes the history of changes to a unit version's program unit level.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_UNIT_LVL_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
UNIT_CD
VERSION_NUMBER COURSE_CD COURSE_VERSION_NUMBER HIST_START_DT |
IGS_PS_UNIT_LVL_HIST_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COURSE_TYPE |
IGS_PS_UNIT_LVL_HIST_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UNIT_LEVEL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | Yes | Code used to identify the unit. |
VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit. |
COURSE_TYPE | VARCHAR2 | (10) | Describes the type of programs offered by the university. Program type is an element defined by DETYA, however, the system is not limited to the DETYA list. DETYA element reference 310. For example, 01 Higher Doctorate, 20 Diploma. --Obsoleted | |
HIST_START_DT | DATE | Yes | Effective start date and time of the history record. | |
HIST_END_DT | DATE | Yes | Effective end date and time of the history record. | |
HIST_WHO | NUMBER | (15) | Yes | Oracle username of the person who created the history record. |
UNIT_LEVEL | VARCHAR2 | (4) | Describes the available university levels. For example, 1 - A first year unit within a program, 2 - A second year unit within a program. | |
WAM_WEIGHTING | NUMBER | (8) | Describes the weighting of the program unit level for the purposes of a weighted average mark calculation. | |
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 | |
COURSE_CD | VARCHAR2 | (6) | Yes | Program code for what the unit level for a unit code is overridden for a unit code. |
COURSE_VERSION_NUMBER | NUMBER | (3) | Yes | Program version number |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, VERSION_NUMBER
, COURSE_TYPE
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, UNIT_LEVEL
, WAM_WEIGHTING
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, COURSE_CD
, COURSE_VERSION_NUMBER
FROM IGS.IGS_PS_UNIT_LVL_HIST_ALL;
IGS.IGS_PS_UNIT_LVL_HIST_ALL does not reference any database object
IGS.IGS_PS_UNIT_LVL_HIST_ALL is referenced by following:
|
|
|