[Home] [Help]
View: IGSFV_DISCONTINUATION_STATUSES
Product: | IGS - Student System (Obsolete) |
Description: | This entity describes user-defined administrative unit statuses that map to system-defined unit statuses, which are system and manually applied. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AUS.ADMINISTRATIVE_UNIT_STATUS
, AUS.DESCRIPTION
, AUS.UNIT_ATTEMPT_STATUS
, AUS.SHOW_ON_OFFIC_NTFCTN_IND
, AUS.EFFECTIVE_PROGRESSION_IND
, AUS.EFFECTIVE_TIME_ELAPSED_IND
, AUS.CLOSED_IND
, '_LA:UNIT_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:UNIT_ATTEMPT_STATUS:MEANING'
, AUS.CREATED_BY
, AUS.CREATION_DATE
, AUS.LAST_UPDATED_BY
, AUS.LAST_UPDATE_DATE
FROM IGS_AD_ADM_UNIT_STAT_ALL AUS WITH READ ONLY
Columns
Name |
ADMINISTRATIVE_UNIT_STATUS |
DESCRIPTION |
UNIT_ATTEMPT_STATUS |
SHOW_ON_OFFIC_NTFCTN_INDICATOR |
EFFECTIVE_PROGRESSION_IND |
EFFECTIVE_TIME_ELAPSED_IND |
CLOSED_INDICATOR |
"_LA:UNIT_ATTEMPT_STATUS_DESC" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |