[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_OFR_RESP_STAT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_OFR_RESP_STAT |
Subobject Name: | |
Status: | VALID |
IGS_AD_OFR_RESP_STAT describes user-defined admission offer response
statuses, which map to system admission offer response statuses.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_OFR_RESP_STAT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADM_OFFER_RESP_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADM_OFFER_RESP_STATUS | VARCHAR2 | (10) | Yes | Contains the institution-defined status assigned to an admission application to describe the state of the applicant's response to an offer of admission. These must be mapped on to a relevant system-defined admission offer response status .For example, Pending - Response to offer outstanding, Accepted - Offer of admission accepted, Lapsed - Offer of admission has lapsed. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the admission offer response status |
S_ADM_OFFER_RESP_STATUS | VARCHAR2 | (30) | Yes | Contains the system-defined status assigned to an admission application to describe the state of the applicant's response to an offer of admission. For example, Pending, Accepted, Lapsed. |
SYSTEM_DEFAULT_IND | VARCHAR2 | (1) | Yes | Specifies if the admission offer response status is the default institution-defined status that the system should use when referred to from a system-defined admission offer response status. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies if the admission offer response status is open or closed. Setting the checkbox to 'closed' prevents use of the admission offer response 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_OFFER_RESP_STATUS
, DESCRIPTION
, S_ADM_OFFER_RESP_STATUS
, SYSTEM_DEFAULT_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_OFR_RESP_STAT;
IGS.IGS_AD_OFR_RESP_STAT does not reference any database object
IGS.IGS_AD_OFR_RESP_STAT is referenced by following:
|
|
|