FND Design Data [Home] [Help]

View: IGSBV_USEC_MEETING_SCHEDULES

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
View Text

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

Columns

Name
OCCURRENCE_IDENTIFIER
MONDAY_INDICATOR
TUESDAY_INDICATOR
WEDNESDAY_INDICATOR
THURSDAY_INDICATOR
FRIDAY_INDICATOR
SATURDAY_INDICATOR
SUNDAY_INDICATOR
START_TIME
END_TIME
BUILDING_CODE
ROOM_CODE
"_LA:SCHEDULE_STATUS"
STATUS_LAST_UPDATED
ERROR_TEXT
INST_NOTIFY_INDICATOR
NOTIFY_STATUS
DEDICATED_BUILDING_CODE
DEDICATED_ROOM_CODE
PREFERRED_BUILDING_CODE
PREFERRED_ROOM_CODE
START_DATE
END_DATE
TO_BE_ANNOUNCED_INDICATOR
UNIT_SECTION_OCCURRENCE_ID
UNIT_SECTION_ID
"_LA:PREFERRED_REGION_DESC"
NO_SET_DAY_INDICATOR
CANCEL_FLAG
ABORT_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE