Contents Show
Changes made to the SPIRIT WIC database in this release of the software are detailed below.
Added a new table: BankExceptionHistory
Column Name |
Data Type |
Constraint |
BankExceptionHistoryID |
numeric(10,0) |
NOT NULL |
ActionID |
varchar(1) |
NOT NULL |
LOGID |
numeric(10,0) |
NOT NULL |
SERIALNO |
varchar(8) |
NOT NULL |
PAIDDATE |
datetime |
NULL |
PAIDAMT |
numeric(7,2) |
NULL |
REJECTIONDATE |
datetime |
NULL |
REJECTIONCODE |
varchar(2) |
NULL |
PRESENTMENTAMT |
numeric(7,2) |
NOT NULL |
STAMPNUMBER |
varchar(7) |
NULL |
ERRORMSGID |
varchar(10) |
NOT NULL |
PROGRAMCODE |
char |
NOT NULL |
PAIDIND |
char |
NULL |
REAPPLYIND |
char |
NULL |
BankFileName |
varchar(50) |
NULL |
ConsignmentMachineId |
varchar(50) |
NULL |
Active |
char |
NULL |
ArchivedCREATEUSERID |
varchar(20) |
NULL |
ArchivedCREATEDTTM |
datetime |
NULL |
ArchivedMODIFYUSERID |
varchar(20) |
NULL |
ArchivedMODIFYDTTM |
datetime |
NULL |
CREATEUSERID |
varchar(20) |
NULL |
CREATEDTTM |
datetime |
NULL |
MODIFYUSERID |
varchar(20) |
NULL |
MODIFYDTTM |
datetime |
NULL |
SerialNoPostedTo |
varchar(8) |
NULL |
Added a new table: OnDemandBankPaidFileProcess
Column Name |
Data Type |
Constraint |
OnDemandBankPaidFileProcessID |
numeric(18,0) |
Not Null |
AccessDateTime |
datetime |
Not Null |
AccessUserID |
varchar(50) |
Not Null |
CreateUserId |
varchar(50) |
Null |
CreateDttm |
datetime |
Null |
ModifyUserId |
varchar(50) |
Null |
ModifyDttm |
datetime |
Null |
Added the following columns to the BankExceptions table:
Column Name |
Data Type |
Constraint |
Active |
char(1) |
DEFAULT("Y") |
Added the following columns to the BankException table:
Column Name |
Data Type |
Constraint |
BankFileName |
Varchar(50) |
NULL |
ConsignmentMachineId |
Varchar(50) |
NULL |
Added the following columns to the FoodInstrument table:
Column Name |
Data Type |
Constraint |
BankFileName |
varchar(50) |
NULL |
The following row was added to the StateBusinessRules table:
Column Name |
Row Value |
CategoryID |
BankEx_AllowPostToVoidedFI |
Value |
N |
Description |
Allow bank exception posts to voided food instrument |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
Category |
NOTIFICATIONPROCESS |
DESCRIPTION |
Name of System Process that Generates Notifications |
STATEDEFINED |
Y |
VALUETYPE |
N |
VALUELENGTH |
1 |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
NOTIFICATIONPROCESS |
EXTERNALID |
1 |
DESCRIPTION |
Bank Exceptions |
SORTVALUE |
1 |
ACTIVE |
(VARIES) |
SYSTEMDEFINED |
N |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
NOTIFICATIONPROCESS |
EXTERNALID |
2 |
DESCRIPTION |
Batch File |
SORTVALUE |
2 |
ACTIVE |
(VARIES) |
SYSTEMDEFINED |
N |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
NOTIFICATIONPROCESS |
EXTERNALID |
3 |
DESCRIPTION |
EBT MAR |
SORTVALUE |
3 |
ACTIVE |
(VARIES) |
SYSTEMDEFINED |
N |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
BNKEXCPTACTION |
EXTERNALID |
1 |
DESCRIPTION |
Edit |
SORTVALUE |
1 |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
Category |
BNKEXCPTACTION |
DESCRIPTION |
Actions allowed when resolving bank exceptions |
STATEDEFINED |
N |
VALUETYPE |
N |
VALUELENGTH |
1 |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
BNKEXCPTACTION |
EXTERNALID |
2 |
DESCRIPTION |
Post |
SORTVALUE |
2 |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
BNKEXCPTACTION |
EXTERNALID |
3 |
DESCRIPTION |
Swap |
SORTVALUE |
3 |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
NOTIFICATIONPROCESS |
EXTERNALID |
4 |
DESCRIPTION |
EBT Reconciliation |
SORTVALUE |
4 |
ACTIVE |
(VARIES) |
SYSTEMDEFINED |
N |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
BNKEXCPTREASON |
EXTERNALID |
30 |
DESCRIPTION |
Food Instrument was voided. |
SORTVALUE |
30 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
Category |
BNKEXCPTREASON |
EXTERNALID |
99 |
DESCRIPTION |
Manually Un-posted |
SORTVALUE |
99 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-10 |
CREATEDTTM |
GETDATE() |
Added the following columns to the CLASSENROLLMENT table:
Column Name |
Data Type |
Constraint |
CONFIRMED |
char(1) |
DEFAULT("N") |
CONFIRMEDDATE |
DATETIME |
NULL |
CONFIRMEDCOMMENT |
VARCHAR(500) |
NULL |
Modified the following view(s):
View |
V_SCHEDULES |
The following features of the FEATURE table have been implemented:
Feature ID |
Feature Group |
Feature |
744 |
Central Administrative Site |
Allow Access to Central Administrative Site Module |
200 |
Central Administrative Site |
Master Calendar |
775 |
Direct Distribution |
Allow Access to Direct Distribution Module |
778 |
Direct Distribution |
Configure Direct Distribution |
777 |
Direct Distribution |
Manage Inventory |
776 |
Direct Distribution |
Set inventory Location |
600 |
Financial Management |
Allow Access to Financial Management Module |
611 |
Financial Management |
Bank Exceptions |
400 |
Management Console |
Allow Access to Management Console Module |
412 |
Management Console |
Reset Password |
149 |
Participant Management |
Allow Access to Clinic Module |
118 |
Participant Management |
Breastfeeding |
114 |
Participant Management |
Certification |
128 |
Participant Management |
Credit Group Education Class |
119 |
Participant Management |
General Notes |
615 |
Participant Management |
Issue EBT Food Instruments |
125 |
Participant Management |
Nutrition Education |
113/110 |
Participant Management |
Participant Transfer |
136 |
Participant Management |
Produce VOC |
150 |
Participant Management |
Report |
142 |
Participant Management |
Scan a Document |
116 |
Participant Management |
VOC Certification |
617 |
Participant Management |
Void EBT Food Instruments |
716 |
Reference Utility |
Adjunctive Income Eligibility |
717 |
Reference Utility |
Agencies |
714 |
Reference Utility |
Allow Access to Reference Utility Module |
718 |
Reference Utility |
Corporate Parents |
719 |
Reference Utility |
Counties |
720 |
Reference Utility |
County/City by ZIP |
721 |
Reference Utility |
Default Food Package |
722 |
Reference Utility |
Documents |
723 |
Reference Utility |
Education Topics |
724 |
Reference Utility |
Facilities |
725 |
Reference Utility |
Fixed Nighttime Locations |
726 |
Reference Utility |
Food Distribution Items |
727 |
Reference Utility |
Food Items |
728 |
Reference Utility |
Grantee |
729 |
Reference Utility |
High Risk Volume Score |
730 |
Reference Utility |
Income Eligibility Amounts |
741 |
Reference Utility |
Maintain State Nutrition Assessment |
732 |
Reference Utility |
Materials Given |
734 |
Reference Utility |
Medical Home |
735 |
Reference Utility |
Other WIC Programs |
736 |
Reference Utility |
Owners/Partners |
737 |
Reference Utility |
Referebce Dictionary |
738 |
Reference Utility |
Risk Factors |
739 |
Reference Utility |
State Questions |
740 |
Reference Utility |
UPC List |
731 |
Reference Utility |
Wholesalers |
804 |
Scheduled Job Administration |
Run File Management |
803 |
Scheduled Job Administration |
Run Interrogator Administration |
802 |
Scheduled Job Administration |
Run WIC End of Day Administration |
801 |
Scheduled Job Administration |
Run WIC End of Month Administration |
805 |
Scheduled Job Administration |
Schedule Job Admin |
715 |
State Office |
Allow Access to Report Generator Module |
300 |
State Office |
Allow Access to State Office Module |
310 |
State Office |
Assigned Caseload |
311 |
State Office |
Calculate Estimated Eligible Caseload |
306 |
State Office |
County Caseload |
305 |
State Office |
Estimated Caseload |
309 |
State Office |
Manage Consigned Breastpumps |
308 |
State Office |
Participant Investigation Results |
320 |
State Office |
Record Replacement Item |
321 |
State Office |
Report |
403 |
System Administration |
Agency Settings |
408 |
System Administration |
Allow Access to System Administration Module |
404 |
System Administration |
Clinic Information Maintenance |
411 |
System Administration |
Data Sync History |
409 |
System Administration |
Event Logs |
405 |
System Administration |
Maintain Local Use Caption |
407 |
System Administration |
Programs |
410 |
System Administration |
System Access Log |
742 |
System Adminstration |
Maintain Local Nutrition Assessement |
713 |
Vendor Management |
Allow Access to Vendor Module |
646 |
Vendor Management |
Manage Vouchers |
810 |
WIC Outreach Loaner Program |
Allow Access to WIC Outreach Loaner Program Module |
813 |
WIC Outreach Loaner Program |
Breastpump Issuance History |
812 |
WIC Outreach Loaner Program |
Issue Breastfeeding Items |
811 |
WIC Outreach Loaner Program |
WIC Outreach Woman |
The following features of the FEATURE table have been removed:
Feature ID |
Feature Group |
Feature |
617 |
Participant Management |
Add EBT Food Instruments |
145 |
Participant Management |
Appointment Scheduling |
134 |
Participant Management |
Breastpump History |
101 |
Participant Management |
Clinic's General Client Information |
617 |
Participant Management |
Edit EBT Food Instruments |
144 |
Participant Management |
Food Instrument Issuance |
133 |
Participant Management |
Reinstate Participant |
147 |
Participant Management |
Transfer WIC Participant into CSFP |
· |
Participant Questionnaire |
Participant Questionnaire |
· |
Participant Questionnaire |
Participant Questionnaire Reports |
301 |
State Office |
Caseload Management |
303 |
State Office |
Check Stock Maintenance |
302 |
State Office |
Participant View |
203 |
System Administration |
Manage Available WIC Application |
The added tables were seeded with converted data from the SQL scripts that are required to be run with release 2.17.
Added a new table: Interview
Column Name |
Data Type |
Constraint |
InterviewID |
NUMERIC(10) |
NOT NULL |
InterviewType |
VARCHAR(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewAgency
Column Name |
Data Type |
Constraint |
InterviewAgencyID |
NUMERIC(10) |
NOT NULL |
InterviewID |
NUMERIC(10) |
NULL |
AgencyID |
VARCHAR(3) |
NULL |
WICStatus |
CHAR(1) |
NOT NULL |
AgeCategoryID |
CHAR(1) |
NOT NULL |
AmountBreastfeeding |
VARCHAR(10) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewAgencyEditPoint
Column Name |
Data Type |
Constraint |
AgencyID |
VARCHAR(3) |
NOT NULL |
InterviewType |
VARCHAR(10) |
NOT NULL |
EditData |
VARCHAR(MAX) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewAgencyRiskFactor
Column Name |
Data Type |
Constraint |
InterviewAgencyID |
NUMERIC(10) |
NOT NULL |
InterviewID |
NUMERIC(10) |
NOT NULL |
InterviewQuestionID |
NUMERIC(10) |
NOT NULL |
InterviewAnswerID |
NUMERIC(10) |
NOT NULL |
RiskFactorID |
VARCHAR(6) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewAnswer
Column Name |
Data Type |
Constraint |
InterviewID |
NUMERIC(10) |
NOT NULL |
InterviewQuestionID |
NUMERIC(10) |
NOT NULL |
InterviewAnswerID |
NUMERIC(10) |
NOT NULL |
NextInterviewQuestionID |
NUMERIC(10) |
NULL |
InterviewTextID |
NUMERIC(10) |
NULL |
RequireComment |
VARCHAR(1) |
NULL |
Active |
VARCHAR(1) |
NULL |
SortValue |
INT |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewComment
Column Name |
Data Type |
Constraint |
InterviewCommentID |
NUMERIC(10) |
NOT NULL |
SHA1Hash |
VARCHAR(28) |
NOT NULL |
Description |
VARCHAR(MAX) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewCommentConsignment
Column Name |
Data Type |
Constraint |
MachineID |
VARCHAR(100) |
NOT NULL |
StartingID |
NUMERIC(10) |
NOT NULL |
EndingID |
NUMERIC(10) |
NOT NULL |
LastUsedID |
NUMERIC(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewName
Column Name |
Data Type |
Constraint |
InterviewNameID |
NUMERIC(10) |
NOT NULL |
SHA1Hash |
VARCHAR(28) |
NOT NULL |
Description |
VARCHAR(MAX) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewQuestion
Column Name |
Data Type |
Constraint |
InterviewID |
NUMERIC(10) |
NOT NULL |
InterviewQuestionID |
NUMERIC(10) |
NOT NULL |
QuestionType |
VARCHAR(10) |
NOT NULL |
AnswerType |
VARCHAR(10) |
NULL |
InterviewTextID |
NUMERIC(10) |
NULL |
InterviewNameID |
NUMERIC(10) |
NULL |
RequireAnswer |
VARCHAR(1) |
NULL |
EffectiveDate |
DATETIME |
NULL |
EndDate |
DATETIME |
NULL |
SortValue |
INT |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewShortAnswer
Column Name |
Data Type |
Constraint |
InterviewShortAnswerID |
NUMERIC(10) |
NOT NULL |
SHA1Hash |
VARCHAR(28) |
NOT NULL |
Description |
VARCHAR(MAX) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewShortAnswerConsignment
Column Name |
Data Type |
Constraint |
MachineID |
VARCHAR(100) |
NOT NULL |
StartingID |
NUMERIC(10) |
NOT NULL |
EndingID |
NUMERIC(10) |
NOT NULL |
LastUsedID |
NUMERIC(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: InterviewText
Column Name |
Data Type |
Constraint |
InterviewTextID |
NUMERIC(10) |
NOT NULL |
SHA1Hash |
VARCHAR(28) |
NOT NULL |
Description |
VARCHAR(MAX) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: NutritionAssessmentContact
Column Name |
Data Type |
Constraint |
NutritionAssessmentContactID |
NUMERIC(10) |
NOT NULL |
StateWICID |
VARCHAR(8) |
NOT NULL |
ContactDate |
DATETIME |
NOT NULL |
CertStartDate |
DATETIME |
NULL |
RFAssigned |
VARCHAR(1) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: NutritionAssessmentContactConsignment
Column Name |
Data Type |
Constraint |
MachineID |
VARCHAR(100) |
NOT NULL |
StartingID |
NUMERIC(10) |
NOT NULL |
EndingID |
NUMERIC(10) |
NOT NULL |
LastUsedID |
NUMERIC(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: NutritionAssessmentContactItem
Column Name |
Data Type |
Constraint |
NutritionAssessmentContactItemID |
NUMERIC(10) |
NOT NULL |
NutritionAssessmentContactID |
NUMERIC(10) |
NOT NULL |
InterviewAgencyID |
NUMERIC(10) |
NOT NULL |
InterviewID |
NUMERIC(10) |
NOT NULL |
InterviewQuestionID |
NUMERIC(10) |
NOT NULL |
InterviewAnswerID |
NUMERIC(10) |
NULL |
InterviewShortAnswerID |
NUMERIC(10) |
NULL |
InterviewCommentID |
NUMERIC(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: NutritionAssessmentContactItemConsignment
Column Name |
Data Type |
Constraint |
MachineID |
VARCHAR(100) |
NOT NULL |
StartingID |
NUMERIC(10) |
NOT NULL |
EndingID |
NUMERIC(10) |
NOT NULL |
LastUsedID |
NUMERIC(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: NutritionAssessmentContactItemRiskFactor
Column Name |
Data Type |
Constraint |
NutritionAssessmentContactItemRiskFactorID |
NUMERIC(10) |
NOT NULL |
NutritionAssessmentContactID |
NUMERIC(10) |
NOT NULL |
NutritionAssessmentContactItemID |
NUMERIC(10) |
NULL |
InterviewAgencyID |
NUMERIC(10) |
NOT NULL |
AmountBreastfeeding2 |
VARCHAR(10) |
NOT NULL |
RiskFactorID |
VARCHAR(6) |
NOT NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: NutritionAssessmentContactItemRiskFactorConsignment
Column Name |
Data Type |
Constraint |
MachineID |
VARCHAR(100) |
NOT NULL |
StartingID |
NUMERIC(10) |
NOT NULL |
EndingID |
NUMERIC(10) |
NOT NULL |
LastUsedID |
NUMERIC(10) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
CATEGORY |
QuestionType |
DESCRIPTION |
Question with a certain type of answers |
STATEDEFINED |
N |
VALUETYPE |
A |
VALUELENGTH |
3 |
CREATEUSERID |
ENH-233 |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
CATEGORY |
AnswerType |
DESCRIPTION |
Types of answers allowed for a question |
STATEDEFINED |
N |
VALUETYPE |
A |
VALUELENGTH |
3 |
CREATEUSERID |
ENH-233 |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
CATEGORY |
InterviewType |
DESCRIPTION |
Identifier used to classify a set of questions and answers |
STATEDEFINED |
N |
VALUETYPE |
A |
VALUELENGTH |
9 |
CREATEUSERID |
ENH-233 |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
CATEGORY |
AnswerNextAction |
DESCRIPTION |
Actions allowed for an answer |
STATEDEFINED |
N |
VALUETYPE |
N |
VALUELENGTH |
1 |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
QuestionType |
EXTERNALID |
MC |
DESCRIPTION |
Multiple Choice |
SORTVALUE |
1 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
QuestionType |
EXTERNALID |
SA |
DESCRIPTION |
Short Answer |
SORTVALUE |
2 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
QuestionType |
EXTERNALID |
T/F |
DESCRIPTION |
True/False |
SORTVALUE |
3 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerType |
EXTERNALID |
MR |
DESCRIPTION |
Multiple Response |
SORTVALUE |
1 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerType |
EXTERNALID |
SR |
DESCRIPTION |
Single Response |
SORTVALUE |
2 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerType |
EXTERNALID |
T/F |
DESCRIPTION |
True/False |
SORTVALUE |
3 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerType |
EXTERNALID |
Y/N |
DESCRIPTION |
Yes/No |
SORTVALUE |
4 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
InterviewType |
EXTERNALID |
SNA |
DESCRIPTION |
State Nutrition Assessment |
SORTVALUE |
1 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
InterviewType |
EXTERNALID |
LNA |
DESCRIPTION |
Local Nutrition Assessment |
SORTVALUE |
2 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
InterviewType |
EXTERNALID |
VENA |
DESCRIPTION |
Value Added Nutrition Assessment |
SORTVALUE |
3 |
ACTIVE |
N |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
InterviewName |
LASTNUMBERUSED |
(Based on Converted Data) |
MODIFYUSERID |
ENH-233 |
The following row was added to the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
InterviewText |
LASTNUMBERUSED |
(Based on Converted Data) |
MODIFYUSERID |
ENH-233 |
The following row was added to the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
Interview |
LASTNUMBERUSED |
(Based on Converted Data) |
MODIFYUSERID |
ENH-233 |
The following row was added to the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
InterviewQuestion |
LASTNUMBERUSED |
(Based on Converted Data) |
MODIFYUSERID |
ENH-233 |
The following row was added to the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
InterviewAnswer |
LASTNUMBERUSED |
(Based on Converted Data) |
MODIFYUSERID |
ENH-233 |
The following row was added to the SEQNUMBERS table:
Column Name |
Row Value |
KEYCODE |
InterviewAgency |
LASTNUMBERUSED |
(Based on Converted Data) |
MODIFYUSERID |
ENH-233 |
The following row was added to the NutritionAssessmentContactConsignment table:
Column Name |
Row Value |
MACHINEID |
WebService |
STARTINGID |
1 |
ENDINGID |
(Based on Converted Data) |
LASTNUMBERUSED |
(Based on Converted Data) |
CREATEUSERID |
ENH-233 |
MODIFYUSERID |
ENH-233 |
The following row was added to the NutritionAssessmentContactItemConsignment table:
Column Name |
Row Value |
MACHINEID |
WebService |
STARTINGID |
1 |
ENDINGID |
(Based on Converted Data) |
LASTNUMBERUSED |
(Based on Converted Data) |
CREATEUSERID |
ENH-233 |
MODIFYUSERID |
ENH-233 |
The following row was added to the NutritionAssessmentContactItemRiskFactorConsignment table:
Column Name |
Row Value |
MACHINEID |
WebService |
STARTINGID |
1 |
ENDINGID |
(Based on Converted Data) |
LASTNUMBERUSED |
(Based on Converted Data) |
CREATEUSERID |
ENH-233 |
MODIFYUSERID |
ENH-233 |
The following row was added to the InterviewShortAnswerConsignment table:
Column Name |
Row Value |
MACHINEID |
WebService |
STARTINGID |
1 |
ENDINGID |
(Based on Converted Data) |
LASTNUMBERUSED |
(Based on Converted Data) |
CREATEUSERID |
ENH-233 |
MODIFYUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerNextAction |
EXTERNALID |
1 |
DESCRIPTION |
Go to the next active question |
SORTVALUE |
1 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerNextAction |
EXTERNALID |
2 |
DESCRIPTION |
Go to the previous active question |
SORTVALUE |
2 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
AnswerNextAction |
EXTERNALID |
3 |
DESCRIPTION |
Jump to a target question |
SORTVALUE |
3 |
ACTIVE |
Y |
SYSTEMDEFINED |
Y |
CREATEUSERID |
ENH-233 |
The following row was deleted from the ReferenceTableCatalog table:
Column Name |
Row Value |
REFERENCETABLECATALOGID |
VENAQUESTION |
Added the following stored procedure(s):
Stored Procedure |
[dbo].[ReserveConsignmentBlocks] |
[dbo].[GetNextConsignmentValue] |
[dbo].[GetNextConsignmentString] |
[dbo].[GetNextInterviewQuestionID] |
[dbo].[GetNextInterviewAnswerID] |
[dbo].[uspParseXml] |
[dbo].[uspInterviewAgencyPackageGetData] |
[dbo].[uspInterviewAgencyPackageGetEditPoint] |
[dbo].[uspInterviewAgencyPackageSaveEditPoint] |
[dbo].[uspInterviewAgencyPackageGetCounters] |
[dbo].[uspInterviewAgencyPackageSaveData] |
[dbo].[uspNutritionAssessmentGetPreviousAnswers] |
[dbo].[uspNutritionAssessmentSaveContact] |
[dbo].[uspNutritionAssessmentDeleteContact] |
[dbo].[uspNutritionAssessmentGetContacts] |
[dbo].[uspNutritionAssessmentExists] |
[dbo].[uspNutritionAssessmentHasRiskFactors] |
[dbo].[uspNutritionAssessmentGetQuickView] |
[dbo].[uspNutritionAssessmentCheckForDuplicateContact] |
Modified the following stored procedure(s):
Stored Procedure |
[dbo].[uspCertificationHistory_Select] |
[dbo].[uspPrintString] |
Deleted the following stored procedure(s):
Stored Procedure |
[dbo].[GetNextInterviewTextID] |
[dbo].[GetNextInterviewNameID] |
[dbo].[GetNextInterviewID] |
[dbo].[GetNextInterviewAgencyID] |
[dbo].[GetNextInterviewCommentID] |
[dbo].[GetNextInterviewShortAnswerID] |
[dbo].[GetNextNutritionAssessmentContactID] |
[dbo].[GetNextNutritionAssessmentContactItemID] |
[dbo].[GetNextNutritionAssessmentContactItemRiskFactorID] |
Added the following user defined function(s):
User Defined Function |
[dbo].[CleanString] |
[dbo].[FloorOfDate] |
Added the following stored procedure(s):
Stored Procedure |
uspReportedParticipationMonthly |
uspRedeemedParticipationMonthly |
uspHighRiskOutreach |
Added a new table: MEMBER_AuthRep_Old
Column Name |
Data Type |
Constraint |
STATEWICID |
[varchar](8) |
NOT NULL |
HOUSEHOLDID |
[varchar](8) |
NOT NULL |
EDUCATIONLEVEL |
[varchar](2) |
NULL |
MARITALSTATUS |
[char](1) |
NULL |
AUTHREPLASTNAME |
[varchar](25) |
NULL |
AUTHREPFIRSTNAME |
[varchar](20) |
NULL |
AUTHREPMIDDLEINITIAL |
[char](1) |
NULL |
ALTAUTHREPLASTNAME |
[varchar](25) |
NULL |
ALTAUTHREPFIRSTNAME |
[varchar](20) |
NULL |
ALTAUTHREPMIDDLEINITIAL |
[char](1) |
NULL |
PROXYLASTNAME |
[varchar](25) |
NULL |
PROXYFIRSTNAME |
[varchar](20) |
NULL |
PROXYMIDDLEINITIAL |
[char](1) |
NULL |
REGISTERTOVOTE |
[char](1) |
NULL |
Added the following columns to the HOUSEHOLD table:
Column Name |
Data Type |
Constraint |
AUTHREPLASTNAME |
varchar(25) |
NULL |
AUTHREPFIRSTNAME |
varchar(20) |
NULL |
AUTHREPMIDDLEINITIAL |
char(1) |
NULL |
AUTHREPRELATIONSHIP |
varchar(10) |
NULL |
AUTHREPMARITALSTATUS |
char(1) |
NULL |
AUTHREPEDUCATIONLEVEL |
varchar(2) |
NULL |
AUTHREPREGISTERTOVOTE |
char(1) |
NULL |
ALTREP1LASTNAME |
varchar(25) |
NULL |
ALTREP1FIRSTNAME |
varchar(20) |
NULL |
ALTREP1MIDDLEINITIAL |
char(1) |
NULL |
ALTREP1RELATIONSHIP |
varchar(10) |
NULL |
ALTREP2LASTNAME |
varchar(25) |
NULL |
ALTREP2FIRSTNAME |
varchar(20) |
NULL |
ALTREP2MIDDLEINITIAL |
char(1) |
NULL |
ALTREP2RELATIONSHIP |
varchar(10) |
NULL |
Added the following columns to the HOUSEHOLDHISTORY table:
Column Name |
Data Type |
Constraint |
AUTHREPLASTNAME |
varchar(25) |
NULL |
AUTHREPFIRSTNAME |
varchar(20) |
NULL |
AUTHREPMIDDLEINITIAL |
char(1) |
NULL |
AUTHREPRELATIONSHIP |
varchar(10) |
NULL |
AUTHREPMARITALSTATUS |
char(1) |
NULL |
AUTHREPEDUCATIONLEVEL |
varchar(2) |
NULL |
AUTHREPREGISTERTOVOTE |
char(1) |
NULL |
ALTREP1LASTNAME |
varchar(25) |
NULL |
ALTREP1FIRSTNAME |
varchar(20) |
NULL |
ALTREP1MIDDLEINITIAL |
char(1) |
NULL |
ALTREP1RELATIONSHIP |
varchar(10) |
NULL |
ALTREP2LASTNAME |
varchar(25) |
NULL |
ALTREP2FIRSTNAME |
varchar(20) |
NULL |
ALTREP2MIDDLEINITIAL |
char(1) |
NULL |
ALTREP2RELATIONSHIP |
varchar(10) |
NULL |
Removed the following columns from the MEMBER table:
Column Name |
EDUCATIONLEVEL |
MARITALSTATUS |
AUTHREPLASTNAME |
AUTHREPFIRSTNAME |
AUTHREPMIDDLEINITIAL |
ALTAUTHREPLASTNAME |
ALTAUTHREPFIRSTNAME |
ALTAUTHREPMIDDLEINITIAL |
PROXYLASTNAME |
PROXYFIRSTNAME |
PROXYMIDDLEINITIAL |
REGISTERTOVOTE |
Modified the following stored procedure(s):
Stored Procedure |
uspGetCDCPNSSData |
uspGetUSDAData |
Modified the following view(s):
View |
V_PARTICIPANT_LIST |
V_HOUSEHOLDMEMBERS |
V_USDA_CLIENT |
V_USDA_DATA |
V_CERTIFICATIONNOTICE |
V_DUAL_ENROLLMENT |
V_ENROLLMENT_CASES |
V_PARTICIPANTSUMMARY |
V_PARTICIPANT_WITH_APPTS |
V_SCHEDULES |
Added the following columns to the fOODiTEM table:
Column Name |
Data Type |
Constraint |
SortOrder |
NUMERIC(10, 0) |
NULL |
Modified the following view(s):
View |
V_FORMULAITEM |
Added a new table: InitialContact
Column Name |
Data Type |
Constraint |
StateWICID |
VARCHAR(8) |
FK_InitialContact_StateWICID |
InitialContactDate |
DATE |
NULL |
InitialContactTypeID |
INT |
NULL |
FirstAppointmentOfferedDate |
DATE |
NULL |
CertificationID |
NUMERIC(10,0) |
NULL |
Comments |
VARCHAR(50) |
NULL |
CreateUserID |
VARCHAR(20) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
The following row was added to the REFDICTIONARYCATEGORY table:
Column Name |
Row Value |
CATEGORY |
INITIALCONTACTTYPE |
DESCRIPTION |
Type of initial contact prior to certification |
STATEDEFINED |
Y |
VALUETYPE |
N |
VALUELENGTH |
2 |
CREATEUSERID |
ENH-334 |
CREATEDTTM |
SystemDate |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
INITIALCONTACTTYPE |
DESCRIPTION |
Phone |
EXTERNALID |
1 |
SORTVALUE |
1 |
SYSTEMDEFINED |
N |
CREATEUSERID |
ENH-334 |
CREATEDTTM |
SystemDate |
The following row was added to the REFERENCEDICTIONARY table:
Column Name |
Row Value |
CATEGORY |
INITIALCONTACTTYPE |
DESCRIPTION |
Walk-In |
EXTERNALID |
2 |
SORTVALUE |
2 |
SYSTEMDEFINED |
N |
CREATEUSERID |
ENH-334 |
CREATEDTTM |
SystemDate |
The following row was added to the StateBusinessRules table:
Column Name |
Row Value |
CategoryiD |
CLN_InitialContactTypeDefault |
Value |
NULL |
Description |
This state uses initial contact type default |
Added a new table: HighRiskFiscalYearCriteria
Column Name |
Data Type |
Constraint |
HighRiskCriteriaID |
Int |
NOT NULL |
Name |
Varchar(100) |
NOT NULL |
AutoAssign |
Char(1) |
NULL |
Operator |
Varchar(10) |
NULL |
Value |
numeric(12, 4) |
NULL |
Tip |
varchar(4) |
NULL |
Factor |
numeric(12, 4) |
NULL |
Include |
char(1) |
NULL |
Sortorder |
Int |
NULL |
Description |
varchar(1000) |
NULL |
Description2 |
varchar(200) |
NULL |
Valueformat |
varchar(20) |
NULL |
Defaultvalue |
numeric(12,4) |
NULL |
CREATEUSERID |
varchar(20) |
NULL |
CREATEDTTM |
datetime |
NULL |
MODIFYUSERID |
varchar(20) |
NULL |
MODIFYDTTM |
datetime |
NULL |
FiscalYear |
char(4) |
NOT NULL |
Added the following columns to the HighRiskAnalysisResults table:
Column Name |
Data Type |
Constraint |
TipAnalysis |
Char(1) |
NULL |
FiscalYear |
Char(4) |
NULL |
Added the following stored procedure(s):
Stored Procedure |
uspDeleteSavedVendorHRFY |
uspGetTipAnalysisCriteria |
uspGetTipVendorInvestigation |
uspGetSavedVendorHRFYs |
uspPreserveHighRiskFiscalYearCriteria |
uspGetHighRiskFiscalYearCriteria |
uspGetSavedVendorHRFY |
uspGetTipVendorReportData |
Added a new table: SecuritySettings
Column Name |
Data Type |
Constraint |
SecuritySettingsId |
int |
IDENTITY (1,1) primary key NOT NULL |
PwdMinimumLength |
int |
NULL |
PwdExpiresAfterDays |
int |
NULL |
PwdCannotReuseLast |
int |
NULL |
PwdFormatUpper |
char(1) |
NULL |
PwdFormatLower |
char(1) |
NULL |
PwdFormatNumeric |
char(1) |
NULL |
PwdFormatSpecialCharacters |
char(1) |
NULL |
PwdDictionaryCheck |
char(1) |
NULL |
PwdDefaultType |
varchar(1) |
NULL |
PwdResetValue |
varchar(16) |
NULL |
LockoutMinutes |
int |
NULL |
LockoutAfterAttempts |
int |
NULL |
UserSessionTimeoutMinutes |
int |
NULL |
CreateUserID |
varchar(20) |
NULL |
CreateDtTm |
datetime |
NULL |
ModifyUserID |
varchar(20) |
NULL |
ModifyDtTm |
datetime |
NULL |
Added a new table: PasswordHistory
Column Name |
Data Type |
Constraint |
PasswordHistoryID |
int |
IDENTITY (1,1) primary key NOT NULL |
UserID |
varchar(20) |
NULL |
Password |
varchar(50) |
NULL |
CreateUserID |
varchar(20) |
NULL |
CreateDtTm |
datetime |
NULL |
Added a new table: PasswordDictionary
Column Name |
Data Type |
Constraint |
PasswordDictionaryID |
int |
IDENTITY (1,1) primary key NOT NULL |
DictionaryWord |
varchar(16) |
NULL |
The PasswordDictionary table is seeded with 148,787 words.
Added the following columns to the USERPROFILE table:
Column Name |
Data Type |
Constraint |
PwdChangeNextLogin |
char(1) |
default("N") |
PwdExpires |
char(1) |
default("Y") |
PwdDefaultVariable |
char(4) |
NULL |
LockedOut |
char(1) |
default("N") |
SetLockedOutDtTm |
char(1) |
default("N") |
LockedOutDtTm |
datetime |
NULL |
PASSWORD |
varchar(50) |
NULL |
PwdChangeNextLogin is initially set to "N", PwdExpires is initially set to "Y", and LockedOut is initially set to "N" for all records.
Removed the following columns from the USERPROFILE table:
Column Name |
PASSWORD |
Added a new table: ACM_Clinic
Column Name |
Data Type |
Constraint |
AcmClinicId |
UniqueIdentifier |
NOT NULL |
AgencyID |
VARCHAR(3) |
NOT NULL |
ServiceSiteID |
VARCHAR(3) |
NOT NULL |
IsOnline |
BIT |
NOT NULL |
IsActive |
BIT |
NOT NULL |
IsDownloadable |
BIT |
NOT NULL |
CreateUserID |
VARCHAR(40) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(40) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: OfflineClinicFlag
Column Name |
Data Type |
Constraint |
ClinicID |
VARCHAR(40) |
NOT NULL |
IsOffline |
BIT |
NULL |
Added a new table: Checkout
Column Name |
Data Type |
Constraint |
ID |
INT |
NOT NULL |
MachineName |
VACHAR(50) |
NOT NULL |
CheckOutStart |
DATETIME |
NOT NULL |
CheckOutFinish |
DATETIME |
NULL |
CheckOutByAppUserID |
UNIQUEIDENTIFIER |
NOT NULL |
CheckInStart |
DATETIME |
NULL |
CheckInFinish |
DATETIME |
NULL |
CheckInByAppUserID |
UNIQUEIDENTIFIER |
NULL |
CreatedDate |
DATETIME |
NOT NULL |
CreatedByAppUserID |
UNIQUEIDENTIFIER |
NOT NULL |
ModifyDtTm |
DATETIME |
NULL |
LastModifiedByAppUserID |
UNIQUEIDENTIFIER |
NULL |
Added a new table: ClinicCheckout
Column Name |
Data Type |
Constraint |
ID |
INT |
NOT NULL |
CheckOutID |
INT |
NOT NULL |
ClinicID |
UNIQUEIDENTIFIER |
NOT NULL |
CreatedDate |
DATETIME |
NOT NULL |
CreatedByAppUserID |
UNIQUEIDENTIFIER |
NOT NULL |
ModifyDtTm |
DATETIME |
NULL |
LastModifiedByAppUserID |
UNIQUEIDENTIFIER |
NULL |
Added a new table: ClinicSynchronizationStatistics
Column Name |
Data Type |
Constraint |
ID |
INT |
NOT NULL |
ClinicCheckOutID |
INT |
NOT NULL |
TableName |
VARCHAR(100) |
NULL |
TotalChanges |
INT |
NULL |
ChangesApplied |
INT |
NULL |
ChangesFailed |
INT |
NULL |
Deletes |
INT |
NULL |
Inserts |
INT |
NULL |
Updates |
INT |
NULL |
CreatedDate |
DATETIME |
NOT NULL |
CreatedByAppUserID |
UNIQUEIDENTIFIER |
NOT NULL |
ModifyDtTm |
DATETIME |
NULL |
LastModifiedByAppUserID |
UNIQUEIDENTIFIER |
NULL |
RejectedChanges |
INT |
NULL |
Added a new table: SynchronizationConflicts
Column Name |
Data Type |
Constraint |
ID |
INT |
NOT NULL |
AgencyID |
VARCHAR(3) |
NOT NULL |
ServiceSiteID |
VARCHAR(3) |
NOT NULL |
IsOnline |
BIT |
NOT NULL |
IsActive |
BIT |
NOT NULL |
IsDownloadable |
BIT |
NOT NULL |
CreateUserID |
VARCHAR(40) |
NULL |
CreateDtTm |
DATETIME |
NULL |
ModifyUserID |
VARCHAR(40) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added a new table: SynchronizationStatistics
Column Name |
Data Type |
Constraint |
ID |
INT |
NOT NULL |
CheckOutID |
INT |
NOT NULL |
TableName |
VARCHAR(100) |
NULL |
TotalChanges |
INT |
NULL |
ChangesApplied |
INT |
NULL |
ChangesFailed |
INT |
NULL |
Deletes |
INT |
NULL |
Inserts |
INT |
NULL |
Updates |
INT |
NULL |
CreatedDate |
DATETIME |
NOT NULL |
CreatedByAppUserID |
UNIQUEIDENTIFIER |
NOT NULL |
ModifyDtTm |
DATETIME |
NULL |
LastModifiedByAppUserID |
UNIQUEIDENTIFIER |
NULL |
RejectedChanges |
INT |
NULL |
Added a new table: TableSynchronizationTimeStamp
Column Name |
Data Type |
Constraint |
TimeStampName |
INT |
NOT NULL |
SynchronizationTimestamp |
BIGINT |
NOT NULL |
Added the following columns to the EventType table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the DCNChanges table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTBatchTransactionLog table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTBatchTransactionLogHistory table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTCardSignature table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTCommunication table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTProxyData table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTTransactionLog table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the EBTWICActivity table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the FoodInstrumentItemRedeemed_Aggregated table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the Head table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the HouseholdChangeEBT table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the HouseholdHistory table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the NationalFoodCatSubCat table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the NationalUPC table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the QueuedParticipant table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the QueuedUser table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the RejectedUpdate table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the SeqNumbers table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the SyncTables table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the TimeSlice table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
Added the following columns to the FoodPackageComplianceBuy table:
Column Name |
Data Type |
Constraint |
ModifyUserID |
VARCHAR(20) |
NULL |
ModifyDtTm |
DATETIME |
NULL |
The following row was added to the StateBusinessRules table:
Column Name |
Row Value |
CategoryID |
UseLocalACMServer |
Value |
N |
Description |
This state uses Local ACM Servers |
The following row was added to the StateBusinessRules table:
Column Name |
Row Value |
CategoryID |
NumberOfWebRetries |
Value |
6 |
Description |
The number of times SPIRIT will try to reconnect to the Web sever on the State Central Server |
The following row was added to the StateBusinessRules table:
Column Name |
Row Value |
CategoryID |
TimeBetweenWebRetries |
Value |
5 |
Description |
The number of seconds between connection retries by SPIRIT to the Web sever on the State Central Server |
Added the following stored procedure(s):
Stored Procedure |
GetOfflineClinics |
Added the following view(s):
View |
v_CertContact |
Added the following user defined function(s):
User Defined Function |
ClinicIsOffline |
Modified the following stored procedure(s):
Stored Procedure |
uspCertificationHistory_Select |
Modified the following view(s):
View |
V_MEMBERINFOS |
See SUG-708.
See SUG-708.
See SUG-708.
See SUG-708.
Added the following view(s):
View |
V_FOODINSTRUMENT |
Modified the following view(s):
View |
V_ORDER_INVENTORY_STATUS |
See SUG-708.
Modified the following view(s):
View |
V_INVENTORYLOCATION_CLINIC |
V_MULTIUSE_BREASTPUMP_DETAIL_LIST |
Modified the following view(s):
View |
V_PARTICIPANTSUMMARY_RISKFACTORS |
See SUG-708.
Added the following columns to the MEMBER table:
Column Name |
Data Type |
Constraint |
PENDINGPROOFBENEFITISSUED |
CHAR(1) |
DEFAULT("N") |
Modified the following view(s):
View |
V_TRAINING_ROSTER |
V_TRAINING_ROSTER_FOR_SS |
See TOF-67.
Modified the following stored procedure(s):
Stored Procedure |
sp_Vendor_GetRiskFactors |
Added the following view(s):
View |
[dbo].[v_EventFollowupKeys] |
See SUG-1938.
The following row was added to the VIOLATIONTYPE table:
Column Name |
Row Value |
CATEGORY |
VIOLATIONTYPE |
VIOLATIONTYPEID |
V |
DESCRIPTION |
V. State (Non-federal) Sanction |
SANCTIONPOINTS |
0 |
SORTVALUE |
69 |
CREATEUSERID |
VRP-126 |
CREATEDTTM |
GETDATE() |
SYSTEMDEFINED |
Y |
ACTIVE |
Y |
Modified the following stored procedure(s):
Stored Procedure |
uspTIPReportData |