2.25.00 Database Changes

ENH-504

The following values were added to the JPMTRANSACTIONERRORCODES table (TRANSACTIONTYPE, ERRORCODE, DESCRIPTION):

('0000', '0101', 'Invalid/Missing WIC State Agency ID.'),

('0000', '0102', 'Invalid/Missing WIC MIS System ID.'),

('0000', '0103', 'Invalid/Missing Password.'),

('0000', '0104', 'Invalid/Missing Message Type.'),

('0000', '0105', 'Invalid/Missing EBT System ID.'),

('0000', '0106', 'Invalid/Missing Message Version.'),

('0000', '0107', 'Invalid/Missing Message Date and Time.'),

('0000', '0108', 'Provided WIC Clinic ID was Invalid.'),

('0000', '0109', 'Invalid/Missing Username.'),

('0000', '0110', 'Provided Workstation ID was Invalid.'),

('0000', '0111', 'System Locked Out.'),

('0000', '0112', 'Invalid/Missing File Sequence Number.'),

('0000', '0113', 'Provided File Sequence Number is transmitted out of order.'),

('0000', '0114', 'Invalid/Missing Record Count.'),

('0000', '0115', 'Invalid/Missing Rejected Count.'),

('0000', '0116', 'Invalid/Missing Original Row Count.'),

('0000', '0117', 'Invalid/Missing Function Return Code.'),

('0000', '0118', 'Duplicate File Has Already Been Processed.'),

('0000', '0119', 'Invalid/Missing Initiating User ID.'),

('0000', '0120', 'Invalid/Missing Local Agency ID.'),

('0000', '0121', 'Invalid/Missing Unique Transaction ID.'),

('0000', '0122', 'Invalid/Missing Action Code.'),

('0000', '0197', 'Missing Security Authorization Object.'),

('0000', '0198', 'Batch File corruption or other general processing error.'),

('0000', '0199', 'Database communication error.') ,

('0000', '9999', 'Unknown (internal) error.'),

('0000', '1001', 'Missing Household Function Parameter Object.'),

('0000', '1002', 'Missing Head of Household Person Object.'),

('0000', '1003', 'Household ID already exists.'),

('0000', '1004', 'Household ID is not known to the EBT System.'),

('0000', '1005', 'Invalid/Missing Household Status ID.'),

('0000', '1006', 'Invalid/Missing Household Type ID.'),

('0000', '1007', 'Provided Email Address was Invalid.'),

('0000', '1008', 'Invalid/Missing Cardholder Relationship.'),

('0000', '1009', 'Invalid/Missing Cardholder Gender.'),

('0000', '1010', 'Invalid/Missing Cardholder Language Code.'),

('0000', '1011', 'Invalid/Missing Cardholder Phone Number.'),

('0000', '1012', 'Account Does Not Have a Primary Cardholder.'),

('0000', '1013', 'Account Id and Account Type do not match.'),

('0000', '1015', 'Invalid/Missing Cardholder Mailing Address Line 1.'),

('0000', '1016', 'Invalid/Missing Cardholder Mailing Address Line 2.'),

('0000', '1017', 'Invalid/Missing Cardholder Mailing Address City.'),

('0000', '1018', 'Invalid/Missing Cardholder Mailing Address State.'),

('0000', '1019', 'Invalid/Missing Cardholder Mailing Address Zip Code.'),

('0000', '1020', 'Invalid/Missing Household ID Number.'),

('0000', '1021', 'Provided Household ID is Invalid.'),

('0000', '1022', 'Invalid/Missing Reason Code.'),

('0000', '1024', 'Invalid/Missing Head of Household Last Name.'),

('0000', '1025', 'Provided Household Mailing Address had a Invalid/Missing Street Address Line 1.'),

('0000', '1026', 'Provided Household Mailing Address had a Invalid/Missing City.'),

('0000', '1027', 'Provided Household Mailing Address had a Invalid/Missing State Abbreviation.'),

('0000', '1028', 'Provided Household Mailing Address had a Invalid/Missing Zip Code.'),

('0000', '1029', 'Household Mailing Address is Missing.'),

('0000', '1030', 'Invalid/Missing Head of Household Date of Birth.'),

('0000', '1031', 'Invalid/Missing Head of Household Gender.'),

('0000', '1032', 'Invalid/Missing Head of Household Language Code.'),

('0000', '1033', 'Head of Household Name is Missing.'),

('0000', '1034', 'Provided Head of Household Person Object’s Suffix was Invalid.'),

('0000', '1045', 'Provided Household Mailing Address had a Invalid/Missing Street Address Line 2.'),

('0000', '1046', 'Invalid/Missing Head of Household First Name.'),

('0000', '1047', 'Invalid/Missing Head of Household Middle Name.'),

('0000', '1059', 'EBT Card Number has already been issued.'),

('0000', '1060', 'Replacement EBT Card Number has already been issued.'),

('0000', '1061', 'Not Enough Filtering Parameters Were Provided.'),

('0000', '1301', 'Invalid/Missing EBT Card Number.'),

('0000', '1302', 'Invalid/Missing Cardholder Type ID.'),

('0000', '1303', 'Missing Cardholder Person Function Parameter Object.'),

('0000', '1304', 'Primary Cardholder already exists for the Household.'),

('0000', '1305', 'Number of active Cardholders is exceeded by this new Cardholder.'),

('0000', '1306', 'Invalid/Missing Cardholder Last Name.'),

('0000', '1307', 'Invalid/Missing Cardholder Date of Birth.'),

('0000', '1308', 'Provided Cardholder Person Object’s First Name was Invalid.'),

('0000', '1309', 'Provided Cardholder Person Object’s Middle Name was Invalid.'),

('0000', '1310', 'Provided Cardholder Person Object’s Email Address was Invalid.'),

('0000', '1311', 'Cardholder name is a duplicate for the Household.'),

('0000', '1312', 'Invalid/Missing Cardholder Id Provided.'),

('0000', '1313', 'Provided Cardholder Person Object’s Suffix was Invalid.'),

('0000', '1314', 'PIN number for cardholder/number is not locked.'),

('0000', '1315', 'No search results found for the entered filter criteria.'),

('0000', '1316', 'Invalid/Missing Replacement Card Number.'),

('0000', '1401', 'EBT Card Number is not known to the EBT System.'),

('0000', '1402', 'Invalid/Missing Card Status Date.'),

('0000', '1403', 'Invalid/Missing Card Status ID.'),

('0000', '1404', 'Invalid/Missing Card Status Reason ID.'),

('0000', '1405', 'Invalid Card Status/Reason Code combination.'),

('0000', '1601', 'Invalid/Missing Encrypted PIN Block.'),

('0000', '1602', 'EBT Card number provided doesn’t match with the MIS Household ID.'),

('0000', '1603', 'Invalid/Missing Effective Date.'),

('0000', '1604', 'Dual PIN Blocks do not match.'),

('0000', '1605', 'Provided Card Number Not Primary Card on Account.'),

('0000', '1606', 'Account Does Not Have an Active Primary Cardholder.'),

('0000', '2001', 'Missing Monthly Food Benefit Function Parameter Object.'),

('0000', '2002', 'EBA is not active.'),

('0000', '2004', 'Unique Benefit ID already exists thus indicating a Duplicate Benefit Adjustment.'),

('0000', '2006', 'Benefit timeframe provided doesn’t match to a Category/Sub-Category balance with sufficient quantity to post the entire debit.'),

('0000', '2007', 'Invalid/Missing Credit/Debit ID.'),

('0000', '2008', 'Invalid/Missing Benefit Start Date.'),

('0000', '2009', 'Invalid/Missing Benefit End Date.'),

('0000', '2011', 'Provided EBT Card Number is Invalid.'),

('0000', '2013', 'Invalid/Missing Category Code.'),

('0000', '2014', 'Invalid/Missing Sub-category Code.'),

('0000', '2015', 'Invalid/Missing Benefit Quantity.'),

('0000', '2017', 'Resulting Food Benefit Quantity exceeds 999.99.'),

('0000', '2019', 'Benefit End Date cannot precede the Benefit Start Date.'),

('0000', '2021', 'Invalid/Missing Benefit Reason ID.'),

('0000', '2022', 'Invalid/Missing Unique Benefit ID.'),

('0000', '2044', 'Invalid/Missing Clinic ID.'),

('0000', '2046', 'Category/Sub-category combination is not active.'),

('0000', '2050', 'Benefit timeframe provided would overlap an existing benefit timeframe containing valid benefits for the Family, which is not allowed.'),

('0000', '3202', 'Provided Search Start Date is Invalid.'),

('0000', '3203', 'Provided Search End Date is Invalid.'),

('0000', '3204', 'Search End Date cannot be before Search Start Date.'),

('0000', '3205', 'Invalid/Missing Maximum Requested Count.'),

('0000', '3206', 'Neither the Household ID nor the EBT Card Number was provided.'),

('0000', '3207', 'Date Range must be less than the value in the system setting.'),

('0000', '3601', 'Provided Card Status ID was Invalid.'),

('0000', '3602', 'Provided Cardholder Person Object’s Last Name was Invalid.'),

('0000', '3603', 'Provided Cardholder Person Object’s Date of Birth was Invalid.'),

('0000', '3604', 'Provided Cardholder has been Deactivated and Access Restricted.'),

('0000', '3701', 'Supplied PIN was not correctly verified.'),

('0000', '4001', 'Missing Vendor Function Parameter Object.'),

('0000', '4036', 'Vendor ID was not known to the EBT System.'),

('0000', '4037', 'Vendor ID already exists.'),

('0000', '4038', 'Invalid/Missing Vendor ID.'),

('0000', '4039', 'Invalid/Missing Vendor Name.'),

('0000', '4040', 'Invalid/Missing Peer Group ID.'),

('0000', '4042', 'Invalid/Missing Vendor Status ID.'),

('0000', '4045', 'Invalid/Missing Above 50% Vendor Code.'),

('0000', '4046', 'Invalid/Missing Vendor Type ID.'),

('0000', '4047', 'Invalid/Missing Federal Tax ID.'),

('0000', '4048', 'Invalid/Missing Direct Connect Flag.'),

('0000', '4049', 'Invalid/Missing Direct Connect ARF flag.'),

('0000', '4051', 'Missing Vendor Physical Address Object.'),

('0000', '4052', 'Missing Vendor Mailing Address Object.'),

('0000', '4055', 'Invalid/Missing Vendor Physical Address’ Line 1.'),

('0000', '4056', 'Invalid/Missing Vendor Physical Address’ City.'),

('0000', '4057', 'Invalid/Missing Vendor Physical Address’ State Abbreviation.'),

('0000', '4058', 'Missing Vendor Contact Person Object.'),

('0000', '4059', 'Invalid/Missing Vendor Mailing Address’ Line 1.'),

('0000', '4060', 'Invalid/Missing Vendor Mailing Address’ City.'),

('0000', '4061', 'Invalid/Missing Vendor Mailing Address’ State Abbreviation.'),

('0000', '4062', 'Invalid/Missing Vendor Primary Phone Number.'),

('0000', '4063', 'Provided Vendor Secondary Phone Number was Invalid.'),

('0000', '4066', 'Provided Corporation ID was Invalid.'),

('0000', '4067', 'Provided Vendor Physical Address’ Line 2 was Invalid.'),

('0000', '4068', 'Provided Vendor Mailing Address’ Line 2 was Invalid.'),

('0000', '4070', 'Invalid/Missing Vendor Authorization Start Date.'),

('0000', '4071', 'Invalid/Missing Vendor Authorization End Date.'),

('0000', '4073', 'Invalid/Missing Vendor Physical Address’ Zip Code.'),

('0000', '4074', 'Invalid/Missing Vendor Mailing Address’ Zip Code.'),

('0000', '4075', 'Authorization End Date cannot be before the Authorization Start Date.'),

('0000', '4080', 'Missing Vendor Banking Information Object.'),

('0000', '4081', 'Invalid/Missing Vendor Banking Information’s Bank Name.'),

('0000', '4082', 'Invalid/Missing Vendor Banking Information’s ABA Routing Transit Number.'),

('0000', '4083', 'Invalid/Missing Vendor Banking Information’s Bank Account Number.'),

('0000', '4084', 'Invalid/Missing Banking Account Type ID.'),

('0000', '4090', 'Invalid/Missing Vendor Contact Person’s First Name.'),

('0000', '4091', 'Invalid/Missing Vendor Contact Person’s Last Name.'),

('0000', '4092', 'Provided Vendor Contact Person’s Middle Name was Invalid.'),

('0000', '4093', 'Provided Vendor Contact Person’s Email Address was Invalid.'),

('0000', '4094', 'Provided Vendor Contact Person’s Date of Birth was Invalid.'),

('0000', '4095', 'Provided Vendor Contact Person Object’s Suffix was Invalid.'),

('0000', '4096', 'Invalid/Missing Vendor Reason Code.'),

('0000', '4097', 'Invalid/Missing ACH Settlement Time.'),

('0000', '4098', 'Invalid/Missing FNS Number.'),

('0000', '4099', 'Invalid/Missing Total Food Sales Amount.'),

('0000', '5001', 'Missing Local Agency Function Parameter Object.'),

('0000', '5002', 'Local Agency ID already exists.'),

('0000', '5003', 'Local Agency ID is unknown to the EBT System.'),

('0000', '5004', 'Invalid/Missing Local Agency ID.'),

('0000', '5005', 'Invalid/Missing Local Agency Name.'),

('0000', '5006', 'Missing Local Agency Contact Person Object.'),

('0000', '5007', 'Invalid/Missing Local Agency Contact Person’s First Name.'),

('0000', '5008', 'Invalid/Missing Local Agency Contact Person’s Last Name.'),

('0000', '5009', 'Provided Local Agency Contact Person’s Middle Name was Invalid.'),

('0000', '5010', 'Provided Local Agency Contact Person’s Email Address was Invalid.'),

('0000', '5011', 'Provided Local Agency Contact Person’s Date of Birth was Invalid.'),

('0000', '5012', 'Missing Local Agency Mailing Address Object.'),

('0000', '5013', 'Invalid/Missing Local Agency Mailing Address’ Line 1.'),

('0000', '5014', 'Provided Local Agency Mailing Address’ Line 2 was Invalid.'),

('0000', '5015', 'Invalid/Missing Local Agency Mailing Address’ City.'),

('0000', '5016', 'Invalid/Missing Local Agency Mailing Address’ State Abbreviation.'),

('0000', '5017', 'Invalid/Missing Local Agency Mailing Address’ Zip Code.'),

('0000', '5018', 'Invalid/Missing Local Agency Primary Phone Number.'),

('0000', '6001', 'Missing Clinic Function Parameter Object.'),

('0000', '6002', 'Clinic ID already exists.'),

('0000', '6003', 'Clinic ID is unknown to the EBT System.'),

('0000', '6005', 'Invalid/Missing Clinic Name.'),

('0000', '6006', 'Missing Clinic Contact Person Object.'),

('0000', '6007', 'Invalid/Missing Clinic Contact Person’s First Name.'),

('0000', '6008', 'Invalid/Missing Clinic Contact Person’s Last Name.'),

('0000', '6009', 'Provided Clinic Contact Person’s Middle Name was Invalid.'),

('0000', '6010', 'Provided Clinic Contact Person’s Email Address was Invalid.'),

('0000', '6011', 'Provided Clinic Contact Person’s Date of Birth was Invalid.'),

('0000', '6012', 'Missing Clinic Mailing Address Object.'),

('0000', '6013', 'Invalid/Missing Clinic Mailing Address’ Line 1.'),

('0000', '6014', 'Provided Clinic Mailing Address’ Line 2 was Invalid.'),

('0000', '6015', 'Invalid/Missing Clinic Mailing Address’ City.'),

('0000', '6016', 'Invalid/Missing Clinic Mailing Address’ State Abbreviation.'),

('0000', '6017', 'Invalid/Missing Clinic Mailing Address’ Zip Code.'),

('0000', '6018', 'Invalid/Missing Clinic Phone Number.'),

('0000', '7001', 'Invalid/Missing Corporation ID.'),

('0000', '7002', 'Invalid/Missing Corporation Name.'),

('0000', '7003', 'Invalid/Missing Corporation Contact Person’s First Name.'),

('0000', '7004', 'Invalid/Missing Corporation Contact Person’s Last Name.'),

('0000', '7005', 'Provided Corporation Contact Person’s Middle Name was Invalid.'),

('0000', '7006', 'Provided Corporation Contact Person’s Email Address was Invalid.'),

('0000', '7007', 'Provided Corporation Contact Person’s Date of Birth was Invalid.'),

('0000', '7008', 'Invalid/Missing Corporation Mailing Address’ Line 1.'),

('0000', '7009', 'Provided Corporation Mailing Address’ Line 2 was Invalid.'),

('0000', '7010', 'Invalid/Missing Corporation Mailing Address’ City.'),

('0000', '7011', 'Invalid/Missing Corporation Mailing Address’ State Abbreviation.'),

('0000', '7012', 'Invalid/Missing Corporation Mailing Address’ Zip Code.'),

('0000', '7013', 'Invalid/Missing Corporation Primary Phone Number.'),

('0000', '7014', 'Provided Corporation Secondary Phone Number was Invalid.'),

('0000', '7015', 'Invalid/Missing Corporation Banking Information’s Bank Name.'),

('0000', '7016', 'Invalid/Missing Corporation Banking Information’s ABA Routing Transit Number.'),

('0000', '7017', 'Invalid/Missing Corporation Banking Information’s Bank Account Number.'),

('0000', '7101', 'Invalid/Missing Vendor Operational Activation Code.'),

('0000', '7102', 'Invalid/Missing Vendor Operational Activation Effective Start Date.'),

('0000', '7201', 'Invalid or Missing processing month.'),

('0000', '7202', 'Invalid or Missing Recoupment Type Code.'),

('0000', '7203', 'Invalid or Missing Recoupment Amount.'),

('0000', '7204', 'Invalid or Missing Record Sequence Number.'),

('0000', '7205', 'Additional Recoupment Amount Would Exceed Maximum For Merchant.'),

('0000', '7206', 'Provided Vendor Type Not Permitted.'),

('0000', '7207', 'Insufficient Benefits for Authorization.'),

('0000', '7208', 'Authorization quantity must be whole number for given product code.'),

('0000', '7209', 'No Matching Benefit Authorization Found.'),

('0000', '8001', 'Invalid/Missing Category Description.'),

('0000', '8002', 'Invalid/Missing Subcategory Description.'),

('0000', '8003', 'Invalid/Missing Unit of Measure Description.'),

('0000', '8004', 'Invalid/Missing Activation Date.'),

('0000', '8005', 'Provided Deactivation Date is Invalid.'),

('0000', '8006', 'Invalid/Missing Category Begin Date.'),

('0000', '8007', 'Invalid/Missing Category End Date.'),

('0000', '8008', 'Invalid/Missing Subcategory Begin Date.'),

('0000', '8009', 'Invalid/Missing Subcategory End Date.'),

('0000', '8010', 'A Subcategory Code Which Was Omitted From the File Has Active Benefits in System.'),

('0000', '8011', 'Invalid/Missing Vendor Effective Date.'),

('0000', '8012', 'Invalid/Missing Original EBT Transaction ID.'),

('0000', '8013', 'Invalid/Missing POS data code card data input capability.'),

('0000', '8014', 'Invalid/Missing POS data code cardholder authentication capability.'),

('0000', '8015', 'Invalid/Missing POS data code, card capture capability.'),

('0000', '8016', 'Invalid/Missing POS data code, operating environment.'),

('0000', '8017', 'Invalid/Missing POS data code, cardholder present.'),

('0000', '8018', 'Invalid/Missing POS data code, card present.'),

('0000', '8019', 'Invalid/Missing POS data code, card data input mode.'),

('0000', '8020', 'Invalid/Missing POS data code, cardholder authentication method.'),

('0000', '8021', 'Invalid/Missing POS data code, cardholder authentication entity.'),

('0000', '8022', 'Invalid/Missing POS data code, card data output capability.'),

('0000', '8023', 'Invalid/Missing POS data code, terminal output capability.'),

('0000', '8024', 'Invalid/Missing POS data code, PIN capture capability.'),

('0000', '8025', 'Invalid/Missing NTE Adjustment Amount.'),

('0000', '8026', 'Invalid/Missing Approved Item Amount.'),

('0000', '8027', 'Invalid/Missing Original Line Number.'),

('0000', '8028', 'Invalid/Missing Status Code.'),

('0000', '8101', 'Invalid/Missing UPC or PLU Code.'),

('0000', '8102', 'Invalid/Missing UPC or PLU Description.'),

('0000', '8103', 'Invalid/Missing Broadband Flag.'),

('0000', '8104', 'Invalid/Missing Package Size.'),

('0000', '8106', 'Invalid/Missing Exchange Size.'),

('0000', '8107', 'Invalid/Missing Rebate Flag.'),

('0000', '8108', 'Invalid/Missing UPC or PLU Effective Start Date.'),

('0000', '8109', 'Invalid/Missing UPC or PLU Deactivation Start Date.'),

('0000', '8110', 'Invalid/Missing NTE Price.'),

('0000', '8111', 'Invalid/Missing Manual Authorization Flag.'),

('0000', '8112', 'Invalid/Missing Is PLU Flag.'),

('0000', '8113', 'Invalid/Missing Purchase Indicator.'),

('0000', '8114', 'Invalid/Missing UPC or PLU Code Length.'),

('0000', '8115', 'Invalid/Missing Number of WIC Vendor Peer Groups.'),

('0000', '8116', 'Invalid/Missing Price Type.'),

('0000', '8117', 'Invalid/Missing Peer Group NTE Price Object.'),

('0000', '8801', 'Invalid/Missing EBT’s Transaction ID.'),

('0000', '8802', 'Invalid/Missing Redemption Transaction Type ID.'),

('0000', '8803', 'Invalid/Missing EBT’s Transaction Date and Time.'),

('0000', '8804', 'Invalid/Missing Vendor’s Transaction Date and Time.'),

('0000', '8805', 'Invalid/Missing Settlement Date.'),

('0000', '8806', 'Invalid/Missing Business Date.'),

('0000', '8807', 'Invalid/Missing Forwarding Institution ID.'),

('0000', '8808', 'Invalid/Missing Receiving Institution ID.'),

('0000', '8809', 'Invalid/Missing Acquiring Institution ID.'),

('0000', '8810', 'Invalid/Missing Terminal ID.'),

('0000', '8811', 'Invalid/Missing Requested Amount.'),

('0000', '8812', 'Invalid/Missing Settled Amount.'),

('0000', '8813', 'Invalid/Missing Total NTE Adjustments.'),

('0000', '8814', 'Invalid/Missing Discount Amount.'),

('0000', '8815', 'Invalid/Missing Requested Purchase Detail Amount.'),

('0000', '8816', 'Invalid/Missing UPC Category Code.'),

('0000', '8817', 'Invalid/Missing UPC Subcategory Code.'),

('0000', '8818', 'Invalid/Missing Requested Quantity.'),

('0000', '8819', 'Invalid/Missing Paid Amount.'),

('0000', '8820', 'Invalid/Missing Benefit Category Code.'),

('0000', '8821', 'Invalid/Missing Benefit Subcategory Code.'),

('0000', '8822', 'Invalid/Missing Approved Quantity.'),

('0000', '8823', 'Invalid/Missing Record Sequence Number.'),

('0000', '8901', 'Invalid/Missing Payment Trace Number.'),

('0000', '8902', 'Invalid/Missing Payor Vendor ID.'),

('0000', '8903', 'Provided Vendor ID is unknown to the EBT System.'),

('0000', '8904', 'Invalid/Missing Payment Amount.'),

('0000', '8905', 'Provided Descriptive Purpose is Invalid.'),

('0000', '8906', 'Provided System Trace Audit Number is Invalid.'),

('0000', '8907', 'Provided System Trace Audit Number is unknown to the EBT System.'),

('0000', '8908', 'Invalid/Missing Payment Effective Date.'),

('0000', '8909', 'Invalid/Missing Category Short Description.'),

('0000', '8910', 'Invalid/Missing Subcategory Short Description.'),

('0000', '8911', 'Invalid/Missing Payor Name.'),

('0000', '8912', 'Invalid/Missing Payment Effective Date.')

ENH-506

Created a new EBTUPCAPLTYPE table for UPC APL types, which includes the following columns:

Added the following column to the VENDOR table:

Added the following row to the REFERENCEDICTIONARYCATEGORY table:

Added the following rows to the REFERENCEDICTIONARY table:

ENH-517

Converted the following convert in-line SQL methods into stored procedures:

• Core ParticipantManager.vb DeleteIncompleteCert

• Core ParticipantManager.vb GetHighRiskParticipants

• Core ParticipantManager.vb SaveIncomeContact

• Core ParticipantManager.vb CreateChildOrWoman

• Core ParticipantManager.vb GetCertEffectiveDateForPsuedoCert

• Core ParticipantManager.vb GetOriginalScreenDate

• Core ParticipantManager.vb SaveIncomeContactForMember

• Core ParticipantManager.vb UpdateApplicant

• Core ParticipantManager.vb DoesPregnantOrInfantHasMedicaid

• Core ParticipantManager.vb GetFoodInstrumentItemDetails

• Core ParticipantManager.vb GetIneligibleMembers

• Core ParticipantManager.vb GetMaximumPriorityCode

• Core ParticipantManager.vb GetMotherOfChild

• Core ParticipantManager.vb GetPostpartum

• Core ParticipantManager.vb GetPostpartumId

• Core ParticipantManager.vb SaveParticipant

• Core ParticipantManager.vb IsMotherOfInfantReceivingMoreThanMaximumAmountOfFormula

• Core ParticipantManager.vb AssignRiskFactors

• Core ParticipantManager.vb GetBloodWorkListItems

• Core ParticipantManager.vb GetHeightWeightListItems

• Core ParticipantManager.vb GetLowestUnservedPriority

• Core ParticipantManager.vb GetMoreParticipantInfo

• Core ParticipantManager.vb SaveMembers

• Core ParticipantManager.vb SavePostPartumInfant

• Core ParticipantManager.vb SaveRiskFactorThreshold

• Core ParticipantManager.vb XferParticipant

• Core ParticipantManager.vb GetPrtFoodPackageListItems

• Core ParticipantManager.vb HouseholdHasAnActiveCertification

• Core ParticipantManager.vb SaveResidencyProofforHousehold

• Core ParticipantManager.vb EditProgram

• Core Household.vb Insert

• Core Household.vb Update

• Core Member.vb Insert

SWM-002

The following row was added to the STATEBUSINESSRULES table:

SWM-4

The following fields were converted to varchar in the GetEbtIssuance procedure:

• FIRSTUSEDATE

• LASTUSEDATE

• PRINTEDFDTU

SWM-17

The following stored procedures were updated:

• uspUpdateStepInCertHistory

• GetNextCertHistoryID