EBT Redemption Purchases:

Use the Message Builder in WIC Direct to simulate EBT redemption purchases.

  1. Ensure the HH has the appropriate benefits in SPIRIT and the HH has a PIN assigned to the HH in WIC Direct. (Core Interop may need to be restarted within the Services if it is not responding to pin entry.) (PIN may not be needed if doing a manual transaction.)
  2. In WIC Direct, go to Messages > Message Builder.
  3. Select Message Type = Saved Template and then select Purchase w/ DC Merchant.
  4. Update Card Number field appropriately and then click Update.
  5. Update Date fields in line 7 and 12 to today and click Update for each one.
  6. Determine which food item will be redeemed.
  7. Using another WIC Direct session, go to the Products screen.
  8. Select the Category and Subcategory for the item to be redeemed (for example 03 – Eggs, 001 - dozen Large White Eggs).
  9. Copy a UPC/PLU number from the results for an item that is ACTIVE.
  10. NOTE: When choosing a UPC, if selecting an item from 000 broadband category, ensure the item is marked as Allow Broadband = Yes.
  11. Also ensure the Exchange Size is less than or equal to the Qty issued.
  12. Back on the Message Builder, remove the defaulted UPC product from the Selected Products section.
  13. Paste the copied UPC/PLU number in the appropriate field, enter Price and a valid Quantity.
  14. Click Add Product and then Update.
  15. Some state agencies can be done as a Manual transaction. If so, click the Manual Transaction link and then Update.
  16. If not then from #53, enter the HH PIN, set KSN = 987654 with BDK = 0123456789ABCDEFFEDCBA9876543210.
  17. Click Update.
  18. Click Build Message, then Message Sender.
  19. Select a Built-In Installation and then click Send Message.
  20. Click Message Reader to check if message was sent successfully or if there were errors. (NOTE: all checkmarks must be green, if any are red, then the message failed.)

The transaction can be verified in the retail_transaction_history table within the WIC Direct database.

Redemption File job can be executed to process transactions from the prior day. If the test transactions from today are needed for that job, then either the WIC Direct server date must be updated to tomorrow’s date before running the job or then all dates stored in the database records for those transactions must be updated to yesterday’s date.

Records for the transaction are stored in the below tables within the EBTCore database:

clinic_transaction_history

retail_transaction_history

transaction_history_raw

NOTE: If the Redemption File job fails, it could be looking for an ARF file. Update the institution_type_id field in the institution table for the FIS record to match an id for a Gateway Non-MoS, instead of a Gateway MoS. This is a temporary solution to ignore the ARF file requirement and should be updated back when testing is completed.

If Redemption File job is complete, this will generate the redemption file (.rxml) into the Outbox folder and then copies the file to Outbox Archive of the corresponding state agency folder within the WIC Direct FTP share.

(For example: \\172.30.105.122\ftpshare$\w11\Outbox_Archive)

WEM & SPIRIT Process

  1. Log on to the WEM server.
  2. Run the WEM Downloads task from the Task Scheduler until completed. This will drop the rxml file in the File Processing inbox on the WEM Server.
    (For example: D:\Program Files (x86)\WIC EBT Middleware\Managed Files\CN\ProxyInbox)
    NOTE: This processing happens instantly so the file may be gone from this location upon viewing.
    And then generates the WEM processed file in the File Processing outbox on the WEM Server.

(For example: D:\Program Files (x86)\WIC EBT Middleware\Managed Files\CN\Outbox)

XXWURDYYMMDD00 - WIC Benefit Redemption File

(Note: Replace XX with the program ID and replace YYMMDD with the today’s date.)

  1. Execute EOD from the WEM server for that state agency until completed. The file is removed from the WEM outbox and processed by SPIRIT. (WURD)
  2. Log on to the SPIRIT database for the matching environment and state agency.
  3. Query the FoodInstrumentItemRedeemed and FoodInstrumentItemRedeemed_Aggregated tables for the redemption records just processed. Ensure data is populated correctly from the .rxml file.
  4. Open SPIRIT and open participant folder for the participant that had item redeemed. Open the EBT Transaction History screen and search for the redemption record and view the Details. Transaction displays with correct redemption data.