Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is used to capture the Enrollment Eligibility Override of system steps. |
Implementation/DBA Data: | Not implemented in this database |
SELECT EOS.ROWID ROW_ID
, EOS.ELGB_OVR_STEP_ID
, EOS.ELGB_OVERRIDE_ID
, EOS.STEP_OVERRIDE_TYPE
, LKV.MEANING
, LKV.STEP_GROUP_TYPE
, EOS.STEP_OVERRIDE_DT
, EOS. STEP_OVERRIDE_LIMIT
, EOS.CREATED_BY
, EOS.CREATION_DATE
, EOS.LAST_UPDATED_BY
, EOS.LAST_UPDATE_DATE
, EOS.LAST_UPDATE_LOGIN
FROM IGS_EN_ELGB_OVR_STEP EOS
, IGS_LOOKUPS_VIEW LKV
WHERE LKV.LOOKUP_CODE = EOS.STEP_OVERRIDE_TYPE
AND LKV.LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE'
AND LKV.CLOSED_IND ='N'