[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes the Enrollment Category Eligibility Validation Extension |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CPDE.ROW_ID
, CPDE.IGS_EN_CPD_EXT_ID
, CPDE.ENROLMENT_CAT
, CPDE.ENR_METHOD_TYPE
, CPDE.S_STUDENT_COMM_TYPE
, CPDE.STEP_ORDER_NUM
, CPDE.S_ENROLMENT_STEP_TYPE
, LKUPS.MEANING
, LKUPS.STEP_GROUP_TYPE
, LKUPS.STEP_ORDER_APPLICABLE_IND
, CPDE.NOTIFICATION_FLAG
, CPDE.S_RULE_CALL_CD
, CPDE.RUL_SEQUENCE_NUMBER
, SRC.RUD_SEQUENCE_NUMBER
, SRC.SELECT_GROUP
, RUD.S_RETURN_TYPE
, RUD.RULE_DESCRIPTION
, IGS_RU_GEN_003.RULP_GET_RULE(CPDE.RUL_SEQUENCE_NUMBER)
, DECODE(LKUPS.STEP_ORDER_APPLICABLE_IND
, 'Y'
, DECODE(NVL(CPDE.RUL_SEQUENCE_NUMBER
, 0)
, 0
, 'UNDEFINED'
, 'DEFINED')
, NULL )
, CPDE.STUD_AUDIT_LIM
, CPDE.CREATED_BY
, CPDE.CREATION_DATE
, CPDE.LAST_UPDATED_BY
, CPDE.LAST_UPDATE_DATE
, CPDE.LAST_UPDATE_LOGIN
FROM IGS_RU_DESCRIPTION RUD
, IGS_RU_CALL SRC
, IGS_EN_CPD_EXT CPDE
, IGS_LOOKUPS_VIEW LKUPS
WHERE CPDE.S_RULE_CALL_CD = SRC.S_RULE_CALL_CD(+)
AND SRC.S_RULE_TYPE_CD(+) = 'ELGBL'
AND RUD.SEQUENCE_NUMBER(+) = SRC.RUD_SEQUENCE_NUMBER
AND LKUPS.LOOKUP_CODE = CPDE.S_ENROLMENT_STEP_TYPE
AND LKUPS.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'