[Home] [Help]
View: IGS_AD_TERM_UNITDTLS_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TU.ROWID ROW_ID
, TU.UNIT_DETAILS_ID
, TU.TERM_DETAILS_ID
, TU.UNIT
, TU.UNIT_DIFFICULTY
, CC1.NAME UNIT_DIFFICULTY_DESC
, TU.UNIT_NAME
, TU.CP_ATTEMPTED
, TU.CP_EARNED
, TU.GRADE
, TU.UNIT_GRADE_POINTS
, TU.CREATED_BY
, TU.CREATION_DATE
, TU.LAST_UPDATED_BY
, TU.LAST_UPDATE_DATE
, TU.LAST_UPDATE_LOGIN
, TU. DEG_AUD_DETAIL_ID FROM IGS_AD_TERM_UNITDTLS TU
, IGS_AD_CODE_CLASSES CC1
WHERE CC1.CODE_ID = TU.UNIT_DIFFICULTY (+)
Columns
Name |
ROW_ID |
UNIT_DETAILS_ID |
TERM_DETAILS_ID |
UNIT |
UNIT_DIFFICULTY |
UNIT_DIFFICULTY_DESC |
UNIT_NAME |
CP_ATTEMPTED |
CP_EARNED |
GRADE |
UNIT_GRADE_POINTS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
DEG_AUD_DETAIL_ID |