[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_ADMDE_INT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_ADMDE_INT_ALL |
Subobject Name: | |
Status: | VALID |
Contains the Admission Decision Details to be imported by the Automatic Batch Admission Decisions Import process into IGS_AD_PS_APPL_INST_ALL table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Admission Decision
Category: BUSINESS_ENTITY IGS_ADM_APPLICATION
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_ADMDE_INT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_MKDES_ID |
IGS_AD_ADMDE_INT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
IGS_AD_ADMDE_INT_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
PERSON_ID
ADMISSION_APPL_NUMBER NOMINATED_COURSE_CD SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_MKDES_ID | NUMBER | (15) | Yes | Unique Identifier of the application instance interface record |
INTERFACE_RUN_ID | NUMBER | (15) | Yes | Identifier of the batch process run for the automatic decision making. |
BATCH_ID | NUMBER | (15) | Yes | Batch Process Identifier |
PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
ADMISSION_APPL_NUMBER | NUMBER | (2) | Yes | Admission Application Number |
NOMINATED_COURSE_CD | VARCHAR2 | (6) | Yes | Program Code for which the person has applied |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence Number of the application instance |
ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Outcome Status of the Admission Application |
DECISION_MAKE_ID | NUMBER | (15) | Person Identifier of the person who has made the decision on the application | |
DECISION_DATE | DATE | Date on which the admission decision is taken | ||
DECISION_REASON_ID | NUMBER | (15) | Identifier of the reason to make such a decision | |
PENDING_REASON_ID | NUMBER | (15) | Identifier of the reason that the application is pending | |
OFFER_DT | DATE | Date on which the offer is made on the application | ||
OFFER_RESPONSE_DT | DATE | Date the person to respond on the offer made | ||
STATUS | VARCHAR2 | (2) | Yes | Status of the Record. |
ERROR_CODE | VARCHAR2 | (30) | Error Code of the record. | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
REQUEST_ID | NUMBER | (15) | Concurrent Program Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program Standard Who Column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program Standard Who Column | ||
ORG_ID | NUMBER | (15) | Multi Org Identifier | |
RECONSIDER_FLAG | VARCHAR2 | (1) | Reconsideration flag indicating whether the Application instance has to be reconsider or not. | |
PRPSD_COMMENCEMENT_DATE | DATE | Proposed Commencement Date | ||
ERROR_TEXT | VARCHAR2 | (2000) | Holds the Error message text |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_MKDES_ID
, INTERFACE_RUN_ID
, BATCH_ID
, PERSON_ID
, ADMISSION_APPL_NUMBER
, NOMINATED_COURSE_CD
, SEQUENCE_NUMBER
, ADM_OUTCOME_STATUS
, DECISION_MAKE_ID
, DECISION_DATE
, DECISION_REASON_ID
, PENDING_REASON_ID
, OFFER_DT
, OFFER_RESPONSE_DT
, STATUS
, ERROR_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, RECONSIDER_FLAG
, PRPSD_COMMENCEMENT_DATE
, ERROR_TEXT
FROM IGS.IGS_AD_ADMDE_INT_ALL;
IGS.IGS_AD_ADMDE_INT_ALL does not reference any database object
IGS.IGS_AD_ADMDE_INT_ALL is referenced by following:
|
|
|