Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes all the columns related to non-standard unit section discontinuation deadline dates |
Implementation/DBA Data: | Not implemented in this database |
SELECT UDD.ROWID ROW_ID
, UDD.USEC_DISC_DL_ID USEC_DISC_DL_ID
, UDD.NON_STD_DISC_DL_STP_ID NON_STD_DISC_DL_STP_ID
, UDD.UOO_ID UOO_ID
, UDD.USEC_DISC_DL_DATE USEC_DISC_DL_DATE
, UDD.USEC_DISC_TOTAL_DAYS USEC_DISC_TOTAL_DAYS
, UDD.USEC_DISC_OFFSET_DAYS USEC_DISC_OFFSET_DAYS
, UDD.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUS.DESCRIPTION DESCRIPTION
, UDD.DEFINITION_CODE DEFINITION_CODE
, LKV1.MEANING DEFINITION_CODE_MEANING
, UDD.ORG_UNIT_CODE ORG_UNIT_CODE
, OU.PARTY_NAME ORG_DESCRIPTION
, UDD.FORMULA_METHOD FORMULA_METHOD
, UDD.ROUND_METHOD ROUND_METHOD
, UDD.OFFSET_DT_CODE OFFSET_DT_CODE
, LKV2.MEANING OFFSET_DT_CODE_MEANING
, UDD.OFFSET_DURATION OFFSET_DURATION
, UDD.CREATED_BY CREATED_BY
, UDD.CREATION_DATE CREATION_DATE
, UDD.LAST_UPDATED_BY LAST_UPDATED_BY
, UDD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UDD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_USEC_DISC_DL UDD
, IGS_AD_ADM_UNIT_STAT AUS
, IGS_LOOKUP_VALUES LKV1
, IGS_LOOKUP_VALUES LKV2
, IGS_OR_INST_ORG_BASE_V OU
WHERE UDD.ADMINISTRATIVE_UNIT_STATUS = AUS.ADMINISTRATIVE_UNIT_STATUS(+)
AND (LKV1.LOOKUP_CODE(+) = UDD.DEFINITION_CODE
AND LKV1.LOOKUP_TYPE(+) = 'DEFINITION_LEVEL')
AND (LKV2.LOOKUP_CODE(+) = UDD.OFFSET_DT_CODE
AND LKV2.LOOKUP_TYPE(+) = 'OFFSET_DATE')
AND UDD.ORG_UNIT_CODE = OU.PARTY_NUMBER (+)
AND OU.INST_ORG_IND (+) = 'O'