Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view would be used in the form. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SCA.ROW_ID
, SCA.ORG_ID
, SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, SCA.COO_ID
, SCA.STUDENT_CONFIRMED_IND
, SCA.COMMENCEMENT_DT
, SCA.COURSE_ATTEMPT_STATUS
, LKUPV1.MEANING CAS_MEANING
, SCA.PROGRESSION_STATUS
, SCA.DERIVED_ATT_TYPE
, SCA.DERIVED_ATT_MODE
, SCA.PROVISIONAL_IND
, SCA.DISCONTINUED_DT
, SCA.DISCONTINUATION_REASON_CD
, SCA.LAPSED_DT
, SCA.FUNDING_SOURCE
, SCA.EXAM_LOCATION_CD
, SCA.DERIVED_COMPLETION_YR
, SCA.DERIVED_COMPLETION_PERD
, SCA.NOMINATED_COMPLETION_YR
, SCA.NOMINATED_COMPLETION_PERD
, SCA.RULE_CHECK_IND
, SCA.WAIVE_OPTION_CHECK_IND
, SCA.LAST_RULE_CHECK_DT
, SCA.PUBLISH_OUTCOMES_IND
, SCA.COURSE_RQRMNT_COMPLETE_IND
, SCA.COURSE_RQRMNTS_COMPLETE_DT
, SCA.S_COMPLETED_SOURCE_TYPE
, SCA.OVERRIDE_TIME_LIMITATION
, SCA.ADVANCED_STANDING_IND
, SCA.FEE_CAT
, SCA.CORRESPONDENCE_CAT
, SCA.SELF_HELP_GROUP_IND
, SCA.LOGICAL_DELETE_DT
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, SCA.LAST_DATE_OF_ATTENDANCE
, SCA.DROPPED_BY
, SCA.IGS_PR_CLASS_STD_ID
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
, SCA.REQUEST_ID
, SCA.PROGRAM_APPLICATION_ID
, SCA.PROGRAM_ID
, SCA.PROGRAM_UPDATE_DATE
, SCA.PRIMARY_PROGRAM_TYPE
, SCA.PRIMARY_PROG_TYPE_SOURCE
, LKUPV2.MEANING PRM_PRG_SOURCE_MEANING
, SCA.CATALOG_CAL_TYPE
, SCA.CATALOG_SEQ_NUM
, CI.DESCRIPTION CATALOG
, PSV.COURSE_TYPE COURSE_TYPE
, PSV.TITLE
, SCA.KEY_PROGRAM
, SCA.OVERRIDE_CMPL_DT
, SCA.MANUAL_OVR_CMPL_DT_IND
, SCA.ATTRIBUTE_CATEGORY
, SCA.ATTRIBUTE1
, SCA.ATTRIBUTE2
, SCA.ATTRIBUTE3
, SCA.ATTRIBUTE4
, SCA.ATTRIBUTE5
, SCA.ATTRIBUTE6
, SCA.ATTRIBUTE7
, SCA.ATTRIBUTE8
, SCA.ATTRIBUTE9
, SCA.ATTRIBUTE10
, SCA.ATTRIBUTE11
, SCA.ATTRIBUTE12
, SCA.ATTRIBUTE13
, SCA.ATTRIBUTE14
, SCA.ATTRIBUTE15
, SCA.ATTRIBUTE16
, SCA.ATTRIBUTE17
, SCA.ATTRIBUTE18
, SCA.ATTRIBUTE19
, SCA.ATTRIBUTE20
, SCA.FUTURE_DATED_TRANS_FLAG
FROM IGS_EN_STDNT_PS_ATT_SV SCA
, IGS_CA_INST CI
, IGS_PS_VER PSV
, IGS_LOOKUP_VALUES LKUPV1
, IGS_LOOKUP_VALUES LKUPV2
WHERE SCA.CATALOG_CAL_TYPE = CI.CAL_TYPE(+)
AND SCA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER(+)
AND LKUPV1.LOOKUP_TYPE(+) = 'CRS_ATTEMPT_STATUS'
AND LKUPV1.LOOKUP_CODE(+) = SCA.COURSE_ATTEMPT_STATUS
AND LKUPV2.LOOKUP_TYPE(+) = 'IGS_EN_PP_SOURCE'
AND LKUPV2.LOOKUP_CODE(+) = SCA.PRIMARY_PROG_TYPE_SOURCE
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER