Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
A new uspGetParticipantsForBatch stored procedure was added.
A new uspSetParticipantsIssuanceType stored procedure was added.
The following column was added to the MEMBER table:
Column Name |
Data Type |
Constraint |
BatchIssuance |
char(1) |
NULL |
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
BatchIssuanceLdtuLookAheadDays |
VALUE |
0 |
DESCRIPTION |
Batch Issue Look Ahead LDTU |
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
UsesBatchIssuance |
VALUE |
N |
DESCRIPTION |
Uses Batch Issuance Process |
The following row was added to the FEATURE table:
Column Name |
Row Value |
FeatureId |
151 |
Description |
Batch Issuance Resolution |
FeatureGroup |
4 |
CreateUserId |
ENH-468 |
CreateDttm |
GETDATE() |
ModifyUserId |
ENH-468 |
ModifyDttm |
GETDATE() |
A new GetNextFoodInstrumentDetailItemId stored procedure was added.
A new TEMPFOODINSTRUMENTDETAILCONSIGNMENT table was created.
Column Name |
Data Type |
Constraint |
MACHINEID |
varchar(100) |
NOT NULL |
STARTINGID |
numeric(10,0) |
NOT NULL |
ENDINGID |
numeric(10,0) |
NOT NULL |
LASTUSEDID |
numeric(10,0) |
NOT NULL |
CREATEUSERID |
varchar(20) |
NULL |
CREATEDTTM |
datetime |
NULL |
MODIFYUSERID |
varchar(10) |
NULL |
MODIFYDTTM |
datetime |
NULL |