eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_AD_TEST_SEGMENTS

Object Details

Object Name:	IGS_AD_TEST_SEGMENTS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_AD_TEST_SEGMENTS
Subobject Name:
Status:	VALID

IGS_AD_TEST_SEGMENTS holds test segments details for test type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_TEST_SEGMENTS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEST_SEGMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEST_SEGMENT_ID	NUMBER		Yes	Unique identifier that identifies a test segment
ADMISSION_TEST_TYPE	VARCHAR2	(30)	Yes	Admission test type
TEST_SEGMENT_NAME	VARCHAR2	(30)	Yes	Test segment name
DESCRIPTION	VARCHAR2	(80)	Yes	Description of the test segment
CLOSED_IND	VARCHAR2	(1)	Yes	Closed indicator to prevent further use of a test segment
MIN_SCORE	NUMBER		Yes	Minimum score for this test segment
MAX_SCORE	NUMBER		Yes	Maximum score for this test segment
INCLUDE_IN_COMP_SCORE	VARCHAR2	(1)	Yes	Whether to include this test segment in the composite test score calculation
SCORE_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
PERCENTILE_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
NATIONAL_PERCENTILE_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
STATE_PERCENTILE_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
PERCENTILE_YEAR_RANK_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
SCORE_BAND_UPPER_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
SCORE_BAND_LOWER_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
IRREGULARITY_CODE_IND	VARCHAR2	(1)	Yes	Whether this attribute is part of this test segment
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
SEGMENT_TYPE	VARCHAR2	(10)	Yes	Defines the segment type of the test segment. It can have values 'SCORE' and 'SUB SCORE'.
SEGMENT_GROUP	NUMBER	(3)	Yes	User defined number sequences. Matches the SCORE and SUB SCORE test segments.

Query Text

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


SELECT TEST_SEGMENT_ID
,      ADMISSION_TEST_TYPE
,      TEST_SEGMENT_NAME
,      DESCRIPTION
,      CLOSED_IND
,      MIN_SCORE
,      MAX_SCORE
,      INCLUDE_IN_COMP_SCORE
,      SCORE_IND
,      PERCENTILE_IND
,      NATIONAL_PERCENTILE_IND
,      STATE_PERCENTILE_IND
,      PERCENTILE_YEAR_RANK_IND
,      SCORE_BAND_UPPER_IND
,      SCORE_BAND_LOWER_IND
,      IRREGULARITY_CODE_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEGMENT_TYPE
,      SEGMENT_GROUP
FROM IGS.IGS_AD_TEST_SEGMENTS;

Dependencies

[top of page]

IGS.IGS_AD_TEST_SEGMENTS does not reference any database object

IGS.IGS_AD_TEST_SEGMENTS is referenced by following:

APPS: IGS_AD_TEST_SEGMENTS