Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The uspGetParticipantsForBatchPreprocess stored procedure was modified as follows.
Logic was modified to identify whether a household is an Balto household.
Logic was added to set the issuance type to "MOV" if the household is an Balto household.
Logic was modified to set the issuance type based on the batch issuance indicator of the participant if the household is not an Balto household.
Logic was added to change the IsCurrentlyBatch value to "Y" for an Balto household.
The uspGetParticipantsForBatch stored procedure was modified as follows.
Logic was added to identify whether the household's issuance type is Balto.
Logic was added to return Balto household participants if the household's issuance type is Balto.
Logic was added to identify whether the household's issuance type is "All" and to return Balto household participants, batch participants, and pickup participants if the household's issuance type is "All".
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
UsesMOV |
VALUE |
N |
DESCRIPTION |
Uses Mail Order Vendor (MOV) |
A new MOVTYPE category was added to the REFDICTIONARYCATEGORY table.
The following records were added to the REFERENCEDICTIONARY table for the new MOVTYPE category:
Category |
Description |
MOVTYPE |
Non-MOV |
All MOV |
|
Formula-Only MOV |
A new MOVTYPE column was added to the following tables:
HOUSEHOLD
HOUSEHOLDHISTORY
Additionally, a new APL Type_MOV_script.sql stand-alone script was created for Alaska that inserts the new "MOV" value for the APLTYPE category into the REFERENCEDICTIONARY table.
The following new procedures were created:
uspBatchGetPendingHouseholdIDs
uspGetBatchFiInfo
uspUpdateBatchAfterIssue
uspGetShoppingList
uspGetBatchFiInfoPending
The following existing procedures were modified:
A new EbtIssuanceNbr column was added to V_FOODINSTRUMENTS_IN_BATCH.
New pending and ebt flags and a new deliverytype column were added to v_BatchIssueDetails.
New pending, deliverytype, and fixed column were added to uspGetBatchIssueHistory (modified to work with pending tables).
New deliverytype, benefitNames, and disabled column were added to uspGetBatchIssueLetter (disabled for pending tables).
A new IsPending flag was added to uspGetParticipantsForBatchPreprocess.
The following columns were added to the BATCHISSUEDETAIL table:
Column Name |
Data Type |
Notes |
DELIVERYSYSTEMTYPE |
varchar(1) = E/C |
E/C = EBT, Check |
PENDING |
char(1) = Y/N |
This is a flag to know if it has had an opportunity to have its labels and letters printed yet. |
The following column was added to the BATCHISSUE table:
Column Name |
Data Type |
Notes |
DELIVERYSYSTEMTYPE |
varchar(1) = E/C/M |
E/C/M = EBT, Check, Mixed |