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_NUTRITION_CONTACTS |
Modified the following stored procedure(s):
Stored Procedure |
dbo.uspClinicActivity_Select |
dbo.uspClinicActivitySTATE_Select |
Added a new table: AgencyEligibles
Column Name |
Data Type |
Constraint |
FISCALYEARID |
Varchar(4) |
PK,FK |
AGENCYID |
Varchar(3) |
PK,FK |
PREGNANTWOMEN |
NUMERIC(7,0) |
NULL |
POSTPARTUMWOMEN |
NUMERIC(7,0) |
NULL |
INFANTS |
NUMERIC(7,0) |
NULL |
CHILDREN |
NUMERIC(7,0) |
NULL |
PRIORITY1 |
NUMERIC(7,0) |
NULL |
PRIORITY2 |
NUMERIC(7,0) |
NULL |
PRIORITY3 |
NUMERIC(7,0) |
NULL |
CREATEUSERID |
Varchar(20) |
NULL |
CREATEDTTM |
Datetime |
NULL |
ModifyUserID |
Varchar(20) |
NULL |
MODIFYDTTM |
Datetime |
NULL |
Added the following stored procedure(s):
Stored Procedure |
dbo.uspInterviewAgencyRecordInUse |
Added the following stored procedure(s):
Stored Procedure |
dbo.uspLoadYearTodateParticipationOutlays |
The indices IX_FOODINSTRUMENTSET_PARTICIPATIONDATE and IX_FOODINSTRUMENT_PROGRAMCODE that were added as part of the original change order have been removed.
Added the following columns to the EBTPending_FOODINSTRUMENT table:
Column Name |
Data Type |
Constraint |
BankFileName |
varchar(50) |
NULL |