INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(80, 71932120, 44829497, '39698290', '10000038837', '', '', '14133640', 'Donald', 'Graves', 'English', '', '{\"DOB\": 17936, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Successful fax\", \"Aligned\": \"\", \"PCP_NPI\": \"1447328125\", \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"SEAN CAREY\", \"Rank_All\": 1, \"PCP_Phone\": \"2078392559\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8C59KH6DQ36\", \"Member_City\": \"Gray\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gray\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-02-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"575 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075231135\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"379 SHAKER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 798\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Graves\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@092523.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2076572403\", \"Member_Identification_Number\": \"10000038837\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073292722\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:39\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-16T20:46\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-18T20:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-18T23:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-16T09:43\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T20:46\", \"reportStatus_date\": \"2026-02-16T20:46\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-18T23:09\", \"reportStatus_date\": \"2026-02-18T23:09\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-16T09:43\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T10:06\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-16T20:46\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-16T20:46\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-18T16:15\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-18T23:09\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-18T20:54\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-18T23:09\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-17T18:01\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"08:27:42\", \"value\": [{\"add\": \"379 SHAKER RD\", \"age\": 77, \"ano\": \"\", \"cno\": \"2073292722\", \"dob\": \"1949-02-07\", \"eno\": \"2073195665\", \"lob\": \"GA - 2026\", \"pno\": \"2076572403\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Gray\", \"gend\": 0, \"insh\": \"10000038837\", \"mzip\": \"04039\", \"name\": \"Donald E Graves\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SEAN CAREY\", \"ppno\": \"2078392559\", \"cliId\": \"\", \"email\": \"declined@092523.com\", \"ename\": \"Scott Wood\", \"madd1\": \"PO BOX 798\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gray\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"575 Main St\", \"pcpnpi\": \"1447328125\", \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075231135\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8C59KH6DQ36\", \"currentgend\": \"Male\", \"pphycomment\": \"David Ducharme -mVA physician\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-12-2026\", \"time\": \"16:27:47\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 08:27:42\"}', NULL, NULL, '{\"memberId\": \"10000038837\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Tue, 17 Feb 2026 23:01:25 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra,\\n\\n1. Medications as selected as support for cirrhosis. However, there were no medications noted for this condition on the medication list. Please clarify.\\n2. Insulin was noted for diabetes, however, insulin was not on the medication list. Please clarify.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 18 Feb 2026 21:15:28 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. change treatment plan for Cirrhosis.  \\n2. Added Lantus Insulin 16 units to med list.  \\nThank You!\"}, \"mailId\": \"\"}], \"memberName\": \"Donald Graves\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/16/2026 09:00 AM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000038837, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000038837}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000038837, \"scheduleDate\": \"2026-02-16T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:49\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:38\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"f323cb5b-87fa-4d64-8d9d-93e98599161b\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"f323cb5b-87fa-4d64-8d9d-93e98599161b\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552631139 15      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:33.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":249,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":249,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:33.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-16T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:52', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000038837\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Graves_10000038837_02162026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:37\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000038837.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Graves_10000038837_02162026.pdf', NULL, 'Summary_10000038837.pdf', NULL, '[{\"date\": \"2026-02-17T01:46:44.688Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-18T21:15:28.293Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-16T22:21', 'Member_Summary_10000038837.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000038837\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000038837.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:39\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(81, 57818338, 44829497, '17537038', '10000039522', '', '', '14133640', 'Peter', 'Dickey', 'English', '', '{\"DOB\": 17898, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Successful fax\", \"Aligned\": \"\", \"PCP_NPI\": \"1164536397\", \"Pcp_Zip\": \"04609\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BAR HARBOR\", \"Pcp_Name\": \"CASEY HANSON\", \"Rank_All\": 1, \"PCP_Phone\": \"2076675899\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8A58VX6FF47\", \"Member_City\": \"Lamoine \", \"Office_Name\": \"TRENTON HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lamoine\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-12-31\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 8\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"2078015123\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1052 SHORE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04605\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1052 SHORE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04605\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dickey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"Pdickey56@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2076672343\", \"Member_Identification_Number\": \"10000039522\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:43\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-04T12:00\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T15:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T15:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-04T10:11\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-04T12:00\", \"reportStatus_date\": \"2026-02-04T12:00\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T15:34\", \"reportStatus_date\": \"2026-02-19T15:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T10:11\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-04T18:55\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-04T12:00\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-04T12:00\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-19T12:59\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-19T13:23\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T15:34\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T15:26\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T15:34\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T12:59\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"08:42:50\", \"value\": [{\"add\": \"1052 SHORE RD\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-12-31\", \"eno\": \"207-479-7711\", \"lob\": \"GA - 2026\", \"pno\": \"2076672343\", \"zip\": \"04605\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Lamoine \", \"gend\": 0, \"insh\": \"10000039522\", \"mzip\": \"04605\", \"name\": \"Peter E Dickey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CASEY HANSON\", \"ppno\": \"2076675899\", \"cliId\": \"\", \"email\": \"Pdickey56@gmail.com\", \"ename\": \"MIchelle Dickey \", \"madd1\": \"1052 SHORE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lamoine\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 8\", \"pcpnpi\": \"1164536397\", \"pcpzip\": \"04609\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BAR HARBOR\", \"pcpname\": \"TRENTON HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078015123\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8A58VX6FF47\", \"currentgend\": \"Male\", \"pphycomment\": \"Dr. Hanson is Medicare director but see Dr Myles \", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-04-2026\", \"time\": \"11:31:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 08:42:50\"}', NULL, NULL, '{\"memberId\": \"10000039522\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 17:59:24 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Self Assessment ADL\\\"s please do not use zero 1 is independent.\\n2.  AOD Neuropsych PHQ9 needs to be completed, diagnosis anxiety and depression need info, Med list reports Alzheimer\'s please add.\\n3.  Assessors comments need info about the assessment added.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Feb 2026 18:23:27 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\nI have made the changes. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Peter Dickey\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/04/2026 10:30 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000039522, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000039522}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000039522, \"scheduleDate\": \"2026-02-04T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:50\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:42\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"95c53568-2967-40b2-b222-cd0a5da0e3aa\\\",\\\"destination_fax_number\\\":\\\"12078015123\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"95c53568-2967-40b2-b222-cd0a5da0e3aa\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12078015123\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"33071\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:30.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":252,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":252,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:01.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:30.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-04T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:52', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000039522\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Dickey_10000039522_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:41\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000039522.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Dickey_10000039522_02042026.pdf', NULL, 'Summary_10000039522.pdf', NULL, '[{\"date\": \"2026-02-04T17:00:52.759Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-19T18:23:27.641Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T11:39', 'Member_Summary_10000039522.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000039522\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000039522.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:42\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(82, 55499828, 44829497, '71460194', '10000039546', '', '', '14133640', 'Claude', 'Kenney', 'English', '', '{\"DOB\": 16613, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": \"1194801993\", \"Pcp_Zip\": \"04263\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"GARY RIVARD\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3RC6JU2DH75\", \"Member_City\": \"Leeds\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Leeds\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-06-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"180 CHURCH HILL RD, STE 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2076476015\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"136 KENNEY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04263\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"136 KENNEY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04263\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Kenney\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Claude\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@01062025.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2072407923\", \"Member_Identification_Number\": \"10000039546\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-09T12:41\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-11T07:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-11T13:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-09T12:23\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-09T12:41\", \"reportStatus_date\": \"2026-02-09T12:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-11T13:38\", \"reportStatus_date\": \"2026-02-11T13:38\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-09T12:23\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-10T10:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-09T12:41\", \"username\": \"SAcha\"}, {\"date\": \"2026-02-09T12:41\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-11T13:38\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-11T07:43\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-11T13:38\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"08:45:41\", \"value\": [{\"add\": \"136 KENNEY RD\", \"age\": 80, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-06-25\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2072407923\", \"zip\": \"04263\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Leeds\", \"gend\": 0, \"insh\": \"10000039546\", \"mzip\": \"04263\", \"name\": \"Claude R Kenney\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GARY RIVARD\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"declined@01062025.com\", \"ename\": \"None\", \"madd1\": \"136 KENNEY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Leeds\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD, STE 1\", \"pcpnpi\": \"1194801993\", \"pcpzip\": \"04263\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076476015\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3RC6JU2DH75\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"11:18:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 08:45:41\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000039546, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000039546}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000039546, \"scheduleDate\": \"2026-02-08T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:50\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:45\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"1576d263-4c64-4f88-bd2e-b1f1f57557e0\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"1576d263-4c64-4f88-bd2e-b1f1f57557e0\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:26:26.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:54.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:07.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:11:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:45.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:15:01.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:18:31.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:19:48.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:21:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:08.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:25:20.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:26:26.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-08T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:52', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000039546\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Kenney_10000039546_02082026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000039546.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Kenney_10000039546_02082026.pdf', NULL, 'Summary_10000039546.pdf', NULL, '[{\"date\": \"2026-02-09T17:41:43.202Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-08T10:00', 'Member_Summary_10000039546.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000039546\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000039546.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:46\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(83, 52478890, 44829497, '17537038', '10000040626', '', '', '14133640', 'Hope', 'Simmons', 'English', '', '{\"DOB\": 18371, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": 1366170748, \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"LOUIS, EMILY C\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4G59T96FP35\", \"Member_City\": \"LIMERICK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LIMERICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-04-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"\\tMartins Point Health Care,\\t331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"11 DYER LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04048\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"11 DYER LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04048\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Simmons\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Hope\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"margomarie25@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2077491089, \"Member_Identification_Number\": \"10000040626\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'0', '{\"date\": \"04-07-2026 14:04:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-07 14:04:18\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-27T17:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-11T14:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T14:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T17:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-30T16:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-28T12:58\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-04-02T14:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-02T14:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-07T14:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T09:18\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-03-20T12:48\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-28T11:03\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-07T16:52\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-07T16:52\", \"reportStatus_date\": \"2026-02-07T16:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T14:03\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T17:09\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-20T12:48\", \"reportStatus_date\": \"2026-03-20T12:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-28T12:58\", \"reportStatus_date\": \"2026-03-30T16:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-04-02T14:51\", \"reportStatus_date\": \"2026-04-02T14:51\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-04-07T14:04\", \"reportStatus_date\": \"2026-04-07T14:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-04-07T14:04\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-03-20T12:48\", \"username\": null}, {\"date\": \"2026-03-20T12:48\", \"username\": \"JCopeland\"}], \"inProgress\": [{\"date\": \"2026-02-05T09:18\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-28T11:03\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-30T12:59\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-28T12:58\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-28T12:58\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-31T11:53\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T11:56\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T11:59\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:02\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:05\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:08\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:11\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:14\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:18\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:21\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:24\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:27\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:30\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:33\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-31T12:36\", \"username\": \"CBryan\"}, {\"date\": \"2026-04-02T13:29\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-04-02T14:51\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-04-02T14:04\", \"username\": \"CBryan\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-04-02T14:51\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-31T12:38\", \"username\": \"CBryan\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-07T16:52\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-28-2026\", \"time\": \"12:33:56\", \"value\": [{\"add\": \"11 DYER LN\", \"age\": 75, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-04-18\", \"eno\": \"2078007433\", \"lob\": \"GA - 2026\", \"pno\": 2077491089, \"zip\": \"04048\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LIMERICK\", \"gend\": 1, \"insh\": \"10000040626\", \"mzip\": \"04048\", \"name\": \"Hope M Simmons\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LOUIS, EMILY C\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"margomarie25@gmail.com\", \"ename\": \"Paula Cardona \", \"madd1\": \"11 DYER LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LIMERICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\\tMartins Point Health Care,\\t331 Veranda St\", \"pcpnpi\": 1366170748, \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4G59T96FP35\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"09:18:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-02-2026 13:29:31\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-07T16:52\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"did not present on doxy. no answer to phone call X2 \", \"cancelStatus\": \"0\"}]}', NULL, '{\"memberId\": \"10000040626\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Cynthia Bryan\", \"queryData\": [{\"date\": \"Tue, 31 Mar 2026 16:13:59 GMT\", \"name\": \"CBryan\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda.\\n1). What medication is member on for Macular Degeneration? medication is marked for this in the Assessment of DX eyes. \\n2). In the med list member has been prescribed Prednisolone for Right Cataract. Under eyes in Assessment of DX member has hx of Cataracts with meds not marked. \\n3). Med list shows member is on Arnuity Elipta for Asthma but under the Assessment of DX Respiratory Asthma, it shows hx and no meds are marked. I see the comment stating member does not use. Should inhaler be marked as not using?\\n4). In the Assessment of DX Cardiovascular Valvular, could you please mark active or hx of?\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 31 Mar 2026 16:38:48 GMT\", \"name\": \"Cynthia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Sorry. It sent before I was done.\\n5). Fist box in Neuro-Psycn was not marked.\\n6). Under Assessment of DX Musculoskeletal Spinal Stenosis, treatment box was not marked.\\n7). Could you please add Gout surgery in the Musculoskeletal section?\\n8). could you please add Cellulitis and wound care to the Integument section? \\nThank you,\\nCindy\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 02 Apr 2026 17:29:29 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Good afternoon, \\nI have corrected the form. The eye drops are for a corneal ulcer in the same eye. \\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Hope Simmons\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/28/2026 11:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"c.bryan@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/20/2026 @ 12:48 PM\", \"result\": 0, \"comment\": \"DNF virtual with Amanda Milliken on 04/28/2026, at 11;00am, MRB WILL BE USING ANDRIOD FOR APPT SENT LINK THUR EMAIL\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 02:18 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 03:22 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 08:47 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 05:09 PM\", \"result\": 3, \"comment\": \"02/26/2026- CALLED TO SCH VIRTUAL-HRA Leana Chan, Nicole Mattison, or Amanda Milliken  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 02:57 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 02:57 PM\"}, {\"date\": \"2/11/2026 @ 02:03 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/13/2026 @ 02:02 PM\"}, {\"date\": \"2/3/2026 @ 05:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000040626\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000040626\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000040626\", \"scheduleDate\": \"2026-3-28T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-11-2026 14:03:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-20-2026 12:48:10\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 0, NULL, '[{\"date\": \"2026-04-07 14:04:16\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"30e1bd56-32ac-11f1-8692-5fd2c5c7f289\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": \"null\"}]', 'Virtual', '2026-3-28T11:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:52', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000040626\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Simmons_10000040626_03282026.pdf\", \"ftp_upload_date\": \"2026-04-07 14:04:15\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000040626.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Simmons_10000040626_03282026.pdf', NULL, 'Summary_10000040626.pdf', NULL, '[{\"date\": \"2026-03-28T16:58:10.755Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-04-02T17:29:29.648Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-28T12:55', 'Member_Summary_10000040626.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000040626\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000040626.pdf\", \"member_ftp_upload_date\": \"2026-04-07 14:04:17\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(84, NULL, NULL, '22140773', '10000040719', '', '', '14133640', 'Wanda', 'Avery', 'English', '', '{\"DOB\": 18322, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1285013771\", \"Pcp_Zip\": \"44121005\", \"Program\": \"Medicare\", \"Pcp_City\": \"BREWER\", \"Pcp_Name\": \"KEITH, ALLISON C\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8QV7EG2FC46\", \"Member_City\": \"Milford\", \"Office_Name\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Milford\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-02-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"43 WHITING HILL RD,SUITE 300\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079735042\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"2 AVERY WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04461\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 855\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04461\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Avery\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Wanda\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"wanda.avery1950@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077452266\", \"Member_Identification_Number\": \"10000040719\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077452295\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Spoke with the member, she needs to cancel again as her husband had a stroke.  She does not wish to reschedule yet and would prefer a call back next month.\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 13:43:12\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}', '{\"date\": \"2026-03-17 13:43:12\", \"hrastatus\": \"\", \"reportstatus\": \"F2F Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T14:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T13:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T13:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T11:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T13:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-17T11:03\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-03-05T13:26\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-11T17:47\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-03-12T09:04\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-03-17T13:43\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-17T11:04\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-03-16T12:27\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-17T11:04\", \"reportStatus_date\": \"2026-02-23T13:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T11:45\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-05T13:26\", \"reportStatus_date\": \"2026-03-05T13:26\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-16T12:27\", \"reportStatus_date\": \"2026-03-16T12:27\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-17T13:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-03-05T13:26\", \"username\": null}, {\"date\": \"2026-03-05T13:26\", \"username\": \"KCoash\"}, {\"date\": \"2026-03-12T09:04\", \"username\": \"LRing1\"}], \"inProgress\": [{\"date\": \"2026-02-17T11:03\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-11T17:47\", \"username\": \"EBarker\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T11:04\", \"username\": \"LRing1\"}, {\"date\": \"2026-03-16T12:27\", \"username\": \"LRing1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:59:52\", \"value\": [{\"add\": \"2 AVERY WAY\", \"age\": 76, \"ano\": \"\", \"cno\": \"2077452295\", \"dob\": \"1950-02-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077452266\", \"zip\": \"04461\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Milford\", \"gend\": 1, \"insh\": \"10000040719\", \"mzip\": \"04461\", \"name\": \"Wanda B Avery\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KEITH, ALLISON C\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"wanda.avery1950@gmail.com\", \"ename\": \"\", \"madd1\": \"PO BOX 855\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Milford\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"43 WHITING HILL RD,SUITE 300\", \"pcpnpi\": \"1285013771\", \"pcpzip\": \"44121005\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BREWER\", \"pcpname\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079735042\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8QV7EG2FC46\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-17-2026\", \"time\": \"11:03:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:59:52\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T11:04\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"LRing1\", \"hraStatus\": 3, \"cancelText\": \"Spoke with the member and she needs to cancel the assessment today because her husband is in the hospital.  Would like a call back to reschedule for a later date. Voided assessment in TSS and database and emailed nurse.\", \"cancelStatus\": 0}, {\"date\": \"2026-03-16T12:27\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"LRing1\", \"hraStatus\": 3, \"cancelText\": \"Spoke with the member, she needs to cancel again as her husband had a stroke.  She does not wish to reschedule yet and would prefer a call back next month.\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 14, \"callLog\": [{\"date\": \"3/17/2026 @ 01:43 PM\", \"result\": 14, \"comment\": \"Member asked to be called back in a month per TSS notes - husband had a stroke and she would like a c/b next month\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"4/14/2026 @ 01:41 PM\"}, {\"date\": \"3/12/2026 @ 01:26 PM\", \"result\": 3, \"comment\": \"o/c to see if we can call back to resched for April as NP is doing Virtual the rest of March\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 01:26 PM\", \"result\": 0, \"comment\": \"Sched w/Erin 3/12 at 1:30 pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 11:45 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA w/Jennifer Winslow.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 11:45 AM\"}, {\"date\": \"2/24/2026 @ 10:44 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/27/2026 @ 10:44 AM\"}, {\"date\": \"2/23/2026 @ 10:57 AM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/26/2026 @ 10:57 AM\"}, {\"date\": \"2/20/2026 @ 02:18 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 02:18 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000040719\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": \"10000040719\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": \"10000040719\", \"scheduleDate\": \"2026-3-12T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 14:18:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-16-2026 12:27:24\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, 'In Person', '2026-3-17T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(85, 57818338, 44829497, '39698290', '10000041073', '', '', '14133640', 'Rosemarie', 'Dubay', 'English', '', '{\"DOB\": 18420, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": 1437478138, \"Pcp_Zip\": \"04274\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Poland\", \"Pcp_Name\": \"ALTER, ADAM A\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6YD9MD8EF15\", \"Member_City\": \"Poland\", \"Office_Name\": \"ST MARYS CENTER FOR FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Poland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-06-06\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Poland Family Practice,1230 Maine St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"6095671169\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"270 JACKSON RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04274\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"270 JACKSON RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04274\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Dubay\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rosemarie\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"mskyto@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2079982547, \"Member_Identification_Number\": \"10000041073\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 14:56:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 14:56:48\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-06T16:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T17:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-12T21:28\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-18T22:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-19T03:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T14:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [{\"date\": \"2026-02-04T17:44\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-09T15:56\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-05T12:53\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-02-11T09:34\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-03-11T23:54\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-09T15:56\", \"reportStatus_date\": \"2026-02-09T15:56\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-11T09:34\", \"reportStatus_date\": \"2026-02-11T09:34\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-05T12:53\", \"reportStatus_date\": \"2026-03-05T12:53\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-12T21:28\", \"reportStatus_date\": \"2026-03-12T21:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-19T03:31\", \"reportStatus_date\": \"2026-03-19T03:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T14:56\", \"reportStatus_date\": \"2026-03-24T14:56\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-04T17:44\", \"username\": \"SCadwell\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T14:56\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-02-09T15:56\", \"username\": null}, {\"date\": \"2026-02-09T15:56\", \"username\": \"KCoash\"}, {\"date\": \"2026-02-11T09:34\", \"username\": null}, {\"date\": \"2026-02-11T09:34\", \"username\": \"KCoash\"}, {\"date\": \"2026-03-05T12:53\", \"username\": \"LRing1\"}], \"inProgress\": [{\"date\": \"2026-03-11T23:54\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:53\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-12T21:28\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-12T21:28\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-17T15:40\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-17T19:15\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-19T03:31\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-18T22:06\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-19T03:31\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-17T15:43\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"11:57:21\", \"value\": [{\"add\": \"270 JACKSON RD\", \"age\": 75, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-06-06\", \"eno\": \"2079982547\", \"lob\": \"GA - 2026\", \"pno\": 2079982547, \"zip\": \"04274\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Poland\", \"gend\": 1, \"insh\": \"10000041073\", \"mzip\": \"04274\", \"name\": \"Rosemarie A Dubay\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ALTER, ADAM A\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mskyto@roadrunner.com\", \"ename\": \"Paul Dubay\", \"madd1\": \"270 JACKSON RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Poland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Poland Family Practice,1230 Maine St\", \"pcpnpi\": 1437478138, \"pcpzip\": \"04274\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Poland\", \"pcpname\": \"ST MARYS CENTER FOR FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"6095671169\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6YD9MD8EF15\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-05-2026\", \"time\": \"12:38:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 19:15:11\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-04T17:44\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"SCadwell\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"10000041073\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Tue, 17 Mar 2026 19:43:38 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra,\\n1.  AOD Cardiovascular med list reports angina.  Please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 17 Mar 2026 23:15:11 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"completed. thank you\"}, \"mailId\": \"\"}], \"memberName\": \"Rosemarie Dubay\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/12/2026 12:00 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"2/11/2026 @ 09:34 AM\", \"result\": 12, \"comment\": \"mbr husband resched to 10:30 am same day - transferred him to MP as he had questions regarding what information is being gathered and why\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 03:56 PM\", \"result\": 0, \"comment\": \"Calling to schedule F2F w/Sandy on March 6 - sched 3/6 at 10:30 am w/Sandy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 04:27 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 04:27 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000041073\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000041073\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000041073\", \"scheduleDate\": \"2026-3-6T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 16:27:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-05-2026 12:53:18\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 14:56:44\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e088e8b9-841c-434f-8ebc-473de1191b6b\\\",\\\"destination_fax_number\\\":\\\"16095671169\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"e088e8b9-841c-434f-8ebc-473de1191b6b\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"16095671169\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:15:58.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T18:56:58.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T18:58:13.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:00:34.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:01:47.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:04:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:05:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:07:41.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:08:56.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:11:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:12:28.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:14:49.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:15:58.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-12T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:53', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000041073\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Dubay_10000041073_03122026.pdf\", \"ftp_upload_date\": \"2026-03-24 14:56:43\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000041073.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Dubay_10000041073_03122026.pdf', NULL, 'Summary_10000041073.pdf', NULL, '[{\"date\": \"2026-03-13T01:28:52.971Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-17T23:15:11.077Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-12T13:15', 'Member_Summary_10000041073.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000041073\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000041073.pdf\", \"member_ftp_upload_date\": \"2026-03-24 14:56:46\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(86, 71932120, 44829497, '71460194', '10000041250', '', '', '14133640', 'Reginald', 'Bouchard', 'English', '', '{\"DOB\": 14855, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": \"1194801993\", \"Pcp_Zip\": \"04263\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"GARY RIVARD\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1WY8AE2WW55\", \"Member_City\": \"Greene\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Greene\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-09-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"180 CHURCH HILL RD, STE 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2076476015\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"386 QUAKER RIDGE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04236\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"386 QUAKER RIDGE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04236\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bouchard\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Reginald\", \"Member_Middle_name\": \"O\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@01312025.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2079466094\", \"Member_Identification_Number\": \"10000041250\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2072128075\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:49\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-16T12:11\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-18T20:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-18T23:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-15T12:18\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T12:11\", \"reportStatus_date\": \"2026-02-16T12:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-18T23:04\", \"reportStatus_date\": \"2026-02-18T23:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-15T12:18\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T09:23\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T16:02\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-16T12:11\", \"username\": \"SAcha\"}, {\"date\": \"2026-02-16T12:11\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-18T23:04\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-18T20:05\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-18T23:04\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"08:49:00\", \"value\": [{\"add\": \"386 QUAKER RIDGE RD\", \"age\": 85, \"ano\": \"\", \"cno\": \"2072128075\", \"dob\": \"1940-09-01\", \"eno\": \"2527171906\", \"lob\": \"GA - 2026\", \"pno\": \"2079466094\", \"zip\": \"04236\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Greene\", \"gend\": 0, \"insh\": \"10000041250\", \"mzip\": \"04236\", \"name\": \"Reginald O Bouchard\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GARY RIVARD\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"declined@01312025.com\", \"ename\": \"David Bouchard (Son)\", \"madd1\": \"386 QUAKER RIDGE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Greene\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD, STE 1\", \"pcpnpi\": \"1194801993\", \"pcpzip\": \"04263\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076476015\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1WY8AE2WW55\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-12-2026\", \"time\": \"10:32:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 08:49:00\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000041250, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000041250}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000041250, \"scheduleDate\": \"2026-02-15T12:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:51\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:49\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"d6df7e10-f60f-4ce0-a2d6-5c621a0a74e6\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"d6df7e10-f60f-4ce0-a2d6-5c621a0a74e6\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:55.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:58.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:15.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:11:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:32.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:14:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:02.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:18:06.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:45.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:21:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:22:29.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:24:38.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:55.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-15T12:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:53', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000041250\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Bouchard_10000041250_02152026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:48\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000041250.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Bouchard_10000041250_02152026.pdf', NULL, 'Summary_10000041250.pdf', NULL, '[{\"date\": \"2026-02-16T17:11:05.576Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-15T13:10', 'Member_Summary_10000041250.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000041250\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000041250.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:49\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
