Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The user ID size was changed from "10" to "20" in the uspGetParticipantsForBatchPreprocess and uspGetParticipantsForBatch stored procedures.
A new 2.29.00.asql file was created and distributed with this release. When run, the new 2.29.00.asql file performs the following tasks:
Changes all currently-existing RISKFACTORID 135 columns in the RISKFACTORREFERENCE table to "135Z" and sets the expiration date to yesterday’s date to deactivate these records.
Changes all currently-existing RISKFACTORID 135 columns in the RISKFACTOR table to "135Z".
Changes all currently-existing RISKFACTORID 352 columns in the RISKFACTORREFERENCE table to "352Z".
Changes all currently-existing RISKFACTORID 352 columns in the RISKFACTOR table to "352Z" and sets the expiration date to yesterday’s date to deactivate these records.
Creates and populates new RISKFACTORID 135 columns in the RISKFACTORREFERENCE table and updates the following columns:
Sets the DESCRIPTION to "Slowed/Faltering Growth Pattern".
Sets the PRIORITY to "1".
Sets the EFFECTIVEDATE to today's date.
Sets the DFPPRIORITY to NULL.
Sets the FOODPACKAGEID to NULL.
Creates and populates new RISKFACTORID 352A columns in the RISKFACTORREFERENCE table and updates the following columns:
Sets the DESCRIPTION to "Infectious Diseases - Acute".
Sets the ASSIGNMENTMETHOD to "C".
Sets the EFFECTIVEDATE to today's date.
Sets the DFPPRIORITY to NULL.
Sets the FOODPACKAGEID to NULL.
Creates and populates new RISKFACTORID 352B columns in the RISKFACTORREFERENCE table and updates the following columns:
Sets the DESCRIPTION to "Infectious Diseases - Chronic".
Sets the ASSIGNMENTMETHOD to "C".
Sets the EFFECTIVEDATE to today's date.
Sets the DFPPRIORITY to NULL.
Sets the FOODPACKAGEID to NULL.
The new 2.29.00.asql file includes different scripts that perform various updates for the 2.29.00 software release. Risk factor scripts included within the 2.29.00.asql file perform a check to determine if the state agency is Minnesota. If the current agency is MN, the risk factor scripts within the new 2.29.00.asql file do not run during the 2.29 software upgrade process.
A new RF135_352_pull_off_script.sql file was created and distributed with this release. When run, the new RF135_352_pull_off_script.sql file deletes the outdated risk factors on the target (Production) database and re-inserts the risk factors from the source (UAT) database. Run the script on the source (UAT) database to generate and insert the scripts, then copy the generated scripts and run them on the target (Production) DB.
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
The uspVendorAddNewPriceListItems stored procedure was modified to remove loops and to run instantly to increase performance.