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
(67, 57818338, 44829497, '39698290', '10000034794', '', '', '14133640', 'Peter', 'Milliken', 'English', '', '{\"DOB\": 18123, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Busy. The destination number was busy.\", \"Aligned\": \"\", \"PCP_NPI\": \"1275732364\", \"Pcp_Zip\": \"04011\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Brunswick\", \"Pcp_Name\": \"JOHN SOMMER\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5JX1HQ7XU12\", \"Member_City\": \"Durham\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Durham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-08-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"PEDIATRICS\", \"Pcp_Address_1\": \"114 Bath Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1683 ROYALSBOROUGH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04222\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1683 ROYALSBOROUGH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04222\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Milliken\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45658, \"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\": \"No\", \"Member_Primary_Phone_Number\": \"2074490289\", \"Member_Identification_Number\": \"10000034794\", \"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:06:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:53\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-18T11:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-22T23:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T14:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"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-23T14:13\", \"reportStatus_date\": \"2026-02-23T14:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [{\"date\": \"2026-02-18T11:18\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-18T11:18\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-22T14:50\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T14:13\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-22T23:00\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T14:13\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-21T23:02\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"16:28:41\", \"value\": [{\"add\": \"1683 ROYALSBOROUGH RD\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-08-13\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2074490289\", \"zip\": \"04222\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Durham\", \"gend\": 0, \"insh\": \"10000034794\", \"mzip\": \"04222\", \"name\": \"Peter L Milliken\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JOHN SOMMER\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1683 ROYALSBOROUGH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Durham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"114 Bath Rd\", \"pcpnpi\": \"1275732364\", \"pcpzip\": \"04011\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Brunswick\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5JX1HQ7XU12\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"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-10-2026\", \"time\": \"10:43:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 16:28:41\"}', NULL, NULL, '{\"memberId\": \"10000034794\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Sun, 22 Feb 2026 04:02:26 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra\\n1.  Demographics gender needs answer.\\n2.  Medication list remove the medications not taking.\\n3.  Assessors Comments needs info added.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 22 Feb 2026 19:50:15 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"completed. \"}, \"mailId\": \"\"}], \"memberName\": \"Peter Milliken\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/02/2026 03:00 PM\", \"clinicianMailId\": \"s.cadwell@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\": 10000034794, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000034794}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000034794, \"scheduleDate\": \"2026-02-02T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:46\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:06:53\", \"status\": 0, \"message\": \"Busy. The destination number was busy.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"7853b104-d3b1-45dd-a169-ca3a93a858cf\\\",\\\"destination_fax_number\\\":\\\"12078287850\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"7853b104-d3b1-45dd-a169-ca3a93a858cf\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12078287850\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:12.005+0000\\\",\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:01.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:07:26.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:09:44.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:51.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:15:01.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:26.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:17:44.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:31.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:20:43.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-02T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:48', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000034794\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Milliken_10000034794_02022026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:52\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000034794.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Milliken_10000034794_02022026.pdf', NULL, 'Summary_10000034794.pdf', NULL, '[{\"date\": \"2026-02-04T18:40:32.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-22T19:50:14.497Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-02T15:56', 'Member_Summary_10000034794.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000034794\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000034794.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:53\"}', 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
(68, 62035418, 44829497, '22140773', '10000035203', '', '', '14133640', 'Linda', 'Dorman', 'English', '', '{\"DOB\": 17715, \"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\": \"1023361953\", \"Pcp_Zip\": \"04953\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Newport\", \"Pcp_Name\": \"BETHANY DAY\", \"Rank_All\": 1, \"PCP_Phone\": \"2073685747\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8NM6U52PP89\", \"Member_City\": \"EXETER\", \"Office_Name\": \"NORTHERN LIGHT HEALTH CENTER NEWPORT PLAZA\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"EXETER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-07-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"26 Main St Ste 2\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2073685483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1022 EXETER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04435\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1022 EXETER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04435\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dorman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Linda\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"declined@050223.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\": \"2072784800\", \"Member_Identification_Number\": \"10000035203\", \"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:06:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:58\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-08T13:12\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T16:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T18:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-06T07:06\", \"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-08T13:12\", \"reportStatus_date\": \"2026-02-08T13:12\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T16:25\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T18:15\", \"reportStatus_date\": \"2026-02-17T18:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-06T07:06\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:50\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-08T13:12\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-08T13:12\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-16T16:25\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T18:15\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T16:29\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T18:15\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-15T13:38\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"16:32:00\", \"value\": [{\"add\": \"1022 EXETER RD\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-07-01\", \"eno\": \"2072990806\", \"lob\": \"GA - 2026\", \"pno\": \"2072784800\", \"zip\": \"04435\", \"add2\": \"\", \"add3\": \"\", \"city\": \"EXETER\", \"gend\": 1, \"insh\": \"10000035203\", \"mzip\": \"04435\", \"name\": \"Linda E Dorman\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BETHANY DAY\", \"ppno\": \"2073685747\", \"cliId\": \"\", \"email\": \"declined@050223.com\", \"ename\": \"Kenneth Dorman - son\", \"madd1\": \"1022 EXETER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"EXETER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"26 Main St Ste 2\", \"pcpnpi\": \"1023361953\", \"pcpzip\": \"04953\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Newport\", \"pcpname\": \"NORTHERN LIGHT HEALTH CENTER NEWPORT PLAZA\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073685483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"8NM6U52PP89\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Methodist\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-03-2026\", \"time\": \"16:56:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 16:32:00\"}', NULL, NULL, '{\"memberId\": \"10000035203\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Sun, 15 Feb 2026 18:38:21 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1) I see in the med list patient is taking Eliquis for history of PE, can you add the history of PE to the respiratory assessment of diagnosis since patient is\\nstill taking blood thinner for this.\\n\\nthank you! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 16 Feb 2026 21:25:51 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Done!\"}, \"mailId\": \"\"}], \"memberName\": \"Linda Dorman\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/06/2026 01:30 PM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"n.schaaf@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 04:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"2/3/2026 @ 04:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"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\": 10000035203, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000035203}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000035203, \"scheduleDate\": \"2026-02-06T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:46\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:06:57\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"515fec52-8cdd-4264-96a4-6d237ab1f11d\\\",\\\"destination_fax_number\\\":\\\"12073685483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"515fec52-8cdd-4264-96a4-6d237ab1f11d\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12073685483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2073685483 SVH North\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11: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\\\":239,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":239,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:31.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-06T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:48', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035203\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Dorman_10000035203_02062026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:56\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000035203.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Dorman_10000035203_02062026.pdf', NULL, 'Summary_10000035203.pdf', NULL, '[{\"date\": \"2026-02-08T18:12:40.137Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-16T21:25:51.519Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-06T15:00', 'Member_Summary_10000035203.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035203\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000035203.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:57\"}', 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
(69, 55499828, 44829497, '22140773', '10000035204', '', '', '14133640', 'John', 'Dorman', 'English', '', '{\"DOB\": 17233, \"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\": \"1144347196\", \"Pcp_Zip\": \"04967\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"PITTSFIELD\", \"Pcp_Name\": \"REYNALDO ARCEO\", \"Rank_All\": 1, \"PCP_Phone\": \"2074875154\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8VY1A81TF01\", \"Member_City\": \"EXETER\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE PITTSFIELD\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"EXETER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-03-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"470 SOMERSET AVE\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2074873158\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1022 EXETER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04435\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1022 EXETER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04435\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dorman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 46023, \"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\": \"2072784800\", \"Member_Identification_Number\": \"10000035204\", \"Member_Alternate_Phone_Number\": \"2073792081\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:02\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-08T12:00\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-11T08:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-11T13:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-06T07:09\", \"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-08T12:00\", \"reportStatus_date\": \"2026-02-08T12:00\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-11T13:43\", \"reportStatus_date\": \"2026-02-11T13:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-06T07:09\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:52\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-08T12:00\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-08T12:00\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-11T13:43\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-11T08:02\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-11T13:43\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"16:34:32\", \"value\": [{\"add\": \"1022 EXETER RD\", \"age\": 79, \"ano\": \"2073792081\", \"cno\": \"\", \"dob\": \"1947-03-07\", \"eno\": \"2072990806\", \"lob\": \"GA - 2026\", \"pno\": \"2072784800\", \"zip\": \"04435\", \"add2\": \"\", \"add3\": \"\", \"city\": \"EXETER\", \"gend\": 0, \"insh\": \"10000035204\", \"mzip\": \"04435\", \"name\": \"John R Dorman\", \"plan\": \"Martin\'s Point\", \"pphy\": \"REYNALDO ARCEO\", \"ppno\": \"2074875154\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Kenneth Dorman - son\", \"madd1\": \"1022 EXETER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"EXETER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"470 SOMERSET AVE\", \"pcpnpi\": \"1144347196\", \"pcpzip\": \"04967\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PITTSFIELD\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE PITTSFIELD\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074873158\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Somerset\", \"medicaidid\": \"\", \"medicareid\": \"8VY1A81TF01\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-03-2026\", \"time\": \"16:53:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 16:34:32\"}', 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\": 10000035204, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000035204}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000035204, \"scheduleDate\": \"2026-02-06T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:47\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:01\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"557e1958-29c1-4ce9-8a9c-6f496e6d747c\\\",\\\"destination_fax_number\\\":\\\"12074873158\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"557e1958-29c1-4ce9-8a9c-6f496e6d747c\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12074873158\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2074873158 SVH North\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:37.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\\\":246,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":246,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:37.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-06T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:49', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035204\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Dorman_10000035204_02062026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:00\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000035204.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Dorman_10000035204_02062026.pdf', NULL, 'Summary_10000035204.pdf', NULL, '[{\"date\": \"2026-02-08T17:00:03.548Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-06T16:03', 'Member_Summary_10000035204.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035204\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000035204.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:01\"}', 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
(70, 57818338, 44829497, '39698290', '10000035317', '', '', '14133640', 'Morris', 'Bernaiche', 'English', '', '{\"DOB\": 15035, \"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\": \"1992291249\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"Bergeron Poulin\", \"Rank_All\": 1, \"PCP_Phone\": 2076936106, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7EQ1AM7FW90\", \"Member_City\": \"Naples\", \"Office_Name\": \"NAPLES FAMILY PRACTICE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Naples\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-02-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"76 High St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2076934026, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"426 LAKE HOUSE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04055\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"426 LAKE HOUSE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04055\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bernaiche\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Morris\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"mbernaiche@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\": \"Yes\", \"Member_Primary_Phone_Number\": 2076931092, \"Member_Identification_Number\": \"10000035317\", \"Member_Alternate_Phone_Number\": 2072720297, \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:05\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-22T16:33\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-25T23:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T03:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [{\"date\": \"2026-02-19T20:16\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-16T21:47\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-19T20:17\", \"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\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-16T21:47\", \"reportStatus_date\": \"2026-02-16T21:47\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-22T16:33\", \"reportStatus_date\": \"2026-02-22T16:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T03:05\", \"reportStatus_date\": \"2026-02-26T03:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-19T20:16\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-16T21:47\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-19T20:17\", \"username\": \"AWalsh\"}], \"qaAssigned\": [{\"date\": \"2026-02-23T17:27\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-22T16:33\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-22T16:33\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-25T15:19\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T03:05\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-25T23:51\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T03:05\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-24T12:00\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"16:39:37\", \"value\": [{\"add\": \"426 LAKE HOUSE RD\", \"age\": 85, \"ano\": 2072720297, \"cno\": \"\", \"dob\": \"1941-02-28\", \"eno\": \"2076931092\", \"lob\": \"GA - 2026\", \"pno\": 2076931092, \"zip\": \"04055\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Naples\", \"gend\": 0, \"insh\": \"10000035317\", \"mzip\": \"04055\", \"name\": \"Morris J Bernaiche\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Bergeron Poulin\", \"ppno\": 2076936106, \"cliId\": \"\", \"email\": \"mbernaiche@yahoo.com\", \"ename\": \"Madeline \", \"madd1\": \"426 LAKE HOUSE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Naples\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 High St\", \"pcpnpi\": 1992291249, \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"NAPLES FAMILY PRACTICE\", \"program\": \"Medicare\", \"pcpfaxno\": 2076934026, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7EQ1AM7FW90\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"Male\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-19-2026\", \"time\": \"20:17:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 16:39:37\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-19T20:16\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"10000035317\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Tue, 24 Feb 2026 17:00:14 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra\\n1.  Demographics marital status needs answer.\\n2.  Medications allergies needs answer.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 25 Feb 2026 20:19:14 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Completed.\"}, \"mailId\": \"\"}], \"memberName\": \"Morris Bernaiche\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/03/2026 10:30 AM\", \"clinicianMailId\": \"s.cadwell@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\": 10000035317, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000035317}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000035317, \"scheduleDate\": \"2026-02-03T10:30:00\"}}', NULL, '{\"date\": \"02-19-2026 20:16:05\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 0}', '{\"orderType\": 1, \"sortOrder\": 1771550165}', 1, NULL, '[{\"date\": \"2026-03-03 17:07:05\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"d8dece23-fdc9-4935-bafc-8838fb307300\\\",\\\"destination_fax_number\\\":\\\"12076934026\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"d8dece23-fdc9-4935-bafc-8838fb307300\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12076934026\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:46.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":2,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":289,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:25.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:07:48.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:09:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":289,\\\"start_timestamp\\\":\\\"2026-03-03T22:13:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:46.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:49', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035317\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Bernaiche_10000035317_02032026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:04\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000035317.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Bernaiche_10000035317_02032026.pdf', NULL, 'Summary_10000035317.pdf', NULL, '[{\"date\": \"2026-02-22T21:33:51.697Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-25T20:19:13.884Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-09T11:29', 'Member_Summary_10000035317.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035317\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000035317.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:05\"}', 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
(71, 71932120, 44829497, '22140773', '10000035931', '', '', '14133640', 'Reginald', 'Burke', 'English', '', '{\"DOB\": 17908, \"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\": \"1396204707\", \"Pcp_Zip\": \"04412\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Brewer\", \"Pcp_Name\": \"EMILY THERMOS\", \"Rank_All\": 1, \"PCP_Phone\": \"2079891567\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5H30NX0UW38\", \"Member_City\": \"ETNA\", \"Office_Name\": \"BREWER MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"ETNA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-01-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"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\": \"224 BURKE LANE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04434\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"224 BURKE LANE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04434\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Burke\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Reginald\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"mammylu@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\": \"Yes\", \"Member_Primary_Phone_Number\": \"2074785538\", \"Member_Identification_Number\": \"10000035931\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:10\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-04T12:26\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-12T16:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-12T17:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-04T08:28\", \"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-09T17:25\", \"reportStatus_date\": \"2026-02-04T12:26\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-12T17:26\", \"reportStatus_date\": \"2026-02-12T17:26\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T08:28\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-04T18:55\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-04T12:26\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-04T12:26\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-09T17:21\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-09T17:24\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-12T05:48\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-12T17:26\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-12T16:06\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-12T17:26\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-09T17:25\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"16:42:13\", \"value\": [{\"add\": \"224 BURKE LANE\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-01-10\", \"eno\": \"2077452805\", \"lob\": \"GA - 2026\", \"pno\": \"2074785538\", \"zip\": \"04434\", \"add2\": \"\", \"add3\": \"\", \"city\": \"ETNA\", \"gend\": 0, \"insh\": \"10000035931\", \"mzip\": \"04434\", \"name\": \"Reginald C Burke\", \"plan\": \"Martin\'s Point\", \"pphy\": \"EMILY THERMOS\", \"ppno\": \"2079891567\", \"cliId\": \"\", \"email\": \"mammylu@yahoo.com\", \"ename\": \"Gail Burke - wife\", \"madd1\": \"224 BURKE LANE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"ETNA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"735 Wilson St\", \"pcpnpi\": \"1396204707\", \"pcpzip\": \"04412\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Brewer\", \"pcpname\": \"BREWER MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079892286\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"5H30NX0UW38\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-03-2026\", \"time\": \"16:23:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 16:42:13\"}', NULL, NULL, '{\"memberId\": \"10000035931\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Mon, 09 Feb 2026 22:25:44 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Please add statin and steroids to long term use in the allergies/medication section of the HRA.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 12 Feb 2026 10:48:04 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Reginald Burke\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/04/2026 09:00 AM\", \"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\": 10000035931, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000035931}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000035931, \"scheduleDate\": \"2026-02-04T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:47\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:09\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"6dcb8418-cd68-4a03-9125-5aa08dcf7f8e\\\",\\\"destination_fax_number\\\":\\\"12079892286\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"6dcb8418-cd68-4a03-9125-5aa08dcf7f8e\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12079892286\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"12079892286\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:33.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":2,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":324,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:07:59.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:10:07.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:29.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":324,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:33.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-04T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:49', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035931\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Burke_10000035931_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:08\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000035931.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Burke_10000035931_02042026.pdf', NULL, 'Summary_10000035931.pdf', NULL, '[{\"date\": \"2026-02-04T17:26:02.996Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-12T10:48:03.696Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T10:45', 'Member_Summary_10000035931.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000035931\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000035931.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:09\"}', 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
(72, 62035418, 44829497, '34707077', '10000036259', '', '', '14133640', 'Ann', 'Brann', 'English', '', '{\"DOB\": 18219, \"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\": \"1720890122\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"MARGARET LOTHIAN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2G52V06FP15\", \"Member_City\": \"Portland\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Portland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-11-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"100 STATE ST APT 228\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04101\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"100 STATE ST APT 228\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04101\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Brann\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ann\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Declined@07212020.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2077123767\", \"Member_Identification_Number\": \"10000036259\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:07:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:07:14\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-15T16:22\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-23T17:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T18:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-13T19:28\", \"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-15T16:22\", \"reportStatus_date\": \"2026-02-15T16:22\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T18:20\", \"reportStatus_date\": \"2026-02-23T18:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:07\", \"reportStatus_date\": \"2026-03-03T17:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:07\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-13T19:28\", \"username\": \"JDoughty\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:27\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-15T16:22\", \"username\": \"JDoughty\"}, {\"date\": \"2026-02-15T16:22\", \"username\": \"JDoughty\"}, {\"date\": \"2026-02-17T18:53\", \"username\": \"NSchaaf\"}, {\"date\": \"2026-02-23T17:36\", \"username\": \"JDoughty\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T18:20\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T17:41\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T18:20\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-17T18:55\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"16:44:28\", \"value\": [{\"add\": \"100 STATE ST APT 228\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-11-17\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2077123767\", \"zip\": \"04101\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Portland\", \"gend\": 1, \"insh\": \"10000036259\", \"mzip\": \"04101\", \"name\": \"Ann M Brann\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MARGARET LOTHIAN\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"Declined@07212020.com\", \"ename\": \"Pt did not give one\", \"madd1\": \"100 STATE ST APT 228\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Portland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"331 Veranda St\", \"pcpnpi\": \"1720890122\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2G52V06FP15\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-15-2026\", \"time\": \"16:19:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 16:44:28\"}', NULL, NULL, '{\"memberId\": \"10000036259\", \"clinician\": \"Jessica Doughty\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Tue, 17 Feb 2026 23:55:38 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Jessica,\\n\\n1) can you add emergency contact, if patient does not have or did not give one you can type none given in text box\\n2) for the KATZ index, the scores should not be \\\"0\\\", ranges from 1-5\\n3) can you answer yes/no for over the counter medications in medication section\\n4) also for the long term use medications can you answer yes/no, since patient is on statin typically we add those here if \\nbeen on long term\\n5) in the medication section can you answer questions about medication compliance.\\n6) since patient is taking medications for HLD and HTN please add to cardiac assessment of diagnosis with supported by data boxes selected\\n7) since patient is taking insomnia medication can you add to neuro assessment of diagnosis with supported by data boxes selected\\n8) in the assessment of diagnosis section can you select yes/no for hematology and cancer sections\\n9) does patient need referral for elevated BP and falls?\\n\\nthank you! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 22:36:54 GMT\", \"name\": \"Jessica \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Hi Natalie:\\nThank you so much for this and I have corrected the issues you enumerated.\\nI don\'t believe she needs a case management referral for the falls and HTN as she is in regular f/u w/her PCP on these things and has a visit booked for this week with her, as is documented in the HRA.\\nPlease let me know if you feel differently and why.\\n\\nThanks again!\\n\\n\\n-Jess\"}, \"mailId\": \"\"}], \"memberName\": \"Ann Brann\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/14/2026 02:00 PM\", \"clinicianMailId\": \"j.doughty@focuscares.com\", \"qaAnalystMailId\": \"n.schaaf@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\": 10000036259, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"34707077\", \"memberId\": 10000036259}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"34707077\", \"memberId\": 10000036259, \"scheduleDate\": \"2026-02-14T14:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:47\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:07:13\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"247f9e65-c589-459d-8e4c-273a79aee665\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"247f9e65-c589-459d-8e4c-273a79aee665\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552411835 14      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:02.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\\\":251,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":251,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:32.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:02.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-14T14:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:49', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000036259\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Brann_10000036259_02142026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:07:12\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000036259.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Brann_10000036259_02142026.pdf', NULL, 'Summary_10000036259.pdf', NULL, '[{\"date\": \"2026-02-15T21:22:18.911Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T22:36:54.555Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-14T15:12', 'Member_Summary_10000036259.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000036259\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000036259.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:07:13\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
