Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The following tables were updated to add a new FILESEQUENCENUMBER column:
EBTWICACTIVITY
FOODINSTRUMENTITEMDETAIL
FOODINSTRUMENTITEMREDEEMED
SUMEBTFOODINSTRUMENTITEMREDEEMED
The following stored procedures were updated to use the value of the new FILESEQUENCENUMBER column instead of the file name parameter when processing of inbound files within End of Day Command Line Batch Processing:
InsertFIItemRedeemed
InsertFIItemRedeemedAggregated
RemovePreviousExpiredBenefits
RemovePreviousRedemptionImport
RemovePreviousWicActivityImport
The following stored procedures were updated or created to improve processing of outbound files within End of Day Command Line Batch Processing:
The InsertEbtTransactionLog stored procedure was updated to use the Sequences process within SQL Server to obtain a unique control number / file sequence number for outbound files processed during End of Day Command Line Batch Processing. The following sequences were added:
EBTBatchFileUniqueIDUPC for the Approved Product List (APL) File
EBTBatchFileUniqueIDCategorySubcategory for the Category Subcategory File
EBTBatchFileUniqueIDVendor for the Authorized Vendor File
Each sequence includes the following default values:
Starting sequence number = 1,000,000
Increment value = 1
A new UpdateLastTransmitDate stored procedure was created to improve the process of recording transmission data for outbound files processed during End of Day Command Line Batch Processing. It replaces the UpdateEbtConnectionInfoParameters stored procedure for the Approved Product List (APL) File and Category Subcategory File.
The GetMarOverride3 stored procedure was modified to include the time when updates are made on the Approve New MAR Prices screen. The Override MAR Prices screen now displays new Maximum Allowed Reimbursement (MAR) prices entered on the current date.
The aSQL file was updated to correct an error in the Release 2.38 that incorrectly changed all VENDORTYPE column values in the STORETYPE table to "I". It now functions correctly to add a row to the STORETYPE table with the value of "I" in the VENDORTYPE column only if one does not exist.
This aSQL file change applies only to state environments that did not upgrade to Release 2.38 or Release 2.39 prior to upgrading to Release 2.40. There is no impact to state environments that upgraded to Release 2.38 or Release 2.39 prior to upgrading to Release 2.40.
The following stored procedure were updated to preserve the values of the CREATEDTTM and MODIFYDTTM columns when inserting records into the CASELOADCOUNT, CASELOADCOUNTREBATEITEMS, CASELOADCOUNTENROLLMENT and tables respectively during End of Month Command Line Batch Processing.
InsertIntoCaseLoadCount
InsertIntoCaseLoadCountRebateItems
InsertIntoCaseLoadCountEnrollment
The RunMonthEndProcess stored procedure was updated to display the “Can not run MONTHEND until month is completed.” message when Run End of Month Command Line Batch Processing is run before the month is completed.
The InsertIntoCaseLoadCountEnrollment stored procedure was updated to prioritize not voided checks over voided checks during End of Month Command Line Batch Processing.
The V_EBTFoodInstruments view was modified to include benefits, even if a food prescription does not exist for the participant.
A VendorFileTypeExtension parameter was added in the EBTCONNECTIONINFO table to support WUMEI file types for the Authorized Vendor File.
A RedeemedBeneFileTypeExtension parameter was added in the EBTCONNECTIONINFO table to support WUMEI file types for the UPC/PLU Redemption File.
The file naming convention was updated for WUMEI file types to expand user-defined file names, including a date field for the following export files:
Approved Product List (APL) File
Authorized Vendor File
Category/Sub-category File