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

VIEW: APPS.IGS_DA_XML_EXAMINATION_V

Object Details
Object Name: IGS_DA_XML_EXAMINATION_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_DA_XML_EXAMINATION_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


XML element ExaminationProvides Student"s basic examination information test type, dates, scores. All Examination information can be excluded with ETS feature value set to Y.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TEST_TYPE VARCHAR2 (30) Yes Contains the test name
TEST_DATE VARCHAR2 (10)
Contains the date that the test was taken
TEST_COMPOSITE_SCORE NUMBER

Contains the sum of all the test segment scores.
BATCH_ID NUMBER
Yes Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID NUMBER (15) Yes Describes the details of the person ID code that is being passed.
TEST_RESULTS_ID NUMBER (15) Yes Test result
Query Text

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


SELECT TEST_TYPE
,      TEST_DATE
,      TEST_COMPOSITE_SCORE
,      BATCH_ID
,      PERSON_ID
,      TEST_RESULTS_ID
FROM APPS.IGS_DA_XML_EXAMINATION_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_EXAMINATION_V references the following:

SchemaAPPS
ViewIGS_AD_TEST_RESULTS_V
SynonymIGS_DA_REQ_FTRS
SynonymIGS_DA_RQST

APPS.IGS_DA_XML_EXAMINATION_V is not referenced by any database object