The following table shows the structure of the JRINCIDENT table:
Column name |
Data type |
Description |
|---|---|---|
processname |
(N)VARCHAR(50) |
Process name |
version |
INTEGER |
Version of the process |
processid |
(N)VARCHAR(50) |
Process ID |
incident |
INTEGER |
Instance number |
status |
INTEGER |
Status of the instance 0: Open 5: Completed |
startdate |
DATETIME |
Start date of the instance |
enddate |
DATETIME |
End date of the instance |
initiator |
(N)VARCHAR(50) |
Username of initiator |
summary |
(N)VARCHAR(255) |
Summary of the instance |
description |
(N)VARCHAR(50) |
Not used |
priority |
INTEGER |
Priority of the instance |
reactivated |
INTEGER |
Flag reactivated 1: Instance was reactivated 0: Default |
reactivate_date |
DATETIME |
Reactivate date |
start_step |
INTEGER |
Number of the first step of the instance |
start_workflowid |
(N)VARCHAR(50) |
Forst workflow ID |
last_step |
INTEGER |
Last step ID |
last_workflowid |
INTEGER |
Last workflow ID |
escalation_date |
DATETIME |
Returns the processing deadline for the instance |
