These entries are copies of WFE records when these are deleted by SRVCLN.
WFD records contains information for statistical evaluation only.
WFD records contain no business relevant data and can be deleted when statistical information is no longer required.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| WFSSUB | ID within WFS | Text | 6 | 1 | Edit | Yes | Public | ||
| SRV | Service | Text | 6 | 1 | Edit | Yes | Public | SRVTXT | |
| STA | Status | Text | 1 | 4 | Edit | Yes | Public | ||
| RTYCNT | Retry Count | Numeric | 6 | 0 | Edit | Yes | Public | ||
| TARDATTIM | Target Time for Completion | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| SSNINR | INR of Session of Last Update | Text | 8 | 1 | Edit | Yes | Public | ||
| DATTIM | Timestamp Last Update | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| TXT | Textual Event Description (in SYSUIL) | Text | 80 | 1 | Edit | Yes | Public | ||
| MANFLG | Flag whether 'STA'tus was changed manually | Text | 1 | 4 | Edit | Yes | Public | YESNO | |
| OPNDUR | Total time in status 'O'pen (in Seconds) | Numeric | 10 | 0 | Edit | Yes | Public | ||
| WAIDUR | Total time in status 'W'aiting (in Seconds) | Numeric | 10 | 0 | Edit | Yes | Public | ||
| RETDUR | Total time in status 'R'etry (in Seconds) | Numeric | 10 | 0 | Edit | Yes | Public | ||
| HDLDUR | Total processing time (in Milliseconds) | Numeric | 10 | 0 | Edit | Yes | Public | ||
| OBJTYP | Table Used to Store Associated Object | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| OBJINR | INR of Object | Text | 8 | 1 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity holding Transaction | Text | 8 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| WFD_OBJ | OBJTYP, OBJINR |
/
WFSSUB
Service to be executed + subtype within service.
The subtype is typically set from SMH\CORTYP and currently not used.
This identifies the service to be executed and the subtype within the service.
This is the service to be executed.
This is the service to be executed.
Open - Service not yet ready to be performed (due to SRO restrictions)
Waiting - Waiting for service to be performed (not waiting for SRO predecessors)
Active - Service for this entry is currently running (Set only for special services like SRVPDX)
Done - Service successfully performed
Retry - Service tried but not succeeded yet. Retry later
Error - Service failed
Skip - Skip service due to 'C'ancel of other service
Cancel - Workflow was canceled because this service failed
Open - the service not yet ready to be performed (due to SRO restrictions)
Waiting - Waiting for service to be performed (not waiting for SRO predecessors)
Active - Service for this entry is currently running (Set only for special services like SRVPDX)
Done - Service successfully performed
Retry - Service tried but not succeeded yet. Retry later
Error - Service failed
Skip - Skip service due to 'C'ancel of other service
Cancel - Workflow was canceled because this service failed
Counter which holds all unsuccessful trials to execute the service. A value of 0 identifies a service with either no trials or no errors.
Counter that holds the number of unsuccessfull attempts to execute the service. A value of 0 indicates that a service was either not attempted or had no errors.
Target date/time on which the service should be completed.
Target date and time on which the service is to be completed.
This is the INR of the session which issued the last update to the WFE entry.
This is the unique ID of the session running the last update.
This is the date and time when the WFD entry was written by SRVCLN
This is the date and time when the workflow statistics entry was last updated by the cleanup transaction.
Result text returned by the last execution of the service SRV. This might be either an error message or a completion message. Upon cleanup this text is copied to the TRN event textblock.
The text of the result text returned when the service was last run. This might be either an error message or a completion message. Following a clean up, this text is copied to the transaction event textblock.
This flag is set when the status of this record was modified manually e.g. by DBWTRN.
When this flag is set, WFE record should be exempted from statistics.
This flag is set when the status of this record was modified manually (e.g. by the 'Repair Transactions / Edit Workflow' transaction.
Total time (in seconds) the status level for the entry was 'O'pen.
Total time (in seconds) the status level for the entry was 'O'pen.
Total time (in seconds) the status level of the entry was 'W'aiting.
Total time (in seconds) the status level of the entry was 'W'aiting.
Total time (in seconds) the status level for the entry was 'R'etry.
Total time (in seconds) the status level for the entry was 'R'etry.
Total processing time (in milliseconds) for this entry.
Total processing time (in milliseconds) for this entry.
This field is copied from WFS.
Type of object the WFS entry refers to. This is the table the object is stored in. The table TRN is currently the only table used for workflow.
This field is copied from the Workflow Subject (WFS) and
is the type of object the WFS entry refers to.
| Code | Text |
|---|---|
| TRN | Transaction |
| ORD | Order |
This field is copied from WFS.
INR of the object within the table, defined in OBJTYP. Thus it is currently the TRN\INR of the transaction.
This field is copied from the Workflow Subject and
is the unique ID of the object within the table, defined in the Object Type field.
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
This field holds the external key of the owning entity to identify the logical owner of this entry.
This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.