Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
A new RemovePreviousWicActivityImport stored procedure was created to remove WIC Activity records that contain the @Filename from the EBTWICACTIVITY table and return the number of rows.
A new GetNextEbtWicActivityId stored procedure was created to retrieve the maximum EBTWICACTIVITYID value from the EBTWICACTIVITY table and return the value.
If the SumEBTWICActivity table existed in the database, it was renamed as zRetired_SumEBTWICActivity for Summer EBT.
New WicActivityBatchRecordCount and WicActivityBatchTimeout records were added to the EBTCONNECTIONINFO table.
A new UpdateVendorPeergroup stored procedure was created to update the VENDOR and PEERGROUPCHANGE tables with peer group changes made on the Peer Group Reassessment screen in the Vendor application module.
With this new stored procedure, the following changes are made the VENDOR table:
The PEERGROUP column is now updated with the modified peer group description.
The MODIFYUSERID column is now updated with the user ID of the staff member who ran End of Day Command Line Batch Processing.
The MODIFYDTTM column is now updated with the date on which End of Day Command Line Batch Processing ran.
In addition, the stored procedure makes the following change are made the PEERGROUPCHANGE table:
The APPLIEDDATE column is now updated with the date on which End of Day Command Line Batch Processing ran.
The uspGetEBTReconciliationErrors stored procedure was modified as follows:
In-line SQL code that previously existed in the legacy End of Day Process to retrieve a count of records containing benefit activities recorded in the EBT Processor system and SPIRIT for a given time frame (the @StartDate and @EndDate passed to the stored procedure) was moved into this stored procedure.
A new @GetCount input parameter was added to retrieve only EBT Processor system and SPIRIT record counts or to only retrieve a list of EBT Reconciliation errors for a given time frame (the @StartDate and @EndDate passed to the stored procedure).
An Agency ID condition was added to the clinic joins in the stored procedure and also to the in-line SQL query in legacy SPIRIT to resolve an issue where duplicates were displayed in both the EBT Reconciliation e-mail and the EBT Household Reconciliation Report (Output).
The uspGetEBTReconciliationErrors stored procedure was modified as follows:
Transaction Type 2 (Recovered) is now included to retrieve data from the FOODINSTRUMENTITEMDETAIL table.
Transaction Type 2 (Recovered) is now converted to a 'V' in the same manner as Transaction Type 3 (Voided).