Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The REFERENCEDICTIONARY table was updated as follows:
Where the value of the CATEGORY column equals "MOVTYPE", the value of the DESCRIPTION column was updated as follows:
"Non-MOV" was renamed as "Non-Balto".
"All MOV" was renamed as "All Balto".
"Formula-Only MOV" was renamed as "Formula-Only Balto".
Where the value of the CATEGORY column equals "APLTYPE" and the value of the DESCRIPTION column equals "MOV", the DESCRIPTION column was renamed as "Balto".
The following stored procedures were updated to correct typos:
CreateCdcPediatricFileData
CreateCdcPregnancyFileData
End of Month Command Line Batch Processing now behaves as expected.
The GetNextParticipantConsignmentId stored procedure was updated to ensure that all record identifiers will now be unique.
The PARTICIPANTCONSIGNMENT table was updated by deleting all used blocks and adding one new block that contains all available identifiers.
The InsertInfantsMostlyBF stored procedure was updated to exclude infants whose mothers did not receive benefits from the CASELOADCOUNT and CASELOADCOUNTENROLLMENT tables.
The InsertFIItemRedeemed stored procedure was updated to set the value of the PAIDDATE column within the FOODINSTRUMENT table only when the value is "NULL".
The InsertInfantsMostlyBF stored procedure was updated to use the value of the CERTEFFECTIVEDATE column instead of the value of the CERTSTARTDATE column within the CERTCONTACT table to determine the month when inserting records into the CASELOADCOUNT and CASELOADCOUNTENROLLMENT tables.