[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_OFRDFRMT_STAT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_OFRDFRMT_STAT |
Subobject Name: | |
Status: | VALID |
IGS_AD_OFRDFRMT_STAT describes user-defined admission offer deferrment
statuses, which map to system admission offer deferrment statuses.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_OFRDFRMT_STAT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ADM_OFFER_DFRMNT_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADM_OFFER_DFRMNT_STATUS | VARCHAR2 | (10) | Yes | Contains the institution-defined status assigned to an admission application to describe the state of a request by the applicant for deferral of their admission. These must be mapped on to a relevant system-defined admission offer deferment status. For example, - Pending - Application for deferral of admission under consideration, Approved - Application for deferred admission approved, Rejected - Application for deferred admission rejected. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the admission offer deferment status |
S_ADM_OFFER_DFRMNT_STATUS | VARCHAR2 | (30) | Yes | Contains the system-defined status assigned to an admission application to describe the state of a request by the applicant for deferral of their admission. For example, Pending, Approved, Rejected. |
SYSTEM_DEFAULT_IND | VARCHAR2 | (1) | Yes | Specifies if the admission offer deferment status is the default institution-defined status that the system should use when referred to from a system-defined admission offer deferment status. Setting the checkbox to 'system default' ensures that this institution-defined status will be used when referred to from the relevant system-defined status. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Specifies if the admission offer deferment status is open or closed. Setting the checkbox to 'closed' prevents use of the admission offer deferment 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_DFRMNT_STATUS
, DESCRIPTION
, S_ADM_OFFER_DFRMNT_STATUS
, SYSTEM_DEFAULT_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_OFRDFRMT_STAT;
IGS.IGS_AD_OFRDFRMT_STAT does not reference any database object
IGS.IGS_AD_OFRDFRMT_STAT is referenced by following:
|
|
|