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
(1810, 93442164, 44829497, '71460194', '10000068349', '', '', '4010197', 'Roy', 'Pittman', 'English', '', '{\"DOB\": 18373, \"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\": 1942279617, \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"DOBIESKI, STEVEN T\", \"Rank_All\": 1, \"PCP_Phone\": 2077745816, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3FE5UG6NW99\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-04-20\", \"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\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2078741483, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"447 WOODSIDE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"447 WOODSIDE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Pittman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Roy\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"pittmanrs@gmail.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\": 2076710679, \"Member_Identification_Number\": \"10000068349\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 15:05:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 15:05:05\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-03T19:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T11:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T12:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T13:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T18:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T19:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-17T16:57\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-22T16:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-22T22:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T15:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-06T11:38\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-08T10:21\", \"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-03T06:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T11:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T18:50\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-03-08T10:21\", \"reportStatus_date\": \"2026-03-08T10:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-22T22:43\", \"reportStatus_date\": \"2026-03-22T22:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T15:05\", \"reportStatus_date\": \"2026-03-24T15:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T15:05\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-06T11:38\", \"username\": null}, {\"date\": \"2026-03-06T11:38\", \"username\": \"LAnguiano\"}], \"inProgress\": [{\"date\": \"2026-03-08T10:21\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-03-18T23:08\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-17T16:57\", \"username\": \"SAcha\"}, {\"date\": \"2026-03-17T16:57\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-22T22:43\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-22T16:14\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-22T22:43\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-08-2026\", \"time\": \"10:21:29\", \"value\": [{\"add\": \"447 WOODSIDE RD\", \"age\": 75, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-04-20\", \"eno\": \"2076152802\", \"lob\": \"GA - 2026\", \"pno\": 2076710679, \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 0, \"insh\": \"10000068349\", \"mzip\": \"04011\", \"name\": \"Roy S Pittman\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DOBIESKI, STEVEN T\", \"ppno\": 2077745816, \"cliId\": \"\", \"email\": \"pittmanrs@gmail.com\", \"ename\": \"Debra Olken\", \"madd1\": \"447 WOODSIDE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,84 Marginal Way Ste 800\", \"pcpnpi\": 1942279617, \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2078741483, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3FE5UG6NW99\", \"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-08-2026\", \"time\": \"10:21:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 16:57:08\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/6/2026 @ 11:38 AM\", \"result\": 0, \"comment\": \"Member scheduled March 8th 1010am with Samuel A \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 01:43 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 07:01 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 06:50 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 01:12 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sam 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/27/2026 @ 01:12 PM\"}, {\"date\": \"2/25/2026 @ 12:46 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Samuel no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/27/2026 @ 12:46 PM\"}, {\"date\": \"2/12/2026 @ 11:21 AM\", \"result\": 3, \"comment\": \"LVM F2F JESS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 11:21 AM\"}, {\"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\": {\"type\": \"visitType\", \"memberId\": \"10000068349\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": \"10000068349\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": \"10000068349\", \"scheduleDate\": \"2026-3-8T10:10\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-12-2026 11:21:00\", \"schedulerId\": \"4010197\", \"schedulerLeadId\": \"4010197\"}]}', '{\"date\": \"03-06-2026 11:38:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 15:05:03\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"48d3357f-6fa0-43f8-bf34-71bb8a2c0197\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"48d3357f-6fa0-43f8-bf34-71bb8a2c0197\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:23:57.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-24T19:05:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:06:32.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:08:49.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:10:06.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:12:21.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:13:34.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:15:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:17:02.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:19:17.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:20:30.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:22:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:23:57.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-8T10:10', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:36', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068349\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Pittman_10000068349_03082026.pdf\", \"ftp_upload_date\": \"2026-03-24 15:05:03\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000068349.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Pittman_10000068349_03082026.pdf', NULL, 'Summary_10000068349.pdf', NULL, '[{\"date\": \"2026-03-17T20:57:08.148Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-08T11:15', 'Member_Summary_10000068349.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068349\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000068349.pdf\", \"member_ftp_upload_date\": \"2026-03-24 15:05:04\"}', 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
(1811, 52478890, 44829497, '27743162', '10000068352', '', '', '52661009', 'Theodore', 'Libby', 'English', '', '{\"DOB\": 18434, \"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\": 1043779804, \"Pcp_Zip\": \"04073\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Sanford\", \"Pcp_Name\": \"PRAST, BRENDAN J\", \"Rank_All\": 1, \"PCP_Phone\": 2074907998, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5JK6F05DA56\", \"Member_City\": \"LYMAN\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LYMAN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-06-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"\\tMaineHealth Primary Care Family Medicine,\\t25A June St Ste 111\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": 2074907999, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"227 KENNEBUNK POND RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04002\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"227 KENNEBUNK POND RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04002\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Libby\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Theodore\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"dawnajl@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\": 2074997435, \"Member_Identification_Number\": \"10000068352\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2076516039}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 14:08:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-07 14:08:33\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T14:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-31T14:15\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-04-01T21:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-01T22:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-07T14:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-05T12:56\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-06T14:36\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-31T12:10\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-25T09:18\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-25T09:18\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-05T12:56\", \"reportStatus_date\": \"2026-02-05T12:56\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-25T09:18\", \"reportStatus_date\": \"2026-02-25T09:18\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-06T14:36\", \"reportStatus_date\": \"2026-03-06T14:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-04-01T22:50\", \"reportStatus_date\": \"2026-04-01T22:50\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-04-07T14:08\", \"reportStatus_date\": \"2026-04-07T14:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-04-07T14:08\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-05T12:56\", \"username\": null}, {\"date\": \"2026-02-05T12:56\", \"username\": \"cwasilak\"}, {\"date\": \"2026-03-06T14:36\", \"username\": null}, {\"date\": \"2026-03-06T14:36\", \"username\": \"jsmith\"}], \"inProgress\": [{\"date\": \"2026-03-31T12:10\", \"username\": \"SHafer\"}], \"qaAssigned\": [{\"date\": \"2026-04-01T10:03\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-31T14:15\", \"username\": \"SHafer\"}, {\"date\": \"2026-03-31T14:15\", \"username\": \"SHafer\"}, {\"date\": \"2026-04-01T18:28\", \"username\": \"SHafer\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-04-01T22:50\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-04-01T21:12\", \"username\": \"CBryan\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-04-01T22:50\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-04-01T15:24\", \"username\": \"CBryan\"}, {\"date\": \"2026-04-01T18:27\", \"username\": \"SHafer\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-25T09:18\", \"username\": \"KCoash\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-31-2026\", \"time\": \"14:15:37\", \"value\": [{\"add\": \"227 KENNEBUNK POND RD\", \"age\": 75, \"ano\": \"\", \"cno\": 2076516039, \"dob\": \"1950-06-20\", \"eno\": \"2078069898\", \"lob\": \"GA - 2026\", \"pno\": 2074997435, \"zip\": \"04002\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LYMAN\", \"gend\": 0, \"insh\": \"10000068352\", \"mzip\": \"04002\", \"name\": \"Theodore M Libby\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PRAST, BRENDAN J\", \"ppno\": 2074907998, \"race\": \"\", \"cliId\": \"\", \"email\": \"dawnajl@yahoo.com\", \"ename\": \"Donna Libby \", \"madd1\": \"227 KENNEBUNK POND RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LYMAN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\\tMaineHealth Primary Care Family Medicine,\\t25A June St Ste 111\", \"pcpnpi\": 1043779804, \"pcpzip\": \"04073\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Sanford\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"evalDate\": \"2026-3-31 12:00 PM\", \"evalName\": \"Shellie Hafer, NP\", \"pcpfaxno\": 2074907999, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5JK6F05DA56\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"male \"}, {\"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-24-2026\", \"time\": \"14:03:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-01-2026 18:28:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-25T09:18\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 3, \"cancelText\": \"member unable to perform virtual appointment with his phone - F2F Call Back\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"10000068352\", \"clinician\": \"Shellie Hafer\", \"qaAnalyst\": \"Cynthia Bryan\", \"queryData\": [{\"date\": \"Wed, 01 Apr 2026 19:24:35 GMT\", \"name\": \"Cynthia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Shellie.\\n1). Could you please add steroid under long term use of for the Fluticasone?\\n2). Atenolol was noted in the med list for DX of CAD. Could you please add this to the Cardiovascular section under the Assessment of DX?\\n3). I saw that member received injection of Eliguard under Medical HX treatments received and that member is prescribed Nubeqa. Is member continuing to receive injections? Should this be added under the Prostate cancer section of Assessment of DX.?\\n5). For Osteoarthritis in the Musculoskeletal Assessment of DX medication was marked. Could you please add this to the med list?\\nThank you,\\nCindy\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 01 Apr 2026 22:28:40 GMT\", \"name\": \"Shellie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"The steroids have been added, CAD has been added. The Eliguard and Nubeqa are both for suppression therapy for the prostate cancer.  He takes osteobioflex for OA.  I have added to the OTC.\\nThanks\\nShellie \"}, \"mailId\": \"\"}], \"memberName\": \"Theodore Libby\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/31/2026 12:00 PM\", \"clinicianMailId\": \"s.hafer@focuscares.com\", \"qaAnalystMailId\": \"c.bryan@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/6/2026 @ 02:36 PM\", \"result\": 0, \"comment\": \"scheduled F2F w/ Shellie H 3/31/2026 at 12PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 02:28 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"3/10/2026 @ 02:28 PM\"}, {\"date\": \"2/25/2026 @ 09:18 AM\", \"result\": 14, \"comment\": \"member unable to do virtual appt - needs F2F call back\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/26/2026 @ 09:18 AM\"}, {\"date\": \"2/5/2026 @ 12:56 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Candace on  February 25, 2026 at 12:00pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/4/2026 @ 04:16 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 04:16 PM\"}, {\"date\": \"2/3/2026 @ 02:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"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\": {\"type\": \"visitType\", \"memberId\": \"10000068352\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": \"10000068352\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": \"10000068352\", \"scheduleDate\": \"2026-3-31T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:16:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}, {\"date\": \"02-25-2026 09:18:36\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-06-2026 14:36:18\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2026-04-07 14:08:31\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"9a490b84-eaaa-4373-9394-7aecc957c249\\\",\\\"destination_fax_number\\\":\\\"12074907999\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"9a490b84-eaaa-4373-9394-7aecc957c249\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12074907999\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"MaineHealth         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-04-07T18:13:22.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\\\":248,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":248,\\\"start_timestamp\\\":\\\"2026-04-07T18:08:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-04-07T18:13:22.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-31T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:37', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068352\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Libby_10000068352_03312026.pdf\", \"ftp_upload_date\": \"2026-04-07 14:08:31\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000068352.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Libby_10000068352_03312026.pdf', NULL, 'Summary_10000068352.pdf', NULL, '[{\"date\": \"2026-03-31T18:15:36.284Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-04-01T22:28:39.700Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-31T13:15', 'Member_Summary_10000068352.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068352\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000068352.pdf\", \"member_ftp_upload_date\": \"2026-04-07 14:08:32\"}', 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
(1812, NULL, NULL, NULL, '10000068364', '', '', NULL, 'James', 'Blalock', '', '', '{\"DOB\": 19890, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1801003595\", \"Pcp_Zip\": \"38018007\", \"Program\": \"Medicare\", \"Pcp_City\": \"NEWINGTON\", \"Pcp_Name\": \"REMBISZ, NICOLE S\", \"Rank_All\": 1, \"PCP_Phone\": \"6037423174\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"4D61F08UW02\", \"Member_City\": \"KITTERY\", \"Office_Name\": \"WHOLE LIFE HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"KITTERY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-06-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"100 SHATTUCK WAY STE 100,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"31 MANSON AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"03904\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"31 MANSON AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"03904\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Blalock\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Jmadden1202@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\": \"6038281049\", \"Member_Identification_Number\": \"10000068364\", \"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:50\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:50\", \"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:17:00\", \"value\": [{\"add\": \"31 MANSON AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-06-15\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"6038281049\", \"zip\": \"03904\", \"add2\": \"\", \"add3\": \"\", \"city\": \"KITTERY\", \"gend\": 0, \"insh\": \"10000068364\", \"mzip\": \"03904\", \"name\": \"James M Blalock\", \"plan\": \"Martin\'s Point\", \"pphy\": \"REMBISZ, NICOLE S\", \"ppno\": \"6037423174\", \"cliId\": \"\", \"email\": \"Jmadden1202@gmail.com\", \"ename\": \"\", \"madd1\": \"31 MANSON AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"KITTERY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 SHATTUCK WAY STE 100,\", \"pcpnpi\": \"1801003595\", \"pcpzip\": \"38018007\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"NEWINGTON\", \"pcpname\": \"WHOLE LIFE HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4D61F08UW02\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:00\"}', '{\"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/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:39:16\", \"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 09:59:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1813, NULL, NULL, NULL, '10000068372', '', '', '52498339', 'Todd', 'Oliver', 'English', '', '{\"DOB\": 25154, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1114339611\", \"Pcp_Zip\": \"40966729\", \"Program\": \"Medicare\", \"Pcp_City\": \"YARMOUTH\", \"Pcp_Name\": \"NEWCOMBE, JODI A\", \"Rank_All\": 1, \"PCP_Phone\": \"2075351200\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2KX1XQ4CM26\", \"Member_City\": \"TOPSHAM\", \"Office_Name\": \"NORTHERN LIGHT MERCY PRIMARY CARE YARMOUTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"TOPSHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1968-11-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"385 ROUTE 1,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"2075351249\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"144 MAIN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04086\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"144 MAIN ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04086\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Oliver\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Todd\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@081120.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\": \"2077512282\", \"Member_Identification_Number\": \"10000068372\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-08-2026 10:06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-04-08 10:06:21\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-08T10:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-04T17:55\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-04T17:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-08T10:06\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:01\", \"value\": [{\"add\": \"144 MAIN ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-11-12\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077512282\", \"zip\": \"04086\", \"add2\": \"\", \"add3\": \"\", \"city\": \"TOPSHAM\", \"gend\": 0, \"insh\": \"10000068372\", \"mzip\": \"04086\", \"name\": \"Todd A Oliver\", \"plan\": \"Martin\'s Point\", \"pphy\": \"NEWCOMBE, JODI A\", \"ppno\": \"2075351200\", \"cliId\": \"\", \"email\": \"declined@081120.com\", \"ename\": \"\", \"madd1\": \"144 MAIN ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"TOPSHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"385 ROUTE 1,\", \"pcpnpi\": \"1114339611\", \"pcpzip\": \"40966729\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"YARMOUTH\", \"pcpname\": \"NORTHERN LIGHT MERCY PRIMARY CARE YARMOUTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075351249\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2KX1XQ4CM26\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"4/8/2026 @ 10:06 AM\", \"result\": 1, \"comment\": \"o/c to sched w/Sandy 4/16\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"4/9/2026 @ 10:06 AM\"}, {\"date\": \"2/4/2026 @ 05:55 PM\", \"result\": 6, \"comment\": \"Called to schedule IHA- call back later in the year \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"4/3/2026 @ 05:55 PM\"}, {\"date\": \"2/3/2026 @ 05:52 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Lesly Rivera\", \"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-04-2026 17:55:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"01-31-2026 23:39:16\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', '{\"orderType\": 0, \"sortOrder\": 1775727840}', 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1814, NULL, NULL, '17537038', '10000068439', '', '', '52498339', 'Gail', 'Tauber', 'English', '', '{\"DOB\": 19872, \"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\": \"7WR4UH1WT76\", \"Member_City\": \"Biddeford\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Biddeford\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-05-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"19 DARTMOUTH ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"19 DARTMOUTH ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Tauber\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gail\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gailaktaub@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\": \"2072830549\", \"Member_Identification_Number\": \"10000068439\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Member will be out of town\"}', 1, b'0', b'0', '{\"date\": \"03-04-2026 16:01:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-04 16:01:58\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-04T16: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-04T11:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T15:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T14:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T14:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T13:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T16:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-06T11:41\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-17T09:49\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-06T11:41\", \"reportStatus_date\": \"2026-02-06T11:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-17T09:49\", \"reportStatus_date\": \"2026-02-20T15:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T14:53\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-04T16:01\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-06T11:41\", \"username\": null}, {\"date\": \"2026-02-06T11:41\", \"username\": \"AChevalier\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T09:49\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:03\", \"value\": [{\"add\": \"19 DARTMOUTH ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-05-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072830549\", \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Biddeford\", \"gend\": 1, \"insh\": \"10000068439\", \"mzip\": \"04005\", \"name\": \"Gail A Tauber\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STEELE, ERIK N\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"gailaktaub@gmail.com\", \"ename\": \"\", \"madd1\": \"19 DARTMOUTH ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Biddeford\", \"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\": \"7WR4UH1WT76\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:03\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T09:49\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"Member will be out of town\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 12:59 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/17\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 12:47 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/30/2026 @ 11:37 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 08:51 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 07:48 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 @ 11:04 AM\", \"result\": 13, \"comment\": \"Called to Schedule F2F HRA with Shellie caller disconnected.u00a0 \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 01:13 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 05:17 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 11:07 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 11:39 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 12:16 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 04:01 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:50 PM\", \"result\": 3, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"3/11/2026 @ 01:50 PM\"}, {\"date\": \"2/27/2026 @ 02:53 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 02:53 PM\"}, {\"date\": \"2/24/2026 @ 02:44 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/26/2026 @ 02:43 PM\"}, {\"date\": \"2/20/2026 @ 03:13 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 03:13 PM\"}, {\"date\": \"2/6/2026 @ 11:41 AM\", \"result\": 0, \"comment\": \"Scheduled with Amanda Milliken 2/21/2026 @ 12:00pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/4/2026 @ 11:49 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA- voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 11:45 AM\"}, {\"date\": \"2/3/2026 @ 01:07 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"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\": {\"type\": \"visitType\", \"memberId\": \"10000068439\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000068439\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000068439\", \"scheduleDate\": \"2026-2-21T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 11:49:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}, {\"date\": \"02-17-2026 09:49:12\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"03-04-2026 16:01:58\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 16}', NULL, 1, NULL, NULL, 'Virtual', '2026-2-21T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1815, NULL, NULL, NULL, '10000068457', '', '', '26056802', 'Ward', 'Ganger', '', '', '{\"DOB\": 19967, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1881655132\", \"Pcp_Zip\": \"04043\", \"Program\": \"Medicare\", \"Pcp_City\": \"Kennebunk\", \"Pcp_Name\": \"SCHWEMM, HEATHER N\", \"Rank_All\": 1, \"PCP_Phone\": \"2074678988\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8Q85Y20HA67\", \"Member_City\": \"Kennebunkport\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY AND INTERNAL MEDIC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Kennebunkport\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-08-31\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"SMHC Health Center Kennebunk,2 Livewell Dr North Tower\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"46 TURBATS CREEK RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04046\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"46 TURBATS CREEK RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04046\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Ganger\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ward\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"wganger@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\": \"\", \"Member_Identification_Number\": \"10000068457\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"6034181027\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-05-2026 11:12:36\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-05 11:12:36\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-05T11:12\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T11:12\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:03\", \"value\": [{\"add\": \"46 TURBATS CREEK RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"6034181027\", \"dob\": \"1954-08-31\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"6034181027\", \"zip\": \"04046\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Kennebunkport\", \"gend\": 0, \"insh\": \"10000068457\", \"mzip\": \"04046\", \"name\": \"Ward L Ganger\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCHWEMM, HEATHER N\", \"ppno\": \"2074678988\", \"cliId\": \"\", \"email\": \"wganger@gmail.com\", \"ename\": \"\", \"madd1\": \"46 TURBATS CREEK RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Kennebunkport\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"SMHC Health Center Kennebunk,2 Livewell Dr North Tower\", \"pcpnpi\": \"1881655132\", \"pcpzip\": \"04043\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Kennebunk\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY AND INTERNAL MEDIC\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8Q85Y20HA67\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/5/2026 @ 11:12 AM\", \"result\": 6, \"comment\": \"Call back when wife is in the system\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/15/2026 @ 11:12 AM\"}, {\"date\": \"1/27/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 11:12:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"01-31-2026 23:39:17\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1816, NULL, NULL, NULL, '10000068571', '', '', NULL, 'Alan', 'Mills', 'English', '', '{\"DOB\": 16097, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1992904080\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"SONTI, SMITA\", \"Rank_All\": 1, \"PCP_Phone\": \"2077998596\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3AT6DC2RF87\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-01-26\", \"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\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"317 PREBLE ST UNIT 1\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"317 PREBLE ST UNIT 1\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Mills\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alan\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"aljeevbr@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\": \"2074006170\", \"Member_Identification_Number\": \"10000068571\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":20,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', NULL, '{\"cron\": \"1\", \"date\": \"2026-01-31 23:39:17\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:07\", \"value\": [{\"add\": \"317 PREBLE ST UNIT 1\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1944-01-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074006170\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000068571\", \"mzip\": \"04106\", \"name\": \"Alan E Mills\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SONTI, SMITA\", \"ppno\": \"2077998596\", \"cliId\": \"\", \"email\": \"aljeevbr@gmail.com\", \"ename\": \"\", \"madd1\": \"317 PREBLE ST UNIT 1\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1992904080\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3AT6DC2RF87\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:07\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:39:17\", \"status\": 4, \"details\": \"member previous year scheduled date not exceed 10 months\", \"disabled\": true, \"notification\": null}', NULL, NULL, 0, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1817, NULL, NULL, NULL, '10000068655', '', '', '52197563', 'Peter', 'Bolduc', '', '', '{\"DOB\": 19880, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1497800734\", \"Pcp_Zip\": \"04988\", \"Program\": \"Medicare\", \"Pcp_City\": \"Unity\", \"Pcp_Name\": \"KRIEGEL, CHARLES B\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5VW6NV3FG81\", \"Member_City\": \"Winslow\", \"Office_Name\": \"NORTHERN LIGHT HEALTH CENTER UNITY\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winslow\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-06-05\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Sebasticook Valley Health,80 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078613281\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"301 BASSETT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"301 BASSETT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bolduc\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@041824.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078593030\", \"Member_Identification_Number\": \"10000068655\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-23-2026 12:49:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-23 12:49:35\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-23T12:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T10:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T14:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-13T11:18\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-23T12:49\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:20\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T11:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T14:15\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-23T12:49\", \"reportStatus_date\": \"2026-03-23T12:49\"}]', '{\"utc\": [{\"date\": \"2026-03-23T12:49\", \"username\": \"LAnguiano\"}], \"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:17:09\", \"value\": [{\"add\": \"301 BASSETT RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-06-05\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078593030\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Winslow\", \"gend\": 0, \"insh\": \"10000068655\", \"mzip\": \"04901\", \"name\": \"Peter R Bolduc\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KRIEGEL, CHARLES B\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@041824.com\", \"ename\": \"\", \"madd1\": \"301 BASSETT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winslow\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Sebasticook Valley Health,80 Main St\", \"pcpnpi\": \"1497800734\", \"pcpzip\": \"04988\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Unity\", \"pcpname\": \"NORTHERN LIGHT HEALTH CENTER UNITY\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078613281\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5VW6NV3FG81\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:09\"}', '{\"utc\": [{\"date\": \"2026-03-23T12:49\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/23/2026 @ 12:49 PM\", \"result\": 6, \"comment\": \"Called to get member scheduled with mphp virtual nurses -member wants call back later in the year\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 02:15 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point nurse Kathryn B- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 11:18 AM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Amanda but member requested a call back after 4:30 PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/19/2026 @ 11:17 AM\"}, {\"date\": \"2/10/2026 @ 10:13 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 10:12 AM\"}, {\"date\": \"2/3/2026 @ 10:26 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 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-10-2026 10:13:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"01-31-2026 23:39:17\", \"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 09:59:39', 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
(1818, NULL, NULL, NULL, '10000068664', '', '', NULL, 'Donald', 'Beairsto', 'English', '', '{\"DOB\": 19932, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1790792133\", \"Pcp_Zip\": \"03801\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portsmouth\", \"Pcp_Name\": \"OLIVE, STEVEN T\", \"Rank_All\": 1, \"PCP_Phone\": \"6034315154\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"8QM4R34PT72\", \"Member_City\": \"Wells\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Englewood\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-07-27\", \"Mailing_State\": \"FL\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,161 Corporate Dr\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sarasota\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"74 WILLOW BEND LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04090\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1400 BEACH RD UNIT 2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"34223\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Beairsto\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"donaldbeairsto@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"6035122848\", \"Member_Identification_Number\": \"10000068664\", \"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:20:40\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:20:40\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:20\", \"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:20\", \"reportStatus_date\": \"2026-02-03T06:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:20\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:10\", \"value\": [{\"add\": \"74 WILLOW BEND LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-07-27\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"6035122848\", \"zip\": \"04090\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Wells\", \"gend\": 0, \"insh\": \"10000068664\", \"mzip\": \"34223\", \"name\": \"Donald A Beairsto\", \"plan\": \"Martin\'s Point\", \"pphy\": \"OLIVE, STEVEN T\", \"ppno\": \"6034315154\", \"cliId\": \"\", \"email\": \"donaldbeairsto@gmail.com\", \"ename\": \"\", \"madd1\": \"1400 BEACH RD UNIT 2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Englewood\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"FL\", \"pcpadd\": \"Martins Point Health Care,161 Corporate Dr\", \"pcpnpi\": \"1790792133\", \"pcpzip\": \"03801\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portsmouth\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8QM4R34PT72\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:10\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:20\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/28/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:39:18\", \"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 09:59:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1819, NULL, NULL, NULL, '10000068675', '', '', NULL, 'Michele', 'Devou', '', '', '{\"DOB\": 19517, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1598054702\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"BUCHBERGER, GLENN K\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4R12QY6KP91\", \"Member_City\": \"Saco\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Saco\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-06-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"InterMed,84 Marginal Way Ste 700\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2075238597\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"145 MCKENNEY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04072\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"145 MCKENNEY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04072\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Devou\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michele\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Michelle.devou@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\": \"\", \"Member_Identification_Number\": \"10000068675\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2078072997\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:20:41\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:20:41\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:20\", \"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:20\", \"reportStatus_date\": \"2026-02-03T06:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:20\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:11\", \"value\": [{\"add\": \"145 MCKENNEY RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2078072997\", \"dob\": \"1953-06-07\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078072997\", \"zip\": \"04072\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Saco\", \"gend\": 1, \"insh\": \"10000068675\", \"mzip\": \"04072\", \"name\": \"Michele E Devou\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BUCHBERGER, GLENN K\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"Michelle.devou@gmail.com\", \"ename\": \"\", \"madd1\": \"145 MCKENNEY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Saco\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,84 Marginal Way Ste 700\", \"pcpnpi\": \"1598054702\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238597\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4R12QY6KP91\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:11\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:20\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/30/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:39:18\", \"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 09:59:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1820, NULL, NULL, NULL, '10000068724', '', '', '1019044', 'Raymond', 'Cray', '', '', '{\"DOB\": 19488, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1366559957\", \"Pcp_Zip\": \"04578\", \"Program\": \"Medicare\", \"Pcp_City\": \"Wiscasset\", \"Pcp_Name\": \"LINVILLE, CORTNEY\", \"Rank_All\": 1, \"PCP_Phone\": \"2078826008\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4GN8PG6QE52\", \"Member_City\": \"WISCASSET\", \"Office_Name\": \"WISCASSET FAMILY HEALTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WISCASSET\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-05-09\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Wiscasset Family Health,66 Water St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Lincoln\", \"Member_Country\": \"Lincoln\", \"PCP_Fax_Number\": \"2078827803\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"155 DICKINSON RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04578\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"155 DICKINSON RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04578\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Cray\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Raymond\", \"Member_Middle_name\": \"P\", \"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\": \"2078827113\", \"Member_Identification_Number\": \"10000068724\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073502990\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-05-2026 13:33:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-05 13:33:45\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T13:33\", \"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-13T12:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T14:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T11:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T13:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T13:33\", \"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-03T06:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T14:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-18T13:05\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T13:33\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:12\", \"value\": [{\"add\": \"155 DICKINSON RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2073502990\", \"dob\": \"1953-05-09\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078827113\", \"zip\": \"04578\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WISCASSET\", \"gend\": 0, \"insh\": \"10000068724\", \"mzip\": \"04578\", \"name\": \"Raymond P Cray\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LINVILLE, CORTNEY\", \"ppno\": \"2078826008\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"155 DICKINSON RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WISCASSET\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Wiscasset Family Health,66 Water St\", \"pcpnpi\": \"1366559957\", \"pcpzip\": \"04578\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Wiscasset\", \"pcpname\": \"WISCASSET FAMILY HEALTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078827803\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4GN8PG6QE52\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:12\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/23/2026 @ 12:49 PM\", \"result\": 3, \"comment\": \"03/23/2026- CALLED TO SCH -MPHP- VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 01:33 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 01:05 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 11:48 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/23/2026 @ 11:48 AM\"}, {\"date\": \"2/13/2026 @ 02:32 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/19/2026 @ 02:31 PM\"}, {\"date\": \"2/13/2026 @ 12:37 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana but no answer No VM setup. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/19/2026 @ 12:36 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\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-13-2026 12:37:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"03-05-2026 13:33:45\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:40', 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
(1821, 71932120, 44829497, '17537038', '10000068810', '', '', '1019044', 'Michael', 'Huitt', 'English', '', '{\"DOB\": 19965, \"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\": 1326334335, \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"CHRISTINA EDWARDS\", \"Rank_All\": 1, \"PCP_Phone\": 2077745816, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8EQ9RQ7MV37\", \"Member_City\": \"Buxton\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buxton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-08-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"84 Marginal Way Ste 700\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": 2075238597, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"429 RIVER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04093\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"429 RIVER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04093\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Huitt\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"mrhuitt1954@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2078381680, \"Member_Identification_Number\": \"10000068810\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:07:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:07:59\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T12:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T09:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-06T18:30\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-12T21:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-13T04:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-10T10:10\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-06T15:17\", \"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-06T12:49\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-10T10:10\", \"reportStatus_date\": \"2026-02-10T10:10\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-03-09T17:11\", \"reportStatus_date\": \"2026-03-06T18:30\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-13T04:53\", \"reportStatus_date\": \"2026-03-13T04:53\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:07\", \"reportStatus_date\": \"2026-03-17T16:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:07\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-10T10:10\", \"username\": null}, {\"date\": \"2026-02-10T10:10\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-03-06T15:17\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-09T16:40\", \"username\": \"AWalsh\"}, {\"date\": \"2026-03-09T16:44\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-06T18:30\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-06T18:30\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-11T16:59\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-13T04:53\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-12T21:52\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-13T04:53\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-09T17:11\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-10-2026\", \"time\": \"09:17:53\", \"value\": [{\"add\": \"429 RIVER RD\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-08-29\", \"eno\": \"2073297192\", \"lob\": \"GA - 2026\", \"pno\": 2078381680, \"zip\": \"04093\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Buxton\", \"gend\": 0, \"insh\": \"10000068810\", \"mzip\": \"04093\", \"name\": \"Michael R Huitt\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CHRISTINA EDWARDS\", \"ppno\": 2077745816, \"cliId\": \"\", \"email\": \"mrhuitt1954@gmail.com\", \"ename\": \"Linda Huitt\", \"madd1\": \"429 RIVER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buxton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"84 Marginal Way Ste 700\", \"pcpnpi\": 1326334335, \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2075238597, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8EQ9RQ7MV37\", \"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-06-2026\", \"time\": \"09:38:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 09:17:53\"}', NULL, NULL, '{\"memberId\": \"10000068810\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Mon, 09 Mar 2026 21:11:20 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1. The member is on medication for HLD. However, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition?\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Mar 2026 20:59:32 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Manoucheca, \\nI have updated the assessment section. \\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Michael Huitt\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/06/2026 02:45 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/10/2026 @ 10:10 AM\", \"result\": 0, \"comment\": \"Scheduled with Amanda Milliken 3/6/2026 @ 2:45pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 09:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/17/2026 @ 09:40 AM\"}, {\"date\": \"2/6/2026 @ 12:49 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 12:46 PM\"}, {\"date\": \"2/4/2026 @ 12:30 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/11/2026 @ 12:30 PM\"}, {\"date\": \"2/3/2026 @ 02:30 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"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\": {\"type\": \"visitType\", \"memberId\": \"10000068810\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000068810\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000068810\", \"scheduleDate\": \"2026-3-6T14:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 12:30:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"02-10-2026 10:10:03\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:07:59\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"bd27ff3a-5f49-4098-ac30-436e9aaf8496\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"bd27ff3a-5f49-4098-ac30-436e9aaf8496\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"8555764814\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:12:21.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":233,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":233,\\\"start_timestamp\\\":\\\"2026-03-17T20:08:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:12:21.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-6T14:45', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:40', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068810\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Huitt_10000068810_03062026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:07:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000068810.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Huitt_10000068810_03062026.pdf', NULL, 'Summary_10000068810.pdf', NULL, '[{\"date\": \"2026-03-06T23:30:06.710Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-11T20:59:32.101Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-06T15:33', 'Member_Summary_10000068810.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068810\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000068810.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:07:59\"}', 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
(1822, 55499828, 44829497, '27743162', '10000068838', '', '', '26056802', 'William', 'Ogle', 'English', '', '{\"DOB\": 17972, \"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\": \"1386683001\", \"Pcp_Zip\": \"03820\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Dover\", \"Pcp_Name\": \"WILLIAM HASSETT\", \"Rank_All\": 1, \"PCP_Phone\": \"6037423174\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"1VA7Y16DA59\", \"Member_City\": \"BERWICK\", \"Office_Name\": \"WHP DOVER FAMILY PRACTICE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Berwick\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-03-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"10 Members Way Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"6037421855\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"8 FRIENDSHIP CT \", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": \"03901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"8 Friendship Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"03901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Ogle\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"WO-MAG@comcast.net\", \"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\": \"2076981305\", \"Member_Identification_Number\": \"10000068838\", \"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:25:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:25:35\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T09:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-17T11:09\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T18:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T23:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-02-10T11:34\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-02-17T10:25\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T09:25\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-10T11:34\", \"reportStatus_date\": \"2026-02-10T11:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T23:02\", \"reportStatus_date\": \"2026-02-17T23:02\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:25\", \"reportStatus_date\": \"2026-03-03T17:25\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:25\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-10T11:34\", \"username\": null}, {\"date\": \"2026-02-10T11:34\", \"username\": \"JDingle\"}], \"inProgress\": [{\"date\": \"2026-02-17T10:25\", \"username\": \"SHafer\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T12:42\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-17T11:09\", \"username\": \"SHafer\"}, {\"date\": \"2026-02-17T11:09\", \"username\": \"SHafer\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T23:02\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T18:49\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T23:02\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-18-2026\", \"time\": \"16:19:32\", \"value\": [{\"add\": \"8 FRIENDSHIP CT \", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-03-15\", \"eno\": \"2076981305\", \"lob\": \"GA - 2026\", \"pno\": \"2076981305\", \"zip\": \"03901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BERWICK\", \"gend\": 0, \"insh\": \"10000068838\", \"mzip\": \"03901\", \"name\": \"William D Ogle\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WILLIAM HASSETT\", \"ppno\": \"6037423174\", \"cliId\": \"\", \"email\": \"WO-MAG@comcast.net\", \"ename\": \"Mary Ogle\", \"madd1\": \"8 Friendship Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Berwick\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"10 Members Way Ste 203\", \"pcpnpi\": \"1386683001\", \"pcpzip\": \"03820\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Dover\", \"pcpname\": \"WHP DOVER FAMILY PRACTICE\", \"program\": \"Medicare\", \"pcpfaxno\": \"6037421855\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1VA7Y16DA59\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"Male \"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-13-2026\", \"time\": \"13:28:50\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-18-2026 16:19:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": \"12\", \"callLog\": [{\"date\": \"2/10/2026 @ 11:34 AM\", \"result\": 12, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 09:25 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"2/18/2026 @ 09:25 AM\"}, {\"date\": \"2/3/2026 @ 01:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Carmen Valdez\", \"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\": {\"type\": \"visitType\", \"memberId\": \"10000068838\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": \"10000068838\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": \"10000068838\", \"scheduleDate\": \"2026-2-17T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 09:25:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"02-10-2026 11:34:10\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:25:34\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"455aadef-02ac-4cde-8d2c-9b29f325d7c7\\\",\\\"destination_fax_number\\\":\\\"16037421855\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"455aadef-02ac-4cde-8d2c-9b29f325d7c7\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"16037421855\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:31:40.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\\\":335,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":335,\\\"start_timestamp\\\":\\\"2026-03-03T22:25:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:31:40.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-17T10:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:40', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068838\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Ogle_10000068838_02172026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:25:32\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000068838.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Ogle_10000068838_02172026.pdf', NULL, 'Summary_10000068838.pdf', NULL, '[{\"date\": \"2026-02-17T16:09:06.831Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-17T11:07', 'Member_Summary_10000068838.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068838\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000068838.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:25:34\"}', 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
(1823, NULL, NULL, '52653458', '10000068866', '', '', '52197563', 'William', 'Lundgren', '', '', '{\"DOB\": 19896, \"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\": \"1M18EX4UQ22\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-06-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"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\": \"30 HARTLEY STREET\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"30 HARTLEY STREET\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Lundgren\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bill.lundgren@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\": \"2072328177\", \"Member_Identification_Number\": \"10000068866\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-19-2026 12:40:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-19 12:40:44\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-16T14:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-19T12:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T17:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T09:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T13:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T17:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T16:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-16T14:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-09T14:42\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2026-02-21T16:02\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-09T14:42\", \"reportStatus_date\": \"2026-02-09T14:42\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-21T16:02\", \"reportStatus_date\": \"2026-02-21T16:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T09:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-06T16:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-16T14:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-19T12:40\", \"reportStatus_date\": \"2026-03-19T12:40\"}]', '{\"utc\": [{\"date\": \"2026-03-19T12:40\", \"username\": \"FBeckford\"}], \"other\": [], \"noShow\": [{\"date\": \"2026-02-21T16:02\", \"username\": \"NHoneychuck\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-09T14:42\", \"username\": null}, {\"date\": \"2026-02-09T14:42\", \"username\": \"jsmith\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:17\", \"value\": [{\"add\": \"30 HARTLEY STREET\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-06-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072328177\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 0, \"insh\": \"10000068866\", \"mzip\": \"04103\", \"name\": \"William J Lundgren\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STATON, MEGAN\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"bill.lundgren@gmail.com\", \"ename\": \"\", \"madd1\": \"30 HARTLEY STREET\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"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\": \"1M18EX4UQ22\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-20-2026\", \"time\": \"12:32:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:17\"}', '{\"utc\": [{\"date\": \"2026-03-19T12:40\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [{\"date\": \"2026-02-21T16:02\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NHoneychuck\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/23/2026 @ 03:21 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Pamela 3/30\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 03:49 PM\", \"result\": 3, \"comment\": \"calling member back to resched w/Pamela\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 12:40 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Pamela but member requested a call back. after 3pm member was going into court  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 12:01 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 02:44 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 04:12 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/10/2026 @ 04:09 PM\"}, {\"date\": \"3/4/2026 @ 05:06 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/9/2026 @ 05:05 PM\"}, {\"date\": \"3/3/2026 @ 01:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/6/2026 @ 01:02 PM\"}, {\"date\": \"2/24/2026 @ 09:41 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/26/2026 @ 09:41 AM\"}, {\"date\": \"2/9/2026 @ 02:42 PM\", \"result\": 0, \"comment\": \"scheduled virtual w/ Nancy Honeychuck 2/21/2026 at 12PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 05:03 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/11/2026 @ 05:02 PM\"}, {\"date\": \"2/4/2026 @ 04:55 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/9/2026 @ 04:54 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\": {\"type\": \"visitType\", \"memberId\": \"10000068866\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"52653458\", \"memberId\": \"10000068866\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"52653458\", \"memberId\": \"10000068866\", \"scheduleDate\": \"2026-2-21T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:55:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}, {\"date\": \"02-21-2026 16:02:52\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-16-2026 14:44:05\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, 'Virtual', '2026-2-21T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1824, NULL, NULL, NULL, '10000068914', '', '', '52661009', 'Norman', 'Bergeron', '', '', '{\"DOB\": 19232, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1760584007\", \"Pcp_Zip\": \"04062\", \"Program\": \"Medicare\", \"Pcp_City\": \"WINDHAM\", \"Pcp_Name\": \"CHASE, SCOTT M\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8RP0GT0TW37\", \"Member_City\": \"OLD ORCHARD BEACH\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OLD ORCHARD BEACH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-08-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"582 ROOSEVELT TRAIL,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"3 RESERVE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04064\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 RESERVE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04064\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Bergeron\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Norman\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45658, \"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\": \"2079344693\", \"Member_Identification_Number\": \"10000068914\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076534483\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 14:14:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-03 14:14:14\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-03T14:14\", \"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-04T16:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T17:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T14:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T14:14\", \"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-06T13:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T14:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T14:14\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:17:19\", \"value\": [{\"add\": \"3 RESERVE ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2076534483\", \"dob\": \"1952-08-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2079344693\", \"zip\": \"04064\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OLD ORCHARD BEACH\", \"gend\": 0, \"insh\": \"10000068914\", \"mzip\": \"04064\", \"name\": \"Norman R Bergeron\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CHASE, SCOTT M\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3 RESERVE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OLD ORCHARD BEACH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"582 ROOSEVELT TRAIL,\", \"pcpnpi\": \"1760584007\", \"pcpzip\": \"04062\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"WINDHAM\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8RP0GT0TW37\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:41\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:17:19\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 02:06 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/17\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 02:59 PM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/30/2026 @ 09:28 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafe\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 12:04 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer No VM Setup\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:49 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/23/2026 @ 01:57 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Pamela 3/30 - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 05:54 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- no vm \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- no vm \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 12:30 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- no vm setup\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- no vm setup \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 04:22 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer No VM Setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 02:14 PM\", \"result\": 3, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:10 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 05:17 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Amanda - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 01:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/11/2026 @ 01:01 PM\"}, {\"date\": \"2/4/2026 @ 04:57 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 04:57 PM\"}, {\"date\": \"2/3/2026 @ 03:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"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:57:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-03-2026 14:14:14\", \"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 09:59:41', 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
(1825, 57818338, 44829497, '31048908', '10000068919', '', '', NULL, 'Deborah', 'Noble', 'English', '', '{\"DOB\": 19550, \"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\": \"1750580486\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"JEFFREY GRASSMANN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4YW6GT2JR59\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-07-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 GANNETT DR STE C\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"757 MAIN ST APT 7\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"757 MAIN ST APT 7\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Noble\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deborah\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Dnoble732@yahoo.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2077769433\", \"Member_Identification_Number\": \"10000068919\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077769433\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:25:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:25:41\", \"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-07T20:58\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-23T21:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T23:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-02T14:18\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-07T12:23\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-02T14:18\", \"reportStatus_date\": \"2026-02-02T14:18\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-07T20:58\", \"reportStatus_date\": \"2026-02-07T20:58\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T23:36\", \"reportStatus_date\": \"2026-02-23T23:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:25\", \"reportStatus_date\": \"2026-03-03T17:25\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:25\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-02T14:18\", \"username\": \"GMedranoAdmin\"}], \"inProgress\": [{\"date\": \"2026-02-07T12:23\", \"username\": \"NMattison\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:49\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-10T09:59\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-07T20:58\", \"username\": \"NMattison\"}, {\"date\": \"2026-02-07T20:58\", \"username\": \"NMattison\"}, {\"date\": \"2026-02-19T23:46\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-21T12:20\", \"username\": \"NMattison\"}, {\"date\": \"2026-02-21T21:51\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-23T11:29\", \"username\": \"NMattison\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T23:36\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T21:54\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T23:36\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T23:47\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-21T21:51\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-18-2026\", \"time\": \"16:21:51\", \"value\": [{\"add\": \"757 MAIN ST APT 7\", \"age\": 72, \"ano\": \"\", \"cno\": \"2077769433\", \"dob\": \"1953-07-10\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2077769433\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 1, \"insh\": \"10000068919\", \"mzip\": \"04106\", \"name\": \"Deborah J Noble\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JEFFREY GRASSMANN\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"Dnoble732@yahoo.com\", \"ename\": \"\", \"madd1\": \"757 MAIN ST APT 7\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DR STE C\", \"pcpnpi\": \"1750580486\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4YW6GT2JR59\", \"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-06-2026\", \"time\": \"15:59:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-18-2026 16:21:51\"}', NULL, NULL, '{\"memberId\": \"10000068919\", \"clinician\": \"Nicole Mattison\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Fri, 20 Feb 2026 04:47:30 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Nicole,\\n1.  Demographics gender needs answer.\\n2.  AOD Respiratory med list reports COPD please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 21 Feb 2026 17:20:41 GMT\", \"name\": \"Nicole \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I answered gender.\\n\\nShe did not tell me she had COPD, she reported asthma and I had documented that.  \\n\\nNikki\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 22 Feb 2026 02:51:43 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Nicole,\\n1.  AOD Respiratory section of the HRA med list reports COPD please add to this section of the HRA.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 16:29:42 GMT\", \"name\": \"Nicole \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Deborah Noble\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/07/2026 12:00 PM\", \"clinicianMailId\": \"n.mattison@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000068919, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"31048908\", \"memberId\": 10000068919}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"31048908\", \"memberId\": 10000068919, \"scheduleDate\": \"2026-02-07T12:00:00.000\"}}', NULL, '{\"date\": \"02-02-2026 14:18:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', NULL, NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:25:39\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"2d6c74be-376d-4d12-950a-a71ed3db251d\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"2d6c74be-376d-4d12-950a-a71ed3db251d\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:43:52.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:25:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:30:24.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:32:42.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:33:56.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:36:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:37:13.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:39:21.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:40:37.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:42:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:43:52.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-07T12:00:00.000', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:41', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068919\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Noble_10000068919_02072026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:25:38\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000068919.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Noble_10000068919_02072026.pdf', NULL, 'Summary_10000068919.pdf', NULL, '[{\"date\": \"2026-02-08T01:58:48.882Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-21T17:20:40.916Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T16:29:40.621Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-07T13:15', 'Member_Summary_10000068919.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000068919\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000068919.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:25:40\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
