[Home] [Help]
View: IGS_CA_DA_INST_ALIAS_VAL_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view is used to provide derived, absolute and effective dates for the date alias instance. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DT_ALIAS
, SEQUENCE_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ABSOLUTE_VAL
, IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(CI_SEQUENCE_NUMBER
, CAL_TYPE
, DT_ALIAS
, SEQUENCE_NUMBER) DERIVED_VAL
, IGS_CA_GEN_001.CALP_SET_ALIAS_VALUE(ABSOLUTE_VAL
, IGS_CA_GEN_002.CALS_CLC_DT_FROM_DAI(CI_SEQUENCE_NUMBER
, CAL_TYPE
, DT_ALIAS
, SEQUENCE_NUMBER)) ALIAS_VAL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_CA_DA_INST
Columns
| Name |
| DT_ALIAS |
| SEQUENCE_NUMBER |
| CAL_TYPE |
| CI_SEQUENCE_NUMBER |
| ABSOLUTE_VAL |
| DERIVED_VAL |
| ALIAS_VAL |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |