[Home] [Help]
View: IGS_AD_CAL_CONF_PERDADM_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | View of adm_perd_admission_cat and date aliases from dt_alias_instance. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT APAC.ADM_CAL_TYPE
, APAC.ADM_CI_SEQUENCE_NUMBER
, APAC.ADMISSION_CAT
, DAIV.DT_ALIAS
, DAIV.ALIAS_VAL
, DA.DESCRIPTION
, SACCO.CREATED_BY
, SACCO.CREATION_DATE
, SACCO.LAST_UPDATED_BY
, SACCO.LAST_UPDATE_DATE
, SACCO.LAST_UPDATE_LOGIN
FROM IGS_AD_PERD_AD_CAT APAC
, IGS_CA_DA_INST_V DAIV
, IGS_AD_CAL_CONF SACCO
, IGS_CA_DA DA
WHERE DAIV.CAL_TYPE = APAC.ADM_CAL_TYPE
AND DAIV.CI_SEQUENCE_NUMBER = APAC.ADM_CI_SEQUENCE_NUMBER
AND SACCO.S_CONTROL_NUM = 1
AND (DAIV.DT_ALIAS = SACCO.ADM_APPL_DUE_DT_ALIAS OR DAIV.DT_ALIAS = SACCO.ADM_APPL_FINAL_DT_ALIAS OR DAIV.DT_ALIAS = SACCO.ADM_APPL_OFFER_RESP_DT_ALIAS)
AND (NOT EXISTS (SELECT 'X' FROM IGS_AD_PECRS_OFOP_DT APCOOD WHERE APCOOD.ADM_CAL_TYPE = DAIV.CAL_TYPE
AND APCOOD.ADM_CI_SEQUENCE_NUMBER = DAIV.CI_SEQUENCE_NUMBER
AND APCOOD.DT_ALIAS = DAIV.DT_ALIAS
AND APCOOD.DAI_SEQUENCE_NUMBER = DAIV.SEQUENCE_NUMBER))
AND DA.DT_ALIAS = DAIV.DT_ALIAS
Columns
| Name |
| ADM_CAL_TYPE |
| ADM_CI_SEQUENCE_NUMBER |
| ADMISSION_CAT |
| DT_ALIAS |
| ALIAS_VAL |
| DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |