[Home] [Help] [Dependency Information]
Object Name: | IGR_I_APPL_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGR_I_APPL_INT |
Subobject Name: | |
Status: | VALID |
Holds inquiry instance interface records. This table is a child to IGS_AD_INTERFACE_ALL and the value in the INTERFACE_ID column links rows in these tables The corresponding production table is IGR_I_APPL_ALL.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Inquiry Application
Category: BUSINESS_ENTITY IGS_INQ_APPLICATION
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGR_I_APPL_INT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | INTERFACE_INQ_APPL_ID |
IGR_I_APPL_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INTERFACE_ID |
IGR_I_APPL_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATUS |
IGR_I_APPL_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_INQ_APPL_ID | NUMBER | (15) | Yes | A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table |
INTERFACE_ID | NUMBER | (15) | Yes | Interface Identifier |
SALES_LEAD_ID | NUMBER | (15) | Used internally by the import process for processing inquiry child records | |
ENQUIRY_APPL_NUMBER | NUMBER | (15) | Enquiry Application Number | |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Academic Calendar type in which the Inquiry is made |
ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Academic Sequence Number |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Admission Calendar Type |
ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Admission Calendar Sequence Number |
INQUIRY_STATUS | VARCHAR2 | (30) | Yes | Inquiry Status. 'MAILED', 'INQUIRED' |
INQUIRY_DT | DATE | Yes | Inquiry Date | |
INQUIRY_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Inquiry Source Type. 'Web Inquiry' |
INQUIRY_ENTRY_STATUS_ID | NUMBER | (15) | Obsolete | |
INQUIRY_ENTRY_LEVEL_ID | NUMBER | (15) | Inquiry Entry Level. First year, second year, junior , senior | |
REGISTERING_PERSON_ID | NUMBER | (15) | Registering Person Identifier | |
OVERRIDE_PROCESS_IND | VARCHAR2 | (1) | Yes | Override Process Indicator. |
INDICATED_MAILING_DT | DATE | Indicated Mailing Date | ||
LAST_PROCESS_DT | DATE | Last Processed Date | ||
COMMENTS | VARCHAR2 | (2000) | Comments | |
EDU_GOAL_ID | NUMBER | (15) | Educational Career Goal. Medicine, business, law | |
INQUIRY_SCHOOL_OF_INTEREST_ID | NUMBER | (15) | Inquiry School Of Interest | |
LEARN_SOURCE_ID | NUMBER | (15) | Inquiry Learning Source | |
INFLUENCE_SOURCE_ID | NUMBER | (15) | Inquiry Influence Id | |
STATUS | VARCHAR2 | (1) | Yes | 1 - Completed2 - Pending3 - Error4 - Warning |
MATCH_IND | VARCHAR2 | (2) | '18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' -- Match reviewed and do not import | |
ERROR_CODE | VARCHAR2 | (30) | Error Code | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flex field structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flex field segment Column | |
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 | |
REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
SOURCE_PROMOTION_ID | NUMBER | (15) | Storing the identifier for OMO campaigns or events | |
INTERFACE_RUN_ID | NUMBER | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user | ||
ERROR_TEXT | VARCHAR2 | (2000) | Error Text | |
PERSON_ID | NUMBER | (15) | Person Identifier. This column will be populated by the import process | |
INQUIRY_TYPE_ID | NUMBER | (15) | Inquiry Type ID | |
PKG_REDUCT_IND | VARCHAR2 | (1) | Package Reduction Indicator. It indicates whether the LOV in package item window will show all the available package items or it will show only those package items corresponding to the academic interest category attached to the inquiry instance. |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_INQ_APPL_ID
, INTERFACE_ID
, SALES_LEAD_ID
, ENQUIRY_APPL_NUMBER
, ACAD_CAL_TYPE
, ACAD_CI_SEQUENCE_NUMBER
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, INQUIRY_STATUS
, INQUIRY_DT
, INQUIRY_SOURCE_TYPE
, INQUIRY_ENTRY_STATUS_ID
, INQUIRY_ENTRY_LEVEL_ID
, REGISTERING_PERSON_ID
, OVERRIDE_PROCESS_IND
, INDICATED_MAILING_DT
, LAST_PROCESS_DT
, COMMENTS
, EDU_GOAL_ID
, INQUIRY_SCHOOL_OF_INTEREST_ID
, LEARN_SOURCE_ID
, INFLUENCE_SOURCE_ID
, STATUS
, MATCH_IND
, ERROR_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_PROMOTION_ID
, INTERFACE_RUN_ID
, ERROR_TEXT
, PERSON_ID
, INQUIRY_TYPE_ID
, PKG_REDUCT_IND
FROM IGS.IGR_I_APPL_INT;
IGS.IGR_I_APPL_INT does not reference any database object
IGS.IGR_I_APPL_INT is referenced by following:
|
|
|