Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Created primarily for the assignment due dates summary report |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, UC.UNIT_MODE
, UOO.UOO_ID
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.REFERENCE
, IGS_GE_GEN_001.GENP_CLC_WEEK_END_DT(UAI.DUE_DT)
, UAI.DUE_DT
, UAI.LOGICAL_DELETE_DT
, ATYP.ASSESSMENT_TYPE
, ATYP.S_ASSESSMENT_TYPE
, ATYP.EXAMINABLE_IND
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN
, UAI.UNIT_ASS_ITEM_GROUP_ID
, UAI.MIDTERM_MANDATORY_TYPE_CODE
, UAI.MIDTERM_WEIGHT_QTY
, UAI.FINAL_MANDATORY_TYPE_CODE
, UAI.FINAL_WEIGHT_QTY
FROM IGS_AS_UNITASS_ITEM UAI
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_AS_UNIT_CLASS UC
, IGS_AS_ASSESSMNT_ITM AI
, IGS_AS_ASSESSMNT_TYP ATYP
WHERE UOO.UNIT_CD = UAI.UNIT_CD
AND UOO.VERSION_NUMBER = UAI.VERSION_NUMBER
AND UOO.CAL_TYPE = UAI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = UAI.CI_SEQUENCE_NUMBER
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UAI.ASS_ID = AI.ASS_ID
AND AI.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE