vEventDetail
|
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 |
