eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_USEC_MEETING_SCHEDULES

Product:	IGS - Student System
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:	APPS.IGSFV_USEC_MEETING_SCHEDULES

View Text

SELECT USO.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER
, USO.MONDAY MONDAY_INDICATOR
, USO.TUESDAY TUESDAY_INDICATOR
, USO.WEDNESDAY WEDNESDAY_INDICATOR
, USO.THURSDAY THURSDAY_INDICATOR
, USO.FRIDAY FRIDAY_INDICATOR
, USO.SATURDAY SATURDAY_INDICATOR
, USO.SUNDAY SUNDAY_INDICATOR
, USO.START_TIME
, USO.END_TIME
, USO.BUILDING_CODE
, USO.ROOM_CODE
, '_LA:SCHEDULE_STATUS:IGS_LOOKUP_VALUES:SCHEDULE_TYPE:MEANING'
, USO.STATUS_LAST_UPDATED
, USO.ERROR_TEXT
, USO.INST_NOTIFY_IND INST_NOTIFY_INDICATOR
, USO.NOTIFY_STATUS
, '_DF:IGS:IGS_PS_UNITSEC_OCCUR:USO'
, USO.DEDICATED_BUILDING_CODE
, USO.DEDICATED_ROOM_CODE
, USO.PREFERRED_BUILDING_CODE
, USO.PREFERRED_ROOM_CODE
, USO.START_DATE
, USO.END_DATE
, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED_INDICATOR
, BLD1.DESCRIPTION BUILDING_DESCRIPTION
, ROM1.DESCRIPTION ROOM_DESCRIPTION
, BLD2.DESCRIPTION DEDICATED_BUILDING_DESC
, ROM2.DESCRIPTION DEDICATED_ROOM_DESC
, BLD3.DESCRIPTION PREFERRED_BUILDING_DESC
, ROM3.DESCRIPTION PREFERRED_ROOM_DESC
, USO.UNIT_SECTION_OCCURRENCE_ID
, USO.UOO_ID UNIT_SECTION_ID
, '_LA:PREFERRED_REGION_CODE:IGS_LOOKUP_VALUES:IGS_OR_LOC_REGION:MEANING'
, USO.NO_SET_DAY_IND NO_SET_DAY_INDICATOR
, USO.CANCEL_FLAG CANCEL_FLAG
, USO.ABORT_FLAG ABORT_FLAG
, USO.CREATED_BY
, USO.CREATION_DATE
, USO.LAST_UPDATED_BY
, USO.LAST_UPDATE_DATE
FROM IGS_PS_USEC_OCCURS_ALL USO
, IGS_AD_BUILDING_ALL BLD1
, IGS_AD_BUILDING_ALL BLD2
, IGS_AD_BUILDING_ALL BLD3
, IGS_AD_ROOM_ALL ROM1
, IGS_AD_ROOM_ALL ROM2
, IGS_AD_ROOM_ALL ROM3
WHERE USO.BUILDING_CODE = BLD1.BUILDING_ID (+)
AND USO.ROOM_CODE = ROM1.ROOM_ID (+)
AND USO.DEDICATED_BUILDING_CODE = BLD2.BUILDING_ID (+)
AND USO.DEDICATED_ROOM_CODE = ROM2.ROOM_ID (+)
AND USO.PREFERRED_BUILDING_CODE = BLD3.BUILDING_ID (+)
AND USO.PREFERRED_ROOM_CODE = ROM3.ROOM_ID (+) 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
"_DF"
DEDICATED_BUILDING_CODE
DEDICATED_ROOM_CODE
PREFERRED_BUILDING_CODE
PREFERRED_ROOM_CODE
START_DATE
END_DATE
TO_BE_ANNOUNCED_INDICATOR
BUILDING_DESCRIPTION
ROOM_DESCRIPTION
DEDICATED_BUILDING_DESC
DEDICATED_ROOM_DESC
PREFERRED_BUILDING_DESC
PREFERRED_ROOM_DESC
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