Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes the grading schema code grades applicable to an administrative unit status. This caters for versions of the grading schema code. At any point in time, there should be only one grading schema code grade applicable. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AUSG.ROWID ROW_ID
, AUSG.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUSG.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, AUSG.VERSION_NUMBER VERSION_NUMBER
, AUSG.GRADE GRADE
, GS.START_DT START_DT
, GS.END_DT END_DT
, GSG.FULL_GRADE_NAME FULL_GRADE_NAME
, GSG.S_RESULT_TYPE S_RESULT_TYPE
, LKUPS.MEANING MEANING
, AUSG.CREATED_BY CREATED_BY
, AUSG.CREATION_DATE CREATION_DATE
, AUSG.LAST_UPDATED_BY LAST_UPDATED_BY
, AUSG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AUSG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_ADM_UT_STA_GD AUSG
, IGS_LOOKUPS_VIEW LKUPS
, IGS_AS_GRD_SCH_GRADE GSG
, IGS_AS_GRD_SCHEMA GS
WHERE LKUPS.LOOKUP_TYPE = 'RESULT_TYPE' AND LKUPS.LOOKUP_CODE = GSG.S_RESULT_TYPE AND GSG.GRADING_SCHEMA_CD = AUSG.GRADING_SCHEMA_CD AND (GSG.VERSION_NUMBER = AUSG.VERSION_NUMBER OR (GSG.VERSION_NUMBER IS NULL
AND AUSG.VERSION_NUMBER IS NULL )) AND (GSG.GRADE = AUSG.GRADE OR (GSG.GRADE IS NULL
AND AUSG.GRADE IS NULL )) AND GS.GRADING_SCHEMA_CD = GSG.GRADING_SCHEMA_CD AND GS.VERSION_NUMBER = GSG.VERSION_NUMBER