Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes the unit section meeting schedules with day/time indicator, location, dedicated room/building details and also preferred building/room with start and end dates of the meeting schedule. |
Implementation/DBA Data: | Not implemented in this database |
SELECT OCCURRENCE_IDENTIFIER
, MONDAY MONDAY_INDICATOR
, TUESDAY TUESDAY_INDICATOR
, WEDNESDAY WEDNESDAY_INDICATOR
, THURSDAY THURSDAY_INDICATOR
, FRIDAY FRIDAY_INDICATOR
, SATURDAY SATURDAY_INDICATOR
, SUNDAY SUNDAY_INDICATOR
, START_TIME
, END_TIME
, BUILDING_CODE
, ROOM_CODE
, '_LA:SCHEDULE_STATUS:IGS_LOOKUP_VALUES:SCHEDULE_TYPE:MEANING'
, STATUS_LAST_UPDATED
, ERROR_TEXT
, INST_NOTIFY_IND INST_NOTIFY_INDICATOR
, NOTIFY_STATUS
, DEDICATED_BUILDING_CODE
, DEDICATED_ROOM_CODE
, PREFERRED_BUILDING_CODE
, PREFERRED_ROOM_CODE
, START_DATE
, END_DATE
, TO_BE_ANNOUNCED TO_BE_ANNOUNCED_INDICATOR
, UNIT_SECTION_OCCURRENCE_ID
, UOO_ID UNIT_SECTION_ID
, '_LA:PREFERRED_REGION_CODE:IGS_LOOKUP_VALUES:IGS_OR_LOC_REGION:MEANING'
, NO_SET_DAY_IND
, CANCEL_FLAG
, ABORT_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_PS_USEC_OCCURS_ALL WITH READ ONLY