Leverage Extract File Date Fields to Filter Results

/in , , , , , , /by

The daily extract file imported into hosted ODP Manager includes many fields that may assist with managing an institution’s Overdraft Privilege program. These fields are used to show letters due and also to populate the standard suite of reports included in ODP Manager. In addition to these purposes, institutions may also benefit from using this data to display filtered results of accounts that share specified criteria. These additional filter options may facilitate monitoring of accounts in specific areas of interest.

The first step to leveraging additional filter and group options is to decide which fields and criteria should be applied to the accounts. Once determined, there are three main areas in ODP Manager that are able to use the additional filter groups: account-level Reports, Account Inquiry, and Custom Query.

Users can apply the filters as needed by typing the desired criteria in the filter boxes displayed below the ODP Manager header rows. If users are entering the same criteria regularly, it may be more efficient to request the creation of an institution-specific query group. Once the individual column filters have been applied or the query group selected, users can view the information in the browser, export the filtered results to either Excel or PDF in Reports, or to Excel in Account Inquiry and Custom Query.

In Account Inquiry, users can choose from three different views to select which extract file fields are available for filtering or export. Both the Default View and Original View display different sets of commonly used fields. The All Fields View displays all fields mapped and available in the hosted software.

If an institution’s users need to limit not only the results displayed but also specify which columns are included, a Custom Query can be created. This Custom Query can be downloaded daily (or as needed) to Excel and will include the accounts that meet the specified criteria.

If you have any questions about setting up additional filter groups in hosted ODP Manager, please contact Strunk Support at support@strunkaccess.com for more details.

An independent certified public accountant has examined Strunk’s operations and found them to be in compliance with the AICPA’s Trust Service Principles. It was determined that Strunk meets the Security, Availability, Processing Integrity, Confidentiality, and Privacy criteria for SOC 2 established by the AICPA.