Bordereaux
Business rules for Bordereaux are built with a click-drop toolset on a workflow design canvas. The purpose of rules in Bordereaux processing is to cleanse raw data and generate derived data. The workflow canvas is available through the Mapping Template Manager.
Click the image below to change its size.
Add Workflow - Adds a new tab and a canvas where you can create a new business rule. A tab represents one set of commands. If your rule is complex, you can break it up into multiple tabs that all work together.
Tab Name – The tab name corresponds to the name of the rule. Provide a tab name indicates the rule you are creating.
Start – All rules start from the Start Button.
End - Rules end with the End button.
Save – The Save button commits items added to the workflow canvas. Perform this function before you begin configuring each tool you add.
To create a new mapping rule, start by adding new Workflow Tab “Add Workflow”. Users can then load either tools (from the toolkit) or data elements from the Normalized or Derived Data sets by clicking on the tool or data element once. The following options are available from the screen above:
Comparison – Causes system to compare to values and provides for a True or False Flow to occur based on Results. Operations include:
| = | Use when two data sets are the same |
|---|---|
| < | Use when the first data element is less than the second |
| > | Use when the first data element is greater than the second |
| =< | Use when the first data element is less than or equal to the second |
| => | Use when the first data element is greater then or equal to the second |
| Begins with | Use when first data element begins with second element. Typically you would use a constant to define the second data element or a table lookup. |
| Ends with | Use when the first data element ends with second data element. Typically you would use a constant to define the 2nd data element or alternately a table lookup. |
| Contains | Does first data element contain contents of 2nd. Typically you would use a constant to define the second data element or a table lookup. |
| Is Blank | Use when the first data element is blank or null |
| Is not Blank | Use when the data element contains a value |
Clicking on a tool or data element on the screen provides the user a pop-up box with the following options: