Product: | IGS - Student System (Obsolete) |
---|---|
Description: | No longer used |
Implementation/DBA Data: | Not implemented in this database |
SELECT SEH.PERSON_ID
, SEH.COURSE_CD
, SEH.EFFECTIVE_START_DT
, SEH.EFFECTIVE_END_DT
, SEH.VERSION_NUMBER
, SEH.CAL_TYPE
, SEH.LOCATION_CD
, SEH.ATTENDANCE_MODE
, SEH.ATTENDANCE_TYPE
, SEH.STUDENT_CONFIRMED_IND
, SEH.COMMENCEMENT_DT
, SEH.COURSE_ATTEMPT_STATUS
, SEH.DERIVED_ATT_TYPE
, SEH.DERIVED_ATT_MODE
, SEH.PROVISIONAL_IND
, SEH.DISCONTINUED_DT
, SEH.DISCONTINUATION_REASON_CD
, SEH.FUNDING_SOURCE
, SEH.EXAM_LOCATION_CD
, SEH.DERIVED_COMPLETION_YR
, SEH.DERIVED_COMPLETION_PERD
, SEH.NOMINATED_COMPLETION_YR
, SEH.NOMINATED_COMPLETION_PERD
, SEH.RULE_CHECK_IND
, SEH.WAIVE_OPTION_CHECK_IND
, SEH.LAST_RULE_CHECK_DT
, SEH.PUBLISH_OUTCOMES_IND
, SEH.COURSE_RQRMNT_COMPLETE_IND
, SEH.OVERRIDE_TIME_LIMITATION
, SEH.ADVANCED_STANDING_IND
, FCCR.FEE_CAT
, SEH.CORRESPONDENCE_CAT
, SEH.SELF_HELP_GROUP_IND
, SEH.CREATED_BY
, SEH.CREATION_DATE
, SEH.LAST_UPDATED_BY
, SEH.LAST_UPDATE_DATE
, SEH.LAST_UPDATE_LOGIN
, FCCR.FEE_CAL_TYPE
, FCCR.FEE_CI_SEQUENCE_NUMBER
FROM IGS_AS_SCAH_EFFECTIVE_H_V SEH
, IGS_FI_F_CAT_CAL_REL FCCR
WHERE FCCR.PERSON_ID = SEH.PERSON_ID
AND FCCR.COURSE_CD = SEH.COURSE_CD
AND FCCR.VERSION_NUMBER = SEH.VERSION_NUMBER