[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_DFLT_OUDTLS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_DFLT_OUDTLS |
Subobject Name: | |
Status: | VALID |
Default Outcome Decision Details
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_DEF_OTCM_DEC_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ADM_OUTCOME_STATUS
CREATED_BY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Admission Outcome status |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
DFLT_DECISIONDATE_FLAG | VARCHAR2 | (1) | Yes | Whether system date should be defaulted in for outcome decision date or not |
RECONSIDER_FLAG | VARCHAR2 | (1) | Yes | Request for Reconsideration flag |
DECISION_MAKER_ID | NUMBER | (15) | Decision maker identifier | |
DECISION_DATE | DATE | Decision Date | ||
FUTURE_ACAD_CAL_TYPE | VARCHAR2 | (10) | Future academic calendar type | |
FUTURE_ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Future academic calendar sequence number | |
FUTURE_ADM_CAL_TYPE | VARCHAR2 | (10) | Future admission calendar type | |
FUTURE_ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Future admission calendar sequence number | |
DECISION_REASON_ID | NUMBER | (15) | Decision reason identifier | |
PENDING_REASON_ID | NUMBER | (15) | Pending reason identifier | |
WAITLIST_STATUS_CODE | VARCHAR2 | (30) | Waitlist status | |
WAITLIST_RANK | VARCHAR2 | (30) | Waitlist rank | |
UCAS_COND_CATEGORY | VARCHAR2 | (450) | UCAS Condition category | |
UCAS_COND_NAME | VARCHAR2 | (450) | UCAS Condition name | |
ADM_CNDTNL_OFFER_STATUS | VARCHAR2 | (10) | Admission Conditional Offer Status | |
CNDTNL_OFFER_SATISFIED_DATE | DATE | Conditional Offer satisfied date | ||
CNDNL_OFFER_MST_BE_STSFD_FLAG | VARCHAR2 | (1) | Yes | Conditional Offer must be satisfied Indicator |
CNDTNL_OFFER_CNDTN_TXT | VARCHAR2 | (2000) | Condition for the Offer | |
ADM_OTCM_STATUS_AUTH_PERSON_ID | NUMBER | (15) | Admission outcome status Authorizing person Identifier | |
ADM_OUTCOME_STATUS_AUTH_DATE | DATE | Admission outcome status Authorized Date | ||
ADM_OUTCOME_STATUS_REASON | VARCHAR2 | (60) | Admission outcome status reason | |
DFLT_OFFERDATE_FLAG | VARCHAR2 | (1) | Yes | Default Sysdate as Offer date |
OFFER_DATE | DATE | Offer Date | ||
OFFER_RESPONSE_DATE | DATE | Offer deadline Date | ||
PRPSD_COMMENCEMENT_DATE | DATE | Proposed Commencement Date | ||
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_OUTCOME_STATUS
, CREATED_BY
, DFLT_DECISIONDATE_FLAG
, RECONSIDER_FLAG
, DECISION_MAKER_ID
, DECISION_DATE
, FUTURE_ACAD_CAL_TYPE
, FUTURE_ACAD_CI_SEQUENCE_NUMBER
, FUTURE_ADM_CAL_TYPE
, FUTURE_ADM_CI_SEQUENCE_NUMBER
, DECISION_REASON_ID
, PENDING_REASON_ID
, WAITLIST_STATUS_CODE
, WAITLIST_RANK
, UCAS_COND_CATEGORY
, UCAS_COND_NAME
, ADM_CNDTNL_OFFER_STATUS
, CNDTNL_OFFER_SATISFIED_DATE
, CNDNL_OFFER_MST_BE_STSFD_FLAG
, CNDTNL_OFFER_CNDTN_TXT
, ADM_OTCM_STATUS_AUTH_PERSON_ID
, ADM_OUTCOME_STATUS_AUTH_DATE
, ADM_OUTCOME_STATUS_REASON
, DFLT_OFFERDATE_FLAG
, OFFER_DATE
, OFFER_RESPONSE_DATE
, PRPSD_COMMENCEMENT_DATE
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_DFLT_OUDTLS;
IGS.IGS_AD_DFLT_OUDTLS does not reference any database object
IGS.IGS_AD_DFLT_OUDTLS is referenced by following:
|
|
|