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
(169, 55499828, 44829497, '22140773', '10000082298', '', '', '14133640', 'Chester', 'Michaud', 'English', '', '{\"DOB\": 11287, \"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\": \"1407127475\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"SANJAY PANDEY\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073300\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1GN0XY6DA10\", \"Member_City\": \"BRADFORD\", \"Office_Name\": \"ST JOSEPH INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRADFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1930-11-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"900 Broadway\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079071923\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"115 MAINE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04410\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"115 MAINE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04410\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Michaud\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Chester\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44197, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@12122024.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\": \"2073271440\", \"Member_Identification_Number\": \"10000082298\", \"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:11:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:05\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-16T15:18\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T19:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T20:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-15T13:00\", \"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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T15:18\", \"reportStatus_date\": \"2026-02-16T15:18\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T20:54\", \"reportStatus_date\": \"2026-02-19T20:54\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-15T13:00\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T09:35\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T16:01\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-16T15:18\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-16T15:18\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T20:54\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T19:10\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T20:54\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"14:59:23\", \"value\": [{\"add\": \"115 MAINE RD\", \"age\": 95, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1930-11-25\", \"eno\": \"2079914240\", \"lob\": \"GA - 2026\", \"pno\": \"2073271440\", \"zip\": \"04410\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRADFORD\", \"gend\": 0, \"insh\": \"10000082298\", \"mzip\": \"04410\", \"name\": \"Chester R Michaud\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SANJAY PANDEY\", \"ppno\": \"2079073300\", \"cliId\": \"\", \"email\": \"declined@12122024.com\", \"ename\": \"Regenia Michaud - wife\", \"madd1\": \"115 MAINE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRADFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"900 Broadway\", \"pcpnpi\": \"1407127475\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"ST JOSEPH INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079071923\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"1GN0XY6DA10\", \"currentgend\": \"Male\", \"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-12-2026\", \"time\": \"15:42:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 14:59:23\"}', 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\": 10000082298, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000082298}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000082298, \"scheduleDate\": \"2026-02-16T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:11\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:04\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e7472077-9dbd-4dbd-a140-4b57386d06bd\\\",\\\"destination_fax_number\\\":\\\"12079071923\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"e7472077-9dbd-4dbd-a140-4b57386d06bd\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12079071923\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:47.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\\\":245,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":245,\\\"start_timestamp\\\":\\\"2026-03-03T22:11:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:47.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-16T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:16', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000082298\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Michaud_10000082298_02162026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:04\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000082298.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Michaud_10000082298_02162026.pdf', NULL, 'Summary_10000082298.pdf', NULL, '[{\"date\": \"2026-02-16T20:18:33.090Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-16T13:28', 'Member_Summary_10000082298.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000082298\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000082298.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11: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
(170, NULL, NULL, '17537038', '10000082532', '', '', '14133640', 'Donna', 'Kane', 'English', '', '{\"DOB\": 17257, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1760644082\", \"Pcp_Zip\": \"46091625\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BAR HARBOR\", \"Pcp_Name\": \"HANKE, TANYA\", \"Rank_All\": 1, \"PCP_Phone\": \"2072445630\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7NE8RT9CW29\", \"Member_City\": \"BAR HARBOR\", \"Office_Name\": \"MDI COMMUNITY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BAR HARBOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-03-31\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"10 WAYMAN LN,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"240 STATE HIGHWAY 3\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04609\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"240 STATE HIGHWAY 3\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04609\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Kane\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donna\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"hummingbirdsuites@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072889405\", \"Member_Identification_Number\": \"10000082532\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2078011933\"}', 'client_014', '2026', '', '{\"hraStatus\":1,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'0', '{\"date\": \"04-06-2026 11:17:23\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}', '{\"date\": \"2026-04-06 11:17:23\", \"hrastatus\": \"\", \"reportstatus\": \"Scheduled\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-02T18:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-05T19:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-24T10:51\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-31T07:14\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-04-06T11:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-02T10:51\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [{\"date\": \"2026-02-12T14:37\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-27T14:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-02T18:58\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-01T10:12\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [{\"date\": \"2026-03-31T16:45\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-02T10:51\", \"reportStatus_date\": \"2026-02-02T10:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-05T19:09\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T14:37\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T18:58\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-24T10:51\", \"reportStatus_date\": \"2026-03-24T10:51\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-04-06T11:17\", \"reportStatus_date\": \"2026-04-06T11:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-03-31T16:45\", \"username\": \"JCummings\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-03-24T10:51\", \"username\": null}, {\"date\": \"2026-03-24T10:51\", \"username\": \"FBeckford\"}, {\"date\": \"2026-04-06T11:17\", \"username\": null}, {\"date\": \"2026-04-06T11:17\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-03-31T07:14\", \"username\": \"JCummings\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-02T10:51\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:24:48\", \"value\": [{\"add\": \"240 STATE HIGHWAY 3\", \"age\": 79, \"ano\": \"\", \"cno\": \"2078011933\", \"dob\": \"1947-03-31\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072889405\", \"zip\": \"04609\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BAR HARBOR\", \"gend\": 1, \"insh\": \"10000082532\", \"mzip\": \"04609\", \"name\": \"Donna R Kane\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HANKE, TANYA\", \"ppno\": \"2072445630\", \"cliId\": \"\", \"email\": \"hummingbirdsuites@icloud.com\", \"ename\": \"\", \"madd1\": \"240 STATE HIGHWAY 3\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BAR HARBOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"10 WAYMAN LN,\", \"pcpnpi\": \"1760644082\", \"pcpzip\": \"46091625\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BAR HARBOR\", \"pcpname\": \"MDI COMMUNITY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7NE8RT9CW29\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"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\": \"03-30-2026\", \"time\": \"14:34:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 11:47:55\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-03-31T16:45\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JCummings\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-02T10:51\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"member cancellation\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/6/2026 @ 11:17 AM\", \"result\": 0, \"comment\": \"scheduled with amanda millikin 4/12/2026 @ 12:00pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/1/2026 @ 10:12 AM\", \"result\": 10, \"comment\": \"o/c to reschedule appt w/Julie C - line is disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"4/2/2026 @ 10:12 AM\"}, {\"date\": \"3/24/2026 @ 10:51 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Julie on March 31st at 04:30PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 10:44 AM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 12:55 PM\", \"result\": 10, \"comment\": \"03/20/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 01:51 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Erin number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 04:59 PM\", \"result\": 10, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 06:43 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 06:58 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:52 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 02:52 PM\"}, {\"date\": \"2/12/2026 @ 02:37 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Candace caller disconnected.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/16/2026 @ 02:37 PM\"}, {\"date\": \"2/5/2026 @ 07:09 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/9/2026 @ 07:09 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000082532\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000082532\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000082532\", \"scheduleDate\": \"2026-4-12T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 19:09:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"04-06-2026 11:17:23\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, NULL, 'Virtual', '2026-4-12T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(171, NULL, NULL, NULL, '10000082757', '', '', '1019044', 'Pennell', 'Worcester', '', '', '{\"DOB\": 18373, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1689779092\", \"Pcp_Zip\": \"04055\", \"Program\": \"Medicare\", \"Pcp_City\": \"Naples\", \"Pcp_Name\": \"BARTER, STEPHEN\", \"Rank_All\": 1, \"PCP_Phone\": \"2076933912\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3FN9CC0HK56\", \"Member_City\": \"NAPLES\", \"Office_Name\": \"STEPHEN BARTER MD\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"NAPLES\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-04-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO Box 1515,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076933453\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"336 EDES FALLS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04055\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"336 EDES FALLS RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04055\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Worcester\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Pennell\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"penn622@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072320747\", \"Member_Identification_Number\": \"10000082757\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-05-2026 12:38:26\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}', '{\"date\": \"2026-02-05 12:38:26\", \"hrastatus\": \"\", \"reportstatus\": \"Ineligible\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-02-05T12:38\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-02-05T12:38\", \"reportStatus_date\": \"2026-02-05T12:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-02-05T12:38\", \"username\": \"FBeckford\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:24:56\", \"value\": [{\"add\": \"336 EDES FALLS RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-04-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072320747\", \"zip\": \"04055\", \"add2\": \"\", \"add3\": \"\", \"city\": \"NAPLES\", \"gend\": 0, \"insh\": \"10000082757\", \"mzip\": \"04055\", \"name\": \"Pennell L Worcester\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BARTER, STEPHEN\", \"ppno\": \"2076933912\", \"cliId\": \"\", \"email\": \"penn622@yahoo.com\", \"ename\": \"\", \"madd1\": \"336 EDES FALLS RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"NAPLES\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO Box 1515,\", \"pcpnpi\": \"1689779092\", \"pcpzip\": \"04055\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Naples\", \"pcpname\": \"STEPHEN BARTER MD\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076933453\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3FN9CC0HK56\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:24:56\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"2/5/2026 @ 12:38 PM\", \"result\": 2, \"comment\": \"Called to Schedule F2F HRA with Sandra but member is ineligible. Member stated he was already scheduled possibly with somone else   \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 12:38:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"01-31-2026 23:30:03\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:17', 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
(172, 71932120, 44829497, '71460194', '10000083908', '', '', '14133640', 'Nancy', 'Reynolds', 'English', '', '{\"DOB\": 19259, \"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\": \"1568469401\", \"Pcp_Zip\": \"04530\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BATH\", \"Pcp_Name\": \"AMY ETZWEILER\", \"Rank_All\": 1, \"PCP_Phone\": \"2073861800\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8GK6MC4VA67\", \"Member_City\": \"Sabattus\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Sabattus\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-09-22\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"108 CENTRE ST\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2074429822\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"18 NILES RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04280\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"18 NILES RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04280\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Reynolds\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nancy\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"nancytreynolds@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\": \"No\", \"Member_Primary_Phone_Number\": \"4074618944\", \"Member_Identification_Number\": \"10000083908\", \"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:11:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:12\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-20T17:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T12:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T14:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T14:20\", \"reportStatus_date\": \"2026-02-23T14:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [{\"date\": \"2026-02-20T11:15\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-20T16:05\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-20T16:08\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-20T16:11\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-20T17:31\", \"username\": \"AWalsh\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T14:20\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T12:16\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T14:20\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-20T16:33\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:01:55\", \"value\": [{\"add\": \"18 NILES RD\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-09-22\", \"eno\": \"2078440375\", \"lob\": \"GA - 2026\", \"pno\": \"4074618944\", \"zip\": \"04280\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Sabattus\", \"gend\": 1, \"insh\": \"10000083908\", \"mzip\": \"04280\", \"name\": \"Nancy T Reynolds\", \"plan\": \"Martin\'s Point\", \"pphy\": \"AMY ETZWEILER\", \"ppno\": \"2073861800\", \"cliId\": \"\", \"email\": \"nancytreynolds@aol.com\", \"ename\": \"Randee Reynolds\", \"madd1\": \"18 NILES RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Sabattus\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"108 CENTRE ST\", \"pcpnpi\": \"1568469401\", \"pcpzip\": \"04530\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"BATH\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074429822\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8GK6MC4VA67\", \"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\": \"15:55:49\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:01:55\"}', NULL, NULL, '{\"memberId\": \"10000083908\", \"clinician\": \"Samuel Acha\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"2026-02-02T19:33:13.346Z\", \"name\": \"Felecia Copeland\", \"role\": \"QA\", \"files\": [], \"query\": {\"feedback\": \"Please review, reconcile, and resubmit the following within 24hours:GI-\\\"bowel movement\\\"-this appears blank. Please answer.\", \"response\": \"\"}, \"mailId\": \"fcopeland@focuscares.com\"}, {\"date\": \"2026-02-04T12:35:48.936Z\", \"name\": \"Samuel Acha\", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"Completed, thanks.\", \"response\": \"\"}, \"mailId\": \"s.acha@focuscares.com\"}, {\"date\": \"Fri, 20 Feb 2026 21:11:48 GMT\", \"name\": \"MJoseph\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Samuel,\\n\\nAfter the medication list, the entire HRA is incomplete. I don\'t know if there was a glitch that caused this. Please fill out the HRA. I apologize for the inconvenience.\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Feb 2026 21:33:01 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Samuel,\\n\\nAfter the medication list, the entire HRA is incomplete. I don\'t know if there was a glitch that caused this. Please fill out the HRA. I apologize for the inconvenience.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Nancy Reynolds\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/01/2026 09:00 AM\", \"clinicianMailId\": \"s.acha@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 01:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"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\": 10000083908, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000083908}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000083908, \"scheduleDate\": \"2026-02-01T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:12\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:11:10\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"4074a633-be08-4997-abba-425159e6c391\\\",\\\"destination_fax_number\\\":\\\"12074429822\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"4074a633-be08-4997-abba-425159e6c391\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12074429822\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:29:48.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:11:30.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:44.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:14:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:05.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:18:20.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:19:38.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:21:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:02.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:25:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:26:21.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:28:39.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:29:48.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-01T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:17', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000083908\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Reynolds_10000083908_02012026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:09\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000083908.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Reynolds_10000083908_02012026.pdf', NULL, 'Summary_10000083908.pdf', NULL, '[{\"date\": \"2026-02-02T02:58:16.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-01T10:10', 'Member_Summary_10000083908.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000083908\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000083908.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:11\"}', 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
(173, NULL, NULL, '71460194', '10000085450', '', '', '14133640', 'Ronald', 'Herrick', 'English', '', '{\"DOB\": 20568, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1922031657\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"HINE, JENNIFER L\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6MW8D62NQ57\", \"Member_City\": \"SABATTUS\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SABATTUS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1956-04-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077984018\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"25 WALES RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04280\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"25 WALES RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04280\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Herrick\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ronald\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45660, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Rak2005@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072404573\", \"Member_Identification_Number\": \"10000085450\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-13-2026 16:36:00\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-13 16:36:00\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-03-13T16:36\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-25T12:00\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-20T11: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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-20T11:37\", \"reportStatus_date\": \"2026-02-20T11:37\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T12:00\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-13T16:36\", \"reportStatus_date\": \"2026-03-13T16:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-13T16:36\", \"username\": \"AChevalier\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-20T11:37\", \"username\": \"JDingle\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:26:15\", \"value\": [{\"add\": \"25 WALES RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1956-04-23\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072404573\", \"zip\": \"04280\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SABATTUS\", \"gend\": 0, \"insh\": \"10000085450\", \"mzip\": \"04280\", \"name\": \"Ronald W Herrick\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HINE, JENNIFER L\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"Rak2005@roadrunner.com\", \"ename\": \"\", \"madd1\": \"25 WALES RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SABATTUS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1922031657\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077984018\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6MW8D62NQ57\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:26:15\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-13T16:36\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AChevalier\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": [{\"date\": \"2026-02-20T11:37\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 3, \"cancelText\": \"The Member called to cancel the appointment, stating he will not be home at the scheduled time. Call back request at a later time to reschedule.\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/13/2026 @ 04:35 PM\", \"result\": 9, \"comment\": \"does not want to participate\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 12:00 PM\", \"result\": 14, \"comment\": \"o/c to sched F2F w/Sandy 3/26 - member asked for c/b in July\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"7/15/2026 @ 12:00 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000085450, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000085450}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000085450, \"scheduleDate\": \"2026-02-22T12:30:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 12:00:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-20-2026 11:37:28\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, 'In Person', '2026-02-22T12:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:17', 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
(174, 55499828, 44829497, '39698290', '10000086477', '', '', '14133640', 'Shirley', 'Haney', 'English', '', '{\"DOB\": 12771, \"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\": 1306229521, \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"BUSTAMANTE, ANTHONY\", \"Rank_All\": 1, \"PCP_Phone\": 2078469013, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2TE0YA1DT06\", \"Member_City\": \"Cumberland Center\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cumberland Center\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1934-12-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2075238586, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"7 PERIWINKLE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04021\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 PERIWINKLE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04021\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Haney\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shirley\", \"Member_Middle_name\": \"V\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"haneyamma@spectrum.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2074503277\", \"Member_Identification_Number\": \"10000086477\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2074503277}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:50:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:50:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-24T16:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-25T19:51\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-27T13:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-27T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T13:01\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-24T13:40\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-05T09:04\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-05T09:04\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-05T09:04\", \"reportStatus_date\": \"2026-02-05T09:04\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-24T13:01\", \"reportStatus_date\": \"2026-02-24T13:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-27T17:06\", \"reportStatus_date\": \"2026-03-27T17:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:50\", \"reportStatus_date\": \"2026-03-31T13:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:50\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-24T13:01\", \"username\": null}, {\"date\": \"2026-02-24T13:01\", \"username\": \"JDingle\"}], \"inProgress\": [{\"date\": \"2026-03-24T13:40\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-26T10:13\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-25T19:51\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-25T19:51\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-27T06:18\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-27T06:21\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-27T10:47\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-27T17:06\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-27T13:30\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-27T17:06\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-27T06:22\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-05T09:04\", \"username\": \"KCoash\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-25-2026\", \"time\": \"19:13:40\", \"value\": [{\"add\": \"7 PERIWINKLE DR\", \"age\": 91, \"ano\": \"\", \"cno\": 2074503277, \"dob\": \"1934-12-18\", \"eno\": \"2074086178\", \"lob\": \"GA - 2026\", \"pno\": \"2074503277\", \"zip\": \"04021\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Cumberland Center\", \"gend\": 1, \"insh\": \"10000086477\", \"mzip\": \"04021\", \"name\": \"Shirley V Haney\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BUSTAMANTE, ANTHONY\", \"ppno\": 2078469013, \"cliId\": \"\", \"email\": \"haneyamma@spectrum.net\", \"ename\": \"Laura Haney \", \"madd1\": \"7 PERIWINKLE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cumberland Center\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": 1306229521, \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2075238586, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2TE0YA1DT06\", \"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\": \"03-20-2026\", \"time\": \"14:39:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-27-2026 10:47:41\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-05T09:04\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 3, \"cancelText\": \"patient is sick and wasn`t sure she`d be well for her appointment - ok to c/b and reschedule in a couple weeks\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"10000086477\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 27 Mar 2026 10:22:58 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\n1) Under the Endocrine section for diabetic retinopathy I would remove it, if the member said he hasn\'t been diagnosed with it, I looked in the PAF and couldn\'t fine retinopathy previously coded in there\\n2) can you add information in the patient summary at the very Bottom of the HRA \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 27 Mar 2026 14:47:41 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"thank you!  Completed\"}, \"mailId\": \"\"}], \"memberName\": \"Shirley Haney\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/24/2026 01:30 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/24/2026 @ 01:01 PM\", \"result\": 0, \"comment\": \"Scheduled F2F W/Sandra Cadwell 3/24 at 130 PM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 09:04 AM\", \"result\": 14, \"comment\": \"call back to reschedule - mbr cx due to illness and not wanting to risk seeing the nurse while she is still sick.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/19/2026 @ 09:04 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000086477\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000086477\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000086477\", \"scheduleDate\": \"2026-3-24T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 09:04:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-24-2026 13:01:19\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:50:55\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"1b1a817a-2670-46be-852e-0c45117a173c\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"1b1a817a-2670-46be-852e-0c45117a173c\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:03: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-31T17:51:09.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:51:30.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T17:53:50.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:54:05.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T17:56:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:56:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T17:58:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:58:58.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:01:13.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:01:26.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:03:40.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:03:55.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-24T13:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:17', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000086477\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Haney_10000086477_03242026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:50:55\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000086477.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Haney_10000086477_03242026.pdf', NULL, 'Summary_10000086477.pdf', NULL, '[{\"date\": \"2026-03-25T23:51:31.342Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-27T14:47:39.140Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-24T14:39', 'Member_Summary_10000086477.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000086477\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000086477.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:50:56\"}', 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
(175, NULL, NULL, '22140773', '10000087356', '', '', '14133640', 'Scott', 'Clukey', 'English', '', '{\"DOB\": 20653, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1912211483\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"ROXAS, SHARON K\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3YK7VN7WD49\", \"Member_City\": \"DEXTER\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DEXTER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1956-07-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"900 Broadway, Building 3\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079073778\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"47 RAILROAD AVE\", \"Member_Address2\": \"154 Railroad Ave\", \"Member_Zip_Code\": \"04930\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 511\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04930\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Clukey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Scott\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"clukeys56@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077179396\", \"Member_Identification_Number\": \"10000087356\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\": 2, \"subStatus\": \"\", \"cancelStatus\": \"\",\"cancelText\": \"\"}', 2, b'0', b'0', '{\"date\": \"04-08-2026 18:06:25\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}', '{\"date\": \"2026-04-08 18:06:25\", \"hrastatus\": \"\", \"reportstatus\": \"Scheduled\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-18T14:08\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-20T13:00\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-12T10:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-14T16:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-16T14:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-17T13:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-18T14:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-02T10:44\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-08T18:06\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-03-02T14:37\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-03-08T21:23\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-06T10:52\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-03-09T15:07\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-06T10:52\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-06T10:52\", \"reportStatus_date\": \"2026-02-06T10:52\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-02T14:37\", \"reportStatus_date\": \"2026-03-02T14:37\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-09T15:07\", \"reportStatus_date\": \"2026-03-09T15:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-16T14:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-20T13:00\", \"reportStatus_date\": \"2026-03-20T13:00\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-04-02T10:44\", \"reportStatus_date\": \"2026-04-02T10:44\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-04-08T18:06\", \"reportStatus_date\": \"2026-04-08T18:06\"}]', '{\"utc\": [{\"date\": \"2026-03-20T13:00\", \"username\": \"JCopeland\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-03-02T14:37\", \"username\": null}, {\"date\": \"2026-03-02T14:37\", \"username\": \"JDingle\"}, {\"date\": \"2026-04-02T10:44\", \"username\": null}, {\"date\": \"2026-04-02T10:44\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-03-08T21:23\", \"username\": \"AMilliken\"}, {\"date\": \"2026-04-08T18:06\", \"username\": \"EBarker\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-06T10:52\", \"username\": \"LAnguiano\"}, {\"date\": \"2026-03-09T15:07\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"14:24:26\", \"value\": [{\"add\": \"47 RAILROAD AVE\", \"age\": 69, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1956-07-17\", \"eno\": \"2079247027\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077179396\", \"zip\": \"04930\", \"add2\": \"154 Railroad Ave\", \"add3\": \"\", \"city\": \"DEXTER\", \"gend\": 0, \"insh\": \"10000087356\", \"mzip\": \"04930\", \"name\": \"Scott L Clukey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ROXAS, SHARON K\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"clukeys56@gmail.com\", \"ename\": \"Jackie Clukey - mother\", \"madd1\": \"PO BOX 511\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DEXTER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"900 Broadway, Building 3\", \"pcpnpi\": \"1912211483\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Bangor\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079073778\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"3YK7VN7WD49\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"12:05:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 15:46:01\"}', '{\"utc\": [{\"date\": \"2026-03-20T13:00\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JCopeland\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-06T10:52\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 3, \"cancelText\": \"member is sick\", \"cancelStatus\": 0}, {\"date\": \"2026-03-09T15:07\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"member did not present for appointment or return VM from provider. please contact to reschedule\", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/2/2026 @ 10:44 AM\", \"result\": 0, \"comment\": \"Erin 4/9 at 2 pm - member is staying at his mothers house at 154 Railroad Ave in Dexter after an accident at his house\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 11:54 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin B 4/8\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 02:15 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 01:00 PM\", \"result\": 6, \"comment\": \"03/20/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken, NOT HOME \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:08 PM\", \"result\": 3, \"comment\": \"03/18/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 01:51 PM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/18/2026 @ 01:50 PM\"}, {\"date\": \"3/16/2026 @ 02:09 PM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/17/2026 @ 02:08 PM\"}, {\"date\": \"3/14/2026 @ 04:58 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amand, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"3/31/2026 @ 02:58 PM\"}, {\"date\": \"3/12/2026 @ 10:47 AM\", \"result\": 3, \"comment\": \"LVM to reschedule cx appt from 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/13/2026 @ 10:47 AM\"}, {\"date\": \"3/2/2026 @ 02:37 PM\", \"result\": 12, \"comment\": \"Scheduled rescheduled w/Amanda Milliken 3/9 at 8 AM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 10:52 AM\", \"result\": 6, \"comment\": \"Member called in to cancel appt he has covid wants call back in a few weeks \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 10:52 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000087356\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": \"10000087356\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": \"10000087356\", \"scheduleDate\": \"2026-4-9T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 10:52:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"04-02-2026 10:44:57\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 0, NULL, NULL, 'In Person', '2026-4-9T14:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-09T15:45', NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(176, NULL, NULL, NULL, '10000089890', '', '', '47262451', 'Joanne', 'Conant', '', '', '{\"DOB\": 15331, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1861451080\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"PIERCE, DANIEL C\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9CF3RV0WK91\", \"Member_City\": \"TURNER\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"TURNER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-12-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"197B HOWES CORNER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04282\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"197B HOWES CORNER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04282\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Conant\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joanne\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Ccgoodwin21@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"4802397740\", \"Member_Identification_Number\": \"10000089890\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-09-2026 18:35:08\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-09 18:35:08\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-09T18:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T12:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T11:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T17:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T11:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T18:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T17:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T11:52\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T18:35\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:28:39\", \"value\": [{\"add\": \"197B HOWES CORNER RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1941-12-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"4802397740\", \"zip\": \"04282\", \"add2\": \"\", \"add3\": \"\", \"city\": \"TURNER\", \"gend\": 1, \"insh\": \"10000089890\", \"mzip\": \"04282\", \"name\": \"Joanne M Conant\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PIERCE, DANIEL C\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"Ccgoodwin21@gmail.com\", \"ename\": \"\", \"madd1\": \"197B HOWES CORNER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"TURNER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": \"1861451080\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9CF3RV0WK91\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:28:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/24/2026 @ 12:27 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy-call dropped \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 01:03 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:09 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 04:50 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 02:04 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 06:35 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 11:52 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 05:51 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/11/2026 @ 05:51 PM\"}, {\"date\": \"2/5/2026 @ 11:11 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/9/2026 @ 11:11 AM\"}, {\"date\": \"2/4/2026 @ 12:55 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/6/2026 @ 12:54 PM\"}, {\"date\": \"2/3/2026 @ 04:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 12:55:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-09-2026 18:35:08\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:18', 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
(177, 62035418, 44829497, '12383693', '10000091633', '', '', '14133640', 'Donald', 'Tompkins', 'English', '', '{\"DOB\": 18951, \"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\": 1508975152, \"Pcp_Zip\": \"04917\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BELGRADE\", \"Pcp_Name\": \"AMY MADDEN\", \"Rank_All\": 1, \"PCP_Phone\": 2076261561, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8PG2QT5EY03\", \"Member_City\": \"Waterville\", \"Office_Name\": \"BELGRADE REGIONAL HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waterville\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-11-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 274\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2074953353, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 PLEASANTDALE AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 PLEASANTDALE AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Tompkins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Member_Middle_name\": \"G\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"dgtompkins1951@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2078727777, \"Member_Identification_Number\": \"10000091633\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:11:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:18\", \"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-25T16:47\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-28T12:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-01T21:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T13:19\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-24T22:22\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-25T11:08\", \"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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-01T21:52\", \"reportStatus_date\": \"2026-03-01T21:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-24T22:22\", \"username\": \"AWalsh\"}], \"inProgress\": [{\"date\": \"2026-02-24T13:19\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-25T11:08\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-02-26T11:31\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-25T16:47\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-25T16:47\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-01T21:52\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-28T12:40\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-01T21:52\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:07:54\", \"value\": [{\"add\": \"15 PLEASANTDALE AVE\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-11-19\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2078727777, \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Waterville\", \"gend\": 0, \"insh\": \"10000091633\", \"mzip\": \"04901\", \"name\": \"Donald G Tompkins\", \"plan\": \"Martin\'s Point\", \"pphy\": \"AMY MADDEN\", \"ppno\": 2076261561, \"cliId\": \"\", \"email\": \"dgtompkins1951@icloud.com\", \"ename\": \"\", \"madd1\": \"15 PLEASANTDALE AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waterville\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 274\", \"pcpnpi\": 1508975152, \"pcpzip\": \"04917\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"BELGRADE\", \"pcpname\": \"BELGRADE REGIONAL HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": 2074953353, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8PG2QT5EY03\", \"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-24-2026\", \"time\": \"13:19:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:07:54\"}', 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\": 10000091633, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": 10000091633}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": 10000091633, \"scheduleDate\": \"2026-02-25T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:13\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:16\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"755cd1d0-7167-4f6a-a1a9-40acc0bce4b5\\\",\\\"destination_fax_number\\\":\\\"12074953353\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"755cd1d0-7167-4f6a-a1a9-40acc0bce4b5\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12074953353\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:32.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\\\":235,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":235,\\\"start_timestamp\\\":\\\"2026-03-03T22:11:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:32.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-25T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:18', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000091633\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Tompkins_10000091633_02252026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:15\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000091633.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Tompkins_10000091633_02252026.pdf', NULL, 'Summary_10000091633.pdf', NULL, '[{\"date\": \"2026-02-25T21:47:15.140Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-25T12:17', 'Member_Summary_10000091633.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000091633\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000091633.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:17\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(178, NULL, NULL, '39698290', '10000073795', '', '', '14133640', 'Marcia', 'Noyes', '', '', '{\"DOB\": 19858, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"Y\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1467459032\", \"Pcp_Zip\": \"41052010\", \"Program\": \"Medicare\", \"Pcp_City\": \"FALMOUTH\", \"Pcp_Name\": \"KAZIMIERCZAK, ADAM M\", \"Rank_All\": 1, \"PCP_Phone\": \"2075351340\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2JT7D85XU20\", \"Member_City\": \"CUMBERLAND\", \"Office_Name\": \"NORTHERN LIGHT MERCY PRIMARY CARE WEST FALMOUTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CUMBERLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-05-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"75 GRAY RD,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075351358\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"146 LONGWOODS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04021\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"146 LONGWOODS RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04021\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Noyes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marcia\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@11262025.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"2026-05-14\", \"Member_Primary_Phone_Number\": \"2078293660\", \"Member_Identification_Number\": \"10000073795\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":1,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-25-2026 11:44:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}', '{\"date\": \"2026-03-25 11:44:31\", \"hrastatus\": \"\", \"reportstatus\": \"Scheduled\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-13T17:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T11:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T14:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-17T10:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-25T11:44\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-09T12:19\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-03-18T14:53\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-09T12:19\", \"reportStatus_date\": \"2026-02-09T12:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T17:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-17T11:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T14:00\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-18T14:53\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-25T11:44\", \"reportStatus_date\": \"2026-03-25T11:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-03-25T11:44\", \"username\": null}, {\"date\": \"2026-03-25T11:44\", \"username\": \"LAnguiano\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-09T12:19\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:19:58\", \"value\": [{\"add\": \"146 LONGWOODS RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-05-14\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078293660\", \"zip\": \"04021\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CUMBERLAND\", \"gend\": 1, \"insh\": \"10000073795\", \"mzip\": \"04021\", \"name\": \"Marcia A Noyes\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KAZIMIERCZAK, ADAM M\", \"ppno\": \"2075351340\", \"cliId\": \"\", \"email\": \"declined@11262025.com\", \"ename\": \"\", \"madd1\": \"146 LONGWOODS RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CUMBERLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"75 GRAY RD,\", \"pcpnpi\": \"1467459032\", \"pcpzip\": \"41052010\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"FALMOUTH\", \"pcpname\": \"NORTHERN LIGHT MERCY PRIMARY CARE WEST FALMOUTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075351358\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2JT7D85XU20\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:18\", \"value\": [[[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"Yes\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", null, \"\", \"\", \"\", \"\", \"\", null, null, null, null, null], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]], \"status\": true, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:19:58\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-09T12:19\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"member called in and cancelled\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/25/2026 @ 11:44 AM\", \"result\": 0, \"comment\": \"Member scheduled for IHA and DEXA with Sandy C 4-16-2026 12pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:53 PM\", \"result\": 6, \"comment\": \"Called to schedule IHA and DEXA w/ martins point -with Sandy -for march 24th 12pm member needs call back at an appt \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"3/19/2026 @ 02:53 PM\"}, {\"date\": \"3/17/2026 @ 10:07 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Samuel but member requested a call back.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/20/2026 @ 10:04 AM\"}, {\"date\": \"2/26/2026 @ 02:00 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA and DEXA w/ martins point -LVM w/ Sandy \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/28/2026 @ 02:00 PM\"}, {\"date\": \"2/17/2026 @ 11:59 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA and DEXA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/19/2026 @ 11:59 AM\"}, {\"date\": \"2/13/2026 @ 05:10 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA and DEXA w/ martins point -LVM w/Sandy\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/16/2026 @ 05:10 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000073795\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000073795\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000073795\", \"scheduleDate\": \"2026-4-16T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-13-2026 17:10:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-25-2026 11:44:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, NULL, 'In Person', '2026-4-16T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-14', '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
(179, 55499828, 44829497, '39698290', '10000094732', '', '', '14133640', 'Kenneth', 'Eklund', 'English', '', '{\"DOB\": 18842, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": \"1841569720\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland \", \"Pcp_Name\": \"Ibrahim Ondze Konda Poko\", \"Rank_All\": 1, \"PCP_Phone\": \"2076620111\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1XF2KU5YW29\", \"Member_City\": \"WINDHAM\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-08-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"22 bramhall St, \", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"25 LANTERN LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"25 LANTERN LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Eklund\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kenneth\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@11262024.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\": \"2072101016\", \"Member_Identification_Number\": \"10000094732\", \"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:11:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:25\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-13T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-18T20:08\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-20T15:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-21T22:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T14:14\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-21T22:28\", \"reportStatus_date\": \"2026-02-21T22:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-17T09:30\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-19T12:50\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-18T20:08\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-18T20:08\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-21T22:28\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-20T15:47\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-20T16:38\", \"username\": \"JWren1\"}, {\"date\": \"2026-02-21T12:07\", \"username\": \"SCadwell\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-21T22:28\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [{\"date\": \"2026-02-20T16:38\", \"username\": \"JWren1\"}], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:11:34\", \"value\": [{\"add\": \"25 LANTERN LN\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-08-02\", \"eno\": \"2078940085\", \"lob\": \"GA - 2026\", \"pno\": \"2072101016\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDHAM\", \"gend\": 0, \"insh\": \"10000094732\", \"mzip\": \"04062\", \"name\": \"Kenneth H Eklund\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Ibrahim Ondze Konda Poko\", \"ppno\": \"2076620111\", \"cliId\": \"\", \"email\": \"declined@11262024.com\", \"ename\": \"Susan Eklind/Tanya Vaillancourt\", \"madd1\": \"25 LANTERN LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"22 bramhall St, \", \"pcpnpi\": \"1841569720\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Separated\", \"pcpFlag\": 0, \"pcpcity\": \"Portland \", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"cumberland\", \"medicaidid\": \"\", \"medicareid\": \"1XF2KU5YW29\", \"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-17-2026\", \"time\": \"09:30:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:11:34\"}', NULL, NULL, '{\"memberId\": \"10000094732\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Jared Wren\", \"queryData\": [{\"date\": \"Fri, 20 Feb 2026 21:39:00 GMT\", \"name\": \"Jared \", \"role\": \"coder_lead\", \"files\": [], \"query\": {\"feedback\": \"Hello,\\n\\nThe cancer section states multiple cancers. If possible, could you explain if some of these are secondary? If not known, no action is needed. Also, dementia is listed under the physical exam. If this is an active diagnosis, could you please list it under the Neuro-psyche section? Thank you.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 21 Feb 2026 17:07:46 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"completed. \"}, \"mailId\": \"\"}], \"memberName\": \"Kenneth Eklund\", \"codingAnalyst\": \"\", \"dateOfService\": \"\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"j.wren@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"2/13/2026 @ 02:14 PM\", \"result\": 13, \"comment\": \"Called to schedule HRA w/ Nicole Mattison CALLER DISCONNECTED \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/19/2026 @ 02:14 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000094732, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000094732}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000094732, \"scheduleDate\": \"2026-02-17T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:13\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771493625}', 0, NULL, '[{\"date\": \"2026-03-03 17:11:23\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ea647a61-174d-11f1-bef6-c51380366b84\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-02-17T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:19', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000094732\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Eklund_10000094732_02172026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:23\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000094732.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Eklund_10000094732_02172026.pdf', NULL, 'Summary_10000094732.pdf', NULL, '[{\"date\": \"2026-02-19T01:08:32.670Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-21T17:07:45.733Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-17T10:14', 'Member_Summary_10000094732.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000094732\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000094732.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:24\"}', 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
(180, 55499828, 44829497, '71460194', '10000095937', '', '', '14133640', 'Stephen', 'Bolduc', 'English', '', '{\"DOB\": 19788, \"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\": \"1053387936\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"MICHAEL CLARK\", \"Rank_All\": 1, \"PCP_Phone\": \"2078615000\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7GG5P31PJ51\", \"Member_City\": \"AUGUSTA\", \"Office_Name\": \"MAINE DARTMOUTH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUGUSTA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-03-05\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"149 North St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078615101\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"7 ANNAS WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04330\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 ANNAS WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04330\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bolduc\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephen\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@122225.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\": \"2073140746\", \"Member_Identification_Number\": \"10000095937\", \"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:11:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:32\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-16T11:39\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T18:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T22:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-14T10: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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T11:39\", \"reportStatus_date\": \"2026-02-16T11:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T22:54\", \"reportStatus_date\": \"2026-02-17T22:54\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-14T10:09\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:32\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-16T11:39\", \"username\": \"SAcha\"}, {\"date\": \"2026-02-16T11:39\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T22:54\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T18:45\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T22:54\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:19:51\", \"value\": [{\"add\": \"7 ANNAS WAY\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-03-05\", \"eno\": \"2076497090\", \"lob\": \"GA - 2026\", \"pno\": \"2073140746\", \"zip\": \"04330\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUGUSTA\", \"gend\": 0, \"insh\": \"10000095937\", \"mzip\": \"04330\", \"name\": \"Stephen P Bolduc\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MICHAEL CLARK\", \"ppno\": \"2078615000\", \"cliId\": \"\", \"email\": \"declined@122225.com\", \"ename\": \"Jillian Jolicolur (Daughter)\", \"madd1\": \"7 ANNAS WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUGUSTA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"149 North St\", \"pcpnpi\": \"1053387936\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Waterville\", \"pcpname\": \"MAINE DARTMOUTH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078615101\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7GG5P31PJ51\", \"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-13-2026\", \"time\": \"10:31:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:19:51\"}', 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\": 10000095937, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000095937}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000095937, \"scheduleDate\": \"2026-02-14T10:10:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:13\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:30\", \"status\": 0, \"message\": \"Busy. The destination number was busy.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"68dc9dbf-91da-4dd3-8d88-e453c748dd32\\\",\\\"destination_fax_number\\\":\\\"12078615101\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"68dc9dbf-91da-4dd3-8d88-e453c748dd32\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12078615101\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:48.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:11:43.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:11.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:14:25.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:58.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:17:18.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17: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:19:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:23.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:22:34.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:07.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:25:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:48.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-14T10:10:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:19', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000095937\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Bolduc_10000095937_02142026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:29\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000095937.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Bolduc_10000095937_02142026.pdf', NULL, 'Summary_10000095937.pdf', NULL, '[{\"date\": \"2026-02-16T16:39:49.910Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-14T11:35', 'Member_Summary_10000095937.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000095937\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000095937.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:31\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
