Table Description
Deferred Process Ticket: An execution of a requested Deferred Process Instance.

When the queue manager dequeues a request to execute a deferred process, Cúram creates a row on this table to store details of the execution.

Example

User Ronan Rooney makes a change to some evidence which affects existing cases for Person John Smith.

The Cúram Server records the change and requests that a deferred process be executed to reassess John Smith's cases. Control returns to User Ronan Rooney as soon as the request has been made, rather than waiting for the reassessment to execute.

The queue manager dequeues the deferred processing request and creates a row on this table.

Technical Notes

Each row on this table is created in tandem with a row created on Deferred Process Instance.

For more information see the Cúram Workflow Management System Developer's Guide.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Attributes (13)
AttributeKeyNullableDescriptionDDL Type
ticketIDYesNoThe unique identifier of the ticket which is used as the primary key for the ticket in the ticket database.SVR_INT64
subject  This gives a short text description about what the ticket is being sent to tell the user to do. Standard text messages should be defined to briefly describe any task objectives for users.SVR_STRING<254>
instDataID  The unique identifier of a ticket instance.SVR_INT64
processName NoThe unique name of the workflow process.SVR_STRING<254>
processInstID NoThe unique identifier of a process instance.SVR_INT64
interfaceName  This is the name for the interface of a BPO to be used for the automatic execution of a task.SVR_STRING<100>
methodName  The name of the method belonging to a BPO which is executed to carry out an automatic task.SVR_STRING<30>
creationTS  The date and time at which the ticket was created.SVR_DATETIME
closureTS  The date and time at which the ticket was closed.SVR_DATETIME
status  The status of the ticket (open or closed).SVR_STRING<10>
resolutionCode  Whether the resolution of the ticket was successful or not.SVR_STRING<10>
ticketType  The general ticket type.SVR_STRING<10>
lastWritten   SVR_DATETIME
Foreign Keys (2)
ChildParent
DPTicket.processInstIDDPProcessInstance.instanceID
DPTicket.processNameDPProcess.processName
Indices (2)
Index NameAttributes
IND__2023249943processInstID
IND_1119817363processName
Related Pages (0)