Exception History

Contents Show

Concepts Show

The Exception History screen is used to access bank exception history records for viewing and exporting to Excel.

Exception History screen

Screen Access

Screen Access

Interface Initialization

Upon initial display of the screen, the following occurs:

  • The title bar text is set to "Exception History".

  • The Action drop-down list box is enabled and defaults to "All".

  • The Exception Reason drop-down list box is enabled and defaults to "All".

  • The Bank Exceptions data grid is enabled and blank.

  • All other data controls are enabled and blank.

  • The first row in the data grid is initially selected as the default.

  • The Bank Reconciliation button is visible and enabled.

  • The Process Banking File button is visible and enabled.

  • The Exception History button is visible and enabled.

  • The Export to Excel button is visible and enabled as the default.

  • The Resolve Exception button is visible and disabled.

  • The Close button is visible and enabled as the default.

Screen Elements

Unless otherwise stated below, all controls on the Exception History screen are visible and enabled when:

If one or more special conditions exist that affect a control on the Exception History screen, the condition(s) are documented for that specific control below.

Search Criteria group box

  Complete the information in the Search Criteria group box.

This group box includes controls that allow you to perform a search and/or filter the list of results displayed in the data grid. The title text of the group box is set to "Search Criteria". The group box consists of the following control(s):

Benefit Number text box

Enter the partial or complete benefit number from a single benefit as search criteria in this text box.

The text box allows the entry of numeric characters only. The maximum number of characters that can be entered in this text box is eight (8).

Paid Date group box

This group box includes controls that allow you to specify the paid date range. The title text of the group box is set to "Paid Date". The following controls are included in the group box:

From calendar control

Select or enter the date of the starting date range in this calendar control.

The From date entered must be less than or equal to the To date entered. If it is not, a standard error message (E0047) displays when the screen is processed.

The date selected or entered must be less than or equal to the current system date. If it is not, a standard error message (E0008) displays when the screen is processed.

To calendar control

Select or enter the date ending the date range in this calendar control.

Action drop-down list box

Select the action that spawned the history record for which to search in this drop-down list box.

The drop-down list box is populated with entries from the Reference Dictionary where category = "BnkExcptAction" and an entry of "All".

Status radio button group

This radio button group includes controls that allow you to search for and return records from the BankExceptions table. The title text of the radio button group is set to "Status". The following radio buttons are included in the radio button group:

Quarantine Date group box

This group box includes controls that allow you to specify the quarantine date range. The title text of the group box is set to "Quarantine Date". The following controls are included in the group box:

From calendar control

Select or enter the date of the starting date range in this calendar control.

The From date entered must be less than or equal to the To date entered. If it is not, a standard error message (E0047) displays when the screen is processed.

The date selected or entered must be less than or equal to the current system date. If it is not, a standard error message (E0008) displays when the screen is processed.

To calendar control

Select or enter the date ending the date range in this calendar control.

Exception Reason drop-down list box

Select the exception reason for which to search in this drop-down list box.

The drop-down list box is populated with entries from the Reference Dictionary where category = "BnkExcptReason" and an entry of "All".

Search button

Click the Search button to perform a search and filter the results displayed in the data grid based on the filter criteria specified.

When Search is clicked, the data grid refreshes and displays results that match the specified filter criteria.

It has a mnemonic of "S".

If no records can be found to match the specified search criteria, a standard error message (E0050) displays when the button is clicked.

Exception History data grid

  View the information in the Exception History data grid.

This data grid contains a list of the bank exceptions with paid dates in the month selected in the drop-down list box. There is no title text for this data grid. It is read-only and allows a single selection. Bank exceptions are initially sorted in ascending order by History Date.

The data grid consists of the following control(s):

History Date column

This column displays the date of the exception for each record displayed within the data grid.

The title of the column is set to "History Date". The information displayed within the column is read-only.

Action column

This column displays the action taken for the exception for each record displayed within the data grid.

The title of the column is set to "Action". The information displayed within the column is read-only.

Benefit Number column

This column displays the food instrument benefit number for each record displayed within the data grid.

The title of the column is set to "Benefit Number". The information displayed within the column is read-only.

Exception Reason column

This column displays the reason for the bank exception for each record displayed within the data grid. The values come from the Description column of the Reference Dictionary table where the value in the ExternalID column matches the value in the ErrorMessageID column of the BankExceptions table.

The title of the column is set to "Exception Reason". The information displayed within the column is read-only.

Stamp Number column

This column displays the vendor stamp number for each record displayed within the data grid.

The title of the column is set to "Stamp Number". The information displayed within the column is read-only.

Paid Date column

This column displays the paid date of the bank exception or food instrument benefit for each record displayed within the data grid. For bank exceptions, the value come from the PaidDate column of the BankExceptions table.

The title of the column is set to "Paid Date". The information displayed within the column is read-only. It is formatted as MM/DD/CCYY.

Quarantine Date column

This column displays the quarantine date for each record displayed within the data grid.

The title of the column is set to "Quarantine Date". The information displayed within the column is read-only.

Reapply column

This column displays the information on reapplied bank exceptions displayed within the data grid. The values come from the ReapplyInd column of the BankExceptions table.

The title of the column is set to "Reapply". The information displayed within the column is read-only.

Active column

This column displays the active status for each record displayed within the data grid.

The title of the column is set to "Active". The information displayed within the column is read-only.

Banking File column

This column displays the name of the banking file associated with the record for each record displayed within the data grid.

The title of the column is set to "Banking File". The information displayed within the column is read-only.

Export to Excel button

  Click the Export to Excel button to export the entries in the data grid to an Excel file.

A Windows Save File As screen displays when the button is clicked.

The control is enabled when:

It has a mnemonic of "E".

Close button

  Click the Close button to close the screen.

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

The Bank Exceptions screen displays when the button is clicked.

Processing

If data can be validated and saved on the screen, the following processes occur when the screen is processed:

If no data can be validated and saved on the screen:

Data Map

The Data Map defines the values saved for all controls on the screen. If available, any additional notes or comments are displayed in the Notes column.

Control Label

Required

Table

Column

Notes

·

·

·

·

·

·

·

·

·

·

|

Vendor