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

TABLE: IGS.IGS_DA_OUT_TSTS

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


IGS_DA_OUT_TSTS stores outgoing test information for students selected in the request. --Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_DA_OUT_TSTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPERSON_ID
ColumnTEST_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Unique ID for a request
PERSON_ID NUMBER (15) Yes Unique identifier for a person
TEST_SEQ_NUM NUMBER
Yes Sequence number associated with each test type for the student in the request.
TEST_TYPE VARCHAR2 (30)
Identifies type of test.
TEST_DATE DATE

Test administration date .
TERM VARCHAR2 (10)
Derived teaching period which is associated with the test date.
SPECIAL_CODE VARCHAR2 (30)
User-defined code associated with the test type.
COMPOSITE_SCORE NUMBER (22)
Summary of scores of the test segments associated with the test type.
TEST_SCORE_ACTIVE VARCHAR2 (1)
Indicates which of the test dates associated with the test type is the one used to determine competency and unit placement.Y indicates YES, N indicates NO.
TEST_SCORE_ATTR1 VARCHAR2 (150)
Test Scores Screen DFF Attribute 1
TEST_SCORE_ATTR2 VARCHAR2 (150)
Test Scores Screen DFF Attribute 2
TEST_SCORE_ATTR3 VARCHAR2 (150)
Test Scores Screen DFF Attribute 3
TEST_SCORE_ATTR4 VARCHAR2 (150)
Test Scores Screen DFF Attribute 4
TEST_SCORE_ATTR5 VARCHAR2 (150)
Test Scores Screen DFF Attribute 5
TEST_SCORE_ATTR6 VARCHAR2 (150)
Test Scores Screen DFF Attribute 6
TEST_SCORE_ATTR7 VARCHAR2 (150)
Test Scores Screen DFF Attribute 7
TEST_SCORE_ATTR8 VARCHAR2 (150)
Test Scores Screen DFF Attribute 8
TEST_SCORE_ATTR9 VARCHAR2 (150)
Test Scores Screen DFF Attribute 9
TEST_SCORE_ATTR10 VARCHAR2 (150)
Test Scores Screen DFF Attribute 10
TEST_SCORE_ATTR11 VARCHAR2 (150)
Test Scores Screen DFF Attribute 11
TEST_SCORE_ATTR12 VARCHAR2 (150)
Test Scores Screen DFF Attribute 12
TEST_SCORE_ATTR13 VARCHAR2 (150)
Test Scores Screen DFF Attribute 13
TEST_SCORE_ATTR14 VARCHAR2 (150)
Test Scores Screen DFF Attribute 14
TEST_SCORE_ATTR15 VARCHAR2 (150)
Test Scores Screen DFF Attribute 15
TEST_SCORE_ATTR16 VARCHAR2 (150)
Test Scores Screen DFF Attribute 16
TEST_SCORE_ATTR17 VARCHAR2 (150)
Test Scores Screen DFF Attribute 17
TEST_SCORE_ATTR18 VARCHAR2 (150)
Test Scores Screen DFF Attribute 18
TEST_SCORE_ATTR19 VARCHAR2 (150)
Test Scores Screen DFF Attribute 19
TEST_SCORE_ATTR20 VARCHAR2 (150)
Test Scores Screen DFF Attribute 20
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      TEST_SEQ_NUM
,      TEST_TYPE
,      TEST_DATE
,      TERM
,      SPECIAL_CODE
,      COMPOSITE_SCORE
,      TEST_SCORE_ACTIVE
,      TEST_SCORE_ATTR1
,      TEST_SCORE_ATTR2
,      TEST_SCORE_ATTR3
,      TEST_SCORE_ATTR4
,      TEST_SCORE_ATTR5
,      TEST_SCORE_ATTR6
,      TEST_SCORE_ATTR7
,      TEST_SCORE_ATTR8
,      TEST_SCORE_ATTR9
,      TEST_SCORE_ATTR10
,      TEST_SCORE_ATTR11
,      TEST_SCORE_ATTR12
,      TEST_SCORE_ATTR13
,      TEST_SCORE_ATTR14
,      TEST_SCORE_ATTR15
,      TEST_SCORE_ATTR16
,      TEST_SCORE_ATTR17
,      TEST_SCORE_ATTR18
,      TEST_SCORE_ATTR19
,      TEST_SCORE_ATTR20
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_OUT_TSTS;

Dependencies

[top of page]

IGS.IGS_DA_OUT_TSTS does not reference any database object

IGS.IGS_DA_OUT_TSTS is referenced by following:

SchemaAPPS
SynonymIGS_DA_OUT_TSTS