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
(2543, 55499828, 44829497, '17537038', '10000109385', '', '', '543416', 'Alan', 'Collins', 'English', '', '{\"DOB\": 21621, \"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\": 1437127750, \"Pcp_Zip\": \"04938\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"FARMINGTON\", \"Pcp_Name\": \"Taylor Munsch\", \"Rank_All\": 1, \"PCP_Phone\": 2077783326, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1H35QC3PC63\", \"Member_City\": \"WILTON\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WILTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1959-03-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"111 FRANKLIN HEALTH CMNS\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Franklin\", \"Member_Country\": \"Franklin\", \"PCP_Fax_Number\": 2077783102, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"37 PLEASANT VIEW HTS\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04294\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"37 PLEASANT VIEW HTS\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04294\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Collins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alan\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"Acollins1959@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2074585391, \"Member_Identification_Number\": \"10000109385\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:10:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:10:57\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T20:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T17:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T16:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-13T12:34\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-17T12:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T14:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-11T10:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-13T11:16\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"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:13\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-11T10:31\", \"reportStatus_date\": \"2026-02-11T10:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-13T12:34\", \"reportStatus_date\": \"2026-03-13T16:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:10\", \"reportStatus_date\": \"2026-03-17T16:10\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:10\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-11T10:31\", \"username\": null}, {\"date\": \"2026-02-11T10:31\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-03-13T11:16\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:53\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-13T12:34\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-13T12:34\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-17T14:41\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-17T12:59\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-17T14:41\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-10-2026\", \"time\": \"16:16:59\", \"value\": [{\"add\": \"37 PLEASANT VIEW HTS\", \"age\": 67, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-03-12\", \"eno\": \"2075784302\", \"lob\": \"GA - 2026\", \"pno\": 2074585391, \"zip\": \"04294\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WILTON\", \"gend\": 0, \"insh\": \"10000109385\", \"mzip\": \"04294\", \"name\": \"Alan S Collins\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Taylor Munsch\", \"ppno\": 2077783326, \"cliId\": \"\", \"email\": \"Acollins1959@gmail.com\", \"ename\": \"Wife Karen\", \"madd1\": \"37 PLEASANT VIEW HTS\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WILTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"111 FRANKLIN HEALTH CMNS\", \"pcpnpi\": 1437127750, \"pcpzip\": \"04938\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"FARMINGTON\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2077783102, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1H35QC3PC63\", \"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\": \"03-13-2026\", \"time\": \"10:49:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 16:16:59\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/11/2026 @ 10:31 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 13, 2026 at 11:15am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:27 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.u00a0 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 01:27 PM\"}, {\"date\": \"2/9/2026 @ 05:13 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 05:12 PM\"}, {\"date\": \"2/6/2026 @ 08:07 PM\", \"result\": 3, \"comment\": \"02/06/2026- F2F HRA WITH SANDRA CADWELL, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/19/2026 @ 08:07 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000109385\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000109385\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000109385\", \"scheduleDate\": \"2026-3-13T11:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 20:07:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"02-11-2026 10:31:55\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:10:55\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"da9f5aec-47c8-435f-847c-64e648d604f3\\\",\\\"destination_fax_number\\\":\\\"12077783102\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"da9f5aec-47c8-435f-847c-64e648d604f3\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12077783102\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"12077783102         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:24:08.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":3,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":286,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:11:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:11:41.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-17T20:13:44.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:14:08.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-17T20:16:33.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:16:53.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":286,\\\"start_timestamp\\\":\\\"2026-03-17T20:19:00.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:24:08.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-13T11:15', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:11', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000109385\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Collins_10000109385_03132026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:10:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000109385.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Collins_10000109385_03132026.pdf', NULL, 'Summary_10000109385.pdf', NULL, '[{\"date\": \"2026-03-13T16:34:00.676Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-13T12:16', 'Member_Summary_10000109385.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000109385\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000109385.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:10: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
(2544, 57818338, 44829497, '39698290', '10000109488', '', '', '52498339', 'John', 'Yohe', 'English', '', '{\"DOB\": 15745, \"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\": 1033777099, \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"HIGGINS, ANDREA B\", \"Rank_All\": 1, \"PCP_Phone\": 2077745816, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6Q57PF5VF57\", \"Member_City\": \"TOPSHAM\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"TOPSHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-02-08\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"InterMed,84 Marginal Way Ste 800\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": 2075238597, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"72 IVANHOE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04086\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"72 IVANHOE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04086\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Yohe\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 44935, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"john.yohe2@aol.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2076322015, \"Member_Identification_Number\": \"10000109488\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:53:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:53:45\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-20T16:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T18:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T17:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T16:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T17:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T16:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-25T17:22\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-26T13:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-26T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-06T11:04\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-24T10:48\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"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:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T16:05\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-06T11:04\", \"reportStatus_date\": \"2026-03-06T11:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-26T17:18\", \"reportStatus_date\": \"2026-03-26T17:18\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:53\", \"reportStatus_date\": \"2026-03-31T13:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:53\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-06T11:04\", \"username\": null}, {\"date\": \"2026-03-06T11:04\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-03-24T10:48\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-26T10:16\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-25T17:22\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-25T17:22\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-26T17:18\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-26T13:49\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-26T17:18\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-24-2026\", \"time\": \"10:51:24\", \"value\": [{\"add\": \"72 IVANHOE DR\", \"age\": 83, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1943-02-08\", \"eno\": \"2074688873\", \"lob\": \"GA - 2026\", \"pno\": 2076322015, \"zip\": \"04086\", \"add2\": \"\", \"add3\": \"\", \"city\": \"TOPSHAM\", \"gend\": 0, \"insh\": \"10000109488\", \"mzip\": \"04086\", \"name\": \"John C Yohe\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HIGGINS, ANDREA B\", \"ppno\": 2077745816, \"cliId\": \"\", \"email\": \"john.yohe2@aol.com\", \"ename\": \"Tom Sukley \", \"madd1\": \"72 IVANHOE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"TOPSHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,84 Marginal Way Ste 800\", \"pcpnpi\": 1033777099, \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2075238597, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6Q57PF5VF57\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"1\", \"\"], \"comment\": [\"\", \"\", \"English/French American\", \"\"]}}, {\"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-23-2026\", \"time\": \"15:39:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-25-2026 17:22:11\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/6/2026 @ 08:04 AM\", \"result\": 0, \"comment\": \"IBC CALLED  TO SCHEDULE F2F WITH SANDY AT 10:30 AM ON 3/24/2026\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 10:23 AM\", \"result\": 13, \"comment\": \"o/c to sched w/Sam 3/8\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 10:22 AM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 11:51 AM\", \"result\": 13, \"comment\": \"o/c to sched w/Sam 3/1\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 03:38 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sam 3/1\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 04:05 PM\", \"result\": 13, \"comment\": \"Called to Schedule F2F HRA with Samuel caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 02:35 PM\", \"result\": 3, \"comment\": \"called to scheduled virtual hra , no answer lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 04:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 05:36 PM\", \"result\": 13, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/11/2026 @ 05:35 PM\"}, {\"date\": \"2/4/2026 @ 06:20 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/5/2026 @ 06:19 PM\"}, {\"date\": \"2/3/2026 @ 05:38 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Lesly Rivera\", \"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\": {\"type\": \"visitType\", \"memberId\": \"10000109488\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000109488\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000109488\", \"scheduleDate\": \"2026-3-24T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 18:20:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"03-06-2026 11:04:31\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:53:43\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"fbdf3d3f-bccb-4dd8-9c2f-bbd54b8a0c4e\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"fbdf3d3f-bccb-4dd8-9c2f-bbd54b8a0c4e\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:21:40.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-31T18:08:26.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:08:49.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:11:04.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:11:17.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:13:29.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:13: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-31T18:15:48.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:16:09.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:18:22.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:18:48.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:21:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:21:40.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-24T10:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:11', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000109488\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Yohe_10000109488_03242026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:53:42\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000109488.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Yohe_10000109488_03242026.pdf', NULL, 'Summary_10000109488.pdf', NULL, '[{\"date\": \"2026-03-25T21:22:10.954Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-24T11:42', 'Member_Summary_10000109488.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000109488\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000109488.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:53:44\"}', 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
(2545, NULL, NULL, NULL, '10000109526', '', '', NULL, 'Bobbie', 'Worley', 'English', '', '{\"DOB\": 21517, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1013396548\", \"Pcp_Zip\": \"04736\", \"Program\": \"Medicare\", \"Pcp_City\": \"Caribou\", \"Pcp_Name\": \"SWANBERG, CALEB\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6XY1NV4PF31\", \"Member_City\": \"CARIBOU\", \"Office_Name\": \"PINES CARIBOU HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CARIBOU\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-11-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Pines Health Services,74 Access Highway\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Aroostook\", \"Member_Country\": \"Aroostook\", \"PCP_Fax_Number\": \"2074926260\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"51 COTE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04736\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"51 COTE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04736\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Worley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Bobbie\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bworley908@yahoo.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\": \"2075514760\", \"Member_Identification_Number\": \"10000109526\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:23:09\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:23:09\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:23\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:23\", \"reportStatus_date\": \"2026-02-03T06:23\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:23\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:39:47\", \"value\": [{\"add\": \"51 COTE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-11-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075514760\", \"zip\": \"04736\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CARIBOU\", \"gend\": 0, \"insh\": \"10000109526\", \"mzip\": \"04736\", \"name\": \"Bobbie D Worley\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SWANBERG, CALEB\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bworley908@yahoo.com\", \"ename\": \"\", \"madd1\": \"51 COTE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CARIBOU\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Pines Health Services,74 Access Highway\", \"pcpnpi\": \"1013396548\", \"pcpzip\": \"04736\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Caribou\", \"pcpname\": \"PINES CARIBOU HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074926260\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6XY1NV4PF31\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:04:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:39:47\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:23\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:43:10\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2546, NULL, NULL, NULL, '10000109735', '', '', '66650973', 'Lauryl', 'Doiron', 'English', '', '{\"DOB\": 21539, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1891189288\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"BAIER, ROBIN\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7AN5EF0GM78\", \"Member_City\": \"PHIPPSBURG\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PHIPPSBURG\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-12-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"41 HALF MOON HILL\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04562\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 261\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04562\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Doiron\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lauryl\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44938, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rute209@myfairpoint.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073891759\", \"Member_Identification_Number\": \"10000109735\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-04-2026 11:40:42\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-04 11:40:42\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-04T11:40\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-04T11:40\", \"reportStatus_date\": \"2026-02-04T11:40\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-04T11:40\", \"username\": \"JDingle\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:39:56\", \"value\": [{\"add\": \"41 HALF MOON HILL\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-12-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073891759\", \"zip\": \"04562\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PHIPPSBURG\", \"gend\": 1, \"insh\": \"10000109735\", \"mzip\": \"04562\", \"name\": \"Lauryl J Doiron\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BAIER, ROBIN\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"rute209@myfairpoint.net\", \"ename\": \"\", \"madd1\": \"PO BOX 261\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PHIPPSBURG\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1891189288\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7AN5EF0GM78\", \"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\": \"10:04:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:39:56\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-04T11:40\", \"type\": null, \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/4/2026 @ 11:40 AM\", \"result\": 9, \"comment\": \"The member declined the health assessment. She stated she receives frequent care from multiple providers and does not wish to schedule.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"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 11:40:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"01-31-2026 23:43:11\", \"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 10:04:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2547, NULL, NULL, NULL, '10000109819', '', '', '1019044', 'Kerry', 'Glew', 'English', '', '{\"DOB\": 18296, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1841827003\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"POULIN, SAMUEL J\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9T29YV9EX48\", \"Member_City\": \"RAYMOND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"RAYMOND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-02-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"213 WEBBS MILLS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04071\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 1332\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04071\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Glew\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kerry\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44936, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kglew1950@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076501454\", \"Member_Identification_Number\": \"10000109819\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-05-2026 13:30:41\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-05 13:30:41\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-05T13:30\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-05T13:30\", \"reportStatus_date\": \"2026-02-05T13:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-05T13:30\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:39:57\", \"value\": [{\"add\": \"213 WEBBS MILLS RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-02-02\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076501454\", \"zip\": \"04071\", \"add2\": \"\", \"add3\": \"\", \"city\": \"RAYMOND\", \"gend\": 1, \"insh\": \"10000109819\", \"mzip\": \"04071\", \"name\": \"Kerry E Glew\", \"plan\": \"Martin\'s Point\", \"pphy\": \"POULIN, SAMUEL J\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"kglew1950@gmail.com\", \"ename\": \"\", \"madd1\": \"PO BOX 1332\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"RAYMOND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1841827003\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9T29YV9EX48\", \"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\": \"10:04:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:39:57\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-05T13:30\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/5/2026 @ 01:30 PM\", \"result\": 9, \"comment\": \"Called to Schedule F2F HRA with Sandra but member refused.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"1/22/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 13:30:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"01-31-2026 23:43:11\", \"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 10:04:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2548, NULL, NULL, NULL, '10000109854', '', '', '52661009', 'Andrea', 'Hanson', '', '', '{\"DOB\": 24075, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1194988311\", \"Pcp_Zip\": \"85203964\", \"Program\": \"Medicare\", \"Pcp_City\": \"MESA\", \"Pcp_Name\": \"MEADOWS, RHIANNA M\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"AZ\", \"Medicare_ID\": \"6C85M97WG72\", \"Member_City\": \"SANFORD\", \"Office_Name\": \"NASSON HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SANFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1965-11-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"840 E MCKELLIPS RD,SUITE 101\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"4808338313\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"330 KENNEBUNK RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04073\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"330 KENNEBUNK RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04073\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hanson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Andrea\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078067951\", \"Member_Identification_Number\": \"10000109854\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-06-2026 16:04:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-06 16:04:01\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-06T16:04\", \"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-05T10:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T15:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-19T12:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T16:04\", \"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-09T15:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T12:53\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-06T16:04\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:39:59\", \"value\": [{\"add\": \"330 KENNEBUNK RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-11-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078067951\", \"zip\": \"04073\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SANFORD\", \"gend\": 1, \"insh\": \"10000109854\", \"mzip\": \"04073\", \"name\": \"Andrea D Hanson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MEADOWS, RHIANNA M\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"330 KENNEBUNK RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SANFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"840 E MCKELLIPS RD,SUITE 101\", \"pcpnpi\": \"1194988311\", \"pcpzip\": \"85203964\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"MESA\", \"pcpname\": \"NASSON HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"4808338313\", \"pcpstate\": \"AZ\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6C85M97WG72\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:04:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:39:59\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/25/2026 @ 04:33 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer No VM Setup.u00a0 \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 07:50 PM\", \"result\": 3, \"comment\": \"03/18/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 05:16 PM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 06:03 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda but no answer No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Maccimene  Jean\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 02:11 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 04:04 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- no vm setup \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 09:53 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 03:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 03:36 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 03:36 PM\"}, {\"date\": \"2/5/2026 @ 10:56 AM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M or 2/26 w/Sandy C\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/6/2026 @ 10:56 AM\"}, {\"date\": \"2/3/2026 @ 04:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 09:20 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"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-05-2026 10:56:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-06-2026 16:04:01\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2549, NULL, NULL, NULL, '10000110063', '', '', NULL, 'Stephen', 'Lyons', '', '', '{\"DOB\": 21565, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1356310098\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"MURRAY PULSIFER, KRISTY A\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5XW9VN0XE19\", \"Member_City\": \"CAPE ELIZABETH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CAPE ELIZABETH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1959-01-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"17 JEWETT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04107\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"17 JEWETT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04107\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Lyons\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephen\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"molsey@maine.rr.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073510225\", \"Member_Identification_Number\": \"10000110063\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:23:09\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:23:09\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:23\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:23\", \"reportStatus_date\": \"2026-02-03T06:23\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:23\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:06\", \"value\": [{\"add\": \"17 JEWETT RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-01-15\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073510225\", \"zip\": \"04107\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CAPE ELIZABETH\", \"gend\": 0, \"insh\": \"10000110063\", \"mzip\": \"04107\", \"name\": \"Stephen T Lyons\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MURRAY PULSIFER, KRISTY A\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"molsey@maine.rr.com\", \"ename\": \"\", \"madd1\": \"17 JEWETT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CAPE ELIZABETH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,100 Foden Rd Ste 203\", \"pcpnpi\": \"1356310098\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5XW9VN0XE19\", \"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\": \"10:04:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:06\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:23\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:43:12\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2550, NULL, NULL, NULL, '10000110084', '', '', '24168610', 'Michael', 'Martin', '', '', '{\"DOB\": 21496, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1649565672\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"MICHAELIS, TODD M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5N60HH4GX13\", \"Member_City\": \"GORHAM\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GORHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-11-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238590\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"8 SYLVAN RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04038\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"8 SYLVAN RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04038\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Martin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44937, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mamiejmartin@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075727333\", \"Member_Identification_Number\": \"10000110084\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 11:29:46\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-04-07 11:29:46\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-13T11:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-03T13:50\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T13:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T11:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T11:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T11:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-04-07T11:29\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"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-09T13:16\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T11:58\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-03T13:50\", \"reportStatus_date\": \"2026-03-03T13:50\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-04-07T11:29\", \"reportStatus_date\": \"2026-04-07T11:29\"}]', '{\"utc\": [{\"date\": \"2026-03-03T13:50\", \"username\": \"KCoash\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-04-07T11:29\", \"username\": \"MDouglas\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:07\", \"value\": [{\"add\": \"8 SYLVAN RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-11-07\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075727333\", \"zip\": \"04038\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GORHAM\", \"gend\": 0, \"insh\": \"10000110084\", \"mzip\": \"04038\", \"name\": \"Michael A Martin\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MICHAELIS, TODD M\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"mamiejmartin@gmail.com\", \"ename\": \"\", \"madd1\": \"8 SYLVAN RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GORHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,100 Foden Rd Ste 203\", \"pcpnpi\": \"1649565672\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238590\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5N60HH4GX13\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:04:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:07\"}', '{\"utc\": [{\"date\": \"2026-03-03T13:50\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-04-07T11:29\", \"type\": null, \"subStaus\": \"\", \"username\": \"MDouglas\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/7/2026 @ 08:29 AM\", \"result\": 9, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 10:05 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 01:55 PM\", \"result\": 3, \"comment\": \"called to schedule w/ kathryn baxter \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 10:41 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 11:54 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 11:29 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/20\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:50 PM\", \"result\": 6, \"comment\": \"o/c to sched F2F w/Sandy 3/9 - call back in the AM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 04:17 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9 or 3/20\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 10:45 AM\", \"result\": 3, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:49 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 11:58 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 11:02 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 11:56 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 11:56 AM\"}, {\"date\": \"2/9/2026 @ 01:16 PM\", \"result\": 3, \"comment\": \"CALL DROPPED VIRTUAL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 01:16 PM\"}, {\"date\": \"2/6/2026 @ 01:48 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 01:48 PM\"}, {\"date\": \"2/3/2026 @ 11:09 AM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Tressa Scott\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"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-06-2026 13:48:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-13-2026 11:58:17\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 17}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:13', 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
(2551, NULL, NULL, NULL, '10000110117', '', '', '52661009', 'Henry', 'Hebb', '', '', '{\"DOB\": 15862, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1932692803\", \"Pcp_Zip\": \"41023344\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"WARD, HANNAH\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2X34XV9PV50\", \"Member_City\": \"POLAND\", \"Office_Name\": \"MAINEHEALTH SENIOR CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"POLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-06-05\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"66 BRAMHALL ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"64 FOREST DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04274\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"64 FOREST DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04274\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Hebb\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Henry\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"hhebb2781@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\": \"2075954127\", \"Member_Identification_Number\": \"10000110117\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-11-2026 19:01:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-11 19:01:52\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T19:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T15:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-11T18:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-11T19:01\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T10:16\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-11T19:01\", \"reportStatus_date\": \"2026-02-11T19:01\"}]', '{\"utc\": [{\"date\": \"2026-02-11T19:01\", \"username\": \"LRivera\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:09\", \"value\": [{\"add\": \"64 FOREST DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"6038282683\", \"dob\": \"1943-06-05\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075954127\", \"zip\": \"04274\", \"add2\": \"\", \"add3\": \"\", \"city\": \"POLAND\", \"gend\": 0, \"insh\": \"10000110117\", \"mzip\": \"04274\", \"name\": \"Henry E Hebb\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WARD, HANNAH\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"hhebb2781@gmail.com\", \"ename\": \"\", \"madd1\": \"64 FOREST DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"POLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"66 BRAMHALL ST,\", \"pcpnpi\": \"1932692803\", \"pcpzip\": \"41023344\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MAINEHEALTH SENIOR CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2X34XV9PV50\", \"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\": \"10:04:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:09\"}', '{\"utc\": [{\"date\": \"2026-02-11T19:01\", \"type\": null, \"subStaus\": \"\", \"username\": \"LRivera\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"2/11/2026 @ 06:01 PM\", \"result\": 6, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell; secondary number is Nancy Hebb\'s; member stated they are not interested in the hra at the moment. Follow up in July.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 05:59 PM\", \"result\": 10, \"comment\": \"Called alternate # to schedule f2f hra with MP nurse Sandra Cadwell; disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:57 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/12/2026 @ 12:54 PM\"}, {\"date\": \"2/9/2026 @ 10:16 AM\", \"result\": 3, \"comment\": \"Calling to schedule F2F w/Sandy in March\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/10/2026 @ 10:16 AM\"}, {\"date\": \"2/5/2026 @ 03:48 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/6/2026 @ 03:48 PM\"}, {\"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 15:48:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:43:12\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2552, NULL, NULL, NULL, '10000110201', '', '', NULL, 'Alitza', 'Wildes', 'English', '', '{\"DOB\": 19725, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1467038042\", \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"FAY SHIELDS, JACOB A\", \"Rank_All\": 1, \"PCP_Phone\": \"2078392559\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1DH6YH6JM44\", \"Member_City\": \"BUXTON\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BUXTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-01-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,575 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2075231135\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"344 OLD ORCHARD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04093\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"344 OLD ORCHARD RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04093\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Wildes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alitza\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"akwildes54@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\": \"2072989419\", \"Member_Identification_Number\": \"10000110201\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:22:10\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:10\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:22\", \"reportStatus_date\": \"2026-02-03T06:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:12\", \"value\": [{\"add\": \"344 OLD ORCHARD RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-01-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072989419\", \"zip\": \"04093\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BUXTON\", \"gend\": 1, \"insh\": \"10000110201\", \"mzip\": \"04093\", \"name\": \"Alitza K Wildes\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FAY SHIELDS, JACOB A\", \"ppno\": \"2078392559\", \"cliId\": \"\", \"email\": \"akwildes54@gmail.com\", \"ename\": \"\", \"madd1\": \"344 OLD ORCHARD RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BUXTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,575 Main St\", \"pcpnpi\": \"1467038042\", \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075231135\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1DH6YH6JM44\", \"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\": \"10:04:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:12\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:43:12\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2553, NULL, NULL, '22140773', '10000110270', '', '', '47262451', 'Cassandra', 'Stachmus', 'English', '', '{\"DOB\": 20257, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1538176789\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"STEELE, ERIK N\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1AT5PW0PD55\", \"Member_City\": \"PHIPPSBURG\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PHIPPSBURG\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-06-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"8 SKYBO DR APT 1\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04562\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"8 SKYBO DR APT 1\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04562\", \"Member_Ethnicity\": \"Hispanic or Latino\", \"Member_Last_name\": \"Stachmus\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Cassandra\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44937, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tooterbell2@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\": \"2072956801\", \"Member_Identification_Number\": \"10000110270\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 15:43:38\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-17 15:43:38\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-06T14:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T13:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T16:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T18:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T19:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-17T15:43\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-03T06:08\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-04T10:22\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-14T13:17\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-03-09T11:55\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-03T06:08\", \"reportStatus_date\": \"2026-02-03T06:08\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-14T13:17\", \"reportStatus_date\": \"2026-02-14T13:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T13:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T18:48\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-09T11:55\", \"reportStatus_date\": \"2026-03-09T11:55\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-17T15:43\", \"reportStatus_date\": \"2026-03-17T15:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-03T06:08\", \"username\": null}, {\"date\": \"2026-03-04T10:22\", \"username\": \"LAtherholt\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-17T15:43\", \"username\": \"KCoash\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-14T13:17\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-09T11:55\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:14\", \"value\": [{\"add\": \"8 SKYBO DR APT 1\", \"age\": 70, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-06-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072956801\", \"zip\": \"04562\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PHIPPSBURG\", \"gend\": 1, \"insh\": \"10000110270\", \"mzip\": \"04562\", \"name\": \"Cassandra A Stachmus\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STEELE, ERIK N\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"tooterbell2@gmail.com\", \"ename\": \"\", \"madd1\": \"8 SKYBO DR APT 1\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PHIPPSBURG\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1538176789\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1AT5PW0PD55\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-12-2026\", \"time\": \"11:40:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:14\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-17T15:43\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": [{\"date\": \"2026-02-14T13:17\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"member called and asked to be rescheduled. her and everyone in the house is sick and she is tired and would rather complete on a different day\", \"cancelStatus\": \"0\"}, {\"date\": \"2026-03-09T11:55\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"provider cancellation\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/17/2026 @ 03:43 PM\", \"result\": 9, \"comment\": \"member on DNC list now per Five9 record dated 3/9/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 02:14 PM\", \"result\": 13, \"comment\": \"INC caller was returning call and disconnected \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 07:04 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 06:48 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 04:37 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/2/2026 @ 04:36 PM\"}, {\"date\": \"2/20/2026 @ 01:51 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 01:51 PM\"}, {\"date\": \"2/3/2026 @ 01:36 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000110270, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000110270}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000110270, \"scheduleDate\": \"2026-02-14T15:00:00.000\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 13:51:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-09-2026 11:55:16\", \"status\": 0, \"details\": \"hra status changed\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, 'In Person', '2026-02-14T15:00:00.000', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2554, NULL, NULL, NULL, '10000110281', '', '', '52661009', 'John', 'Nugent', 'English', '', '{\"DOB\": 19299, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1659908101\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"SCONTRAS, JENNIFER\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8DA6U63MV55\", \"Member_City\": \"RAYMOND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"RAYMOND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-11-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075231135\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"7 IAN PASS\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04071\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 IAN PASS\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04071\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Nugent\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 44937, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"thinkthicker7@yahoo.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\": \"2076556316\", \"Member_Identification_Number\": \"10000110281\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-09-2026 11:34:49\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-09 11:34:49\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-09T11:34\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T11:34\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:15\", \"value\": [{\"add\": \"7 IAN PASS\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-11-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076556316\", \"zip\": \"04071\", \"add2\": \"\", \"add3\": \"\", \"city\": \"RAYMOND\", \"gend\": 0, \"insh\": \"10000110281\", \"mzip\": \"04071\", \"name\": \"John C Nugent\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCONTRAS, JENNIFER\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"thinkthicker7@yahoo.com\", \"ename\": \"\", \"madd1\": \"7 IAN PASS\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"RAYMOND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1659908101\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075231135\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8DA6U63MV55\", \"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\": \"10:04:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:15\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/9/2026 @ 11:34 AM\", \"result\": 6, \"comment\": \"per five9 records c/b later in the year\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"6/15/2026 @ 11:34 AM\"}, {\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 11:34:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:43:13\", \"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 10:04:15', 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
(2555, 55499828, 44829497, '17537038', '10000110292', '', '', '14035267', 'Ruth', 'Brown', 'English', '', '{\"DOB\": 24065, \"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\": 1366715302, \"Pcp_Zip\": \"44121005\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BREWER\", \"Pcp_Name\": \"KUHL, AMY M\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4H92WE1EW95\", \"Member_City\": \"BENTON\", \"Office_Name\": \"OAKLAND FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BENTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1965-11-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"43 WHITING HILL RD,SUITE300\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2079735042, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1155 CLINTON AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1155 CLINTON AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ruth\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44938, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"rbrown7647@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2073143890, \"Member_Identification_Number\": \"10000110292\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:53:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:53:53\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T13:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T16:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T12:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T10:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-23T16:49\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-26T20:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-26T21:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-04T15:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-22T18:44\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-03-11T14:40\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-23T16:09\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-23T15:20\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-04T15:07\", \"reportStatus_date\": \"2026-02-04T15:07\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-23T15:20\", \"reportStatus_date\": \"2026-02-23T15:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T16:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T10:42\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-11T14:40\", \"reportStatus_date\": \"2026-03-11T14:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-23T16:49\", \"reportStatus_date\": \"2026-03-23T16:49\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-26T21:05\", \"reportStatus_date\": \"2026-03-26T21:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:53\", \"reportStatus_date\": \"2026-03-31T13:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:53\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-04T15:07\", \"username\": null}, {\"date\": \"2026-02-04T15:07\", \"username\": \"MDouglas\"}, {\"date\": \"2026-03-11T14:40\", \"username\": null}, {\"date\": \"2026-03-11T14:40\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-02-22T18:44\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-23T16:09\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-23T18:19\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-03-23T16:49\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-23T16:49\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-25T12:33\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-26T08:33\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-26T21:05\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-26T20:02\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-26T21:05\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-25T12:35\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-23T15:20\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-23-2026\", \"time\": \"16:12:57\", \"value\": [{\"add\": \"1155 CLINTON AVE\", \"age\": 60, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-11-19\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2073143890, \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BENTON\", \"gend\": 1, \"insh\": \"10000110292\", \"mzip\": \"04901\", \"name\": \"Ruth A Brown\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KUHL, AMY M\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"rbrown7647@yahoo.com\", \"ename\": \"Stephanie Isaac - daughter \", \"madd1\": \"1155 CLINTON AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BENTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"43 WHITING HILL RD,SUITE300\", \"pcpnpi\": 1366715302, \"pcpzip\": \"44121005\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"BREWER\", \"pcpname\": \"OAKLAND FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2079735042, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4H92WE1EW95\", \"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-22-2026\", \"time\": \"18:44:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-26-2026 08:33:11\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-23T15:20\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"provider cancellation\", \"cancelStatus\": 1}]}', NULL, '{\"memberId\": \"10000110292\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Wed, 25 Mar 2026 16:35:31 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda,\\n1) On the med list the statin is marked as not taking but under HLD in the cardiac section yes is selected for is the member taking a statin\\n2) CHF mentioned on the med list, can you add to cardiac section if member has CHF \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Mar 2026 12:33:10 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Thank you\"}, \"mailId\": \"\"}], \"memberName\": \"Ruth Brown\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/23/2026 04:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/11/2026 @ 02:40 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 23, 2026 at 4:00pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 10:42 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/13/2026 @ 10:41 AM\"}, {\"date\": \"3/6/2026 @ 12:50 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/10/2026 @ 12:48 PM\"}, {\"date\": \"2/25/2026 @ 04:28 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point nurse Kathryn B- LVM or with Erin B \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/27/2026 @ 04:28 PM\"}, {\"date\": \"2/23/2026 @ 10:32 AM\", \"result\": 3, \"comment\": \"o/c to reschedule appt to 3/9 at 3 pm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 10:09 AM\", \"result\": 14, \"comment\": \"need to c/b and reschedule - provider unable to do appt due to weather\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/24/2026 @ 10:09 AM\"}, {\"date\": \"2/4/2026 @ 12:07 PM\", \"result\": 0, \"comment\": \"SCHEDULED APPT W/ ERIN BARKER AT 3PM ON 2/23/2026\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/4/2026 @ 10:32 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/10/2026 @ 10:31 AM\"}, {\"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\": {\"type\": \"visitType\", \"memberId\": \"10000110292\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000110292\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000110292\", \"scheduleDate\": \"2026-3-23T16:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 10:32:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}, {\"date\": \"02-23-2026 15:20:42\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"03-11-2026 14:40:01\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:53:52\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"6e04ad3e-1063-47c0-ab2d-3e9c0cf0affb\\\",\\\"destination_fax_number\\\":\\\"12079735042\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"6e04ad3e-1063-47c0-ab2d-3e9c0cf0affb\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12079735042\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2079735042 Northern \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:59:54.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\\\":320,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":320,\\\"start_timestamp\\\":\\\"2026-03-31T17:54:22.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:59:54.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-23T16:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:15', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000110292\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Brown_10000110292_03232026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:53:51\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000110292.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Brown_10000110292_03232026.pdf', NULL, 'Summary_10000110292.pdf', NULL, '[{\"date\": \"2026-03-23T20:49:22.562Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-26T12:33:10.019Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-23T16:38', 'Member_Summary_10000110292.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000110292\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000110292.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:53:53\"}', 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
(2556, NULL, NULL, NULL, '10000110490', '', '', '1019044', 'Tammy', 'Robinson', 'English', '', '{\"DOB\": 21518, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1235249137\", \"Pcp_Zip\": \"41062327\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"STATON, MEGAN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9HY1TK1VD39\", \"Member_City\": \"GORHAM\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GORHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-11-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 FODEN RD. WEST,SUITE 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"5 KEEPA WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04038\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5 KEEPA WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04038\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Robinson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tammy\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44937, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Tammyrobinson759@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078397113\", \"Member_Identification_Number\": \"10000110490\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-04-2026 16:42:01\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-04 16:42:01\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-04T16:42\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-04T16:42\", \"reportStatus_date\": \"2026-02-04T16:42\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-04T16:42\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:20\", \"value\": [{\"add\": \"5 KEEPA WAY\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-11-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078397113\", \"zip\": \"04038\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GORHAM\", \"gend\": 1, \"insh\": \"10000110490\", \"mzip\": \"04038\", \"name\": \"Tammy L Robinson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STATON, MEGAN\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"Tammyrobinson759@yahoo.com\", \"ename\": \"\", \"madd1\": \"5 KEEPA WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GORHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN RD. WEST,SUITE 203\", \"pcpnpi\": \"1235249137\", \"pcpzip\": \"41062327\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9HY1TK1VD39\", \"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\": \"10:04:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:20\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-04T16:42\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": \"3\", \"callLog\": [{\"date\": \"2/12/2026 @ 11:03 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/19/2026 @ 11:03 AM\"}, {\"date\": \"2/11/2026 @ 12:03 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 12:02 PM\"}, {\"date\": \"2/4/2026 @ 04:42 PM\", \"result\": 9, \"comment\": \"Called to Schedule F2F HRA with Sandra but member refused.  stated she has to many appointment and is well taken care of  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 01:28 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"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 16:42:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"01-31-2026 23:43:13\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', '{\"orderType\": 0, \"sortOrder\": 1771493629}', 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2557, NULL, NULL, NULL, '10000110498', '', '', NULL, 'Charles', 'Kneeland', '', '', '{\"DOB\": 21506, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1104385962\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"WINTERS, TESS\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9RK1YW4HE29\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-11-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238590\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"119 HILL ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"119 HILL ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Kneeland\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Charles\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072529325\", \"Member_Identification_Number\": \"10000110498\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:23:10\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:23:10\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:23\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:23\", \"reportStatus_date\": \"2026-02-03T06:23\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:23\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:21\", \"value\": [{\"add\": \"119 HILL ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-11-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072529325\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000110498\", \"mzip\": \"04106\", \"name\": \"Charles E Kneeland\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WINTERS, TESS\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"119 HILL ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,100 Foden Rd Ste 203\", \"pcpnpi\": \"1104385962\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238590\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9RK1YW4HE29\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:04:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:21\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:23\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:43:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2558, NULL, NULL, NULL, '10000110558', '', '', '52661009', 'Louise', 'Bouvier', '', '', '{\"DOB\": 17024, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1043288525\", \"Pcp_Zip\": \"44621258\", \"Program\": \"Medicare\", \"Pcp_City\": \"MILLINOCKET\", \"Pcp_Name\": \"DUNSTAN, EDWARD\", \"Rank_All\": 1, \"PCP_Phone\": \"2077235161\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7PN3RA3QY60\", \"Member_City\": \"Auburn\", \"Office_Name\": \"MILLINOCKET REGIONAL HOSPITAL FAMILY AND INTERNAL\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Jay\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-08-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"200 SOMERSET ST,SUITE 3\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Franklin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077233040\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"440 MINOT AVE APT 10\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 WHITE AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04239\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bouvier\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Louise\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"LBOUVIER1046@GMAIL.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073910068\", \"Member_Identification_Number\": \"10000110558\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-24-2026 12:45:53\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-24 12:45:53\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T12:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T14:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T18:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T14:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T12:45\", \"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-09T14:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T14:40\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T12:45\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:40:23\", \"value\": [{\"add\": \"440 MINOT AVE APT 10\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-08-10\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073910068\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Auburn\", \"gend\": 1, \"insh\": \"10000110558\", \"mzip\": \"04239\", \"name\": \"Louise J Bouvier\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DUNSTAN, EDWARD\", \"ppno\": \"2077235161\", \"cliId\": \"\", \"email\": \"LBOUVIER1046@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"3 WHITE AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Jay\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"200 SOMERSET ST,SUITE 3\", \"pcpnpi\": \"1043288525\", \"pcpzip\": \"44621258\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"MILLINOCKET\", \"pcpname\": \"MILLINOCKET REGIONAL HOSPITAL FAMILY AND INTERNAL\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077233040\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7PN3RA3QY60\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:04:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:40:23\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 12:55 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/13\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 02:50 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/13\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 09:32 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 12:20 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 12:11 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 02:12 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- no vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 12:49 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:27 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 09:59 AM\", \"result\": 13, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 08:46 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 09:41 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 04:45 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 12:45 PM\", \"result\": 13, \"comment\": \"02/24/2026- F2F HRA WITH Sandra Cadwell,  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 01:40 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell Feb 13 or 27th; LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 05:41 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/27; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/12/2026 @ 05:40 PM\"}, {\"date\": \"2/9/2026 @ 01:50 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 01:49 PM\"}, {\"date\": \"2/6/2026 @ 02:41 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 02:41 PM\"}, {\"date\": \"1/28/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-06-2026 14:41:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-24-2026 12:45:53\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 18}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:16', 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
(2559, 57818338, 44829497, '22140773', '10000110594', '', '', NULL, 'Katrina', 'Lezotte', 'English', '', '{\"DOB\": 19925, \"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\": \"1912211483\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Bangotr\", \"Pcp_Name\": \"SHARON ROXAS\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073777\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3QT3Q73EP04\", \"Member_City\": \"Levant\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Levant\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-07-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"700 Broadway, Bld 3\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079073778\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"16 BLACKSTREAM DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04456\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04456\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Lezotte\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Katrina\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"kmlezotte54@icloud.com\", \"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\": \"2076592741\", \"Member_Identification_Number\": \"10000110594\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2078847168\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:29:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:29:12\", \"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-07T14:56\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-22T21:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T14:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-03T06:08\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T17:33\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-07T14:56\", \"reportStatus_date\": \"2026-02-07T14:56\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T14:03\", \"reportStatus_date\": \"2026-02-23T14:03\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:29\", \"reportStatus_date\": \"2026-03-03T17:29\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:29\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-03T06:08\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T17:33\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:51\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-07T14:56\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-07T14:56\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T21:46\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T14:03\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-22T21:59\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T14:03\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T14:39\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-19-2026\", \"time\": \"15:50:10\", \"value\": [{\"add\": \"16 BLACKSTREAM DR\", \"age\": 71, \"ano\": \"\", \"cno\": \"2078847168\", \"dob\": \"1954-07-20\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2076592741\", \"zip\": \"04456\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Levant\", \"gend\": 1, \"insh\": \"10000110594\", \"mzip\": \"04456\", \"name\": \"Katrina M Lezotte\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SHARON ROXAS\", \"ppno\": \"2079073777\", \"cliId\": \"\", \"email\": \"kmlezotte54@icloud.com\", \"ename\": \"Michael Lezotte - husband\", \"madd1\": \"PO BOX 2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Levant\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"700 Broadway, Bld 3\", \"pcpnpi\": \"1912211483\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"Bangotr\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079073778\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"3QT3Q73EP04\", \"currentgend\": \"Female\", \"pphycomment\": \"address and office name corrected\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Christian\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-03-2026\", \"time\": \"16:54:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-19-2026 15:50:10\"}', NULL, NULL, '{\"memberId\": \"10000110594\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 19:39:34 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n1.  AOD Cardiovascular Med list reports HLD please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 02:46:52 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Done!\"}, \"mailId\": \"\"}], \"memberName\": \"Katrina Lezotte\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/06/2026 09:00 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000110594, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000110594}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000110594, \"scheduleDate\": \"2026-02-06T09:00:00.000\"}}', NULL, '{\"date\": \"01-31-2026 23:43:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, '[{\"date\": \"2026-03-03 17:29:11\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ec4d6ccf-d522-4f23-b27d-b18c5eece1bb\\\",\\\"destination_fax_number\\\":\\\"12079073778\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"ec4d6ccf-d522-4f23-b27d-b18c5eece1bb\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12079073778\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:34:02.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":254,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":254,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:34:02.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-06T09:00:00.000', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:17', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000110594\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Lezotte_10000110594_02062026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:29:11\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000110594.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Lezotte_10000110594_02062026.pdf', NULL, 'Summary_10000110594.pdf', NULL, '[{\"date\": \"2026-02-07T19:56:22.205Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T02:46:51.764Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-06T10:16', 'Member_Summary_10000110594.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000110594\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000110594.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:29:12\"}', 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
(2560, 71932120, 44829497, '22140773', '10000110623', '', '', '24168610', 'Richard', 'Brown', 'English', '', '{\"DOB\": 16628, \"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\": \"1255356440\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"KEVYN COMSTOCK\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073030\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7G96Q50CF42\", \"Member_City\": \"MILFORD\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"MILFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-07-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"27 State St, Ste 62\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079073031\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"495 COUNTY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04461\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"495 COUNTY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04461\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"decline@2024.com\", \"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\": \"2079749172\", \"Member_Identification_Number\": \"10000110623\", \"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:29:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:29:18\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T11:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-14T10:41\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-23T18:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T21:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-11T11:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-13T09:32\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"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-05T11:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-14T10:41\", \"reportStatus_date\": \"2026-02-14T10:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T21:36\", \"reportStatus_date\": \"2026-02-23T21:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:29\", \"reportStatus_date\": \"2026-03-03T17:29\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:29\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-11T11:29\", \"username\": null}, {\"date\": \"2026-02-11T11:29\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-02-13T09:32\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:27\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T16:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-14T10:41\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-14T10:41\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T22:05\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T21:36\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T18:36\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T21:36\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-18T20:19\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-19-2026\", \"time\": \"15:52:42\", \"value\": [{\"add\": \"495 COUNTY RD\", \"age\": 80, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-07-10\", \"eno\": \"2079746173\", \"lob\": \"GA - 2026\", \"pno\": \"2079749172\", \"zip\": \"04461\", \"add2\": \"\", \"add3\": \"\", \"city\": \"MILFORD\", \"gend\": 0, \"insh\": \"10000110623\", \"mzip\": \"04461\", \"name\": \"Richard W Brown\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KEVYN COMSTOCK\", \"ppno\": \"2079073030\", \"cliId\": \"\", \"email\": \"decline@2024.com\", \"ename\": \"Karen Brown - wife\", \"madd1\": \"495 COUNTY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"MILFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"27 State St, Ste 62\", \"pcpnpi\": \"1255356440\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079073031\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"7G96Q50CF42\", \"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\": \"09:32:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-19-2026 15:52:42\"}', NULL, NULL, '{\"memberId\": \"10000110623\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 01:19:01 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Insomnia was supported by medication, however, no medications were noted on the med/OTC list. Please clarify.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 03:05:33 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"The member takes Tylenol PM for insomnia, which is on the OTC med list. \"}, \"mailId\": \"\"}], \"memberName\": \"Richard Brown\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/13/2026 10:30 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/11/2026 @ 11:29 AM\", \"result\": 0, \"comment\": \"Scheduled w/Erin B 2/13 at 10:30 on 2/5/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 11:59 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 11:59 AM\"}, {\"date\": \"2/3/2026 @ 04:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000110623\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": \"10000110623\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": \"10000110623\", \"scheduleDate\": \"2026-2-13T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 11:59:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-11-2026 11:29:39\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:29:17\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"66b89c28-4bcf-423b-a387-8b95f1eb069b\\\",\\\"destination_fax_number\\\":\\\"12079073031\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"66b89c28-4bcf-423b-a387-8b95f1eb069b\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12079073031\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:33:53.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":243,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":243,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:33:53.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-13T10:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:04:17', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000110623\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Brown_10000110623_02132026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:29:16\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000110623.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Brown_10000110623_02132026.pdf', NULL, 'Summary_10000110623.pdf', NULL, '[{\"date\": \"2026-02-14T15:41:11.940Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T03:05:32.587Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-13T11:44', 'Member_Summary_10000110623.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000110623\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000110623.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:29:17\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
