2.26.01 Release Notes

Contents Show

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

ENH-515

New USDA regulations indicate that the closely-spaced indicator for risk factor 332 should be based on a live birth within eighteen (18) months of the LMP Start Date on the Pregnancy Information screen in the Clinic application module of the SPIRIT WIC system.

As a result, the SPIRIT WIC system was modified to accommodate the new USDA regulations for the closely-spaced indicator. Refer to the documentation in the table below for detailed information regarding the code changes made for this enhancement.

Some states may have an extra constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table. If your state currently has an FK constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table, the script below MUST be run manually on the database. Failure to run the script below in states that currently have an FK constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table will cause problems with this release of the software.

IF EXISTS (SELECT * FROM sys.foreign_keys

WHERE object_id = OBJECT_ID(N'FK_RISKFACTORREF_PRIORITYWICSTS')

AND parent_object_id = OBJECT_ID(N'RISKFACTORREFERENCE')

)

ALTER TABLE [dbo].[RISKFACTORREFERENCE]

DROP CONSTRAINT [FK_RISKFACTORREF_PRIORITYWICSTS]

IF EXISTS (SELECT * FROM sys.foreign_keys

WHERE object_id = OBJECT_ID(N'FK_RISKFACTORREF_FOODPKG')

AND parent_object_id = OBJECT_ID(N'RISKFACTORREFERENCE')

)

ALTER TABLE [dbo].[RISKFACTORREFERENCE]

DROP CONSTRAINT [FK_RISKFACTORREF_FOODPKG]

ALTER TABLE [dbo].[RISKFACTORREFERENCE]

ALTER COLUMN [ASSIGNMENTRESTRICTION] CHAR (1) NULL

For some of the USDA regulation changes to risk factors, users MUST manually update the high risk thresholds for the risk factors in the Reference Utility application module. For more information, see the Edit High Risk Threshold screen.

Enhancement#

Primary Function

Enhancement Detail

ENH-515

 Database Changes

Risk Factor 332

R1: To accommodate the R1 requirement for this enhancement, all of the currently-existing code related to the system assignment of risk factor 332 was disabled within the SPIRIT WIC system.

R2: To accommodate the R2 requirement for this enhancement, a new Live Birth within 18 Months check box was added to the Previous Pregnancy Information group box on the following screens in the following application modules:

  • Pregnancy Information (Central Administrative Site)

  • Pregnancy Information (Clinic)

  • Pregnancy Information (State Office)

R3: To accommodate the R3 requirement for this enhancement, a new Live Birth within 18 Months check box was added to the Any History Of group box on the following screens in the following application modules:

  • Postpartum Information (Central Administrative Site)

  • Postpartum Information (Clinic)

  • Postpartum Information (State Office)

R4: To accommodate the R4 requirement for this enhancement, the Live Birth within 18 Months check box is enabled throughout the entire certification period (not only during the Certification Guided Script) on both the Pregnancy Information and the Postpartum Information screens (depending on the current certification status of the participant (pregnant or postpartum)) in the Clinic application module.

R5: To accommodate the R5 requirement for this enhancement, risk factor 332 is system-assigned to the participant record whenever the Live Birth within 18 Months check box is checked on either the Pregnancy Information or the Postpartum Information screens (depending on the current certification status of the participant (pregnant or postpartum)) in the Clinic application module.

Note

NOTE: Risk factor assignments can be viewed on the following screens in the Clinic application module:

  • Assign Certification Risk Factors

  • Certification Guided Script

  • Mid-certification Assessment

  • Risk Factors
 
 
 

Reported Issues

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

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

CDP-159

Risk Factors

Risk factor 201 was incorrectly being removed from the participant record when a Lead (ug/dl) measurement was entered on the Blood Measurement screen and a pseudo-certification was created.

The SPIRIT WIC system was modified as follows:

  • A condition was added to remove risk factor 201 from the participant record only when the participant is in a valid certification period or the participant is currently being certified.

  • A WicStatusCode is now being returned in MostRecentInCertPeriod to prevent SPIRIT from the condition skipping condition when assigning risk factor 201.

CDP-160

Risk Factors

Risk factor 201 was not assigning correctly when a Hemoglobin (gm/dl) measurement below the anemia cut-off level was added for a participant outside of a certification attempt.

This reported issue was resolved as a result of changes made to the SPIRIT WIC system for CDP-159.

CDP-161

DFDD Changes

DFDD and Release Notes

Release 2.26.00's documentation changes for risk factor 602 in the Risk Factors Matrix of the DFDD and also in the 2.26.00 Release Notes contained the following errors:

  • The value in the Description column for the "Pregnant" row did not state that the pregnant woman must also be breastfeeding.

  • The value in the Assignment column for the "Breastfeeding" row incorrectly stated that the method of assignment was "Both System and CPA Assigned" instead of "CPA Assigned Only".

Additionally, the 2.26.00 Release Notes incorrectly contained the following bullet point in the DFDD Updates section for ENH-515 and risk factor 602:

  • The values in the Formula column for all rows were changed from "≥ 10" to "≥ 5".

The SPIRIT WIC DFDD and the 2.26.00 Release Notes were updated to resolve this issue. For more information, refer to the DFDD Updates for this release.

CDP-164

Risk Factors

Risk factor 201 was removed incorrectly when a pseudo-certification was created after a simple change (such as updating the demographic information) was made and the change was saved.

This reported issue was resolved as a result of changes made to the SPIRIT WIC system for CDP-159.

DFDD Updates

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

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

CDP-161

Code Changes

Appendix

(busrule.chm)

The following changes were made to the Risk Factors Matrix in Appendix D of the DFDD:

  • Risk factor 602 was updated as follows:

  • The value in the Description column for the "Pregnant" row was changed from {blank} to "A pregnant woman with any..." to "A pregnant woman who is also breastfeeding with any..."

  • The value in the Assignment column for the "Breastfeeding" row was changed from "Both System and CPA Assigned" to "CPA Assigned Only".

Release Notes

(wicdfdd.chm)

Changes were also made to the 2.26.00 Release Notes topic in the DFDD. Under the DFDD Updates section for ENH-515 and risk factor 602, the following changes were made:

  • The value in the Definition column for the "Pregnant" row was changed from {blank} to "A pregnant woman with any..." to "A pregnant woman who is also breastfeeding with any..."

  • The following bullet points were removed entirely:

  • The value in the Assignment column for the "Breastfeeding" row was changed from "CPA Assigned Only" to "Both System and CPA Assigned".

  • The values in the Formula column for all rows were changed from "≥ 10" to "≥ 5".

ENH-515

Code Changes

Appendix

(busrule.chm)

In Appendix D of the DFDD, the following changes were made to Risk factor 332 in the Risk Factors Matrix:

  • The values in the Assignment column for all applicable rows were changed from "System Assigned Only" to "Both System and CPA Assigned".

  • The value in the Formula column for the "Pregnant" row was changed to "The system will assign the risk factor whenever the Live Birth within 18 Months check box is checked on the Pregnancy Information screen in the Clinic application module."

  • The values in the Formula column for the "Breastfeeding" and "Non-breastfeeding" rows were changed to "The system will assign the risk factor whenever the Live Birth within 18 Months check box is checked on the Postpartum Information screen in the Clinic application module."

Central Administrative Site

(centadmn.chm)

The following changes were made to the Central Administrative Site DFDD:

  • A new Live Birth within 18 Months check box was added to the Previous Pregnancy Information group box on the Pregnancy Information topic.

  • A new Live Birth within 18 Months check box was added to the Any History Of group box on the Postpartum Information topic.

Clinic

(clinic.chm)

The following changes were made to the Clinic DFDD:

  • A new Live Birth within 18 Months check box was added to the Previous Pregnancy Information group box on the Pregnancy Information topic.

  • A new Live Birth within 18 Months check box was added to the Any History Of group box on the Postpartum Information topic.

State Office

(stateofc.chm)

The following changes were made to the State Office DFDD:

  • A new Live Birth within 18 Months check box was added to the Previous Pregnancy Information group box on the Pregnancy Information topic.

  • A new Live Birth within 18 Months check box was added to the Any History Of group box on the Postpartum Information topic.

|

Documentation Delivery Date: 08/26/2016