Table:
WFEvent
Workflow Events
Name | Type | Description | Remarks |
---|---|---|---|
AssociatedEntityID | Identifier to the associated table, depending on the WorkFlowType |
For WFType 1 or 2, AssociatedEntityID is a foreign key to the Orders table. For WFType 4, AssociatedEntityID is a foreign key to the BillingClaim table. |
|
EventName |
varchar(50) |
Brief verbal description of the event |
eg: Edit or Return Adjustment |
Note |
varchar(max) |
Extended description of the event |
May contain formatting tags |
Timestamp |
datetime |
Date/Time stamp for the Workflow Event |
|
UserId |
int |
User ID of the user that triggered the event. |
UserID is a foreign key to the Users table. |
WFTypeID |
int |
Workflow Type Identifier |
WFTypeID is a foreign key to the WFType table. |
XIFBatchID |
int |
XIF Framework (XLink) Batch ID |
XIFBatchID is a foreign key to the Batch table in the XIF_Framework database. |