Payment Data Export via Banner SFTP

The Payment Data Export via Banner SFTP feature automatically exports payment and violation data into a CSV file specifically formatted for integration with the Banner system. Its primary purpose is to ensure seamless financial data synchronization by appending the necessary detail codes and term codes to user transactions. This article is intended for OPS-COM administrators responsible for system configuration and financial integrations.

Setup and Configuration

There are several items that must be carefully configured across different system modules in order for the right information to display in the exported CVSCSV file.

Admin Side:

User Profile

 Configuration

1. In the user profile,Configure a unique user ID in the User Profile. must be configured.

   This information will likely be populated byautomatically via a user data import. 

   

Lot Administration

 Configuration

Each lot requires a unique banner detail code.

Toestablished setduring the bannerpreliminary detailplanning code,phase goof toyour project.

1. Hover over Lot Administration and click on Pricing & Lot Admin.

   

2. 
   

   SelectClick the lotspecific you wish to add the detail code to. Click on the lot name to access the configuration screens.

   

3. 
   

   Once you are in the lot configuration tool, selectClick the Additional tab.

   




4. Enter the required code into the Lot Detail Code. (These codes are established in the preliminary planning phase of the project)field.

5. Save your lot configuration changes.

Ticket Categories

 Configuration

1. From the Options Menu, hoverHover over Violations and select Ticket Categories (or Manage Ticket Categories).

   




2. Click Edit Edit on the Categorycategory you wish to configure.

   




3. Enter the detail code for the ticket category.

   category

   In(e.g., thisentering case, the Detail Code is PRKB for the Boot Fee category.category).

4. Save your category changes.

Sales Window

Configuration

OnYou must enter a Term Code specifically used for permits on the sales window configuration page, we need to enter a Term Code used for Permits only.

To dopage so goit to the Permits Menu and select Sales Windows

To access the configuration screen, click on EDIT.

Here you will enter the Term Code for the selected Sales Window that you want to appearappears on the permit purchases export.

1. Hover over Permits and select Sales Window.

2. 
   Click Edit to access the configuration screen for the desired window.

3. Enter the appropriate code in the Banner Term Code field.

4. Click the Save Changes button.

Activate Script to Run on a Schedule

1. YouClick mustView nowSystem ensureTask Logs from the Systemmain Taskoptions menu.

2. Ensure the associated system task is set to active and has an active schedule set.

   set

   In(e.g., verifying the Options menu, click on View System Task Logs.

   

   
   

   In this example, the Tasktask is set to run at 2:00 am Nightlynightly).

User Side: End-users do not interact with the setup or configuration of the Banner export. They simply select the appropriate payment method during checkout.

Using

Thethis User Portal

Feature

YouOnce areconfigured, nowthe setsystem toautomatically makehandles the data export based on your scheduled tasks. Administrators can verify the workflow by performing a paymenttest transaction on the user portal.

In this example, we will purchase

Performing a permit.

Test Transaction

1. GoNavigate to the user portal and click on the Permits menu item.

   

2. 
   

   Select the Lotlot you wish to purchase a permit in.

   

3. 
   

   Click

   Clickthe  Reserve Permit button.

   

4. 
   

   Click

   Continue to Checkout to view your Cart.cart.

   

5. 
   

   Select Banner Payment as your Paymentpayment Type.

   type.

   This can be configured so that Banner Payment is yourthe only selection available.available to the user.

   

6. 
   

   Click

   Clickthe Submit Payment.Payment button.

7. The screen will refresh to show theClick Confirm Payment page.

   Click on Confirm Payment.

   

   
   

   Once the paymentrefreshed isscreen processed,to youfinalize willthe gettransaction anand generate the online receipt.

   

---

Best Practices and Considerations

• Some additional information on howUnderstand the Banner export processtrigger: works:

  The

  Export to Banner process will run automatically whenever the system task is setscheduled to,to andexecute. It actively gathers any violations or payments that can be sent to bannerBanner that haven't been exported yet. WhenOnce aan violationitem has been exported by the system task, it hasis ainternally flag put on it that marks it has been exportedflagged to Banner.prevent duplicate exports.

• ItAnticipate willunique exportfile thegeneration: violationsThe it found into a new file, andsystem does not affect any previously output files, meaning it doesn't create a cumulative file that gets more data added to it each day. Rather, it creates a completely new CSV file every single time it runs;runs. thisThis interval isn't necessarily daily,daily; it runs at whatever intervalfrequency your organization has decided.

• Handle missed schedules carefully: If the clientsystem hastask decided for it.

  This would mean if they missedmisses a scheduled day, there wouldwill be more than one new file in the output folder for themyour team to process. Administrators must be prepared to process all pending files in Banner.Banner to ensure financial records are fully reconciled.