Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Modified the following view(s):
View |
[dbo].[V_TRAINING_ROSTER] |
[dbo].[V_TRAINING_ROSTER_FOR_SS] |
Added the following stored procedure(s):
Stored Procedure |
dbo.uspCertContactUpdateRiskFactorCategories |
Modified the following stored procedure(s):
Stored Procedure |
[dbo].[uspReportGetMedicalPrescriptions] |
Modified the following stored procedure(s):
Stored Procedure |
dbo.uspReportGetInitialContactsReportData |
Added the following columns to the LocalUseCaptionHistory table:
Column Name |
Data Type |
Constraint |
EffectiveDate |
DateTime |
NOT NULL |
Added the following columns to the LocalUseCodeHistory table:
Column Name |
Data Type |
Constraint |
EffectiveDate |
DateTime |
NOT NULL |
Added the following columns to the StateUseCaptionHistory table:
Column Name |
Data Type |
Constraint |
EffectiveDate |
DateTime |
NOT NULL |
Added the following columns to the StateUseCodeHistory table:
Column Name |
Data Type |
Constraint |
EffectiveDate |
DateTime |
NOT NULL |
Removed the following columns from the LocalUseCaptionHistory table:
Column Name |
LocalUseCaptionHistoryID |
Removed the following columns from the LocalUseCodeHistory table:
Column Name |
LocalUseCodeHistoryID |
ValueSetID |
Removed the following columns from the StateUseCaptionHistory table:
Column Name |
StateUseCaptionHistoryID |
Removed the following columns from the StateUseCodeHistory table:
Column Name |
StateUseCodeHistoryID |
ValueSetID |
The following row was added to the ACM_Configuration table:
Column Name |
Row Value |
SyncOrder |
2591 |
TableName |
STATESURVEYANSWER |
BatchNumber |
27 |
UploadOnly |
Y |
The following row was deleted from the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
LocalUseCaptionHistory |
KEYCODE |
LocalUseCodeHistory |
KEYCODE |
LocalUseCodeHistoryValueSet |
Added the following stored procedure(s):
Stored Procedure |
dbo.uspSurveyItemIsInUse |
dbo.uspParticipantGetMemberOtherInfo |
Deleted the following stored procedure(s):
Stored Procedure |
[dbo].[T_UpdateSurvey] |
[dbo].[uspSaveLocalSurveyAnswer] |
[dbo].[uspSaveStateSurveyAnswer] |
[dbo].[uspGetLocalQuestionHistoryID] |
[dbo].[uspGetLocalAnswerHistoryID] |
[dbo].[uspGetStateQuestionHistoryID] |
[dbo].[uspGetStateAnswerHistoryID] |
[dbo].[trgLocalSurveyAnswer_ModifyDtTm] |
Added the following view(s):
View |
V_NON_PARTICIPATION_REMINDER_NOTICES |
Deleted the following view(s):
View |
V_NON_PARTICIPATION_REMAINDER_NOTICES |