Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes all the columns related to enrollment deadline date offset constraints |
Implementation/DBA Data: | Not implemented in this database |
SELECT DDCV.ROWID
, DDCV.DISC_DL_CONS_ID
, DDCV.OFFSET_CONS_TYPE_CD
, LKV.MEANING
, DDCV.CONSTRAINT_CONDITION
, DDCV.CONSTRAINT_RESOLUTION
, DDCV.NON_STD_DISC_DL_STP_ID
, DDCV.CREATED_BY
, DDCV.CREATION_DATE
, DDCV.LAST_UPDATED_BY
, DDCV.LAST_UPDATE_DATE
, DDCV.LAST_UPDATE_LOGIN
FROM IGS_EN_DISC_DL_CONS DDCV
, IGS_LOOKUPS_VIEW LKV
WHERE LKV.LOOKUP_CODE = DDCV. OFFSET_CONS_TYPE_CD
AND LKV.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE'