Rapid PayCard Cardholders Export

This export report is designed according to Rapid PayCard's specification requirements. It contains employee pay card information and can be exported to an Excel spreadsheet and saved as a CSV formatted file for uploading to Rapid PayCard's system.

Executable Formats

This report can be executed in the following format:

  • Excel

Accessing the Report

To access the Rapid PayCard Cardholders Export:

  1. From the Navigator, select Reporting.
  2. From the fly-out menu, select Reporting & Analytics.
  3. From Reporting & Analytics page, select System Reports in the Folder/Report navigator.
  4. In the System Reports folder, select the Financial Administration folder.
  5. In the Financial Administration folder, single-click on Rapid PayCard Cardholders Export and click on the Export Report icon and select XLS.. Alternatively, you can right-click on Rapid PayCard Cardholders Export and select Export As > and then XLS.

Filters

This report has two filters:

  • Routing Number: This is the Direct Deposit routing number.
  • Updated Date: The Updated Date of the Direct Deposit.

The following conditions are available:

  • Equal To: Data must be equal to the Value. There is only 1 Value option.
  • Not Equal To: Data must not be equal to the Value. There is only 1 Value option.
  • Less Than: Data must be before the Value alphabetically. There is only 1 Value option.
  • Less Than or Equal To: Data must be before or equal to the Value alphabetically. There is only 1 Value option.
  • Greater Than: Data must be later than the Value alphabetically. There is only 1 Value option.
  • Greater Than or Equal To: Data must be later or equal to the Value alphabetically. There is only 1 Value option.
  • Starts With (not available for Updated Date): Data must start with the Value. There is only 1 Value option.
  • Not Starts With (not available for Updated Date): Data must not start with the Value. There is only 1 Value option.
  • Ends With (not available for Updated Date): Data must end with the Value. There is only 1 Value option.
  • Does Not End With (not available for Updated Date): Data must not end with the Value. There is only 1 Value option.
  • Contains (not available for Updated Date): Data must contain the Value. There is only 1 Value option.
  • Does not Contain (not available for Updated Date): Data must not contain the Value. There is only 1 Value option.
  • Is Between (Default for Updated Date): Data/Date must be between the two selected Values alphabetically, numerically or date-wise (inclusive). There are two Value options.
  • Is Not Between: Data/Date must not be between the two selected Values alphabetically, numerically or date-wise (inclusive). There are two Value options.
  • Is One Of (Default for Routing Number): Data must match one of the selected Values. There are multiple Value options.
  • Is Not One of: Data must not match any of the selected Values. There are multiple Value options.

You have the following Value options:

For performance purposes the following two items should be noted when using the Values droplist. First, in order to enhance performance, once a value is selected, the droplist only displays those items alphabetically/numerically AFTER the selected item. To see all items again, delete the value (select it and press Delete on your keyboard) and then use the droplist. All items will display. Second, in order to enhance performance, the droplist only displays a set number of records. If the list of possible values is longer than the displayed list, select the name at the bottom of the list as the value. When you next click the droplist, the rest of the items display.

  • Double Values: To select two values, click the drop-list on each value. The top value corresponds to the "From" value and the bottom value corresponds to the "To" value.

  • Multiple Values: To select multiple values, click the drop-list on the top field to select a Value to add to the list. To see the items on the list, click the lower drop-list. To remove an item from the list, click the red X to the right of the item.

Report Actions

The report is a file designed for export purposes and therefore, creates an .xls file that can be viewed in Excel.