Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view incorporates all the reasons that are available for a student to discontinue a course or unit. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DR.ROWID ROW_ID
, DR.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, DR.DESCRIPTION DESCRIPTION
, DR.DFLT_IND DFLT_IND
, DR.CLOSED_IND CLOSED_IND
, DR.S_DISCONTINUATION_REASON_TYPE S_DISCONTINUATION_REASON_TYPE
, LKUPS.MEANING MEANING
, LKUPS.CLOSED_IND DSP_CLOSED_IND
, DR.SYS_DFLT_IND SYS_DFLT_IND
, DR.COMMENTS COMMENTS
, DR.DCNT_PROGRAM_IND DCNT_PROGRAM_IND
, DR.DCNT_UNIT_IND DCNT_UNIT_IND
, DR.CREATED_BY CREATED_BY
, DR.CREATION_DATE CREATION_DATE
, DR.LAST_UPDATED_BY LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_DCNT_REASONCD DR
, IGS_LOOKUPS_VIEW LKUPS
WHERE DR.S_DISCONTINUATION_REASON_TYPE IS NOT NULL AND LKUPS.LOOKUP_CODE = DR.S_DISCONTINUATION_REASON_TYPE
AND LKUPS.CLOSED_IND = 'N'
AND LKUPS.LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE' UNION SELECT DR.ROWID ROW_ID
, DR.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, DR.DESCRIPTION DESCRIPTION
, DR.DFLT_IND DFLT_IND
, DR.CLOSED_IND CLOSED_IND
, DR.S_DISCONTINUATION_REASON_TYPE S_DISCONTINUATION_REASON_TYPE
, TO_CHAR(NULL) MEANING
, TO_CHAR(NULL) DSP_CLOSED_IND
, DR.SYS_DFLT_IND SYS_DFLT_IND
, DR.COMMENTS COMMENTS
, DR.DCNT_PROGRAM_IND DCNT_PROGRAM_IND
, DR.DCNT_UNIT_IND DCNT_UNIT_IND
, DR.CREATED_BY CREATED_BY
, DR.CREATION_DATE CREATION_DATE
, DR.LAST_UPDATED_BY LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_EN_DCNT_REASONCD DR
WHERE DR.S_DISCONTINUATION_REASON_TYPE IS NULL