Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
In this release, the fix for CDP-271 contains a new .asql script that updates the following tables within the database:
NUTRITIONASSESSMENTCONTACTITEMRISKFACTOR
VENACONTACTRF
Although considered to be a rare circumstance, states that already upgraded to release 2.29.00 may encounter issues with risk factor 135 because the name of risk factor 135 didn't change between the 2.29.00 and the 2.29.01 releases. Some states may notice risk factor 135 on the Risk Factors tab in the Participant Folder and also risk factor 135Z on the Nutrition Assessment screen for all similar records inserted after release 2.29.00. This can happen because records are inserted into the NUTRITIONASSESSMENTCONTACTITEMRISKFACTOR and RISKFACTOR tables when a participant that is at risk for risk factor 135 is certified with a nutrition assessment contact, and if users run the 2.29.01 script on top of an already-upgraded 2.29.00 database, only the risk factors in the NUTRITIONASSESSMENTCONTACTITEMRISKFACTOR table will be updated from risk factor 135 to 135Z, and the records in the RISKFACTOR table are not updated.
Therefore, CDP recommends that states planning to upgrade to release 2.29.01 first roll back their UAT environments to a pre-2.29.00 version of the SPIRIT database before upgrading the software to release 2.29.01. In other words, reset back to a pre-2.29.00 version of the SPIRIT database, then deploy the 2.29.01 database and scripts appropriately and roll 2.29.01 into Production as necessary.
To reset an environment back to a pre-2.29.00 database, complete the following steps:
1. Restore the pre-2.29.01 release database.
2. Upgrade to the 2.29.01 release.
Some states may have already set up data for release 2.29.00. As a result, resetting back to a pre-2.29.00 database may not be a feasible option. For states that choose not to fully reset to a pre-2.29.00 version of the database, CDP recommends using the RF135_352_pull_off_script.sql file that was created for and distributed with the 2.29.00 release to copy risk factors from UAT to Production environments.
To use the RF135_352_pull_off_script.sql file to copy risk factors from UAT to Production environments, complete the following steps:
1. Run the RF135_352_pull_off_script.sql file and save the generated risk factor script.
2. Restore the pre-2.29.00 release database.
3. Upgrade to the 2.29.01 release.
4. Restore the risk factor data using the risk factor script generated above in step 1.
For additional information about the RF135_352_pull_off_script.sql file, see the documentation for requirement number twenty (R20) of ENH-533 in the 2.29.00 Release Notes.
A new 2.29.01.asql file was created and distributed with this release. When run, the new 2.29.01.asql file performs the following tasks:
Changes all currently-existing RISKFACTORID 135 columns in the NUTRITIONASSESSMENTCONTACTITEMRISKFACTOR table to "135Z" and sets the modified date to today's date.
Changes all currently-existing RISKFACTORID 135 columns in the VENACONTACTRF table to "135Z" and sets the modified date to today's date.
Changes all currently-existing RISKFACTORID 352 columns in the NUTRITIONASSESSMENTCONTACTITEMRISKFACTOR table to "352Z" and sets the modified date to today's date.
Changes all currently-existing RISKFACTORID 352 columns in the VENACONTACTRF table to "352Z" and sets the modified date to today's date.
A new RF_352_InterviewAgencyRiskFactor_script.sql file was created and distributed with this release. When run, the new RF_352_InterviewAgencyRiskFactor_script.sql file performs the following tasks:
Queries the INTERVIEWAGENCYRISKFACTOR table and returns all nutrition assessment questions that currently have risk factor 352 assigned within the database.
Provides a list of records that can be used to quickly identify the nutrition assessment questions that currently have risk factor 352 assigned within the SPIRIT WIC system.
The new RF_352_InterviewAgencyRiskFactor_script.sql file also contains step-by-step instructions to update the old risk factor 352 questions to either 352A or 352B for nutrition assessment questions within the SPIRIT WIC system.
For states that may have an extra constraint on the FOODPACKAGEID column of the RISKFACTORREFERENCE table, refer to the special instructions in the 2.29.00 Release Notes for requirement number one (R1) of ENH-533.