2.18 Database Changes

Contents ShowHide

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

ENH-12

Added the following stored procedure(s):

Stored Procedure

dbo.GetParticipantChartAudit

Added the following view(s):

View

V_CertContactWithEndDate

ENH-105

Added the following stored procedure(s):

Stored Procedure

dbo.uspReportGetMedicalPrescriptions

dbo.uspReportGetMedicalPrescriptionsRxExpiration

Deleted the following view(s):

View

V_SPECIAL_FORMULA

V_SPEICALFORMULARXEXPIRATIONLISTITEMS

ENH-108

Added the following stored procedure(s):

Stored Procedure

dbo.uspReportGetClassEnrollmentData

Added the following view(s):

View

V_CLASS_ENROLLMENTS_REPORT

ENH-195

Added the following stored procedure(s):

Stored Procedure

dbo.GetEbtIssuance

ENH-196

Added the following stored procedure(s):

Stored Procedure

dbo.GetSupplierRebate

ENH-207

The following row was added to the RefDictionaryCategory table:

Column Name	Row Value
Category	EBTCardStatus
Description	EBT Card Status
StateDefined	Y
ValueType	null
ValueLength	null
CreateUserID	ENH-207
CreateDtTm	getdate()
ModifyUserID	ENH-207
ModifyDtTm	getdate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	00
Description	Not Activated
SortValue	1
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	01
Description	Not Activated
SortValue	2
Active	Y
SystemDefined	Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	02
Description	Lost
SortValue	3
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	03
Description	Damaged
SortValue	4
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	04
Description	Stolen
SortValue	5
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	05
Description	Compromised
SortValue	6
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	08
Description	Statused by Authorized Person
SortValue	7
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	09
Description	Statused by System
SortValue	8
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	11
Description	Undeliverable Card
SortValue	9
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	22
Description	Lost (do not issue mail replacement)
SortValue	10
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	33
Description	Damaged (do not issue mail replacement)
SortValue	11
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	44
Description	Stolen (do not issue mail replacement)
SortValue	12
Active	Y
SystemDefined	Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	55
Description	Authorized cardholder statused Alternate card
SortValue	13
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

The following row was added to the ReferenceDictionary table:

Column Name	Row Value
Category	EBTCardStatus
ExternalID	98
Description	Placeholder/No Card Issued
SortValue	14
Active	Y
SystemDefined	Not Activated
UpdateRecord	null
CreateUserID	ENH-207
CreateDtTm	getDate()
ModifyUserID	ENH-207
ModifyDtTm	getDate()

ENH-208

Added the following stored procedure(s):

Stored Procedure

dbo.uspGetFoodInstrVoidReplaceReturn

ENH-274

The following row was added to the Feature table:

Column Name	Row Value
FeatureID	815
Description	Manage UPC MAR Approval
FeatureGroup	8
CreateUserID	2.18.00
CreateDtTm	getDate()
ModifyUserID	2.18.00
ModifyDtTm	getDate()

The following row was added to the Feature table:

Column Name	Row Value
FeatureID	816
Description	Manage UPC MAR Override
FeatureGroup	8
CreateUserID	2.18.00
CreateDtTm	getDate()
ModifyUserID	2.18.00
ModifyDtTm	getDate()

The following row was added to the Feature table:

Column Name	Row Value
FeatureID	817
Description	Manage UPC MAR Calculation Method
FeatureGroup	8
CreateUserID	2.18.00
CreateDtTm	getDate()
ModifyUserID	2.18.00
ModifyDtTm	getDate()

The following row was added to the Feature table:

Column Name	Row Value
FeatureID	818
Description	Manage UPC MAR Initial Values
FeatureGroup	8
CreateUserID	2.18.00
CreateDtTm	getDate()
ModifyUserID	2.18.00
ModifyDtTm	getDate()

ENH-346

Added a new table: CertHistory

Column Name	Data Type	Constraint
CertHistoryID	numeric(10, 0)	PK
CertificationID	numeric(10, 0)	NULL
MidCertificationID	numeric(10, 0)	NULL
CertStepID	varchar(10)	NULL
StepAcknowledged	char(1)	NULL
CreateUserID	varchar(20)	NULL
CreateDTTM	datetime	NULL
ModifyUserID	varchar(20)	NULL
ModifyDTTM	datetime	NULL

Added a new table: CertHistoryConsignment

Column Name	Data Type	Constraint
MachineID	varchar(100)	PK
StartingID	numeric(10,0)	PK
EndingID	numeric(10,0)	NULL
LastUsedID	numeric(10,0)	NULL
CreateUserID	varchar(20)	NULL
CreateDTTM	datetime	NULL
ModifyUserID	varchar(20)	NULL
ModifyDTTM	datetime	NULL

Added a new table: MidCertification

Column Name	Data Type	Constraint
MidCertificationID	numeric(10,0)	PK
CertificationID	numeric(10,0)	NULL
DueDate	datetime	NULL
StartUserID	varchar(20)	NULL
StartDate	datetime	NULL
CompletedUserID	varchar(20)	NULL
CompletedDate	datetime	NULL
CreateUserID	varchar(20)	NULL
CreateDTTM	datetime	NULL
ModifyUserID	varchar(20)	NULL
ModifyDTTM	datetime	NULL

Added a new table: MidCertificationConsignment

Column Name	Data Type	Constraint
MachineID	varchar(100)	PK
StartingID	numeric(10,0)	PK
EndingID	numeric(10,0)	NULL
LastUsedID	numeric(10,0)	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	CertSteps
DESCRIPTION	System defined list of certification/mid-certification steps
STATEDEFINED	N
VALUETYPE	N
VALUELENGTH	3
CREATEUSERID	ENH-346

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	1
DESCRIPTION	Demographics
SORTVALUE	1
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	2
DESCRIPTION	Income Contact
SORTVALUE	2
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	3
DESCRIPTION	Health Info
SORTVALUE	3
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	4
DESCRIPTION	Height, Weight
SORTVALUE	4
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	5
DESCRIPTION	Blood Work
SORTVALUE	5
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	6
DESCRIPTION	Immunization
SORTVALUE	6
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	7
DESCRIPTION	Nutrition Assessment
SORTVALUE	7
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	8
DESCRIPTION	Risk Factors
SORTVALUE	8
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	9
DESCRIPTION	Referrals/Other Programs
SORTVALUE	9
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	10
DESCRIPTION	Nutrition Education
SORTVALUE	10
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	11
DESCRIPTION	Food Prescription
SORTVALUE	11
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	12
DESCRIPTION	SOAP Notes
SORTVALUE	12
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	13
DESCRIPTION	EBT Household Demographics
SORTVALUE	13
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	CertSteps
EXTERNALID	14
DESCRIPTION	CPA Determined Follow-Up
SORTVALUE	14
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346
HIDDEN	N

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	APPLICATIONAREACODE
EXTERNALID	19
DESCRIPTION	Mid-certification Assessment
SORTVALUE	19
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-346

The following row was added to the STATEBUSINESSRULES table:

Column Name	Row Value
CATEGORYID	CreateMCAs
VALUE	Y
DESCRIPTION	Create Mid-certification Assessments

The following row was added to the STATEBUSINESSRULES table:

Column Name	Row Value
CATEGORYID	InfantMCADueInMonths
VALUE	6
DESCRIPTION	Infant MCA due [n] months after cert effective date

The following row was added to the STAFFTASKTYPE table:

Column Name	Row Value
STAFFTASKTYPECD	15
DESCRIPTION	Mid-certification Completed
CREATEUSERID	ENH-346

Added the following stored procedure(s):

Stored Procedure

dbo.uspReportGetMidCertAssessmentData

Added the following view(s):

View

V_MIDCERTIFICATION_ASSESSMENT_REPORT

Modified the following view(s):

View

V_STAFFACTIVITY

V_STAFFACTIVITY_STATEWIDE

Added the following user defined function(s):

User Defined Function

FormatParticipantName

ENH-374

Modified the following stored procedure(s):

Stored Procedure

dbo.EBTBATCHTRANSACTIONLOG_FOR_DELETE

dbo.EBTMAR_FOR_DELETE

dbo.T_UpdateSurvey

dbo.tgr_AgeCategory_iud

dbo.tgr_Agency_iud

dbo.tgr_AGENCYPROGRAM_iud

dbo.tgr_AGENCYPROGRAMLOCATION_iud

dbo.tgr_AGENCYPROGRAMORGANIZATION_iud

dbo.tgr_Anemiacutoff_iud

dbo.tgr_AppointmentResource_iud

dbo.tgr_AppointmentType_iud

dbo.tgr_BaseFoodCategory_iud

dbo.tgr_BFCONTACTTOPIC_iud

dbo.tgr_BFCounselor_iud

dbo.tgr_BusinessDay_iud

dbo.tgr_BusinessHour_iud

dbo.tgr_ClassType_iud

dbo.tgr_CLINICPROGRAM_iud

dbo.tgr_CLINICPROGRAMLOCATION_iud

dbo.tgr_CLINICPROGRAMORGANIZATION_iud

dbo.tgr_ComplaintType_iud

dbo.tgr_CorporateParent_iud

dbo.tgr_County_iud

dbo.tgr_CountyCityByZip_iud

dbo.tgr_DefaultFoodItem_iud

dbo.tgr_DocumentImageType_iud

dbo.tgr_EducationTopic_iud

dbo.tgr_EnglishToSpanish_iud

dbo.tgr_FixedLocation_iud

dbo.tgr_FoodDistributionItem_iud

dbo.tgr_FoodInstrumentType_iud

dbo.tgr_FoodInstrumentTypeWicStatus_iud

dbo.tgr_FoodItem_iud

dbo.tgr_FoodItemFormula_iud

dbo.tgr_FoodPackage_iud

dbo.tgr_FoodPackageItem_iud

dbo.tgr_HealthFacility_iud

dbo.tgr_Holiday_iud

dbo.tgr_HtAge_iud

dbo.tgr_ImmunizationSeries_iud

dbo.tgr_IncomeEligibilityAmount_iud

dbo.tgr_IntrauterineWeight_iud

dbo.tgr_ItemPurchaseSize_iud

dbo.tgr_LegalMunicipality_iud

dbo.tgr_LengthWeightAge_iud

dbo.tgr_LgthAge_iud

dbo.tgr_LocalMunicipality_iud

dbo.tgr_LocalUseCaption_iud

dbo.tgr_LocalUseCode_iud

dbo.tgr_Location_iud

dbo.tgr_MedicalHome_iud

dbo.tgr_OtherOwnershipStructure_iud

dbo.tgr_OtherWicProgram_iud

dbo.tgr_PeerGroup_iud

dbo.tgr_PrematureLengthWeightAge_iud

dbo.tgr_PrenatalWeightGain_iud

dbo.tgr_PRIORITYPERWICSTATUS_iud

dbo.tgr_raceEthnicity_iud

dbo.tgr_ReferenceDictionary_iud

dbo.tgr_RiskfactorReference_iud

dbo.tgr_RISKFACTORTHRESHOLD_iud

dbo.tgr_ServiceSite_iud

dbo.tgr_SmokingAmount_iud

dbo.tgr_StaffTaskType_iud

dbo.tgr_StateBusinessRules_iud

dbo.tgr_StateProfile_iud

dbo.tgr_STATEPROGRAM_iud

dbo.tgr_STATEPROGRAMORGANIZATION_iud

dbo.tgr_StateUseCaption_iud

dbo.tgr_StateUseCode_iud

dbo.tgr_StoreType_iud

dbo.tgr_Vaccine_iud

dbo.tgr_VENAQUESTION_iud

dbo.tgr_VendorDocumentImageType_iud

dbo.tgr_VENDORSTAMP_iud

dbo.tgr_ViolationType_iud

dbo.tgr_WeightLength_iud

dbo.tgr_WHOLgthAge_iud

dbo.tgr_WHOWtAge_iud

dbo.tgr_WHOWtLength_iud

dbo.tgr_WicStatus_iud

dbo.tgr_WtAge_iud

dbo.tgr_WtHeight_iud

dbo.tgr_WtLength_iud

dbo.trg_insert_CERTCONTACT

dbo.trg_insert_CustomFollowupActivities

dbo.trg_insert_EVENT

dbo.trg_insert_EventRelationship

dbo.trg_insert_FOLLOWUPRELATIONSHIP

dbo.trg_update_VendorCertificationStepsCompleted

dbo.trg_VENDOR

dbo.trgAccessLevel_ModifyDtTm

dbo.trgAddress_HistDel

dbo.trgAddress_HistIns

dbo.trgAddress_HistUpd

dbo.trgAddress_UpdateSoundsLike

dbo.trgAddressCrossRef_HistDel

dbo.trgAddressCrossRef_HistIns

dbo.trgAddressCrossRef_HistUpd

dbo.trgAgency_ModifyDtTm

dbo.trgAlert_ModifyDtTm

dbo.trgAnemiaCutoff_ModifyDtTm

dbo.trgAnthropContact_ModifyDtTm

dbo.trgAuthorizedRepresentative_ModifyDtTm

dbo.trgBaseFoodCategory_ModifyDtTm

dbo.trgBFContactTopic_ModifyDtTm

dbo.trgBloodwork_ModifyDtTm

dbo.trgChild_ModifyDtTm

dbo.trgChildBFStopReason_ModifyDtTm

dbo.trgContact_HistDel

dbo.trgContact_HistIns

dbo.trgContact_HistUpd

dbo.trgContactCrossRef_HistDel

dbo.trgContactCrossRef_HistIns

dbo.trgContactCrossRef_HistUpd

dbo.trgCounty_ModifyDtTm

dbo.trgCountyCityByZIP_ModifyDtTm

dbo.trgDatabaseVersion_ModifyDtTm

dbo.trgDCNChanges_ModifyDtTm

dbo.trgDefaultDuration_ModifyDtTm

dbo.trgDIAgeCategory_ModifyDtTm

dbo.trgDocumentImagetype_ModifyDtTm

dbo.trgEBTBatchTransactionLog_ModifyDtTm

dbo.trgEBTBatchTransactionLogHistory_ModifyDtTm

dbo.trgEBTCardSignature_ModifyDtTm

dbo.trgEBTCommunication_ModifyDtTm

dbo.trgEBTProxyData_ModifyDtTm

dbo.trgEBTTransactionLog_ModifyDtTm

dbo.trgEBTWICActivity_ModifyDtTm

dbo.trgEducationContact_ModifyDtTm

dbo.trgEducationContactItem_ModifyDtTm

dbo.trgEducationTopic_ModifyDtTm

dbo.trgFeature_ModifyDtTm

dbo.trgFiscalYear_ModifyDtTm

dbo.trgFoodDistributionItemPriceMultiplier_ModifyDtTm

dbo.trgFoodInstrumentItemRedeemed_Aggregated_ModifyDtTm

dbo.trgFoodPackageComplianceBuy_ModifyDtTm

dbo.trgFormulaPackage_ModifyDtTm

dbo.trgHead_ModifyDtTm

dbo.trgHealthFacility_ModifyDtTm

dbo.trgHousehold_ModifyDtTm

dbo.trgHouseholdChangeEBT_ModifyDtTm

dbo.trgHouseholdHistory_ModifyDtTm

dbo.trgImmunizationSeries_ModifyDtTm

dbo.trgIncomeContact_ModifyDtTm

dbo.trgIncomeEligibilityAmount_ModifyDtTm

dbo.trgIncomeItem_ModifyDtTm

dbo.trgIntrauterineWeight_ModifyDtTm

dbo.trgInvalidBfcCombo_ModifyDtTm

dbo.trgInventoryConTransConsignment_ModifyDtTm

dbo.trgInventoryIssuedConsignment_ModifyDtTm

dbo.trgInventoryIssuedESignConsignment_ModifyDtTm

dbo.trgInventoryNonWICConsignment_ModifyDtTm

dbo.trgLegalMunicipality_ModifyDtTm

dbo.trgLegalMunicipalityEstimated_ModifyDtTm

dbo.trgLengthWeightAge_ModifyDtTm

dbo.trgLengthWeightType_ModifyDtTm

dbo.trgLocalAgencyEligibles_ModifyDtTm

dbo.trgLocalMunicipality_ModifyDtTm

dbo.trgLocalSurveyAnswer_ModifyDtTm

dbo.trgLocation_ModifyDtTm

dbo.trgMedicalHome_ModifyDtTm

dbo.trgNationalFoodCatSubcat_ModifyDtTm

dbo.trgNationalUPC_ModifyDtTm

dbo.trgParticipantFormula_ModifyDtTm

dbo.trgPermission_ModifyDtTm

dbo.trgPostpartumInfant_ModifyDtTm

dbo.trgPostpartumInfantBFStopReason_ModifyDtTm

dbo.trgPregnancy_ModifyDtTm

dbo.trgPrematureLengthWeightAge_ModifyDtTm

dbo.trgPrenatalWeightGain_ModifyDtTm

dbo.trgPrepregWeightHeight_ModifyDtTm

dbo.trgPriorityPerWICStatus_ModifyDtTm

dbo.trgQueuedParticipant_ModifyDtTm

dbo.trgQueuedUser_ModifyDtTm

dbo.trgRaceEthnicity_ModifyDtTm

dbo.trgRefDictionaryCategory_ModifyDtTm

dbo.trgReferenceDictionary_ModifyDtTm

dbo.trgRejectedUpdate_ModifyDtTm

dbo.trgRiskFactor_ModifyDtTm

dbo.trgROLE_ModifyDtTm

dbo.trgRolePermission_ModifyDtTm

dbo.trgSeqNumbers_ModifyDtTm

dbo.trgServiceSite_ModifyDtTm

dbo.trgSmokingAmount_ModifyDtTm

dbo.trgStaffTaskType_ModifyDtTm

dbo.trgStateProfile_ModifyDtTm

dbo.trgStateUseCaption_ModifyDtTm

dbo.trgStateUseCode_ModifyDtTm

dbo.trgSyncTables_ModifyDtTm

dbo.trgTimeSlice_ModifyDtTm

dbo.trgVaccine_ModifyDtTm

dbo.trgWeightLength_ModifyDtTm

dbo.trgWLAgeCategory_ModifyDtTm

dbo.trgWoman_ModifyDtTm

Modified the following user defined function(s):

User Defined Function

TriggersEnabled

ENH-392

Added the following columns to the FOODDISTRIBUTIONITEM table:

Column Name	Data Type	Constraint
AllowDirectShip	Char(1)	DEFAULT 'N'
DSPrice	Numeric(7,2)	NULL

Added the following columns to the FOODINSTRUMENT table:

Column Name	Data Type	Constraint
ShipTo	Char(1)	NULL
ShipToAddress	Varchar(50)	NULL
ShipToCity	Varchar(30)	NULL
ShipToStateCD	Varchar(2)	NULL
ShipToZIPCode	Varchar(10)	NULL

Added the following columns to the EBTPending_FOODINSTRUMENT table:

Column Name	Data Type	Constraint
ShipTo	Char(1)	NULL
ShipToAddress	Varchar(50)	NULL
ShipToCity	Varchar(30)	NULL
ShipToStateCD	Varchar(2)	NULL
ShipToZIPCode	Varchar(10)	NULL

The following row was added to the STATEBUSINESSRULES table:

Column Name	Row Value
CATEGORYID	DirectShipPrintOrder
VALUE	N
DESCRIPTION	Check the Print Order checkbox on the Direct Shipped Benefit Items screen by default

The following row was added to the STATEBUSINESSRULES table:

Column Name	Row Value
CATEGORYID	DirectShipPrintReceipt
VALUE	N
DESCRIPTION	Check the Print Receipt checkbox on the Direct Shipped Benefit Items screen by default

The following row was added to the FEATURE table:

Column Name	Row Value
FEATUREID	814
DESCRIPTION	Manage Direct Shipment Item Redemption
FEATUREGROUP	1
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the FEATURE table:

Column Name	Row Value
FEATUREID	322
DESCRIPTION	Manage Direct Shipment Item Redemption
FEATUREGROUP	8
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFDICTIONARYCATEGORY table:

Column Name	Row Value
CATEGORY	DeliverySystemType
DESCRIPTION	Food Instrument Delivery System Type
STATEDEFINED	N
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	DeliverySystemType
EXTERNALID	C
DESCRIPTION	Check
SORTVALUE	1
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	DeliverySystemType
EXTERNALID	E
DESCRIPTION	EBT
SORTVALUE	2
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	DeliverySystemType
EXTERNALID	S
DESCRIPTION	Direct Shipment
SORTVALUE	3
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	DeliverySystemType
EXTERNALID	D
DESCRIPTION	Direct Distribution
SORTVALUE	4
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	DeliverySystemType
EXTERNALID	V
DESCRIPTION	Voucher
SORTVALUE	5
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()

The following row was added to the REFERENCEDICTIONARY table:

Column Name	Row Value
CATEGORY	BNKEXCPTREASON
EXTERNALID	31
DESCRIPTION	Benefit is a Direct Ship Benefit.
SORTVALUE	31
ACTIVE	Y
SYSTEMDEFINED	Y
CREATEUSERID	ENH-392
CREATEDTTM	GETDATE()
MODIFYUSERID	ENH-392
MODIFYDTTM	GETDATE()
HIDDEN	N

Added the following stored procedure(s):

Stored Procedure

uspEBTGetRemainingBenefitsData

uspEBTGetRemainingBenefitsData_DirectShip

uspEBTGetIssuanceData

uspEBTGetVoidData

uspSetFoodInstrumentAsPaid

uspDirectShipmentGetOrderNotifications

Added the following view(s):

View

v_DirectShippedItems

V_DIRECTSHIPMENT_ORDER_NOTIFICATIONS

Modified the following view(s):

View

V_CHECK_HISTORY_HEADER

Regression

Added the following columns to the Member table:

Column Name	Data Type	Constraint
FosterParents	char(1)	default to N

Removed the following columns from the CHILD table:

Column Name

FOSTERPARENTS