[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This entity describes a student's attempt at studying a particular course offered by the university. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT 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
, 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.PRIMARY_PROGRAM_TYPE
, SCA.PRIMARY_PROG_TYPE_SOURCE
, SCA.CATALOG_CAL_TYPE
, SCA.CATALOG_SEQ_NUM
, SCA.KEY_PROGRAM
, SCA.OVERRIDE_CMPL_DT
, SCA.MANUAL_OVR_CMPL_DT_IND
, HP.PARTY_NUMBER
, PSV.TITLE
, CA.DESCRIPTION
, LOC1.DESCRIPTION
, AM1.DESCRIPTION
, ATT1.DESCRIPTION
, AM2.DESCRIPTION
, ATT2.DESCRIPTION
, CC.DESCRIPTION
, CI.DESCRIPTION
, DR.DESCRIPTION
, ENCP.DESCRIPTION
, FC.DESCRIPTION
, FS.DESCRIPTION
, LOC2.DESCRIPTION
, PCS.CLASS_STANDING
, '_LA:COURSE_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:CRS_ATTEMPT_STATUS:MEANING'
, '_LA:PROGRESSION_STATUS:IGS_LOOKUP_VALUES:PROGRESSION_STATUS:MEANING'
, '_LA:PRIMARY_PROG_TYPE_SOURCE:IGS_LOOKUP_VALUES:IGS_EN_PP_SOURCE:MEANING'
, '_DF:IGS:IGS_EN_STDNT_ATT_FLEX:SCA'
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.FUTURE_DATED_TRANS_FLAG
FROM IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_PS_VER_ALL PSV
, IGS_CA_TYPE CA
, IGS_AD_LOCATION_ALL LOC1
, IGS_EN_ATD_MODE_ALL AM1
, IGS_EN_ATD_TYPE_ALL ATT1
, IGS_EN_ATD_MODE_ALL AM2
, IGS_EN_ATD_TYPE_ALL ATT2
, IGS_CO_CAT CC
, IGS_CA_INST_ALL CI
, IGS_EN_DCNT_REASONCD_ALL DR
, IGS_EN_NOM_CMPL_PRD ENCP
, IGS_FI_FEE_CAT_ALL FC
, IGS_FI_FUND_SRC_ALL FS
, IGS_AD_LOCATION_ALL LOC2
, IGS_PR_CLASS_STD PCS
WHERE SCA.PERSON_ID = HP.PARTY_ID
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SCA.CAL_TYPE = CA.CAL_TYPE
AND SCA.LOCATION_CD = LOC1.LOCATION_CD
AND SCA.ATTENDANCE_MODE = AM1.ATTENDANCE_MODE
AND SCA.ATTENDANCE_TYPE = ATT1.ATTENDANCE_TYPE
AND SCA.DERIVED_ATT_MODE = AM2.ATTENDANCE_MODE (+)
AND SCA.DERIVED_ATT_TYPE = ATT2.ATTENDANCE_TYPE (+)
AND SCA.CORRESPONDENCE_CAT = CC.CORRESPONDENCE_CAT (+)
AND SCA.CATALOG_CAL_TYPE = CI.CAL_TYPE (+)
AND SCA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER (+)
AND SCA.DISCONTINUATION_REASON_CD = DR.DISCONTINUATION_REASON_CD (+)
AND SCA.NOMINATED_COMPLETION_PERD = ENCP.COMPLETION_PERD (+)
AND SCA.FEE_CAT = FC.FEE_CAT (+)
AND SCA.FUNDING_SOURCE = FS.FUNDING_SOURCE (+)
AND SCA.EXAM_LOCATION_CD = LOC2.LOCATION_CD (+)
AND SCA.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID (+) WITH READ ONLY