[Home] [Help] [Dependency Information]
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 |
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.
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. |
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;
|
|
|