Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UPG.ROWID ROW_ID
, UPG.UNIT_PREV_GRADE_ID UNIT_PREV_GRADE_ID
, UPG.UNIT_CODE UNIT_CODE
, UPG.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, UPG.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, UPG.GRADING_SCHEMA_VERSION_NUMBER GRADING_SCHEMA_VERSION_NUMBER
, UPG.GRADING_SCHEMA_VALUE GRADING_SCHEMA_VALUE
, GSG.FULL_GRADE_NAME FULL_GRADE_NAME
, UPG.CREATED_BY CREATED_BY
, UPG.CREATION_DATE CREATION_DATE
, UPG.LAST_UPDATED_BY LAST_UPDATED_BY
, UPG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UPG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNT_PRV_GRADE UPG
, IGS_AS_GRD_SCH_GRADE GSG
WHERE UPG.GRADING_SCHEMA_CODE = GSG.GRADING_SCHEMA_CD
AND UPG.GRADING_SCHEMA_VERSION_NUMBER = GSG.VERSION_NUMBER
AND UPG.GRADING_SCHEMA_VALUE = GSG.GRADE