2.19.05 Database Changes

Changes made to the SPIRIT WIC database in this release of the software are detailed below.

ENH-425

Added the following column to the FoodInstrumentRedeemed table:

Column Name	Data Type	Constraint
BusinessDay	Numeric(10,0)	NULL

Added the following column to the FoodInstrumentRedeemed_Aggregated table:

Column Name	Data Type	Constraint
BusinessDay	Numeric(10,0)	NULL

EGT-46

Added the following columns to the Wholesaler table:

Column Name	Data Type	Constraint
SystemDefined	char(1)	NOT NULL DEFAULT 'N'

The following row was added to the Wholesaler table:

Column Name	Row Value
NAME	'Wholesaler Not Listed'
CREATEDTTM	GETDATE()
CREATEUSERID	'EGT-46'
MODIFYDTTM	GETDATE()
MODIFYUSERID	'EGT-46'
SystemDefined	TYPE
WholesalerID	Max(WholesalerID) + 1

The following row was added to the WholesalerType table:

Column Name	Row Value
WholesalerTypeID	Max(WholesalerTypeID) + 1
WholesalerID	WholesalerID from new Wholesaler record
WholesalerType	1
CREATEDTTM	GETDATE()
CREATEUSERID	'EGT-46'
MODIFYDTTM	GETDATE()
MODIFYUSERID	'EGT-46'

The following row was added to the WholesalerType table:

Column Name	Row Value
WholesalerTypeID	Max(WholesalerTypeID) + 1
WholesalerID	WholesalerID from new Wholesaler record
WholesalerType	2
CREATEDTTM	GETDATE()
CREATEUSERID	'EGT-46'
MODIFYDTTM	GETDATE()
MODIFYUSERID	'EGT-46'

The following row was added to the WholesalerType table:

Column Name	Row Value
WholesalerTypeID	Max(WholesalerTypeID) + 1
WholesalerID	WholesalerID from new Wholesaler record
WholesalerType	3
CREATEDTTM	GETDATE()
CREATEUSERID	'EGT-46'
MODIFYDTTM	GETDATE()
MODIFYUSERID	'EGT-46'

The following row was added to the WholesalerType table:

Column Name	Row Value
WholesalerTypeID	Max(WholesalerTypeID) + 1
WholesalerID	WholesalerID from new Wholesaler record
WholesalerType	4
CREATEDTTM	GETDATE()
CREATEUSERID	'EGT-46'
MODIFYDTTM	GETDATE()
MODIFYUSERID	'EGT-46'

NIN-3

Added the following stored procedure(s):

Stored Procedure

GetCostNeutrality

NIN-32

Modified the following stored procedure(s):

Stored Procedure

V_MULTIUSE_BREASTPUMP_DETAIL_LIST

NIN-47

Modified the following stored procedure(s):

Stored Procedure

uspVendorSaveVendorImage

NIN-53

Modified the following stored procedure(s):

Stored Procedure

uspHighRiskOutreach

NIN-54

Added the following stored procedure(s):

Stored Procedure

GetHighCostFoodInstrument

NIN-56

Modified the following stored procedure(s):

Stored Procedure

GetSupplierRebate

NIN-57

Modified the following stored procedure(s):

Stored Procedure

V_EBTFoodInstruments

Added the following user defined function(s):

Stored Procedure

GetFoodRx

NIN-65

Added the following stored procedure(s):

Stored Procedure

GetZScoreFromPct

Modified the following stored procedure(s):

Stored Procedure

sp_Vendor_GetRiskFactors

NIN-78

Added the following stored procedure(s):

Stored Procedure

GetYtdParticipationAndOutlays

NIN-79

Added the following stored procedure(s):

Stored Procedure

uspToggleHouseholdOnsite

NIN-115

Modified the following stored procedure(s):

Stored Procedure

uspInterviewAgencyPackageSaveData

Deleted the following stored procedure(s):

View

GetNextInterviewQuestionID

NIN-188

Modified the following view(s):

View

V_VENDORS_BY_COUNTY

NIN-191

Added the following stored procedure(s):

Stored Procedure

uspReportVendorSanctionPoints

Deleted the following view(s):

View

V_VENDOR_SANCTIONPOINTS

NIN-204

Added the following columns to the GSCHANGEHOUSEHOLDID table:

Column Name	Data Type	Constraint
REVIEWNEWHOUSEHOLD	Char(1)	NULL

NIN-205

Modified the following stored procedure(s):

Stored Procedure

uspEBTGetVoidData

NIN-227

Added the following stored procedure(s):

Stored Procedure

GetBFSummary

Deleted the following view(s):

View

V_INFANTS_BREASTFEEDING_SUMMARY

NIN-232

Modified the following stored procedure(s):

Stored Procedure

uspReportedParticipationMonthly

NIN-244

Added the following stored procedure(s):

Stored Procedure

uspVendorGetSanctionPointTotal

NIN-249

Added the following stored procedure(s):

Stored Procedure

uspNutritionAssessmentMismatchesCertification

NIN-264

Modified the following stored procedure(s):

Stored Procedure

uspReportGetMedicalPrescriptions

NIN-274

Modified the following view(s):

View

V_DELAYEDBLOODWORKLISTITEMS

NIN-307

Modified the following stored procedure(s):

Stored Procedure

BFDurationIsBF

BFDurationNotBF

NIN-308

Modified the following stored procedure(s):

Stored Procedure

uspReportInitialContactsReportData

NIN-310

Modified the following stored procedure(s):

Stored Procedure

uspReportGetReportedParticipationList

NIN-315

Modified the following stored procedure(s):

Stored Procedure

GetPCContactPendingBf

NIN-329

Modified the following stored procedure(s):

Stored Procedure

uspReportGetBreastfeedingInitiation

NIN-338

Modified the following stored procedure(s):

Stored Procedure

V_FOODINSTRUMENT_FISCAL_REDEMPTIONS