Creating a Cash Flow Edit process is a one-step process. You define both the attributes that uniquely describe a particular Cash Flow Edit process and the data to be validated or cleansed by that process on the Create Cash Flow Edit process page.
The following table describes key terms used for this procedure.
Term |
Description |
|---|---|
Filters |
One of the two components that determine the data that will be cleansed by Cash Flow Edit processes. This field allows you to select a subset of data for processing by selecting a Filter that was previously created. Its default value is "No Filter". |
Source Selection |
One of the two components that determine the data that will be cleansed by Cash Flow Edit processes. This field allows you to select the Instrument tables that need to be included in a Cash Flow Edit process. Alternatively, you can select a hierarchy and then select the desired product members that will be included in the process. Note that the Source selection and Hierarchy selection options are mutually exclusive. You can define your dataset by selecting one or the other, but not a combination of both. |
Preview Mode |
Selecting this check box allows you to view the results of running a Cash Flow Edit process before the system updates the underlying records in the Instrument tables. The default value is checked. |
Source Selection: Available Tables |
When the "Source Selection" option is made, you are presented with two Shuttle Control windows which contain the names of the Instrument Tables available for inclusion during a Cash Flow Edit process. |
Source Selection: Selected Tables |
One of the two Shuttle Control windows, it contains the names of the tables that have already been selected for processing by the Cash Flow Edit process. |
Cash Flow Edit Rules |
The Cash Flow Edit Rule section provides a summary of all seeded cash flow edit rules. Users can refer to this list to understand the validations that are applied to the cash flow fields on the instrument records and also view the default values that are applied when errors are found. |
1. Navigate to the Cash Flow Edits Summary page.
2. Click Add button.
The Create Cash Flow Edits Process page is displayed.
3. Complete standard steps for this procedure. For more information, see Creating Rules section.
Note At this point, you can input the components to ensure that the data processed by Cash Flow Edits will be clean. If you save the Rule without selecting Instrument tables or selecting product members from the hierarchy, the Process will be saved but no data would be selected for cleansing. |
4. (Optional) Select a Filter.
5. Select the Instrument tables or use a hierarchy to make Product member selections.
Note Use the Source Selection: Shuttle Control to select the Instrument tables that you want to include in the Cash Flow Edit process. You can move Instrument tables from Available Tables into Selected Tables and vice versa by using Move, Move All, Remove, and Remove All. These tables can also be reordered to change the order of processing. Initially, the selected tables list is empty. However, during subsequent runs, the selected tables list retains the names of the tables that you selected previously. For example, if you select two tables and save the Cash Flow Edits Process, the system shows them the next time you open the rule. A table name shown in the Selected Tables list does not appear in the Available Tables. |
6. Click Save.
The Cash Flow Edits process is saved and the summary page is displayed.