Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Updated the uspCreateMidCertificationRecord procedure to add logic for the infant being recertified within 30 days of its first birthday.
Updated the uspGetFoodItemLimitInfo procedure to remove the GetAgeCatForIAt6Months function.
Made updates to the RISKFACTORREFERENCE table to make Risk Factor 338 system-assigned only. The following changes were made:
Conditions |
Column |
Updated Value |
WICSTATUS=P and RISKFACTORID=338 |
ASSIGNMENTMETHOD |
S |
ASSIGNMENTRESTRICTION |
S |
|
MODIFYDTTM |
Current Date |
Made the following updates to the uspReportGetBreastfeedingInitiation procedure:
Ensured that the Minimum Certification Date for all data was returned.
Updated the NotBreastfeeding1stMonth column calculation to: Difference between Birth Date and Date Breastfeeding Ended < 30 days where EVERBF = Y.
Updated GetBenefitPickup to not return infants, less than six months for fully-breastfeeding women.
Updated the FOODINSTRUMENTREDEEMED table to make REDEEMEDITEMID an identity column.
Added a state business rule that will store the Substitution Value for Maximum for Women BF Multiples for Infant Fruits and Vegetables in the STATEBUSINESSRULES table.
Updated the uspGetBaseCatLimitInfo procedure to add BF Multiples, FPVII+.