[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_CNDNL_OFRSTAT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_CNDNL_OFRSTAT |
Subobject Name: | |
Status: | VALID |
IGS_AD_CNDNL_OFRSTAT describes user-defined admission conditional offer
statuses which map to system-defined admission conditional offer statuses.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_CNDNL_OFRSTAT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADM_CNDTNL_OFFER_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADM_CNDTNL_OFFER_STATUS | VARCHAR2 | (10) | Yes | Contains the institution-defined status assigned to an admission conditional offer to describe whether the conditions attached to the offer of admission have been met. These must be mapped on to a system-defined conditional offer status. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the admission conditional offer status |
S_ADM_CNDTNL_OFFER_STATUS | VARCHAR2 | (30) | Yes | Contains the system-defined status assigned to an admission conditional offer to describe whether the conditions attached to the offer of admission have been met. For example, - Pending, Satisfied, Waived. |
SYSTEM_DEFAULT_IND | VARCHAR2 | (1) | Yes | Specifies if the admission conditional offer status is the default institution-defined status that the system should use when referred to from a system-defined admission conditional offer status. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies if the admission conditional offer status is open or closed. Setting the checkbox to 'closed' prevents use of the admission conditional offer status in new or modified admission application 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 ADM_CNDTNL_OFFER_STATUS
, DESCRIPTION
, S_ADM_CNDTNL_OFFER_STATUS
, SYSTEM_DEFAULT_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_CNDNL_OFRSTAT;
IGS.IGS_AD_CNDNL_OFRSTAT does not reference any database object
IGS.IGS_AD_CNDNL_OFRSTAT is referenced by following:
|
|
|