2.25.00 Release Notes

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-501

Formula Return and Recovery

R1: To accommodate the R1 requirement for this enhancement, CDP's QA staff ensured that returns and recoveries are accurately reflected in the following:

• The SPIRIT database

• The Supplier Rebate Report FIN001 (Output)

• The Benefits History tree list on the following screens:

• Benefits History (Clinic)

• Benefits History (State Office)

Benefits History

R2: To accommodate the R2 requirement for this enhancement, a new Returned tree list node was added to the Benefits History tree list on the following screens if a formula food item was returned:

• Benefits History (Central Administrative Site)

• Benefits History (Clinic)

• Benefits History (State Office)

Benefits History

R3: To accommodate the R3 requirement for this enhancement, a new Recovered tree list node was added to the Benefits History tree list on the following screens if a formula food item was recovered:

• Benefits History (Central Administrative Site)

• Benefits History (Clinic)

• Benefits History (State Office)

System Outputs

R4: Based on the original requirement, CDP determined that because of the original design of the SPIRIT WIC system, returns and recoveries for paper food instruments could not be done for any issuance type other than EBT due to the fact that only the EBT issuance type is based on actual redemption data. And, as noted in the Detailed Functional Design Document (DFDD), transaction data for each household is summarized on the EBT Household Reconciliation Report (Output). This report contains food category totals for each Clinic and the entire State, and the data on the report is based on both the positive and negative benefit data transactions recorded in the FoodInstrumentItemDetail table of the database. Therefore, accurate counts for cans of formula redeemed are displayed on the EBT Household Reconciliation Report (Output) for EBT-based systems.

Therefore, to accommodate the R4 requirement for this enhancement, the following two new Data Elements were added to the EBT Household Reconciliation Report (Output) generated from within the State Office application module:

• Return

• Recovery

In addition, CDP's QA staff thoroughly regression tested the Supplier Rebate Report FIN001 (Output) to ensure the unit counts reported accurately to include actual redemption, including any subsequent returns and recoveries.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-502

Assign Card

R1: To accommodate the R1 requirement for this enhancement, the code was modified to place the cursor position at the left-most character position as the default when no card data exists and a card is swiped using a card reader or when the mouse is used to click on the Insert or Swipe Card, or Type PAN text box on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R2: To accommodate the R2 requirement for this enhancement, the code was modified to place the cursor position at the left-most character position as the default when no card data exists and the keyboard is used to navigate to the Insert or Swipe Card, or Type PAN text box on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R3: To accommodate the R3 requirement for this enhancement, the code was modified to allow precise cursor placement using a mouse or the keyboard when data already exists within the Insert or Swipe Card, or Type PAN text box on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-503

Assign Card

R1: To accommodate the R1 requirement for this enhancement, the code was modified to display a standard error message E0004 with the text: "The card number is invalid." if the an invalid PAN is displayed in the Insert or Swipe Card, or Type PAN text box and the OK button is clicked on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R2: To accommodate the R2 requirement for this enhancement, the code was modified to automatically populate the BIN number when exactly ten (10) digits are entered in the Insert or Swipe Card, or Type PAN text box and the OK button is clicked on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R3: To accommodate the R3 requirement for this enhancement, SPIRIT WIC system will not automatically populate the BIN number when more than ten (10) but less than sixteen (16) digits are entered in the Insert or Swipe Card, or Type PAN text box and the OK button is clicked on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R4: To accommodate the R4 requirement for this enhancement, the code was modified to display a standard error message E0004 with the text: "The card number is invalid." if less than sixteen (16) digits are entered but exactly ten (10) digits are not entered in the Insert or Swipe Card, or Type PAN text box and the OK button is clicked on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R5: To accommodate the R5 requirement for this enhancement, CDP's QA staff verified that the card reader continued to function properly when a card was swiped and that sixteen (16) digits were correctly entered in the Insert or Swipe Card, or Type PAN text box on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

R6: To accommodate the R6 requirement for this enhancement, CDP's QA staff ensured that the Insert or Swipe Card, or Type PAN text box was working properly on the following screens:

• Assign Card (Clinic)

• Assign Card (Vendor)

DFDD

R7: To accommodate the R7 requirement for this enhancement, the SPIRIT WIC Detailed Functional Design Document (DFDD) was updated to include content that details the PAN number validations and behaviors documented above in requirements R1 through R4 of this enhancement. Refer to the DFDD changes for ENH-503 for more information.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-504

EBT Error Messages

R1: To accommodate the R1 requirement for this enhancement, the code was modified so that all system messages returned from the Universal Interface in regards to EBT and displayed within in the SPIRIT WIC system's interface contain a textual description of the error code as referenced in the Universal Interface Data Elements Matrix. For example: "EBT Card Number has already been issued."

Additionally, some messages displayed within SPIRIT are returned from SPIRIT WIC EBT Middleware (SWEM). By design, these codes are two-digit codes that ensure backwards compatibility with the SPIRIT code.

DFDD

R2: To accommodate the R2 requirement for this enhancement, To accommodate the R1 requirement, all data element codes returned from the Universal Interface in regards to EBT were documented and added to Appendix D of the SPIRIT WIC Detailed Functional Design Document (DFDD) as a new Universal Interface Data Elements Matrix.

EBT Error Messages

R3: To accommodate the R3 requirement for this enhancement, the code was modified so that all system messages returned from the Universal Interface in regards to EBT and displayed within in the SPIRIT WIC system's interface contain not only contain a textual description of the error code but also contain the specific code of the error in parentheses as referenced in the Universal Interface Data Elements Matrix. For example: "EBT Card Number has already been issued. (DT1059)"

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-506

UPC

R1: To accommodate the R1 requirement for this enhancement, a new APL Type list box was added to the UPC screen in the Reference Utility application module.

NOTE: For the basis of this requirement, APL types of "All" and "Commissary" have been added to support Missouri's EBT implementation. While CDP has defined these two APL types to fulfill this enhancement requirement, the Universal Interface is subject to be altered and a subsequent change could be required at a later date.

Page3 (Demographics) and Authorized Vendor File

R2: To accommodate the R2 requirement for this enhancement, a new APL Type drop-down list box was added to the Page3 (Demographics) screen of the Vendor Folder in the Vendor application module.

Additionally, a new APL Type column was added to the Authorized Vendor File generated during End of Day Processing.

UPC List

R3: To accommodate the R3 requirement for this enhancement, a new APL Type column was added to the UPCs data grid on the UPC List screen in the Reference Utility application module.

National UPC File

R4: To accommodate the R4 requirement for this enhancement, a new APL Types column and a new APL Types Description column were added to the National UPC File generated by selecting the Export National UPC Excel File menu option from the EBT UPC Actions menu menu on the UPC List screen in the Reference Utility application module.

NOTE: It is CDP's understanding that no clients currently use the National UPC File text output generated by selecting the Export National UPC Text File menu option from the EBT UPC Actions menu menu on the UPC List screen in the Reference Utility application module. Therefore, no code changes were made to the National UPC File text output for this enhancement.

Approved Product List (APL) File

R5: To accommodate the R5 requirement for this enhancement, a new Filler column (3 spaces) and a new APL Types column were added to the Approved Product List (APL) File generated during End of Day Processing and also by selecting the Send UPC File to EBT System menu option from the EBT UPC Actions menu menu on the UPC List screen in the Reference Utility application module.

UPC List

R6: To accommodate the R6 requirement for this enhancement, CDP's QA staff validated that APL type values were included when the Update Multiple Items check box was checked on the UPC List screen in the Reference Utility application module.

SUG Review

R7: To accommodate the R7 requirement for this enhancement, CDP provided screen clip mock-ups to the CCWG and/or SUG prior to development.

R8: To accommodate the R8 requirement for this enhancement, CDP provided data samples of the UPC list and the Excel export file to the SUG prior to development.

UPC List

R9: To accommodate the R9 requirement for this enhancement, a new APL Type list box was added to the UPC List screen in the Reference Utility application module.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-507

EBT Transaction History

R1: To accommodate the R1 requirement for this enhancement, CDP's QA staff verified that functionality didn't change and that existing data continued to display correctly on the EBT Transaction History screen in the Clinic application module.

R2: To accommodate the R2 requirement for this enhancement, a new Benefit Dates column was added to the Transaction History data grid on the EBT Transaction History screen in the Clinic application module.

DFDD

R3: To accommodate the R3 requirement for this enhancement, the following changes were made to the SPIRIT WIC Detailed Functional Design Document (DFDD):

• A new Transaction Type glossary term was added to the Glossary tab.

• The description for the Transaction Type column in the Transaction History data grid on the EBT Transaction History topic in the Clinic DFDD was updated to include detailed information regarding how the column is populated.

• A new EBT Transactions Matrix was added to Appendix D of the DFDD to document the categories, codes, and descriptions assigned to EBT transactions within the SPIRIT WIC system.

EBT Transaction History Detail

R4: To accommodate the R4 requirement for this enhancement, CDP's QA staff verified that functionality didn't change and that existing data continued to display correctly on the EBT Transaction History Detail screen in the Clinic application module.

R5: To accommodate the R5 requirement for this enhancement, the PFDTU and LDTU benefit dates were added to the title label of the Transaction Details data grid on the EBT Transaction History Detail screen in the Clinic application module.

R6: To accommodate the R6 requirement for this enhancement, new Participant Name and State WIC ID text and value labels were added to the EBT Transaction History Detail screen in the Clinic application module.

R7: To accommodate the R7 requirement for this enhancement, a new Staff Member text and value label was added to the EBT Transaction History Detail screen in the Clinic application module.

SUG Review

R8: To accommodate the R8 requirement for this enhancement, CDP provided screen clip mockups to the SUG prior to development.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-508

AdditionalInfo2

R1: CDP determined that a change to the SPIRIT user interface was not required and that sending "NULL" to the back-end would resolve the EBT errors experienced by the users.

Therefore, to accommodate the R1 requirement for this enhancement, the code in the Clinic application module was modified as follows:

• The Add CardholderCard message was modified to send the LANGUAGE_IND as NULL regardless of the value selected in the Correspondence Preference drop-down list box on the AdditionalInfo2 (Demographics) sub-tab within the Participant Folder.

• The Update CardholderCard message was modified to send the LANGUAGE_IND as NULL regardless of the value selected in the Correspondence Preference drop-down list box on the AdditionalInfo2 (Demographics) sub-tab within the Participant Folder.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-512

EBT Household Demographics

R1: To accommodate the R1 requirement for this enhancement, the text: "Alternate Representative/Proxy" was changed to display as "Alternate Representative/Proxy 1" for primary alternate authorized representatives and primary proxies that are recorded for the household but do not display State WIC IDs in the State WIC ID column within the EBT Household Representatives data grid on the EBT Household Demographics screen in the Clinic application module.

EBT Household Demographics

R2: To accommodate the R2 requirement for this enhancement, the text: "Alternate Representative/Proxy" was changed to display as "Alternate Representative/Proxy 2" for secondary alternate authorized representatives and secondary proxies that are recorded for the household but do not display State WIC IDs in the State WIC ID column within the EBT Household Representatives data grid on the EBT Household Demographics screen in the Clinic application module.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-513

Edit Authorized Representative

R1: To accommodate the R1 requirement for this enhancement, a new Edit Auth Rep button was added to Select Existing Household screen. When clicked, a new Edit Authorized Representative screen displays, which allows users to update the authorized representative information for a household.

Additionally, a new Authorized Representative group box was added to the Create New Household screen in the Clinic application module.

Create New Household

R2: To accommodate the R2 requirement for this enhancement, information in the new Authorized Representative group box on the Create New Household screen in the Clinic application module initially defaults to blank and is required to create a new household. If required information is not specified in the Authorized Representative group box, a standard error message E0001 displays when the OK button is clicked.

Select Existing Household

R3: To accommodate the R3 requirement for this enhancement, a new Authorized Representative column was added to the Households data grid on the Select Existing Household screen in the Clinic application module for both non-EBT and EBT-enabled programs.

Create New Household

R4: To accommodate the R4 requirement for this enhancement, the new Authorized Representative group box was added below the Mail group box on the Create New Household screen in the Clinic application module, and in the same manner as the Authorized Representative group box on the Applicant Prescreening screen displayed when selecting the Create New Household menu option on the Participant List menu on the Participant List screen in the Clinic application module.

EBT Household Demographics

R5: To accommodate the R5 requirement for this enhancement, CDP's QA staff verified that when the Change Household ID screen is closed within the Clinic application module, the authorized representative identified for the household is displayed in the EBT Household Representatives data grid on the EBT Household Demographics screen.

R6: To accommodate the R6 requirement for this enhancement, CDP's QA staff verified that the user is able to set the authorized representative as the primary cardholder after adding a date of birth for the authorized representative on the EBT Household Demographics screen.

EBT Household Demographics

R7: To accommodate the R7 requirement for this enhancement, the assignment of a primary cardholder is now required on the following screens when attempting to send EBT data to the EBT processor system:

• EBT Household Demographics (Clinic)

• EBT Household Demographics (Vendor)

If a primary cardholder has not been specified when the Send EBT Data button is clicked on these screens, a new I0075 standard information message displays with the following text: "Missing primary account. Select a row and click Set As Primary to set the primary account holder."

Lock Household

R8: The CCWG voted to place a hold on this requirement as Maine believes the other requirements in this enhancement will address the locking of the household during this process. Maine indicated that if the other changes in this enhancement do not address the locking of the household, the CCWG may request to add this feature later through a corrective release.

Therefore, no changes were made to the code  for this requirement at this time.

State Office

R9: To accommodate the R9 requirement for this enhancement, CDP provided screen clip mockups to the SUG prior to development.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-517

In-line SQL Conversion

R1: To accommodate the R1 requirement for this enhancement, the in-line SQL methods identified in the database changes documented for this enhancement were converted to into stored procedures.

Please see the In-line SQL Conversion topic for more information about the changes made to the SPIRIT WIC System for this requirement.

Management Console

R2: To accommodate the R2 requirement for this enhancement, a new In-line SQL Conversion topic was added to the SPIRIT WIC Detailed Functional Design Document (DFDD). This new topic specifically details the changes made to the SPIRIT WIC System for this enhancement. This new topic is also packaged and included with the paper-based version of the 2.25 release notes.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

SWM-002

Assign Primary Cardholder

R1: To accommodate the R1 requirement for this enhancement, the SPIRIT WIC system now displays a standard error message (E0004) with the text: "A primary cardholder must be assigned." if a primary cardholder has not been selected for the household when the Send EBT Data button is clicked on the on the following screens:

• EBT Household Demographics (Clinic)

• EBT Household Demographics (Vendor)

Assign Primary Cardholder

R2: To accommodate the R2 requirement for this reported issue, the SPIRIT WIC system will not automatically assign a primary cardholder. Users must manually assign primary cardholders within the SPIRIT WIC system.

Change Primary Cardholder

R3: To accommodate the R3 requirement for this enhancement, the SPIRIT WIC system now displays a standard information message (I0075) with the text: "Missing primary account. Select a row and click Set As Primary to set the primary account holder." if the primary cardholder has been removed from the household and the Send EBT Data button is clicked on the on the following screens:

• EBT Household Demographics (Clinic)

• EBT Household Demographics (Vendor)

Additionally, the code was modified to display a standard information message (I0077) with the text: "Changes to the Alternate Representative/Proxy 1 cannot be saved as the alternate representative/proxy 1 is currently assigned as the Primary Cardholder for the EBT Household. Please adjust the Primary Cardholder within the EBT Household Demographic Screen." if the user attempts to delete or modify information for an authorized representative, proxy 1, or proxy 2 and save changes on the AdditionalInfo2 screen in the Participant Folder and the authorized representative, proxy 1, or proxy 2 being modified is currently assigned as the primary cardholder and/or has been assigned a card on the EBT Household Demographics screen.

Assign Primary Cardholder

R4: To accommodate the R4 requirement for this enhancement, a new PrimaryCardHolderAgeLimit business rule was added to the SPIRIT WIC system to allow each state to control whether the assignment of a primary cardholder is allowed for participants under the age of five (5) years.

Additionally, the SPIRIT WIC system now displays a standard information message (I0076) with the text: "Primary Cardholder must be 5 years or older." if the value of the PrimaryCardHolderAgeLimit business rule equals "Y", a child under the age of five (5) is selected in the EBT Household Representatives data grid, and either the Set as Primary button or the Assign Card button is clicked on the following screens:

• EBT Household Demographics (Clinic)

• EBT Household Demographics (Vendor)

EBT Household Change Guided Script

R5: To accommodate the R5 requirement for this enhancement, the SPIRIT WIC system will not lock the household during household changes and will allow successful completion of the EBT Household Change Guided Script in the Clinic application module.

Additionally, the code was modified within the EBT Household Change Guided Script in the Clinic application module so that when the Determine New Household link is clicked, the EBT Household Demographics screen will only display when a new household is created on the Create New Household screen.

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

SWM-001

ZIP Codes

The SPIRIT WIC system was dropping leading zeroes in ZIP codes and preventing users from issuing EBT cards to participants.

The following changes were made in the SPIRIT WIC system:

• A column named "Zip" that was incorrectly defined as an integer in dsEBTHouseholdAccount (which is used to transmit EBT data) was fixed.

• The vendor mailing section that addresses ZIP codes was rewritten to fix seventeen (17) formatting errors and a new class named "WIC.Common.ZipCode" was created for future ZIP code formatting needs.

• A new class named "LetterMailMergeGenerator" was created with code extracted from frmSendLetters.

Additionally, SPIRIT WIC EBT Middleware (SWEM) had a bug that caused the addition of a leading zero to the zip even if it already had a leading zero. SWEM was fixed and SWEM version 1.1.0.8 was created.

SWM-4

Benefits History

The SPIRIT WIC system returned an Unhandled Exception error when reprinting a shopping list on the Benefits History tab within the Participant Folder in the Clinic application module.

The unhandled exception was fixed by changing the column types to string for three datetime columns. Three new properties were added to the dataset to access the fields as datetimes. Additionally, some of the fields were converted to new fields where appropriate.

SWM-5

Benefits History

In the EBT staging environment, when viewing the details of benefits on the Benefit Details screen in the Clinic application module, "Batch User" displayed as the name of the staff member that issued the benefits.

If anonymous connections are allowed on the IIS server, the user identification is not passed by the service. This results in a blank user identification, which is subsequently updated to "BATCHUSER" as the user identification when saving a food instrument in the SPIRIT WIC system. This is the expected behavior based on how the server is set up and is therefore working as intended.

SWM-7

Change Primary Cardholder

In the SPIRIT WIC system, when a primary cardholder and the card number are initially assigned through the EBT Household Demographics screen, the data on the screen correctly matches the data on the EBT Card History screen and the data in WIC Direct. However, when the primary cardholder was changed and a new card number was assigned, the data no longer matched on the EBT Household Demographics screen, the EBT Card History screen, and WIC Direct.

Much of the primary method in the AcctSetupMsgHandler.cs file was rewritten in the SPIRIT WIC EBT Middleware (SWEM) interface to call the updatecardholder method; then, if needed also, the method also calls the replace card method.

SWM-8

Issue Benefits

When benefits were voided for multiple household members with the same benefits dates (the same LDTUS) and a new benefit issuance was attempted for the household, the Issue Benefits screen in the Clinic application module displayed incorrect and inconsistent messages regarding the reason(s) benefits could not be issued.

SWM-11

Food Adjustment Wizard

When the Void Current and Future Benefits radio button was selected and the OK button was clicked on the Food Adjustment Wizard screen in the Clinic application module, a "DT-69 Database Communication Error" displayed.

SWM-12

Food Adjustment Wizard

Over-issuance was occurring when exchanging food items already issued on the Food Adjustment Wizard screen in the Clinic application module.

SWM-14

Food Adjustment Wizard

When attempting to exchange multiple food items on the Food Adjustment Wizard screen in the Clinic application module, a "Column 'StateWICID, FDTU, LDTU, Category, SubCategory' is constrained to be unique" error occurred.

SWM-16

EBT Household Demographics

SWEM was only returning one of the two cardholders to the SPIRIT WIC system, but both cardholders were being sent back by WIC Direct. This resulted in the PrimaryAltIndicator not being sent to SWEM.

The SPIRIT WIC system was updated as follows:

• The PrimaryAltIndicator field of the message was populated.

• If two cards were assigned, the code was modified to disable the Assign Card button until one of the cards is removed on the following screens:

• EBT Household Demographics (Clinic)

• EBT Household Demographics (Vendor)

SWM-17

Mid-certification Assessment

The EBT Household Demographics check box was incorrectly becoming unchecked on the Mid-certification Assessment screen in the Clinic application module.

A change in language should not force an EBT update. Therefore, the SPIRIT WIC system was modified to remove the language check. Additionally, the following stored procedures were updated:

• uspUpdateStepInCertHistory

• GetNextCertHistoryID

SWM-18

EBT Transaction History Detail

Descriptions were incorrectly displayed in the Subcategory column on the EBT Transaction History Detail screen in the Clinic application module.

"<>" was changed to "=" for subcategories in the WIC.FoodInstruments.dsFoodInstruments.EbtCatSubcatsData table.

SWM-19

EBT Transaction History

The EBT Transaction History screen in the Clinic application module displayed a date and time stamp that was four hours later than the actual time that the transaction occurred.

The following changes were made to the SPIRIT WIC EBT Middleware (SWEM) interface:

• A time zone conversion was added for the local time on the box where the SWEM is running.

• A new WIC_STATE_AGENCY_SETTINGS table was added to support time zone settings as well as future settings.

• Procedures were added for CRUD operations on the settings table.

• DAL/IDAL and Business Layer objects were added.

• New constants and a new Object model were added.

• A new section "settings" was added to the web administrative application to allow the time zone updates and to verify that the results returned to the SPIRIT WIC system change accordingly.

Additionally, minor cosmetic changes were made to the SPIRIT WIC EBT Middleware (SWEM) interface's website.

SWM-21

EBT Transaction History

If the date range specified on the EBT Transaction History screen in the Clinic application module included the date on which a redemption occurred, a "DT9999" error displayed.

The following changes were made to the SPIRIT WIC EBT Middleware (SWEM) interface:

• Service references were updated.

• Timeout issues were fixed.

• The version number was incremented.

• Logging support was enhanced.

SWM-23

Food Adjustment Wizard

When the Void Future Benefits radio button was selected and the OK button was clicked on the Food Adjustment Wizard screen in the Clinic application module, avoid issuance error displayed.

SWM-24

EBT Household Demographics

An object reference error displayed when the authorized representative's date of birth was deleted and the EBT Household Demographics screen was processed in the Clinic application module.

The SPIRIT WIC system was modified to add a date of birth validation to the update process on the EBT Household Demographics screen in the Clinic application module.

SWM-25

EBT Household Demographics

A "DT1012" error displayed when an EBT card was not already assigned to a household and a primary cardholder was assigned the EBT Household Demographics screen was processed in the Clinic application module.

The SPIRIT WIC system was modified to trap and ignore the exception when it occurs so that the "DT1012" error no longer displays when an EBT card is not already assigned to a household and a primary cardholder is assigned.

SWM-27

EBT Household Demographics

A primary key constraint error message was displaying when accessing the EBT Household Demographics screen.

A database transaction was added to lock the table when the file is saved. Adding the new database transaction with tablelock and hold resolved this issue.

SWM-29

EBT Household Demographics

The SPIRIT WIC system was changing the date of birth for each of the authorized representative listed on the EBT Household Demographics screen.

The SPIRIT WIC system was modified to change the save function to use the date of birth in the EBT Household Representatives data grid instead of the date of birth in the calendar control on the following screens:

• EBT Household Demographics (Clinic)

• EBT Household Demographics (Vendor)

SWM-31

End of Day Processing

The following issues were reported:

• The WIC Activity File (MEWACT) failed to parse during SPIRIT End of Day Processing.

• WIC Benefit Purge File (MEWEXP) failed to parse during SPIRIT End of Day Processing.

• SWEM Output files for WIC Direct contained the incorrect byte order mark.

• UPC Files generated by SWEM had an incorrect Broadband Purchase Indicator.

The following changes were made to the SPIRIT WIC EBT Middleware (SWEM) interface:

• The file output was corrected so that values are trimmed prior to adding padding to prevent oversizing of whitespace output. This applies to all of the fields that were dynamic from within this file format.

• Updated the code for file processing to support leading zeros in the WIC Agency Id.

• The version was updated from 1.0.0.21 to 1.1.0.0.

SWM-39

EBT Household Change Guided Script

In the SPIRIT WIC system, an "Invalid/Missing Cardholder Date of Birth" message was displaying during EBT Household Change Guided Script which prevented the user from completing the script.

A nullable DateTime cleaning function was added to the AcctSetupMsgHandler in the SPIRIT WIC EBT Middleware (SWEM) interface to use the constant value to parse the date in the SPIRIT WIC system.

Additionally, the DeserializeJPMAccountSetupResponse in the SPIRIT WIC system was updated to separate the date of birth correctly when returned from the SPIRIT WIC EBT Middleware (SWEM) interface in different formats.

TMP-41 / TTY-23

Food Prescriptions

In the SPIRIT WIC system, a new food prescription was automatically added by the system when the Food Prescription link on the Certification Guided Script screen was selected by a user who had view-only permissions to the Food Prescriptions Feature within the Participant Management Feature Group.

The following files and methods were updated to no longer automatically generate food prescriptions for users who have view-only permissions to the Food Prescriptions Feature within the Participant Management Feature Group:

• ctlHealthInformation.vb -ModifyPrescriptionIfPregnantAndBFAmountChanged

• ctlFoodPrescription.vb - AddDefaultFoodPrescriptions

• frmParticipantFolder.vb - ModifyMothersPrescription

• frmCertificationStep.vb - ModifyPrescriptionIfBFAmountChangedInfant

• clsAlterPrescription.vb - UpdateMother

• frmCertificationRiskFactors.vb - SaveCertificationRiskFactorsbutton

• frmMothersWicCategoryChange.vb - SaveInfants

• frmParticipantFolder.vb - SaveChanges

TMP-219

UPC List

In the SPIRIT WIC system, generation of UPC List in the Reference Utility application module required excessive use of memory.

CDP's research indicated that the UPC List screen in Reference Utility application module was using roughly two (2) GB of memory, and that the SPIRIT WIC system was not releasing the memory used once the UPC List screen was closed. As a result, users were receiving out-of-memory errors when they tried to open other application modules (like Clinic) because their local systems had no available memory.

Therefore, to resolve these out-of-memory errors, the code was modified to release the memory used by the UPC List screen when screen is closed. The following code changes were made:

• A new Services Agent/Service was added to return the UPC list data in a dataset format (named dsUPCs).

• The UPC List screen was modified to use the dsUPCs dataset returned from the Services Agent/Service to load the UPCs data grid screen.

• The Search, Sort, Edit, Add, Delete and load events were updated to work with the new dsUPCs dataset.

• The Delete and Edit database operations were updated.

TTY-37

Issue Benefits

Missouri was unable to issue one month of benefits on the first of the month while recertifying of existing participants in the SPIRIT WIC system.

CDP discovered that if the comparison logic for the FDTU and the Date Benefits Allowed was ">=", the failure to issue one month of benefits occurred. The code was modified to change ">=" to ">" in WIC.Windows.FoodInstruments.CheckProcess.IsValidBenefitsPeriod to resolve this issue.

TTY-38

Benefit Cycle Adjustment

The SPIRIT WIC system was suggesting sets of benefits for future months with a PFDTU on the 30th of the month, which is against cycle rules.

For example, if a participant is certified on the 29th, 30th, or 31st of the month and they do not have an established cycle, or if another member in the household doesn't have an established cycle, the participant's first set should be a syncing set that runs through the last date of the current month, and after which the participant's cycle should then be set to monthly. In this situation, the SPIRIT WIC system was giving a cycle of the 30th to the last day of the next month.

CDP verified that this bug did not occur in release 2.20, and that new but undiscovered bugs were introduced with the code changes made for TMP-144 in release 2.21.

As this is quite a severe and large problem, one which is much too involved to fix in a small corrective release, the code changes made for TMP-144 in the 2.21 code bases were reverted back to the 2.20 code base for this corrective release.

TMP-144 will be re-engineered in a subsequent large corrective release, which is currently anticipated for release 2.25.01.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

ENH-501

Glossary

(all .chms)

The following new glossary terms were added to the Glossary tab of the DFDD:

• WIC Terminal

• WIC POS Terminal

• TPP

• Third-Party Processor

Central Administrative Site

(centadmn.chm)

Documentation for the Returned/Recovered tree list node in the Benefits History tree list on the Benefits History topic in the Central Administrative Site DFDD was updated to contain detailed information about how the Returned/Recovered tree list node is populated for food items.

Clinic

(clinic.chm)

Documentation for the Returned/Recovered tree list node in the Benefits History tree list on the Benefits History topic in the Clinic DFDD was updated to contain detailed information about how the Returned/Recovered tree list node is populated for food items.

State Office

(stateofc.chm)

Documentation for the Returned/Recovered tree list node in the Benefits History tree list on the Benefits History topic in the State Office DFDD was updated to contain detailed information about how the Returned/Recovered tree list node is populated for food items.

ENH-503

Glossary

(all .chms)

New Bank Identification Number and BIN glossary terms were added to the Glossary tab of the DFDD.

Clinic

(clinic.chm)

The Clinic DFDD was updated to include the content below which details the processes that occur when the OK button is clicked on the Assign Card screen.

Vendor

(vendor.chm)

The Vendor DFDD was updated to include the content below which details the processes that occur when the OK button is clicked on the Assign Card screen.

ENH-504

Appendix

(busrule.chm)

To document all data element codes returned from the Universal Interface in regards to EBT within the DFDD, a new Universal Interface Data Elements Matrix was added to Appendix D.

Additionally, some messages displayed within SPIRIT are returned from SWEM. By design, these are two-digit codes that maintain backwards compatibility.

ENH-506

Reference Utility

(refutil.chm)

The Reference Utility DFDD was updated as follows:

• A new APL Type list box was added to the UPC List topic.

• A new APL Type column was added to the UPCs data grid on the UPC List topic.

• The Send UPC File to EBT System menu option on the EBT UPC Actions menu menu topic was rewritten

• A new APL Type list box was added to the UPC topic.

• A new APL Types column was added to the National UPC File topic.

• A new APL Types Description column was added to the National UPC File topic.

Scheduled Job Administration

(jobadmn.chm)

The Scheduled Job Administration DFDD was updated as follows:

• A new APL Type column was added to the Authorized Vendor File.

• A new Filler column (3 spaces) was added to the Approved Product List (APL) File.

• A new APL Types column was added to the Approved Product List (APL) File.

Vendor

(vendor.chm)

A new APL Type drop-down list box was added to the Page3 (Demographics) topic in the Vendor DFDD.

ENH-507

Glossary

(all .chms)

A new Transaction Type glossary term was added to the Glossary tab of the DFDD.

Clinic

(clinic.chm)

The following changes were made to the Clinic DFDD:

• A new Benefit Dates column was added to the Transaction History data grid in the EBT Transaction History topic.

• The description of the Transaction Type column within the Transaction History data grid in the EBT Transaction History topic was updated to contain detailed information about transaction types.

• PFDTU and LDTU benefit dates were added to the title label of the Transaction Details data grid in the EBT Transaction History Detail topic.

• A new Participant Name text and value label was added to the EBT Transaction History Detail screen.

• A new EBT System Message text and value label was added to the EBT Transaction History Detail screen.

• A new State WIC ID text and value label was added to the EBT Transaction History Detail screen.

• A new Staff Member text and value label was added to the EBT Transaction History Detail screen.

ENH-512

Clinic

(clinic.chm)

The content for the EBT Household Representatives data grid on the EBT Household Demographics topic was rewritten to document that the data grid displays household members, authorized representatives, alternate authorized representatives, and proxies recorded for the household.

Additionally, content was added to the State WIC ID column within the EBT Household Representatives data grid on the EBT Household Demographics topic to document the text that displays for authorized representatives, alternate authorized representatives, and proxies that are recorded for the household but do not display State WIC IDs within the column.

Vendor

(vendor.chm)

The content for the EBT Household Representatives data grid on the EBT Household Demographics topic was rewritten to document that the data grid displays the household member and authorized representative recorded for the household on the Compliance Buy (Participant Information) screen.

Additionally, content was added to the State WIC ID column within the EBT Household Representatives data grid on the EBT Household Demographics topic to document that if an authorized representative was entered on the Compliance Buy (Participant Information) screen, the State WIC ID column displays the text "Authorized Representative" instead of the State WIC ID for the authorized representative.

ENH-513

Appendix

(busrule.chm)

In Appendix D, a new I0075 standard information message was added to the Messages Matrix.

Clinic

(clinic.chm)

The following changes were made to the Clinic DFDD:

• A new Edit Auth Rep button was added to Select Existing Household topic.

• A new Edit Authorized Representative topic was added.

• A new Authorized Representative group box was added to the Create New Household screen.

• A new Authorized Representative column was added to the Households data grid on the Select Existing Household topic.

• A new Check for Primary Cardholder Assignment process was added to the processing section for the Send EBT Data button on the EBT Household Demographics topic.

Vendor

(vendor.chm)

A new Check for Primary Cardholder Assignment process was added to the processing section for the Send EBT Data button on the EBT Household Demographics topic in the Vendor DFDD.

ENH-517

DFDD

(wicdfdd.chm)

A new In-line SQL Conversion topic was added to the SPIRIT WIC Detailed Functional Design Document (DFDD).

SWM-002

Appendix

(busrule.chm)

In Appendix B, a new PrimaryCardHolderAgeLimit business rule was added.

In Appendix D, the following changes were made to the Messages Matrix:

• New Variant Text was added to the standard information message E0004, and the Message Trigger was rewritten to accommodate additional requirements.

• A new standard information message I0076 was added.

• A new standard information message I0077 was added.

Clinic

(clinic.chm)

The EBT Household Demographics topic in the Clinic DFDD was updated as follows:

• The Screen Access section was rewritten to detail the methods in which the screen displays during the household ID change process.

• A new Check for Cardholder Under Age 5 process was added to the processing section for the Set as Primary button.

• A new Check for Cardholder Under Age 5 process was added to the processing section for the Assign Card button.

Additionally, the documentation for the Determine New Household link on the EBT Household Change Guided Script topic was rewritten to detail the processing that occurs when the user closes the Change Household ID screen.

Vendor

(vendor.chm)

The EBT Household Demographics topic in the Vendor DFDD was updated as follows:

• The Screen Access section was rewritten to detail the methods in which the screen displays during the household ID change process.

• A new Check for Cardholder Under Age 5 process was added to the processing section for the Set as Primary button.

• A new Check for Cardholder Under Age 5 process was added to the processing section for the Assign Card button.

SWM-16

Clinic

(clinic.chm)

The Assign Card button on the EBT Household Demographics topic in the Clinic DFDD was updated to indicate that the control is disabled when a primary cardholder has not yet been assigned or when two cards are already assigned to the household.

Vendor

(vendor.chm)

The Assign Card button on the EBT Household Demographics topic in the Vendor DFDD was updated to indicate that the control is disabled when a primary cardholder has not yet been assigned or when two cards are already assigned to the household.