[Home] [Help]
View: IGSFV_CAL_PRD_EVNT_TYPE_PAIRS
Product: | IGS - Student System (Obsolete) |
Description: | This is the full view for the entity Calendar Period Event Type Pairs which describes combination of date aliases into pairs. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DA.DT_ALIAS
, DA.RELATED_DT_ALIAS
, DA1.DESCRIPTION
, DA2.DESCRIPTION
, DA.CREATED_BY
, DA.CREATION_DATE
, DA.LAST_UPDATED_BY
, DA.LAST_UPDATE_DATE
FROM IGS_CA_DA_PAIR DA
, IGS_CA_DA DA1
, IGS_CA_DA DA2
WHERE DA.DT_ALIAS = DA1.DT_ALIAS
AND DA.RELATED_DT_ALIAS = DA2.DT_ALIAS WITH READ ONLY
Columns
Name |
DATE_ALIAS |
RELATED_DATE_ALIAS |
DATE_ALIAS_DESCRIPTION |
RELATED_DATE_ALIAS_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |