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

TABLE: IGS.IGS_UC_EXAM_SCORES

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


Holds records that links to exam level values in IGS_UC_REF_CODES and holds grades/points against exam levels.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_EXAM_SCORES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXAM_SCORES_ID
IGS_UC_EXAM_SCORES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXAM_LEVEL
ColumnREF_CODE_TYPE
Columns
Name Datatype Length Mandatory Comments
EXAM_SCORES_ID NUMBER
Yes Unique Record Identifier
REF_CODE_TYPE VARCHAR2 (2) Yes Always 'EL' to link to column - IGS_UC_REF_CODES.code_type
EXAM_LEVEL VARCHAR2 (6) Yes Examination level.Links to column - IGS_UC_REF_CODES.CODE.
POINTS VARCHAR2 (2)
Point score
GRADES VARCHAR2 (2)
Grade score
CREATED_BY NUMBER (15) Yes Standard WHO columns
CREATION_DATE DATE
Yes Standard WHO columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO columns
LAST_UPDATE_DATE DATE
Yes Standard WHO columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns
Query Text

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


SELECT EXAM_SCORES_ID
,      REF_CODE_TYPE
,      EXAM_LEVEL
,      POINTS
,      GRADES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_EXAM_SCORES;

Dependencies

[top of page]

IGS.IGS_UC_EXAM_SCORES does not reference any database object

IGS.IGS_UC_EXAM_SCORES is referenced by following:

SchemaAPPS
SynonymIGS_UC_EXAM_SCORES