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
(500, 93442164, 44829497, '39698290', '10000012611', '', '', '52197563', 'John', 'Hale', 'English', '', '{\"DOB\": 16933, \"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\": 1235216094, \"Pcp_Zip\": \"04364\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Winthrop\", \"Pcp_Name\": \"BROWN, BENJAMIN M\", \"Rank_All\": 1, \"PCP_Phone\": 2073772111, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9VJ7YH2PQ58\", \"Member_City\": \"North Monmouth\", \"Office_Name\": \"WINTHROP FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"North Monmouth\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-05-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Winthrop Family Medicine,16 Commerce Plaza Ste 3A\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2076243845, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"59 HIGHLAND TERRACE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04265\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 195\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04265\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hale\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"oarlock@twc.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2079334024, \"Member_Identification_Number\": \"10000012611\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 14:59:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 14:59:26\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T16:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-14T19:36\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-19T20:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-20T18:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T14:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-05T14:58\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-02-23T13:05\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-03-13T12:31\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-23T13:00\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-05T14:58\", \"reportStatus_date\": \"2026-02-05T14:58\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-23T13:05\", \"reportStatus_date\": \"2026-02-23T13:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-14T19:36\", \"reportStatus_date\": \"2026-03-14T19:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-20T18:10\", \"reportStatus_date\": \"2026-03-20T18:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T14:59\", \"reportStatus_date\": \"2026-03-24T14:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T14:59\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-05T14:58\", \"username\": null}, {\"date\": \"2026-02-05T14:58\", \"username\": \"cwasilak\"}, {\"date\": \"2026-02-23T13:05\", \"username\": null}, {\"date\": \"2026-02-23T13:05\", \"username\": \"JDingle\"}], \"inProgress\": [{\"date\": \"2026-03-13T12:31\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:52\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-14T19:36\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-14T19:36\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-20T18:10\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-19T20:45\", \"username\": \"mscanlon1\"}, {\"date\": \"2026-03-20T16:30\", \"username\": \"SCadwell\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-20T18:10\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-23T13:00\", \"username\": \"JDingle\"}], \"clinicianReviewCoder\": [{\"date\": \"2026-03-20T14:04\", \"username\": \"JWren1\"}, {\"date\": \"2026-03-20T16:30\", \"username\": \"SCadwell\"}], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-13-2026\", \"time\": \"12:31:41\", \"value\": [{\"add\": \"59 HIGHLAND TERRACE\", \"age\": 79, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-05-11\", \"eno\": \"2075228656\", \"lob\": \"GA - 2026\", \"pno\": 2079334024, \"zip\": \"04265\", \"add2\": \"\", \"add3\": \"\", \"city\": \"North Monmouth\", \"gend\": 0, \"insh\": \"10000012611\", \"mzip\": \"04265\", \"name\": \"John Hale\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BROWN, BENJAMIN M\", \"ppno\": 2073772111, \"cliId\": \"\", \"email\": \"oarlock@twc.com\", \"ename\": \"Valerie Enos \", \"madd1\": \"PO BOX 195\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"North Monmouth\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Winthrop Family Medicine,16 Commerce Plaza Ste 3A\", \"pcpnpi\": 1235216094, \"pcpzip\": \"04364\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Winthrop\", \"pcpname\": \"WINTHROP FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2076243845, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9VJ7YH2PQ58\", \"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-12-2026\", \"time\": \"12:29:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 16:30:49\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-23T13:00\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 3, \"cancelText\": \"The member canceled his previous appointment due to technical issues, including computer and phone service outages.\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"10000012611\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Jared Wren\", \"queryData\": [{\"date\": \"Fri, 20 Mar 2026 18:04:18 GMT\", \"name\": \"Jared \", \"role\": \"coder_lead\", \"files\": [], \"query\": {\"feedback\": \"Hello,\\n\\nThe meds list indicates that the member is taking medication for Parkinsonism. If this is an active diagnosis, could you please add it to the assessment section of the HRA? Thank you.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Mar 2026 20:30:49 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Added parkinsonism under neuro in comment box\"}, \"mailId\": \"\"}], \"memberName\": \"John Hale\", \"codingAnalyst\": \"\", \"dateOfService\": \"\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"j.wren@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"2/23/2026 @ 01:05 PM\", \"result\": 12, \"comment\": \"The member is rescheduled w/Sandra Cadwell 3/13 at 12 PM. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 02:58 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Candace on February 24, 2026 at 11:00am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 12:11 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Roody Dodoye\", \"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\": \"10000012611\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000012611\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000012611\", \"scheduleDate\": \"2026-3-13T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 14:58:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}, {\"date\": \"02-23-2026 13:00:37\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-23-2026 13:05:49\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 14:59:23\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"729c2dcd-3398-4b31-a3ca-69f0b39cc17f\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"729c2dcd-3398-4b31-a3ca-69f0b39cc17f\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"207 624 3845\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:05:53.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":7,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":1,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":186,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T18:59:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:00:10.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":186,\\\"start_timestamp\\\":\\\"2026-03-24T19:02:21.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:05:53.005+0000\\\",\\\"pages_sent\\\":7,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-13T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:01', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012611\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Hale_10000012611_03132026.pdf\", \"ftp_upload_date\": \"2026-03-24 14:59:22\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000012611.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Hale_10000012611_03132026.pdf', NULL, 'Summary_10000012611.pdf', NULL, '[{\"date\": \"2026-03-14T23:36:45.130Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-20T20:30:48.538Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-13T13:40', 'Member_Summary_10000012611.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012611\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000012611.pdf\", \"member_ftp_upload_date\": \"2026-03-24 14:59:25\"}', 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
(501, NULL, NULL, NULL, '10000012632', '', '', NULL, 'Sandra', 'Hutchinson', '', '', '{\"DOB\": 16929, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1356796353\", \"Pcp_Zip\": \"04073\", \"Program\": \"Medicare\", \"Pcp_City\": \"Sanford\", \"Pcp_Name\": \"GIBSON, AMANDA R\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4DX7YC5JH63\", \"Member_City\": \"Lebanon\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lebanon\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-05-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"MaineHealth Primary Care Family Medicine,25A June St Ste 111\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"179 GODING RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04027\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"179 GODING RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04027\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Hutchinson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sandra\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"greenthumb68@metrocast.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2074572038\", \"Member_Identification_Number\": \"10000012632\", \"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:21:15\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:21:15\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:21\", \"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:21\", \"reportStatus_date\": \"2026-02-03T06:21\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:21\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:21\", \"value\": [{\"add\": \"179 GODING RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-05-07\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074572038\", \"zip\": \"04027\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Lebanon\", \"gend\": 1, \"insh\": \"10000012632\", \"mzip\": \"04027\", \"name\": \"Sandra L Hutchinson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GIBSON, AMANDA R\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"greenthumb68@metrocast.net\", \"ename\": \"\", \"madd1\": \"179 GODING RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lebanon\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"MaineHealth Primary Care Family Medicine,25A June St Ste 111\", \"pcpnpi\": \"1356796353\", \"pcpzip\": \"04073\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Sanford\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4DX7YC5JH63\", \"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:52:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:21\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:21\", \"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:31:35\", \"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:52:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(502, NULL, NULL, NULL, '10000012802', '', '', '94743867', 'Barbara', 'Cary', '', '', '{\"DOB\": 16969, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1114214509\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"EWER, ADRIENNE M\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073300\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2QP5AF5PQ62\", \"Member_City\": \"Lewiston\", \"Office_Name\": \"ST JOSEPH INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Topsham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-06-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"St Joseph Internal Medicine,900 Broadway Bldg 5\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2079071923\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"102 CAMPUS AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04240\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1055 FORESIDE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04086\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cary\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Barbara\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 46026, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"grandma.barby.1@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078296235\", \"Member_Identification_Number\": \"10000012802\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 09:51:35\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}', '{\"date\": \"2026-04-07 09:51:35\", \"hrastatus\": \"\", \"reportstatus\": \"Disconnected\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-04T18:02\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-06T11:10\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-17T12:15\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-25T14:38\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-26T14:12\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-27T10:07\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-03T11:26\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-04T14:21\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-06T12:27\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-17T10:10\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-20T16:36\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-24T14:11\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-25T12:24\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-26T13:06\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-27T13:34\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-31T10:06\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-06T11:33\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-07T09:51\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T11:10\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-17T12:15\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T10:07\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-06T12:27\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-20T16:36\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-27T13:34\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-06T11:33\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-07T09:51\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:26\", \"value\": [{\"add\": \"102 CAMPUS AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-06-16\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078296235\", \"zip\": \"04240\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Lewiston\", \"gend\": 1, \"insh\": \"10000012802\", \"mzip\": \"04086\", \"name\": \"Barbara D Cary\", \"plan\": \"Martin\'s Point\", \"pphy\": \"EWER, ADRIENNE M\", \"ppno\": \"2079073300\", \"cliId\": \"\", \"email\": \"grandma.barby.1@gmail.com\", \"ename\": \"\", \"madd1\": \"1055 FORESIDE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Topsham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"St Joseph Internal Medicine,900 Broadway Bldg 5\", \"pcpnpi\": \"1114214509\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"ST JOSEPH INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079071923\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2QP5AF5PQ62\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 10, \"callLog\": [{\"date\": \"4/7/2026 @ 09:51 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 11:33 AM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Samuel number disconnected. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 10:06 AM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Pamela Kratzer\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 01:34 PM\", \"result\": 10, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 01:06 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:24 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 02:11 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 04:36 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Pamela 3/30\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 10:10 AM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Samuel number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 12:27 PM\", \"result\": 10, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 02:21 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 11:26 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 10:07 AM\", \"result\": 10, \"comment\": \"o/c to sched F2F HA w/Jennifer 3/5\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 02:12 PM\", \"result\": 10, \"comment\": \"o/c to sched w/Jennifer 3/5\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 02:38 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Samuel number disconnected.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 12:15 PM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ Nicole Mattison DISCONNECTED. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/20/2026 @ 12:15 PM\"}, {\"date\": \"2/6/2026 @ 08:10 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/20/2026 @ 08:09 AM\"}, {\"date\": \"2/4/2026 @ 05:02 PM\", \"result\": 10, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 05:01 PM\"}, {\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 17:02:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"04-07-2026 09:51:35\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 19}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(503, NULL, NULL, NULL, '10000012812', '', '', '94743867', 'Harold', 'Snowman', 'English', '', '{\"DOB\": 15970, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1114308277\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"RIDDLEBERGER, JAMES M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6V96RQ5KW55\", \"Member_City\": \"Windham\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Windham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-09-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"31 POPE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"31 POPE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Snowman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Harold\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"HSNOWMAN2001@YAHOO.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072528451\", \"Member_Identification_Number\": \"10000012812\", \"Member_Alternate_Phone_Number\": \"2078928195\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-23-2026 11:41:04\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-23 11:41:05\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-23T11:41\", \"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-04T13:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T17:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T15:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T09:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T11:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T17:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T09:55\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T11:41\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:27\", \"value\": [{\"add\": \"31 POPE RD\", \"age\": \"\", \"ano\": \"2078928195\", \"cno\": \"\", \"dob\": \"1943-09-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072528451\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Windham\", \"gend\": 0, \"insh\": \"10000012812\", \"mzip\": \"04062\", \"name\": \"Harold P Snowman\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RIDDLEBERGER, JAMES M\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"HSNOWMAN2001@YAHOO.COM\", \"ename\": \"\", \"madd1\": \"31 POPE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Windham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1114308277\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6V96RQ5KW55\", \"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:52:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:27\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 09:22 AM\", \"result\": 3, \"comment\": \"called to schedule w/ Jennifer Landry\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 11:21 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 01:49 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:51 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 01:50 PM\", \"result\": 3, \"comment\": \"called to schedule F2F with Sandy\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 11:59 AM\", \"result\": 3, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 11:41 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 2/24 or 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 09:55 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 03:13 PM\", \"result\": 3, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/18/2026 @ 03:13 PM\"}, {\"date\": \"2/9/2026 @ 05:25 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 05:23 PM\"}, {\"date\": \"2/4/2026 @ 12:48 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; Left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 12:47 PM\"}, {\"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-04-2026 12:48:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-23-2026 11:41:04\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:02', 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
(504, 55499828, 44829497, '17537038', '10000012817', '', '', '1019044', 'Hazel', 'Fiedler', 'English', '', '{\"DOB\": 16662, \"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\": 1346225711, \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"WALDRON, ROSALIND\", \"Rank_All\": 1, \"PCP_Phone\": 2078725139, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2JP4MD7KC81\", \"Member_City\": \"Oakland\", \"Office_Name\": \"ROSALIND WALDRON MD\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Oakland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-08-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"32 College Ave Ste 203,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2078725148, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"13 Junipers Lane Unit 1\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04963\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"13 Junipers Lane Unit 1\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04963\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Fiedler\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Hazel\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"KFIED@yahoo.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\": \"2077024179\", \"Member_Identification_Number\": \"10000012817\", \"Member_Alternate_Phone_Number\": 2077024179}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:51:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:51:08\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T14:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T14:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-15T16:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-25T09:33\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-27T13:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-27T15:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-16T14:48\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-25T08:00\", \"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-26T14:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T14:37\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-16T14:48\", \"reportStatus_date\": \"2026-03-16T14:48\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-27T15:02\", \"reportStatus_date\": \"2026-03-27T15:02\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:51\", \"reportStatus_date\": \"2026-03-31T13:51\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:51\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-16T14:48\", \"username\": null}, {\"date\": \"2026-03-16T14:48\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-03-25T08:00\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-25T09:51\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-25T09:33\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-25T09:33\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-26T20:17\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-27T12:55\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-27T15:02\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-27T13:30\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-27T15:02\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-26T20:17\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-26T20:18\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-25-2026\", \"time\": \"08:42:55\", \"value\": [{\"add\": \"13 Junipers Lane Unit 1\", \"age\": 80, \"ano\": 2077024179, \"cno\": \"\", \"dob\": \"1945-08-13\", \"eno\": \"6159391040\", \"lob\": \"GA - 2026\", \"pno\": \"2077024179\", \"zip\": \"04963\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Oakland\", \"gend\": 1, \"insh\": \"10000012817\", \"mzip\": \"04963\", \"name\": \"Hazel K Fiedler\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WALDRON, ROSALIND\", \"ppno\": 2078725139, \"cliId\": \"\", \"email\": \"KFIED@yahoo.com\", \"ename\": \"Craig \", \"madd1\": \"13 Junipers Lane Unit 1\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Oakland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"32 College Ave Ste 203,\", \"pcpnpi\": 1346225711, \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"ROSALIND WALDRON MD\", \"program\": \"Medicare\", \"pcpfaxno\": 2078725148, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2JP4MD7KC81\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-23-2026\", \"time\": \"17:11:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-27-2026 12:55:09\"}', NULL, NULL, '{\"memberId\": \"10000012817\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 27 Mar 2026 00:17:39 GMT\", \"name\": \"HBeck\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda,\\n1) Under the Neuro section can you select yes or no\\n2) Under BMI can you select moderate obesity \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 27 Mar 2026 00:18:02 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda,\\n1) Under the Neuro section can you select yes or no\\n2) Under BMI can you select moderate obesity \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 27 Mar 2026 16:55:08 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Hazel Fiedler\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/25/2026 08:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/16/2026 @ 02:48 PM\", \"result\": 0, \"comment\": \"Scheduled with Amanda Millikin 3/25/2026 @ 8:00am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 04:11 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"3/27/2026 @ 04:10 PM\"}, {\"date\": \"3/9/2026 @ 02:37 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/13/2026 @ 02:37 PM\"}, {\"date\": \"2/26/2026 @ 02:26 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 02:25 PM\"}, {\"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\": {\"type\": \"visitType\", \"memberId\": \"10000012817\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000012817\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000012817\", \"scheduleDate\": \"2026-3-25T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-26-2026 14:26:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"03-16-2026 14:48:51\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:51:07\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3fc381fe-e1a6-4a3b-8889-da4e9dbe5dd5\\\",\\\"destination_fax_number\\\":\\\"12078725148\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3fc381fe-e1a6-4a3b-8889-da4e9dbe5dd5\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12078725148\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:55:39.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-03-31T17:51:20.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:55:39.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-25T08:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:02', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012817\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Fiedler_10000012817_03252026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:51:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000012817.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Fiedler_10000012817_03252026.pdf', NULL, 'Summary_10000012817.pdf', NULL, '[{\"date\": \"2026-03-25T13:33:09.494Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-27T16:55:08.075Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-25T08:42', 'Member_Summary_10000012817.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012817\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000012817.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:51:07\"}', 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
(505, NULL, NULL, NULL, '10000012872', '', '', '543416', 'Geoffrey', 'Howitt', '', '', '{\"DOB\": 16665, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1548293772\", \"Pcp_Zip\": \"41013776\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"STOCKWELL, GEORGE W\", \"Rank_All\": 1, \"PCP_Phone\": \"2078930290\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5MK4JW2UF81\", \"Member_City\": \"Windham\", \"Office_Name\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Windham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-08-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"144 STATE ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078930295\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"30 POPE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"30 POPE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Howitt\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Geoffrey\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"GEOFFREYHOWITT@YAHOO.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078925449\", \"Member_Identification_Number\": \"10000012872\", \"Member_Alternate_Phone_Number\": \"2078925449\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 11:20:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-24 11:20:14\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-04T12:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-24T11:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-09T16:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T15:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T14:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T12:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T11:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T12:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T16:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T14:49\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T11:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-04T12:35\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-24T11:20\", \"reportStatus_date\": \"2026-03-24T11:20\"}]', '{\"utc\": [{\"date\": \"2026-03-24T11:20\", \"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\": \"00:46:29\", \"value\": [{\"add\": \"30 POPE RD\", \"age\": \"\", \"ano\": \"2078925449\", \"cno\": \"\", \"dob\": \"1945-08-16\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078925449\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Windham\", \"gend\": 0, \"insh\": \"10000012872\", \"mzip\": \"04062\", \"name\": \"Geoffrey Howitt\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STOCKWELL, GEORGE W\", \"ppno\": \"2078930290\", \"cliId\": \"\", \"email\": \"GEOFFREYHOWITT@YAHOO.COM\", \"ename\": \"\", \"madd1\": \"30 POPE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Windham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"144 STATE ST,\", \"pcpnpi\": \"1548293772\", \"pcpzip\": \"41013776\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078930295\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5MK4JW2UF81\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:29\"}', '{\"utc\": [{\"date\": \"2026-03-24T11:20\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/24/2026 @ 11:20 AM\", \"result\": 6, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- member is going through cancer treatments call back possibly to schedule in july \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 01:51 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:54 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f, member couldnt hear me very well \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 09:35 AM\", \"result\": 13, \"comment\": \"called to schedule F2F with Sandy, MEMBER ADV HE HAS ALOT OF APPT AND DISCONNECTED THE CALL\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 11:44 AM\", \"result\": 13, \"comment\": \"o/c to sched w/Sandy 2/24 or 3/9 - member said there\'s a foot of snow coming for tomorrow then he hung up on me\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 12:16 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 02:49 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 02:49 PM\"}, {\"date\": \"2/12/2026 @ 03:13 PM\", \"result\": 3, \"comment\": \"02/12/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/25/2026 @ 03:13 PM\"}, {\"date\": \"2/9/2026 @ 04:07 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/13/2026 @ 04:07 PM\"}, {\"date\": \"1/22/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-12-2026 15:13:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"03-04-2026 12:35:27\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(506, NULL, NULL, NULL, '10000012935', '', '', '52498339', 'Faye', 'Brown', '', '', '{\"DOB\": 17028, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Program\": \"Medicare\", \"Pcp_City\": \"\", \"Rank_All\": 1, \"Medicare_ID\": \"9AA3WX4TX87\", \"Member_City\": \"Lisbon Falls\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lisbon Falls\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-08-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"4 BOOKER ST\", \"Member_Zip_Code\": \"04252\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4 BOOKER ST\", \"Mailing_Zip_Code\": \"04252\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Faye\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"NOEMAIL71423@NOREPLY.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2078378105, \"Member_Identification_Number\": \"10000012935\", \"Member_Alternate_Phone_Number\": 2074074008}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-04-2026 16:45:29\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-04 16:45:29\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-04T16:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T18:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T18:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T16:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T11:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T16:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-04T18:23\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T18:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T16:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T11:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-04T16:45\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"02-23-2026\", \"time\": \"23:36:09\", \"value\": [{\"add\": \"4 BOOKER ST\", \"age\": \"\", \"ano\": 2074074008, \"cno\": \"\", \"dob\": \"1946-08-14\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2078378105, \"zip\": \"04252\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Lisbon Falls\", \"gend\": 1, \"insh\": \"10000012935\", \"mzip\": \"04252\", \"name\": \"Faye E Brown\", \"plan\": \"Martin\'s Point\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"NOEMAIL71423@NOREPLY.COM\", \"ename\": \"\", \"madd1\": \"4 BOOKER ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lisbon Falls\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9AA3WX4TX87\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-03-2026 00:11:12\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 10:28 AM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 11:29 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 06:44 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH  VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 03:50 PM\", \"result\": 3, \"comment\": \"called to schedule with sandra cadwell f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 03:11 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 04:45 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sam 3/8\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 11:29 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/12\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 04:36 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 06:07 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/17/2026 @ 06:07 PM\"}, {\"date\": \"2/4/2026 @ 06:23 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/5/2026 @ 06:23 PM\"}, {\"date\": \"2/3/2026 @ 11:59 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa Scott\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 18:23:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"03-04-2026 16:45:29\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(507, NULL, NULL, NULL, '10000012943', '', '', '52661009', 'Francis', 'Meehan', 'English', '', '{\"DOB\": 15195, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": 1073586491, \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"HOFFMAN, SARA M\", \"Rank_All\": 1, \"PCP_Phone\": 2077998596, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1WH6Q85VA45\", \"Member_City\": \"OCEAN PARK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OCEAN PARK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-08-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"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\": \"13 TIOGA AVE\", \"Member_Zip_Code\": \"04063\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 7097\", \"Mailing_Zip_Code\": \"04063\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Meehan\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Francis\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Fmeeh12@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2075303609, \"Member_Identification_Number\": \"10000012943\", \"Member_Secondary_Phone_Number\": 2074854497}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-27-2026 14:32:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-27 14:32:55\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-27T14:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T16:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T17:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T14:32\", \"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-06T12:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T17:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T14:32\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"02-23-2026\", \"time\": \"23:36:10\", \"value\": [{\"add\": \"13 TIOGA AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": 2074854497, \"dob\": \"1941-08-07\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2075303609, \"zip\": \"04063\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OCEAN PARK\", \"gend\": 0, \"insh\": \"10000012943\", \"mzip\": \"04063\", \"name\": \"Francis W Meehan\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HOFFMAN, SARA M\", \"ppno\": 2077998596, \"cliId\": \"\", \"email\": \"Fmeeh12@gmail.com\", \"ename\": \"\", \"madd1\": \"PO BOX 7097\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OCEAN PARK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": 1073586491, \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078287850, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1WH6Q85VA45\", \"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:52:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-03-2026 00:11:12\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 01:53 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/17\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 10:23 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 @ 03:02 PM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 10:54 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:41 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM.u00a0 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 01:43 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 05:37 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:49 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 @ 12:23 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 03:06 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:19 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 @ 02:11 PM\", \"result\": 3, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:32 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:10 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 12:50 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 @ 12:49 PM\"}, {\"date\": \"2/5/2026 @ 04:42 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:41 PM\"}, {\"date\": \"2/4/2026 @ 04:37 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 04: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-04-2026 16:37:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-27-2026 14:32:55\", \"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:52:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(508, NULL, NULL, NULL, '10000012947', '', '', NULL, 'Lucien', 'Boucher', 'English', '', '{\"DOB\": 17064, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1932410883\", \"Pcp_Zip\": \"40683527\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTER\", \"Pcp_Name\": \"KITCHENS, CHRISTOPHER T\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4J91RC7MG93\", \"Member_City\": \"Parsonsfield\", \"Office_Name\": \"SACOPEE VALLEY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Parsonsfield\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-09-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"70 MAIN ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2076257820\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1624 NORTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04047\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1624 NORTH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04047\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Boucher\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lucien\", \"Member_Middle_name\": \"N\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072055718\", \"Member_Identification_Number\": \"10000012947\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2079109999\"}', 'client_014', '2026', '', '{\"hraStatus\":20,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', NULL, '{\"cron\": \"1\", \"date\": \"2026-01-31 23:31:38\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:30\", \"value\": [{\"add\": \"1624 NORTH RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2079109999\", \"dob\": \"1946-09-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072055718\", \"zip\": \"04047\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Parsonsfield\", \"gend\": 0, \"insh\": \"10000012947\", \"mzip\": \"04047\", \"name\": \"Lucien N Boucher\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KITCHENS, CHRISTOPHER T\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1624 NORTH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Parsonsfield\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"70 MAIN ST,\", \"pcpnpi\": \"1932410883\", \"pcpzip\": \"40683527\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTER\", \"pcpname\": \"SACOPEE VALLEY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076257820\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4J91RC7MG93\", \"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:52:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:30\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:38\", \"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:52:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(509, NULL, NULL, NULL, '10000013023', '', '', NULL, 'David', 'Haines', '', '', '{\"DOB\": 15371, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1144200833\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"ROSS, PAMELA E\", \"Rank_All\": 1, \"PCP_Phone\": \"2077955700\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7A61R77DA35\", \"Member_City\": \"Auburn\", \"Office_Name\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Auburn\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-01-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Central Maine Internal Medicine,12 High St Ste 400\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077955727\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"384 BUTLER HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"384 BUTLER HILL RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Haines\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dhaines@bates.edu\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077844821\", \"Member_Identification_Number\": \"10000013023\", \"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:17\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:17\", \"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\": \"00:46:32\", \"value\": [{\"add\": \"384 BUTLER HILL RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1942-01-30\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077844821\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Auburn\", \"gend\": 0, \"insh\": \"10000013023\", \"mzip\": \"04210\", \"name\": \"David C Haines\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ROSS, PAMELA E\", \"ppno\": \"2077955700\", \"cliId\": \"\", \"email\": \"dhaines@bates.edu\", \"ename\": \"\", \"madd1\": \"384 BUTLER HILL RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Auburn\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Central Maine Internal Medicine,12 High St Ste 400\", \"pcpnpi\": \"1144200833\", \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Lewiston\", \"pcpname\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077955727\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7A61R77DA35\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:32\"}', '{\"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/20/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:31:39\", \"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:52:04', 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
(510, NULL, NULL, NULL, '10000013099', '', '', '47262451', 'Diane', 'Roy', 'English', '', '{\"DOB\": 17083, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1598705360\", \"Pcp_Zip\": \"44121006\", \"Program\": \"Medicare\", \"Pcp_City\": \"BREWER\", \"Pcp_Name\": \"JOHNSTON, PAULINE K\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5C38W93PT65\", \"Member_City\": \"BRADLEY\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE BREWER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRADLEY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-10-08\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"43 WHITING HILL RD STE 300,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079735042\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"650 MAIN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04411\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"650 MAIN ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04411\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Roy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Diane\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@111419.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\": \"2078662532\", \"Member_Identification_Number\": \"10000013099\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-10-2026 10:23:15\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-10 10:23:15\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-10T10:23\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-04T10:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T11:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T09:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T10:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-05T14:07\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T09:53\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T10:23\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:33\", \"value\": [{\"add\": \"650 MAIN ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-10-08\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078662532\", \"zip\": \"04411\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRADLEY\", \"gend\": 1, \"insh\": \"10000013099\", \"mzip\": \"04411\", \"name\": \"Diane Roy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JOHNSTON, PAULINE K\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@111419.com\", \"ename\": \"\", \"madd1\": \"650 MAIN ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRADLEY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"43 WHITING HILL RD STE 300,\", \"pcpnpi\": \"1598705360\", \"pcpzip\": \"44121006\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BREWER\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE BREWER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079735042\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5C38W93PT65\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:33\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 12:29 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 03:04 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 02:23 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell or Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 12:14 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell or Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/1/2026 @ 02:36 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 02:30 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 11:25 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 11:15 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 01:27 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 12:17 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 06:47 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH  VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 06:42 PM\", \"result\": 3, \"comment\": \"03/18/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 04:19 PM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 12:48 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:09 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Erin B 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 04:05 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F/Virtual HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 11:30 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin B 3/20\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 01:08 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 3/10 - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:14 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA F2F with Erin Barker  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 07:51 AM\", \"result\": 3, \"comment\": \"called to schedule f2f with erin b, lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 09:43 AM\", \"result\": 3, \"comment\": \"called to schedule f2f with erin b, lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 08:09 AM\", \"result\": 3, \"comment\": \"called to schedule f2f with erin b, lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 10:54 AM\", \"result\": 3, \"comment\": \"called to schedule f2f with erin b, lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 08:24 AM\", \"result\": 3, \"comment\": \"called to schedule f2f with erin b, lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 10:11 AM\", \"result\": 3, \"comment\": \"called to schedule f2f with erin b, lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 09:37 AM\", \"result\": 7, \"comment\": \"o/c to schedule w/Erin 2/20\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 01:41 PM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 09:32 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin B 2/13 at 9 am\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 11:14 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin B 2/13 at 9 am\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 10:23 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 09:53 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 11:40 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/12/2026 @ 11:40 AM\"}, {\"date\": \"2/5/2026 @ 11:07 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/19/2026 @ 11:07 AM\"}, {\"date\": \"2/4/2026 @ 10:43 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/9/2026 @ 10:43 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 10:43:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-10-2026 10:23:15\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 36}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:05', 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
(511, 71932120, 44829497, '39698290', '10000013102', '', '', '52661009', 'Patricia', 'Livernois', 'English', '', '{\"DOB\": 18403, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": 1770528143, \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Auburn \", \"Pcp_Name\": \"NATHAN RABY\", \"Rank_All\": 1, \"PCP_Phone\": 2079982100, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6AF7UD2AP64\", \"Member_City\": \"Poland\", \"Office_Name\": \"Central maine medical \", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Poland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-05-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"798 Minot Ave\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"26 JULIE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04274\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"26 JULIE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04274\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Livernois\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Patricia\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2075771790, \"Member_Identification_Number\": \"10000013102\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:28:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:28:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-12T12:17\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T15:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T18:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T12:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-07T21:52\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-09T16:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-09T17:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-23T15:15\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-06T08:43\", \"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-09T10:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T12:17\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-23T15:15\", \"reportStatus_date\": \"2026-02-23T15:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-09T17:36\", \"reportStatus_date\": \"2026-03-09T17:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:28\", \"reportStatus_date\": \"2026-03-10T14:28\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:28\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-23T15:15\", \"username\": null}, {\"date\": \"2026-02-23T15:15\", \"username\": \"JCopeland\"}], \"inProgress\": [{\"date\": \"2026-03-06T08:43\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-09T16:40\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-07T21:52\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-07T21:52\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-09T17:36\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-09T16:55\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-09T17:36\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"16:18:03\", \"value\": [{\"add\": \"26 JULIE ST\", \"age\": 75, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-05-20\", \"eno\": \"2975771791\", \"lob\": \"GA - 2026\", \"pno\": 2075771790, \"zip\": \"04274\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Poland\", \"gend\": 1, \"insh\": \"10000013102\", \"mzip\": \"04274\", \"name\": \"Patricia M Livernois\", \"plan\": \"Martin\'s Point\", \"pphy\": \"NATHAN RABY\", \"ppno\": 2079982100, \"cliId\": \"\", \"email\": \"\", \"ename\": \"Dennis Livernois \", \"madd1\": \"26 JULIE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Poland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"798 Minot Ave\", \"pcpnpi\": 1770528143, \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Auburn \", \"pcpname\": \"Central maine medical \", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6AF7UD2AP64\", \"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, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-04-2026\", \"time\": \"11:58:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 16:18:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/23/2026 @ 03:15 PM\", \"result\": 0, \"comment\": \"02/23/2026- F2F HRA WITH Sandra Cadwell, DNF-F2F W/SANDY 3/6 AT 12:00 PM, MRB SAID THEY LIVE IN BROOKDALE VILLAGE \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:38 PM\", \"result\": 3, \"comment\": \"02/23/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 09:47 AM\", \"result\": 1, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 11:21 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24 - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 01:38 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24/26 - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 11:17 AM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell; line busy pop up on first call and left VM on second attempt.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 05:46 PM\", \"result\": 1, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell; dead air. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:49 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/12/2026 @ 12:48 PM\"}, {\"date\": \"2/9/2026 @ 10:26 AM\", \"result\": 3, \"comment\": \"Calling to schedule F2F w/Sandy in March\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 10:26 AM\"}, {\"date\": \"2/5/2026 @ 03:30 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/6/2026 @ 03:29 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000013102\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000013102\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000013102\", \"scheduleDate\": \"2026-3-6T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 15:30:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-23-2026 15:15:02\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:28:45\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"f9371635-1cae-11f1-8213-3562d3c08cb5\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-3-6T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:05', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000013102\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Livernois_10000013102_03062026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:28:45\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000013102.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Livernois_10000013102_03062026.pdf', NULL, 'Summary_10000013102.pdf', NULL, '[{\"date\": \"2026-03-08T02:52:11.771Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-06T13:10', 'Member_Summary_10000013102.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000013102\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000013102.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:28:46\"}', 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
(512, NULL, NULL, NULL, '10000013148', '', '', '94743867', 'James', 'Barnett', '', '', '{\"DOB\": 15990, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1861489882\", \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"Pcp_City\": \"Auburn\", \"Pcp_Name\": \"SKELTON, SARAH K\", \"Rank_All\": 1, \"PCP_Phone\": \"2077847388\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9P67NE4UP65\", \"Member_City\": \"Auburn\", \"Office_Name\": \"FAMILY HEALTH CARE ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Auburn\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-10-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Family Health Care Associates,190 Stetson Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077952043\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"102 LAKE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"102 LAKE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Barnett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"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\": \"2075764012\", \"Member_Identification_Number\": \"10000013148\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 00:37:27\", \"text\": \"\", \"method\": \"api\", \"status\": -1}', '{\"date\": \"2026-03-24 00:37:27\", \"hrastatus\": \"\", \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T12:42\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T13:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T16:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T12:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-03-02T11:36\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [{\"date\": \"2026-03-24T00:37\", \"text\": \"\", \"method\": \"api\", \"status\": -1}], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T14:02\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T12:42\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-03-02T11:36\", \"reportStatus_date\": \"2026-03-02T11:36\"}, {\"text\": \"\", \"type\": \"ReportStatus\", \"status\": -1, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-24T00:37\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-03-02T11:36\", \"username\": \"KCoash\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:36\", \"value\": [{\"add\": \"102 LAKE ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2075764012\", \"dob\": \"1943-10-11\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075764012\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Auburn\", \"gend\": 0, \"insh\": \"10000013148\", \"mzip\": \"04210\", \"name\": \"James D Barnett\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SKELTON, SARAH K\", \"ppno\": \"2077847388\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"102 LAKE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Auburn\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Family Health Care Associates,190 Stetson Rd\", \"pcpnpi\": \"1861489882\", \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Auburn\", \"pcpname\": \"FAMILY HEALTH CARE ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077952043\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9P67NE4UP65\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:36\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"3/2/2026 @ 11:36 AM\", \"result\": 2, \"comment\": \"member on hospice - added primary number 207.782.2739 to DNC and updated secondary number 207.576.4012\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 11:31 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/12\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 03:32 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:45 PM\", \"result\": 3, \"comment\": \"02/23/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 11:23 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 11:06 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 01:12 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 02:30 PM\", \"result\": 13, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 11:42 AM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell Feb 13 or 27th; LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 03:21 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/27; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 01:02 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 01:02 PM\"}, {\"date\": \"2/6/2026 @ 01:30 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 01:30 PM\"}, {\"date\": \"2/5/2026 @ 12:08 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/10; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/10/2026 @ 12:08 PM\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 12:08:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}, {\"date\": \"03-24-2026 00:37:27\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"03-24-2026 00:37:27\", \"status\": 0, \"details\": \"mobile number changed\", \"disabled\": false, \"notification\": {\"type\": 0, \"value\": {\"pno\": 2075764012}, \"previous_status\": 3}}', '{\"attemptCount\": 14}', '{\"orderType\": 2, \"sortOrder\": 1774327047}', 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(513, NULL, NULL, NULL, '10000013158', '', '', NULL, 'Eugene', 'Grindle', 'English', '', '{\"DOB\": 21940, \"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\": \"8WH8M73JC46\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1960-01-25\", \"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\": \"11 WARD CIR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"11 WARD CIR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Grindle\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Eugene\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077295040\", \"Member_Identification_Number\": \"10000013158\", \"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:31:40\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:37\", \"value\": [{\"add\": \"11 WARD CIR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-01-25\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077295040\", \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 0, \"insh\": \"10000013158\", \"mzip\": \"04011\", \"name\": \"Eugene Grindle\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STEELE, ERIK N\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"11 WARD CIR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"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\": \"8WH8M73JC46\", \"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:52:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:37\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:40\", \"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:52:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(514, NULL, NULL, NULL, '10000013181', '', '', '52197563', 'Linda', 'Houghton', '', '', '{\"DOB\": 17086, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1396701470\", \"Pcp_Zip\": \"04462\", \"Program\": \"Medicare\", \"Pcp_City\": \"Millinocket\", \"Pcp_Name\": \"MILNE, LISA S\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4CU4GN4PQ76\", \"Member_City\": \"LEE\", \"Office_Name\": \"MILLINOCKET REGIONAL HOSPITAL PRIMARY CARE RHC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LEE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-10-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Millinocket Regional Hospital Primary Care RHC,200 Somerset St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2075282880\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"PO BOX 222 141 MAXWELL ROAD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04455\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 222 141 MAXWELL ROAD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04455\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Houghton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Linda\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077317185\", \"Member_Identification_Number\": \"10000013181\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-04-2026 19:01:06\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-04 19:01:06\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-04T19:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T11:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T14:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T12:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T19:01\", \"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-04T11:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T14:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-17T12:18\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-04T19:01\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:38\", \"value\": [{\"add\": \"PO BOX 222 141 MAXWELL ROAD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-10-11\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077317185\", \"zip\": \"04455\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LEE\", \"gend\": 1, \"insh\": \"10000013181\", \"mzip\": \"04455\", \"name\": \"Linda Houghton\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MILNE, LISA S\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 222 141 MAXWELL ROAD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LEE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Millinocket Regional Hospital Primary Care RHC,200 Somerset St\", \"pcpnpi\": \"1396701470\", \"pcpzip\": \"04462\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Millinocket\", \"pcpname\": \"MILLINOCKET REGIONAL HOSPITAL PRIMARY CARE RHC\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075282880\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4CU4GN4PQ76\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 01:04 PM\", \"result\": 3, \"comment\": \" Called to schedule virtual with Amanda, LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 05:06 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 06:50 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH  VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 01:19 PM\", \"result\": 1, \"comment\": \"Called to schedule virtual with Amanda, dead air\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 10:43 AM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Amanda , dead air.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 07:01 PM\", \"result\": 3, \"comment\": \"03/04/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 12:18 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 02:51 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/20/2026 @ 02:50 PM\"}, {\"date\": \"2/12/2026 @ 10:21 AM\", \"result\": 13, \"comment\": \"called to schedule f2f with erin b, caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 10:21 AM\"}, {\"date\": \"2/4/2026 @ 11:02 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/10/2026 @ 11:01 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-04-2026 11:02:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-04-2026 19:01:06\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(515, NULL, NULL, NULL, '10000013212', '', '', '52197563', 'Philip', 'Soucy', '', '', '{\"DOB\": 15279, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1649615923\", \"Pcp_Zip\": \"04224\", \"Program\": \"Medicare\", \"Pcp_City\": \"Dixfield\", \"Pcp_Name\": \"KING, JESSICA S\", \"Rank_All\": 1, \"PCP_Phone\": \"2075624226\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4YE4XD7WH68\", \"Member_City\": \"Rumford\", \"Office_Name\": \"ELSEMORE DIXFIELD FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rumford\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-10-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Elsemore Dixfield Family Medicine,146 Weld St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Oxford\", \"Member_Country\": \"Oxford\", \"PCP_Fax_Number\": \"5188242388\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"113 S RUMFORD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04276\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"113 S RUMFORD RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04276\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Soucy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Philip\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44197, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@012622.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073647856\", \"Member_Identification_Number\": \"10000013212\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-11-2026 17:25:08\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-11 17:25:08\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T17:25\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T11:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T18:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T18:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T12:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T17:25\", \"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-09T12:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T17:25\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:39\", \"value\": [{\"add\": \"113 S RUMFORD RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1941-10-30\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073647856\", \"zip\": \"04276\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Rumford\", \"gend\": 0, \"insh\": \"10000013212\", \"mzip\": \"04276\", \"name\": \"Philip Soucy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KING, JESSICA S\", \"ppno\": \"2075624226\", \"cliId\": \"\", \"email\": \"declined@012622.com\", \"ename\": \"\", \"madd1\": \"113 S RUMFORD RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rumford\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Elsemore Dixfield Family Medicine,146 Weld St\", \"pcpnpi\": \"1649615923\", \"pcpzip\": \"04224\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Dixfield\", \"pcpname\": \"ELSEMORE DIXFIELD FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"5188242388\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4YE4XD7WH68\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/24/2026 @ 02:46 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 07:17 PM\", \"result\": 14, \"comment\": \"03/04/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER, MRB CAN NOT DO VIRTUAL NEEDS F2F, \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 10:21 AM\", \"result\": 13, \"comment\": \"called to scheduled virtual hra \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 12:58 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 05:25 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 11:10 AM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 06:55 PM\", \"result\": 3, \"comment\": \"02/06/2026- F2F HRA WITH SANDRA CADWELL, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/18/2026 @ 06:54 PM\"}, {\"date\": \"2/5/2026 @ 06:43 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 06:42 PM\"}, {\"date\": \"2/4/2026 @ 11:03 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/10/2026 @ 11:03 AM\"}, {\"date\": \"2/2/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 11:03:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-11-2026 17:25:08\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(516, NULL, NULL, NULL, '10000013261', '', '', '47262451', 'Donald', 'Tyrol', '', '', '{\"DOB\": 17119, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1922360411\", \"Pcp_Zip\": \"04910\", \"Program\": \"Medicare\", \"Pcp_City\": \"Albion\", \"Pcp_Name\": \"CHAMBERLAIN, DEAN E\", \"Rank_All\": 1, \"PCP_Phone\": \"2074379388\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8TA1PA9KT93\", \"Member_City\": \"Vassalboro\", \"Office_Name\": \"LOVEJOY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Vassalboro\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-11-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Lovejoy Health Center,7 School St Ste 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078619624\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1653 CROSS HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04989\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1653 CROSS HILL RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04989\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Tyrol\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dhtyrol@fairpoint.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075571146\", \"Member_Identification_Number\": \"10000013261\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 13:47:47\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-25 13:47:47\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T10:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T17:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-25T13:47\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T17:53\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-25T13:47\", \"reportStatus_date\": \"2026-02-25T13:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-25T13:47\", \"username\": \"LAnguiano\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:40\", \"value\": [{\"add\": \"1653 CROSS HILL RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-11-13\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075571146\", \"zip\": \"04989\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Vassalboro\", \"gend\": 0, \"insh\": \"10000013261\", \"mzip\": \"04989\", \"name\": \"Donald Tyrol\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CHAMBERLAIN, DEAN E\", \"ppno\": \"2074379388\", \"cliId\": \"\", \"email\": \"dhtyrol@fairpoint.net\", \"ename\": \"\", \"madd1\": \"1653 CROSS HILL RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Vassalboro\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Lovejoy Health Center,7 School St Ste 1\", \"pcpnpi\": \"1922360411\", \"pcpzip\": \"04910\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Albion\", \"pcpname\": \"LOVEJOY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078619624\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8TA1PA9KT93\", \"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:52:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-25T13:47\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/25/2026 @ 01:47 PM\", \"result\": 9, \"comment\": \"Per notes in 5-9 member was called 2-18-2026 and refused IHA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 05:53 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/11/2026 @ 05:53 PM\"}, {\"date\": \"2/4/2026 @ 10:45 AM\", \"result\": 7, \"comment\": \"Called to schedule IHA w/ martins point -Line busy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/6/2026 @ 10:44 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 10:45:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"01-31-2026 23:31:41\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:06', 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
(517, NULL, NULL, NULL, '10000013273', '', '', '52661009', 'Sandra', 'Rozanski', '', '', '{\"DOB\": 14415, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1861489882\", \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"Pcp_City\": \"Auburn\", \"Pcp_Name\": \"SKELTON, SARAH K\", \"Rank_All\": 1, \"PCP_Phone\": \"2077847388\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4K50PE7CD26\", \"Member_City\": \"Auburn\", \"Office_Name\": \"FAMILY HEALTH CARE ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Auburn\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1939-06-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Family Health Care Associates,190 Stetson Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077952043\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"327 OLD DANVILLE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"327 OLD DANVILLE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Rozanski\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sandra\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ctracy1027@outlook.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077862096\", \"Member_Identification_Number\": \"10000013273\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-02-2026 11:33:33\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-02 11:33:33\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-02T11:33\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-09T13:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T13:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T09:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T11: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\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T13:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T13:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T11:33\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:41\", \"value\": [{\"add\": \"327 OLD DANVILLE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2073129768\", \"dob\": \"1939-06-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077862096\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Auburn\", \"gend\": 1, \"insh\": \"10000013273\", \"mzip\": \"04210\", \"name\": \"Sandra A Rozanski\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SKELTON, SARAH K\", \"ppno\": \"2077847388\", \"cliId\": \"\", \"email\": \"ctracy1027@outlook.com\", \"ename\": \"\", \"madd1\": \"327 OLD DANVILLE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Auburn\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Family Health Care Associates,190 Stetson Rd\", \"pcpnpi\": \"1861489882\", \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Auburn\", \"pcpname\": \"FAMILY HEALTH CARE ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077952043\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4K50PE7CD26\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:41\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 01:18 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 02:38 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 04:42 PM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/2/2026 @ 05:15 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 11:47 AM\", \"result\": 13, \"comment\": \"Caller disconnected the call before intro. Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 10:32 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 06:55 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH  VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 12:54 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:44 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 07:52 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 08:16 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 11:33 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/12\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 09:59 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/6 - called daughters phone \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 01:07 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/6 - called alt number as it\'s her daughters who schedules her appts\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/27/2026 @ 01:07 PM\"}, {\"date\": \"2/10/2026 @ 01:21 PM\", \"result\": 3, \"comment\": \"o/c to schedule w/Sandy in March\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 01:21 PM\"}, {\"date\": \"2/9/2026 @ 01:09 PM\", \"result\": 3, \"comment\": \"Calling to schedule F2F w/Sandy in March - call alt number as daughter schedules for member\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/10/2026 @ 01:08 PM\"}, {\"date\": \"1/23/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 13:09:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-02-2026 11:33:33\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 17}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(518, NULL, NULL, NULL, '10000013358', '', '', '52197563', 'Michael', 'Mickeriz', '', '', '{\"DOB\": 17428, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1154326387\", \"Pcp_Zip\": \"42762100\", \"Program\": \"Medicare\", \"Pcp_City\": \"RUMFORD\", \"Pcp_Name\": \"DELUCA, THOMAS J\", \"Rank_All\": 1, \"PCP_Phone\": \"2073647831\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9RH3D71QA85\", \"Member_City\": \"RUMFORD\", \"Office_Name\": \"SWIFT RIVER FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"RUMFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-09-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"431 FRANKLIN ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Oxford\", \"Member_Country\": \"Oxford\", \"PCP_Fax_Number\": \"2073699467\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"331 PINE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04276\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"331 PINE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04276\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mickeriz\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jmickeriz@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\": \"2075775633\", \"Member_Identification_Number\": \"10000013358\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-16-2026 01:27:08\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-16 01:27:08\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T11:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T18:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T18:56\", \"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-09T12:14\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-16T01:27\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T12:14\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:27\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:44\", \"value\": [{\"add\": \"331 PINE ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-09-18\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075775633\", \"zip\": \"04276\", \"add2\": \"\", \"add3\": \"\", \"city\": \"RUMFORD\", \"gend\": 0, \"insh\": \"10000013358\", \"mzip\": \"04276\", \"name\": \"Michael Mickeriz\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DELUCA, THOMAS J\", \"ppno\": \"2073647831\", \"cliId\": \"\", \"email\": \"jmickeriz@gmail.com\", \"ename\": \"\", \"madd1\": \"331 PINE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"RUMFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"431 FRANKLIN ST,\", \"pcpnpi\": \"1154326387\", \"pcpzip\": \"42762100\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"RUMFORD\", \"pcpname\": \"SWIFT RIVER FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073699467\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9RH3D71QA85\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": \"6\", \"callLog\": [{\"date\": \"2/9/2026 @ 11:14 AM\", \"result\": 6, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM. Member is down in Florida; should be back by the end of April. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 06:56 PM\", \"result\": 3, \"comment\": \"02/06/2026- F2F HRA WITH SANDRA CADWELL, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/17/2026 @ 06:56 PM\"}, {\"date\": \"2/5/2026 @ 06:45 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 06:44 PM\"}, {\"date\": \"2/4/2026 @ 11:04 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/9/2026 @ 11:04 AM\"}, {\"date\": \"2/3/2026 @ 05:35 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/2/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 11:04:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"01-31-2026 23:31:42\", \"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:52:07', 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
(519, 55499828, 44829497, '39698290', '10000013470', '', '', '94743867', 'Edward', 'Harvey', 'English', '', '{\"DOB\": 14704, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": \"1235696600\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"ISABELLA TAYLOR\", \"Rank_All\": 1, \"PCP_Phone\": \"2077952800\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3VJ4A44UJ73\", \"Member_City\": \"Lewiston\", \"Office_Name\": \"CMMC FAMILY MEDICINE RESIDENCY PROGRAM\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lewiston\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-04-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"76 High St Ste 200\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"704 S PLEASANT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04240\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"704 S PLEASANT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04240\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Harvey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Edward\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@082225.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\": \"2077862062\", \"Member_Identification_Number\": \"10000013470\", \"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:20:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:20:05\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T16:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T16:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-15T19:08\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T11:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T15:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-09T16:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-13T13:41\", \"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-09T16:31\", \"reportStatus_date\": \"2026-02-09T16:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-15T19:08\", \"reportStatus_date\": \"2026-02-15T19:08\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T15:24\", \"reportStatus_date\": \"2026-02-19T15:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:20\", \"reportStatus_date\": \"2026-03-03T17:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:20\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-09T16:31\", \"username\": null}, {\"date\": \"2026-02-09T16:31\", \"username\": \"LRivera\"}], \"inProgress\": [{\"date\": \"2026-02-13T13:41\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:54\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T16:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-15T19:08\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-15T19:08\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T15:24\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T11:06\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T15:24\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"11:49:52\", \"value\": [{\"add\": \"704 S PLEASANT RD\", \"age\": 85, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-04-03\", \"eno\": \"2077862062\", \"lob\": \"GA - 2026\", \"pno\": \"2077862062\", \"zip\": \"04240\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Lewiston\", \"gend\": 0, \"insh\": \"10000013470\", \"mzip\": \"04240\", \"name\": \"Edward R Harvey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ISABELLA TAYLOR\", \"ppno\": \"2077952800\", \"cliId\": \"\", \"email\": \"declined@082225.com\", \"ename\": \"Irene C. Harvey\", \"madd1\": \"704 S PLEASANT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lewiston\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 High St Ste 200\", \"pcpnpi\": \"1235696600\", \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Lewiston\", \"pcpname\": \"CMMC FAMILY MEDICINE RESIDENCY PROGRAM\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3VJ4A44UJ73\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-11-2026\", \"time\": \"11:42:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 11:49:52\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/9/2026 @ 03:31 PM\", \"result\": 0, \"comment\": \"IC- scheduled with Sandra C on the 13th - 1:30 PM - No pets; only has landline. Call to confirm apt a day before the visit.\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 03:19 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 03:19 PM\"}, {\"date\": \"2/6/2026 @ 12:30 PM\", \"result\": 7, \"comment\": \"Called to schedule IHA- Line busy \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/9/2026 @ 12:30 PM\"}, {\"date\": \"2/5/2026 @ 02:25 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/10; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 02:24 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000013470\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000013470\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000013470\", \"scheduleDate\": \"2026-2-13T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 14:25:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-09-2026 16:31:55\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:20:03\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"2058786e-174f-11f1-883c-73a54f222901\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-2-13T13:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:07', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000013470\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Harvey_10000013470_02132026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:20:03\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000013470.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Harvey_10000013470_02132026.pdf', NULL, 'Summary_10000013470.pdf', NULL, '[{\"date\": \"2026-02-16T00:08:51.050Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-13T14:30', 'Member_Summary_10000013470.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000013470\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000013470.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:20:04\"}', 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
(520, NULL, NULL, NULL, '10000013487', '', '', '14035267', 'Margaret', 'Valvo', '', '', '{\"DOB\": 16652, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": 1538190384, \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"PISCULLI, JENNY T\", \"Rank_All\": 1, \"PCP_Phone\": 2078615000, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8YA6N22WM68\", \"Member_City\": \"FAIRFIELD\", \"Office_Name\": \"MAINE DARTMOUTH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FAIRFIELD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-08-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Maine Dartmouth Family Medicine,149 North St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Somerset\", \"Member_Country\": \"Somerset\", \"PCP_Fax_Number\": 2078615101, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 MCKENZIE AVE\", \"Member_Zip_Code\": \"04937\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 MCKENZIE AVE\", \"Mailing_Zip_Code\": \"04937\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Valvo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Margaret\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"valvo.robert@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2074536634, \"Member_Identification_Number\": \"10000013487\"}', 'client_014', '2026', '', '{\"hraStatus\":15,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-06-2026 12:54:49\", \"text\": \"Deceased\", \"method\": \"api\", \"status\": 8}', '{\"date\": \"2026-03-06 12:54:49\", \"hrastatus\": \"\", \"reportstatus\": \"Deceased\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-20T13:17\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T17:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T11:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T10:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T10:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T13:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [{\"date\": \"2026-03-06T12:54\", \"text\": \"Deceased\", \"method\": \"api\", \"status\": 8}], \"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-09T11:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T13:17\"}, {\"text\": \"Deceased\", \"type\": \"ReportStatus\", \"status\": 8, \"hraStatus\": 15, \"hraStatus_date\": \"2026-03-06T12:54\", \"reportStatus_date\": \"2026-03-06T12:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [{\"date\": \"2026-03-06T12:54\", \"username\": \"cwasilak\"}], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"02-23-2026\", \"time\": \"23:36:24\", \"value\": [{\"add\": \"15 MCKENZIE AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-08-03\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2074536634, \"zip\": \"04937\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FAIRFIELD\", \"gend\": 1, \"insh\": \"10000013487\", \"mzip\": \"04937\", \"name\": \"Margaret Valvo\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PISCULLI, JENNY T\", \"ppno\": 2078615000, \"cliId\": \"\", \"email\": \"valvo.robert@yahoo.com\", \"ename\": \"\", \"madd1\": \"15 MCKENZIE AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FAIRFIELD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Maine Dartmouth Family Medicine,149 North St\", \"pcpnpi\": 1538190384, \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"MAINE DARTMOUTH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078615101, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8YA6N22WM68\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-03-2026 00:11:22\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 5, \"callLog\": [{\"date\": \"3/6/2026 @ 12:54 PM\", \"result\": 5, \"comment\": \"Called to Schedule F2F HRA with Kathryn but member is ineligible. member passed away on February 13 2026  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 01:17 PM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin B 2/25\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 07:49 AM\", \"result\": 3, \"comment\": \"called to schedule virtual appt with Amanda M,\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 07:49 AM\", \"result\": 3, \"comment\": \"called to schedule virtual appt with Amanda M,\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 08:31 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/12/2026 @ 08:31 AM\"}, {\"date\": \"2/4/2026 @ 02:33 PM\", \"result\": 3, \"comment\": \" called to schedule face to face \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/10/2026 @ 02:33 PM\"}, {\"date\": \"2/3/2026 @ 06:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"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-04-2026 14:33:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"02-20-2026 13:17:19\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(521, NULL, NULL, NULL, '10000013493', '', '', '4010197', 'June', 'Keefe', 'English', '', '{\"DOB\": 17031, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1285073205\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"OSULLIVAN, SEAN T\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3QN9TM4JN58\", \"Member_City\": \"South Portland\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"South Portland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-08-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"76 High St Fl 1,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"170 BOOTHBY AVENUE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"170 BOOTHBY AVENUE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Keefe\", \"Medication_Review\": \"N\", \"Member_first_name\": \"June\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"apksr@maine.rr.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\": \"2077998326\", \"Member_Identification_Number\": \"10000013493\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-11-2026 12:29:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-11 12:29:45\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T10:21\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-11T12:29\", \"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-06T10:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T18:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T10:21\", \"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-09T10:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T13:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T10:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-11T12:29\", \"reportStatus_date\": \"2026-03-11T12:29\"}]', '{\"utc\": [{\"date\": \"2026-03-11T12:29\", \"username\": \"cwasilak\"}], \"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\": \"00:46:46\", \"value\": [{\"add\": \"170 BOOTHBY AVENUE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-08-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077998326\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"South Portland\", \"gend\": 1, \"insh\": \"10000013493\", \"mzip\": \"04106\", \"name\": \"June Keefe\", \"plan\": \"Martin\'s Point\", \"pphy\": \"OSULLIVAN, SEAN T\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"apksr@maine.rr.com\", \"ename\": \"\", \"madd1\": \"170 BOOTHBY AVENUE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"South Portland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 High St Fl 1,\", \"pcpnpi\": \"1285073205\", \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Lewiston\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3QN9TM4JN58\", \"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:52:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:46\"}', '{\"utc\": [{\"date\": \"2026-03-11T12:29\", \"type\": null, \"subStaus\": \"\", \"username\": \"cwasilak\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/11/2026 @ 12:29 PM\", \"result\": 6, \"comment\": \"INC - does not need assessment...shes going thru cancer Treatments and is a nurse herself ...call later in year  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 12:06 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 07:10 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Elizabeth Bailey- LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 02:10 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 11:40 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Erin no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 10:21 AM\", \"result\": 3, \"comment\": \"LVM F2F \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 01:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 03:18 PM\", \"result\": 3, \"comment\": \" called to schedule face to face \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/17/2026 @ 03:17 PM\"}, {\"date\": \"2/9/2026 @ 10:24 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/16/2026 @ 10:23 AM\"}, {\"date\": \"2/6/2026 @ 10:16 AM\", \"result\": 3, \"comment\": \"LVM VIRTUAL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 10:16 AM\"}, {\"date\": \"2/3/2026 @ 05:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 10:16:00\", \"schedulerId\": \"4010197\", \"schedulerLeadId\": \"4010197\"}]}', '{\"date\": \"02-24-2026 10:21:32\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(522, NULL, NULL, NULL, '10000013860', '', '', '52661009', 'Evelyn', 'Murch', 'English', '', '{\"DOB\": 13985, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1154499002\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"WADLAND, WILLIAM R\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6G83AA3GM16\", \"Member_City\": \"Hollis Center\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hollis Center\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1938-04-15\", \"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\": \"213 CAPE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04042\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 228\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04042\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Murch\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Evelyn\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"REMURCH@ROADRUNNER.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\": \"2077104071\", \"Member_Identification_Number\": \"10000013860\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-10-2026 15:03:46\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}', '{\"date\": \"2026-02-10 15:03:46\", \"hrastatus\": \"\", \"reportstatus\": \"Ineligible\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T10:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T14:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-02-10T15:03\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T14:08\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-02-10T15:03\", \"reportStatus_date\": \"2026-02-10T15:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-02-10T15:03\", \"username\": \"JCopeland\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:51\", \"value\": [{\"add\": \"213 CAPE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1938-04-15\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077104071\", \"zip\": \"04042\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Hollis Center\", \"gend\": 1, \"insh\": \"10000013860\", \"mzip\": \"04042\", \"name\": \"Evelyn A Murch\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WADLAND, WILLIAM R\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"REMURCH@ROADRUNNER.COM\", \"ename\": \"\", \"madd1\": \"PO BOX 228\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hollis Center\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1154499002\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6G83AA3GM16\", \"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:52:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:51\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": \"2\", \"callLog\": [{\"date\": \"2/10/2026 @ 03:03 PM\", \"result\": 2, \"comment\": \"02/10/2026- VIRTUAL HRA, MRB HUSBAND CALLED BACK AND SAID SHE IS IN A NURSING HOME INELIGBLE\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/17/2026 @ 01:49 PM\"}, {\"date\": \"2/6/2026 @ 02:08 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 02:08 PM\"}, {\"date\": \"2/4/2026 @ 10:57 AM\", \"result\": 3, \"comment\": \"calling to sched IHA w/Sandy for 2/5/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 10:57 AM\"}, {\"date\": \"2/3/2026 @ 03:42 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\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 10:57:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:31:43\", \"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:52:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(523, NULL, NULL, '17537038', '10000013903', '', '', '52197563', 'Shirley', 'Poirier', '', '', '{\"DOB\": 13000, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1497105605\", \"Pcp_Zip\": \"04530\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bath\", \"Pcp_Name\": \"JACOB, ROBERT T\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6YQ4GW5UV67\", \"Member_City\": \"Winslow\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"North Vassalboro\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1935-08-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"MaineHealth Primary Care Internal Medicine,108 Centre St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2075176915\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"363 S POND RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 47\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04962\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Poirier\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shirley\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@091824.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078727043\", \"Member_Identification_Number\": \"10000013903\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":\"0\",\"cancelText\":\"Shirley A Poirier would like to do a home visit. She told me the phone number we have is a land line and she states she does not have a cell phone or a computer.u00a0\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 10:16:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-04-07 10:16:34\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-03T11:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-07T10:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-10T14:02\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-11T15:12\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-03-12T10:21\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-11T15:14\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:22\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-10T14:02\", \"reportStatus_date\": \"2026-02-10T14:02\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-11T15:14\", \"reportStatus_date\": \"2026-03-12T10:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-03T11:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-07T10:16\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-10T14:02\", \"username\": null}, {\"date\": \"2026-02-10T14:02\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-03-11T15:12\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-11T15:14\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:53\", \"value\": [{\"add\": \"363 S POND RD\", \"age\": 90, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1935-08-04\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078727043\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Winslow\", \"gend\": 1, \"insh\": \"10000013903\", \"mzip\": \"04962\", \"name\": \"Shirley A Poirier\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JACOB, ROBERT T\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@091824.com\", \"ename\": \"\", \"madd1\": \"PO BOX 47\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"North Vassalboro\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"MaineHealth Primary Care Internal Medicine,108 Centre St\", \"pcpnpi\": \"1497105605\", \"pcpzip\": \"04530\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bath\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075176915\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6YQ4GW5UV67\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-10-2026\", \"time\": \"11:59:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:53\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-11T15:14\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"Shirley A Poirier would like to do a home visit. She told me the phone number we have is a land line and she states she does not have a cell phone or a computer.u00a0\", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"4/7/2026 @ 10:16 AM\", \"result\": 1, \"comment\": \"Called to schedule F2F HRA w/ Erin Barker\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"4/22/2026 @ 10:12 AM\"}, {\"date\": \"4/3/2026 @ 11:19 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell or Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"4/23/2026 @ 11:19 AM\"}, {\"date\": \"3/12/2026 @ 10:21 AM\", \"result\": 14, \"comment\": \"o/c to confirm ok to call back and sched w/Kathryn when we have the April - member asked for c/b in June to resched as she wants to think about it first\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"6/2/2026 @ 10:21 AM\"}, {\"date\": \"2/10/2026 @ 02:02 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 11, 2026 at 12:30pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"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\": {\"type\": \"visitType\", \"memberId\": \"10000013903\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000013903\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000013903\", \"scheduleDate\": \"2026-3-11T12:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 14:02:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}, {\"date\": \"03-11-2026 15:14:21\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-11-2026 15:14:21\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, 'Virtual', '2026-3-11T12:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
