Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
A new variable @isBatchIssuance VARCHAR(1) was created and a string was replaced with the new variable in an update statement.
A duplicate uspGetParticipantsForBatchPreprocess procedure was removed.
The following column was added to the SERVICESITE table:
Column Name |
Data Type |
Constraint |
Default |
EMERGENCYBATCH |
[char](1) |
NOT NULL |
'N' |
User ID logic was removed from the uspGetParticipantsForBatchPreprocess procedure.
The following new views were created:
v_BatchIssueDetails
V_FOODINSTRUMENTS_IN_BATCH
The following new procedures were created:
uspGetBatchIssueHistory
uspUpdateBatchIssue
uspUpdateBatchIssueDetail
A record was inserted into the REFERENCEDICTIONARY table for the following categories:
EVTLOGPROC
VOIDREASON
A record was inserted into the COMMREQUEST table for the following categories:
BatchIssue
LetterArchive
A record was inserted into the DOCUMENTIMAGETYPE table for the following category:
Receipt Confirmation
The following column was added to the HOUSEHOLDLOCK table:
Column Name |
Data Type |
Constraint |
BATCHISSUEID |
[int] |
NULL |
The following columns were added to the PARTICIPANTSFORBATCH table:
Column Name |
Data Type |
Constraint |
PFDTU1 |
[varchar](20) |
NULL |
FDTU1 |
[varchar](20) |
NULL |
LDTU1 |
[varchar](20) |
NULL |
FDTU2 |
[varchar](20) |
NULL |
LDTU2 |
[varchar](20) |
NULL |
FDTU3 |
[varchar](20) |
NULL |
LDTU3 |
[varchar](20) |
NULL |
FDTU4 |
[varchar](20) |
NULL |
LDTU4 |
[varchar](20) |
NULL |
SUGGESTEDCUTOFFDATE |
[varchar](50) |
NULL |
A new BATCHISSUE table was created, which includes the following columns:
Column Name |
Data Type |
Constraint |
BATCHID |
[int] IDENTITY(1,1) |
NOT NULL |
ISSUEDATE |
[date] |
NULL |
ISSUEDBY |
[varchar](50) |
NULL |
NUMBEROFCHECKS |
[int] |
NULL |
AGENCYID |
[varchar](3) |
NULL |
SERVICESITEID |
[varchar](3) |
NULL |
VOIDEDDATE |
[date] |
NULL |
VOIDEDUSER |
[varchar](50) |
NULL |
VOIDEDREASON |
[varchar](1) |
NULL |
CREATEUSERID |
[varchar](20) |
NULL |
CREATEDTTM |
[datetime] |
NULL |
MODIFYUSERID |
[varchar](20) |
NULL |
MODIFYDTTM |
[datetime] |
NULL |
A new BATCHISSUEDETAIL table was created, which includes the following columns:
Column Name |
Data Type |
Constraint |
BATCHISSUEID |
[int] |
NOT NULL |
FOODINSTRUMENTSETID |
[numeric](10, 0) |
NOT NULL |
RECEIVEDDATE |
[datetime] |
NULL |
ADDEDDTTM |
[datetime] |
NULL |
CREATEUSERID |
[varchar](20) |
NULL |
CREATEDTTM |
[datetime] |
NULL |
MODIFYUSERID |
[varchar](20) |
NULL |
MODIFYDTTM |
[datetime] |
NULL |
MAILEDADDRESS |
[varchar](500) |
NULL |
A new BATCHISSUEERROR table was created, which includes the following columns:
Column Name |
Data Type |
Constraint |
BATCHISSUEID |
[int] |
NOT NULL |
STATEWICID |
[varchar](8) |
NOT NULL |
ERRORTXT |
[varchar](8) |
NULL |
CREATEUSERID |
[varchar](20) |
NULL |
CREATEDTTM |
[datetime] |
NULL |
MODIFYUSERID |
[varchar](20) |
NULL |
MODIFYDTTM |
[datetime] |
NULL |