Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
The DESCR column in the EBTCONNECTIONINFO table where the value of the NAME column equals "ApptReminderTemplateSpanish" was modified to state "Path for the appointment reminder email template spanish".
The CheckChildFirstBirthday stored procedure was modified to correct a typo. It now correctly sets the priority when an infant changes to a child category.
To accommodate requirements for the ENH-493, ENH-613, ENH-616, ENH-623, ENH-625, ENH-626, ENH-627, ENH-629, ENH-630, and ENH-638 enhancements and the reported issue TMP-257 to the SPIRIT WIC system, a new BatchProcessing_Core.zip was created and distributed to improve the efficiency of End of Month Processing.
The following functions were converted from in-line SQL code and views to new stored procedures which were added to process End of Month Command Line Batch Processing data:
The RunMonthEndProcess stored procedure was added to execute the End of Month Command Line Batch Processing.
The RollProcessControlTableToNextMonth stored procedure was added to update the Process Control table with the next set of dates.
The InsertScheduledJobLog stored procedure was added to log information to the EXCEPTIONLOG and SCHEDULEDJOBLOG tables.
If the MONTHEND_INCL_CASELOADCOUNTS business rule equals 'Y', call the following stored procedures:
The InsertIntoCaseLoadCount stored procedure was added to insert records into the CASELOADCOUNT table.
The InsertIntoCaseLoadCountEnrollment stored procedure was added to insert records into the CASELOADCOUNTENROLLMENT table.
The InsertFullyBFIntoCaseLoadCount stored procedure was added to insert records into the CASELOADCOUNT table.
The InsertInfantsMostlyBF stored procedure was added to insert records for infants who are age birth-1 month old, with breastfeeding amount = '2', and have not received benefits into the CASELOADCOUNT and CASELOADCOUNTENROLLMENT tables.
The InsertIntoCaseLoadCountRebateItems stored procedure was added to insert records into the CASELOADCOUNTREBATEITEMS table.
The InsertRedemptionHistory stored procedure was added to insert records into the REDEMPTIONHISTORY table if the MONTHEND_INCL_HIGHRISK_DATA business rule equals 'Y'.
If the MONTHEND_INCL_CASELOADUNDUP_TBLS business rule equals 'Y', call the following stored procedures.
The GetFiscalYear stored procedure was added to retrieve the current fiscal year.
The InsertCaseLoadCountUndupe stored procedure was added to insert records into the CASELOADCOUNTUNDUPSTATE, CASELOADCOUNTUNDUPFEDERAL, and CASELOADCOUNTUNDUPCALENDAR tables.
The InsertIntoDuplicateEnrollParticipation stored procedure was added to insert records into the DUPLICATEENROLLPARTICIPATION table if the MONTHEND_INCL_DUALENROLLMENT_TBLS business rule equals 'Y'.
The InsertIntoRedemptionReconciliation stored procedure was added to insert records into the REDEMPTIONRECONCILIATION table if the MONTHEND_INCL_REDEMPRECON_TBL business rule equals 'Y'.
If the MONTHEND_INCL_CASELOADCOUNTS and MONTHEND_INCL_CDC_FILES business rules equal 'Y', call the following stored procedures:
The CreateCdcPregnancyFileData stored procedure was added to insert pregnancy records into the CDCPregnancyFile temporary table if the Pregnancy CDC files have been generated for the current quarter.
The CreateCdcPediatricFileData stored procedure was added to insert pediatric records into the CDCPediatricFiletemporary table.
If data exists within the CDCPediatricFile temporary table, the GetCDCPediatricFile stored procedure was added to write the CDC Pediatric File to the output folder path value in the ROWTEXT column in the second row within the CDCPediatricFiletemporary table.
If data exists within the CDCPregnancyFile temporary table, the GetCDCPregnancyFile stored procedure was added to write the CDC Pregnancy File to the output folder path value in the ROWTEXT column in the second row within the CDCPregnancyFile temporary table.
The DropCDCFileTables stored procedure was added to delete the CDCPediatricFile and CDCPregnancyFile temporary tables.
For more information, see the Run End of Month Command Line Batch Processing topic.
The following parameters were added in the EBTCONNECTIONINFO table to support WUMEI file types for the Approved Product List (APL) File:
FileType, ICDVersion, UniversalServiceProviderType, WICEBTSystemID, WICMISSystemID, and UPCPLUFileTypeExtension.
The GetEbtConnectionInfoParameters stored procedure was modified to include retrieval of the new EBTCONNECTIONINFO table parameters.
The file naming convention was updated to support WUMEI file types.
The GetJPMVendorExportList stored procedure was renamed as GetVendorBatchExportList.
The following parameters were updated in the EBTCONNECTIONINFO table to support WUMEI file types for the Authorized Vendor File:
Updated the VendorFileName parameter requirements.
Added parameters for FileType, ICDVersion, UniversalServiceProviderType, WICEBTSystemID, and WICMISSystemID.
The GetEbtConnectionInfoParameters stored procedure was modified to include retrieval of the new EBTCONNECTIONINFO table parameters.
The file naming convention was updated to support WUMEI file types.
The following parameters were added in the EBTCONNECTIONINFO table to support WUMEI file types for the Category/Sub-category File:
FileType, ICDVersion, UniversalServiceProviderType, WICEBTSystemID, WICMISSystemID, and CatSubcatFileTypeExtension.
The GetEbtConnectionInfoParameters stored procedure was modified to include retrieval of the new EBTCONNECTIONINFO table parameters.
The LoadCatSubcatFile stored procedure was modified to include the following action codes to support WUMEI file types:
ActionCode = "01" when FILETYPE = "0"
ActionCode = "002" when FILETYPE = "1" or "2"
The file naming convention was updated to support WUMEI file types.
The following parameters were updated in the EBTCONNECTIONINFO table to support WUMEI file types for the UPC/PLU Redemption File:
Updated the RedeemedBenefitsFileName parameter requirements.
Added parameters for FileType, ICDVersion, UniversalServiceProviderType, WICEBTSystemID, and WICMISSystemID.
The GetEbtConnectionInfoParameters stored procedure was modified to include retrieval of the new EBTCONNECTIONINFO table parameters.
The file naming convention was updated to support WUMEI file types.
The following parameters were added in the EBTCONNECTIONINFO table to support WUMEI file types for the WIC Activity File:
FileType, ICDVersion, UniversalServiceProviderType, WICEBTSystemID, WICMISSystemID, and WicActivityFileTypeExtension.
The GetEbtConnectionInfoParameters stored procedure was modified to include retrieval of the new EBTCONNECTIONINFO table parameters.
The file naming convention was updated to support WUMEI file types.
The following parameters were added in the EBTCONNECTIONINFO table to support WUMEI file types for the Expired Benefits File:
FileType, ICDVersion, UniversalServiceProviderType, WICEBTSystemID, WICMISSystemID, and WICBenefitsPurgedFileTypeExt.
The GetEbtConnectionInfoParameters stored procedure was modified to include retrieval of the new EBTCONNECTIONINFO table parameters.
The file naming convention was updated to support WUMEI file types.
The REFERENCEDICTIONARY table was modified to add a row where the value of the CATEGORY column equals "INTERNALVNDRTYP", the value of the EXTERNALID column equals "I", and the value of the DESCRIPTION column equals "Independent Grocer" if the row does not already exist. This change allows users to map the correct store type to vendor records.