Release Notes 2.22.01

Issue: Issue#

Issue: Primary Function

Issue: Detail

Issue: Resolution

Issue: Reported Issues

TMP-151

Breastfeeding Initiation Report

Fixes to functionality from previous release. Identified issues include:

• Enrollee grouping by clinic/agency/grantee should be done based on the initial certification clinic/agency.

• The column labels of the report do not accurately reflect the data displayed.

• The DFDD contains inaccuracies about the tables from which data is pulled.

• Need to provide the number of infants who initiated breastfeeding after 30 days of life.

The functionality has been updated to fix the defects identified during UAT.

• Grouping by clinic/agency/grantee is now driven by the location of the participants' initial certification clinic/agency.

• "BF" was removed from the headers for columns on the report regarding mothers who had been on WIC during pregnancy.

• DFDD updates were made to fix the inaccuracies regarding the tables from which the data is pulled for the report. For more information, see DFDD Updates.

• The calculation was updated for the NOT BF 1st MO After column. The calculation is now:

WHERE EVERBF=Y and BreastfeedingEnded - DateofBirth < 30 days

• Database changes were made. For more information, see Database Changes.

Issue: Issue#

Issue: Primary Function

Issue: Detail

Issue: Resolution

Issue: Enhancements

ENH-045

Certification

Fixes to functionality from previous release. Identified issues include:

• When creating the pseudo-certification record on the first birthday, the certification date did not follow normal pseudo-certification rules.

• The business rules created to support the certification requirement should not have an effect on the CERTTOMONTHEND business rule.

The functionality has been updated to match the new requirements outlined in TTY-17. The requirements include:

• When creating the pseudo-certification record on the first birthday, the certification date follows normal pseudo-certification rules.

• The certification start date of the new certification record will set to the certification start date of the previous certification record.

• The certification end date of the new certification record will be set to the certification end date of the previous certification record.

• The certification effective date of the new certification record will be the current date.

• The certification end date of the previous certification record will be updated to the current date.

• The two business rules added to support the certification requirement (CLN_INFANTCERTLENGTH and CLN_INFANTRECERTBEFORE1STBIRTHDAY) have been updated and do not have an effect on the CERTTOMONTHEND, 1YRINFANTCERT, and CLN_INFANTAGEMCADUEINMONTHS business rules.

• When an infant is recertified within 30 days of its first birthday, the category of the participant does not change.

• Infants 6-11 months old receive a six-month certification regardless of the setting of the business rule for new certifications.

• When an infant is recertified within 30 days of its first birthday, the mid-certification date (if the certification period is more than six months) is calculated as six months from the certification start date. The setting of the mid-certification business rule for infants is ignored, instead using the calculation.

• NOTE: The certification within a month of the infant's first birthday function only applies to re-certifying an infant, not new infant certifications.

• DFDD updates were made. For more information, see DFDD Updates.

• Database changes were made. For more information, see Database Changes.

ENH-458

Blood Work Regulations

Fixes to functionality from previous release. Identified issues include:

• The system allowing a user to continue without a General Note, even when the Delayed Blood Work check box was selected.

• DFDD needs additional content to explain BWISSUANCELIMIT.

The functionality has been updated to fix the defects identified during UAT.

• When the Delayed Blood Work check box is selected, or if the state requires an exception reason, the user must enter a General Note. If a user clicks Cancel without saving a General Note, the entire entry is cancelled, including the blood work record and the user must start over.

• If the Delayed Blood Work check box is selected, the content on the screen can only be edited on the date the check box is selected. If a user opens the screen on another date, the Edit Button is visible but inactive.

• The Edit button for bloodwork in the Certified Guided Script will be enabled and the user will be able to edit the bloodwork so long as the bloodwork record is related the open certification record.

• DFDD updates were made to expand the definitions for BWISSUANCELIMIT. For more information, see DFDD Updates.

ENH-476

Food Packages

Fixes to functionality from previous release. Identified issues include:

• Users are unable to give a CVB to a woman or child who requires FPIII when the Base Food Category and Food Item records are not active for Infant F/V item for Child or Woman categories.

• The 6 mo-1 year base food category is still visible, and it cannot be deactivated.

The functionality has been updated to fix the defect identified during UAT.

• In order to perform correct substitutions for the CVB and Infant Fruit/Vegetable substitutions, database changes must be made. For instructions, see CVB and Infant Fruits/Vegetables Substitution Set-Up.

• The 6 mo-1 year age base food category is now hidden.

• Database changes were made. For more information, see Database Changes.

ENH-477

Risk Factors

Fixes to functionality from previous release. Identified issues include:

• Risk factor 338 cannot be CPA assigned, it can only be system assigned.

• Risk factor 338 should only be assigned if either the Currently Breastfeeding Infant or Currently Breastfeeding Child Over 1 check boxes are selected.

• DFDD changes need to be made: The level for the multiples in relation to base food category screens. Food Item page 2 needs to be updated to Multiples/Enhanced. Update print screen and text.

The functionality has been updated to fix the identified issues.

• A script has been provided to update Risk Factor 338 to be system-assigned only. To install the script:

1. Identify if the script needs to be installed. If a user is able to assign risk factor 338, the script must be run.

2. If the script needs to be installed, run the script ENH477_Update.sql.

3. After the script has run, update the reference data. To do so" right-click the SessionManager icon in the System Tray and select Update Local Reference Data.

• When either the Currently Breastfeeding Infant or Currently Breastfeeding Child Over 1 check boxes are selected on the Pregnant Health Information screen, risk factor 338 is assigned automatically.

• The DFDD updates have been made. For more details, see DFDD Updates.

• Database changes were made. For more information, see Database Changes.

TMP-041

Permissions

Fixes to functionality from previous release. Identified issues include:

• Users are able to modify or add a food prescription when change the Currently Breastfeeding status of a pregnant participant.

• The following message, found on the Certification Guided Script contains a typo: "You do not have sufficient permission to update FoodPrescription. Please contact your supervisor."

The functionality has been updated to fix the defects identified.

• The permissions for users have been updated. For more information, see the fix highlighted for TMP-205.

• The typo in the error message has been updated. The message now reads: "You do not have sufficient permission to update Food Prescription. Please contact your supervisor."

TMP-154

Scanning

In Missouri, the Cannon CanoScan LIDE 600F no longer works.

The C:\Windows folder contained scanner settings for LCD4X5SE, which is not the correct scanner for Missouri.
The SigPlus.ini file in C:\Windows was replaced, making sure the scanner settings were in place for the correct model, SignatureGemLCD4X5.

TMP-158

Benefit Pickup Report

Fix to functionality from previous release. Identified issue: Fully breastfeeding women are not always displaying on the Benefit Pickup Report if their linked infant is under 6 months old.

The functionality has been updated to fix the defect identified during UAT. Fully breastfeeding women display on the Benefit Pickup Report if the linked infant is under six months old.

Database changes were made. For more information, see Database Changes.

TMP-183/184

MS-2

Food Instrument Redemption

Fix to functionality from previous release. Issues identified are:

• There is a defect in the checkout process that issues PK errors on the FoodInstrumentItemRedeemed table.

• Collissions are occuring when the system is inserting DetailItemID into the FoodInstrumentDetail table.

• MS must align with the core code base.

During the contract transition period, a fix was provided to MS. As a result, the code handed off to CDP did not contain those code changes.

The code has been provided to CDP, and has been merged into this version.

Database changes were made. For more information, see Database Changes.

TMP-205

Permissions

The Food Prescription permissions have not been implemented for the Pregnant Health Information screen.

The permission settings for the Currently Breastfeeding check box on the Infants Born From this Pregnancy were applied to both the Currently Breastfeeding Infant and Currently Breastfeeding Child Over 1 check boxes. If a user has "view" permissions for food prescriptions, if either check box is selected, the following message displays: "You do not have sufficient permission to create a Food Prescription. The Breastfeeding Amount cannot be changed."

Issue: Reported Issues

TTY-1

WICSessionManager.exe

The WICSessionManager.exe failed. Users were requested to delete files in order to successfully run Spirit.

The WicAppLoader must not load the MemCache as it causes SessionManager to crash on update after login because WicAppLoader is still running and holds the table locked in memory.

TheStateUsesLocalACMServers was updated so that it does not use MemCache. By eliminating the use of MemCache, the StateBusinessRules table does not get locked.

The exception handling for threaded RetrieveUpdates was also updated.

TTY-2

Food Packages

When a 9-11 month old received FPIII, the solid foods are being deleted from the food package, with the exception of Fresh Fruits and Vegetables. This should function exactly as it does for the 6-8 month age category.

The code was modified to identify CVB as an infant food. As such, the 9-11 month old FPIII has Fresh Fruits and Vegetables removed from the Default Food Prescription.

TTY-3

Food Packages

While using the Certification Guided Script for the two new age categories (6-8 month; 9-11 month), if a risk factor is system-assigned, it does not display on the main screen.

The code was updated to ensure that system-assigned risk factors display correctly in the Certified Guided Script's main screen.

TTY-4

Certification

The End-of-Day processing changed a number of infants to children because the current date was past their first birthday. In doing so, the system changed the certification start date to the date the 2.22.00 updates were installed. This is a deviation from expected behavior, which should have retained the old certification start date when updating from an infant to a child.

The system was updated to retain the original certification start date for infants changing to a child category. The only date that will updated is CERTEFFECTIVEDATE. This was resolved with the fix listed above for ENH-045.

TTY-5

Food Packages

There should be a way to deactivate the 6 mo-1 year age category.

The code was updated so the 6 mo-1 year age category is hidden. This was resolved with the fix listed above for ENH-476.

TTY-7

Food Packages

When attempting to update a woman with FPIII, a message displays stating the CVB violates the base food category limit and will be removed from the food package. (DOES ANYONE HAVE THE ACTUAL TEXT OF THIS MESSAGE?)

This issue is identical to the first issue identified above for ENH-476. Performing the workaround listed prevents this issue from recurring.

TTY-8

Food Packages

There is a food item that is nor available for the 9-11 month age category, but it can be selected and added to the food prescription.

The system has been modified to ensure that food items that are not available for certain WIC age categories should not be available for selection on a food prescription.

TTY-9

Risk Factors

Risk Factor 201 (Low Hemoglobin/Hematocrit) is not being assigned correctly.

Risk Factor 201 was validated to ensure it is a system-assigned risk factor assigned to an infant who has a recertification prior to its first birthday and the appropriate bloodwork criteria is entered. This was resolved with the fix listed above for ENH-045.

TTY-10

Risk Factors/

Certification

Risk Factor 133 (High Maternal Weight Gain) drops from a participant when a system-assigned risk factor is added or removed and a pseudo-certification is created for a pregnant participant.

Risk Factor 133 is no longer removed if no changes have occurred in the height/weight for the participant. This was resolved with the fix listed above for ENH-045.

TTY-11

Food Packages

The system should still add the CVB to food packages. (NEED MORE DETAIL, ADD FOR WHAT?)

This issue is identical to the first issue identified above for ENH-476. Performing the workaround listed prevents this issue from recurring.

TTY-12

Food Packages

When a woman is fully-breastfeeding multiple infants and the Requires Food Package III check box is selected, she can receive $15 CVB and up to 80 ounces of Infant Fruits and Vegetables.

The stored procedures have been updated to list the maximum substitution values. (DOES THE PROCEDURE CAP THEM OR IS IT UP TO THE USER?)

Database changes were made. For more information, see Database Changes.

TTY-14

Food Packages

When the Replacement Food screen opened, the only food available for selection was the Infant Fruits and Vegetables. The user was unable to change the Infant Fruits and Vegetables to CVB using the Food Adjustment Wizard.

Updated the hard-coded food distribution list of food items allowed.

TTY-15

Certification

When a pseudo-certification is created, the system updates the CERTSTARTDATE rather than just the CERTEFFECTIVEDATE.

This is related to TTY-4 listed above. The system should retain the original certification start date for infants changing to a child category. This was resolved with the fix listed above for ENH-045.

Issue#

DFDD Location

DFDD Resolution

Issue: Reported Issues

ENH-045

Appendix B

busrule.chm

Updated the following two topics:

• CLN_INFANTCERTLENGTH

• CLN_INFANTRECERTBEFORE1STBIRTHDAY

Clinic

clinic.chm

Updated the Certification Menu topic to add more details about infant certification.

ENH-458

Appendix B

busrule.chm

BWISSUANCELIMIT was updated to include definitions of the different values accepted.

ENH-477

Reference Utility

refutil.chm

• The descriptor text for Multiples/Enhanced in the Base Food Category Limits topic was updated.

• Screen captures were updated to show Multiples/Enhanced in the following topics:

• Food Item Wizard page 2

• Base Food Category Limits

• Base Food Category Limits

• Food Item Limits

• Risk Factor Associations

Risk Factor Matrix

Busrule.chm

Updated the Risk Factor Matrix to show Risk Factor 338 as system-assigned.

TMP-151

Central Administration

centadmin.chm

Updated the Breastfeeding Initiation Report topic with the following:

• Added further clarification to introductory paragraphs to include information about the Raw Data Spreadsheet.

• Updated information regarding the tables from which data is pulled for Fully Breastfeeding Infants.

• Updated "breastfed infants" to "infants" in descriptions of column calculations.

• Added further clarification to the Filter Criteria, Base of Data description regarding the tables from which data is pulled.

• Updated the calculation for the NOT BF 1st MO After column of the report.

• Removed the reference to Last Enrolled Month within Date Range and Last Month Fully Breastfeeding within Date Range columns, as they are no longer used.

State Office

stateofc.chm

Updated the Breastfeeding Initiation Report topic with the following:

• Added further clarification to introductory paragraphs to include information about the Raw Data Spreadsheet.

• Updated information regarding the tables from which data is pulled for Fully Breastfeeding Infants.

• Updated "breastfed infants" to "infants" in descriptions of column calculations.

• Added further clarification to the Filter Criteria, Base of Data description regarding the tables from which data is pulled.

• Updated the calculation for the NOT BF 1st MO After column of the report.

• Removed the reference to Last Enrolled Month within Date Range and Last Month Fully Breastfeeding within Date Range columns, as they are no longer used.