Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The rowstart and rowend parameters were re-added to the uspGetParticipantsForBatchPreprocess procedure.
The value of the ready column was changed from 'Y' to 'All' in the uspGetParticipantsForBatch procedure.
A new uspUpdateParticipantForBatch procedure was added and the uspSetParticipantsIssuanceType procedure was modified to update participants for batch. Additionally, a Rownumber filter was added to the uspGetParticipantsForBatch procedure.
A new PARTICIPANTSFORBATCH table was created, which includes the following columns:
Column Name |
Data Type |
Constraint |
STATEWICID |
varchar (8) |
NOT NULL |
HOUSEHOLDID |
varchar (8) |
NULL |
LASTNAME |
varchar (25) |
NULL |
FIRSTNAME |
varchar (20) |
NULL |
MIDDLEINITIAL |
varchar (1) |
NULL |
CITY |
varchar (30) |
NULL |
CLINIC |
varchar (50) |
NULL |
DATEOFBIRTH |
datetime |
NULL |
LASTLDTU |
datetime |
NULL |
CATEGORY |
varchar (1) |
NULL |
CERTENDDATE |
datetime |
NULL |
MIDCERTDUEDATE |
datetime |
NULL |
ISSUEFREQUENCY |
char (1) |
NULL |
LASTNUTEDU |
datetime |
NULL |
LASTANTHROP |
datetime |
NULL |
LASTBLOODWORK |
datetime |
NULL |
READY |
varchar (10) |
NULL |
ISSUES |
varchar (max) |
NULL |
CERTSTARTDATE |
datetime |
NULL |
CLINICID |
varchar (3) |
NULL |
AGENCYID |
varchar (3) |
NULL |
CERTTERMREASON |
char (1) |
NULL |
ISTERMED |
char (1) |
NULL |
ISSUES2 |
varchar (max) |
NULL |
ISBATCH |
char (1) |
NULL |
ISSELECTED |
varchar (5) |
NULL |
CERTIFICATIONID |
numeric (10, 0) |
NULL |
A new uspGetParticipantsForBatchPreprocess procedure was created and most of the original logic from the uspGetParticipantsForBatch procedure was moved to the new uspGetParticipantsForBatchPreprocess procedure.
The following value was added to the JPMTRANSACTIONERRORCODES table (TRANSACTIONTYPE, ERRORCODE, DESCRIPTION):
('0000', '1062', 'EBT Card Number is Inactive.')
The uspGetParticipantsForBatch procedure was updated as follows:
The MEMBER and CERTCONTACT tables were joined by CERTIFICATIONID instead of STATEWICID.
The following logic was removed from the #PARTICIPANTS temp table creation:
cc.CERTSTARTDATE <= IsNull(@Today,getdate())
cc.CERTENDDATE > IsNull(@Today,getdate())
The uspGetParticipantsForBatch procedure was updated to filter out the three (3) participant types in question as follows:
Fully Breastfeeding Infants who are not old enough to receive a 6-month benefit within the benefit issuance period currently appear with Ready as "No" and a message is received that the infant is fully breastfeeding. The only time they will not appear on the Batch Issue Resolution screen is when the mother is not set to Batch issuance.
Some Breastfeeding Women with infants 6 months and older currently appear if both participants are set to batch. The message received is: "Breastfeeding and cannot receive benefits for (Date range) because her infant is getting more than the maximum amount of formula." Ready is "No". If the woman's infant is changed to Pick-up and Some Breastfeeding is not changed, the woman remains listed on the Batch Issue Resolution screen.
Participants who have received benefits beyond the end of their certification periods.
In the uspGetOriginalScreenDate procedure, the logic to get the original screen date for the household member was changed in the @CopiedWicId variable.