Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UGS.ROWID ROW_ID
, UGS.UNIT_GRADING_SCHEMA_ID UNIT_GRADING_SCHEMA_ID
, UGS.UNIT_CODE UNIT_CODE
, UGS.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, UGS.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, UGS.GRD_SCHM_VERSION_NUMBER GRD_SCHM_VERSION_NUMBER
, UGS.DEFAULT_FLAG DEFAULT_FLAG
, GS.DESCRIPTION GRD_SCHM_DESCRIPTION
, UGS.CREATED_BY CREATED_BY
, UGS.CREATION_DATE CREATION_DATE
, UGS.LAST_UPDATED_BY LAST_UPDATED_BY
, UGS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UGS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_GRD_SCHM UGS
, IGS_AS_GRD_SCHEMA GS
WHERE UGS.GRADING_SCHEMA_CODE = GS.GRADING_SCHEMA_CD
AND UGS.GRD_SCHM_VERSION_NUMBER = GS.VERSION_NUMBER