DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSBV_USEC_MEETING_SCHEDULES

Object Details
Object Name: IGSBV_USEC_MEETING_SCHEDULES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_USEC_MEETING_SCHEDULES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
OCCURRENCE_IDENTIFIER VARCHAR2 (30) Yes Unique identity for an occurrence within a unit section.
MONDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Monday
TUESDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Tuesday
WEDNESDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Wednesday.
THURSDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Thursday
FRIDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Friday.
SATURDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Saturday
SUNDAY_INDICATOR VARCHAR2 (1)
Indicates class is conducted on Sunday.
START_TIME DATE

Start time of the unit section occurrence
END_TIME DATE

End time of the unit section occurrence
BUILDING_CODE NUMBER (10)
Building in that the unit section occurrences
ROOM_CODE NUMBER (10)
Room in that the unit section occurrences
_LA:SCHEDULE_STATUS CHAR (59)
Status of the unit section occurrence
STATUS_LAST_UPDATED DATE

Last time in that the status of the unit section occurrence is updated
ERROR_TEXT VARCHAR2 (2000)
Error text from the scheduling
INST_NOTIFY_INDICATOR VARCHAR2 (1)
Instructor Notified Indicator
NOTIFY_STATUS VARCHAR2 (10)
Status of the notification
DEDICATED_BUILDING_CODE NUMBER (10)
Dedicated Building Code
DEDICATED_ROOM_CODE NUMBER (10)
Dedicated Room Code
PREFERRED_BUILDING_CODE NUMBER (10)
Preferred building code
PREFERRED_ROOM_CODE NUMBER (10)
Preferred room code
START_DATE DATE

Start Date
END_DATE DATE

End Date
TO_BE_ANNOUNCED_INDICATOR VARCHAR2 (1)
To be announced indicator
UNIT_SECTION_OCCURRENCE_ID NUMBER (10) Yes Unique identifier for unit section occurrence.
UNIT_SECTION_ID NUMBER (7) Yes Unit Section Identifier
_LA:PREFERRED_REGION_DESC CHAR (69)
Preferred Region description
NO_SET_DAY_INDICATOR VARCHAR2 (1)
Indicator to indicate the unit section occurrence is a no set day unit section occurrence or not. No set day unit section occurrence doesn't require scheduling information like (Building,Room etc.). E.g. web courses.
CANCEL_FLAG VARCHAR2 (1)
Flag to indicate the unit section occurrence is requested for cancel.
ABORT_FLAG VARCHAR2 (1) Yes Flag to indicate whether the occurrence is ABORTED.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.IGSBV_USEC_MEETING_SCHEDULES;

Dependencies

[top of page]

APPS.IGSBV_USEC_MEETING_SCHEDULES references the following:

SchemaAPPS
SynonymIGS_PS_USEC_OCCURS_ALL

APPS.IGSBV_USEC_MEETING_SCHEDULES is not referenced by any database object