[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNT_INLV_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PS_UNT_INLV_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_PS_UNT_INLV_HIST_ALL describes the history of changes for a unit internal program level.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PS_UNT_INLV_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
UNIT_INT_COURSE_LEVEL_CD
HIST_START_DT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_INT_COURSE_LEVEL_CD | VARCHAR2 | (10) | Yes | Describes the internal program level code for WEFTSU unit grouping. |
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. |
DESCRIPTION | VARCHAR2 | (60) | Description, or name, of the unit internal program level. Internal program levels are used in the determination of WEFTSU. | |
WEFTSU_FACTOR | NUMBER | (3) | Factor associated with the internal program level grouping used in the determination of weighted equivalent full time student Units. | |
CLOSED_IND | VARCHAR2 | (1) | Indicator that specifies if the unit internal program level is open or closed. Setting the checkbox to closed ticked prevents use of the internal program level in new or modified 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_INT_COURSE_LEVEL_CD
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, DESCRIPTION
, WEFTSU_FACTOR
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_PS_UNT_INLV_HIST_ALL;
IGS.IGS_PS_UNT_INLV_HIST_ALL does not reference any database object
IGS.IGS_PS_UNT_INLV_HIST_ALL is referenced by following:
|
|
|