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
(551, NULL, NULL, NULL, '10000015713', '', '', '52197563', 'Stephanie', 'Porciello', '', '', '{\"DOB\": 16317, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"\", \"Program\": \"Medicare\", \"Pcp_City\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Medicare_ID\": \"4QY8D75CF32\", \"Member_City\": \"Winslow\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winslow\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-09-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"543 Clinton Ave\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"543 Clinton Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Porciello\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephanie\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"SPORCIELLO@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\": \"2073147695\", \"Member_Identification_Number\": \"10000015713\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-20-2026 14:37:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-20 14:37:40\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-20T14:37\", \"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-10T10:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T10:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T14:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T12:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T14:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T10:40\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T14:37\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:34\", \"value\": [{\"add\": \"543 Clinton Ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1944-09-02\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073147695\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Winslow\", \"gend\": 1, \"insh\": \"10000015713\", \"mzip\": \"04901\", \"name\": \"Stephanie M Porciello\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PRESTON, DAVID G\", \"ppno\": 2078731098, \"cliId\": \"\", \"email\": \"SPORCIELLO@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"543 Clinton Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winslow\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Mid Maine Medicine,325B Kennedy Memorial Dr\", \"pcpnpi\": 1871559203, \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"THAYER INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078735461, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4QY8D75CF32\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:34\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/6/2026 @ 09:56 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell or Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 11:13 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 07:22 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 @ 05:27 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 12:39 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 02:37 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 @ 12:27 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 02:42 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/24/2026 @ 02:42 PM\"}, {\"date\": \"2/13/2026 @ 10:40 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/18/2026 @ 10:40 AM\"}, {\"date\": \"2/10/2026 @ 10:04 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 10:04 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 10:04:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-20-2026 14:37:40\", \"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:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(552, NULL, NULL, NULL, '10000015785', '', '', '543416', 'Shirley', 'Hall', '', '', '{\"DOB\": 14663, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1629590484\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"JURGENS, PAUL J\", \"Rank_All\": 1, \"PCP_Phone\": \"2079412373\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3JG4GD4YY63\", \"Member_City\": \"BREWER\", \"Office_Name\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BREWER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-02-22\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Northern Light Husson Family Medicine,302 Husson Ave Ste 2\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079418803\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"109 WASHINGTON ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04412\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"109 WASHINGTON ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04412\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hall\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shirley\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@09302024.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2079893396\", \"Member_Identification_Number\": \"10000015785\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 11:01:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-25 11:01:09\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-17T13:15\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-02-25T11:01\", \"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:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T14:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T11:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T13:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-09T10:12\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T10:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-17T13:15\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-25T11:01\", \"reportStatus_date\": \"2026-02-25T11:01\"}]', '{\"utc\": [{\"date\": \"2026-02-25T11:01\", \"username\": \"MDouglas\"}], \"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:47:37\", \"value\": [{\"add\": \"109 WASHINGTON ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-02-22\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2079893396\", \"zip\": \"04412\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BREWER\", \"gend\": 1, \"insh\": \"10000015785\", \"mzip\": \"04412\", \"name\": \"Shirley M Hall\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JURGENS, PAUL J\", \"ppno\": \"2079412373\", \"cliId\": \"\", \"email\": \"declined@09302024.com\", \"ename\": \"\", \"madd1\": \"109 WASHINGTON ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BREWER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Northern Light Husson Family Medicine,302 Husson Ave Ste 2\", \"pcpnpi\": \"1629590484\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079418803\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3JG4GD4YY63\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:37\"}', '{\"utc\": [{\"date\": \"2026-02-25T11:01\", \"type\": null, \"subStaus\": \"\", \"username\": \"MDouglas\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 12:31 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:09 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 02:27 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:40 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:33 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:31 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:18 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 @ 11:59 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 06:49 PM\", \"result\": 14, \"comment\": \"03/19/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken, MRB CANT DO VIRTUAL \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 12:52 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:14 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:11 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:34 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:12 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:50 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 03:51 PM\", \"result\": 3, \"comment\": \"02/26/2026- F2F HRA WITH ERIN BARKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 08:01 AM\", \"result\": 6, \"comment\": \"called to schedule f2f with erin b,member requested callback \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 09:54 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:16 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin but lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 10:55 AM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Erin but line was busy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 08:31 AM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Erin but line was busy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 10:15 AM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Erin but line was busy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 10:12 AM\", \"result\": 14, \"comment\": \"Called to Schedule F2F HRA with Erin but member requested a call back. needs a march appointment F2F no virtual capabilities \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/26/2026 @ 10:12 AM\"}, {\"date\": \"2/6/2026 @ 11:54 AM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Erin but line was busy.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/11/2026 @ 11:54 AM\"}, {\"date\": \"2/5/2026 @ 11:31 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M, no vm setup\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/10/2026 @ 11:26 AM\"}, {\"date\": \"2/4/2026 @ 06:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/9/2026 @ 06:54 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 18:54:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"02-17-2026 13:15:26\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 27}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(553, NULL, NULL, NULL, '10000015789', '', '', NULL, 'Nancy', 'Netherland', 'English', '', '{\"DOB\": 14910, \"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\": \"8P76YR0EJ53\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-10-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"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\": \"9 DRESDEN CT\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"9 DRESDEN CT\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Netherland\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nancy\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"NANYARDS@GMAIL.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078412712\", \"Member_Identification_Number\": \"10000015789\", \"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:19\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:19\", \"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:47:38\", \"value\": [{\"add\": \"9 DRESDEN CT\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-10-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078412712\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 1, \"insh\": \"10000015789\", \"mzip\": \"04103\", \"name\": \"Nancy B Netherland\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WADLAND, WILLIAM R\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"NANYARDS@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"9 DRESDEN CT\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"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\": \"8P76YR0EJ53\", \"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:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:38\"}', '{\"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/27/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:53\", \"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:20', 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
(554, 93442164, 44829497, '85163466', '10000016035', '', '', '52197563', 'Kathleen', 'Strange', 'English', '', '{\"DOB\": 18244, \"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\": \"1336601996\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"DANIEL CROTHERS\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6PJ2GQ6DH11\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-12-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 CARTER ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 CARTER ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Strange\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kathleen\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"kathy.strange@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2076506700\", \"Member_Identification_Number\": \"10000016035\", \"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:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:20:12\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-18T21:02\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T15:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T20:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-04T13:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-18T20:23\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-04T13:07\", \"reportStatus_date\": \"2026-02-04T13:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T20:47\", \"reportStatus_date\": \"2026-02-19T20:47\"}, {\"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-04T13:07\", \"username\": null}, {\"date\": \"2026-02-04T13:07\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-02-18T20:23\", \"username\": \"EBailey\"}], \"qaAssigned\": [{\"date\": \"2026-02-19T12:49\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-18T21:02\", \"username\": \"EBailey\"}, {\"date\": \"2026-02-18T21:02\", \"username\": \"EBailey\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T20:47\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T15:41\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T20:47\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"11:56:10\", \"value\": [{\"add\": \"15 CARTER ST\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-12-12\", \"eno\": \"2076506700\", \"lob\": \"GA - 2026\", \"pno\": \"2076506700\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 1, \"insh\": \"10000016035\", \"mzip\": \"04103\", \"name\": \"Kathleen K Strange\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DANIEL CROTHERS\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"kathy.strange@gmail.com\", \"ename\": \"Daughter in Brunswick \", \"madd1\": \"15 CARTER ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"331 Veranda St\", \"pcpnpi\": \"1336601996\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6PJ2GQ6DH11\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-12-2026\", \"time\": \"15:36:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 11:57:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/4/2026 @ 01:07 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Elizabeth for: February 16, 2026 at 9:30am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"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\": {\"type\": \"visitType\", \"memberId\": \"10000016035\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"85163466\", \"memberId\": \"10000016035\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"85163466\", \"memberId\": \"10000016035\", \"scheduleDate\": \"2026-2-16T09:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 13:07:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-04-2026 13:07:04\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:20:11\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"f7fa2f89-a05c-497f-bf09-178f967d3b49\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"f7fa2f89-a05c-497f-bf09-178f967d3b49\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552411835 35      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:23.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":221,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":221,\\\"start_timestamp\\\":\\\"2026-03-03T22:20:26.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:23.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-16T09:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:21', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016035\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Strange_10000016035_02162026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:20:10\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000016035.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Strange_10000016035_02162026.pdf', NULL, 'Summary_10000016035.pdf', NULL, '[{\"date\": \"2026-02-19T02:02:46.747Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-16T10:40', 'Member_Summary_10000016035.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016035\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000016035.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:20:12\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0'),
(555, NULL, NULL, NULL, '10000016036', '', '', NULL, 'Jacqueline', 'Charette', '', '', '{\"DOB\": 18284, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1285110023\", \"Pcp_Zip\": \"42407649\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"TREMIS, MARIE ALEXANDRIA\", \"Rank_All\": 1, \"PCP_Phone\": \"2077955750\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7VC1Q41UR93\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"CENTRAL MAINE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-01-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"76 HIGH ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"20 GREAT FALLS PLZ BOX 403\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"20 GREAT FALLS PLZ BOX 403\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Charette\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jacqueline\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@100325.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075775217\", \"Member_Identification_Number\": \"10000016036\", \"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:54\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:41\", \"value\": [{\"add\": \"20 GREAT FALLS PLZ BOX 403\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-01-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075775217\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 1, \"insh\": \"10000016036\", \"mzip\": \"04210\", \"name\": \"Jacqueline A Charette\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TREMIS, MARIE ALEXANDRIA\", \"ppno\": \"2077955750\", \"cliId\": \"\", \"email\": \"declined@100325.com\", \"ename\": \"\", \"madd1\": \"20 GREAT FALLS PLZ BOX 403\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 HIGH ST,\", \"pcpnpi\": \"1285110023\", \"pcpzip\": \"42407649\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"CENTRAL MAINE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7VC1Q41UR93\", \"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:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:41\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:54\", \"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:21', 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
(556, 57818338, 44829497, '17537038', '10000016037', '', '', '52661009', 'Barbara', 'Garrey', 'English', '', '{\"DOB\": 17199, \"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\": \"1427165778\", \"Pcp_Zip\": \"04054\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Moody\", \"Pcp_Name\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"2076468386\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6Y36FK6DR84\", \"Member_City\": \"Kennebunk\", \"Office_Name\": \"WEBHANNET INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Kennebunk\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-02-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"277 Post Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2076412855\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"119 CAT MOUSAM RD UNIT 21\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04043\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"119 CAT MOUSAM RD UNIT 21\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04043\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Garrey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Barbara\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"bgarrey1@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"3035895256\", \"Member_Identification_Number\": \"10000016037\", \"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:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:20:20\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T14:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T16:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-20T15:52\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-26T00:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T02:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-04T15:00\", \"text\": \"Scheduled\", \"method\": \"api\", \"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-04T15:00\", \"reportStatus_date\": \"2026-02-04T15:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T16:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-20T15:52\", \"reportStatus_date\": \"2026-02-20T15:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T02:44\", \"reportStatus_date\": \"2026-02-26T02:44\"}, {\"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-04T15:00\", \"username\": null}, {\"date\": \"2026-02-04T15:00\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-02-18T13:49\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-23T17:01\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-20T15:52\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-20T15:52\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-25T11:51\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T02:44\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-26T00:12\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T02:44\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-24T12:19\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-24T12:22\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"11:59:41\", \"value\": [{\"add\": \"119 CAT MOUSAM RD UNIT 21\", \"age\": 79, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-02-01\", \"eno\": \"2078577110\", \"lob\": \"GA - 2026\", \"pno\": \"3035895256\", \"zip\": \"04043\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Kennebunk\", \"gend\": 1, \"insh\": \"10000016037\", \"mzip\": \"04043\", \"name\": \"Barbara Garrey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"\", \"ppno\": \"2076468386\", \"cliId\": \"\", \"email\": \"bgarrey1@gmail.com\", \"ename\": \"June\", \"madd1\": \"119 CAT MOUSAM RD UNIT 21\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Kennebunk\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"277 Post Rd\", \"pcpnpi\": \"1427165778\", \"pcpzip\": \"04054\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"Moody\", \"pcpname\": \"WEBHANNET INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076412855\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6Y36FK6DR84\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-18-2026\", \"time\": \"09:36:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 11:59:41\"}', NULL, NULL, '{\"memberId\": \"10000016037\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Tue, 24 Feb 2026 17:19:44 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  AOD Integument med list reports fungal dermatitis.  Please add.\\n2.  TUG score 14 member is fall risk.  Please send a case management referral.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Feb 2026 17:22:27 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  AOD Integument med list reports fungal dermatitis.  Please add.\\n2.  TUG score 14 member is fall risk.  Please send a case management referral.\\n3.  Vital signs 120/75 63 18 98.4 98% are reported but you report unable to obtain.  Please correct.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 25 Feb 2026 16:51:53 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\nI have added the information and placed the order for the referral. \\n\\nThank you, \\nAmanda \"}, \"mailId\": \"\"}], \"memberName\": \"Barbara Garrey\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/18/2026 01:30 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"3\", \"callLog\": [{\"date\": \"2/11/2026 @ 04:12 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 04:12 PM\"}, {\"date\": \"2/4/2026 @ 03:00 PM\", \"result\": 0, \"comment\": \"Scheduled w/Amanda Virtual 2/18/26 at 1:30 pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/4/2026 @ 02:31 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 02:30 PM\"}, {\"date\": \"2/3/2026 @ 01:28 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000016037\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000016037\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000016037\", \"scheduleDate\": \"2026-2-18T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 14:31:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-04-2026 15:00:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', '{\"orderType\": 0, \"sortOrder\": 1771407971}', 0, NULL, '[{\"date\": \"2026-03-03 17:20:18\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"4ba75cf0-2e99-46d5-938f-f91bfe8063ec\\\",\\\"destination_fax_number\\\":\\\"12076412855\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"4ba75cf0-2e99-46d5-938f-f91bfe8063ec\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12076412855\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:26:24.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\\\":322,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":322,\\\"start_timestamp\\\":\\\"2026-03-03T22:20:39.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:26:24.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-2-18T13:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:21', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016037\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Garrey_10000016037_02182026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:20:17\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000016037.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Garrey_10000016037_02182026.pdf', NULL, 'Summary_10000016037.pdf', NULL, '[{\"date\": \"2026-02-20T20:52:54.084Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-25T16:51:52.973Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-18T14:45', 'Member_Summary_10000016037.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016037\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000016037.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:20:19\"}', 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
(557, NULL, NULL, NULL, '10000016073', '', '', NULL, 'Mary Ann', 'Grazioso', 'English', '', '{\"DOB\": 17142, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1174884951\", \"Pcp_Zip\": \"42407649\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"PICARD, PAIGE\", \"Rank_All\": 1, \"PCP_Phone\": \"2077952800\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8V57XN7JA54\", \"Member_City\": \"FARMINGDALE\", \"Office_Name\": \"CENTRAL MAINE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FARMINGDALE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-12-06\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"76 HIGH ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2077952808\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"37 SHELDON ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04344\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"37 SHELDON ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04344\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Grazioso\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mary Ann\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"maryanngrazioso08@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075823697\", \"Member_Identification_Number\": \"10000016073\", \"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:55\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:41\", \"value\": [{\"add\": \"37 SHELDON ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-12-06\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075823697\", \"zip\": \"04344\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FARMINGDALE\", \"gend\": 1, \"insh\": \"10000016073\", \"mzip\": \"04344\", \"name\": \"Mary Ann L Grazioso\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PICARD, PAIGE\", \"ppno\": \"2077952800\", \"cliId\": \"\", \"email\": \"maryanngrazioso08@gmail.com\", \"ename\": \"\", \"madd1\": \"37 SHELDON ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FARMINGDALE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 HIGH ST,\", \"pcpnpi\": \"1174884951\", \"pcpzip\": \"42407649\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"CENTRAL MAINE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077952808\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8V57XN7JA54\", \"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:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:41\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:55\", \"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:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(558, NULL, NULL, NULL, '10000016182', '', '', NULL, 'Barbara', 'Lawrence', '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\": \"1669577938\", \"Pcp_Zip\": \"04444\", \"Program\": \"Medicare\", \"Pcp_City\": \"Hampden\", \"Pcp_Name\": \"PATTEN, JOHN L\", \"Rank_All\": 1, \"PCP_Phone\": \"2078620300\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5CX4YQ7NX84\", \"Member_City\": \"HAMPDEN\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE HAMPDEN\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"HAMPDEN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-09-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"St Joseph Family Medicine Hampden,21 Western Ave\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2077778800\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"261 WESTERN AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04444\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"261 WESTERN AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04444\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Lawrence\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Barbara\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bblegmbarb@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078623566\", \"Member_Identification_Number\": \"10000016182\", \"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:56\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:43\", \"value\": [{\"add\": \"261 WESTERN AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1943-09-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078623566\", \"zip\": \"04444\", \"add2\": \"\", \"add3\": \"\", \"city\": \"HAMPDEN\", \"gend\": 1, \"insh\": \"10000016182\", \"mzip\": \"04444\", \"name\": \"Barbara L Lawrence\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PATTEN, JOHN L\", \"ppno\": \"2078620300\", \"cliId\": \"\", \"email\": \"bblegmbarb@roadrunner.com\", \"ename\": \"\", \"madd1\": \"261 WESTERN AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"HAMPDEN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"St Joseph Family Medicine Hampden,21 Western Ave\", \"pcpnpi\": \"1669577938\", \"pcpzip\": \"04444\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Hampden\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE HAMPDEN\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077778800\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5CX4YQ7NX84\", \"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:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:43\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:56\", \"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:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(559, NULL, NULL, NULL, '10000016188', '', '', '52661009', 'Jill', 'Hunt', '', '', '{\"DOB\": 17187, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1467094656\", \"Pcp_Zip\": \"04055\", \"Program\": \"Medicare\", \"Pcp_City\": \"Naples\", \"Pcp_Name\": \"SAUCIER, NICOLE M\", \"Rank_All\": 1, \"PCP_Phone\": \"2076936106\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7YM8UF9JC59\", \"Member_City\": \"Casco\", \"Office_Name\": \"NAPLES FAMILY PRACTICE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Raymond\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-01-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Naples Family Practice,410 Roosevelt Trl\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076934026\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"440 POLAND SPRINGS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04015\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 652\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04071\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hunt\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jill\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@102219.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076277253\", \"Member_Identification_Number\": \"10000016188\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-08-2026 13:03:08\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}', '{\"date\": \"2026-04-08 13:03:08\", \"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-06T11:55\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-09T11:23\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-10T11:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-11T19:54\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-19T17:08\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-25T16:11\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-04T19:42\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-06T13:25\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-09T11:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-14T15:46\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-20T19:27\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-24T14:01\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-25T11:24\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-26T12:32\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-31T09:42\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-01T12:02\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-03T12:30\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-06T11:33\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-07T09:50\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-08T13:03\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T11:23\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T19:54\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T17:08\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T16:11\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T11:52\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-14T15:46\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-20T19:27\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-26T12:32\"}, {\"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-08T13:03\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:44\", \"value\": [{\"add\": \"440 POLAND SPRINGS RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-01-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076277253\", \"zip\": \"04015\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Casco\", \"gend\": 1, \"insh\": \"10000016188\", \"mzip\": \"04071\", \"name\": \"Jill D Hunt\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SAUCIER, NICOLE M\", \"ppno\": \"2076936106\", \"cliId\": \"\", \"email\": \"declined@102219.com\", \"ename\": \"\", \"madd1\": \"PO BOX 652\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Raymond\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Naples Family Practice,410 Roosevelt Trl\", \"pcpnpi\": \"1467094656\", \"pcpzip\": \"04055\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Naples\", \"pcpname\": \"NAPLES FAMILY PRACTICE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076934026\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7YM8UF9JC59\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 10, \"callLog\": [{\"date\": \"4/8/2026 @ 10:03 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 09:50 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 11:33 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 12:30 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/1/2026 @ 12:02 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Jennifer number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 09:42 AM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Pamela Kratzer\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 12:32 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 @ 11:24 AM\", \"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:01 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 @ 07:27 PM\", \"result\": 10, \"comment\": \"03/20/2026- CALLED TO SCH  VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 03:46 PM\", \"result\": 10, \"comment\": \"Call disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 08:52 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 10:25 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 07:42 PM\", \"result\": 10, \"comment\": \"03/04/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 04:11 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sandy 3/3\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 05:08 PM\", \"result\": 10, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 07:54 PM\", \"result\": 10, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, DISC\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 11:59 AM\", \"result\": 10, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 11:59 AM\"}, {\"date\": \"2/9/2026 @ 11:23 AM\", \"result\": 10, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/10/2026 @ 11:23 AM\"}, {\"date\": \"2/6/2026 @ 11:55 AM\", \"result\": 10, \"comment\": \"o/c to schedule w/Sandy 2/19\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 11:54 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-06-2026 11:55:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"04-08-2026 13:03:08\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 21}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(560, NULL, NULL, NULL, '10000016189', '', '', NULL, 'Patsy', 'Muzzy', 'English', '', '{\"DOB\": 14642, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1912957069\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"CHAPPELLE, CATHRA M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9A24Y56XA81\", \"Member_City\": \"Cumberland Center\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cumberland Center\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-02-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282425\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"12 DROWNE RD APT 208\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04021\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"12 DROWNE RD APT 208\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04021\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Muzzy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Patsy\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"PMUZZY@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\": \"2074899138\", \"Member_Identification_Number\": \"10000016189\", \"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:57\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:44\", \"value\": [{\"add\": \"12 DROWNE RD APT 208\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-02-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074899138\", \"zip\": \"04021\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Cumberland Center\", \"gend\": 1, \"insh\": \"10000016189\", \"mzip\": \"04021\", \"name\": \"Patsy A Muzzy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CHAPPELLE, CATHRA M\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"PMUZZY@MAINE.RR.COM\", \"ename\": \"\", \"madd1\": \"12 DROWNE RD APT 208\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cumberland Center\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1912957069\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282425\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9A24Y56XA81\", \"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:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:57\", \"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:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(561, NULL, NULL, NULL, '10000016263', '', '', '94743867', 'Sandra', 'Fortin', '', '', '{\"DOB\": 15921, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"\", \"Program\": \"Medicare\", \"Pcp_City\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Medicare_ID\": \"1EQ3DV2NW88\", \"Member_City\": \"Auburn\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Auburn\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-08-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"79 CHARTER WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"79 CHARTER WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Fortin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sandra\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Kjlandry2019@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\": \"2073125684\", \"Member_Identification_Number\": \"10000016263\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2072124059\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-23-2026 15:27:53\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}', '{\"date\": \"2026-02-23 15:27:53\", \"hrastatus\": \"\", \"reportstatus\": \"Ineligible\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T09:38\", \"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-05T14:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T13:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T09:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-02-23T15:27\", \"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-09T13:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T09:38\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-02-23T15:27\", \"reportStatus_date\": \"2026-02-23T15:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-02-23T15:27\", \"username\": \"KCoash\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:46\", \"value\": [{\"add\": \"79 CHARTER WAY\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2072124059\", \"dob\": \"1943-08-03\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073125684\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Auburn\", \"gend\": 1, \"insh\": \"10000016263\", \"mzip\": \"04210\", \"name\": \"Sandra J Fortin\", \"plan\": \"Martin\'s Point\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Kjlandry2019@gmail.com\", \"ename\": \"\", \"madd1\": \"79 CHARTER WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Auburn\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1EQ3DV2NW88\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:46\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"2/23/2026 @ 03:27 PM\", \"result\": 2, \"comment\": \"member lives in an SNF with advanced dementia\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 03:23 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:40 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:34 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:36 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:50 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 09:38 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Sandy in March 2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:24 PM\", \"result\": 3, \"comment\": \"o/c to schedule w/Sandy in March 2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 01:12 PM\", \"result\": 3, \"comment\": \"Calling to schedule F2F w/Sandy in March\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 01:12 PM\"}, {\"date\": \"2/6/2026 @ 01:32 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 01:31 PM\"}, {\"date\": \"2/5/2026 @ 01:31 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 @ 01:30 PM\"}, {\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 13:31:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-11-2026 09:38:15\", \"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:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(562, NULL, NULL, NULL, '10000016341', '', '', NULL, 'Donald', 'Haley', '', '', '{\"DOB\": 16917, \"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\": \"4WQ6RY0HE64\", \"Member_City\": \"DANVILLE\", \"Office_Name\": \"FAMILY HEALTH CARE ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DANVILLE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-04-25\", \"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\": \"1329 OLD DANVILLE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04223\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 37\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04223\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Haley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077841072\", \"Member_Identification_Number\": \"10000016341\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077518715\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:20:05\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:20:05\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:20\", \"reportStatus_date\": \"2026-02-03T06:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:20\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:47\", \"value\": [{\"add\": \"1329 OLD DANVILLE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2077518715\", \"dob\": \"1946-04-25\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077841072\", \"zip\": \"04223\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DANVILLE\", \"gend\": 0, \"insh\": \"10000016341\", \"mzip\": \"04223\", \"name\": \"Donald E Haley\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SKELTON, SARAH K\", \"ppno\": \"2077847388\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 37\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DANVILLE\", \"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\": \"4WQ6RY0HE64\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:47\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:20\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:31:57\", \"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:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(563, NULL, NULL, NULL, '10000016378', '', '', NULL, 'Alva', 'Drinon', 'English', '', '{\"DOB\": 14643, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1750580486\", \"Pcp_Zip\": \"41065900\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"GRASSMANN, JEFFREY L\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8R32XQ5GU17\", \"Member_City\": \"Westbrook\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Westbrook\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-02-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 GANNETT DR STE C,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"300 SPRING ST\", \"Member_Zip_Code\": \"04092\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"300 SPRING ST\", \"Mailing_Zip_Code\": \"04092\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Drinon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alva\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@062725.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Member_Primary_Phone_Number\": \"2078561230\", \"Member_Identification_Number\": \"10000016378\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:18:36\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}', '{\"date\": \"2026-02-03 06:18:36\", \"hrastatus\": \"\", \"reportstatus\": \"Wrong Number\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:18\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"01-31-2026\", \"time\": \"09:52:23\", \"value\": [{\"add\": \"300 SPRING ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-02-02\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2078561230\", \"zip\": \"04092\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Westbrook\", \"gend\": 1, \"insh\": \"10000016378\", \"mzip\": \"04092\", \"name\": \"Alva C Drinon\", \"plan\": \"martin’s point\", \"pphy\": \"GRASSMANN, JEFFREY L\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"declined@062725.com\", \"ename\": \"\", \"madd1\": \"300 SPRING ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Westbrook\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DR STE C,\", \"pcpnpi\": \"1750580486\", \"pcpzip\": \"41065900\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8R32XQ5GU17\", \"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:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-31-2026 09:52:23\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 4, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:31:58\", \"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:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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
(564, 57818338, 44829497, '48822527', '10000016411', '', '', '94743867', 'Richard', 'Robertson', 'English', '', '{\"DOB\": 16926, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": 1548293772, \"Pcp_Zip\": \"04092\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"westbrook\", \"Pcp_Name\": \"Jenna Crutsinger NP\", \"Rank_All\": 1, \"PCP_Phone\": \"2076621340\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7QA7TT3FV45\", \"Member_City\": \"Westbrook\", \"Office_Name\": \"MH primary care\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Westbrook\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-05-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"1 Harnois ave\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2078930295, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"70 RUTH HUNTON CT APT 109\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04092\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"70 RUTH HUNTON CT APT 109\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04092\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Robertson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"rodeoredhat70@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2076372176, \"Member_Identification_Number\": \"10000016411\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2077302596}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 14:59:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 14:59:49\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-12T11:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-12T11:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-15T12:49\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-17T14:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-22T13:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T14:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-12T14:15\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-15T09:32\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-04T15:40\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-05T11:42\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-10T18:13\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-23T11:03\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-24T12:41\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-26T11:36\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-06T17:37\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T11:42\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T18:13\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T11:03\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T11:36\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-06T17:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-15T12:49\", \"reportStatus_date\": \"2026-03-15T12:49\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-22T13:38\", \"reportStatus_date\": \"2026-03-22T13:38\"}, {\"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-03-12T14:15\", \"username\": null}, {\"date\": \"2026-03-12T14:15\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-03-15T09:32\", \"username\": \"JLandry\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T10:33\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-15T12:49\", \"username\": \"JLandry\"}, {\"date\": \"2026-03-15T12:49\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-22T13:38\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-17T14:21\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-21T17:37\", \"username\": \"JLandry\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-22T13:38\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [{\"date\": \"2026-03-17T15:37\", \"username\": \"JWren1\"}], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-15-2026\", \"time\": \"11:58:31\", \"value\": [{\"add\": \"70 RUTH HUNTON CT APT 109\", \"age\": 79, \"ano\": \"\", \"cno\": 2077302596, \"dob\": \"1946-05-04\", \"eno\": \"2076329812\", \"lob\": \"GA - 2026\", \"pno\": 2076372176, \"zip\": \"04092\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Westbrook\", \"gend\": 0, \"insh\": \"10000016411\", \"mzip\": \"04092\", \"name\": \"Richard E Robertson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Jenna Crutsinger NP\", \"ppno\": \"2076621340\", \"cliId\": \"\", \"email\": \"rodeoredhat70@gmail.com\", \"ename\": \"richard Robertson Jr\", \"madd1\": \"70 RUTH HUNTON CT APT 109\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Westbrook\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"1 Harnois ave\", \"pcpnpi\": 1548293772, \"pcpzip\": \"04092\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"westbrook\", \"pcpname\": \"MH primary care\", \"program\": \"Medicare\", \"pcpfaxno\": 2078930295, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7QA7TT3FV45\", \"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-15-2026\", \"time\": \"09:32:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-21-2026 17:37:38\"}', NULL, NULL, '{\"memberId\": \"10000016411\", \"clinician\": \"Jennifer Landry\", \"qaAnalyst\": \"Jared Wren\", \"queryData\": [{\"date\": \"Tue, 17 Mar 2026 19:37:59 GMT\", \"name\": \"Jared \", \"role\": \"coder_lead\", \"files\": [], \"query\": {\"feedback\": \"Hello,\\n\\nUnder the cancer section, could you select active or history of for the CLL dx? Thank you.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 21 Mar 2026 21:37:37 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Richard Robertson\", \"codingAnalyst\": \"\", \"dateOfService\": \"\", \"clinicianMailId\": \"j.landry@focuscares.com\", \"qaAnalystMailId\": \"j.wren@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/12/2026 @ 02:15 PM\", \"result\": 0, \"comment\": \"Scheduled with jennifer landry 3/15/2026 @ 12:10am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 11:20 AM\", \"result\": 3, \"comment\": \"called to scheduled with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 05:37 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Elizabeth number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 11:36 AM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sandy 3/17\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 12:41 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Jennifer number disconnected.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 11:03 AM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM on alternate number. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 06:13 PM\", \"result\": 10, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/16/2026 @ 06:13 PM\"}, {\"date\": \"2/5/2026 @ 10:42 AM\", \"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/9/2026 @ 10:42 AM\"}, {\"date\": \"2/4/2026 @ 02:40 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 @ 02:35 PM\"}, {\"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\": {\"type\": \"visitType\", \"memberId\": \"10000016411\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": \"10000016411\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": \"10000016411\", \"scheduleDate\": \"2026-3-15T12:10\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 14:40:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"03-12-2026 14:15:35\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 14:59:46\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"cb951550-7d42-4725-af0a-76d1f8750d25\\\",\\\"destination_fax_number\\\":\\\"12078930295\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"cb951550-7d42-4725-af0a-76d1f8750d25\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12078930295\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:18:42.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:00:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:01:21.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:03:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:04:57.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:07:16.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:08:30.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:10:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:11:56.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:14:02.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:15:21.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:17:31.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:18:42.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-15T12:10', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:24', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016411\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Robertson_10000016411_03152026.pdf\", \"ftp_upload_date\": \"2026-03-24 14:59:46\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000016411.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Robertson_10000016411_03152026.pdf', NULL, 'Summary_10000016411.pdf', NULL, '[{\"date\": \"2026-03-15T16:49:03.309Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-21T21:37:36.662Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-15T12:48', 'Member_Summary_10000016411.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016411\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000016411.pdf\", \"member_ftp_upload_date\": \"2026-03-24 14:59:48\"}', 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
(565, NULL, NULL, NULL, '10000016557', '', '', '1019044', 'Carol', 'Larson', 'English', '', '{\"DOB\": 15676, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1952890485\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"KING, KARYN R\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2QD4CY3JW08\", \"Member_City\": \"Gorham\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gorham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-12-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238590\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"23 LAUREL PINES DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04038\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"23 LAUREL PINES DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04038\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Larson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carol\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"clarson2468@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078397618\", \"Member_Identification_Number\": \"10000016557\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076532219\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-08-2026 10:52:26\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}', '{\"date\": \"2026-04-08 10:52:26\", \"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:20\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-04T13:44\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-06T12:41\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-09T17:53\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-10T15:19\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-13T10:53\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-20T13:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-23T13:25\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-24T09:47\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-27T16:15\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-03T13:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-04T14:38\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-09T15:34\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-11T14:24\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-12T13:29\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-13T11:41\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-18T14:55\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-20T17:29\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-25T14:43\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-27T11:37\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-06T09:56\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-07T10:28\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-04-08T10:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T17:53\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T10:53\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T13:25\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T16:15\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T15:34\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-13T11:41\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-20T17:29\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-27T11:37\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-06T09:56\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-08T10:52\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:50\", \"value\": [{\"add\": \"23 LAUREL PINES DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2076532219\", \"dob\": \"1942-12-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078397618\", \"zip\": \"04038\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Gorham\", \"gend\": 1, \"insh\": \"10000016557\", \"mzip\": \"04038\", \"name\": \"Carol M Larson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KING, KARYN R\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"clarson2468@gmail.com\", \"ename\": \"\", \"madd1\": \"23 LAUREL PINES DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gorham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,100 Foden Rd Ste 203\", \"pcpnpi\": \"1952890485\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238590\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2QD4CY3JW08\", \"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:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:50\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 10, \"callLog\": [{\"date\": \"4/8/2026 @ 07:52 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 07:28 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 09:56 AM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Pamela number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 11:37 AM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Pamela Kratzer\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 11:43 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 05:29 PM\", \"result\": 10, \"comment\": \"o/c to sched w/Pamela 3/30\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:55 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Pamela number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 11:41 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 01:29 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 02:24 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 03:34 PM\", \"result\": 10, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 11:38 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:52 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 04:15 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sandy 3/9 or 3/20\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 09:47 AM\", \"result\": 10, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 01:25 PM\", \"result\": 10, \"comment\": \"o/c to sched w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 01:59 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Leana number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 10:53 AM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ Nicole Mattison DISCONNECTED. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:19 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 02:53 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 02:53 PM\"}, {\"date\": \"2/6/2026 @ 12:41 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Candace caller disconnected.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"3/3/2026 @ 12:41 PM\"}, {\"date\": \"2/4/2026 @ 01:44 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Sandra number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/11/2026 @ 01:44 PM\"}, {\"date\": \"1/29/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 13:44:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"04-08-2026 10:52:26\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 23}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(566, NULL, NULL, NULL, '10000016574', '', '', NULL, 'Marlene', 'Myers', '', '', '{\"DOB\": 16233, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1457474132\", \"Pcp_Zip\": \"41065900\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"COLEMAN, KRISTIN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6DH4GN4RT79\", \"Member_City\": \"Gray\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gray\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-06-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 GANNETT DR STE C,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"162 MAYALL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"162 MAYALL RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Myers\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marlene\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Mmyers610@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\": \"2076573567\", \"Member_Identification_Number\": \"10000016574\", \"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:59\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:50\", \"value\": [{\"add\": \"162 MAYALL RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1944-06-10\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076573567\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Gray\", \"gend\": 1, \"insh\": \"10000016574\", \"mzip\": \"04039\", \"name\": \"Marlene R Myers\", \"plan\": \"Martin\'s Point\", \"pphy\": \"COLEMAN, KRISTIN\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"Mmyers610@outlook.com\", \"ename\": \"\", \"madd1\": \"162 MAYALL RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gray\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DR STE C,\", \"pcpnpi\": \"1457474132\", \"pcpzip\": \"41065900\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6DH4GN4RT79\", \"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:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:50\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:31:59\", \"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:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(567, NULL, NULL, NULL, '10000016632', '', '', '66650973', 'Lorraine', 'Castaldo', '', '', '{\"DOB\": 16517, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1003879909\", \"Pcp_Zip\": \"04043\", \"Program\": \"Medicare\", \"Pcp_City\": \"Kennebunk\", \"Pcp_Name\": \"CUTONE, JENNIFER A\", \"Rank_All\": 1, \"PCP_Phone\": \"2074673200\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3X85ER9TW64\", \"Member_City\": \"North Waterboro\", \"Office_Name\": \"INTERNAL MEDICINE OF SOUTHERN MAINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"North Waterboro\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-03-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Internal Medicine of Southern Maine,2 Independence Dr Ste B\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2074673207\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"558 NEW DAM RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04061\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"558 NEW DAM RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04061\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Castaldo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lorraine\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"donnacastaldo21@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\": \"2072475015\", \"Member_Identification_Number\": \"10000016632\", \"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 17:17:06\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-04 17:17:06\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-27T14:04\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-03T16:08\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-04T17:17\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-11T14:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T17:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T10:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-19T13:26\", \"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:21\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-27T14:04\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T17:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T13:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-27T14:04\", \"reportStatus_date\": \"2026-02-27T14:04\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-03T16:08\", \"reportStatus_date\": \"2026-03-04T17:17\"}]', '{\"utc\": [{\"date\": \"2026-02-27T14:04\", \"username\": \"KCoash\"}, {\"date\": \"2026-03-03T16:08\", \"username\": \"KCoash\"}], \"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:47:51\", \"value\": [{\"add\": \"558 NEW DAM RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-03-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072475015\", \"zip\": \"04061\", \"add2\": \"\", \"add3\": \"\", \"city\": \"North Waterboro\", \"gend\": 1, \"insh\": \"10000016632\", \"mzip\": \"04061\", \"name\": \"Lorraine D Castaldo\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CUTONE, JENNIFER A\", \"ppno\": \"2074673200\", \"cliId\": \"\", \"email\": \"donnacastaldo21@gmail.com\", \"ename\": \"\", \"madd1\": \"558 NEW DAM RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"North Waterboro\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Internal Medicine of Southern Maine,2 Independence Dr Ste B\", \"pcpnpi\": \"1003879909\", \"pcpzip\": \"04043\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Kennebunk\", \"pcpname\": \"INTERNAL MEDICINE OF SOUTHERN MAINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074673207\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3X85ER9TW64\", \"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:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:51\"}', '{\"utc\": [{\"date\": \"2026-02-27T14:04\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-03-03T16:08\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:17 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Pamela Kratzer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 04:21 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 02:17 PM\", \"result\": 1, \"comment\": \"called to schedule F2F with Sandy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 04:08 PM\", \"result\": 6, \"comment\": \"o/c to sched F2F w/Sandy 3/9 - member unavailable\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:04 PM\", \"result\": 6, \"comment\": \"o/c to sched F2F w/Sandy 3/9 - call back after 4 pm member at work\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 01:26 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 10:56 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/20/2026 @ 10:55 AM\"}, {\"date\": \"2/13/2026 @ 05:09 PM\", \"result\": 13, \"comment\": \"Called to Schedule Virtual HRA with Leana caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/18/2026 @ 05:09 PM\"}, {\"date\": \"2/11/2026 @ 02:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/13/2026 @ 02:49 PM\"}, {\"date\": \"1/29/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-11-2026 14:50:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-04-2026 17:17:06\", \"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:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(568, NULL, NULL, NULL, '10000016654', '', '', '52661009', 'Marie', 'Day', '', '', '{\"DOB\": 15518, \"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\": \"4VJ0F55GV42\", \"Member_City\": \"Gray\", \"Office_Name\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gray\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-06-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"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\": \"6 WAYNE AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6 WAYNE AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Day\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marie\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@12162025.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076576191\", \"Member_Identification_Number\": \"10000016654\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-06-2026 14:23:13\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-06 14:23:13\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T10:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-06T14:23\", \"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-06T16:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T12:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T17:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T09:36\", \"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-06T14:57\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-24T10:47\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T16:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T12:08\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T09:36\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-24T10:48\", \"reportStatus_date\": \"2026-02-24T10:48\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-06T14:23\"}]', '{\"utc\": [{\"date\": \"2026-02-24T10:48\", \"username\": \"KCoash\"}], \"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:47:52\", \"value\": [{\"add\": \"6 WAYNE AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1942-06-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076576191\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Gray\", \"gend\": 1, \"insh\": \"10000016654\", \"mzip\": \"04039\", \"name\": \"Marie L Day\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STOCKWELL, GEORGE W\", \"ppno\": \"2078930290\", \"cliId\": \"\", \"email\": \"declined@12162025.com\", \"ename\": \"\", \"madd1\": \"6 WAYNE AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gray\", \"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\": \"4VJ0F55GV42\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:52\"}', '{\"utc\": [{\"date\": \"2026-02-24T10:48\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"3/6/2026 @ 02:23 PM\", \"result\": 1, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- dead air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 10:47 AM\", \"result\": 6, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26 - member stated wanted a c/b in MAY per Five9 notes\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 09:36 AM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Leana , dead air.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 05:04 PM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Leana , dead air.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 12:08 PM\", \"result\": 1, \"comment\": \"Called to schedule HRA w/ Nicole Mattison DEAD AIR. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 12:08 PM\"}, {\"date\": \"2/6/2026 @ 02:57 PM\", \"result\": 6, \"comment\": \"mbr asked for c/b later in the year \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"5/8/2026 @ 02:57 PM\"}, {\"date\": \"2/3/2026 @ 01:52 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 14:57:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-06-2026 14:23:13\", \"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:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(569, NULL, NULL, NULL, '10000016689', '', '', '66650973', 'Earle', 'Bessey', '', '', '{\"DOB\": 16636, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"\", \"Program\": \"Medicare\", \"Pcp_City\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Medicare_ID\": \"9UU0E57UW21\", \"Member_City\": \"Waterville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waterville\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-07-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"48 WINTER ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"48 WINTER ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Bessey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Earle\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"EDB3@EDBESSEY.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078736682\", \"Member_Identification_Number\": \"10000016689\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2075574911\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 11:56:33\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-24 11:56:33\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-09T11:53\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-24T11:56\", \"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-09T18:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T12:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-19T16:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T16:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T11:53\", \"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-09T18:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T16:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T16:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T11:53\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-24T11:56\", \"reportStatus_date\": \"2026-03-24T11:56\"}]', '{\"utc\": [{\"date\": \"2026-03-24T11:56\", \"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:47:53\", \"value\": [{\"add\": \"48 WINTER ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2075574911\", \"dob\": \"1945-07-18\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078736682\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Waterville\", \"gend\": 0, \"insh\": \"10000016689\", \"mzip\": \"04901\", \"name\": \"Earle D Bessey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PRESTON, DAVID G\", \"ppno\": 2078731098, \"cliId\": \"\", \"email\": \"EDB3@EDBESSEY.COM\", \"ename\": \"\", \"madd1\": \"48 WINTER ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waterville\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Mid Maine Medicine,325B Kennedy Memorial Dr\", \"pcpnpi\": 1871559203, \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"THAYER INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078735461, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9UU0E57UW21\", \"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:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:53\"}', '{\"utc\": [{\"date\": \"2026-03-24T11:56\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:34 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 11:56 AM\", \"result\": 6, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- member answered said he was in a meeting and would need a call another time- \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 07:30 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH  VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 05:07 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 11:53 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer No VM Setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 04:19 PM\", \"result\": 3, \"comment\": \"Per 5-9 member was called 2-25-2026 no vm set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 04:05 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 12:36 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/20/2026 @ 12:36 PM\"}, {\"date\": \"2/9/2026 @ 06:51 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/11/2026 @ 06:51 PM\"}, {\"date\": \"2/3/2026 @ 07:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"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\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 18:51:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-09-2026 11:53:19\", \"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:25', 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
(570, NULL, NULL, NULL, '10000016831', '', '', NULL, 'Lorna', 'Porter', 'English', '', '{\"DOB\": 15587, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1770911430\", \"Pcp_Zip\": \"42437291\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"DRUAN, KRISTEN\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073300\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6Q79K97KE19\", \"Member_City\": \"BANGOR\", \"Office_Name\": \"ST JOSEPH INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BANGOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-09-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"C/O ST MARYS HEALTH SYSTEM - PROVIDER ENROLLMENT,PO BOX 7291\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079071923\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"10 KILLARNEY CT\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04401\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"10 KILLARNEY CT\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04401\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Porter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lorna\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"lornview@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072800229\", \"Member_Identification_Number\": \"10000016831\", \"Member_Alternate_Phone_Number\": \"2072800229\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:22:19\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:19\", \"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:47:56\", \"value\": [{\"add\": \"10 KILLARNEY CT\", \"age\": \"\", \"ano\": \"2072800229\", \"cno\": \"\", \"dob\": \"1942-09-03\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072800229\", \"zip\": \"04401\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BANGOR\", \"gend\": 1, \"insh\": \"10000016831\", \"mzip\": \"04401\", \"name\": \"Lorna J Porter\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DRUAN, KRISTEN\", \"ppno\": \"2079073300\", \"cliId\": \"\", \"email\": \"lornview@icloud.com\", \"ename\": \"\", \"madd1\": \"10 KILLARNEY CT\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BANGOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"C/O ST MARYS HEALTH SYSTEM - PROVIDER ENROLLMENT,PO BOX 7291\", \"pcpnpi\": \"1770911430\", \"pcpzip\": \"42437291\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"ST JOSEPH INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079071923\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6Q79K97KE19\", \"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:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:56\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:32:00\", \"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:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(571, NULL, NULL, NULL, '10000016920', '', '', NULL, 'James', 'Donahue', 'English', '', '{\"DOB\": 17173, \"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\": \"1C80CP8WG12\", \"Member_City\": \"Cumberland Center\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cumberland Center\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-01-06\", \"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\": \"24 HEDGEROW DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04021\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"24 HEDGEROW DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04021\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Donahue\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Ldona24@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\": \"2078295008\", \"Member_Identification_Number\": \"10000016920\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076500493\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:21:17\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:21:17\", \"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:47:57\", \"value\": [{\"add\": \"24 HEDGEROW DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2076500493\", \"dob\": \"1947-01-06\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078295008\", \"zip\": \"04021\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Cumberland Center\", \"gend\": 0, \"insh\": \"10000016920\", \"mzip\": \"04021\", \"name\": \"James Donahue\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WADLAND, WILLIAM R\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"Ldona24@maine.rr.com\", \"ename\": \"\", \"madd1\": \"24 HEDGEROW DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cumberland 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\": \"1C80CP8WG12\", \"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:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:57\"}', '{\"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/23/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:32:01\", \"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:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(572, NULL, NULL, NULL, '10000016931', '', '', NULL, 'Pamela', 'Marchant', '', '', '{\"DOB\": 15739, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1619538964\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"BADILLO, JEFFREY\", \"Rank_All\": 1, \"PCP_Phone\": \"2075351200\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4P05HV8WK57\", \"Member_City\": \"FREEPORT\", \"Office_Name\": \"NORTHERN LIGHT MERCY PRIMARY CARE YARMOUTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FREEPORT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-02-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Northern Light Mercy Primary Care Yarmouth,385 Rte 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075351249\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"21 LINWOOD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04032\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"21 LINWOOD RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04032\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Marchant\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Pamela\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"PMARCHANT64@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\": \"2072399159\", \"Member_Identification_Number\": \"10000016931\", \"Member_Alternate_Phone_Number\": \"2078651537\", \"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:32:01\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:57\", \"value\": [{\"add\": \"21 LINWOOD RD\", \"age\": \"\", \"ano\": \"2078651537\", \"cno\": \"\", \"dob\": \"1943-02-02\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072399159\", \"zip\": \"04032\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FREEPORT\", \"gend\": 1, \"insh\": \"10000016931\", \"mzip\": \"04032\", \"name\": \"Pamela R Marchant\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BADILLO, JEFFREY\", \"ppno\": \"2075351200\", \"cliId\": \"\", \"email\": \"PMARCHANT64@yahoo.com\", \"ename\": \"\", \"madd1\": \"21 LINWOOD RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FREEPORT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Northern Light Mercy Primary Care Yarmouth,385 Rte 1\", \"pcpnpi\": \"1619538964\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"NORTHERN LIGHT MERCY PRIMARY CARE YARMOUTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075351249\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4P05HV8WK57\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:57\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:32:01\", \"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:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(573, NULL, NULL, NULL, '10000016993', '', '', '52197563', 'John', 'Murphy', '', '', '{\"DOB\": 17209, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": 1114059672, \"Pcp_Zip\": \"04330\", \"Program\": \"Medicare\", \"Pcp_City\": \"Augusta\", \"Pcp_Name\": \"CHELEUITTE, RAMON E\", \"Rank_All\": 1, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5VA4EW7GU03\", \"Member_City\": \"Oakland\", \"Office_Name\": \"THAYER INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Oakland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-02-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"12 Spruce St Ste 7,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2078615461, \"Plan_Term_Date\": \"2026-02-28\", \"Member_Address1\": \"49 MAYLAND ST\", \"Member_Zip_Code\": \"04963\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"49 MAYLAND ST\", \"Mailing_Zip_Code\": \"04963\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Murphy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"JM1643@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\": 2073141186, \"Member_Identification_Number\": \"10000016993\"}', 'client_014', '2026', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 23:32:23\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2026-03-03 23:32:23\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-26T14:47\", \"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:20\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-09T16:40\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T16:40\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T14:47\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"02-23-2026\", \"time\": \"23:36:58\", \"value\": [{\"add\": \"49 MAYLAND ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-02-11\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2073141186, \"zip\": \"04963\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Oakland\", \"gend\": 0, \"insh\": \"10000016993\", \"mzip\": \"04963\", \"name\": \"John J Murphy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CHELEUITTE, RAMON E\", \"ppno\": \"2078731098\", \"cliId\": \"\", \"email\": \"JM1643@YAHOO.COM\", \"ename\": \"\", \"madd1\": \"49 MAYLAND ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Oakland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"12 Spruce St Ste 7,\", \"pcpnpi\": 1114059672, \"pcpzip\": \"04330\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Augusta\", \"pcpname\": \"THAYER INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078615461, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5VA4EW7GU03\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:52:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-03-2026 00:11:52\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/26/2026 @ 02:47 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 02:46 PM\"}, {\"date\": \"2/9/2026 @ 04:40 PM\", \"result\": 6, \"comment\": \"  Called to Schedule Virtual HRA with Amanda but member requested a call back  Called to Schedule Virtual HRA with Amanda but member requested a call back   Member was not aware the appt was cancelled on 1/28/2026. Would like to reschedule when march (kathryn baxter) availibility opens up.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/6/2026 @ 04:29 PM\"}, {\"date\": \"1/28/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 16:40:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"01-31-2026 23:32:02\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1772529884}', 1, NULL, NULL, NULL, NULL, '2026-02-28', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(574, NULL, NULL, NULL, '10000017049', '', '', '52661009', 'Joyce', 'Folgert', 'English', '', '{\"DOB\": 14144, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": 1265482152, \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"DRISCOLL, MEGAN L\", \"Rank_All\": 1, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8QY0YA7WC19\", \"Member_City\": \"CORNISH\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"MADISON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1938-09-21\", \"Mailing_State\": \"WI\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"\\tInterMed,\\t100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Dane\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": 2078741483, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"46 MOOSE TRL\", \"Member_Zip_Code\": \"04020\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2016 KENDALL AVE\", \"Mailing_Zip_Code\": \"53726\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Folgert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joyce\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"joycellama@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2072107820, \"Member_Identification_Number\": \"10000017049\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-12-2026 15:12:27\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-12 15:12:27\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-12T15:12\", \"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-04T10:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T18:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T11:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T15:12\", \"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-06T18:28\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-16T01:26\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T18:28\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T11:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-12T15:12\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"03-24-2026\", \"time\": \"00:38:01\", \"value\": [{\"add\": \"46 MOOSE TRL\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1938-09-21\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2072107820, \"zip\": \"04020\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CORNISH\", \"gend\": 1, \"insh\": \"10000017049\", \"mzip\": \"53726\", \"name\": \"Joyce Folgert\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DRISCOLL, MEGAN L\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"joycellama@gmail.com\", \"ename\": \"\", \"madd1\": \"2016 KENDALL AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"MADISON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"WI\", \"pcpadd\": \"\\tInterMed,\\t100 Foden Rd Ste 203\", \"pcpnpi\": 1265482152, \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078741483, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8QY0YA7WC19\", \"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:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-24-2026 00:38:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 14, \"callLog\": [{\"date\": \"3/13/2026 @ 02:16 PM\", \"result\": 14, \"comment\": \"member called in is not available for march dates, is checking with her daughter to see if 4/11 would be ok.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 02:10 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 03:12 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 08:19 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 03:28 PM\", \"result\": 6, \"comment\": \" called to schedule face to face appt with Jennifer L, member stated will be out of state for 2 weeks so will callback to schedule\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 03:17 PM\", \"result\": 3, \"comment\": \" called to schedule face to face appt with Jennifer L\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/10/2026 @ 03:17 PM\"}, {\"date\": \"2/4/2026 @ 10:54 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:54 AM\"}, {\"date\": \"2/3/2026 @ 03:22 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:54:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-12-2026 15:12:27\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:26', 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
(575, 55499828, 44829497, '31048908', '10000017072', '', '', '543416', 'Nancy', 'Marin', 'English', '', '{\"DOB\": 15022, \"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\": 1912979402, \"Pcp_Zip\": \"04276\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"RUMFORD\", \"Pcp_Name\": \"DIETER KRECKEL\", \"Rank_All\": 1, \"PCP_Phone\": 2073690146, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9ND3X07TX00\", \"Member_City\": \"MILTON TWP\", \"Office_Name\": \"SWIFT RIVER FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"MILTON TWP\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-02-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"430 FRANKLIN ST\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Oxford\", \"Member_Country\": \"Oxford\", \"PCP_Fax_Number\": 2073648626, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"108 ROGER FARNUM RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04219\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"108 ROGER FARNUM RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04219\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Marin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nancy\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"drivert@hughes.net\", \"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\": 2073699052, \"Member_Identification_Number\": \"10000017072\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2073570959}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:04:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:04:43\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T16:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-09T10:01\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-16T12:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-16T13:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-11T15:26\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-04T08:22\", \"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-06T16:59\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-11T15:26\", \"reportStatus_date\": \"2026-02-11T15:26\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-09T10:01\", \"reportStatus_date\": \"2026-03-09T10:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-16T13:59\", \"reportStatus_date\": \"2026-03-16T13:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:04\", \"reportStatus_date\": \"2026-03-17T16:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:04\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-11T15:26\", \"username\": null}, {\"date\": \"2026-02-11T15:26\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-03-04T08:22\", \"username\": \"NMattison\"}], \"qaAssigned\": [{\"date\": \"2026-03-09T16:07\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-09T10:01\", \"username\": \"NMattison\"}, {\"date\": \"2026-03-09T10:01\", \"username\": \"NMattison\"}, {\"date\": \"2026-03-13T19:21\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-13T19:24\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-14T11:22\", \"username\": \"NMattison\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-16T13:59\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-16T12:03\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-16T13:59\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-13T19:26\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"10:52:04\", \"value\": [{\"add\": \"108 ROGER FARNUM RD\", \"age\": 85, \"ano\": \"\", \"cno\": 2073570959, \"dob\": \"1941-02-15\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2073699052, \"zip\": \"04219\", \"add2\": \"\", \"add3\": \"\", \"city\": \"MILTON TWP\", \"gend\": 1, \"insh\": \"10000017072\", \"mzip\": \"04219\", \"name\": \"Nancy Marin\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DIETER KRECKEL\", \"ppno\": 2073690146, \"cliId\": \"\", \"email\": \"drivert@hughes.net\", \"ename\": \"\", \"madd1\": \"108 ROGER FARNUM RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"MILTON TWP\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"430 FRANKLIN ST\", \"pcpnpi\": 1912979402, \"pcpzip\": \"04276\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"RUMFORD\", \"pcpname\": \"SWIFT RIVER FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2073648626, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9ND3X07TX00\", \"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-04-2026\", \"time\": \"08:22:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 10:52:04\"}', NULL, NULL, '{\"memberId\": \"10000017072\", \"clinician\": \"Nicole Mattison\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 13 Mar 2026 23:26:33 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Nicole,\\n1) Alendronate listed on the med list, has she been using this for a while? If so, can you select biphosphonate under long term care list \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 14 Mar 2026 15:22:53 GMT\", \"name\": \"Nicole \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"The bisphosphonate has been added to long term care list. Nikki\"}, \"mailId\": \"\"}], \"memberName\": \"Nancy Marin\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/07/2026 09:30 AM\", \"clinicianMailId\": \"n.mattison@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/11/2026 @ 03:26 PM\", \"result\": 0, \"comment\": \"scheduled we/Nicole for 3/7 at 9:30 per Five9 records and TSS\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 04:59 PM\", \"result\": 3, \"comment\": \"02/06/2026- F2F HRA WITH SANDRA CADWELL, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/18/2026 @ 04:59 PM\"}, {\"date\": \"2/3/2026 @ 05:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/16/2026 @ 09:00 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\": {\"type\": \"visitType\", \"memberId\": \"10000017072\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"31048908\", \"memberId\": \"10000017072\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"31048908\", \"memberId\": \"10000017072\", \"scheduleDate\": \"2026-3-7T09:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 16:59:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"02-11-2026 15:26:35\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:04:40\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"4f240669-5001-486c-83c6-09fab20dd7d9\\\",\\\"destination_fax_number\\\":\\\"12073648626\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"4f240669-5001-486c-83c6-09fab20dd7d9\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12073648626\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:10:32.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":334,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":334,\\\"start_timestamp\\\":\\\"2026-03-17T20:04:49.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:10:32.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-7T09:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:52:27', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000017072\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Marin_10000017072_03072026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:04:39\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000017072.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Marin_10000017072_03072026.pdf', NULL, 'Summary_10000017072.pdf', NULL, '[{\"date\": \"2026-03-09T14:01:53.280Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-14T15:22:52.692Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-07T10:39', 'Member_Summary_10000017072.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000017072\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000017072.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:04:42\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
