[Home] [Help]
View: IGS_AS_UAI_EXAMINATION_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Describes all examinations that are required within the examination calendar instance, they are to be examined. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT UECV.EXAM_CAL_TYPE
, UECV.EXAM_CI_SEQUENCE_NUMBER
, UECV.CAL_TYPE
, UECV.CI_SEQUENCE_NUMBER
, UECV.ASS_ID
, UECV.UNIT_CD
, UECV.REFERENCE
, AI.EXAM_PAPER_NAME
, UV.OWNER_ORG_UNIT_CD
, AI.EXAM_WORKING_TIME
, IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UECV.ASS_ID
, SUA.UOO_ID)
, SUA.DEG_AUD_DETAIL_ID
FROM IGS_AS_UAI_EXAM_CI_V UECV
, IGS_CA_INST TCI
, IGS_CA_STAT TCS
, IGS_AS_ASSESSMNT_ITM AI
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_STAT US
, IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_EN_SU_ATTEMPT SUA
, IGS_AS_UNIT_CLASS UCL
WHERE TCI.CAL_TYPE = UECV.CAL_TYPE
AND TCI.SEQUENCE_NUMBER = UECV.CI_SEQUENCE_NUMBER
AND TCS.CAL_STATUS = TCI.CAL_STATUS
AND TCS.S_CAL_STATUS = 'ACTIVE'
AND AI.ASS_ID = UECV.ASS_ID
AND UV.UNIT_CD = UECV.UNIT_CD
AND UV.VERSION_NUMBER = UECV.VERSION_NUMBER
AND US.UNIT_STATUS = UV.UNIT_STATUS
AND US.S_UNIT_STATUS = 'ACTIVE'
AND SUAAI.ASS_ID = UECV.ASS_ID
AND SUAAI.UNIT_CD = UECV.UNIT_CD
AND SUAAI.CAL_TYPE = UECV.CAL_TYPE
AND SUAAI.CI_SEQUENCE_NUMBER = UECV.CI_SEQUENCE_NUMBER
AND SUAAI.LOGICAL_DELETE_DT IS NULL
AND SUA.PERSON_ID = SUAAI.PERSON_ID
AND SUA.COURSE_CD = SUAAI.COURSE_CD
AND SUA.UOO_ID = SUAAI.UOO_ID
AND SUA.UNIT_ATTEMPT_STATUS = 'ENROLLED'
AND SUA.NO_ASSESSMENT_IND = 'N'
AND UCL.UNIT_CLASS = SUA.UNIT_CLASS
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI(SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UCL.UNIT_MODE
, UECV.LOCATION_CD
, UECV.UNIT_CLASS
, UECV.UNIT_MODE) = 'TRUE'
Columns
| Name |
| EXAM_CAL_TYPE |
| EXAM_CI_SEQUENCE_NUMBER |
| TEACH_CAL_TYPE |
| TEACH_CI_SEQUENCE_NUMBER |
| ASS_ID |
| UNIT_CD |
| REFERENCE |
| EXAM_PAPER_NAME |
| OWNER_ORG_UNIT_CD |
| EXAM_WORKING_TIME |
| EXAM_LOCATION_CD |
| DEG_AUD_DETAIL_ID |