Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UGS.ROWID ROW_ID
, UGS.UNIT_SECTION_GRADING_SCHEMA_ID UNIT_SECTION_GRADING_SCHEMA_ID
, UGS.UOO_ID UOO_ID
, UGS.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, GS.DESCRIPTION GRADING_SCHEMA_DESCRIPTION
, GS.START_DT START_DT
, GS.END_DT END_DT
, UGS.GRD_SCHM_VERSION_NUMBER GRD_SCHM_VERSION_NUMBER
, UGS.DEFAULT_FLAG DEFAULT_FLAG
, 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_USEC_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