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 DOSC.ROWID
, DOSC.ENR_DL_OFFSET_CONS_ID
, DOSC.OFFSET_CONS_TYPE_CD
, LKV.MEANING
, DOSC.CONSTRAINT_CONDITION
, DOSC.CONSTRAINT_RESOLUTION
, DOSC.NON_STD_USEC_DLS_ID
, DOSC.DEADLINE_TYPE
, DOSC.CREATED_BY
, DOSC.CREATION_DATE
, DOSC.LAST_UPDATED_BY
, DOSC.LAST_UPDATE_DATE
, DOSC.LAST_UPDATE_LOGIN
FROM IGS_EN_DL_OFFSET_CONS DOSC
, IGS_LOOKUP_VALUES LKV
WHERE LKV.LOOKUP_CODE = DOSC.OFFSET_CONS_TYPE_CD
AND LKV.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE'