2.40.00 Release Notes

Contents Show

Changes made in this release of the software are detailed below.

Files Included in This Release

The following files are included with this release of the software:

WIC EBT Middleware

A new version of the WIC EBT Middleware (WEM) software is available with this release. This version contains the following code updates:

Features Added:

Special Instructions

The current version of BatchProcessor included in this release requires SQL Server version 2012 or higher.

Prior to upgrading to this release of the software, verify that the WEM outbox folder is empty. This folder can be identified by looking at the FILERECEIVEPATH column within the EBTCONNECTIONINFO table.

States/ITOs should run End of Day and End of Month processes in the following order:

Reminders for states switching to WUMEI file types:

The UniversalServiceOverrideTerminationDate setting must be set to FALSE in the wem.config file within WEM configuration folder. Failing to do so may terminate all vendors. For more information, see the WEM Configuration topic.

Note

NOTE: Manually sending files to the EBT Processor system is supported for JPM file types only, where the value of the FileType row equals "0" within the EBTCONNECTIONINFO table of the database. WUMEI file types must be sent using End of Day Command Line Batch Processing.

Enhancements

The table below documents software enhancements included within this release of the software.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

157451 SPIRIT Web-147040

End of Day Command Line Batch Processing support in SPIRIT Web

The SPIRIT WIC system was modified as follows:

  • The SetAllTerminatedMembers stored procedure was added to support Member Adjustments/Archives/Purges Service Processing within the BatchProcessor in the SPIRIT Web environment. This stored procedure does not run in the SPIRIT WIC Desktop environment.

No DFDD or Database changes were made that impact the SPIRIT WIC Desktop environment.

157443 SPIRIT Web-150036

DFDD Changes Database Changes

End of Day Command Line Batch Processing

inbound files

Previously, the End of Day Command Line Batch Processing used the file name to identify prior-processed inbound files for the following imported files:

  • Expired Benefits File

  • UPC/PLU Redemption File

  • WIC Activity File

This process occasionally resulted in duplicate records being written to the SPIRIT database, such as when an import process failed and the files were imported again.

The SPIRIT WIC system End of Day Command Line Batch Processing was modified as follows:

  • Import files will be identified using an existing identifier in the header row of the import file. For JPM file types, this is the control number. For WUMEI file types, this is the file sequence number.

  • When the End of Day Command Line Batch Processing imports a file that has not previously been processed based on the control number / file sequence number, it will add new records to the associated tables.

  • When the End of Day Command Line Batch Processing imports a file that has previously been processed based on the control number / file sequence number, it will replace previously-added records within the associated tables with the current file data.

For more information, see the DFDD Changes and the database changes for this enhancement.

158339 SPIRIT Web-150801

DFDD Changes Database Changes

End of Day Command Line Batch Processing support for outbound files

The SPIRIT WIC system was modified as follows:

  • The InsertEbtTransactionLog stored procedure was updated to improve the process of obtaining a unique control number / file sequence number for outbound files processed during End of Day Command Line Batch Processing. For JPM file types, this is the control number. For WUMEI file types, this is the file sequence number.

  • A new UpdateLastTransmitDate stored procedure was created to improve the process of recording transmission data for outbound files processed during End of Day Command Line Batch Processing.

For more information, see the DFDD Changes and the database changes for this enhancement.

157450 SPIRIT Web-152726

DFDD Changes

File Processor Upgrade

The SPIRIT WIC system file processor was updated to version .NET 3.1 to improve the efficiency of End of Day Command Line Batch Processing and End of Month Command Line Batch Processing.

For more information, see the DFDD Changes for this enhancement. No database changes were required.

Reported Issues

The table below documents issues fixed within this release of the software.

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

CDP-132

Electronic Benefit Transfer (EBT)

SPIRIT received an error when attempting to place an EBT account on hold in the Solutran eWIC interface.

The SPIRIT WIC system was modified to change the order of the Household Unlock, Household Data, and Household Lock calls sent to the EBT Processor when the Send EBT Data button is clicked.

The SPIRIT WIC system now functions correctly with the Solutran eWIC interface when placing an EBT account on hold.

No DFDD or database changes were required. For additional information, see the WIC EBT Middleware change described above.

CDP-332

Electronic Benefit Transfer (EBT)

The EBT Household Change Guided Script displayed a DT1315 error when a participant was transferred from a household with no EBT card assigned.

The SPIRIT WIC system EBT Household Change Guided Script was modified to correctly transfer participants from a household with no EBT card assigned.

No DFDD or database changes were required.

CDP-356

Maximum Allowed Reimbursement (MAR) calculations

The MARs did not calculate properly when the unit of measure is not a whole unit.

The SPIRIT WIC system was modified by SPIRIT Web-12655 in Release 2.38 to improve UPC/PLU Redemption File processing for WUMEI file types. The End of Month Command Line Batch Processing now properly performs Maximum Allowed Reimbursement (MAR) calculations for WUMEI file types.

No additional DFDD Changes or Database Changes were required.

CDP-386

Maximum Allowed Reimbursement (MAR) prices

Price adjustments made on the Approve New MAR Prices screen did not display on the Override MAR Prices screen until the day after they were entered.

The SPIRIT WIC system was modified to now display updated Maximum Allowed Reimbursement (MAR) prices on the Override MAR Prices screen on the date they are entered.

For more information, see the Database Changes for this reported issue. No DFDD changes were required.

CDP-393

Issue Benefits

The user group requested clarification on the error message received when issuing benefits for an item without an associated category / subcategory.

The SPIRIT WIC system was modified to now display the correct message when issuing benefits for an item without an associated category / subcategory.

No DFDD or database changes were required.

CDP-403

Void/Replace Benefits for EBT Account

The user group requested clarification on the Benefits for Current Month data grid regarding shared benefits.

The SPIRIT WIC The SPIRIT WIC Detailed Functional Design Document (DFDD) was modified to reflect the user group comments in CDP-403.

For more information, see the DFDD Changes for this reported issue. No database changes were required.

CDP-410

Issue Benefits

The EBTISSUANCECROSSREF table contained records that targeted the same FOODINSTRUMENTSETID value.

The SPIRIT WIC system was modified to now handle long values in the FOODINSTRUMENTSETID column of the EBTISSUANCECROSSREF table without error.

No DFDD or database changes were required.

CDP-427

Redemption File

The Redemption File import process rounded values to whole numbers, which caused inaccuracies in MAR calculations.

The SPIRIT WIC system was modified by SPIRIT Web-12655 in Release 2.38 to improve UPC/PLU Redemption File processing for WUMEI file types. The End of Month Command Line Batch Processing properly performs Maximum Allowed Reimbursement (MAR) calculations for WUMEI file types.

No additional DFDD Changes or Database Changes were required.

CDP-439

Account Balance Report (Output)

The Account Balance Report (Output) incorrectly included recovered formula in the household balance after a formula change.

The SPIRIT WIC system was modified to remove recovered formula from the the household balance after a formula change. The Account Balance Report (Output) now displays the correct amount.

No DFDD or database changes were required.

CDP-456

Release 2.38

The aSQL file for Release 2.38 incorrectly changed all VENDORTYPE column values to "I".

The SPIRIT WIC system aSQL file was modified to correct this error. It now functions correctly.

For more information, see the Database Changes for this reported issue. No DFDD changes were required.

CDP-463

End of Month Command Line Batch Processing

The create date and modify date were not considered while calculating the CASELOAD and CASELOADCOUNTENROLLMENT data during End of Month Command Line Batch Processing.

The SPIRIT WIC system was modified to preserve create dates and modify dates while calculating the CASELOAD and CASELOADCOUNTENROLLMENT data during End of Month Command Line Batch Processing. It now functions correctly.

For more information, see the DFDD Changes and the Database Changes for this reported issue.

CDP-464

End of Month Command Line Batch Processing

An unexpected error message displayed when running Run End of Month Command Line Batch Processing before the end of the month.

The SPIRIT WIC system was modified to correct an error in the Run End of Month Command Line Batch Processing. If the process is run before the end of the month, it now displays the correct error message.

For more information, see the Database Changes for this reported issue. No DFDD changes were required.

ENH-629

End of Month Command Line Batch Processing

Extra rows were found in the CASELOADCOUNT table when testing End of Month Command Line Batch Processing.

The SPIRIT WIC system was modified by ENH-625 in Release 2.39.01 to ensure food item counts are correct.

However, another issue was discovered while investigating this reported issue. The SPIRIT WIC system was modified to correctly prioritize checks during Run End of Month Command Line Batch Processing. It now correctly reports participation data when multiple checks are issued during a month.

For more information, see the Database Changes for this reported issue. No DFDD changes were required.

TMP-379

Electronic Benefit Transfer (EBT)

The EBT Account Balance Report (Output) displayed incorrect information when a food prescription was modified.

The SPIRIT WIC system was modified to include benefits on the Account Balance Report (Output), even if a food prescription does not exist for the participant. It now functions correctly.

For more information, see the Database Changes for this reported issue. No DFDD changes were required.

TMP-385 SPIRIT Web-153511

End of Day Command Line Batch Processing

The vendor file extension option was missing in the EBTCONNECTIONINFO table.

The SPIRIT WIC system End of Day Command Line Batch Processing was modified as follows:

  • A file type extension was added to the EBTCONNECTIONINFO table for the Authorized Vendor File and the UPC/PLU Redemption File.

  • The file naming convention was updated for WUMEI file types to expand user-defined file names, including a date field for the export files.

The EBTCONNECTIONINFO table now contains the vendor file extension row.

For more information, see the DFDD Changes and the Database Changes for this reported issue.

Bug-160922

Manually sending files to the EBT Processor system

Errors occurred during internal testing when attempting to manually send WUMEI files to the EBT Processor system.

The SPIRIT WIC system was not modified. However, notes were added to these release notes and to the DFDD to advise users of functionality constraints.

For more information, see the DFDD Changes for this reported issue. No Database Changes were required.

DFDD Updates

The table below documents changes made to the SPIRIT WIC Detailed Functional Design Document (DFDD) for this release of the software.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

157443 SPIRIT Web-150036

Code Changes

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for SPIRIT Web-150036 are documented below.

The following topics were updated to describe replacing the "filename" parameter with a new "FILESEQUENCENUMBER" parameter:

  • Redemption Processing within the BatchProcessor

  • Expired Benefits File Processing within the BatchProcessor

  • WIC Activity File Processing within the BatchProcessor

158339 SPIRIT Web-150801

Code Changes

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for SPIRIT Web-150801 are documented below.

The following topics were updated in the SPIRIT Database Processing section to reflect changes to the InsertEbtTransactionLog stored procedure:

  • Approved Product List (APL) Processing within the BatchProcessor

  • Authorized Vendor File Processing within the BatchProcessor

  • Category/Sub-category Processing within the BatchProcessor

The following topics were updated in the SPIRIT Database Processing section to reflect the new UpdateLastTransmitDate stored procedure which replaced the UpdateEbtConnectionInfoParameters stored procedure:

  • Approved Product List (APL) Processing within the BatchProcessor

  • Category/Sub-category Processing within the BatchProcessor

157450 SPIRIT Web-152726

Code Changes

Appendix

(busrule.chm) and (apndxe.chm)

Changes to the Appendix DFDD for SPIRIT Web-152726 are documented below.

All topics with references to the renamed topics listed in the Scheduled Job Administration DFDD row below were updated to reflect the new names.

The Create a Scheduled Task for End of Day and Create a Scheduled Task for End of Month topics were updated to modify the instructions for the New Action screen and renamed the "BatchProcessor.dll" file as "BatchProcessor.exe".

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for SPIRIT Web-152726 are documented below.

The following topics were renamed to replace "BatchProcessor.dll" with "BatchProcessor":

  • Appointment Reminder Service Processing within the BatchProcessor

  • Approved Product List (APL) Processing within the BatchProcessor

  • Authorized Vendor File Processing within the BatchProcessor

  • BatchProcessor Logging Processes

  • BatchProcessor Processing

  • Category/Sub-category Processing within the BatchProcessor

  • Duplicate Participant Service Processing within the BatchProcessor

  • Expired Benefits File Processing within the BatchProcessor

  • MAR Calculation Processing within the BatchProcessor

  • Member Adjustments/Archives/Purges Service Processing within the BatchProcessor

  • Peer Group Reassessment Processing within the BatchProcessor

  • Pending Vendor Disqualifications Service within the BatchProcessor

  • Redemption Processing within the BatchProcessor

  • Reset Probations Service Processing within the BatchProcessor

  • Sanction Points Service Processing within the BatchProcessor

  • Vendor Services Processing within the BatchProcessor

  • WIC Activity File Processing within the BatchProcessor

  • WIC Activity Reconciliation Processing within the BatchProcessor

All topics with references to the renamed topics listed above were updated to reflect the new names.

The following topics were updated with one or more changes described below:

  • Approved Product List (APL) Processing within the BatchProcessor

  • Authorized Vendor File Processing within the BatchProcessor

  • BatchProcessing_Core.zip Installation and Configuration

  • BatchProcessor Logging Processes

  • BatchProcessor Processing

  • Calculate UPC Maximum Allowable Reimbursement (MAR) Values

  • Category/Sub-category Processing within the BatchProcessor

  • Create Environment Variables within the Windows Operating System

  • Expired Benefits File Processing within the BatchProcessor

  • Pending Vendor Disqualifications Service within the BatchProcessor

  • Redemption Processing within the BatchProcessor

  • Run End of Day Command Line Batch Processing

  • Run End of Month Command Line Batch Processing

  • Sanction Points Service Processing within the BatchProcessor

  • SPIRIT Import Files

  • Vendor Services Processing within the BatchProcessor

  • WIC Activity File Processing within the BatchProcessor

  • WIC Activity Reconciliation Processing within the BatchProcessor

The following changes were made to the topics listed above, as applicable:

  • Removed the requirement to install .NET Core Runtime and .NET Core SDK.

  • Renamed the "BatchProcessor.dll" file as "BatchProcessor.exe" or "BatchProcessor"

  • Renamed the "dotnet BatchProcessor.dll -EOD [CN]" command as "BatchProcessor.exe -EOD [CN]".

  • Renamed the "dotnet BatchProcessor.dll -Test [CN]" command as "BatchProcessor.exe -Test [CN]".

  • Renamed the "dotnet BatchProcessor.dll -setConnectionString "[connectionString]" [CN] command as "BatchProcessor.exe -setConnectionString "[connectionString]" [CN]".

  • Renamed the "dotnet BatchProcessor.exe -EOM [CN]" command as "BatchProcessor.exe -EOM [CN]"

  • Updated command line images.

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for SPIRIT Web-152726 are documented below.

All topics with references to the renamed topics in the Scheduled Job Administration DFDD row listed above were updated to reflect the new names.

Vendor

(vendor.chm)

Changes to the Vendor DFDD for SPIRIT Web-152726 are documented below.

All topics with references to the renamed topics in the Scheduled Job Administration DFDD row listed above were updated to reflect the new names.

CDP-403

Code Changes

Clinic

(clinic.chm)

Changes to the Clinic DFDD for CDP-403 are documented below.

The Void/Replace Benefits for EBT Account topic, Benefits for Current Month data grid description was updated with exact phrasing from the customer.

CDP-463

Code Changes

Scheduled Job Administration

(jobadmn.chm)

No changes were required for CDP-463. However, an error was discovered in the Scheduled Job Administration DFDD related to this issue.

The Run End of Month Command Line Batch Processing topic was updated in step 2 of the SPIRIT .NET Processing section to state that the InsertIntoCaseLoadCountRebateItems stored procedure updates the CASELOADCOUNTREBATEITEMS table.

TMP-385 SPIRIT Web-153511

Code Changes

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for SPIRIT Web-153511 are documented below.

The following topics were updated to describe a new naming syntax for WUMEI file types to expand user-defined export file names, including new variables and a new date time format:

  • Approved Product List (APL) File

  • Authorized Vendor File

  • Category/Sub-category File

The following topics were updated to describe new file type extensions that were added to the EBTCONNECTIONINFO table for the Authorized Vendor File and the UPC/PLU Redemption File:

  • Authorized Vendor File

  • Authorized Vendor File Processing within the BatchProcessor

  • UPC/PLU Redemption File

  • Redemption Processing within the BatchProcessor

  • BatchProcessing_Core.zip Installation and Configuration

  • Run End of Day Command Line Batch Processing

Bug-160922

Code Changes

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for Bug-160922 are documented below.

The EBT UPC Actions menu topic was updated to add the following note:

Note

NOTE: Manually sending files to the EBT Processor system is supported for JPM file types only, where the value of the FileType row equals "0" within the EBTCONNECTIONINFO table of the database. WUMEI file types must be sent using End of Day Command Line Batch Processing.

Vendor

(vendor.chm)

Changes to the Vendor DFDD for Bug-160922 are documented below.

The File menu topic was updated to add the following note:

Note

NOTE: Manually sending files to the EBT Processor system is supported for JPM file types only, where the value of the FileType row equals "0" within the EBTCONNECTIONINFO table of the database. WUMEI file types must be sent using End of Day Command Line Batch Processing.
 

Appendix

(apndxe.chm)

The following new topics were updated in Appendix G:

  • SWEM Smart Card Reader-Writer

  • Smart Card Reader Process Flows
 

DFDD

(wicdfdd.chm)

For this release, the title bar of the Detailed Functional Design Document (DFDD) was updated to reflect build version "2.40.00". Additionally, the footer was also updated to reflect software version "2.40.00".

|

Documentation Delivery Date: 01/25/2021