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
(21, 57818338, 44829497, '45509507', '10000059730', '', '', '14133640', 'Georgia', 'Woodbury', 'English', '', '{\"DOB\": 19434, \"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\": \"1720067317\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"JEFFREY PATCH\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6ED2X44GJ80\", \"Member_City\": \"GRAY\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GRAY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-03-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"7 FRIENDSHIP DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 FRIENDSHIP DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Woodbury\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Georgia\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"gmw3163@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-20-2026\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2073297408\", \"Member_Identification_Number\": \"10000059730\", \"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:04:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:04:38\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-08T17:21\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-25T23:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T02:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17: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-08T13:44\", \"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-08T17:21\", \"reportStatus_date\": \"2026-02-08T17:21\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-19T14:51\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T02:37\", \"reportStatus_date\": \"2026-02-26T02:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:04\", \"reportStatus_date\": \"2026-03-03T17:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:04\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-08T13:44\", \"username\": \"JWinslow\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T10:13\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-08T17:21\", \"username\": \"JWinslow\"}, {\"date\": \"2026-02-08T17:21\", \"username\": \"JWinslow\"}, {\"date\": \"2026-02-19T14:50\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-25T18:06\", \"username\": \"JWinslow\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T02:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-25T23:54\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T02:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T14:51\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-26-2026\", \"time\": \"16:36:42\", \"value\": [{\"add\": \"7 FRIENDSHIP DR\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-03-16\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2073297408\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GRAY\", \"gend\": 1, \"insh\": \"10000059730\", \"mzip\": \"04039\", \"name\": \"Georgia M Woodbury\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JEFFREY PATCH\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"gmw3163@gmail.com\", \"ename\": \"\", \"madd1\": \"7 FRIENDSHIP DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GRAY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"259 Main St\", \"pcpnpi\": \"1720067317\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Registered Partnership\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6ED2X44GJ80\", \"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-08-2026\", \"time\": \"13:44:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-26-2026 16:36:42\"}', NULL, NULL, '{\"memberId\": \"10000059730\", \"clinician\": \"Jennifer Winslow\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 19:51:56 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Jennifer\\n1.  Vital signs are you interested in nutrition question needs answer.\\n2.  Home safety what can you work on to improve quality of life question needs answer.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 25 Feb 2026 23:06:50 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Completed thank you \"}, \"mailId\": \"\"}], \"memberName\": \"Georgia Woodbury\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/08/2026 01:30 PM\", \"clinicianMailId\": \"jennifer.winslow@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\": 10000059730, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"45509507\", \"memberId\": 10000059730}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"45509507\", \"memberId\": 10000059730, \"scheduleDate\": \"2026-02-08T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:34\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:04:37\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e01703ff-28ae-4f7e-8d22-55fe7f4614af\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"e01703ff-28ae-4f7e-8d22-55fe7f4614af\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:53.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:04:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:06:05.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:08:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:43.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:11:55.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:08.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:15:30.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:52.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:19:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:25.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:22:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:53.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-08T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:36', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059730\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Woodbury_10000059730_02082026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:04:36\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059730.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Woodbury_10000059730_02082026.pdf', NULL, 'Summary_10000059730.pdf', NULL, '[{\"date\": \"2026-02-08T22:21:10.612Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-25T23:06:50.315Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-08T14:05', 'Member_Summary_10000059730.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059730\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059730.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:04:37\"}', NULL, NULL, NULL, '01-20-2026', '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
(22, 71932120, 44829497, '22140773', '10000011468', '', '', '14133640', 'Beatrice', 'Thomas', 'English', '', '{\"DOB\": 15248, \"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\": \"1013062348\", \"Pcp_Zip\": \"04073\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Sanford\", \"Pcp_Name\": \"GAVIN DUCKER\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1DX4DP4UF91\", \"Member_City\": \"BROOKS\", \"Office_Name\": \"YORK HOSPITAL SANFORD WALK IN CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BROOKS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-09-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"1474 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Waldo\", \"Member_Country\": \"Waldo\", \"PCP_Fax_Number\": \"2078613281\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"154 MOOSEHEAD TRAIL HWY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04921\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 347\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04921\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Thomas\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Beatrice\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"none@02092012.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\": \"2077223557\", \"Member_Identification_Number\": \"10000011468\", \"Member_Alternate_Phone_Number\": \"2077223557\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:27:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:27:03\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-23T18:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-04T16:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-05T08:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-05T12:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-15T11:14\", \"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\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-15T11:14\", \"reportStatus_date\": \"2026-02-15T11:14\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 9, \"hraStatus_date\": \"2026-02-23T21:32\", \"reportStatus_date\": \"2026-02-23T18:32\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-05T12:50\", \"reportStatus_date\": \"2026-03-05T12:50\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:27\", \"reportStatus_date\": \"2026-03-10T14:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:27\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-15T11:14\", \"username\": \"EBarker\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-02-19T16:53\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T16:56\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T16:59\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:02\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:05\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:08\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:11\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:14\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:17\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:21\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-22T21:12\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-04T16:04\", \"username\": \"AWalsh\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-05T12:50\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T18:32\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-05T08:27\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-05T12:50\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-20T15:54\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [{\"date\": \"2026-02-23T21:32\", \"username\": \"JWren1\"}], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"11:48:02\", \"value\": [{\"add\": \"154 MOOSEHEAD TRAIL HWY\", \"age\": 84, \"ano\": \"2077223557\", \"cno\": \"\", \"dob\": \"1941-09-29\", \"eno\": \"2078527124\", \"lob\": \"GA - 2026\", \"pno\": \"2077223557\", \"zip\": \"04921\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BROOKS\", \"gend\": 1, \"insh\": \"10000011468\", \"mzip\": \"04921\", \"name\": \"Beatrice A Thomas\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GAVIN DUCKER\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"none@02092012.com\", \"ename\": \"Jonathan Thomas - son\", \"madd1\": \"PO BOX 347\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BROOKS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"1474 Main St\", \"pcpnpi\": \"1013062348\", \"pcpzip\": \"04073\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"Sanford\", \"pcpname\": \"YORK HOSPITAL SANFORD WALK IN CARE\", \"program\": \"Medicare\", \"evalDate\": \"2026-02-02 1:30:00 PM\", \"evalName\": \"Erin Barker, FNP\", \"pcpfaxno\": \"2078613281\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1DX4DP4UF91\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"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-03-2026\", \"time\": \"16:08:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 11:48:02\"}', NULL, NULL, '{\"memberId\": \"10000011468\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 22:21:30 GMT\", \"name\": \"MJoseph\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"\\n\\n\\n \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Feb 2026 20:54:57 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Please select if diabetes is active or history of in the assessment of diagnosis endocrine section.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 02:12:23 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"It\'s been clarified.\\nThanks!\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Feb 2026 02:32:05 GMT\", \"name\": \"Jared \", \"role\": \"coder_lead\", \"files\": [], \"query\": {\"feedback\": \"Hello,\\n\\nUnder the genitourinary section, could you please select active or history of for the CKD? Thank you.\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Beatrice Thomas\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/02/2026 01:30 PM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"j.wren@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 01:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"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\": 10000011468, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000011468}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000011468, \"scheduleDate\": \"2026-02-02T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:34\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-10 14:27:02\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ab7fe15d-7208-4bfa-9c2a-99d0a6f7bf51\\\",\\\"destination_fax_number\\\":\\\"12078613281\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"ab7fe15d-7208-4bfa-9c2a-99d0a6f7bf51\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12078613281\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:42:15.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-10T18:27:24.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:27:55.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:30:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:30:56.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:33:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:33:41.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:35:55.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:36:50.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:38:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:39:35.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:41:44.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:42:15.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-02T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:36', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000011468\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Thomas_10000011468_02022026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:27:02\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000011468.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Thomas_10000011468_02022026.pdf', NULL, 'Summary_10000011468.pdf', NULL, '[{\"date\": \"\", \"signature\": \"\"}, {\"date\": \"2026-02-23T02:12:22.690Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-02T14:55', 'Member_Summary_10000011468.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000011468\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000011468.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:27:02\"}', 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
(23, NULL, NULL, '17537038', '10000011524', '', '', '14133640', 'Nancy', 'Newton', '', '', '{\"DOB\": 16611, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": 1720579543, \"Pcp_Zip\": \"04976\", \"Program\": \"Medicare\", \"Pcp_City\": \"Skowhegan\", \"Pcp_Name\": \"CRISWELL, RACHEL L\", \"Rank_All\": 1, \"PCP_Phone\": 2074746201, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3VG4RN6AR97\", \"Member_City\": \"Gardiner\", \"Office_Name\": \"SKOWHEGAN FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gardiner\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-06-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Skowhegan Family Medicine,46 Fairview Ave Ste 334\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2074740969, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"35 FREMONT ST APT 4\", \"Member_Zip_Code\": \"04345\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 456\", \"Mailing_Zip_Code\": \"04345\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Newton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nancy\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@032322.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2075822434, \"Member_Identification_Number\": \"10000011524\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"need to reschedule\"}', 1, b'0', b'0', '{\"date\": \"02-23-2026 18:15:13\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-23 18:15:13\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-23T18:15\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-04T12:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T16:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T17:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T16:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T18:15\", \"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}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-03T16:37\", \"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-03T16:37\", \"reportStatus_date\": \"2026-02-09T16:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T16:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T18:15\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:37\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"02-23-2026\", \"time\": \"23:35:40\", \"value\": [{\"add\": \"35 FREMONT ST APT 4\", \"age\": 80, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-06-23\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2075822434, \"zip\": \"04345\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Gardiner\", \"gend\": 1, \"insh\": \"10000011524\", \"mzip\": \"04345\", \"name\": \"Nancy M Newton\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CRISWELL, RACHEL L\", \"ppno\": 2074746201, \"cliId\": \"\", \"email\": \"declined@032322.com\", \"ename\": \"\", \"madd1\": \"PO BOX 456\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gardiner\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Skowhegan Family Medicine,46 Fairview Ave Ste 334\", \"pcpnpi\": 1720579543, \"pcpzip\": \"04976\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Skowhegan\", \"pcpname\": \"SKOWHEGAN FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2074740969, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3VG4RN6AR97\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-14-2026\", \"time\": \"05:27:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-24-2026 00:37:08\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:37\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"need to reschedule\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/25/2026 @ 08:37 AM\", \"result\": 3, \"comment\": \"called to schedule w/ kathryn baxter \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 12:23 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 05:13 PM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 11:54 AM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 01:41 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Dean W. no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 03:15 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 04:46 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/19/2026 @ 04:46 PM\"}, {\"date\": \"2/10/2026 @ 02:32 PM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/13/2026 @ 02:32 PM\"}, {\"date\": \"2/9/2026 @ 04:32 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/13/2026 @ 04:32 PM\"}, {\"date\": \"2/4/2026 @ 12:54 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/5/2026 @ 12:49 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/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\": 10000011524, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000011524}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000011524, \"scheduleDate\": \"2026-02-02T13:30:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 12:54:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-23-2026 18:15:13\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, 'Virtual', '2026-02-02T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:36', 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
(24, 55499828, 44829497, '22140773', '10000104423', '', '', '14133640', 'Arlene', 'Frey', 'English', '', '{\"DOB\": 21220, \"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\": \"1922668466\", \"Pcp_Zip\": \"04412\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Brewer\", \"Pcp_Name\": \"KATHRYN DOBROVOLNY\", \"Rank_All\": 1, \"PCP_Phone\": \"2079891567\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2T58KW0XX42\", \"Member_City\": \"HAMPDEN\", \"Office_Name\": \"BREWER MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"HAMPDEN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-02-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"735 Wilson St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079892286\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"36 BACK WINTERPORT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04444\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 88\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04444\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Frey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Arlene\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"snowwoman58@aol.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\": \"2079912725\", \"Member_Identification_Number\": \"10000104423\", \"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:04:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:04:42\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-05T11:32\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-13T05:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-13T14:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17: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-05T07:38\", \"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\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-06T10:53\", \"reportStatus_date\": \"2026-02-05T11:32\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-13T14:19\", \"reportStatus_date\": \"2026-02-13T14:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:04\", \"reportStatus_date\": \"2026-03-03T17:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:04\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T07:38\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-05T12:10\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-05T11:32\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-05T11:32\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-12T05:43\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-13T14:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-13T05:52\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-13T14:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-06T10:53\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"09:47:14\", \"value\": [{\"add\": \"36 BACK WINTERPORT RD\", \"age\": 68, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-02-04\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2079912725\", \"zip\": \"04444\", \"add2\": \"\", \"add3\": \"\", \"city\": \"HAMPDEN\", \"gend\": 1, \"insh\": \"10000104423\", \"mzip\": \"04444\", \"name\": \"Arlene L Frey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KATHRYN DOBROVOLNY\", \"ppno\": \"2079891567\", \"cliId\": \"\", \"email\": \"snowwoman58@aol.com\", \"ename\": \"\", \"madd1\": \"PO BOX 88\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"HAMPDEN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"735 Wilson St\", \"pcpnpi\": \"1922668466\", \"pcpzip\": \"04412\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"Brewer\", \"pcpname\": \"BREWER MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079892286\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"2T58KW0XX42\", \"currentgend\": \"Female\", \"pphycomment\": \"member sees Jennifer Taylor, NP for primary care\", \"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-03-2026\", \"time\": \"16:29:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-26-2026 16:40:26\"}', NULL, NULL, '{\"memberId\": \"10000104423\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 06 Feb 2026 15:53:12 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Erin,\\n1) For any diagnosis the member did not endorse, you can add a comment stating this, I would not select the diagnosis in the assessment of diagnosis, and list it as active( glaucoma, mitral valve deficiency)\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 12 Feb 2026 10:43:47 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Got it, thanks!\"}, \"mailId\": \"\"}], \"memberName\": \"Arlene Frey\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/05/2026 09:00 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"h.beck@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\": 10000104423, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000104423}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000104423, \"scheduleDate\": \"2026-02-05T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:35\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:04:41\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"af72bd11-7953-4495-bdc8-9bb0346abdfc\\\",\\\"destination_fax_number\\\":\\\"12079892286\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"af72bd11-7953-4495-bdc8-9bb0346abdfc\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12079892286\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"12079892286\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10: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\\\":319,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":319,\\\"start_timestamp\\\":\\\"2026-03-03T22:04:55.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:33.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-05T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:37', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000104423\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Frey_10000104423_02052026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:04:40\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000104423.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Frey_10000104423_02052026.pdf', NULL, 'Summary_10000104423.pdf', NULL, '[{\"date\": \"2026-02-05T16:32:07.101Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-12T10:43:46.559Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-05T10:10', 'Member_Summary_10000104423.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000104423\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000104423.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:04:41\"}', 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
(25, 55499828, 44829497, '8715496', '10000012946', '', '', '14133640', 'William', 'Doucette', 'English', '', '{\"DOB\": 17078, \"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\": \"1760467187\", \"Pcp_Zip\": \"04988\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Unity \", \"Pcp_Name\": \"Jennifer Fitzpatrick\", \"Rank_All\": 1, \"PCP_Phone\": \"2079482100\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7MV0UK3CR08\", \"Member_City\": \"Benton\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE UNITY\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Benton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-10-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"80 Main Street\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2079483018\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"294 E BENTON RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"294 E BENTON RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Doucette\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"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\": \"2074532489\", \"Member_Identification_Number\": \"10000012946\", \"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:05:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-03-03 17:05:04\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"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-06T18:36\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-09T14:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-09T15:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17: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-04T12:37\", \"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\": 10, \"hraStatus_date\": \"2026-02-09T15:49\", \"reportStatus_date\": \"2026-02-09T15:49\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:04\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:04\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T12:37\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:51\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-06T18:36\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-06T18:36\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-09T15:49\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-09T14:42\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-09T15:49\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"09:51:39\", \"value\": [{\"add\": \"294 E BENTON RD\", \"age\": 79, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-10-03\", \"eno\": \"2074532489\", \"lob\": \"GA - 2026\", \"pno\": \"2074532489\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Benton\", \"gend\": 0, \"insh\": \"10000012946\", \"mzip\": \"04901\", \"name\": \"William J Doucette\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Jennifer Fitzpatrick\", \"ppno\": \"2079482100\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Elaine Doucette (wife)\", \"madd1\": \"294 E BENTON RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Benton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"80 Main Street\", \"pcpnpi\": \"\", \"pcpzip\": \"04988\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Unity \", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE UNITY\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079483018\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7MV0UK3CR08\", \"currentgend\": \"Male\", \"pphycomment\": \"verified with member\", \"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, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visit.  \"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-04-2026\", \"time\": \"12:37:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-26-2026 16:52:18\"}', 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\": 10000012946, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": 10000012946}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": 10000012946, \"scheduleDate\": \"2026-02-04T10:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:35\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:04:45\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"072acdf3-521b-42c3-bf85-b960480f2878\\\",\\\"destination_fax_number\\\":\\\"12079483018\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"072acdf3-521b-42c3-bf85-b960480f2878\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12079483018\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2072754847 SVH North\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:31.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\\\":260,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":260,\\\"start_timestamp\\\":\\\"2026-03-03T22:04:59.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:31.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-04T10:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:37', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012946\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Doucette_10000012946_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:04:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000012946.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Doucette_10000012946_02042026.pdf', NULL, 'Summary_10000012946.pdf', NULL, '[{\"date\": \"2026-02-06T23:36:31.472Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T15:29', 'Member_Summary_10000012946.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012946\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000012946.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:04: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
(26, 71932120, 44829497, '39698290', '10000112658', '', '', '14133640', 'Donald', 'Frechette Jr', 'English', '', '{\"DOB\": 21817, \"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\": \"1023040656\", \"Pcp_Zip\": \"04074\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"SCARBOROUGH\", \"Pcp_Name\": \"MARK BOUCHARD\", \"Rank_All\": 1, \"PCP_Phone\": \"2077811500\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9Q57WC8VF57\", \"Member_City\": \"NEW GLOUCESTER\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"NEW GLOUCESTER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1959-09-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"301C US ROUTE 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2077811507\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"428 COBBS BRIDGE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04260\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"428 COBBS BRIDGE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04260\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Frechette Jr\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"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\": \"2075767497\", \"Member_Identification_Number\": \"10000112658\", \"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:04:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:04:51\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-19T21:56\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-20T16:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-20T16:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"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\": 10, \"hraStatus_date\": \"2026-02-20T16:49\", \"reportStatus_date\": \"2026-02-20T16:49\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:04\", \"reportStatus_date\": \"2026-03-03T17:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:04\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-18T20:48\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-20T11:15\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-19T21:56\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-19T21:56\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-20T16:49\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-20T16:39\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-20T16:49\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"10:24:43\", \"value\": [{\"add\": \"428 COBBS BRIDGE RD\", \"age\": 66, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-09-24\", \"eno\": \"2075761050\", \"lob\": \"GA - 2026\", \"pno\": \"2075767497\", \"zip\": \"04260\", \"add2\": \"\", \"add3\": \"\", \"city\": \"NEW GLOUCESTER\", \"gend\": 0, \"insh\": \"10000112658\", \"mzip\": \"04260\", \"name\": \"Donald D Frechette Jr\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MARK BOUCHARD\", \"ppno\": \"2077811500\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Leah Frechette\", \"madd1\": \"428 COBBS BRIDGE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"NEW GLOUCESTER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"301C US ROUTE 1\", \"pcpnpi\": \"1023040656\", \"pcpzip\": \"04074\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"SCARBOROUGH\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077811507\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9Q57WC8VF57\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Jehovah\'s Witness \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"15:15:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-26-2026 17:10:58\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"2/3/2026 @ 04:38 PM\", \"result\": 1, \"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\": 10000112658, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000112658}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000112658, \"scheduleDate\": \"2026-02-06T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:35\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:04:50\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"2ab1c205-5de3-4a43-89f5-0c89f72d3069\\\",\\\"destination_fax_number\\\":\\\"12077811507\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"2ab1c205-5de3-4a43-89f5-0c89f72d3069\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12077811507\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"MaineHealth         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:25.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\\\":243,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":243,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:07.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:25.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-06T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:37', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000112658\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Frechette Jr_10000112658_02062026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:04:49\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000112658.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Frechette Jr_10000112658_02062026.pdf', NULL, 'Summary_10000112658.pdf', NULL, '[{\"date\": \"2026-02-20T02:56:06.635Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-19T13:30', 'Member_Summary_10000112658.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000112658\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000112658.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:04:51\"}', 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
(27, 71932120, 44829497, '22140773', '10000013006', '', '', '14133640', 'Marianne', 'Fricke', 'English', '', '{\"DOB\": 17062, \"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\": \"1316029077\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"KENNETH SMITH\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1EX8XU0AQ58\", \"Member_City\": \"BANGOR\", \"Office_Name\": \"NORTHERN LIGHT INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BANGOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-09-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"302 Husson Ave Ste 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"3023378072\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"69 FRENCHS POINT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04401\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"69 FRENCHS POINT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04401\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Fricke\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marianne\", \"Member_Middle_name\": \"Y\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"THEREALFRICKSTER@YAHOO.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\": \"2079510163\", \"Member_Identification_Number\": \"10000013006\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2079510163\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-03-03 17:05:04\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"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-08T14:19\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-12T15:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-12T17:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17: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-04T12:50\", \"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\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-09T21:00\", \"reportStatus_date\": \"2026-02-08T14:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-12T17:13\", \"reportStatus_date\": \"2026-02-12T17:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:04\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:04\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T12:50\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:53\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-08T14:19\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-08T14:19\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-12T05:38\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-12T17:13\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-12T15:22\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-12T17:13\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-09T21:00\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:08:05\", \"value\": [{\"add\": \"69 FRENCHS POINT RD\", \"age\": 79, \"ano\": \"\", \"cno\": \"2079510163\", \"dob\": \"1946-09-17\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2079510163\", \"zip\": \"04401\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BANGOR\", \"gend\": 1, \"insh\": \"10000013006\", \"mzip\": \"04401\", \"name\": \"Marianne Y Fricke\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KENNETH SMITH\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"THEREALFRICKSTER@YAHOO.COM\", \"ename\": \"Laurent Lussier - husband\", \"madd1\": \"69 FRENCHS POINT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BANGOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"302 Husson Ave Ste 1\", \"pcpnpi\": \"1316029077\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"NORTHERN LIGHT INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"3023378072\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"1EX8XU0AQ58\", \"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-03-2026\", \"time\": \"16:20:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-27-2026 11:25:35\"}', NULL, NULL, '{\"memberId\": \"10000013006\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Tue, 10 Feb 2026 02:00:56 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Please select the treatment for allergic rhinitis in the assessment of diagnosis section.\\n2. In the assessment of diagnosis, musculoskeletal, please select if osteoporosis is active or history of. \\n3. Please complete the endocrine and hematology/immunology/infectious disease section.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 12 Feb 2026 10:38:47 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Marianne Fricke\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/04/2026 03:00 PM\", \"clinicianMailId\": \"e.barker@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\": 10000013006, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000013006}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000013006, \"scheduleDate\": \"2026-02-04T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:04:54\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"8c71567a-c064-4acf-a416-54c39d471ef3\\\",\\\"destination_fax_number\\\":\\\"13023378072\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"8c71567a-c064-4acf-a416-54c39d471ef3\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"13023378072\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18: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:05:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:05:45.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:18.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:10:40.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:08.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:13:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13: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:15:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:25.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:18:33.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:55.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-04T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:37', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000013006\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Fricke_10000013006_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:04:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000013006.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Fricke_10000013006_02042026.pdf', NULL, 'Summary_10000013006.pdf', NULL, '[{\"date\": \"2026-02-08T19:19:00.066Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-12T10:38:46.847Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T17:00', 'Member_Summary_10000013006.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000013006\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000013006.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:04:55\"}', 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
(28, 57818338, 44829497, '27743162', '10000048605', '', '', '14133640', 'Laurent', 'Giguere', 'English', '', '{\"DOB\": 18200, \"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\": \"1386606333\", \"Pcp_Zip\": \"04005\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BIDDEFORD\", \"Pcp_Name\": \"MICHAEL ALBAUM\", \"Rank_All\": 1, \"PCP_Phone\": \"2072823349\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4KW9E66PD47\", \"Member_City\": \"BIDDEFORD\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BIDDEFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-10-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"PO BOX 626\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2072826099\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"14 RAYMOND ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"14 RAYMOND ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Giguere\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Laurent\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"declined@012126.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2074139716\", \"Member_Identification_Number\": \"10000048605\", \"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:05:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:00\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-24T11:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-24T12:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"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\": 10, \"hraStatus_date\": \"2026-02-24T12:35\", \"reportStatus_date\": \"2026-02-24T12:35\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-24T12:35\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-24T11:08\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-24T12:35\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:11:09\", \"value\": [{\"add\": \"14 RAYMOND ST\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-10-29\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2074139716\", \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BIDDEFORD\", \"gend\": 0, \"insh\": \"10000048605\", \"mzip\": \"04005\", \"name\": \"Laurent D Giguere\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MICHAEL ALBAUM\", \"ppno\": \"2072823349\", \"cliId\": \"\", \"email\": \"declined@012126.com\", \"ename\": \"\", \"madd1\": \"14 RAYMOND ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BIDDEFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 626\", \"pcpnpi\": \"1386606333\", \"pcpzip\": \"04005\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"BIDDEFORD\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2072826099\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4KW9E66PD47\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Catholic \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-09-2026\", \"time\": \"14:05:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-30-2026 17:27:35\"}', 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\": 10000048605, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": 10000048605}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": 10000048605, \"scheduleDate\": \"2026-02-03T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:04:59\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"a9c52d23-a4fd-4dcf-b1d2-81bd087775c8\\\",\\\"destination_fax_number\\\":\\\"12072826099\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"a9c52d23-a4fd-4dcf-b1d2-81bd087775c8\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12072826099\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:12.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:05:10.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:06:19.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:08:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:42.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:11:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:00.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:15:08.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:14.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:18:32.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:19:40.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:21:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:38', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000048605\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Giguere_10000048605_02032026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:04:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000048605.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Giguere_10000048605_02032026.pdf', NULL, 'Summary_10000048605.pdf', NULL, '[{\"date\": \"2026-02-03T18:07:40.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T13:04', 'Member_Summary_10000048605.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000048605\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000048605.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:04:59\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
