DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_AD_INQ_APPL_INT

Object Details
Object Name: IGS_AD_INQ_APPL_INT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AD_INQ_APPL_INT
Subobject Name:
Status: VALID


IGS_AD_INQ_APPL_INT holds admission inquiry instance interface records - Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_INQ_APPL_INT_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_INQ_APPL_ID
Columns
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
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 (10) Yes Inquiry Status. 'MAILED', 'INQUIRED'
INQUIRY_DT DATE
Yes Inquiry Date
DUP_PERSON_ID NUMBER (15)
Duplicate Person Identifier
DUP_ENQUIRY_APPL_NUMBER NUMBER (15)
Duplicate Inquiry Application Number
INQUIRY_SOURCE_TYPE VARCHAR2 (10) Yes Inquiry Source Type. 'Web Inquiry'
INQUIRY_ENTRY_STATUS_ID NUMBER (15) Yes Inquiry Status(First time freshman, transfer, new graduate)
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_INQ_APPL_ID
,      INTERFACE_ID
,      ENQUIRY_APPL_NUMBER
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      INQUIRY_STATUS
,      INQUIRY_DT
,      DUP_PERSON_ID
,      DUP_ENQUIRY_APPL_NUMBER
,      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
FROM IGS.IGS_AD_INQ_APPL_INT;

Dependencies

[top of page]

IGS.IGS_AD_INQ_APPL_INT does not reference any database object

IGS.IGS_AD_INQ_APPL_INT is referenced by following:

SchemaAPPS
SynonymIGS_AD_INQ_APPL_INT