Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Added the following column to the V_EOD_BANKING_NEW_FI_ISSUANCE table:
Column Name |
Data Type |
Constraint |
FoodInstrumentSet.PRINTEDFDTU |
DateTime |
NOT NULL |
Added the following column to the V_EOD_BANKING_NEW_FI_ISSUANCE_MISSOURI_FORMAT table:
Column Name |
Data Type |
Constraint |
FoodInstrumentSet.PRINTEDFDTU |
DateTime |
NOT NULL |
Removed a join from the CERTCONTACT table.
Modified the uspToggleHouseholdOnsite procedure.
Added the following updates to the V_MEMBERLIST table:
An outer join to the WICSTATUS table to return the WIC status description.
The following fields:
Field Name |
Data Type |
Constraint |
DESCRIPTION |
Varchar(20) |
NULL |
LASTNAME |
Varchar(25) |
NULL |
ONPREMISESDTTM |
DateTime |
NULL |