Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The following new procedures were created:
uspSaveServiceSiteRedemption
uspGetServiceSiteRedemptions
uspGetServiceSiteRedemptionsByFoodInstrumentId
uspGetServiceSiteRedemptionsByFoodInstrumentSetId
The REFERENCEDICTIONARY table description was updated as "Status Replaced" where the Category is EBTCardStatus and its ExternalID is 09. See below.
UPDATE REFERENCEDICTIONARY
SET DESCRIPTION = 'Status Replaced'
WHERE CATEGORY = 'EBTCardStatus'
AND EXTERNALID = '09'
The CKC_RETCOMPBUY_DELIVERYSYSTEMTYP Check constraint was updated on ReturnedComplianceBuyFI to include [DELIVERYSYSTEMTYPE]='E'.
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
EBT_OFFLINE |
VALUE |
N |
DESCRIPTION |
The type of EBT implementation for the state. (Y) Offline (N) Online. |
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
VNDR_COMPBUY_FI_ENABLE_DELIVERYTYPE_EBT |
VALUE |
N |
DESCRIPTION |
Determines if the Compliance Buy Benefits screens are using EBT (Y) or Checks (N) |
The following column was added to the COMPLIANCEBUY table:
Column Name |
Data Type |
Constraint |
ISSUANCEFREQUENCY |
char(1) |
NULL |
The following foreign key was added to the COMPLIANCEBUY table:
Foreign Key |
On Column |
Reference |
FK_CompBuy_CompBuyPkgId |
ComplianceBuyPackageId |
REFERENCES [dbo].[COMPLIANCEBUYPACKAGES] ([PackageId]) |
The following columns were added to the FOODDISTRIBUTIONITEM table:
Column Name |
Data Type |
Default |
ALLOWONSITEREDEMPTION |
char(1) |
N |
ONSITEREDEMPTIONPRICE |
NUMERIC(7, 2) |
|
The following columns were added to the COMPLIANCEBUYPARTICIPANT table:
Column Name |
Data Type |
Constraint |
HOUSEHOLDID |
varchar(8) |
NULL |
WICSTATUS |
char(1) |
NULL |
DATEOFBIRTH |
[datetime] |
NULL |
COMPLIANCEBUYPACKAGEID |
int |
NULL |
ISEBT |
char(1) |
NULL |
The following foreign keys were added to the COMPLIANCEBUYPARTICIPANT table:
Foreign Key |
On Column |
Reference |
FK_CompBuyPart_HouseholdId |
HouseholdID |
REFERENCES [dbo].[HOUSEHOLD] ([HouseholdId]) |
FK_CompBuyPart_WicStatus |
WicStatus |
REFERENCES [dbo].[WICSTATUS] ([WicStatus]) |
A new SERVICESITEREDEMPTIONLOG table was created, which includes the following columns:
Column Name |
Data Type |
Constraint |
ID |
[numeric](10, 0) IDENTITY(1,1) |
NOT NULL |
HOUSEHOLDID |
[varchar](10) |
NOT NULL |
STATEWICID |
[varchar](50) |
NOT NULL |
FOODINSTRUMENTID |
[numeric](10, 0) |
NOT NULL |
DISTRIBUTIONITEMID |
[numeric](10, 0) |
NOT NULL |
FOODITEMID |
[numeric](10, 0) |
NOT NULL |
FOODITEMCATEGORY |
[char](2) |
NOT NULL |
FOODITEMSUBCATEGORY |
[char](3) |
NOT NULL |
DESCRIPTION |
[varchar](255) |
NULL |
UPC |
[varchar](20) |
NULL |
UPCPACKAGESIZEUNITS |
[numeric](5, 2) |
NULL |
REDEEMEDQUANTITY |
[varchar](20) |
NOT NULL |
CLAIMAMOUNT |
[numeric](7, 2) |
NOT NULL |
PAIDAMOUNT |
[numeric](7, 2) |
NOT NULL |
AGENCYID |
[varchar](3) |
NOT NULL |
SERVICESITEID |
[varchar](3) |
NOT NULL |
ISSUANCENUMBER |
[int] |
NOT NULL |
FOODINSTRUMENTITEMREDEEMED |
[numeric](10, 0) |
NOT NULL |
FOODINSTRUMENTITEMREDEEMED_AGGREGATEDID |
[numeric](10, 0) |
NOT NULL |
CREATEUSERID |
[varchar](20) |
NOT NULL |
CREATEDTTM |
[datetime] |
NOT NULL |
MODIFYUSERID |
[varchar](20) |
NOT NULL |
MODIFYDTTM |
[datetime] |
NOT NULL |