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

TABLE: IGS.IGS_OR_INST_INT

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


Contains the Institution Interface Details to be imported into HZ_PARTIES, IGS_PE_HZ_PARTIES.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Institutions
Category: BUSINESS_ENTITY IGS_INSTITUTION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_OR_INST_INT_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_ID
IGS_OR_INST_INT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER (15) Yes Interface Identifier. Logical Primary Key for this table
BATCH_ID NUMBER (15) Yes Batch Identifier
STATUS VARCHAR2 (1) Yes Status of the Record. For E.g. '1'- Completed '2' - Pending '3' - Error
NEW_INSTITUTION_CD VARCHAR2 (30)
New Institution Code
EXST_INSTITUTION_CD VARCHAR2 (30)
Existing Institution Code for Match
NAME VARCHAR2 (360)
Name of the Institution
ALT_ID_TYPE VARCHAR2 (30)
Alternate Identifier Type
ALT_ID_VALUE VARCHAR2 (25)
Alternate Identifier Value
INSTITUTION_STATUS VARCHAR2 (10)
Status of the Institution
LOCAL_INSTITUTION_IND VARCHAR2 (1)
Local Institution Indicator
OS_IND VARCHAR2 (1)
OS Indicator - OBSOLETE
GOVT_INSTITUTION_CD VARCHAR2 (30)
Government Institution Code
INSTITUTION_TYPE VARCHAR2 (20) Yes Type of the Institution
INST_CONTROL_TYPE VARCHAR2 (30) Yes Control type for the Institution
INST_PRIORITY_CD VARCHAR2 (30)
Institution Priority Code
EPS_CODE VARCHAR2 (8)
Market Code
ADV_STUDIES_CLASSES NUMBER

Number of Advanced Studies Classes Offered
HONORS_CLASSES NUMBER

Number of Honors Classes Offered
CLASS_SIZE NUMBER

Size of the Class
SEC_SCHOOL_LOCATION_ID NUMBER (15)
Secondary School Location Identifier
PERCENT_PLAN_HIGHER_EDU NUMBER

Planning to Pursue Higher Education Percentage
PHONE_COUNTRY VARCHAR2 (10)
Phone Country Code
PHONE_AREA VARCHAR2 (10)
Phone Area Code
PHONE_NUMBER VARCHAR2 (40)
Phone Number
ACCOUNT_NUMBER VARCHAR2 (30)
Obsolete this Column- Account Number
DATA_SOURCE_ID VARCHAR2 (30) Yes Data Source Identifier
DATA_SOURCE_VALUE VARCHAR2 (25) Yes Data Source Value
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
ERROR_CODE VARCHAR2 (30)
Error Code for the Interface Record
ERROR_TEXT VARCHAR2 (2000)
Error Text for the Interface Record while creating/updating the record.
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flex field segment column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flex field segment column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flex field segment column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flex field segment column
Query Text

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


SELECT INTERFACE_ID
,      BATCH_ID
,      STATUS
,      NEW_INSTITUTION_CD
,      EXST_INSTITUTION_CD
,      NAME
,      ALT_ID_TYPE
,      ALT_ID_VALUE
,      INSTITUTION_STATUS
,      LOCAL_INSTITUTION_IND
,      OS_IND
,      GOVT_INSTITUTION_CD
,      INSTITUTION_TYPE
,      INST_CONTROL_TYPE
,      INST_PRIORITY_CD
,      EPS_CODE
,      ADV_STUDIES_CLASSES
,      HONORS_CLASSES
,      CLASS_SIZE
,      SEC_SCHOOL_LOCATION_ID
,      PERCENT_PLAN_HIGHER_EDU
,      PHONE_COUNTRY
,      PHONE_AREA
,      PHONE_NUMBER
,      ACCOUNT_NUMBER
,      DATA_SOURCE_ID
,      DATA_SOURCE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ERROR_CODE
,      ERROR_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
FROM IGS.IGS_OR_INST_INT;

Dependencies

[top of page]

IGS.IGS_OR_INST_INT does not reference any database object

IGS.IGS_OR_INST_INT is referenced by following:

SchemaAPPS
SynonymIGS_OR_INST_INT