A one-time event describes a event that is not recurring. I.e it happens only once and has a fixed start and end time.
A one-time event may be related to a recurring event. If so, it is used to override an recurring occurrence for the recurring event in cases where an occurrence is updated or deleted.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| onetime_event_oid | varchar(20) | not null | Unique identity of the one-time event |
| start | integer | not null | Start time in epoch for the one time event |
| duration | integer | with null | Durations, in seconds for the one time event |
| description | nvarchar(255) | with null | Textual description of the event |
| status | char(1) | with null | Status, 'D' - deleted, 'A' or null = active |
| value | nvarchar(255) | with null | Value of the event |
| calendar_oid | varchar(20) | with null | The calendar to which this event belongs. |
| event_category_oid | varchar(20) | with null | The event category to which this event belongs |
| recurring_event_oid | varchar(20) | with null | A onetime event can be used to remove or add occurrences to a recurring event by pointing to the recurring event here. |
| event_category_value_oid | varchar(20) | with null | The event category value selected. May be null. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| onetime_event_oid | usm_sm_event | onetime_event_oid |
| onetime_event_oid | usm_service_event | onetime_event_oid |