View: IGS_AS_SC_ATTEMPT_H

View Text

SELECT TAB.ROWID ROW_ID
, TAB.PERSON_ID PERSON_ID
, TAB.COURSE_CD COURSE_CD
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.CAL_TYPE CAL_TYPE
, TAB.LOCATION_CD LOCATION_CD
, TAB.ATTENDANCE_MODE ATTENDANCE_MODE
, TAB.ATTENDANCE_TYPE ATTENDANCE_TYPE
, TAB.STUDENT_CONFIRMED_IND STUDENT_CONFIRMED_IND
, TAB.COMMENCEMENT_DT COMMENCEMENT_DT
, TAB.COURSE_ATTEMPT_STATUS COURSE_ATTEMPT_STATUS
, TAB.PROGRESSION_STATUS PROGRESSION_STATUS
, TAB.DERIVED_ATT_TYPE DERIVED_ATT_TYPE
, TAB.DERIVED_ATT_MODE DERIVED_ATT_MODE
, TAB.PROVISIONAL_IND PROVISIONAL_IND
, TAB.DISCONTINUED_DT DISCONTINUED_DT
, TAB.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, TAB.LAPSED_DT LAPSED_DT
, TAB.FUNDING_SOURCE FUNDING_SOURCE
, TAB.FS_DESCRIPTION FS_DESCRIPTION
, TAB.EXAM_LOCATION_CD EXAM_LOCATION_CD
, TAB.ELO_DESCRIPTION ELO_DESCRIPTION
, TAB.DERIVED_COMPLETION_YR DERIVED_COMPLETION_YR
, TAB.DERIVED_COMPLETION_PERD DERIVED_COMPLETION_PERD
, TAB.NOMINATED_COMPLETION_YR NOMINATED_COMPLETION_YR
, TAB.NOMINATED_COMPLETION_PERD NOMINATED_COMPLETION_PERD
, TAB.RULE_CHECK_IND RULE_CHECK_IND
, TAB.WAIVE_OPTION_CHECK_IND WAIVE_OPTION_CHECK_IND
, TAB.LAST_RULE_CHECK_DT LAST_RULE_CHECK_DT
, TAB.PUBLISH_OUTCOMES_IND PUBLISH_OUTCOMES_IND
, TAB.COURSE_RQRMNT_COMPLETE_IND COURSE_RQRMNT_COMPLETE_IND
, TAB.COURSE_RQRMNTS_COMPLETE_DT COURSE_RQRMNTS_COMPLETE_DT
, TAB.S_COMPLETED_SOURCE_TYPE S_COMPLETED_SOURCE_TYPE
, TAB.OVERRIDE_TIME_LIMITATION OVERRIDE_TIME_LIMITATION
, TAB.ADVANCED_STANDING_IND ADVANCED_STANDING_IND
, TAB.FEE_CAT FEE_CAT
, TAB.FC_DESCRIPTION FC_DESCRIPTION
, TAB.CORRESPONDENCE_CAT CORRESPONDENCE_CAT
, TAB.CC_DESCRIPTION CC_DESCRIPTION
, TAB.SELF_HELP_GROUP_IND SELF_HELP_GROUP_IND
, TAB.ADM_ADMISSION_APPL_NUMBER ADM_ADMISSION_APPL_NUMBER
, TAB.ADM_NOMINATED_COURSE_CD ADM_NOMINATED_COURSE_CD
, TAB.ADM_SEQUENCE_NUMBER ADM_SEQUENCE_NUMBER
, TAB.LAST_DATE_OF_ATTENDANCE
, TAB. DROPPED_BY
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
, TAB.PRIMARY_PROGRAM_TYPE
, TAB.PRIMARY_PROG_TYPE_SOURCE
, TAB.CATALOG_CAL_TYPE
, TAB.CATALOG_SEQ_NUM
, TAB.KEY_PROGRAM
, TAB.MANUAL_OVR_CMPL_DT_IND
, TAB.OVERRIDE_CMPL_DT
, TAB.COO_ID
, TAB.IGS_PR_CLASS_STD_ID
FROM IGS_AS_SC_ATTEMPT_H_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns