Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is the full view for the entity Calendar Period Event, describes an instance of a date alias in a calendar instance. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DA.DT_ALIAS
, DA.SEQUENCE_NUMBER
, DA.CAL_TYPE
, DA.CI_SEQUENCE_NUMBER
, DA.ABSOLUTE_VAL
, IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(DA.CI_SEQUENCE_NUMBER
, DA.CAL_TYPE
, DA.DT_ALIAS
, DA.SEQUENCE_NUMBER)
, IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE(DA.ABSOLUTE_VAL
, IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(DA.CI_SEQUENCE_NUMBER
, DA.CAL_TYPE
, DA.DT_ALIAS
, DA.SEQUENCE_NUMBER))
, DA1.DESCRIPTION
, IN2.START_DT
, IN2.END_DT
, IN2.ALTERNATE_CODE
, DA.CREATED_BY
, DA.CREATION_DATE
, DA.LAST_UPDATED_BY
, DA.LAST_UPDATE_DATE
FROM IGS_CA_DA_INST DA
, IGS_CA_DA DA1
, IGS_CA_INST_ALL IN2
WHERE DA.DT_ALIAS = DA1.DT_ALIAS
AND DA.CAL_TYPE = IN2.CAL_TYPE
AND DA.CI_SEQUENCE_NUMBER = IN2.SEQUENCE_NUMBER WITH READ ONLY