2.34.00 Release Notes

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-605

End of Day Process

Within the SPIRIT WIC system, the End of Day Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Approved Product List (APL) File and Category/Sub-category File processing.

R1: Ensure that the new EOD processes correctly and updates the appropriate records for the following:

• UPC / PLU File

• Cat/Subcat File

To accommodate the R1 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing against the new BatchProcessor.dll to ensure that the appropriate tables are updated after the process is run.

R2: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied.

To accommodate the R2 requirement for this enhancement, the following new stored procedures were created and distributed with this release of the software:

• GetUPCAPLExportFileRecords

• UpdateEbtConnectionInfoParameters

• InsertEbtTransactionLog

• LoadCatSubcatFile

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

R3: The legacy EOD process shall discontinue the creation of these files.

To accommodate the R3 requirement for this enhancement, changes to End of Day Processing for ENH-605 removed Approved Product List (APL) File and Category/Sub-category File processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.34.00 release of the SPIRIT WIC system, Approved Product List (APL) File and Category/Sub-category File processing now occurs only during End of Day Command Line Batch Processing.

R4: The UPC / PLU File can be triggered independently of the EOD process.

To accommodate the R4 requirement for this enhancement, the new BatchProcessor.dll file delivered with this release of the software executes Approved Product List (APL) File processing from the Command Prompt.

R5: The Cat / Subcat File can be triggered independently of the EOD process.

To accommodate the R5 requirement for this enhancement, the new BatchProcessor.dll file delivered with this release of the software executes Category/Sub-category File processing from the Command Prompt.

R6: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition.

To accommodate the R6 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R7: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD/EOM.

To accommodate the R7 requirement for this enhancement, the prerequisite processes continue to run as intended.

R8: CDP shall document within the release notes that states will need to run their existing EOD/EOM prior to running the new EOD/EOM and generate the UPC/PLU File and the Cat/Subcat File from both processes for testing or comparing the old results with the new.

To accommodate the R8 requirement for this enhancement, states should process the Approved Product List (APL) File and Category/Sub-category File during the End of Day Process in the Scheduled Job Administration application module prior to upgrading to release 2.34.00.

ENH-606

End of Day Process

Within the SPIRIT WIC system, the End of Day Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Authorized Vendor File processing.

R1: Ensure that the new EOD processes correctly and updates the appropriate records for the following:

• Authorized Vendor File

To accommodate the R1 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing against the new BatchProcessor.dll to ensure that the appropriate tables are updated after the process is run.

R2: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied.

To accommodate the R2 requirement for this enhancement, the following new stored procedure was modified and distributed with this release of the software:

• GetJPMVendorExportList

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

R3: The legacy EOD process shall discontinue the creation of these files.

Changes to End of Day Processing for ENH-606 removed Authorized Vendor File processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.34.00 release of the SPIRIT WIC system, Authorized Vendor File processing now occurs only during End of Day Command Line Batch Processing.

R4: The Authorized Vendor File can be triggered independently of the EOD process.

To accommodate the R4 requirement for this enhancement, the new BatchProcessor.dll file delivered with this release of the software executes Authorized Vendor File processing from the Command Prompt.

R5: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition.

To accommodate the R5 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R6: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD/EOM.

To accommodate the R6 requirement for this enhancement, the prerequisite processes continue to run as intended.

R7: CDP shall document within the release notes that states will need to run their existing EOD/EOM prior to running the new EOD/EOM and generate the Authorized Vendor File from both processes for testing or comparing the old results with the new.

To accommodate the R7 requirement for this enhancement, states should process the Authorized Vendor File during the End of Day Process in the Scheduled Job Administration application module prior to upgrading to release 2.34.00.

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

CDP-61

EBT Transaction History Detail

A "UPC Not Found" description displayed in the UPC Description column within the Transaction Details data grid on the following screens:

• EBT Transaction History Detail (Central Administrative Site)

• EBT Transaction History Detail (Clinic)

• EBT Transaction History Detail (State Office)

The SPIRIT WIC system was only retrieving UPC records from EBTAUTHORIZEDUPC table that contained a distribution item ID.

The SPIRIT WIC system was modified to retrieve and store in a dataset all UPC records from the EBTAUTHORIZEDUPC table, regardless of the values in the DISTRIBUTIONITEMID column of the EBTAUTHORIZEDUPC table.

For more information about the new dataset, see the changes made for CDP-296.

CDP-228

EBT Transaction History

Transactions that occurred on or after 1:00 PM displayed with an AM time stamp on the following screens:

• EBT Transaction History (Central Administrative Site)

• EBT Transaction History (Clinic)

• EBT Transaction History (State Office)

To resolve this issue, the default value of the Standard Time Format text box in the WEM Configuration Manager must be modified on the WIC EBT Middleware (WEM) server.

CDP-262

Authorized Vendor File

When changes were made to a vendor's folder, the changes were not successfully transmitted to or updated in the EBT Processor system.

This reported issue was resolved as part of the enhancements made for the ENH-606 change request.

CDP-296

EBT Transaction History

A "System.OutOfMemoryException" error occurred when attempting to display the following screens:

• EBT Transaction History (Central Administrative Site)

• EBT Transaction History (Clinic)

• EBT Transaction History (State Office)

The SPIRIT WIC system was modified as follows:

• The current data retrieval process was modified to store data in a dataset rather than the legacy business object. The new dataset retrieves data from the following columns of the EBTAUTHORIZEDUPC table of the database:

• UPCCD

• UPCDESCRIPTION

• A new service call was added to load all UPC codes and descriptions into the new dataset when the View Details button is clicked for the first time on the following screens:

• EBT Transaction History (Central Administrative Site)

• EBT Transaction History (Clinic)

• EBT Transaction History (State Office)

• Code was added to load data from the new dataset into a new dictionary.

• The following screens were modified to use the new dictionary (instead of the current function) to populate the value(s) displayed in the UPC Description column of the Transaction Details data grid:

• EBT Transaction History Detail (Central Administrative Site)

• EBT Transaction History Detail (Clinic)

• EBT Transaction History Detail (State Office)

The changes noted above are behind-the-scenes changes that do not visibly change the SPIRIT WIC system's user interface (UI).

CDP-314

Generate Reports

When the Print EBT Account Balance menu option was selected on the Benefit Management menu, an unhandled exception error occurred.

The SPIRIT WIC system was modified to add Try/Catch logic to ensure that exceptions generated by the Microsoft.Office.Interop.Word assembly display properly.

CDP-369

SPIRIT Database

When a new vendor was created and saved in the Vendor Online Application, the APLTYPE column was not updated in the VENDOR table for the newly-created vendor.

The SPIRIT WIC system was modified to set the value of the APLTYPE column to "1" in the VENDOR table of the SPIRIT WIC database whenever a new vendor is created and the Next or Save buttons are clicked on the Business Information screen in the Vendor Online Application.

CDP-383

Override MAR Prices

In the Vendor application module, when a MAR price was denied on the Approve New MAR Prices screen, the denied MAR price could not be overridden on the Override MAR Prices screen.

The SPIRIT WIC system was modified to convert the in-line SQL on the Override MAR Prices screen into a new SaveNewMar stored procedure, which allows a denied MAR price to be overridden as expected.

For more information about MAR processing, refer to the Maximum Allowed Reimbursement (MAR) Process Flow topic in the Scheduled Job Administration DFDD.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

ENH-605

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for EOD-3 are documented below.

Approved Product List (APL) File

In the tutorial within the BatchProcessing_Core.zip Installation and Configuration topic, the Update the EBTCONNECTIONINFO table step was updated to include EBTCONNECTIONINFO table requirements for the Approved Product List (APL) File.

A new Approved Product List (APL) Processing within the BatchProcessor topic was added to document the Approved Product List (APL) processing that occurs when the BatchProcessor.dll is run.

Within the DFDD's Table of Contents (TOC) (Scheduled Job Administration -> Scheduled Job Administration -> End of Day Processing -> End of Day Command Line Batch Processing -> BatchProcessor.dll Process Flow), a new page was added for the new Approved Product List (APL) Processing within the BatchProcessor topic.

The Approved Product List (APL) File topic was updated as follows:

• The introduction at the top of the topic was expanded to include a hypertext link to the new Approved Product List (APL) Processing within the BatchProcessor topic.

• Previously-missing data elements were added and the File Mapping from SPIRIT Database (Table. Column) column was populated in the Detail Record section.

• The file naming conventions section was updated to document how the file is named when generated and where the file is sent during BatchProcessor Processing.

The Run End of Day Command Line Batch Processing topic was updated as follows:

• The sample error section was updated to include EBTCONNECTIONINFO table requirements for the Approved Product List (APL) File.

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new Approved Product List (APL) Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for Approved Product List (APL) File processing.

Category/Sub-category File

In the tutorial within the BatchProcessing_Core.zip Installation and Configuration topic, the Update the EBTCONNECTIONINFO table step was updated to include EBTCONNECTIONINFO table settings for the Category/Sub-category File.

A new Category/Sub-category Processing within the BatchProcessor topic was added to document the category/sub-category file processing that occurs when the BatchProcessor.dll is run.

Within the DFDD's Table of Contents (TOC) (Scheduled Job Administration -> Scheduled Job Administration -> End of Day Processing -> End of Day Command Line Batch Processing -> BatchProcessor.dll Process Flow), a new page was added for the new Category/Sub-category Processing within the BatchProcessor topic.

The Category/Sub-category File topic was updated as follows:

• The introduction at the top of the topic was expanded to include a hypertext link to the new Category/Sub-category Processing within the BatchProcessor topic.

• Previously-missing data elements were added and the File Mapping from SPIRIT Database (Table. Column) column was populated in the Detail Record section.

• The file naming conventions section in the topic was updated to document how the file is named when generated and where the file is sent during BatchProcessor Processing.

The Run End of Day Command Line Batch Processing topic was updated as follows:

• The sample error section was updated to include EBTCONNECTIONINFO table requirements for the Category/Sub-category File.

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new Category/Sub-category Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for Category/Sub-category File processing.

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for ENH-605 are documented below.  This change was made in Release 2.36 on 7/26/19.

The EBT UPC Actions menu topic was updated to include the following note in the Send UPC File to EBT System section:

ENH-606

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for ENH-606 are documented below.

In the tutorial within the BatchProcessing_Core.zip Installation and Configuration topic, the COMMREQUEST table values were added/updated as follows in the Update the settings in the COMMREQUEST table step:

• SYSTEMNAME: Set this value to match the value of the current PROCESSTYPE column from the EBTNOTIFICATION table.

• SERVERNAME: Set this value to the address of the e-mail server for your state's environment (for example: smtp.cdpehs.com).

Authorized Vendor File

In the tutorial within the BatchProcessing_Core.zip Installation and Configuration topic, the Update the EBTCONNECTIONINFO table step was updated to include EBTCONNECTIONINFO table settings for the Authorized Vendor File.

A new Authorized Vendor File Processing within the BatchProcessor topic was added to document the authorized vendor file processing that occurs when the BatchProcessor.dll is run.

Within the DFDD's Table of Contents (TOC) (Scheduled Job Administration -> Scheduled Job Administration -> End of Day Processing -> End of Day Command Line Batch Processing -> BatchProcessor.dll Process Flow), a new page was added for the new Authorized Vendor File Processing within the BatchProcessor topic.

The Authorized Vendor File topic was updated as follows:

• The introduction at the top of the topic was expanded to include a hypertext link to the new Authorized Vendor File Processing within the BatchProcessor topic.

• Previously-missing data elements were added and the File Mapping from SPIRIT Database (Table. Column) column was populated in the Detail Record section.

• The file naming conventions section in the topic was updated to document how the file is named when generated and where the file is sent during BatchProcessor Processing.

The Run End of Day Command Line Batch Processing topic was updated as follows:

• The sample error section was updated to include EBTCONNECTIONINFO table requirements for the Authorized Vendor File.

• Messages that can display on the Command Prompt as the BatchProcessor.dll processes were added.

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new Authorized Vendor File Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for Authorized Vendor File processing.

CDP-369

Vendor Online Application

(voa.chm)

Changes to the Vendor Online Application DFDD for CDP-369 are documented below.

In the Screen Elements section of the Business Information screen topic, the following content was added below the Next button and the Save button:

"When adding a new vendor, the value of the APLTYPE column in the VENDOR table of the SPIRIT WIC database is set to "1" when the button is clicked."

Appendix

(apndxe.chm)

The following changes were made to the Smart Card Reader Process Flows topic in Appendix G:

• Smart Card Reader/Writer device screen images were updated throughout the topic to reflect updates made by cyberJack RFID SoliSYSTEMS to the Smart Card Reader/Writer device software.

• A new Prompt for New PIN process was added.

• A new Wrong PIN Reset process was added.

• A new Validate New PIN process was added.

• A new Card is Locked process was added.

• The Prompt for PIN process was renamed as "Prompt for Existing PIN" to differentiate it from the new Prompt for New PIN process that was added.

• The Prompt for Existing PIN process was updated as follows:

• The new PIN Validation Timeout process was added.

• The new Card is Locked process was added.

• The OK key presses on the keypad were added.

• The processing that occurs when no interaction is made with the keypad was added.

• The Validate PIN process was renamed as "Validate Existing PIN" to differentiate it from the new Validate New PIN process that was added.

• The Card Can be Read process was updated as follows:

• A new Prompt for New PIN process was added.

• A new Reset PIN button click process on the EBT Household Demographics screen was added.

• A new PIN Validation Timeout process was added.

• Content was added to the Validate Existing PIN process to document the following:

• A new "Please enter PIN ****" message.

• The OK key presses on the keypad were added.

• The PIN Lock the Card process was modified.

• The PIN Lock the Card process was updated to include a note indicating that once a card is PIN locked, it can no longer be used.

• The Card Present process was updated to provide references and hypertext links to data retrieved from and affected on various screens in the SPIRIT WIC system.

• A new Validate Card Number process was added.

• The Prompt to Enter Card Number process was updated as follows:

• The new Validate Card Number process was added.

• The OK key presses on the keypad were added.

• The processing that occurs when no interaction is made with the keypad was added.

• The Verify the Same Card was Reinserted process was updated with new "Card Read Error Please Retry" message text.

• The Prompt to Report Damaged Card process was updated to accurately document the processing that occurs when the 2 key is pressed on the keypad.

Also, as a result of the changes made to the Smart Card Reader Process Flows topic, the following changes were made to the EBT Household Demographics (Clinic) and the EBT Household Demographics (Vendor) screen topics:

• The On Hold radio button was updated to document how the selection of the radio button affects the Smart Card Reader/Writer device.

• The Reset PIN button was updated to indicate that the button is enabled when a row that contains a Card Number is selected in the EBT Household Representatives data grid. Additionally, the processing that occurs when the button is clicked was added.

• A new Communicate Actions to the Smart Card Reader/Writer Device section was added to the bottom of the Send EBT Data button process.

DFDD

(wicdfdd.chm)

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