Create or edit existing Description Miner records

Use the Description Miner feature to populate reportable fields with defined rules (based on search terms) and extract any text from the transaction data found in the BAI2 information (Description field) in the Cash Flow/Working Capital (CFWC) table. This valuable data is stored in reportable fields for enhanced reporting and analysis.

1. On the Treasury Cash Management page, click Administration > Cash Flow/Working Capital.

2. Click Description Miner.

3. Select the Report Fields option.

   

4. Click See unassigned transactions to view all transactions that have not been assigned a detail rollup.

5. Click Add Record to create a new record and define the rules for that new record.

6. Click the applicable field in the Field to Save to dropdown by selecting a standard or a user-defined field (UDF) name.

7. In the Parse Text columns, enter the text to capture/extract from (the starting position) in the Find Text From field, and then enter the text to capture/extract to (the ending position) in the Find Text To field. All content in between these columns is extracted and saved to the report field defined in the rule.

   Example:

   To capture the bank name from each transaction, enter Sending Bank and Sending Bank Reference. (The from and to search terms vary by bank. Review your transaction data to verify that you entered the correct search terms.)

8. In the Find/Replace Text columns, enter the text you want to remove in the Remove This Text field, and then enter the preferred text in the Replace With This Text field (or leave it blank to remove extra characters).

   Example:

   To remove a “space hyphen space,” enter [ - ] in the Remove This Text field, and then leave the Replace With This Text field blank. This action removes the separating hyphen and surrounding spaces from the extracted data.

9. To filter certain days of the week, select the applicable weekday (or All) in the Weekdays field.

10. To filter only debits or credits, select the applicable transaction type in the DB/CR dropdown .

11. To filter certain Bank Administration Institute (BAI) codes, select the applicable code in the BAIs to apply to dropdown.

12. To filter certain bank accounts, select the applicable account in the Bank accounts to apply to dropdown.

13. Select the Enabled check box to verify the rule is applied. Clear the Enabled check box to save the rule but disable it.

    NOTE: The number in the UID column provides a Unique ID number that is used in the database.

14. Click Save to save any changes and/or added records.

15. Click OK to confirm the saved data.

16. Refer to Run Description Miner to apply the rules defined above.