Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT COND.ROWID ROW_ID
, COND.CONDITION_CATEGORY CONDITION_CATEGORY
, COND.CONDITION_NAME CONDITION_NAME
, COND.CONDITION_LINE CONDITION_LINE
, COND.ABBREVIATION ABBREVIATION
, (SELECT ABBREV_TEXT
FROM IGS_UC_REF_OFF_ABRV
WHERE ABBREV_CODE = COND.ABBREVIATION) ABBREV_DESC
, COND.GRADE_MARK GRADE_MARK
, COND.POINTS POINTS
, COND.SUBJECT SUBJECT
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE = 'SB'
AND CODE = COND.SUBJECT) SUBJECT_DESC
, COND.CONDITION_TEXT CONDITION_TEXT
, COND.CREATED_BY CREATED_BY
, COND.CREATION_DATE CREATION_DATE
, COND.LAST_UPDATED_BY LAST_UPDATED_BY
, COND.LAST_UPDATE_DATE LAST_UPDATE_DATE
, COND.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_UC_COND_DETAILS COND