Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Created the following state business rules:
Business Rule Name |
Business Rule Description |
Default Value |
CLN_INFANTCERTLENGTH |
Length in months of infant recertification |
6 |
CLN_INFANTRECERTBEFORE1STBIRTHDAY |
Allow an infant subsequent certification to be started prior to the first birthday |
N |
Created the following state business rules:
Business Rule Name |
Business Rule Description |
Default Value |
BWREQUIRENOTE |
Requires a new blood work record |
N |
BWISSUANCELIMIT |
The number of months of issuance that will be enforced based on the selected blood work exception reason |
1 |
Made the following updates to the AGECATEGORY table:
Added the two new age category rows.
Added the column "Active" to the table. All rows were set to Y, except the 6-11 month row, which was set to N.
Updated the RISKFACTORREFERENCE table to make sure all rules for the inactive AgeCategory were duplicated for the two new AgeCategories. No changes were made to the default food packages so the new Risk Factors will need to be edited to point to the new default food packages created for the two new AgeCategories.
Updated the stored procedure uspGetBaseCatLimitInfo to include the new combination baselimit 'LM.'
Added the following state business rules to store conversion factors:
Number |
Business Rules |
296 |
SubstitutionWomenLMcf=.16: Conversion Rate for Women for Cash Value Benefit to Infant Fruit and Vegetables |
297 |
SubstitutionChildrenLMcf=.16: Conversion Rate for Children for Cash Value Benefit to Infant Fruit and Vegetables |
298 |
SubstitutionInfants1LMcf=.16: Conversion Rate for fully breastfed infants for Cash Value Benefit to Infant Fruit and Vegetables |
298 |
SubstitutionInfants245LMcf=.16: Conversion Rate for Infants not fully breastfed for Cash Value Benefit to Infant Fruit and Vegetables |
Added the following business rules to store Cash Value Benefit/Infant Fruit and Vegetable substitution values:
Business Rules |
SubstitutionWomenLMMax=160: Maximum for Women for Infant Fruit and Vegetables |
SubstitutionChildrenLMMax=128: Maximum for Children for Infant Fruit and Vegetables |
SubstitutionInfants1LMMax=128: Maximum for fully breastfed Infants for Infant Fruit and Vegetables to substitute |
SubstitutionInfants245LMMax=64: Maximum for Infants not fully breastfed for Infant Fruit and Vegetables to substitute |
Created a non-clustered index on the FOODINSTRUMENT table.
Modified the following stored procedures:
uspGetDuplicateParticipantData
uspGetPotentialDuplicateParticipants
Made the following updates to the uspReportGetBreastfeedingInitiation procedures:
Created temporary tables for ServiceSites, Grantees, CaseloadData, CertContact and Ethnicity to increase performance
Altered how queries were reading BFHistory table by returning only first record for each enrollee
Changed data range parameters to refer to enrollees birthdate
Removed infant selection criteria
Created new fields for new report categories
Altered WIC mom category logic
Altered ServiceSite temp table logic
Altered CaseLoadData temp table logic
Altered BaseData table variable
Added new fields for PDF output
Change field output logic for FBF Infants percentage
Adjusted Qualifying Infant CTE query conditions for FBF, SBF, MBF and NBF
Adjusted Selected Member CTE query by removing condition that removed FBF Infants