Integrate
Process Templates: After Post Rules H
Process Templates: After Post Rules V
Use this page to Register After Post Rules to a Process Template.
- Select Integrate > Categories from Navigation pane.
- Click the Processes icon for a category.
- Click the After Post Rules icon for a process template.
|
Field |
Description |
|
PRIORITY |
Displays the order the After Post Rule runs for this process template if multiple rules are assigned. Rules process in ascending order. |
|
RULE |
Displays the rule name. An After Post Rule is used in a multi-template process and can be a stored procedure, Collect Download, or Status View. The rules run after the process template is finished executing and before the next one begins. |
|
COMMENT |
Displays user-entered text, which could include a description of the after post rule’s function |
Process Templates After Post Rules V
Process Templates: After Post Rules H
Use this page to Register After Post Rules to a Process Template.
|
Field |
Description |
|
Basic |
|
|
Priority |
Displays the order the After Post Rule runs for this process template if multiple rules are assigned. Rules process in ascending order. |
|
Comment |
Displays user-entered text, which could include a description of the after post rule’s function |
|
Business Rule |
|
|
After Post Rule Data Source ID |
Displays the data source that stores the stored procedure. |
|
After Post Rule |
Displays the Business Rule name. Rules pull data down to refresh local data after it has been changed or to manipulate the local data to prepare for the next template. This stored procedure runs after the process template is finished executing and before the next one begins. When a Business Rule After Post Rule is encountered, Integrate runs the rule and waits for it to complete before running the next rule. Refer to Register a Stored Procedure as an After Post Rule for more information. |
|
Collect |
|
|
Collect Source |
Displays the source to use for the Collect Download. NOTE: The source is required when registering a Collect Download. |
|
Collect Target |
Displays the target to use for the Collect Download. NOTE: The target is required when registering a Collect download. |
|
Collect Table Name |
Displays the name of the table to download. NOTE: The table name is required when registering a Collect Download. |
|
Collect Target Where Clause |
Displays the rule to run on target data after the table downloads. The data returned from this Where clause is used as an input parameter to the next template in the process. The target Where clause selects records to delete from the target before the download. Refer to Register a Collect Download After Post Rule Manually for more information. |
|
Collect Source Where Clause |
Displays the rule to run on source data after the table downloads. The source Where clause selects records to download from the source to the target. The data returned from this Where clause is used as an input parameter to the next template in the process. Refer to Register a Collect Download After Post Rule Manually for more information. |
|
Collect Where Clause |
Click to open the Process Template: After Post Rule: Collect Where page to add the inputs to a Where clause that is built automatically at run time. Refer to Register a Collect Download After Post Rule that is Built Automatically for more information. |
|
Collect Run Rules After Download |
If enabled, the rules run on the Collect table after it has downloaded. If disabled, the rules do not run. |
|
Status |
|
|
Status View Data Source ID |
Displays the data source that stores the Status View. |
|
Status View |
Displays the name of the Status View used to communicate a status of the posting to the user. The view status is "pass" when there are no records in the view for the PostingID. The view status is "fail" if the view contains at least one record of data for the PostingID. If a status of failure is found then that status is written as the status for the posting of that template. Refer to Register a Status View as an After Post Rule for more information. |
