[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_OU_STAT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AD_OU_STAT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Describes user-defined admission outcome statuses like offer to be made, conditional offer to be made, unsuccessful, reject, offer revoked. These map to the system admission outcome statuses that are recognized by system functionality.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier of the driving table. | |
ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Contains institution-defined status assigned to an admission application to describe the state of the applicant's request for admission. These must be mapped to a relevant system-defined admission outcome status. For example, Pending-application under consideration, Offer-make offer of admission, Cond-Offer make offer of admission subject to conditions. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the admission outcome status |
S_ADM_OUTCOME_STATUS | VARCHAR2 | (30) | Yes | Contains the system-defined status assigned to an admission application to describe the state of the applicant's request foradmission. For example, Pending, Offer, Cond-Offer. |
SYSTEM_DEFAULT_IND | VARCHAR2 | (1) | Yes | An indicator that specifies if the admission outcome status is the default institution-defined status that the system should use whenreferred to from a system-defined admission outcome status. Settingthe checkbox to 'system default' (ticked) ensures that thisinstitution-defined status will be used when referred to from therelevant system-defined status. |
CLOSED_IND | VARCHAR2 | (1) | Yes | An indicator that specifies if the admission outcome status is open orclosed. Setting the checkbox to 'closed' (ticked) prevents use of theadmission outcome status in new or modified admission applicationrecords. |
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 | |
MEANING | VARCHAR2 | (80) | Yes | Meaning of the lookup code. |
DSP_CLOSED_IND | VARCHAR2 | (1) | Flag to show whether a look up code is available. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ADM_OUTCOME_STATUS
, DESCRIPTION
, S_ADM_OUTCOME_STATUS
, SYSTEM_DEFAULT_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MEANING
, DSP_CLOSED_IND
FROM APPS.IGS_AD_OU_STAT_V;
|
|
|