2.24.00 Release Notes

Contents Show

Changes made in this release of the software are detailed below.

ENH-468

Users wanted the SPIRIT WIC system to allow batch mailing of benefits to participants. However, not all state agencies may choose to use the batch-mailed feature. Therefore, users also wanted the SPIRIT WIC system to allow states to enable the batch-mailed feature for state agencies that choose to use it, and disable the batch-mailed feature for state agencies that choose not to use it.

Users also wanted the SPIRIT WIC system to identify participants who have a last LDTU that is within a specific date range and display a list of participants with an LDTU within the specified date range. Additionally, users wanted the SPIRIT WIC system to allow the specific date range to be configurable by the state for all local agencies, where the date range equals the current date plus the configurable number of days (LDTU = current system date + the state-specified number of days).

This release of the SPIRIT WIC system contains Phase 1 of ENH-468, and includes requirements 1-9 of the ENH-468 change request. The modifications documented below detail the changes made to the SPIRIT WIC system to accommodate ENH-468.

Enhancements

Enhancement#

Primary Function

Enhancement Detail

ENH-468

Database Changes

Business Rules

The SPIRIT WIC system has been modified to allow batch mailing of benefits to participants.

A new business rule named UsesBatchIssuance was added to the StateBusinessRules table. The new business rule allows state agencies to control whether to use the batch mailed functionality within the SPIRIT application. The default value for the business rule is set to "N".

The SPIRIT WIC system has been modified to identify and search for participants who have a LDTU that is within a specific date range.

A new business rule named BatchIssuanceLdtuLookAheadDays was added to the StateBusinessRules table. The new business rule allows state agencies to configure the LDTU look-ahead number of days for a calculated date range, where the date range equals the current system date plus the configurable number of days (date range = current system date + the value specified for this business rule). For example:

  • If a participant's LDTU is 10/02/2015, the current system date is 10/02/2015, and the value of the business rule equals "5", the participant is returned as a result.

  • If a participant's LDTU is on 10/02/2015, the current system date is 09/15/2015, and the value of the business rule equals "5", the participant is not returned as a result.

State agencies can configure the LDTU look-ahead number of days for all local agencies by adjusting the value of the business rule. The default value of the business rule is "0".

Management Console

On the Role Profile screen in the Management Console application module, a new Batch Issue Resolution permission was added to the Permission(s) data grid.

The new Batch Issue Resolution permission displays in the Feature column within the Participant Management Feature Group.

The new permission allows the user View or Full access to the following screens in the SPIRIT WIC system:

  • Batch Issue Resolution (Clinic)

  • Batch Issue Resolution (State Office)

Central Administrative Site

The following change was made to the Central Administrative Site application module:

  • A new Batch Issuance check box was added to Demographics screen. This new check box is visible and disabled when the value of the UsesBatchIssuance business rule is set to "Y".

Clinic

The following changes were made to the Clinic application module:

  • A new Batch Issuance check box was added to Demographics screen. This new check box is visible and enabled when the value of the UsesBatchIssuance business rule is set to "Y".

  • A new Batch Issue Resolution menu option was added to the Activities menu on the Participant List screen. This new menu option is visible and enabled when the value of the UsesBatchIssuance business rule is set to "Y". The Batch Issue Resolution screen displays when the menu option is selected.

  • A new Batch Issue Resolution screen was added. This new screen allows users to search for participants, resolve errors restricting benefit issuance, and to indicate that participants are able to receive batch-mailed benefits.

State Office

The following changes were made to the State Office application module:

  • A new Batch Issuance check box was added to Demographics screen. This new check box is visible and disabled when the value of the UsesBatchIssuance business rule is set to "Y".

  • A new Batch Issue Resolution menu option was added to the Activities menu on the Participant List screen. This new menu option is visible and enabled when the value of the UsesBatchIssuance business rule is set to "Y". The Batch Issue Resolution screen displays when the menu option is selected.

  • A new Batch Issue Resolution screen was added. This new screen allows users to search for participants, resolve errors restricting benefit issuance, and to indicate that participants are able to receive batch-mailed benefits.

Reported Issues

The table below documents issues fixed within this release of the software.

Reported Issues

Issue#

Primary Function

Issue Detail

Issue Resolution

TMP-129

ACM Check Out

A Unique Index error was occurring when performing the check out process for a clinic in the ACM application module.

An issue with a merge statement was identified. Primary Key (self-referencing) columns were removed from the merge update statement.

TMP-130

ACM Check Out

A Foreign Key error was occurring when performing the check out process for a clinic in the ACM application module.

CDP first was able to reproduce foreign key issue on Agency-ServiceSite tables by expiring change retention period on Central SPIRIT server. Therefore, CDP believed that this was at first a procedural issue and sent step-by-step instructions to document the correct checkout process.

The process sent also indicated that the RefreshChangeTracking.sql script should be run on the Central SPIRIT Database and that the local database should be refreshed before change retention expires. This is very important, because data is deleted (cleaned) from the change tracking tables after the retention period (currently users' databases are set for 120 days).

The RefreshChangeTracking.sql script is included in this release of the software, and it is the responsibility of each state to ensure this script is run.

In addition, the following changes were made to the DFDD:

  • To help users to better understand the ACM application module, the ACM Client Training Manual and the ACM Client Installation Guide were added to the ACM DFDD.

  • A new ACM Check In and Check Out training scenario topic was added to the ACM DFDD and the ACM Online Help System to provide users step-by-step instructions to successfully check in and check out clinics using the ACM application module.

However, users reported that they were still able to recreate this issue after following the step-by-step instructions from CDP. Additionally, the users specified the issue occurs intermittently, and that it cannot be reproduced at will.

The data containing the issue was backed up and sent to CDP (i.e. the missing parent (woman) records that were causing the Foreign Key error).

CDP analyzed the database backups received from users very thoroughly, and identified the records that are causing the issue. CDP is now able to recreate the issue using the data within the backups.

CDP identified four woman records that were missing from the woman table, and these records were linked with a child in the child table. Since the State WIC ID of each woman is in the child table and not in the parent (woman) table, the Foreign Key error occurs as a result.

CDP analyzed the results of the database backups, including the child records, the woman records, the datasync tables, the change tracking tables, the tables used during the checkout process, the stored procedures, and the checkout process code.

CDP is currently identifying the reason(s) preventing specific women records from downloading during the checkout process.

Since CDP is in process of identifying the reason(s) preventing specific women records from downloading during the checkout process, there is no code change included in this release of the software for this issue.

TMP-166

ACM Check In

Users reported incorrect CERTIFICATIONIDs in the MEMBER record for participants, which resulted in the potential for double issuance.

CDP analyzed this issue very thoroughly and was unable to recreate the issue in CDP's testing environments.

CDP followed the steps below (from JIRA) numerous times to attempt to recreate the issue.

1          Checked out a clinic in the ACM application module.

2          Checked out a clinic in the ACM application module.

3          Recertified a child participant that was had an expired certification in the Clinic application module.

4          Issued bi-monthly benefits to the participant.

5          Checked the clinic back into the ACM application module.

6          Launched the Clinic application module again and searched for the participant.

7          Viewed the details of the participant.

8          Verified that the certification end date displayed correctly.

The Certification process, the Recertification process and the Pseudo Certification process were thoroughly analyzed, including using various WIC categories through multiple testing scenarios.

CDP also combed through the code to attempt to identify any caveat that is improperly updating the certification ID or certification end date.

To assist CDP in recreating the issue, it was decided on the users' call to backup and send the data to CDP once the issue was recreated by a user. However, the issue is now reported only to occur intermittently, and the users are unable to reproduce the issue at will. Because users have not been able to recreate the issue recently, a data backup was not sent to CDP.

Since CDP has not received backup data and is unable to reproduce this issue, there is no code change included in this release of the software for this issue.

TTY-33

Database Changes

Clinic Benefit Issuance

After the deployment of SPIRIT 2.22.02, San Felipe received a "Cannot find stored procedure name 'getNextFoodInstrumentDetailItemID'" error when attempting to issue benefits.

The T-SQL statements required to generate the 'GetNextFoodInstrumentDetailItemId' stored procedure and subsequent 'TEMPFOODINSTRUMENTDETAILCONSIGNMENT' table used for the Santo Domingo and San Felipe databases were obtained from CSC and included in the 2.24.00.asql file delivered with this release.

DFDD Updates

The table below documents changes made to the SPIRIT WIC Detailed Functional Design Document (DFDD) for this release of the software.

DFDD Updates

Issue#

DFDD Location

DFDD Resolution

ENH-468

Appendix

(busrule.chm)

In Appendix B, the following Client Business Rules were added:

  • A new business rule named BatchIssuanceLdtuLookAheadDays was added.

  • A new business rule named UsesBatchIssuance was added.

In the Appendix D, a new permission 836 was added to the Participant Management Feature Group in the Permissions Matrix.

In Appendix D, the following changes were made to the Messages Matrix:

  • New Variant Text was added to the standard confirmation message C0049, and the Message Trigger was rewritten to accommodate multiple search functions.

  • New Variant Text and Notes were added to the standard error message E0350.

  • A new standard confirmation message C0081 was added.

  • A new standard information message I0074 was added.

Central Administrative Site

(centadmn.chm)

The following changes were made to the Central Administrative Site DFDD:

  • A new Batch Issuance check box was added to the Demographics screen topic.

Clinic

(clinic.chm)

The following changes were made to the Clinic DFDD:

  • A new Batch Issuance check box was added to Demographics screen topic.

  • A new Batch Issue Resolution menu option was added to the Participant List Activities menu topic.

  • A new Batch Issue Resolution screen topic was added.

State Office

(stateofc.chm)

The following changes were made to the State Office DFDD:

  • A new Batch Issuance check box was added to Demographics screen topic.

  • A new Batch Issue Resolution menu option was added to the Participant List Activities menu topic.

  • A new Batch Issue Resolution screen topic was added.

TMP-130

ACM

(acm.chm)

The following changes were made to the ACM DFDD:

  • The ACM Client Training Manual and the ACM Client Installation Guide were added.

  • A new ACM Check In and Check Out training scenario topic was added.

|

Documentation Delivery Date: 09/25/2015