|
|
|
|
vEventDetail |
Provides a description of an event. |
|
Column Name |
Type |
Purpose |
PartitionId |
numeric(26,0), not null |
Tenant identifier |
EventTypeDesc |
varchar(256), not null |
Description |
IntervalTypeDesc |
varchar(50), not null |
Interval type ID |
EventDesc |
varchar(256), not null |
Description |
EventEndpoint |
varchar(770), not null |
The endpoint name to dispatch |
Data |
varchar(-1), null |
Data payload |
DataFileSpec |
varchar(200), null |
File path to pass along (if any) |
EffectiveDate |
datetime(3), not null |
Date event was first introduced |
ExpirationDate |
datetime(3), null |
Expiration date (if any) |
IntervalIncrement |
int(10), null |
Increment integer |
CreateOwnerCalendarEntries |
bit, null |
If 1, create a full year's worth of scheduling information, starting from the first run date, in the Hermes.EventInstance table. If 0, do not create this scheduling instance. |
NotifyOwnerOnStartAndCompletion |
bit, not null |
Boolean notification flag (future use) |
NotifySubscribersOnCompletion |
bit, not null |
Boolean notification flag (future use) |
OwnerUserName |
varchar(50), null |
User Name |
OwnerCoveredPassword |
varchar(50), null |
Covered PW (future use) |
StartNotificationNote |
varchar(100), null |
Notification note (future use) |
CompletionNotificationNote |
varchar(100), null |
Completion note (future use) |
SuspenseIntervalTypeID |
int(10), null |
Suspense interval type as specified in interval type ID table |
SuspenseIntervalIncrement |
int(10), null |
Suspense interval increment |
SuspenseExpirationEventID |
int(10), null |
Upon suspense expiration which event to dispatch (future use) |
SuspenseExpirationNote |
varchar(100), null |
Suspense expiration note (future use) |
ErrorEventID |
int(10), null |
Upon error, which event to dispatch (future use) |
ErrorNote |
varchar(100), null |
Error note (future use) |
PreparationEventID |
int(10), null |
(future use) |
PreparationEventData |
varchar(200), null |
(future use) |
CalendarEntriesAllowed |
bit, not null |
Should year? instance creation be allowed |
DefaultEventEndpoint |
varchar(770), not null |
Default endpoint name |
OwnerNotificationAllowed |
bit, not null |
Notification bit for owner |
SubscriberNotificationAllowed |
bit, not null |
Notification bit for subscriber |
SysMinIncrement |
int(10), not null |
Run count (number of times) |
SysMaxIncrement |
int(10), not null |
Recurrence in seconds |
MinIncrement |
int(10), not null |
Minimum increment |
MaxIncrement |
int(10), not null |
Maximum increment |
EventId |
int(10), not null |
Unique event type ID |
Active |
bit, not null |
Is active bit |
RunCount |
int(10), null |
Run count (number of times) |
ScriptId |
int(10), null |
script ID linking to agent procedures |
AgentGuid |
numeric(26,0), null |
Unique 26 digit random number identifying this agent. Master record stored in machNameTab. |
orgCalendarScheduleId |
numeric(26,0), null |
Associated ID in orgCalendarSchedule |