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

TABLE: IGS.IGS_AD_TEST_INT

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


Contains Test Result details for each person to be imported into the IGS_AD_TEST_RESULTS table by the Admission Import process
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Test
Category: BUSINESS_ENTITY IGS_PREV_EDUCATION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_TEST_INT_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_TEST_ID
IGS_AD_TEST_INT_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_ID
IGS_AD_TEST_INT_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSTATUS
IGS_AD_TEST_INT_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_RUN_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_TEST_ID NUMBER (15) Yes A unique identifier assigned to identify each test results details record of the interface table . This ID should be populated when the rows are inserted into this table
INTERFACE_ID NUMBER (15) Yes Interface identifier
ADMISSION_TEST_TYPE VARCHAR2 (30) Yes Type of the admission test taken by the person, for example, TOEFL, UMAT and others
REGISTRATION_NUMBER VARCHAR2 (30)
Registration number provided by the testing agency if the test is taken
TEST_DATE DATE
Yes Date that the test was administered
SCORE_REPORT_DATE DATE

Date that the test scores were created
EDU_LEVEL_ID NUMBER (15)
Education level of the person at the time the test was given
SCORE_TYPE VARCHAR2 (30)
Test score type
SCORE_SOURCE_ID NUMBER (15)
Score source
NON_STANDARD_ADMIN VARCHAR2 (1)
Non standard test administration
SPECIAL_CODE VARCHAR2 (30)
Special code
STATUS VARCHAR2 (2) Yes Status of the record - imported, pending, error or warning
MATCH_IND VARCHAR2 (2)
Match indicator
ERROR_CODE VARCHAR2 (30)
Error code of the record
ACTIVE_IND VARCHAR2 (1)
Indicator for Active Test Types
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)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
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
PERSON_ID NUMBER (15)
Person Identifier. This column will be populated by the import process.
ERROR_TEXT VARCHAR2 (2000)
Error Text
GRADE_ID NUMBER (15)
Grade Identifier as defined in the Test Results Information -> Test Results Grade
TEST_RESULTS_ID NUMBER (15)
Test Results Identifier
DUP_TEST_RESULTS_ID NUMBER (15)
Unique identifier to identify duplicate test result record in OSS
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
Query Text

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


SELECT INTERFACE_TEST_ID
,      INTERFACE_ID
,      ADMISSION_TEST_TYPE
,      REGISTRATION_NUMBER
,      TEST_DATE
,      SCORE_REPORT_DATE
,      EDU_LEVEL_ID
,      SCORE_TYPE
,      SCORE_SOURCE_ID
,      NON_STANDARD_ADMIN
,      SPECIAL_CODE
,      STATUS
,      MATCH_IND
,      ERROR_CODE
,      ACTIVE_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INTERFACE_RUN_ID
,      PERSON_ID
,      ERROR_TEXT
,      GRADE_ID
,      TEST_RESULTS_ID
,      DUP_TEST_RESULTS_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM IGS.IGS_AD_TEST_INT;

Dependencies

[top of page]

IGS.IGS_AD_TEST_INT does not reference any database object

IGS.IGS_AD_TEST_INT is referenced by following:

SchemaAPPS
SynonymIGS_AD_TEST_INT