SVC_BI_WORK_CALENDARS
This table is used for BI reporting to report on time spent in the lifecycle of an SR. It can be used to more accurately determine such metrics as SR age, or time to resolve, as it takes into account agent availability according to a schedule of working hours.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_BI_WORK_CALENDARS_PK |
WORK_CALENDAR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORK_CALENDAR_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | |
| SCHEDULE_ID | NUMBER | 18 | Foreign key that references OSS_COVERAGE_SCHEDULES.SCHEDULE_ID. | ||
| EXCEPTION_ID | NUMBER | 18 | Foreign key that references OSS_COVERAGE_EXCEPTIONS.EXCEPTION_ID. | ||
| TIMEZONE_CODE | VARCHAR2 | 50 | The local timezone for the schedule. This is the timezone for LOCAL_START_DATE, LOCAL_END_DATE, and LOCAL_REPORT_DATE. | ||
| WORK_CALENDAR_START_DATE | TIMESTAMP | The starting date and time this row is relevant for (in UTC). | |||
| WORK_CALENDAR_END_DATE | TIMESTAMP | The ending date and time this row is relevant for (in UTC). | |||
| LOCAL_START_DATE | TIMESTAMP | The starting date and time this row is relevant for (in the timezone determined by TIMEZONE_CODE). | |||
| LOCAL_END_DATE | TIMESTAMP | The ending date and time this row is relevant for (in the timezone determined by TIMEZONE_CODE). | |||
| DURATION_MS | NUMBER | 18 | The duration of time between WORK_CALENDAR_START_DATE and WORK_CALENDAR_END_DATE in milliseconds. | ||
| REPORT_DATE | DATE | THe starting date this row is relevant for (in UTC). | |||
| LOCAL_REPORT_DATE | DATE | THe starting date this row is relevant for (in the timezone determined by TIMEZONE_CODE). | |||
| DELETED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the row is logically deleted (Y or N). | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_BI_WORK_CALENDARS_N1 | Non Unique | DEFAULT | SCHEDULE_ID, REPORT_DATE |
| SVC_BI_WORK_CALENDARS_N2 | Non Unique | DEFAULT | LAST_UPDATE_DATE |
| SVC_BI_WORK_CALENDARS_PK | Unique | Default | WORK_CALENDAR_ID |