Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
A new 2.31.00.asql file was created and distributed with this release.
A new uspGetSignaturesForCards stored procedure was created.
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
CatSubcatListDescription |
VALUE |
L100N000U000S000C000 |
DESCRIPTION |
Determines display of cat-subcat item descriptions in shopping lists. |
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
CatSubcatListMonthDescription |
VALUE |
Redemption Period: <D1> thru <D2> |
DESCRIPTION |
Determines display of month headers in shopping lists. |
The following column was added to the EBTFOODCATSUBCATEGORY table:
Column Name |
Data Type |
Constraint |
LISTDESCRIPTION |
varchar(200) |
NULL |
The following new stored procedures were created:
uspUpdateCatSubcatListDescriptions
uspGetAccountBalanceOtherInfo
The GetEbtIssuance stored procedure was modified to select EBT issuance data for EBT Benefit Issuance (Output) report.
The V_EBTFoodInstruments view was updated to add the new LISTDESCRIPTION column.
A new database update script was added to update the LISTDESCRIPTION column value in the EBTFOODCATSUBCATEGORY table with the FOODSUBCATDESCRIPTION column value if the new LISTDESCRIPTION column value is null in the EBTFOODCATSUBCATEGORY table.
A new uspGetVendorComplianceBuyEBTRedemptions stored procedure was created.
The IX_RETURNEDCOMPLIANCEBUYFI_1 index was modified in the RETURNEDCOMPLIANCEBUYFI table to include the USEDDATE column to support duplicate benefit numbers in returned compliance buys.
The following column was modified in the RETURNEDCOMPLIANCEBUYFI table:
Column Name |
Data Type |
Constraint |
FOODINSTRUMENTID |
[numeric](10, 0) |
NULL |
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
EBTMaxCards |
VALUE |
@Count WHEN (SELECT [VALUE] FROM [dbo].[STATEBUSINESSRULES] WHERE CATEGORYID = 'EBT_OFFLINE') = 'Y' Then 1 Else 2 |
DESCRIPTION |
Valid number of EBT cards allowed. This value should match with the EBT Processor configuration. |