Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes all the columns related to non-standard unit section enrollment deadline dates |
Implementation/DBA Data: | Not implemented in this database |
SELECT NSDL.ROWID
, NSDL. NSTD_USEC_DL_ID
, NSDL.NON_STD_USEC_DLS_ID
, NSDL.UOO_ID
, NSDL.ENR_DL_DATE
, NSDL.ENR_DL_TOTAL_DAYS
, NSDL.ENR_DL_OFFSET_DAYS
, NSDL.FUNCTION_NAME
, LKV1.MEANING
, NSDL.DEFINITION_CODE
, LKV2.MEANING
, NSDL.ORG_UNIT_CODE
, OU.DESCRIPTION
, NSDL.FORMULA_METHOD
, NSDL.ROUND_METHOD
, NSDL.OFFSET_DT_CODE
, LKV3.MEANING
, NSDL.OFFSET_DURATION
, NSDL.CREATED_BY
, NSDL.CREATION_DATE
, NSDL.LAST_UPDATED_BY
, NSDL.LAST_UPDATE_DATE
, NSDL.LAST_UPDATE_LOGIN
FROM IGS_EN_NSTD_USEC_DL NSDL
, IGS_OR_UNIT OU
, IGS_LOOKUPS_VIEW LKV1
, IGS_LOOKUPS_VIEW LKV2
, IGS_LOOKUPS_VIEW LKV3
WHERE NSDL.ORG_UNIT_CODE = OU.ORG_UNIT_CD (+)
AND (LKV1.LOOKUP_CODE (+) = NSDL.FUNCTION_NAME
AND LKV1.LOOKUP_TYPE(+) = 'ENROLLMENT_FUNCTION')
AND (LKV2.LOOKUP_CODE (+) = NSDL.DEFINITION_CODE
AND LKV2.LOOKUP_TYPE(+) = 'DEFINITION_LEVEL')
AND (LKV3.LOOKUP_CODE (+) = NSDL.OFFSET_DT_CODE
AND LKV3.LOOKUP_TYPE(+) = 'OFFSET_DATE')