[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DRVTAB.ROWID ROW_ID
, DRVTAB.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, DRVTAB.DESCRIPTION DESCRIPTION
, DRVTAB.S_PROGRESSION_OUTCOME_TYPE S_PROGRESSION_OUTCOME_TYPE
, LKUP.MEANING MEANING
, DRVTAB.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND
, DRVTAB.CLOSED_IND CLOSED_IND
, ATTYP.DESCRIPTION ATT_TYP_DESCRIPTION
, LKUP.CLOSED_IND LOOKUP_CLOSED_IND
, DRVTAB.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
, ET.DESCRIPTION ENCUMB_DESCRIPTION
, ATTYP.CLOSED_IND ATT_TYP_CLOSED_IND
, LKUP.LOOKUP_TYPE LOOKUP_TYPE
, ET.S_ENCUMBRANCE_CAT S_ENCUMBRANCE_CAT
, ET.CLOSED_IND ENCUMB_CLOSED_IND
, DRVTAB.DFLT_RESTRICTED_ENROLMENT_CP DFLT_RESTRICTED_ENROLMENT_CP
, DRVTAB.DFLT_RESTRICTED_ATT_TYPE DFLT_RESTRICTED_ATT_TYPE
, DRVTAB.COMMENTS COMMENTS
, DRVTAB.CREATED_BY CREATED_BY
, DRVTAB.CREATION_DATE CREATION_DATE
, DRVTAB.LAST_UPDATED_BY LAST_UPDATED_BY
, DRVTAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DRVTAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PR_OU_TYPE DRVTAB
, IGS_LOOKUPS_VIEW LKUP
, IGS_EN_ATD_TYPE ATTYP
, IGS_FI_ENCMB_TYPE ET
WHERE (LKUP.LOOKUP_TYPE = 'PROGRESSION_OUTCOME_TYPE'
AND LKUP.LOOKUP_CODE = DRVTAB.S_PROGRESSION_OUTCOME_TYPE)
AND ATTYP.ATTENDANCE_TYPE(+) = DRVTAB.DFLT_RESTRICTED_ATT_TYPE
AND ET.ENCUMBRANCE_TYPE(+) = DRVTAB.ENCUMBRANCE_TYPE