2.33.00 Release Notes

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-552

13-digit UPCs

Prior to this release, the SPIRIT WIC system did not allow the entry of an odd-numbered Universal Product Code (UPC) longer than 12 digits when creating a new UPC record.

This enhancement allows the entry of a 13-digit Universal Product Code (UPC) and also provides support for a 14-digit Universal Product Code (UPC) when adding a new UPC on the UPC screen in the Reference Utility application module within the SPIRIT WIC system. This enhancement also provides support for 13-digit and 14-digit UPCs within National UPC Files imported on the Import National UPC File screen in the Reference Utility application module.

To support 13-digit and 14-digit UPCs, the changes below were made to the SPIRIT WIC system.

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

R2: The user shall be able to enter (via manual entry or import), edit data related to, and export a 13 or 14 digit UPC in SPIRIT.

To accommodate the R2 requirement for this enhancement, the existing check digit calculation algorithm was modified to allow the SPIRIT WIC system to support 13-digit and 14-digit UPCs. The algorithm executes when UPC/PLU Check Digit Calculations are performed and validated during the following processes within the Reference Utility application module of the SPIRIT WIC system:

• When a new Universal Product Code (UPC) or Price Look-Up (PLU) code record is saved in Add mode on the UPC screen in the Reference Utility application module.

• When a National UPC File is imported on the Import National UPC File screen in the Reference Utility application module.

R3: The system should correctly write all UPCs to the WUMEI compatible UPC file, including the 13 or 14 digit UPCs.

To accommodate the R3 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing to validate that 13-digit and 14-digit UPC records added on the UPC screen in the Reference Utility application module within the SPIRIT WIC system successfully transmit to and display correctly in the WIC Direct WIC Universal MIS EBT Interface (WUMEI).

R4: The system should correctly process all UPCs including 13 or 14 digit UPCs.

To accommodate the R4 requirement for this enhancement, the existing check digit calculation algorithm was modified to allow the SPIRIT WIC system to accurately process all UPCs, including 13-digit and 14-digit UPCs.

CDP's Quality Assurance (QA) team performed testing to ensure that 13-digit and 14-digit UPCs calculate correctly within this release of the software.

R5: Manage UPC MAR screens in the Vendor module must appropriately display and handle all UPCs including 13 and 14 digit UPCs.

To accommodate the R5 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing to ensure that 13-digit and 14-digit UPCs display and function properly within the Manage UPC MAR area of the Vendor application module.

R6: Assess that all fields, locations, and reports where UPCs are included display correctly and function as designed with all UPCs including 13 or 14 digit UPCs.

To accommodate the R6 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing to ensure that 13-digit and 14-digit UPCs display and function properly throughout this release of the software.

R7: Optionally assess CDP-254, CDP-325, TMP-226, and TMP-293 to be included with this change.

To accommodate the R7 requirement for this enhancement, CDP researched and resolved the following additional issues within this release:

• CDP-254

• CDP-319

• CDP-325

• TMP-226

• TMP-293

ENH-569

Online Application Security

The database connection strings were not encrypted in the web.config (or machine.config) files used by the Vendor Online Application (VOA) and Vendor Online Price Survey (VOPS) application modules, which posed a security risk within the SPIRIT WIC system.

To improve the security within the web.config (or machine.config) files used by the Vendor Online Application (VOA) and Vendor Online Price Survey (VOPS) application module, the changes below were made to the SPIRIT WIC system.

R1: Encrypt the database connection string stored in the Web.config files for VOA/VPS in accordance with best industry practice.

To accommodate the R1 requirement for this enhancement, the SPIRIT WIC system now allows the connection strings in the web.config (or machine.config) files used by the Vendor Online Application (VOA) and Vendor Online Price Survey (VOPS) application modules to be encrypted and decrypted using the .NET Framework Command Prompt tool.

R2: Update documentation to reflect the fact that the database connection string has been encrypted, how to use the .Net command line tool to encrypt/decrypt connection strings, how to determine the user account under which ASP.Net runs, what kind of access the account that runs ASP.Net should have and for which files, and ensure that the elements in the Web.config files are documented with useful explanations.

To accommodate the R2 requirement for this enhancement, the following topics were added to the SPIRIT WIC Detailed Functional Design Document (DFDD):

• VOA/VOPS Connection String Encryption

• Encrypt the connectionStrings in web.config files

• Fix an unsuccessful web.config file encryption

• Decrypt the connectionStrings in a web.config file

• Encrypt the connectionStrings in a machine.config file

• Decrypt the connectionStrings in a machine.config file

Additionally, the topics above were compiled into a stand-alone VOA_VOPS_Connection_String_Encryption.pdf document that is also delivered with this release of the software.

R3: Ensure that SPIRIT VOA/VPS still functions correctly with encrypted database connection strings.

To accommodate the R3 requirement for this enhancement, the Vendor Online Application (VOA) and Vendor Online Price Survey (VOPS) application modules continue to function as designed in this release of the software after encryption of the web.config (or machine.config) files.

CDP's Quality Assurance (QA) team performed testing against this requirement to ensure that the SPIRIT WIC system continues to function as designed after the web.config (or machine.config) files are encrypted.

R4: Documentation on how to determine if the website that a state hosts VOA/VPS on is configured with the default RsaProtectedConfigurationProvider and the location of the web.config (or machine.config) file. Any pertinent information needed to correctly configure SPIRIT to use encrypted database connections strings should be provided.

To accommodate the R4 requirement for this enhancement, the following topics were added to the SPIRIT WIC Detailed Functional Design Document (DFDD):

• VOA/VOPS Connection String Encryption

• Encrypt the connectionStrings in web.config files

• Fix an unsuccessful web.config file encryption

• Decrypt the connectionStrings in a web.config file

• Encrypt the connectionStrings in a machine.config file

• Decrypt the connectionStrings in a machine.config file

Additionally, the topics above were compiled into a stand-alone VOA_VOPS_Connection_String_Encryption.pdf document that is also delivered with this release of the software.

ENH-585

End of Day Process

Within the SPIRIT WIC system, the End of Day Process was slow to run and occasionally time-outs occurred during UPC/PLU Redemption File processing.

To improve the efficiency of the End of Day Process, the changes below were made to the SPIRIT WIC system.

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

R2: Modify EBT EOD and supporting code to be more efficient so that redemption files are processed in under 2 hours.

Changes to End of Day Processing for ENH-585 removed redemption file processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.33.00 release of the SPIRIT WIC system, redemption file processing now occurs only during End of Day Command Line Batch Processing.

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

R3: Ensure that the new EBT EOD process correctly updates the same records that the current EBT EOD process updates.

R4: Ensure that the new EBT EOD works with online and offline EBT.

R5: Ensure that the new EBT EOD does not break EOD for checks, Direct Distribution, MOV, Batch, Compliance Buys, and Vouchers.

R6: Ensure that the new EBT EOD does not break EOD for all EBT processors.

To accommodate the R6 requirement for this enhancement, the changes made to the SPIRIT WIC system in this release were validated to work with the WIC Direct EBT Processor.

R7: Ensure that the new EBT EOD does not break EOM.

To accommodate the R7 requirement for this enhancement, the changes made to the SPIRIT WIC system in this release were validated to work alongside current End of Month Processes.

CDP's Quality Assurance (QA) team performed testing against current End of Month Processes to ensure that the SPIRIT WIC system continues to function as designed after the new BatchProcessor.dll is run.

R8: The release notes should contain the name of the stored procedure for the new EBT EOD.

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

• InsertFIItemRedeemed

• InsertFIItemRedeemedAggregated

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

R9: The new EOD should be compatible with SPIRIT Web.

To accommodate the R9 requirement for this enhancement, the changes made to the SPIRIT WIC system in this release will be fully compatible with the SPIRIT Web interface.

ENH-586

End of Day Process

Within the SPIRIT WIC system, the End of Day Process was slow to run and occasionally time-outs occurred during UPC Maximum Allowed Reimbursement (MAR) Calculation processing.

To improve the efficiency of the End of Day Process, the changes below were made to the SPIRIT WIC system.

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

R2: Modify the EOD and any supporting source code so that it will not timeout for states that have large caseloads and make the code more efficient. All States should be able to run EOD without experiencing timeouts. EOD should run in under 2 hours.

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

R3: Ensure that the new EBT EOD process correctly updates the appropriate records.

R4: Ensure that the new EBT EOD works with online and offline EBT.

R5: Ensure that the new EBT EOD does not break EOD for checks, Direct Distribution, Compliance Buys, and Vouchers, and Batch Issuance/MOV.

R6: The release notes should contain the name of the stored procedure for the new EBT EOD.

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

• CalculateMAR

• GetNewMARCats

• InsertScheduledLog

• InsertExceptionLog

• GetEBTNotificationList

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

Additionally, the new CalculateMAR stored procedure was thoroughly documented in a new CalculateMAR Stored Procedure topic within the DFDD. For more information, see the DFDD changes for this enhancement.

Changes to End of Day Processing for ENH-586 removed MAR calculation processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.33.00 release of the SPIRIT WIC system, MAR calculation processing now occurs only during MAR Calculation Processing within the BatchProcessor.

R7: The new EOD should be compatible with SPIRIT Web.

To accommodate the R7 requirement for this enhancement, the changes made to the SPIRIT WIC system in this release will be fully compatible with the SPIRIT Web interface.

R8: Ensure that the new EBT EOD does not break EOD for any EBT processors.

To accommodate the R8 requirement for this enhancement, the changes made to the SPIRIT WIC system in this release were validated to work with the WIC Direct EBT Processor.

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

CDP-118

Detailed Functional Design Document (DFDD)

The DFDD referenced the "5 (Some Breastfeeding)" drop-down list box option as "5 (Partially Breastfeeding)" in the definition of risk factor 338 within the Risk Factors Matrix.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to correctly reference the "5 (Some Breastfeeding)" drop-down list box option in the definition of risk factor 338 in the Risk Factors Matrix.

For more information, see the DFDD changes for this reported issue.

CDP-211

Detailed Functional Design Document (DFDD)

The user group requested several revisions to the DFDD in this reported issue.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was modified based on several of the comments from the user group in CDP-211.

For more information, see the DFDD changes for this reported issue.

CDP-254

UPC List

On the UPC List screen, no results were found when using the APL Type drop-down list box to search for UPC records that were created prior to Release 2.25.00 in the SPIRIT WIC system.

CDP-319

Import National UPC File

Errors occurred when attempting to import a National UPC File as a text file on the Import National UPC File screen in the Reference Utility application module.

The SPIRIT WIC system was modified to import the National UPC File as a text file without errors on the Import National UPC File screen in the Reference Utility application module.

CDP-320

Detailed Functional Design Document (DFDD)

The DESCRIPTION column of the BNKEXCPTREASON category of the REFERENCEDICTIONARY table was incorrectly documented as "BANKEXCPTREASON" in the DFDD.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to correctly reference the DESCRIPTION column of the BNKEXCPTREASON category of the REFERENCEDICTIONARY table.

For more information, see the DFDD changes for this reported issue.

CDP-325

Restore Previous UPC Version / Import National UPC File

When the OK button was clicked on the Restore Previous UPC Version screen, all UPC records were deleted unexpectedly from the EBTAUTHORIZEDUPC and EBTUPCAPLTYPE tables of the database.

Then, when attempting to use the Import National UPC File screen to restore UPC records, a "Violation of Primary Key constraint" error occurred.

CDP-346

Issue Formula and Infant Foods

On the Issue Formula and Infant Foods screen, the New Amount column did not display the expected amount of formula.

The LoadExistingBenefitsIntoGrid function in the frmEBTFoodAdjWiz_FormulaInfantFoodIssuance class within the SPIRIT WIC system was incorrectly using the following formula to calculate the remaining amount on the card:

Min(Amount Issued - (Recovered+Returned)) or MaxBaseLimit)

The math in this formula was modified as follows to correctly calculate the remaining amount on the card:

Min((Amount Recoverable - Recovered) or MaxBaseLimit)

CDP-351

MAR Recalculation

An unexpected system error occurred when the Recalculate button was clicked on the Manage UPC MAR screen in the Vendor application module.

CDP believes this error was resolved with the changes made to the SPIRIT WIC system for ENH-586.

For more information, see the enhancements made in this release for ENH-586.

CDP-352

Detailed Functional Design Document (DFDD)

The DFDD contained unnecessary footnote references in the definition of risk factor 383 within the Risk Factors Matrix.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to remove the unnecessary footnote references from the definition of risk factor 383 in the Risk Factors Matrix.

For more information, see the DFDD changes for this reported issue.

CDP-353

Detailed Functional Design Document (DFDD)

The End Date calendar control was missing from the Data Map section on the following screen topics in the DFDD:

• EBT Transaction History (Central Administrative Site)

• EBT Transaction History (Clinic)

• EBT Transaction History (State Office)

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to include the End Date calendar control in the Data Map section on the following screen topics:

• EBT Transaction History (Central Administrative Site)

• EBT Transaction History (Clinic)

• EBT Transaction History (State Office)

For more information, see the DFDD changes for this reported issue.

CDP-354

Detailed Functional Design Document (DFDD)

In the DFDD's Table of Contents (TOC), the first page listed under the Appendix B - Client Business Rules book linked to a Business Rule Classifications.xlsx spreadsheet file that was specific to a specific State WIC Program.

The Business Rule Classifications.xlsx spreadsheet file was removed entirely from the SPIRIT WIC Detailed Functional Design Document (DFDD).

For more information, see the DFDD changes for this reported issue.

CDP-357

Detailed Functional Design Document (DFDD)

On the Food Adjustment Wizard screen topic in the DFDD, the heading of the Void Future Benefits radio button incorrectly referenced "Add Infant Solid Foods".

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to correctly reference "Void Future Benefits" in the heading text for the Void Future Benefits radio button on the Food Adjustment Wizard screen topic.

For more information, see the DFDD changes for this reported issue.

CDP-358

Detailed Functional Design Document (DFDD)

The DFDD incorrectly documented the mnemonic for the Show Details button on the following screen topics:

• Benefits History (Central Administrative Site)

• Benefits History (State Office)

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to document the mnemonic for the Show Details button as a "D" on the following screen topics:

• Benefits History (Central Administrative Site)

• Benefits History (State Office)

For more information, see the DFDD changes for this reported issue.

CDP-359

Benefit Issuance

A PRIMARY KEY constraint error occurred when multiple users attempted to issue benefits to multiple households simultaneously.

Changes to the SPIRIT WIC system for CDP-359 affect End of Day Processing that occurs within the Scheduled Job Administration application module. It is critical to deploy the 2.33.00 release to all servers that run End of Day Processing within your state’s environment. Failure to upgrade End of Day on the server(s) at the same time SPIRIT applications are upgraded to release 2.33.00 will result in data integrity issues.

The SPIRIT WIC system was modified as follows:

• The CreateInsert function in the FoodInstrumentItemDetail class was changed to pass in the next DetailItemId value instead of using a SQL statement to retrieve the max DetailItemId directly from the FoodInstrumentItemDetail table.

• The FoodInstrumentManager class was modified as follows:

• The SaveFoodInstrumentIssuances function was changed to get the count of the total number of food items to determine range, and then it retrieves the list of next IDs to assign and stores the IDs in an array list.

• A single ID SQL statement was relocated to allow access by both EBT and Direct Distribution.

• The SaveFoodInstrumentItemDetails function was modified to use the new method of getting the next available number.

• The JPMExpiredBenefitsImport class was modified as follows:

• The ImportFile function was modified to retrieve the next food item detail number (FIDetailNextValue) from a new database table.

• SQL logic was added to set the new FIDetailNextValue parameter for an insert and to retrieve the next number for Summer EBT.

• The EBTBenefitMessage class was modified as follows:

• The SaveFoodInstrumentItemDetail function was modified to retrieve the next food item detail number (FIDetailNextValue) from a new database table.

AND

SQL logic was added to set the new FIDetailNextValue parameter for an insert.

• The SavePendingFoodInstrumentItemDetail function was modified to retrieve the next food item detail number (FIDetailNextValue) from a new database table.

AND

SQL logic was added to set the new FIDetailNextValue parameter for an insert.

• The ParticipantManager class was modified as follows:

• The ResolveEBTPendingVoid function was changed to retrieve next ID to assign and SQL logic was modified to use the retrieved ID for an insert.

• The ResolveEBTPending function was changed to get the count of IDs to generate, and then it retrieves the list of next IDs to assign and stores the IDs in an array list. SQL logic was also modified to use the IDs in array list for an insert.

Various changes were made to the SPIRIT WIC database. For more information, see the database changes for this reported issue.

CDP-362

Detailed Functional Design Document (DFDD)

The Reset button was missing from the Interface Initialization section of the Benefits History screen topic in the Central Administrative Site DFDD.

The Reset button was added to the Interface Initialization section of the Benefits History screen topic in the Central Administrative Site DFDD.

For more information, see the DFDD changes for this reported issue.

CDP-363

Detailed Functional Design Document (DFDD)

The Reset button was missing from the Interface Initialization section of the Benefits History screen topic in the Clinic DFDD.

The Reset button was added to the Interface Initialization section of the Benefits History screen topic in the Clinic DFDD.

For more information, see the DFDD changes for this reported issue.

CDP-364

Detailed Functional Design Document (DFDD)

The Reset button was missing from the Interface Initialization section of the Benefits History screen topic in the State Office DFDD.

The Reset button was added to the Interface Initialization section of the Benefits History screen topic in the State Office DFDD.

For more information, see the DFDD changes for this reported issue.

CDP-365

Detailed Functional Design Document (DFDD)

The DFDD changes for ENH-567 in the 2.32.01 Release Notes documented that the note below was added to the top of the Permissions Matrix, but the note did not exist.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to include the note below at the top of the Permissions Matrix.

For more information, see the DFDD changes for this reported issue.

TMP-226

Add UPC

When no records existed in the EBTAUTHORIZEDUPC table of the SPIRIT database, a UPC could not be added on the UPC screen in the Reference Utility application module.

The SPIRIT WIC system was modified to allow UPCs to be added on the UPC screen in the Reference Utility application module when no records exist in the EBTAUTHORIZEDUPC table of the SPIRIT database.

TMP-293

UPC List

When the UPC screen in the Reference Utility application module was displayed in Edit Multiple UPCs mode, the selection in the APL Type list box was modified, and the changes were saved, the value of the UPCPLUDATALENGTH column in the EBTAUTHORIZEDUPC table of the SPIRIT database was modified unexpectedly.

The Reference Utility application module of the SPIRIT WIC system was modified to no longer update the value of the UPCPLUDATALENGTH column in the EBTAUTHORIZEDUPC table of the SPIRIT database and also to update the APL type even if no other changes were made when the UPC screen is displayed in Edit Multiple UPCs mode, the selection in the APL Type list box is modified, and the changes are saved.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

ENH-552

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for ENH-552 are documented below.

A new UPC/PLU Check Digit Calculations process topic was added to document the check digit calculations that occur within the SPIRIT WIC system.

The UPC screen topic was updated as follows:

• In the Processing section, a hypertext link to the new UPC/PLU Check Digit Calculations process topic was added.

• In the Screen Elements section, the UPC text box was updated as follows:

• Since Price Look-Up (PLU) codes can also be entered on the UPC screen, content was added for Price Look-Up (PLU) codes.

• Content was added to indicate that the text box only allows the entry of numeric characters.

• Content was revised to indicate that the text box is only enabled when the screen is displayed in Add mode.

• The note below was added.

The Screen Elements section of the Import National UPC File screen topic was updated as follows:

• Documentation for the Import button was updated as follows:

• The documentation that explains the processing that occurs when the button is clicked was restructured into an alphabetized list (a, b, c...) for accessibility and rewritten for clarity.

• Step e) was expanded to include content about the processing that occurs in the EBTUPCAPLTYPE and EBTUPCAPLTYPEHISTORY tables of the SPIRIT database and also the APL type import process that occurs when importing a National UPC File in Excel format.

• Step f) was rewritten to include a hypertext link to the new UPC/PLU Check Digit Calculations process topic.

• The note below was added to the Text File radio button in the File Type radio button group.

ENH-569

Appendix

(busrule.chm)

Changes to the Appendix DFDD for ENH-569 are documented below.

In the DFDD's Table of Contents (TOC) under Appendix, a new VOA/VOPS Connection String Encryption book was added, which contains the following new topics:

• VOA/VOPS Connection String Encryption

• Encrypt the connectionStrings in web.config files

• Fix an unsuccessful web.config file encryption

• Decrypt the connectionStrings in a web.config file

• Encrypt the connectionStrings in a machine.config file

• Decrypt the connectionStrings in a machine.config file

ENH-585

Appendix

(busrule.chm)

Changes to the Appendix DFDD for ENH-585 are documented below.

A new State Identifier Codes topic was added to Appendix G.

In the DFDD's Table of Contents (TOC), a new State Identifier Codes page was added to the Appendix  G - Additional Documentation book within the Appendix book. The new State Identifier Codes page links to the new State Identifier Codes topic.

Scheduled Job Administration

(jobadmn.chm)

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

While researching the documentation needs for ENH-585, CDP determined that the file layouts documented in the SPIRIT DFDD for the files imported from and exported to the EBT Processor system by End of Day Processing were largely inaccurate. As a result, the following topics were entirely rewritten:

• Approved Product List (APL) File

• Authorized Vendor File

• Category/Sub-category File

• Expired Benefits File

• UPC/PLU Redemption File

• WIC Activity File

Resulting from the file layout documentation research noted above, a new EBT Processor Import/Export Files topic was created to further explain the files that are imported from and exported to the EBT Processor system during End of Day Processing by the SPIRIT WIC system. And, in the DFDD's Table of Contents (TOC), a new EBT Processor Import/Export Files book was added to the End of Day Processing book within the Scheduled Job Administration book. The new EBT Processor Import/Export Files book links to the following topics:

• EBT Processor Import/Export Files

• EBT to SPIRIT Files (SPIRIT Import Files)

• SPIRIT Import Files

• Expired Benefits File

• UPC/PLU Redemption File

• WIC Activity File

• SPIRIT to EBT Files (SPIRIT Export Files)

• SPIRIT Export Files

• Approved Product List (APL) File

• Authorized Vendor File

• Category/Sub-category File

The following topics were renamed throughout the DFDD for clarity and/or consistency:

• The Import Files topic was renamed as "SPIRIT Import Files".

• The Export Files topic was renamed as "SPIRIT Export Files".

• The Create Approved Product List (APL) File topic was renamed as "Approved Product List (APL) File".

• The Create Authorized Vendor File topic was renamed as "Authorized Vendor File".

• The Create Category/Sub-category File topic was renamed as "Category/Sub-category File".

• The Create Over 50% Vendor Report topic was renamed as "Over 50% Vendor Report".

The SPIRIT Import Files topic was updated as follows:

• References to the "CSC system" were replaced to instead reference the SPIRIT WIC system.

• Hypertext links to the End of Day Process topic were added throughout the topic.

• The Expired Benefits File section was updated as follows:

• An incorrect reference to the COMMREQUEST table was updated to correctly reference the FILERECEIVEPATH parameter of the  EBTCONNECTIONINFO table.

• "JPM" and "JPMTRANSSPIRITFTP" references were removed.

• Hypertext links to the Expired Benefits File topic were added.

• Hypertext links to the EBT to SPIRIT Files section of the new EBT Processor Import/Export Files topic were added.

• The UPC/PLU Redemption File section was updated as follows:

• An incorrect reference to the COMMREQUEST table was updated to correctly reference the FILERECEIVEPATH parameter of the EBTCONNECTIONINFO table.

• "JPM" and "JPMTRANSSPIRITFTP" references were removed.

• Hypertext links to the UPC/PLU Redemption File topic were added.

• Hypertext links to the EBT to SPIRIT Files section of the new EBT Processor Import/Export Files topic were added.

• A list of transaction codes and descriptions were added.

• The Vendor Activity File section that previously existed between the UPC/PLU Redemption File and WIC Activity File sections was removed entirely as the Vendor Activity File is not imported into the SPIRIT WIC system from the EBT Processor system (it is an export file that is documented on the SPIRIT Export Files topic).

• The WIC Activity File section was updated as follows:

• An incorrect reference to the COMMREQUEST table was updated to correctly reference the FILERECEIVEPATH parameter of the EBTCONNECTIONINFO table.

• "JPM" and "JPMTRANSSPIRITFTP" references were removed.

• Hypertext links to the WIC Activity File topic were added.

• Hypertext links to the EBT to SPIRIT Files section of the new EBT Processor Import/Export Files topic were added.

The SPIRIT Export Files topic was updated as follows:

• References to the "CSC system" were replaced to instead reference the SPIRIT WIC system.

• Previously-missing documentation for the Approved Product List (APL) File was added.

• Previously-missing documentation for the Authorized Vendor File was added.

• Previously-missing documentation for the Category/Sub-category File was added.

The note below was added to the top of the following topics:

• End of Day Process

• UPC/PLU Redemption File

• SPIRIT Import Files

A new Redemption Processing within the BatchProcessor topic was added to document the redemption file processing that occurs when the BatchProcessor.dll is run.

In the DFDD's Table of Contents (TOC), a new End of Day Command Line Batch Processing book was added to the End of Day Processing book within the Scheduled Job Administration book. The new End of Day Command Line Batch Processing book links to the following topics:

• BatchProcessing_Core.zip Installation and Configuration

• Create Environment Variables within the Windows Operating System

• Run End of Day Command Line Batch Processing

• BatchProcessor Processing

• BatchProcessor Logging Processes

• Maximum Allowed Reimbursement (MAR) Process Flow

• Calculate UPC Maximum Allowable Reimbursement (MAR) Values

• CalculateMAR Stored Procedure

• Vendor Services Processing within the BatchProcessor

• Redemption Processing within the BatchProcessor

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for ENH-585 are documented below.

The National UPC File Layout Definition topic was renamed as "National UPC File" throughout the DFDD to follow consistent naming conventions.

The following changes were made to the EBT UPC Actions menu topic:

• Content was added to the top of the topic to indicate that the menu is visible and enabled only when the Electronic Benefit Transfer (EBT) food delivery system is enabled for any clinic within the state.

• A note was added below the Export National UPC Text File menu option to provide a hypertext link to the National UPC File topic.

• A note was added below the Export National UPC Excel File menu option to provide a hypertext link to the National UPC File topic.

System Administration

(sysadmn.chm)

Changes to the System Administration DFDD for ENH-585 are documented below.

In the Screen Elements section of the EBT Data screen topic, a list of transaction codes and descriptions were added to the TRANSACTIONCODE column within the EBT Redemption Data data grid.

Vendor

(vendor.chm)

Changes to the Vendor DFDD for ENH-585 are documented below.

In the Screen Elements section of the EBT Redemption Data screen topic, a list of transaction codes and descriptions were added to the Transaction Code column within the EBT Redemption Data data grid.

In the Data Elements section of the following report output topics, a note was added below the Agency Code data element to provide a link to the new State Identifier Codes topic.

• The Integrity Profile (TIP) File (Output)

• The Excel Integrity Profile (TIP) Report (Output)

ENH-586

Appendix

(busrule.chm)

Changes to the Messages Matrix in Appendix D of the DFDD for ENH-586 are documented below.

The following changes were made to the E0335 standard error message:

• The following Variant Text was added:

• "An error occurred for {process} for {function}."

• "An error occurred for {process} for {function}. Parameter: {process type}"

• "An error occurred for {process} for {function}. Parameter: {start date}, {override interval} {user ID}"

• "Could not find configuration for state/ITO '{site name}'."

• The following Message Triggers were added:

• "The SPIRIT WIC system encountered an error that was logged as a new exception in the EXCEPTIONLOG table of the SPIRIT database."

• "When attempting to Run End of Day Command Line Batch Processing, an error is logged as a new exception in the EXCEPTIONLOG table of the SPIRIT database when the [State Identifier Code] specified in the command line argument entered and executed on the Command Prompt window is not a valid [State Identifier Code] value in an existing system environment variable within the Windows operating system on the SPIRIT server."

• The following Notes were added:

• "The variable {function} refers to the refers to the name of a specific function that was attempted or functional area to which access was attempted."

• "The variable {process} refers to the name of a specific process that was attempted."

• "The variable {start date} refers to the date on which the record, process, or function begins (or began)."

• "The variable {override interval} refers to the specific interval at which the record, process, or function is (or was) overridden."

• "The variable {user ID} refers to a newly created or already-existing user ID."

• "The variable {process type} refers to the type of a specific process that was attempted."

• "The variable {site name} refers to the [State Identifier Code] of a specific agency, location, or site."

A previously-undocumented standard information message (I0094) was added as follows:

• Message Text: "Variables saved successfully."

• Variant Text: "MARs calculated successfully."

• Message Triggers:

• "The Save Variables button is clicked within the MAR Calculation Variables group box on the Manage UPC MAR screen in the Vendor application module."

• "The Recalculate button is clicked within the MAR Calculation Schedule group box on the Manage UPC MAR screen in the Vendor application module."

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for ENH-586 are documented below.

The following changes were made to the Process column within the Screen Elements section on the Notification List screen topic:

• The description was rewritten to indicate that only active notifications display as options within the drop-down list box.

• A bulleted list was added to document the previously-existing "EBT MAR" option and a new "WICEOD" option.

Scheduled Job Administration

(jobadmn.chm)

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

A new CalculateMAR Stored Procedure topic was added to document the processes and calculations that occur when the CalculateMAR stored procedure executes.

A new Vendor Services Processing within the BatchProcessor topic was added to document the vendor services processing that occurs when the BatchProcessor.dll is run.

A new Maximum Allowed Reimbursement (MAR) Process Flow topic was added to document MAR processing within the SPIRIT WIC system.

The following changes were made to the Calculate UPC Maximum Allowable Reimbursement (MAR) Values topic:

• An overview of MAR within the WIC Program was added to the top of the topic.

• A note was added to the top of the topic to provide a hypertext link to the new Maximum Allowed Reimbursement (MAR) Process Flow topic.

• MAR calculation processing that occurs when End of Day is run from the command line using the new BatchProcessor.dll was added.

• A paragraph introducing MAR processes and containing the following links was added to the top of the topic:

• MAR Calculation Overview

• MAR Calculation Processing within the BatchProcessor

• The note below was added to the top of the topic.

The Data Map section on the Event Log - WIC Scheduled Job Administration screen topic was updated to reflect current functionality and follow standards and consistencies.

System Administration

(sysadmn.chm)

Changes to the System Administration DFDD for ENH-586 are documented below.

The Data Map section on the Event Log - WIC Scheduled Job Administration screen topic was updated to reflect current functionality and follow standards and consistencies.

Vendor

(vendor.chm)

Changes to the Vendor DFDD for ENH-586 are documented below.

The following changes were made to the Screen Elements section on the Manage UPC MAR screen topic:

• The Recalculate button within the MAR Calculation Schedule group box was updated to reference the I0094 standard information message.

• The Save Variables button within the MAR Calculation Variables group box was updated to reference the I0094 standard information message.

While researching the documentation needs for ENH-586, CDP determined that the Overcharges Report VND035 (Output) is not directly related to UPC MAR prices. As a result, references to the Overcharges Report VND035 (Output)topic were removed from the introductory paragraph on the following topics:

• Manage UPC MAR

• Approve New MAR Prices

• Override MAR Prices

• MAR Calculation Method

• Set Initial MAR Values

Additionally, a note was added to the top of the topics above to provide a hypertext link to the new Maximum Allowed Reimbursement (MAR) Process Flow topic.

CDP-118

Appendix

(busrule.chm)

Changes to the Appendix DFDD for CDP-118 are documented below.

The reference to the "5 (Partially Breastfeeding)" drop-down list box option was updated to instead reference "5 (Some Breastfeeding)" in the Definition column for risk factor 338 within in the Risk Factors Matrix.

CDP-211

Appendix

(busrule.chm)

Changes to the Messages Matrix in Appendix D of the DFDD for CDP-211 are documented below.

The E0239 standard error message was deemed a duplicate of the E0002 standard error message with this release. A note was added to the E0239 standard error message to indicate that it was merged with the E0002 standard error message in Release 2.32.02. The E0239 standard error message ID will be repurposed for a future enhancement in a future release.

As a result, the following additional changes were made to the E0002 standard error message:

• The E0239 standard error message's Message Text was added as new Variant Text with the following text: "Each Area for Monitoring/Training must have a selection."

• The E0239 standard error message's Variant Text was added as new Variant Text with the following text: "Please select a benefit row to void."

• The Message Trigger was updated to include editable data grids.

Clinic

(clinic.chm)

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

The "Unlock one or more households that were previously locked" bullet at the top of the Batch Issue History screen topic was updated as follows: "Unlock one or more households that were previously locked by the Batch Issue Resolution Process in the Scheduled Job Administration application module." Additionally, the following note was added below the bulleted list:

The "Batch" issuance type option documented for the Issuance Type drop-down list box in the Search Criteria group box on the Batch Issue Resolution screen topic was updated as follows: "Select the "Batch" option to only include participants currently receiving benefits via batch mailing issuance in the search (unless the clinic is in emergency mode, whereas all participants in the clinic receive "Batch" benefits)."

Additionally, the following notes were added to both the top of the Batch Issue Resolution screen topic and to the Issuance Type drop-down list box in the Search Criteria group box on the Batch Issue Resolution screen topic:

Under the following Screen Elements on the Batch Details screen topic, references to the E0239 standard error message were replaced to instead reference the E0002 standard error message:

• Void Checked Benefits button

• Reprint Checked button

Reference Utility

(refutil.chm)

Changes to the Reference Utility DFDD for CDP-211 are documented below.

The emergency batch operation mode note was rewritten as follows:

The emergency batch operation mode note (above) is presented in the Reference Utility DFDD under the following Screen Elements on the following screen topics:

• Agency/Clinic screen - Emergency Batch text and value label

• Clinic screen - Clinic is in Emergency Batch Mode check box

Additionally, the following note was added to the Emergency Batch text and value label on the Agency/Clinic screen topic:

State Office

(State Office)

Changes to the State Office DFDD for CDP-211 are documented below.

The "Unlock one or more households that were previously locked" bullet at the top of the Batch Issue History screen topic was updated as follows: "Unlock one or more households that were previously locked by the Batch Issue Resolution Process in the Scheduled Job Administration application module." Additionally, the following note was added below the bulleted list:

The "Batch" issuance type option documented for the Issuance Type drop-down list box in the Search Criteria group box on the Batch Issue Resolution screen topic was updated as follows: "Select the "Batch" option to only include participants currently receiving benefits via batch mailing issuance in the search (unless the clinic is in emergency mode, whereas all participants in the clinic receive "Batch" benefits)."

Additionally, the following notes were added to both the top of the Batch Issue Resolution screen topic and to the Issuance Type drop-down list box in the Search Criteria group box on the Batch Issue Resolution screen topic:

Under the following Screen Elements on the Batch Details screen topic, references to the E0239 standard error message were replaced to instead reference the E0002 standard error message:

• Void Checked Benefits button

• Reprint Checked button

Vendor

(vendor.chm)

Changes to the Vendor DFDD for CDP-211 are documented below.

Under the Monitoring Areas editable data grid on the following screen topics, references to the E0239 standard error message were replaced to instead reference the E0002 standard error message:

• Monitoring Visit screen

• New Vendor Authorization screen

CDP-320

DFDD

(wicdfdd.chm)

Changes to the DFDD (wicdfdd.chm) for CDP-320 are documented below.

References to the "BANKEXCPTREASON" category in the Release 2.17.05 Notes topic were updated to correctly reference the BNKEXCPTREASON category.

Financial Management

(finmgmt.chm)

Changes to the Financial Management DFDD for CDP-320 are documented below.

A reference to the "BANKEXCPTREASON" category was updated to correctly reference the BNKEXCPTREASON category in the Exception Reason text and value label on the Resolve Exception screen topic.

Vendor

(vendor.chm)

Changes to the Vendor DFDD for CDP-320 are documented below.

A reference to the "BANKEXCPTREASON" category was updated to correctly reference the BNKEXCPTREASON category in the Exception Reason text and value label on the Resolve Exception screen topic.

CDP-352

Appendix

(busrule.chm)

Changes to the Appendix DFDD for CDP-352 are documented below.

References to the "(1)" and "(2,3)" footnotes were removed from the Definition column for risk factor 383 in the Risk Factors Matrix.

CDP-353

Central Administrative Site

(centadmn.chm)

Changes to the Central Administrative Site DFDD for CDP-353 are documented below.

The End Date calendar control was added to the Data Map section on the EBT Transaction History screen topic.

Clinic

(clinic.chm)

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

The End Date calendar control was added to the Data Map section on the EBT Transaction History screen topic.

State Office

(State Office)

Changes to the State Office DFDD for CDP-353 are documented below.

The End Date calendar control was added to the Data Map section on the EBT Transaction History screen topic.

CDP-354

Appendix

(busrule.chm)

Changes to the Appendix DFDD for CDP-354 are documented below.

The Business Rule Classifications.xlsx spreadsheet file was removed entirely from the DFDD. As a result, the first page that previously existed under the Appendix B - Client Business Rules book in the DFDD's Table of Contents (TOC) that linked to the Business Rule Classifications.xlsx spreadsheet file was removed as well, and now the first page displayed under the Appendix B - Client Business Rules book in the DFDD's Table of Contents (TOC) links to the Client Business Rules topic.

CDP-357

Clinic

(clinic.chm)

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

The Food Adjustment Wizard screen topic was updated to correctly reference "Void Future Benefits" in the heading text for the Void Future Benefits radio button.

CDP-358

Central Administrative Site

(centadmn.chm)

Changes to the Central Administrative Site DFDD for CDP-358 are documented below.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to document the mnemonic for the Show Details button as a "D" on the Benefits History screen topic.

State Office

(State Office)

Changes to the State Office DFDD for CDP-358 are documented below.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to document the mnemonic for the Show Details button as a "D" on the Benefits History screen topic.

CDP-362

Central Administrative Site

(centadmn.chm)

Changes to the Central Administrative Site DFDD for CDP-362 are documented below.

The Reset button was added to the Interface Initialization section of the Benefits History screen topic.

CDP-363

Clinic

(clinic.chm)

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

The Reset button was added to the Interface Initialization section of the Benefits History screen topic.

CDP-364

State Office

(State Office)

Changes to the State Office DFDD for CDP-364 are documented below.

The Reset button was added to the Interface Initialization section of the Benefits History screen topic.

CDP-365

Appendix

(busrule.chm)

Changes to the Appendix DFDD for CDP-365 are documented below.

The note below was added to the top of the Permissions Matrix.

DFDD

(wicdfdd.chm)

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