[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_USEC_MEETING_SCHEDULES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_USEC_MEETING_SCHEDULES
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 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 | |
| _DF | CHAR | (32) | Descriptive flexfield | |
| 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 | |
| BUILDING_DESCRIPTION | VARCHAR2 | (80) | Description of the building | |
| ROOM_DESCRIPTION | VARCHAR2 | (80) | Description of the room | |
| DEDICATED_BUILDING_DESC | VARCHAR2 | (80) | Description of the building code | |
| DEDICATED_ROOM_DESC | VARCHAR2 | (80) | Description of the room code | |
| PREFERRED_BUILDING_DESC | VARCHAR2 | (80) | Description of the preferred building | |
| PREFERRED_ROOM_DESC | VARCHAR2 | (80) | Description of the preferred room | |
| 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 |
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
, _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
FROM APPS.IGSFV_USEC_MEETING_SCHEDULES;
APPS
IGS_AD_BUILDING_ALL
IGS_AD_ROOM_ALL
IGS_PS_USEC_OCCURS_ALL
APPS.IGSFV_USEC_MEETING_SCHEDULES is not referenced by any database object
|
|
|
|