[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_ENCMB_EFCTTYP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_EN_ENCMB_EFCTTYP |
Subobject Name: | |
Status: | VALID |
IGS_EN_ENCMB_EFCTTYP describes the encumbrance effects recognized by the system, and available for application to a student. For example, suppression of transcript, maximum enrollment load restriction.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_EN_ENCMB_EFCTTYP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | S_ENCMB_EFFECT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
S_ENCMB_EFFECT_TYPE | VARCHAR2 | (10) | Yes | System-defined encumbrance effect used in the creation of institution-defined encumbrance types. |
APPLY_TO_COURSE_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the system encumbrance effect type must be applied to an existing student program attempt. Setting the indicator restricts the system encumbrance effect type to an existing student program attempt. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the system encumbrance effect type is closed. Setting the checkbox prevents use of the system encumbrance effect type in the creation of new or modified institution-defined encumbrance types. |
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 S_ENCMB_EFFECT_TYPE
, APPLY_TO_COURSE_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_ENCMB_EFCTTYP;
IGS.IGS_EN_ENCMB_EFCTTYP does not reference any database object
IGS.IGS_EN_ENCMB_EFCTTYP is referenced by following:
|
|
|