[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view displays the assessment item for a unit offering. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT UAI.ROWID ROW_ID
, UAI.ORG_ID ORG_ID
, UAI.UNIT_CD UNIT_CD
, UAI.VERSION_NUMBER VERSION_NUMBER
, UAI.CAL_TYPE CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UAI.ASS_ID ASS_ID
, AI.ASSESSMENT_TYPE DSP_ASSESSMENT_TYPE
, NVL (UAI. DESCRIPTION
, AI.DESCRIPTION) ASS_ID_DESC
, UAI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, UAI.CI_START_DT CI_START_DT
, UAI.CI_END_DT CI_END_DT
, NULL UNIT_CLASS
, NULL DSP_UNIT_MODE
, NULL UNIT_MODE
, NULL LOCATION_CD
, UAI.DUE_DT DUE_DT
, UAI.REFERENCE REFERENCE
, UAI.DFLT_ITEM_IND DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
, UAI.ACTION_DT ACTION_DT
, UAI.EXAM_CAL_TYPE EXAM_CAL_TYPE
, UAI.EXAM_CI_SEQUENCE_NUMBER EXAM_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UAI.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER GS_VERSION_NUMBER
, GRD.DESCRIPTION DSP_GRD_SCHEMA_DESC
, UAI.RELEASE_DATE RELEASE_DATE
, UAI.CREATED_BY CREATED_BY
, UAI.CREATION_DATE CREATION_DATE
, UAI.LAST_UPDATED_BY LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UAI.REQUEST_ID REQUEST_ID
, UAI.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, UAI.PROGRAM_ID PROGRAM_ID
, UAI.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UAI.UNIT_ASS_ITEM_ID
, 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_ALL UAI
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_GRD_SCHEMA GRD
, IGS_CA_INST CI
WHERE UAI.ASS_ID = AI.ASS_ID
AND UAI.GRADING_SCHEMA_CD = GRD.GRADING_SCHEMA_CD
AND UAI.GS_VERSION_NUMBER = GRD.VERSION_NUMBER
AND UAI.EXAM_CAL_TYPE = CI.CAL_TYPE(+)
AND UAI.EXAM_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)