[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | The view is used to query for the Unit and Unit Section details of the Overridden Eligibility Unit Step. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT EOU.ROWID ROW_ID
, EOU.ELGB_OVR_STEP_ID ELGB_OVR_STEP_ID
, EOU.ELGB_OVR_STEP_UOO_ID ELGB_OVR_STEP_UOO_ID
, EOU.UNIT_CD UNIT_CD
, EOU.VERSION_NUMBER VERSION_NUMBER
, UV1.TITLE TITLE
, EOU.UOO_ID UOO_ID
, UOO.CAL_TYPE US_CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER US_CI_SEQUENCE_NUMBER
, CA.START_DT US_CI_START_DT
, CA.END_DT US_CI_END_DT
, CA.ALTERNATE_CODE US_ALTERNATE_CODE
, UOO.LOCATION_CD US_LOCATION_CD
, UOO.UNIT_CLASS US_UNIT_CLASS
, EOU.STEP_OVERRIDE_LIMIT STEP_OVERRIDE_LIMIT
, EOU.CREATED_BY CREATED_BY
, EOU.CREATION_DATE CREATION_DATE
, EOU.LAST_UPDATED_BY LAST_UPDATED_BY
, EOU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EOU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_ELGB_OVR_UOO EOU
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_VER UV1
, IGS_CA_INST CA
WHERE EOU.UNIT_CD = UV1.UNIT_CD
AND EOU.VERSION_NUMBER = UV1.VERSION_NUMBER
AND EOU.UOO_ID = UOO.UOO_ID (+)
AND UOO.CAL_TYPE = CA.CAL_TYPE (+)
AND UOO.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)