[Home] [Help] [Dependency Information]
Object Name: | IGS_PR_UL_MARK_DTL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PR_UL_MARK_DTL |
Subobject Name: | |
Status: | VALID |
Defines the configuration details like core type indicator, priority in selecting the units for marks calculation etc.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PR_UL_MARK_DTL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
MARK_CONFIG_ID
CORE_INDICATOR_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MARK_CONFIG_ID | NUMBER | Yes | Foreign key to the table IGS_PR_UL_MARK_CNFG. | |
CORE_INDICATOR_CODE | VARCHAR2 | (30) | Yes | The type of unit attempt - core, optional, or elective. |
TOTAL_CREDITS | NUMBER | (3) | The total credits to be selected for the core type. | |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Indicator that the Total Credit is required for the indicator type. Default value is 'N' |
PRIORITY_NUM | NUMBER | Yes | The priority to select units. | |
UNIT_SELECTION_CODE | VARCHAR2 | (30) | Defines the order to select unit attempts. | |
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 MARK_CONFIG_ID
, CORE_INDICATOR_CODE
, TOTAL_CREDITS
, REQUIRED_FLAG
, PRIORITY_NUM
, UNIT_SELECTION_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_PR_UL_MARK_DTL;
IGS.IGS_PR_UL_MARK_DTL does not reference any database object
IGS.IGS_PR_UL_MARK_DTL is referenced by following:
|
|
|