Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
A new GetUPCAPLExportFileRecords stored procedure was created to return a list of rows from the EBTAUTHORIZEDUPC table and/or the EBTMAR table that have a MODIFYDTTM greater than the APLLastTransmitDate. The APLLastTransmitDate VALUE is obtained from the EBTCONNECTIONINFO table where the name is equal to "APLLastTransmitDate".
A new UpdateEbtConnectionInfoParameters stored procedure was created to update the VALUE, MODIFYDTTM, and MODIFYUSERID of the EBTCONNECTIONINFO table for the @NAME with the @VALUE, @USERID, and GETDATE() respectively.
A new InsertEbtTransactionLog stored procedure to create a record in the EBTBATCHTRANSACTIONLOG table or the EBTTRANSACTIONLOG table based on the input parameter @BatchTransaction. If @BatchTransaction is '1', a new record is created in the EBTBATCHTRANSACTIONLOG table, and if @BatchTransaction is '0, a new record is created in the EBTTRANSACTIONLOG table.
A new LoadCatSubcatFile stored procedure was created to return a list of rows from the EBTFOODCATSUBCATEGORY table that have a MODIFYDTTM greater than the CatSubcatLastTransmitDate. The CatSubcatLastTransmitDate VALUE is obtained from the EBTCONNECTIONINFO table where the name is equal to "CatSubcatLastTransmitDate".
To correct a previously-existing issue that caused existing authorized vendors that were updated not to be included in the Authorized Vendor File, the following views and stored procedure were modified to retrieve the MODIFYDTTM column from the ADDRESS, ADDRESSCROSSREF, CONTACT, CONTACTCROSSREF, and CORPORATEPARENT tables:
Views:
V_CORPORATEPARENT
V_VENDORLST_CONTACTS
V_VENDORADDRESSES
V_VENDOR
Stored Procedure:
GetJPMVendorExportList
A DF_VENDOR_APLTYPE DEFAULT ('1') constraint was added to the APLTYPE column in the VENDOR table.
A new SaveNewMar stored procedure was added to allow a denied MAR price to be overridden on the Override MAR Prices screen in the Vendor application module.