Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Student Unit Attempt Assessment Item Group |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, SUAG.COURSE_CD
, CRV.TITLE
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UV.TITLE
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO.UNIT_CLASS
, UC.DESCRIPTION
, SUAG.GROUP_NAME
, '_LA:SUAG.MIDTERM_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING'
, SUAG.MIDTERM_FORMULA_QTY
, SUAG.MIDTERM_WEIGHT_QTY
, '_LA:SUAG.FINAL_FORMULA_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_FORMULA_OPTIONS:MEANING'
, SUAG.FINAL_FORMULA_QTY
, SUAG.FINAL_WEIGHT_QTY
, UAIG.GROUP_NAME
, USAG.GROUP_NAME
, SUAG.UNIT_ASS_ITEM_GROUP_ID
, SUAG.PERSON_ID
, SUAG.UOO_ID
, SUAG.UNIT_ASS_ITEM_GROUP_ID
, SUAG.US_ASS_ITEM_GROUP_ID
, SUAG.CREATED_BY
, SUAG.CREATION_DATE
, SUAG.LAST_UPDATED_BY
, SUAG.LAST_UPDATE_DATE
FROM IGS_AS_SUA_AI_GROUP SUAG
, HZ_PARTIES HP
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL CRV
, IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CI
, IGS_AD_LOCATION_ALL LOC
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_AS_UNIT_AI_GRP UAIG
, IGS_AS_US_AI_GROUP USAG
WHERE SUAG.PERSON_ID = HP.PARTY_ID
AND SUAG.PERSON_ID = SCA.PERSON_ID
AND SUAG.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUAG.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND SUAG.UNIT_ASS_ITEM_GROUP_ID = UAIG.UNIT_ASS_ITEM_GROUP_ID
AND SUAG.US_ASS_ITEM_GROUP_ID = USAG.US_ASS_ITEM_GROUP_ID WITH READ ONLY