Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Modified the following view(s):
View |
v_DirectShippedItems |
The following row was added to the STATEBUSINESSRULES table:
Column Name |
Row Value |
CATEGORYID |
CLN_PromptForPFDTUAdjustment |
VALUE |
N |
DESCRIPTION |
Prompt the user to pick a PFDTU if the original value is before the certification effective date. |
Modified the following view(s):
View |
[dbo].[V_CLASS_ENROLLMENTS_REPORT] |
Modified the following stored procedure(s):
Stored Procedure |
[dbo].[uspReportGetClassEnrollmentData] |
Modified the following stored procedure(s):
Stored Procedure |
[dbo].[uspReportGetMedicalPrescriptions] |
[dbo].[uspReportGetMedicalPrescriptionsRxExpiration] |
Modified the following view(s):
View |
V_EOD_ARCHIVE_INACTIVE_PARTICIPANTS |
Added the following columns to the dbo.CaseloadCountInitialParticipation table:
Column Name |
Data Type |
Constraint |
PRIORITY |
VARCHAR(1) |
NOT NULL |
SUBPRIORITY |
VARCHAR(1) |
NOT NULL |
Added the following stored procedure(s):
Stored Procedure |
dbo.uspCaseloadCountInitialParticipationSave |
dbo.uspGetInitAndCloseoutParticipation |
Added the following stored procedure(s):
Stored Procedure |
uspVendorAddnewPriceListItems |
Modified the following stored procedure(s):
Stored Procedure |
uspSaveNewPriceList |
uspSavePendingCorporatePrice |
uspSavePendingVendorPrice |
Added the following columns to the Communication table:
Column Name |
Data Type |
Constraint |
UsePreviousPrices |
char(1) |
DEFAULT 'N' NOT NULL |