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.

[Home] [Help]

View: IGSBV_AS_GRD_SCH_TRANSLATIONS

Product:	IGS - Student System (Obsolete)
Description:	Grading Schema Translations
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT GSGT.GRADING_SCHEMA_CD
, GSGT.VERSION_NUMBER
, GS1.DESCRIPTION
, GSGT.GRADE
, GSG1.FULL_GRADE_NAME
, GSGT.TO_GRADING_SCHEMA_CD
, GSGT.TO_VERSION_NUMBER
, GS2.DESCRIPTION
, GSGT.TO_GRADE
, GSG2.FULL_GRADE_NAME
, GSGT.CREATED_BY
, GSGT.CREATION_DATE
, GSGT.LAST_UPDATED_BY
, GSGT.LAST_UPDATE_DATE
FROM IGS_AS_GRD_SCH_TRN_ALL GSGT
, IGS_AS_GRD_SCHEMA GS1
, IGS_AS_GRD_SCH_GRADE GSG1
, IGS_AS_GRD_SCHEMA GS2
, IGS_AS_GRD_SCH_GRADE GSG2
WHERE GSGT.GRADING_SCHEMA_CD = GSG1.GRADING_SCHEMA_CD
AND GSGT.VERSION_NUMBER = GSG1.VERSION_NUMBER
AND GSGT.GRADE = GSG1.GRADE
AND GSG1.GRADING_SCHEMA_CD = GS1.GRADING_SCHEMA_CD
AND GSG1.VERSION_NUMBER = GS1.VERSION_NUMBER
AND GSGT.TO_GRADING_SCHEMA_CD = GSG2.GRADING_SCHEMA_CD
AND GSGT.TO_VERSION_NUMBER = GSG2.VERSION_NUMBER
AND GSGT.TO_GRADE = GSG2.GRADE
AND GSG2.GRADING_SCHEMA_CD = GS2.GRADING_SCHEMA_CD
AND GSG2.VERSION_NUMBER = GS2.VERSION_NUMBER WITH READ ONLY

Columns

Name
GRADING_SCHEMA_CODE
GS_VERSION_NUMBER
GS_DESCRIPTION
GRADE
FULL_GRADE_NAME
TO_GRADING_SCHEMA_CODE
TO_GS_VERSION_NUMBER
TO_GS_DESCRIPTION
TO_GRADE
TO_FULL_GRADE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE