2.35.00 Release Notes

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-590

Risk Factors

A federal mandate required United States Department of Agriculture (USDA) regulations for some risk factors to change.

R1: The DFDD shall be updated to accurately reflect the changes indicated in the “Definition/Cut-off Value” section of the risk factor detail sheet attached to ENH-590 for the following risk factors:

• 301

• 341

• 372

• 501

• 502

• 902

To accommodate the R1 requirement for this enhancement, the following risk factors were updated in the Risk Factors Matrix topic within the SPIRIT WIC DFDD:

• 301

• 341

• 372

• 501

• 502

• 902

For more information, see the DFDD changes for this enhancement.

R2: Risk factors 132 and 703 shall have "discontinued" written after the title.

To accommodate the R2 requirement for this enhancement, the following risk factors were updated in the Risk Factors Matrix topic within the SPIRIT WIC DFDD:

• 132

• 703

For more information, see the DFDD changes for this enhancement.

R3: Risk factor 350 Pyloric Stenosis shall have "discontinued" written after the title.

To accommodate the R3 requirement for this enhancement, the following risk factor was updated in the Risk Factors Matrix topic within the SPIRIT WIC DFDD:

• 350

For more information, see the DFDD changes for this enhancement.

R4: Risk factor 381 shall be renamed Oral Health Conditions in the Risk Factor matrix in Appendix D of the DFDD.

To accommodate the R4 requirement for this enhancement, the following risk factor was updated in the Risk Factors Matrix topic within the SPIRIT WIC DFDD:

• 381

For more information, see the DFDD changes for this enhancement.

R5: State responsibilities:

1.        Inactivate 132 and 703.

2.        Update Risk Factor Guide excel files.

To help state agencies accommodate the R5 requirement for this enhancement, the information below has been provided.

Risk factors 132, 350, and 703 were deactivated by the USDA. Disable these risk factors in your agency's environment using the Inactive Date calendar control on the Risk Factors screen in the Reference Utility application module.

To make this change in the SPIRIT WIC system, complete the following steps:

1.        Open the Reference Utility application module. The Reference Utility screen displays.

2.        Double-click on the Risk Factors list item in the Functions data grid. The Risk Factors screen displays.

3.        Double-click on the first Risk Factor ID "132" row in the Risk Factors data grid. The Risk Factor screen displays in Edit mode.

4.        In the Inactive Date calendar control, select or enter the date on which to deactivate the risk factor.

5.        Click the OK button. The Risk Factors screen displays and the Risk Factors data grid refreshes to display the updated Default Food Package ID and DFP Priority for the selected row.

6.        Repeat steps 3-6 for each remaining "132" row and all "350" and "703" rows in the Risk Factors data grid.

ENH-612

End of Day Process

Within the SPIRIT WIC system, the End of Day Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include WIC Activity File processing.

R1: Ensure that the new EOD processes correctly and updates the appropriate records for the following:

• WIC Activity File

To accommodate the R1 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing against the new BatchProcessor.dll to ensure that the appropriate tables are updated after the process is run.

R2: The new EOD shall archive files that have already been processed, from previous days.

To accommodate the R2 requirement for this enhancement, WIC Activity File processing that occurs during End of Day Command Line Batch Processing appropriately archives files that were previously processed.

R3: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied.

To accommodate the R3 requirement for this enhancement, new RemovePreviousWicActivityImport and GetNextEbtWicActivityId stored procedures were added and distributed with this release of the software.

For more information, see the database changes for this enhancement.

R4: The legacy EOD process shall discontinue the import of the WIC Activity File.

Changes to End of Day Processing for ENH-612 removed WIC Activity File processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.35.00 release of the SPIRIT WIC system, WIC Activity File processing now occurs only during End of Day Command Line Batch Processing.

R5: The file shall maintain the current naming syntax of [State Identifier Code][WACT][YYMMDD][Sequence Number].

To accommodate the R5 requirement for this enhancement, the exiting file naming convention was retained with this release of the software.

R6: Remove SumEbtWicActivity (Summer EBT) from the WIC Activity File

To accommodate the R6 requirement for this enhancement, if the SumEBTWICActivity table exists in the database, it is renamed as zRetired_SumEBTWICActivity for Summer EBT.

For more information, see the database changes for this enhancement.

R7: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition.

To accommodate the R7 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R8: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD/EOM.

To accommodate the R8 requirement for this enhancement, the prerequisite processes continue to run as intended.

R9: CDP shall document within the release notes that states will need to run their existing EOD/EOM prior to running the new EOD/EOM and generate the Authorized Vendor File from both processes for testing or comparing the old results with the new.

To accommodate the R9 requirement for this enhancement, states should process the WIC Activity File during the End of Day Process in the Scheduled Job Administration application module prior to upgrading to release 2.35.00.

ENH-621

End of Day Process

Within the SPIRIT WIC system, the End of Day Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Peer Group Reassessment Processing.

R1: Ensure that the new EOD processes Perform Peer Group Reassessment correctly and updates the appropriate records.

To accommodate the R1 requirement for this enhancement, CDP's Quality Assurance (QA) team performed testing against the new BatchProcessor.dll to ensure that the appropriate tables are updated after the process is run.

R2: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied.

To accommodate the R2 requirement for this enhancement, the UpdateVendorPeergroup stored procedure was added and distributed with this release of the software.

For more information, see the database changes for this enhancement.

R3: The legacy EOD shall discontinue the Process Peer Group Reassessment.

To accommodate the R3 requirement for this enhancement, changes to End of Day Processing for ENH-621 removed Peer Group Reassessment Processing from the End of Day Process in the Scheduled Job Administration application module when a peer group change is effective on a future date.

With the 2.35.00 release of the SPIRIT WIC system:

• When a peer group change is effective on the current system date, then the End of Day Processing code (outside of End of Day Command Line Batch Processing) updates the peer group data in the VENDOR table and applies the effective date in the EFFECTIVEDATE column of the PEERGROUPCHANGE table.

• When a peer group change is effective on a future date, then End of Day Command Line Batch Processing updates the peer group data in the VENDOR table and applies the effective date (without a time stamp) to the EFFECTIVEDATE column in the PEERGROUPCHANGE table.

R4: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition.

To accommodate the R4 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R5: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD.

To accommodate the R5 requirement for this enhancement, the prerequisite processes continue to run as intended.

R6: Exceptions will be logged to the appropriate table.

To accommodate the R6 requirement for this enhancement, exception information is logged consistently in the EXCEPTIONLOG table of the SPIRIT database.

R7: The same work will be done whether the process runs at 11PM or 1AM.

To accommodate the R7 requirement for this enhancement, the End of Day Command Line Batch Processing updates the peer group data in the VENDOR table and applies the effective date (without a time stamp) to the EFFECTIVEDATE column in the PEERGROUPCHANGE table as follows:

• When End of Day Command Line Batch Processing is run before 6pm, then it retrieves the peer group data from the PEERGROUPCHANGE table with an EFFECTIVEDATE < the run date.

• When End of Day Command Line Batch Processing is run after 6pm, then it retrieves the peer group data from the PEERGROUPCHANGE table with EFFECTIVEDATE < (the run date + 1).

ENH-631

End of Day Process

Within the SPIRIT WIC system, the End of Day Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include WIC Activity Reconciliation processing.

For more information, see the DFDD changes for this enhancement.

R2: Ensure that the new EOD processes correctly and updates the appropriate records for the following:

• WIC Activity Reconciliation

To accommodate the R2 requirement for this enhancement, recovered transactions are now converted to Void and referenced in the "EBT Reconciliation" e-mail notification sent. Additionally, the code was modified to send the @EndDate as 2019-02-05 23:59:59:997 to theuspGetEBTReconciliationErrors stored procedure. As a result, the SQL server will no longer convert the 2019-02-05 23:59:59:999 date to the next day (2019-02-06 00:00:00:000). For more information, see the Database Changes for this release.

CDP's Quality Assurance (QA) team performed testing against the new BatchProcessor.dll to ensure that the appropriate tables are updated after the process is run.

R3: The release notes should contain the name of any stored procedures used by EOD after these changes have been applied.

To accommodate the R3 requirement for this enhancement, the uspGetEBTReconciliationErrors stored procedure was modified and distributed with this release of the software:

For more information, see the database changes for this enhancement.

R4: The legacy EOD process shall discontinue the WIC Activity reconciliation.

To accommodate the R4 requirement for this enhancement, changes to End of Day Processing for ENH-631 removed EBT Reconciliation processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.35.00 release of the SPIRIT WIC system, WIC Activity Reconciliation processing now occurs only during End of Day Command Line Batch Processing.

R5: The reconciliation e-mail shall be sent to all recipients in the system, not just the first recipient on the list.

To accommodate the R5 requirement for this enhancement, TMP-332 was fixed within this release of the software and the SPIRIT WIC system now uses the WIC Activity Reconciliation Processing within the BatchProcessor implemented with this release of the software to send "EBT Reconciliation" e-mail notifications.

R6: All new processes will log information to the scheduled job log in a manner consistent with the original versions, however the order may be different since the job order may change during transition.

To accommodate the R6 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R7: Any prerequisite processes for either of these processes shall continue to run ahead of these processes in either legacy or the new EOD.

To accommodate the R7 requirement for this enhancement, the prerequisite processes continue to run as intended.

R8: CDP shall document within the release notes that states will need to run their existing EOD prior to running the new EOD and reconcile the WIC Activity File from both processes for testing or comparing the old results with the new.

To accommodate the R8 requirement for this enhancement, states should process the WIC Activity File during the End of Day Process in the Scheduled Job Administration application module prior to upgrading to release 2.35.00.

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

TMP-332

E-mail Notifications

When multiple e-mail recipients were set up to receive an EBT Reconciliation e-mail notification on the Notification List screen in the Reference Utility application module, an e-mail was sent to only one recipient during End of Day Processing.

The EBT Reconciliation process was modified to use the e-mail functionality implemented within the BatchProcessor.dll.

For more information, see the BatchProcessor Processing topic.

TMP-354

E-mail Notifications

The EBT Reconciliation e-mail notification generated during the End of Day Process contained misleading information.

The uspGetEBTReconciliationErrors stored procedure in the SPIRIT WIC system was modified to resolve this issue.

For more information, see the Database Changes for this reported issue.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

ENH-590

Appendix

(busrule.chm)

Changes to the Risk Factors Matrix in the Appendix D DFDD for ENH-590 are documented below.

Risk Factor 132:

"(Discontinued)" was added to the end of the title text on the risk factor.

Risk Factor 301:

The content in the Definition column for the Pregnant row was modified to read as follows:

Risk Factor 341:

The title of the risk factor was changed from "Nutrient Deficiency Diseases" to "Nutrient Deficiency or Disease".

The content in the Priority column for the Non-breastfeeding row was changed from "<18 years = 6, ≥ 18 years = 6" to "3, 4, 5, or 6".

The content in the Definition column was modified to read as follows for all Category rows:

Risk Factor 350:

"(Discontinued)" was added to the end of the title text on the risk factor.

Risk Factor 372:

The title of the risk factor was changed from "Alcohol and Illegal Drug Use" to "Alcohol and Substance Use".

The content in the Priority column for the Non-breastfeeding row was changed from "<18 years = 6, ≥ 18 years = 6" to "3, 4, 5, or 6".

The content in the Definition column was modified to read as follows for the Pregnant row:

The content in the Definition column was modified to read as follows for the Breastfeeding row:

The content in the Definition column was modified to read as follows for the Non-breastfeeding row:

Risk Factor 381:

The title of the risk factor was changed from "Dental Problems" to "Oral Health Conditions".

Risk Factor 501:

The content in the Priority column was updated as follows:

• The priority for the Breastfeeding row was changed from "4" to ""1, 4, or 7".

• The priority for the Non-breastfeeding row was changed from "<18 years = 6, ≥ 18 years = 6" to "3, 4, 5, 6, or 7".

• The priority for the Children row was changed from "5" to "3, 5, or 7".

• The priority for the Infants row was changed from "4" to "1, 4, or 7".

The content in the Definition column was modified to read as follows for all Category rows:

Risk Factor 502:

The content in the Priority column for the Breastfeeding row was changed from "<18 years = N/A, ≥ 18 years = N/A" to "N/A".

The content in the Definition column was modified to read as follows for all Category rows:

Risk Factor 703:

"(Discontinued)" was added to the end of the title text on the risk factor.

Risk Factor 902:

The title of the risk factor was changed from "Woman or Primary Caregiver of Infant/Child with Limited Ability to Make Feeding Decisions and/or Prepare Food" to "Woman or Infant/Child of Primary Caregiver with Limited Ability to Make Appropriate Feeding Decisions and/or Prepare Food".

The content in the Priority column was updated as follows:

• The priority for the Pregnant and Breastfeeding rows was changed from "4" to "4 or 7".

• The priority for the Non-breastfeeding row was changed from "<18 years = 6, ≥ 18 years = 6" to "4 or 7".

• The priority for the Children and Infants rows was changed from "5" to "5 or 7".

The content in the Definition column was modified to read as follows for all Category rows:

ENH-612

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for ENH-612 are documented below.

In the tutorial within the BatchProcessing_Core.zip Installation and Configuration topic, the Update the EBTCONNECTIONINFO table step was updated to include EBTCONNECTIONINFO table requirements for the WIC Activity File.

A new WIC Activity File Processing within the BatchProcessor topic was added to document the WIC Activity File processing that occurs when the BatchProcessor.dll is run.

Within the DFDD's Table of Contents (TOC) (Scheduled Job Administration -> Scheduled Job Administration -> End of Day Processing -> End of Day Command Line Batch Processing -> BatchProcessor.dll Process Flow), a new page was added for the new WIC Activity File Processing within the BatchProcessor topic.

The WIC Activity File topic was updated as follows:

• The introduction at the top of the topic was expanded to include a hypertext link to the new WIC Activity File Processing within the BatchProcessor topic.

• Previously-missing data elements were added and the File Mapping from SPIRIT Database (Table. Column) column was populated in the Detail Record section.

• The file naming conventions section was updated to document how the file is named when generated and where the file is sent during BatchProcessor Processing.

The Run End of Day Command Line Batch Processing topic was updated as follows:

• The sample error section was updated to include EBTCONNECTIONINFO table requirements for the new WIC Activity File Processing within the BatchProcessor.

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new WIC Activity File Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for WIC Activity File Processing within the BatchProcessor.

ENH-621

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for ENH-621 are documented below.

The "Perform Peer Group Reassessment" topic was renamed Peer Group Reassessment Processing within the BatchProcessor and entirely rewritten to accurately document current functionality within this release of the software.

Within the DFDD's Table of Contents (TOC) (Scheduled Job Administration -> Scheduled Job Administration -> End of Day Processing -> End of Day Command Line Batch Processing -> BatchProcessor.dll Process Flow), a new page was added for the new Peer Group Reassessment Processing within the BatchProcessor topic.

The Run End of Day Command Line Batch Processing topic was updated as follows:

• The Messages that can display on the Command Prompt section was updated to include the following additional messages:

• Updating data for {Name}.

• Updated data for {Name}.

• |ERROR|

• {Name} failed.

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new Peer Group Reassessment Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for Peer Group Reassessment Processing within the BatchProcessor.

ENH-631

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for ENH-631 are documented below.

A new WIC Activity Reconciliation Processing within the BatchProcessor topic was added to document the EBT Reconciliation processing that occurs when the BatchProcessor.dll is run.

Within the DFDD's Table of Contents (TOC) (Scheduled Job Administration -> Scheduled Job Administration -> End of Day Processing -> End of Day Command Line Batch Processing -> BatchProcessor.dll Process Flow), a new page was added for the new WIC Activity Reconciliation Processing within the BatchProcessor topic.

The Run End of Day Command Line Batch Processing topic was updated as follows:

• The Messages that can display on the Command Prompt section was updated to include the following additional messages:

• {Name} started.

• Checking Discrepancies for {Name}.

• Sending Email for {Name}.

• {Name} executed successfully, but discrepancies were found and an email sent.

• {Name} successfully executed.

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new WIC Activity Reconciliation Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for WIC Activity Reconciliation Processing within the BatchProcessor.

DFDD

(wicdfdd.chm)

For this release, the title bar of the Detailed Functional Design Document (DFDD) was updated to reflect build version "2.35.00". Additionally, the footer was also updated to reflect software version "2.35.00".