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]

VIEW: APPS.IGS_AD_TEST_SCORES_V

Object Details

Object Name:	IGS_AD_TEST_SCORES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_TEST_SCORES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view gives the detailed description for the test scores for the Students.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID
TEST_RESULTS_ID	NUMBER	(15)	Yes	Test Result Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
TEST_TYPE	VARCHAR2	(30)	Yes	Test Type.
TEST_DATE	DATE		Yes	Date of the test.
SCORE_SOURCE	VARCHAR2	(10)		Source from where the Test Score is obtained.
SCORE_TYPE	VARCHAR2	(30)		Type of test score.
TEST_SEGMENT	VARCHAR2	(30)		Segments of the test.
SEGMENT_SCORE	NUMBER			Score in the segment.
COMBINED_SCORE	NUMBER			Total score of all the segments.
ACTIVE_IND	VARCHAR2	(1)		Indicator to indicate if the test type is ACTIVE or not.
CREATION_DATE	DATE		Yes	WHO column .
CREATED_BY	NUMBER	(15)	Yes	WHO column .
LAST_UPDATE_DATE	DATE		Yes	WHO column .
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column .
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column .
SCORE_TYPE_MEANING	VARCHAR2	(80)		Score Type meaning
SEGMENT_TYPE	VARCHAR2	(10)		Defines the segment type of the test segment. It can have values 'SCORE' and 'SUB SCORE'.
SEGMENT_GROUP	NUMBER	(3)		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 ROW_ID
,      TEST_RESULTS_ID
,      PERSON_ID
,      TEST_TYPE
,      TEST_DATE
,      SCORE_SOURCE
,      SCORE_TYPE
,      TEST_SEGMENT
,      SEGMENT_SCORE
,      COMBINED_SCORE
,      ACTIVE_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SCORE_TYPE_MEANING
,      SEGMENT_TYPE
,      SEGMENT_GROUP
FROM APPS.IGS_AD_TEST_SCORES_V;

Dependencies

[top of page]

APPS.IGS_AD_TEST_SCORES_V references the following:

APPS: IGS_AD_CODE_CLASSES; IGS_AD_TEST_RESULTS; IGS_AD_TEST_SEGMENTS; IGS_AD_TST_RSLT_DTLS; IGS_LOOKUP_VALUES

APPS.IGS_AD_TEST_SCORES_V is referenced by following:

APPS: IGR_PER_INFO_001 - show dependent code