Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains the seeded system date types that are used for date type configurations. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DA.SYS_DATE_TYPE
, '_LA:DA.OWNER_MODULE_CODE:IGS_LOOKUP_VALUES:IGS_MODULES:MEANING'
, DA.VALIDATION_PROC
, DA.ONE_PER_CAL_FLAG
, '_LA:DA.RES_CAL_CAT1:IGS_LOOKUP_VALUES:CAL_CAT:MEANING'
, '_LA:DA.RES_CAL_CAT2:IGS_LOOKUP_VALUES:CAL_CAT:MEANING'
, DA.DATE_ALIAS
, DA.DESCRIPTION SYSTEM_DATE_TYPE_DESC
, CA.DESCRIPTION
, DA.CREATED_BY
, DA.CREATION_DATE
, DA.LAST_UPDATED_BY
, DA.LAST_UPDATE_DATE
FROM IGS_CA_DA_CONFIGS DA
, IGS_CA_DA CA
WHERE DA.DATE_ALIAS=CA.DT_ALIAS WITH READ ONLY