NOTE: The Card Diagnostics screen is only available in environments where the value of the EBT_OFFLINE business rule equals "Y".
Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The new GetCardNumberByStateWicId stored procedure was added to return the most recently created row from the EBTCARDSIGNATURE table matching the input parameter @STATEWICID.
The new V_EBTFoodInstrumentsIncludeVoids view was added to return a list of food instruments, including voids from the following tables: FOODINSTRUMENTSET, FOODINSTRUMENT, MEMBER, FOODINSTRUMENTITEM, ITEMPURCHASESIZE, FOODITEM, EBTISSUANCECROSSREF, FOODDISTRIBUTIONITEM and EBTFOODCATSUBCATEGORY.
A new Reset Failed Debit button was added to the Card Diagnostics screen.
The Card Number text and value label on the Card Diagnostics screen was changed to a text box which populates with the Smart Card number currently assigned to the household.
|
NOTE: The Card Diagnostics screen is only available in environments where the value of the EBT_OFFLINE business rule equals "Y". |