[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_GRD_SCH_TRN_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_GRD_SCH_TRN_ALL |
Subobject Name: | |
Status: | VALID |
IGS_AS_GRD_SCH_TRN_ALL contains information required to translate grade from one schema to another.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_GRD_SCH_TRN_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GRADING_SCHEMA_CD
VERSION_NUMBER GRADE TO_GRADING_SCHEMA_CD TO_VERSION_NUMBER TO_GRADE |
IGS_AS_GRD_SCH_TRN_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TO_GRADING_SCHEMA_CD
TO_VERSION_NUMBER TO_GRADE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | The code that identifies the 'from' grading schema when performing a grading schema translation. A grading schema describes the set of available marks and grades which can be used in the assessment of student unit attempts. There may be multiple grading schemas for any one institution. |
VERSION_NUMBER | NUMBER | (3) | Yes | A system generated number used to identify the version of the 'from' grading schema when performing a translation. |
GRADE | VARCHAR2 | (5) | Yes | A code representing the grade from one schema which is translated or mapped to grade in another schema the to schema. |
TO_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | The code that identifies the to grading schema. A grading schema describes the set of available marks and grades which can be used in the assessment of student unit attempts. An institution may have multiple grading schema. |
TO_VERSION_NUMBER | NUMBER | (3) | Yes | A system generated number used to identify the version of the 'to' grading schema when performing a translation. |
TO_GRADE | VARCHAR2 | (5) | Yes | A code representing the grade in one schema, to which the grade in another schema the from schema is translated or mapped. |
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT GRADING_SCHEMA_CD
, VERSION_NUMBER
, GRADE
, TO_GRADING_SCHEMA_CD
, TO_VERSION_NUMBER
, TO_GRADE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_AS_GRD_SCH_TRN_ALL;
IGS.IGS_AS_GRD_SCH_TRN_ALL does not reference any database object
IGS.IGS_AS_GRD_SCH_TRN_ALL is referenced by following:
|
|
|