2.37.00 Release Notes

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-610

Adjust/Archive/Purge Process

End of Day Process

Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include the Adjust/Archive/Purge Process.

R1: Ensure that the new EOD adjusts participant records appropriately when business rule EOD_PROCESSMEMBERADJUSTMENTS is set to “Y”.

To accommodate the R1 requirement for this enhancement, the following functions were converted from in-line SQL code and views to new stored procedures which were added and distributed with this release of the software:

• CheckMaximumChildWomanAge

• CheckCertLimitWithPendingIDProof

• CheckCategoricallyIneligibleParticipants

• CheckRecertifyFailure

• CheckFailedToPickupFI

• CheckCertLimitWithRF503NoHW

• CheckCertLimitWithRF503NoBlood

• CheckIncompleteCertLimitPregnant

• CheckIncompleteCertLimitMigrant

• CheckIncompleteCertLimitOther

• CheckChildFirstBirthday

• SynchronizeCertificationInfo

• CheckInactiveParticipants

• CheckAndDeleteEmptyInitialContactRecords

• ResetOnPremisesTimes

The following existing stored procedures were modified and distributed with this release of the software:

• GetNextParticipantConsignmentId

• uspSetFoodInstrumentAsPaid

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

R2: Fully Breastfed Infants less than 6 months of age shall be terminated for failure to pick-up if their two-way linked Breastfeeding mother is terminated for failure to pick-up.

To accommodate the R2 requirement for this enhancement, CDP researched and resolved the following additional issue within this release:

• TMP-26

R3: When a participant category is changed from Infant to Child on their first birthday, the one-year old food prescription shall not be removed.

To accommodate the R3 requirement for this enhancement, CDP researched and resolved the following additional issue within this release:

• TMP-344

R4: Participants with an incomplete certification shall be marked as ineligible based on number of days set in applicable business rules:

• INCOMPCERTLIMITPREGNANT

• INCOMPCERTLIMITMIGRANT

• INCOMPCERTLIMITOTHER

To accommodate the R2 requirement for this enhancement, CDP researched and resolved the following additional issue within this release:

• TMP-302

R5: Ensure that the new EOD archives participant records appropriately when business rule EOD_PROCESSMEMBERARCHIVES is set to “Y”.

To accommodate the R5 requirement for this enhancement, the UpdateArchiveInactiveParticipants function was converted from in-line SQL code and views to a new stored procedure which was added and distributed with this release of the software.

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

R6: Ensure that the new EOD purges participant records appropriately when business rule EOD_PROCESSMEMBERPURGES is set to “Y”.

To accommodate the R6 requirement for this enhancement, the following functions were converted from in-line SQL code and views to new stored procedures which were added and distributed with this release of the software:

• PurgeEventLogs14DaysOld

• PurgeBusinessHours90DaysOld

• PurgeAppointments3MonthsOld

• PurgeHouseholdAlertsWithNoMembers

• PurgeClassEnrollments7MonthsOld

• PurgeHolidays90DaysOld

• PurgeHouseholdLock - This procedure does not rely on the business rule EOD_PROCESSMEMBERPURGES.

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

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

To accommodate the R7 requirement for this enhancement, the following functions were converted from in-line SQL code and views to new stored procedures which were added and distributed with this release of the software:

• CheckMaximumChildWomanAge

• CheckCertLimitWithPendingIDProof

• CheckCategoricallyIneligibleParticipants

• CheckRecertifyFailure

• CheckFailedToPickupFI

• CheckCertLimitWithRF503NoHW

• CheckCertLimitWithRF503NoBlood

• CheckIncompleteCertLimitPregnant

• CheckIncompleteCertLimitMigrant

• CheckIncompleteCertLimitOther

• CheckChildFirstBirthday

• SynchronizeCertificationInfo

• CheckInactiveParticipants

• CheckAndDeleteEmptyInitialContactRecords

• ResetOnPremisesTimes

• UpdateArchiveInactiveParticipants

• PurgeEventLogs14DaysOld

• PurgeBusinessHours90DaysOld

• PurgeAppointments3MonthsOld

• PurgeHouseholdAlertsWithNoMembers

• PurgeClassEnrollments7MonthsOld

• PurgeHolidays90DaysOld

• PurgeHouseholdLock

The following existing procedures were modified and distributed with this release of the software:

• GetNextParticipantConsignmentId

• uspSetFoodInstrumentAsPaid

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

R8: The legacy EOD process shall discontinue adjusting, archiving and purging participant data.

To accommodate the R8 requirement for this enhancement, changes to End of Day Processing for ENH-610 removed Adjust/Archive/Purge Process processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.37.00 release of the SPIRIT WIC system, Member Adjustments/Archives/Purges Service processing now occurs only during End of Day Command Line Batch Processing.

R9: 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 R9 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R10: 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 R10 requirement for this enhancement, the prerequisite processes continue to run as intended:

R11: CDP shall document within the release notes what order States/ITOs needs to run existing and new EOD/EOM.

To accommodate the R11 requirement for this enhancement, States/ITOs should run End of Day and End of Month processes in the following order:

ENH-640

Perform Probation Activity Updates

End of Day Process

Within the SPIRIT WIC system, the End of Day Command Line Batch Processing that occurs when the BatchProcessor.dll is run from the Command Prompt was expanded to include Perform Probation Activity Updates processing. Perform Probation Activity Updates was renamed to Reset Probations Service.

R1: Ensure that the new EOD processes Perform Probation Activity Updates correctly and updates the appropriate records.

To accommodate the R1 requirement for this enhancement, the ProcessProbationUpdates function was converted from in-line SQL code and views to a new stored procedure which was added and distributed with this release of the software.

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

R2: Ensure the new EOD process does not remove the Probation follow-up activity from the Event Log screen in the Vendor Folder within the Vendor application module.

To accommodate the R2 requirement for this enhancement,the ProcessProbationUpdates function was converted from in-line SQL code and views to a new stored procedure which was added and distributed with this release of the software.

This process does not remove the Probation follow-up activity from the Event Log screen in the Vendor Folder within the Vendor application module.

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

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 ProcessProbationUpdates function was converted from in-line SQL code and views to a new stored procedure which was 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 Process Probation Activity Updates

To accommodate the R4 requirement for this enhancement, changes to End of Day Processing for ENH-640 removed Perform Probation Activity Updates processing from the End of Day Process in the Scheduled Job Administration application module. With the 2.37.00 release of the SPIRIT WIC system, Reset Probations Service processing now occurs only during End of Day Command Line Batch Processing.

R5: 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 R5 requirement for this enhancement, information is logged consistently in the SCHEDULEDJOBLOG table of the SPIRIT database.

R6: Exceptions shall be logged to the appropriate table.

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

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

To accommodate the R7 requirement for this enhancement, End of Day Command Line Batch Processing will function correctly at any time of the day.

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 what order States/ITOs needs to run existing and new EOD/EOM.

To accommodate the R9 requirement for this enhancement, States/ITOs should run End of Day and End of Month processes in the following order:

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

CDP-411

End of Day Process

The file version numbers within the contents of the BatchProcessing_Core_Source Code.zip for release 2.36 state 2.33.

The file version numbers within the contents of the BatchProcessing_Core_Source Code.zip were changed in release 2.37 and will be incremented for each major release in the future.

CDP-412

End of Day Process

The user group requested information on scheduling multiple actions within a single scheduled task to allow End of Day tasks to process sequentially.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was modified based on several of the comments from the user group in CDP-412.

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

CDP-413

End of Day Process

The End of Day EBT Reconciliation Service did not send e-mail when there was no corresponding record in the COMMREQUEST table.

The user group requested information on records in the COMMREQUEST table.

To facilitate sending e-mail by the EBT Reconciliation Service, the Release 2.37 upgrade process was modified to add a new record in the COMMREQUEST table if it does not exist.

With this release of the software, changes must be made manually to the COMMREQUEST table. For more information, see the BatchProcessing_Core.zip Installation and Configuration topic.

For more information, see the database changes for this reported issue.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was modified based on several of the comments from the user group in CDP-413.

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

CDP-415

End of Day Process

The user group requested information on template format types.

The SPIRIT WIC Detailed Functional Design Document (DFDD) was modified based on several of the comments from the user group in CDP-415.

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

TMP-26

Adjust/Archive/Purge Process

End of Day Process

The End of Day Process does not terminate fully breastfed infants < 6 months of age when the mother is terminated.

The CheckFailedToPickupFI function was converted from in-line SQL code and views to a new stored procedure which was added to the SPIRIT WIC system to resolve this issue as part of ENH-610.

For more information, see the database changes for this reported issue.

TMP-302

Adjust/Archive/Purge Process

End of Day Process

The End of Day Process does not close out certifications for terminated participants.

The following functions were converted from in-line SQL code and views to new stored procedures which were added to the SPIRIT WIC system to resolve this issue as part of ENH-610.

• CheckIncompleteCertLimitPregnant

• CheckIncompleteCertLimitMigrant

• CheckIncompleteCertLimitOther

For more information, see the database changes for this reported issue.

TMP-344

Adjust/Archive/Purge Process

End of Day Process

The End of Day Process removed one-year-old food prescriptions when a non-terminated participant turns one.

The CheckChildFirstBirthday function was converted from in-line SQL code and views to a new stored procedure which was added to the SPIRIT WIC system to resolve this issue as part of ENH-610.

For more information, see the database changes for this reported issue.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

CDP-412

Appendix

(apndxe.chm)

Changes to the Appendix DFDD for CDP-412 are documented below.

The Adding End of Day to the Windows Task Scheduler topic was deprecated. The Table of Contents link to this topic was replaced with a link to the Create a Scheduled Task for End of Day topic.

The Create a Scheduled Task for End of Day topic was modified to add steps to create a second action for the new EOD process to the existing EOD scheduled task.

CDP-413

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for CDP-413 are documented below.

The CommRequest.dll topic was modified to add a table listing the PROCESSNAME - SYSTEMNAME combinations that are used in SPIRIT.

CDP-415

DFDD

(wicdfdd.chm)

Changes to the DFDD for CDP-415 are documented below.

The SPIRIT WIC Templates topic was modified to remove "using Microsoft Word" and to add a note to clarify templates file types.

Scheduled Job Administration

(jobadmn.chm)

Changes to the Scheduled Job Administration DFDD for CDP-415 are documented below.

The Appointment Reminder E-mail (Output) topic was modified to state that the templates are plain text format and to add a note to clarify templates file types.

ENH-610

Scheduled Job Administration

(jobadmn.chm)

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

A new Member Adjustments/Archives/Purges Service Processing within the BatchProcessor topic was added to document the Member Adjustments/Archives/Purges Service processing that occurs when the BatchProcessor.dll is run.

A new Member Adjustments/Archives/Purges Service topic was added to combine all the functions from the following topics:

• Adjust/Archive/Purge Process (Scheduled Job Administration)

• Process Archive Records (Scheduled Job Administration)

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), new pages were added for the new Member Adjustments/Archives/Purges Service and Member Adjustments/Archives/Purges Service Processing within the BatchProcessor topics.

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

• The dotnet BatchProcessor.dll -EOD [CN] Processes section at the bottom of the topic was updated to include a hypertext link to the new Member Adjustments/Archives/Purges Service Processing within the BatchProcessor topic.

The BatchProcessor Processing topic was updated to include a new step for Member Adjustments/Archives/Purges Service Processing within the BatchProcessor.

Appendix

(busrule.chm)

Changes to the Appendix DFDD for ENH-610 are documented below.

The following topics were updated to replace the introduction references to the End of Day module with hypertext links to the End of Day Command Line Batch Processing topic. A statement was either added or updated describing the action of End of Day Command Line Batch Processing based on the state-defined business rules. The DFDD References section was either added or updated to replace hypertext links to the Adjust/Archive/Purge Process topic with hypertext links to the new Member Adjustments/Archives/Purges Service and Member Adjustments/Archives/Purges Service Processing within the BatchProcessor topics. A See Also section was either added or updated with a hypertext link to the EOD_PROCESSMEMBERADJUSTMENTS business rule.

• Age Allowed for WIC Category

• Limit Certification with Pending ID Proof

• Limit Certification with Pending Income Proof

• Limit Certification with Pending Residency Proof

• Mark Participants with Incomplete Certification Attempts as Ineligible

• Number of Days a Pregnant Participant Can Be Certified Without Blood Work and Risk 503

• Number of Days a Pregnant Participant Can Be Certified Without Height Weight and Risk 503

The Pending Residency Proof - Key Value topic was updated as follows:

• A statement was updated describing the action of End of Day Command Line Batch Processing based on the state-defined business rules.

• The DFDD References at the bottom of the topic was updated to include a hypertext link to the Member Adjustments/Archives/Purges Service Processing within the BatchProcessor.

• The See Also section was updated with a hypertext link to the EOD_PROCESSMEMBERADJUSTMENTS business rule

The Run Member Adjustment Process, Run Member Archive Process, and Run Member Purge Process topics were updated as follows:

• All references to the End of Day process were replaced with hypertext links to the End of Day Command Line Batch Processing topic.

• A DFDD References section was added with hypertext links to the new Member Adjustments/Archives/Purges Service and Member Adjustments/Archives/Purges Service Processing within the BatchProcessor topics.

ENH-640

Scheduled Job Administration

(jobadmn.chm)

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

A new Reset Probations Service Processing within the BatchProcessor topic was added to document the Reset Probations Service processing that occurs when the BatchProcessor.dll is run.

The Perform Probation Activity Updates topic was renamed to Reset Probations Service and updated as follows:

• The introduction at the top of the topic was expanded to include a hypertext link to the new Reset Probations Service Processing within the BatchProcessor topic and the existing End of Day Command Line Batch Processing topic.

• A See Also section was added at the bottom of the topic to include a hypertext link to the new Reset Probations Service Processing within the BatchProcessor topic.

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), new pages were added for the new Reset Probations Service Processing within the BatchProcessor topic and the renamed Reset Probations Service topic.

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

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

The BatchProcessor Processing topic was updated to include a new step for Reset Probations Service Processing within the BatchProcessor.

The Create a Scheduled Task for End of Day topic was updated to include the batch processor as a scheduled task.

DFDD

(wicdfdd.chm)

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