Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Shows the mappings between the UCAS decision codes and oss outcome status codes along with the descriptions |
Implementation/DBA Data: | Not implemented in this database |
SELECT MOU.ROWID ROW_ID
, MOU.SYSTEM_CODE SYSTEM_CODE
, MOU.DECISION_CODE DECISION_CODE
, LK1.MEANING DECISION_DESC
, OU.S_ADM_OUTCOME_STATUS SYSTEM_OUTCOME_STATUS
, LK2.MEANING SYS_OUTCOME_STATUS_DESC
, MOU.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS
, OU.DESCRIPTION ADM_OUTCOME_STATUS_DESC
, MOU.DEFAULT_IND DEFAULT_IND
, MOU.CLOSED_IND CLOSED_IND
, MOU.CREATED_BY
, MOU.CREATION_DATE
, MOU.LAST_UPDATED_BY
, MOU.LAST_UPDATE_DATE
, MOU.LAST_UPDATE_LOGIN
FROM IGS_UC_MAP_OUT_STAT MOU
, IGS_LOOKUPS_VIEW LK1
, IGS_AD_OU_STAT OU
, IGS_LOOKUPS_VIEW LK2
WHERE LK1.LOOKUP_TYPE = 'IGS_UC_APP_DECISION'
AND LK1.LOOKUP_CODE= MOU.DECISION_CODE
AND LK1.CLOSED_IND ='N'
AND OU.ADM_OUTCOME_STATUS = MOU.ADM_OUTCOME_STATUS
AND OU.CLOSED_IND ='N'
AND LK2.LOOKUP_TYPE = 'ADM_OUTCOME_STATUS'
AND LK2.LOOKUP_CODE = OU.S_ADM_OUTCOME_STATUS
AND LK2.CLOSED_IND = 'N'