...
Description | Table Field | |
|---|---|---|
Project Form App | In every Project Form App, there may exist multiple Form Iterations. | ZFORM_NAME |
Form Iteration | Each Form Iteration can accommodate multiple Workflow IDs intended for future Alternate Workflows. Form Iteration value increments whenever user saves the form app via 'SAVE (new iteration)' button or form is transported through systems. | ZITERATION_NO |
Workflow ID | Since the Alternate Workflow functionality has not been released yet, Workflow IDs as of FAB released v3.3.1 will consistently remain set to '1'. | ID |
Workflow Version | Within each Workflow ID, numerous Workflow Versions can be found, each possessing a unique HASH character identifier. All workflow versions available for each Form App can now be easily viewed via the new workflow designer. See Version List | VERSION_ID |
Related Tables
/IQX/FAB_WF - FAB Enhanced Workflow Definition
...
ZDEFAULT
...
BOOLEAN
...
Indication for default Workflow ID
...
MD5_CHECKSUM
...
HASH160
...
MD5 generation from ZDEFINITION, to be used as key in
...
MODIFIED_BY
...
CHAR 12
...
Modified By
...
MODIFIED_DATE
...
DATS 8
...
FAB Changed on date
...
MODIFIED_TIME
...
TIMS 6
...
FAB Changed at time
/IQX/FORMHD_INST - FAB Form Header Instance Data (run-time values)
New Fields:
...
Field
...
Key
...
Type
...
Description
...
WF_INSTANCE
...
FK
...
HASH160
...
WF Instance
...
IS_TERMINATED
...
...
BOOLEAN
...
Is FAB Instance EOL
Adds new line for every new
Project App-Form Iteration-WF ID-WF Version combinationFeatures:
WF instance
Multiple workflows per Project
Default workflow
Traceability - fields Modifies existing lines for every modification done on the existing WF Versions. Change Date and Timestamps are recorded in fields with pattern MODIFIED_*
Repurposed Notable Fields:
ZFORM_NAME: Form App
ZITERATION_NO: incrementing, to be used as WF VersionForm Iteration
ID: to be used as WF ID
ZID: to be used as WF Description
New Fields:
combination set of Project App>Form Iteration>WF ID>WF Version
...
Field
...
Key
...
Type
...
Description
Workflow ID (Always set to '1' as of FAB v3.3.1)
MD5_CHECKSUM: Unique character identifier of Active Workflow Versions
VERSION_ID: Workflow Version
Description Fields:
ITERATION_DESC: Form Iteration Description
ZID: Workflow ID Description
VERSION_DESC: Workflow Version Description (editable via new workflow designer)
DESCRIPTION: Project Form App Description
Status Fields:
IS_ACTIVE: Sets to 'X' (TRUE) when WF Version is in Active or Locked status
IS_RELEASED: Sets to 'X' (TRUE) when WF Version is released and transported
| Info |
|---|
When no Workflow Version is activated yet for the Project Form Application, the Workflow Instance ID (/IQX/FAB_WF-MD5_CHECKSUM) will be on its fall-back value: Form Instances submitted for WF Versions with Editable status will have this fall-back value as their unique MD5_CHECKSUM. |
/IQX/FAB_WF_INST - FAB - Enhanced Workflow Instance (New
...
table released in FAB v3.3)
To store the definition snapshot of WF Definition when a FAB instance is submitted.
Fields:
Field | KEY | Type | Description |
|---|---|---|---|
ZWF_INSTANCE | PK | HASH160 | WF Instance (MD5) |
ZFORM_NAME | FK | CHAR 24 | FAB Project ID |
ID | FK | NUMC 6 | Workflow ID |
ZITERATION_NO | FK | NUMC 6 | Workflow Version |
ZDEFINITION |
| STRING | WF Definition in JSON |
...
/IQX/FORMHD_INST - FAB Form Header Instance Data (run-time values)
New Fields:
Field | Key | Type | Description |
|---|---|---|---|
WF_INSTANCE | FK | HASH160 | WF Instance |
IS_TERMINATED |
| BOOLEAN | Is FAB Instance EOL |
Developer Guide
For list of technical objects affected by this change, see https://iqxbusiness.atlassian.net/wiki/spaces/IPM/pages/2159542343/Design+of+non-breakable+WF+for+in-flight+FAB+instances?atlOrigin=eyJpIjoiM2Q4NDk3OTY0NDNlNDcxY2FhOWFlZGY0ZjQ3YTMzNTEiLCJwIjoiYyJ9 .
...