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
(1732, NULL, NULL, NULL, '10000064592', '', '', '52197563', 'Lorna', 'Blackmer', '', '', '{\"DOB\": 16799, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1316906589\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"LOISELLE, DANIEL\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2WJ0T36TH32\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-12-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"100 FODEN ROAD WEST,SUITE 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"14 BASKET LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"14 BASKET LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Blackmer\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lorna\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mblackme@maine.rr.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077972598\", \"Member_Identification_Number\": \"10000064592\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-06-2026 11:47:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-04-06 11:47:33\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-06T11: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-05T13:40\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T13:40\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-06T11:47\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:14:58\", \"value\": [{\"add\": \"14 BASKET LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-12-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077972598\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 1, \"insh\": \"10000064592\", \"mzip\": \"04103\", \"name\": \"Lorna L Blackmer\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LOISELLE, DANIEL\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"mblackme@maine.rr.com\", \"ename\": \"\", \"madd1\": \"14 BASKET LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN ROAD WEST,SUITE 203\", \"pcpnpi\": \"1316906589\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2WJ0T36TH32\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:14:58\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/6/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"4/10/2026 @ 11:47 AM\"}, {\"date\": \"2/5/2026 @ 01:40 PM\", \"result\": 6, \"comment\": \"Called to schedule IHA- call back in 2 months  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"4/2/2026 @ 01:40 PM\"}, {\"date\": \"2/4/2026 @ 04:36 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/10/2026 @ 04:35 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:36:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"01-31-2026 23:38:51\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', '{\"orderType\": 0, \"sortOrder\": 1775814750}', 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1733, NULL, NULL, NULL, '10000064617', '', '', '52661009', 'James', 'Semple', '', '', '{\"DOB\": 19828, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1952622151\", \"Pcp_Zip\": \"41065900\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"MOHAN, ELIZABETH A\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6P55A56MT78\", \"Member_City\": \"WEST BALDWIN\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WEST BALDWIN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-04-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"GERIATRIC 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\": \"118 SADDLEBACK RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04091\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"118 SADDLEBACK RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04091\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Semple\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078383187\", \"Member_Identification_Number\": \"10000064617\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-10-2026 10:58:17\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-10 10:58:17\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-10T10:58\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-10T10:58\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:14:59\", \"value\": [{\"add\": \"118 SADDLEBACK RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-04-14\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078383187\", \"zip\": \"04091\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WEST BALDWIN\", \"gend\": 0, \"insh\": \"10000064617\", \"mzip\": \"04091\", \"name\": \"James M Semple\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MOHAN, ELIZABETH A\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"118 SADDLEBACK RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WEST BALDWIN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DR STE C,\", \"pcpnpi\": \"1952622151\", \"pcpzip\": \"41065900\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6P55A56MT78\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:14:59\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/10/2026 @ 10:58 AM\", \"result\": 6, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26 - ok to c/b in July\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"7/15/2026 @ 10:58 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 10:58:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:38:51\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1734, NULL, NULL, '12383693', '10000064651', '', '', '52197563', 'Patricia', 'Vigue', '', '', '{\"DOB\": 19722, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1760467187\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"Pcp_City\": \"WATERVILLE\", \"Pcp_Name\": \"DOUGLAS, JAMES W\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9GV1MV7VQ27\", \"Member_City\": \"Pittston\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE CLINTON\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Pittston\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-12-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"10 WASHINGTON ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"629 WISCASSET RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04345\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"629 WISCASSET RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04345\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Vigue\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Patricia\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075579151\", \"Member_Identification_Number\": \"10000064651\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Spoke with the member but she has to take her sister to an appointment on the same date and would like to cancel. She requested a call back to reschedule for later in the month of April.\"}', 1, b'0', b'0', '{\"date\": \"04-06-2026 13:24:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-04-06 13:24:40\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-16T14:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T14:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T18:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T17:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T16:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-10T13:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-16T14:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-06T13:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-06T13:47\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-25T11:03\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-03-25T12:32\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-30T18:34\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-30T19:27\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2026-02-25T11:25\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2026-04-06T13:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-06T13:47\", \"reportStatus_date\": \"2026-02-06T13:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-25T11:25\", \"reportStatus_date\": \"2026-02-26T18:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T16:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-16T14:41\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-30T19:27\", \"reportStatus_date\": \"2026-03-30T19:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-06T13:24\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-25T11:25\", \"username\": \"chembrick\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-06T13:47\", \"username\": null}, {\"date\": \"2026-02-06T13:47\", \"username\": \"cwasilak\"}, {\"date\": \"2026-03-25T12:32\", \"username\": null}, {\"date\": \"2026-03-25T12:32\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-02-25T11:03\", \"username\": \"chembrick\"}, {\"date\": \"2026-03-30T18:34\", \"username\": \"KBaxter\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-30T19:27\", \"username\": \"LRing1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:14:59\", \"value\": [{\"add\": \"629 WISCASSET RD\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-12-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075579151\", \"zip\": \"04345\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Pittston\", \"gend\": 1, \"insh\": \"10000064651\", \"mzip\": \"04345\", \"name\": \"Patricia A Vigue\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DOUGLAS, JAMES W\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"629 WISCASSET RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Pittston\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"10 WASHINGTON ST,\", \"pcpnpi\": \"1760467187\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"WATERVILLE\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE CLINTON\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9GV1MV7VQ27\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-25-2026\", \"time\": \"09:57:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:14:59\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-25T11:25\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"chembrick\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-30T19:27\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"LRing1\", \"hraStatus\": 3, \"cancelText\": \"Spoke with the member but she has to take her sister to an appointment on the same date and would like to cancel. She requested a call back to reschedule for later in the month of April.\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/6/2026 @ 01:24 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"4/7/2026 @ 01:24 PM\"}, {\"date\": \"3/25/2026 @ 09:32 AM\", \"result\": 0, \"comment\": \"SCHEDULED F2F W/ KATHRYN BAXTER ON 4/1/2026 AT 11 AM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 12:45 PM\", \"result\": 13, \"comment\": \"Called to Schedule F2F HRA with Samuel caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 02:41 PM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 01:23 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"3/12/2026 @ 01:22 PM\"}, {\"date\": \"3/9/2026 @ 04:23 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"3/12/2026 @ 04:23 PM\"}, {\"date\": \"3/5/2026 @ 05:59 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/10/2026 @ 05:59 PM\"}, {\"date\": \"2/26/2026 @ 06:27 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA w/Jennifer Winslow.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 06:27 PM\"}, {\"date\": \"2/6/2026 @ 01:47 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Candace on February 25, 2026 at 11:00am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 02:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/12/2026 @ 02:49 PM\"}, {\"date\": \"2/3/2026 @ 11:40 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000064651\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": \"10000064651\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": \"10000064651\", \"scheduleDate\": \"2026-4-1T13:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 13:47:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}, {\"date\": \"02-25-2026 11:25:51\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}, {\"date\": \"03-30-2026 19:27:43\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-30-2026 19:27:43\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1775555255}', 1, NULL, NULL, 'In Person', '2026-4-1T13:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1735, NULL, NULL, NULL, '10000064767', '', '', '52197563', 'Michael', 'Schotten', 'English', '', '{\"DOB\": 22600, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1538176789\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"STEELE, ERIK N\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1EC9A42EC11\", \"Member_City\": \"WOOLWICH\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WOOLWICH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1961-11-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"53 GILMAN HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04579\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 142\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04579\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Schotten\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"G\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mschotten@comcast.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078412554\", \"Member_Identification_Number\": \"10000064767\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-05-2026 18:39:33\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-05 18:39:33\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T18:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T10:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T13:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T11:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T19:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T18:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T10:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T19:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T18:39\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:03\", \"value\": [{\"add\": \"53 GILMAN HILL RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-11-15\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078412554\", \"zip\": \"04579\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WOOLWICH\", \"gend\": 0, \"insh\": \"10000064767\", \"mzip\": \"04579\", \"name\": \"Michael G Schotten\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STEELE, ERIK N\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mschotten@comcast.net\", \"ename\": \"\", \"madd1\": \"PO BOX 142\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WOOLWICH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1538176789\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1EC9A42EC11\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/23/2026 @ 12:12 PM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 06:39 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 07:19 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 11:10 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/2/2026 @ 11:10 AM\"}, {\"date\": \"2/26/2026 @ 01:24 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/2/2026 @ 01:23 PM\"}, {\"date\": \"2/10/2026 @ 10:38 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:38 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-10-2026 10:38:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-05-2026 18:39:33\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1736, NULL, NULL, NULL, '10000064845', '', '', '14035267', 'Peter', 'Young', '', '', '{\"DOB\": 19559, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1952406308\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"KNAUSENBERGER, ROLAND H\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9EQ0GG7XU26\", \"Member_City\": \"OAKLAND\", \"Office_Name\": \"THAYER INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OAKLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-07-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Thayer Internal Medicine,149 North St Dept IM\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078613281\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"4 BROOKSIDE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04963\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4 BROOKSIDE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04963\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Young\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"paybrookside@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\": \"2074657502\", \"Member_Identification_Number\": \"10000064845\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 16:38:17\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-25 16:38:17\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T12:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-25T16:38\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T10:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:27\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-25T16:38\", \"reportStatus_date\": \"2026-02-25T16:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-25T16:38\", \"username\": \"LAnguiano\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:04\", \"value\": [{\"add\": \"4 BROOKSIDE DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-07-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074657502\", \"zip\": \"04963\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OAKLAND\", \"gend\": 0, \"insh\": \"10000064845\", \"mzip\": \"04963\", \"name\": \"Peter A Young\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KNAUSENBERGER, ROLAND H\", \"ppno\": \"2077955700\", \"cliId\": \"\", \"email\": \"paybrookside@gmail.com\", \"ename\": \"\", \"madd1\": \"4 BROOKSIDE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OAKLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Thayer Internal Medicine,149 North St Dept IM\", \"pcpnpi\": \"1952406308\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"THAYER INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078613281\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9EQ0GG7XU26\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:04\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-25T16:38\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/25/2026 @ 04:38 PM\", \"result\": 9, \"comment\": \"Per notes in 5-9 member refused 2-12-2026 \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 10:55 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 12:41 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/9/2026 @ 12:40 PM\"}, {\"date\": \"2/5/2026 @ 09:10 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/11/2026 @ 09:10 AM\"}, {\"date\": \"2/3/2026 @ 07:18 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\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 09:10:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"01-31-2026 23:38:52\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1737, NULL, NULL, NULL, '10000064918', '', '', NULL, 'Jacob', 'Webb', '', '', '{\"DOB\": 19548, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1861451080\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"PIERCE, DANIEL C\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8H55W83AX82\", \"Member_City\": \"FALMOUTH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FALMOUTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-07-08\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"7 FUNDY RD APT 17\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04105\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 FUNDY RD APT 17\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04105\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Webb\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jacob\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jcb_webb@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073172603\", \"Member_Identification_Number\": \"10000064918\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:21:49\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:21:49\", \"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\": \"01:15:07\", \"value\": [{\"add\": \"7 FUNDY RD APT 17\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-07-08\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073172603\", \"zip\": \"04105\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FALMOUTH\", \"gend\": 0, \"insh\": \"10000064918\", \"mzip\": \"04105\", \"name\": \"Jacob E Webb\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PIERCE, DANIEL C\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"jcb_webb@yahoo.com\", \"ename\": \"\", \"madd1\": \"7 FUNDY RD APT 17\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FALMOUTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": \"1861451080\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8H55W83AX82\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:07\"}', '{\"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/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:38:52\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:11', 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
(1738, NULL, NULL, NULL, '10000064921', '', '', '52197563', 'Mark', 'Ruane', '', '', '{\"DOB\": 19423, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1891800546\", \"Pcp_Zip\": \"44019942\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"RUSK, SCOTT F\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1GC5T41FH85\", \"Member_City\": \"OGUNQUIT\", \"Office_Name\": \"WELLS PRIMARY CARE OF YORK HOSPITAL\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OGUNQUIT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-03-05\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"144 STATE STREET,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"8 COLES LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"03907\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 2407\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"03907\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Ruane\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mark\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mwcoastal@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\": \"2076462677\", \"Member_Identification_Number\": \"10000064921\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-13-2026 13:00:00\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-13 13:00:00\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-13T13:00\", \"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-05T16:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T18:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T17:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T13:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T12:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T18:49\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T17:36\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-13T13:00\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:08\", \"value\": [{\"add\": \"8 COLES LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-03-05\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076462677\", \"zip\": \"03907\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OGUNQUIT\", \"gend\": 0, \"insh\": \"10000064921\", \"mzip\": \"03907\", \"name\": \"Mark W Ruane\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RUSK, SCOTT F\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mwcoastal@gmail.com\", \"ename\": \"\", \"madd1\": \"PO BOX 2407\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OGUNQUIT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"144 STATE STREET,\", \"pcpnpi\": \"1891800546\", \"pcpzip\": \"44019942\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"WELLS PRIMARY CARE OF YORK HOSPITAL\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1GC5T41FH85\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:08\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:04 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 11:05 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 12:15 PM\", \"result\": 3, \"comment\": \"03/23/2026- CALLED TO SCH -MPHP- VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 04:21 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 01:00 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 05:36 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Erin no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 06:49 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA w/Jennifer Winslow.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 12:53 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/10/2026 @ 12:53 PM\"}, {\"date\": \"2/5/2026 @ 04:49 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/9/2026 @ 04:48 PM\"}, {\"date\": \"2/3/2026 @ 02:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"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-05-2026 16:49:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-13-2026 13:00:00\", \"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:59:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1739, NULL, NULL, NULL, '10000064925', '', '', NULL, 'Susan', 'Cairns', '', '', '{\"DOB\": 17611, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1255369575\", \"Pcp_Zip\": \"40749701\", \"Program\": \"Medicare\", \"Pcp_City\": \"SCARBOROUGH\", \"Pcp_Name\": \"HAYES, STEPHEN R\", \"Rank_All\": 1, \"PCP_Phone\": \"2076621340\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7DY4PW3KJ74\", \"Member_City\": \"WINDHAM\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-03-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"301C US ROUTE 1,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076621341\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 CHRISTMAS TREE WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 CHRISTMAS TREE WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Cairns\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Susan\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Declined@121825.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078922156\", \"Member_Identification_Number\": \"10000064925\", \"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:38:53\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:09\", \"value\": [{\"add\": \"15 CHRISTMAS TREE WAY\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-03-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078922156\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDHAM\", \"gend\": 1, \"insh\": \"10000064925\", \"mzip\": \"04062\", \"name\": \"Susan Cairns\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HAYES, STEPHEN R\", \"ppno\": \"2076621340\", \"cliId\": \"\", \"email\": \"Declined@121825.com\", \"ename\": \"\", \"madd1\": \"15 CHRISTMAS TREE WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"301C US ROUTE 1,\", \"pcpnpi\": \"1255369575\", \"pcpzip\": \"40749701\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SCARBOROUGH\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076621341\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7DY4PW3KJ74\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:09\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:38:53\", \"status\": 4, \"details\": \"member previous year scheduled date not exceed 10 months\", \"disabled\": true, \"notification\": null}', NULL, NULL, 0, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:12', 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
(1740, 62035418, 44829497, '17537038', '10000065049', '', '', '24168610', 'Don', 'Horstkotte', 'English', '', '{\"DOB\": 19569, \"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\": 1649565672, \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"TODD MICHAELIS\", \"Rank_All\": 1, \"PCP_Phone\": 2078741489, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4C85RM8HF91\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-07-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"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\": \"7 OLD BOG RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 OLD BOG RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Horstkotte\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Don\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"donhorstkotte@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\": 8153559051, \"Member_Identification_Number\": \"10000065049\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:31:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:31:04\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T18:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T13:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T16:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-01T11:49\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-09T19:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T02:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-12T17:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-01T09:27\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:19\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-12T17:07\", \"reportStatus_date\": \"2026-02-12T17:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-01T11:49\", \"reportStatus_date\": \"2026-03-01T11:49\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 7, \"hraStatus_date\": \"2026-03-09T19:32\", \"reportStatus_date\": \"2026-03-09T19:32\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:31\", \"reportStatus_date\": \"2026-03-10T14:31\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:31\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-12T17:07\", \"username\": null}, {\"date\": \"2026-02-12T17:07\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-03-01T09:27\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-03T09:42\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-01T11:49\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-01T11:49\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-08T15:18\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-10T02:34\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-09T19:32\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-10T02:34\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-05T12:54\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-23-2026\", \"time\": \"11:46:07\", \"value\": [{\"add\": \"7 OLD BOG RD\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-07-29\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 8153559051, \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000065049\", \"mzip\": \"04106\", \"name\": \"Don A Horstkotte\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TODD MICHAELIS\", \"ppno\": 2078741489, \"cliId\": \"\", \"email\": \"donhorstkotte@gmail.com\", \"ename\": \"20735501555\", \"madd1\": \"7 OLD BOG RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 Foden Rd Ste 203\", \"pcpnpi\": 1649565672, \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2075238590, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4C85RM8HF91\", \"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-01-2026\", \"time\": \"09:27:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-23-2026 11:46:07\"}', NULL, NULL, '{\"memberId\": \"10000065049\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Thu, 05 Mar 2026 17:54:35 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1) for the medication section for OTC please select yes/no\\n2) since patient is seeing specialist for OSA please add to assessment of diagnosis with supporting data\\n3) does patient have asthma, COPD or both? I see in med list you have COPD but then in respiratory section you have selected asthma\\n4) for cardiac assessment of diagnosis since patient is seeing specialist for AFIB can you add to this section and supported by data\\n5) in the med list you have patient taking medication for anxiety and then in neuro you have depression selected can you edit and/or\\nadd anxiety to neuro assessment of diagnosis with supported by data\\n\\nthank you! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 08 Mar 2026 19:18:43 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Natalie, \\n\\nI have updated the form. \\n\\nThank you!\\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Don Horstkotte\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/01/2026 11:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"n.schaaf@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/12/2026 @ 05:07 PM\", \"result\": 0, \"comment\": \"Scheduled with Amanda Milliken 3/1/2026 @ 11:00am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 04:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/19/2026 @ 04:23 PM\"}, {\"date\": \"2/11/2026 @ 10:31 AM\", \"result\": 13, \"comment\": \" called to schedule face to face , caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 10:30 AM\"}, {\"date\": \"2/10/2026 @ 06:44 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/12/2026 @ 12:44 PM\"}, {\"date\": \"2/3/2026 @ 05:34 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000065049\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000065049\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000065049\", \"scheduleDate\": \"2026-3-1T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 18:44:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-12-2026 17:07:26\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:31:03\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"55ad97f8-d941-4193-842d-7bd5c9e297c6\\\",\\\"destination_fax_number\\\":\\\"12075238590\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"55ad97f8-d941-4193-842d-7bd5c9e297c6\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12075238590\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:44:00.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-10T18:31:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:31:37.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:33:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:33:59.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:36:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:36:33.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:38:44.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:38:59.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:41:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:41:31.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:43:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:44:00.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-1T11:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:12', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065049\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Horstkotte_10000065049_03012026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:31:02\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000065049.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Horstkotte_10000065049_03012026.pdf', NULL, 'Summary_10000065049.pdf', NULL, '[{\"date\": \"2026-03-01T16:49:23.042Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-08T19:18:43.306Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-01T11:48', 'Member_Summary_10000065049.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065049\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000065049.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:31:04\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(1741, NULL, NULL, NULL, '10000065101', '', '', '24168610', 'Michael', 'Duquette', '', '', '{\"DOB\": 19419, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1528034303\", \"Pcp_Zip\": \"04330\", \"Program\": \"Medicare\", \"Pcp_City\": \"Augusta\", \"Pcp_Name\": \"CARON, LAURA P\", \"Rank_All\": 1, \"PCP_Phone\": \"2072136713\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9YY4P25AT82\", \"Member_City\": \"SOUTH GARDINER\", \"Office_Name\": \"FAMILY FOCUSED HEALTHCARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH GARDINER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-03-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Family Focused Healthcare,219 Capitol St Ste 5\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2072136785\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 BARTLETT ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04359\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 223\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04359\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Duquette\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mrduke29@aol.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075824898\", \"Member_Identification_Number\": \"10000065101\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-03-2026 11:26:12\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-04-03 11:26:12\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-10T13:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-18T13:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-04-03T11:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T17:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T16:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T12:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T18:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-10T13:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T10:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T18:01\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-10T13:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-18T13:09\", \"reportStatus_date\": \"2026-03-18T13:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-04-03T11:26\", \"reportStatus_date\": \"2026-04-03T11:26\"}]', '{\"utc\": [{\"date\": \"2026-03-18T13:09\", \"username\": \"FBeckford\"}, {\"date\": \"2026-04-03T11:26\", \"username\": \"FBeckford\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:13\", \"value\": [{\"add\": \"15 BARTLETT ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-03-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075824898\", \"zip\": \"04359\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH GARDINER\", \"gend\": 0, \"insh\": \"10000065101\", \"mzip\": \"04359\", \"name\": \"Michael R Duquette\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CARON, LAURA P\", \"ppno\": \"2072136713\", \"cliId\": \"\", \"email\": \"mrduke29@aol.com\", \"ename\": \"\", \"madd1\": \"PO BOX 223\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH GARDINER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Family Focused Healthcare,219 Capitol St Ste 5\", \"pcpnpi\": \"1528034303\", \"pcpzip\": \"04330\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Augusta\", \"pcpname\": \"FAMILY FOCUSED HEALTHCARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2072136785\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9YY4P25AT82\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:13\"}', '{\"utc\": [{\"date\": \"2026-03-18T13:09\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-04-03T11:26\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"4/3/2026 @ 11:26 AM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Kathryn but member requested a call back. In MAY  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 01:09 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Samuel but member not interested at this time Callback in week member just had a surgery \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 04:41 PM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Samuel but line was busy.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 01:44 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 06:01 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 12:37 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 04:26 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 05:23 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/12/2026 @ 05:22 PM\"}, {\"date\": \"2/9/2026 @ 10:19 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/16/2026 @ 10:19 AM\"}, {\"date\": \"2/3/2026 @ 11:27 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 17:23:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"03-10-2026 13:44:52\", \"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:59:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1742, NULL, NULL, NULL, '10000065192', '', '', NULL, 'Deborah', 'Coward', 'English', '', '{\"DOB\": 18103, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1073833703\", \"Pcp_Zip\": \"41062855\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"NORMAN, ANASTASIA R\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9UD5MC7WE93\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-07-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"96 OCEAN ST STE 4,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"17 WOODUBRY ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"17 WOODUBRY ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Coward\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deborah\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"trubrit@trubritrealty.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\": \"2078388126\", \"Member_Identification_Number\": \"10000065192\", \"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:38:54\", \"hrastatus\": 20, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:15\", \"value\": [{\"add\": \"17 WOODUBRY ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-07-24\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078388126\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 1, \"insh\": \"10000065192\", \"mzip\": \"04106\", \"name\": \"Deborah F Coward\", \"plan\": \"Martin\'s Point\", \"pphy\": \"NORMAN, ANASTASIA R\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"trubrit@trubritrealty.com\", \"ename\": \"\", \"madd1\": \"17 WOODUBRY ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"96 OCEAN ST STE 4,\", \"pcpnpi\": \"1073833703\", \"pcpzip\": \"41062855\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9UD5MC7WE93\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:15\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"01-31-2026 23:38: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:59:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1743, NULL, NULL, NULL, '10000065250', '', '', '52661009', 'Joanne', 'Neithercut', '', '', '{\"DOB\": 16527, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1174758866\", \"Pcp_Zip\": \"04072\", \"Program\": \"Medicare\", \"Pcp_City\": \"Saco\", \"Pcp_Name\": \"DENNING BOLLE, SARA J\", \"Rank_All\": 1, \"PCP_Phone\": \"2076023571\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6RF8WA0RF66\", \"Member_City\": \"Saco\", \"Office_Name\": \"MATURE CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bridgton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-03-31\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Mature Care,655 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2076023573\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"392 MAIN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04072\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"355 HIO RIDGE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04009\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Neithercut\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joanne\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@022723.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078388459\", \"Member_Identification_Number\": \"10000065250\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-05-2026 09:24:38\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}', '{\"date\": \"2026-02-05 09:24:38\", \"hrastatus\": \"\", \"reportstatus\": \"Wrong Number\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2026-02-05T09:24\", \"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-05T09:24\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:18\", \"value\": [{\"add\": \"392 MAIN ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-03-31\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078388459\", \"zip\": \"04072\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Saco\", \"gend\": 1, \"insh\": \"10000065250\", \"mzip\": \"04009\", \"name\": \"Joanne C Neithercut\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DENNING BOLLE, SARA J\", \"ppno\": \"2076023571\", \"cliId\": \"\", \"email\": \"declined@022723.com\", \"ename\": \"\", \"madd1\": \"355 HIO RIDGE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bridgton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Mature Care,655 Main St\", \"pcpnpi\": \"1174758866\", \"pcpzip\": \"04072\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Saco\", \"pcpname\": \"MATURE CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076023573\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6RF8WA0RF66\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:18\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": \"4\", \"callLog\": [{\"date\": \"2/5/2026 @ 09:24 AM\", \"result\": 4, \"comment\": \"calling to sched virtual IHA w/Amanda M - woman who answered told me it\'s the wrong number\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 02:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 09:24:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-05-2026 09:24:38\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:14', 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
(1744, 93442164, 44829497, '17537038', '10000065318', '', '', '543416', 'Jeffrey', 'Pinkham', 'English', '', '{\"DOB\": 20589, \"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\": 1194801993, \"Pcp_Zip\": \"04259\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Monmouth\", \"Pcp_Name\": \"GARY RIVARD\", \"Rank_All\": 1, \"PCP_Phone\": 2075243501, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4CW8ND7CN26\", \"Member_City\": \"Fayette\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Fayette\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1956-05-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"11 Academy RD \", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2076476015, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"351 SOUTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04349\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"351 SOUTH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04349\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Pinkham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jeffrey\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"flyfish822@aol.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2076202533, \"Member_Identification_Number\": \"10000065318\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:31:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:31:07\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T16:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-06T14:07\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-08T18:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-08T19:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-09T15:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-06T12:40\", \"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-09T15:16\", \"reportStatus_date\": \"2026-02-09T15:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-08T19:39\", \"reportStatus_date\": \"2026-03-08T19:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:31\", \"reportStatus_date\": \"2026-03-10T14:31\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:31\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-09T15:16\", \"username\": null}, {\"date\": \"2026-02-09T15:16\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-03-06T12:40\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-06T15:27\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-06T14:07\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-06T14:07\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-07T13:55\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-08T19:39\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-08T18:47\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-08T19:39\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-07T08:35\", \"username\": \"mscanlon1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-23-2026\", \"time\": \"11:50:58\", \"value\": [{\"add\": \"351 SOUTH RD\", \"age\": 69, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1956-05-14\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2076202533, \"zip\": \"04349\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Fayette\", \"gend\": 0, \"insh\": \"10000065318\", \"mzip\": \"04349\", \"name\": \"Jeffrey T Pinkham\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GARY RIVARD\", \"ppno\": 2075243501, \"cliId\": \"\", \"email\": \"flyfish822@aol.com\", \"ename\": \"\", \"madd1\": \"351 SOUTH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Fayette\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"11 Academy RD \", \"pcpnpi\": 1194801993, \"pcpzip\": \"04259\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Monmouth\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": 2076476015, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4CW8ND7CN26\", \"currentgend\": \"Male\", \"pphycomment\": \"Provider is Debrah Gilmette; Dr Rivard is medical director \", \"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-05-2026\", \"time\": \"13:08:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-23-2026 11:50:58\"}', NULL, NULL, '{\"memberId\": \"10000065318\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Meredyth Scanlon\", \"queryData\": [{\"date\": \"Sat, 07 Mar 2026 13:16:31 GMT\", \"name\": \"Meredyth \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1. Long term use can you statin\\n2. HDL  and DM says diet controlled but he on medications. Can you check off medication to the ROS for lipid and diabetes\\nThank you\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 07 Mar 2026 18:55:25 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Meredith, \\nHe took himself off the lipitor. He also stopped his blood pressure medication but was not sure which one he had been taking last. I added comments to the form. \\nThank you!\\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Jeffrey Pinkham\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/06/2026 12:30 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.scanlon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/9/2026 @ 12:16 PM\", \"result\": 0, \"comment\": \"Scheduled virtual appointment with Amanda on 3/6/2026 at 12:30 pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 01:46 PM\", \"result\": 3, \"comment\": \"02/06/2026- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/10/2026 @ 01:46 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000065318\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000065318\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000065318\", \"scheduleDate\": \"2026-3-6T12:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 13:46:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"02-09-2026 15:16:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:31:06\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"33006f17-6868-491c-9d5f-5910c4830c2b\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"33006f17-6868-491c-9d5f-5910c4830c2b\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:49:53.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-10T18:31:17.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:32:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:34:41.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:35:53.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:38:05.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:39:20.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:41:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:42:52.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:45:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:46:15.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:48:34.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:49:53.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-6T12:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:14', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065318\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Pinkham_10000065318_03062026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:31:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000065318.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Pinkham_10000065318_03062026.pdf', NULL, 'Summary_10000065318.pdf', NULL, '[{\"date\": \"2026-03-06T19:07:01.649Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-07T18:55:24.831Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-06T14:00', 'Member_Summary_10000065318.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065318\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000065318.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:31:07\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(1745, NULL, NULL, NULL, '10000065432', '', '', '24168610', 'Ella', 'Seavor', 'English', '', '{\"DOB\": 21178, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1710066410\", \"Pcp_Zip\": \"40399629\", \"Program\": \"Medicare\", \"Pcp_City\": \"GRAY\", \"Pcp_Name\": \"HILARY, MANJU\", \"Rank_All\": 1, \"PCP_Phone\": \"2076573308\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5G01PR3WM08\", \"Member_City\": \"Gorham\", \"Office_Name\": \"GRAY FAMILY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gorham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1957-12-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"126 SHAKER RD,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076573309\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"80 DOW RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04038\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"80 DOW RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04038\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Seavor\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ella\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072220085\", \"Member_Identification_Number\": \"10000065432\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-23-2026 14:23:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-23 14:23:41\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-23T14: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-06T13:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T14:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T19:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T18:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T14:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T13:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T18:02\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T14:23\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:22\", \"value\": [{\"add\": \"80 DOW RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1957-12-24\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072220085\", \"zip\": \"04038\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Gorham\", \"gend\": 1, \"insh\": \"10000065432\", \"mzip\": \"04038\", \"name\": \"Ella L Seavor\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HILARY, MANJU\", \"ppno\": \"2076573308\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"80 DOW RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gorham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"126 SHAKER RD,\", \"pcpnpi\": \"1710066410\", \"pcpzip\": \"40399629\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"GRAY\", \"pcpname\": \"GRAY FAMILY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076573309\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5G01PR3WM08\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:22\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 09:00 AM\", \"result\": 3, \"comment\": \"called to schedule w/ Jennifer Landry\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 03:44 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sam A 4/11\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 10:01 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 01:41 PM\", \"result\": 3, \"comment\": \"called to schedule w/ kathryn baxter \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 10:14 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 04:58 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 03:02 PM\", \"result\": 3, \"comment\": \"called to schedule with jennifer landry f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 11:52 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/20\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:35 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 04:43 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9 or 3/20\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 10:21 AM\", \"result\": 3, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:23 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 03:02 PM\", \"result\": 3, \"comment\": \"called to schedule f2f with sandy , lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 07:34 PM\", \"result\": 3, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/18/2026 @ 07:33 PM\"}, {\"date\": \"2/10/2026 @ 02:20 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/17/2026 @ 02:20 PM\"}, {\"date\": \"2/6/2026 @ 01:29 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 01:29 PM\"}, {\"date\": \"2/3/2026 @ 11:27 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa Scott\", \"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-06-2026 13:29:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-23-2026 14:23:41\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 18}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1746, NULL, NULL, '39698290', '10000065480', '', '', '52197563', 'Richard', 'Anderson', '', '', '{\"DOB\": 19738, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1134206352\", \"Pcp_Zip\": \"41066143\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"FRASER, ROBERT J\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6Q26A76QD73\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-01-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"100 FODEN RD. W,SUITE 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"97 FLORIDA AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"97 FLORIDA AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Anderson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@12082023.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073910435\", \"Member_Identification_Number\": \"10000065480\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Did not feel he needed the visit \"}', 1, b'0', b'0', '{\"date\": \"04-09-2026 10:43:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-04-09 10:43:44\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-10T13:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T13:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T17:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-09T10:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-11T13:05\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-04-03T14:56\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-19T08:59\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-20T13:09\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T14:35\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-11T13:05\", \"reportStatus_date\": \"2026-02-11T13:05\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-19T08:59\", \"reportStatus_date\": \"2026-02-20T13:09\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-03T14:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-09T10:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-11T13:05\", \"username\": null}, {\"date\": \"2026-02-11T13:05\", \"username\": \"cwasilak\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-19T08:59\", \"username\": \"SCadwell\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:23\", \"value\": [{\"add\": \"97 FLORIDA AVE\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-01-14\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073910435\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 0, \"insh\": \"10000065480\", \"mzip\": \"04103\", \"name\": \"Richard E Anderson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FRASER, ROBERT J\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"declined@12082023.com\", \"ename\": \"\", \"madd1\": \"97 FLORIDA AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN RD. W,SUITE 203\", \"pcpnpi\": \"1134206352\", \"pcpzip\": \"41066143\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6Q26A76QD73\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-12-2026\", \"time\": \"10:07:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:23\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-19T08:59\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"SCadwell\", \"hraStatus\": 3, \"cancelText\": \"Did not feel he needed the visit \", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/9/2026 @ 10:43 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 4/17 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"4/10/2026 @ 10:42 AM\"}, {\"date\": \"4/3/2026 @ 02:56 PM\", \"result\": 14, \"comment\": \"cannot do a video call\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"4/4/2026 @ 02:56 PM\"}, {\"date\": \"2/20/2026 @ 01:09 PM\", \"result\": 6, \"comment\": \"Called to get member rescheduled with mphp nurses -member wants call back April 2026 \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"4/1/2026 @ 01:08 PM\"}, {\"date\": \"2/11/2026 @ 01:05 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Sandra on February 12, 2026 at 12:00pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:07 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 02:35 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-no VM \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 02:25 PM\", \"result\": 3, \"comment\": \" called to schedule face to face appt with Jessica D\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/10/2026 @ 02:23 PM\"}, {\"date\": \"2/5/2026 @ 01:47 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA- no vm setup\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 01:47 PM\"}, {\"date\": \"2/4/2026 @ 04:38 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/9/2026 @ 04:36 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000065480\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000065480\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000065480\", \"scheduleDate\": \"2026-2-12T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:38:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}, {\"date\": \"02-19-2026 08:59:29\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-19-2026 08:59:29\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1775814750}', 1, NULL, NULL, 'In Person', '2026-2-12T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1747, NULL, NULL, '17537038', '10000065518', '', '', '94743867', 'Theodate', 'Coughlin', 'English', '', '{\"DOB\": 15039, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1396371282\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"JORDAN, DANIEL\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2EF5QH5HD84\", \"Member_City\": \"Falmouth\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Falmouth\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-03-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1 PARTRIDGE LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04105\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1 PARTRIDGE LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04105\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Coughlin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Theodate\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072090763\", \"Member_Identification_Number\": \"10000065518\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-12-2026 16:21:13\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-12 16:21:13\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T18:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T17:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T14:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T16:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-12T16:21\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-09T12:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-28T11:50\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-28T15:07\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-09T12:57\", \"reportStatus_date\": \"2026-02-09T12:57\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-28T15:07\", \"reportStatus_date\": \"2026-02-28T15:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T16:49\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-12T16:21\", \"reportStatus_date\": \"2026-03-12T16:21\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-09T12:57\", \"username\": null}, {\"date\": \"2026-02-09T12:57\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-02-28T11:50\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-12T16:21\", \"username\": \"KCoash\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-28T15:07\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:24\", \"value\": [{\"add\": \"1 PARTRIDGE LN\", \"age\": 84, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1941-03-04\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072090763\", \"zip\": \"04105\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Falmouth\", \"gend\": 1, \"insh\": \"10000065518\", \"mzip\": \"04105\", \"name\": \"Theodate P Coughlin\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JORDAN, DANIEL\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1 PARTRIDGE LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Falmouth\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1396371282\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2EF5QH5HD84\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-27-2026\", \"time\": \"11:11:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:24\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-12T16:21\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": [{\"date\": \"2026-02-28T15:07\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"member did not present to doxy. I called and left a voicemail. no call back. please contact to try and reschedule. thank you. \", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/14/2026 @ 05:51 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"3/31/2026 @ 05:50 PM\"}, {\"date\": \"3/12/2026 @ 04:21 PM\", \"result\": 9, \"comment\": \"member refused 3/5/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 04:49 PM\", \"result\": 3, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"3/10/2026 @ 04:48 PM\"}, {\"date\": \"2/9/2026 @ 09:57 AM\", \"result\": 0, \"comment\": \"scheduled 2/28/2026 at 12:00 pm w/ Amanda\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 02:30 PM\", \"result\": 3, \"comment\": \"LVM F2F \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 02:29 PM\"}, {\"date\": \"2/5/2026 @ 05:50 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 05:49 PM\"}, {\"date\": \"2/4/2026 @ 05:48 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; Left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 05:47 PM\"}, {\"date\": \"2/3/2026 @ 01:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000065518\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000065518\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000065518\", \"scheduleDate\": \"2026-2-28T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 17:48:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}, {\"date\": \"02-28-2026 15:07:30\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-28-2026 15:07:30\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1774950884}', 1, NULL, NULL, 'Virtual', '2026-2-28T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1748, NULL, NULL, NULL, '10000065538', '', '', '52661009', 'Sandra', 'Macdonald', '', '', '{\"DOB\": 17105, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1437911450\", \"Pcp_Zip\": \"40904135\", \"Program\": \"Medicare\", \"Pcp_City\": \"Wells\", \"Pcp_Name\": \"SCHMIR, CHLOE\", \"Rank_All\": 1, \"PCP_Phone\": \"2076460676\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1P42TM9XT07\", \"Member_City\": \"Kennebunk\", \"Office_Name\": \"WELLS FAMILY PRACTICE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Kennebunk\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-10-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"\\tWells Family Practice,59 Mile Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"48 WARRENS WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04043\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"48 WARRENS WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04043\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Macdonald\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sandra\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"sandeemac46@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\": \"\", \"Member_Identification_Number\": \"10000065538\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076324455\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-04-2026 12:33:06\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-03-04 12:33:06\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T16:18\", \"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-04T14:46\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-02T15:13\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-04T12:33\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-04T14:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T16:18\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T15:13\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-04T12:33\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:26\", \"value\": [{\"add\": \"48 WARRENS WAY\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2076324455\", \"dob\": \"1946-10-30\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076324455\", \"zip\": \"04043\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Kennebunk\", \"gend\": 1, \"insh\": \"10000065538\", \"mzip\": \"04043\", \"name\": \"Sandra L Macdonald\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCHMIR, CHLOE\", \"ppno\": \"2076460676\", \"cliId\": \"\", \"email\": \"sandeemac46@yahoo.com\", \"ename\": \"\", \"madd1\": \"48 WARRENS WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Kennebunk\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\\tWells Family Practice,59 Mile Rd\", \"pcpnpi\": \"1437911450\", \"pcpzip\": \"40904135\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Wells\", \"pcpname\": \"WELLS FAMILY PRACTICE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1P42TM9XT07\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"3/4/2026 @ 12:33 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Shellie but member requested a call back later in year....the daughter feels we are a waste and is mean \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"9/10/2026 @ 12:33 PM\"}, {\"date\": \"3/2/2026 @ 03:13 PM\", \"result\": 6, \"comment\": \"Member requested a call back on Wednesday, when her daughter is home to schedule the assessment.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/4/2026 @ 11:11 AM\"}, {\"date\": \"2/11/2026 @ 04:18 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 04:18 PM\"}, {\"date\": \"2/4/2026 @ 02:46 PM\", \"result\": 6, \"comment\": \"mbr asked for c/b later in the year per Five9 notes 2/2/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"7/1/2026 @ 02:45 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 14:46:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:38:56\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(1749, NULL, NULL, '17537038', '10000065557', '', '', '66650973', 'Kurt', 'Tielinen', '', '', '{\"DOB\": 27757, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1649835224\", \"Pcp_Zip\": \"38674523\", \"Program\": \"Medicare\", \"Pcp_City\": \"ROCHESTER\", \"Pcp_Name\": \"LEE, BRENDA C\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"7QK4VD7AU01\", \"Member_City\": \"Alfred\", \"Office_Name\": \"NASSON HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Alfred\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1975-12-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"16 PEASLEE RD,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"32 AVERY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04002\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"32 AVERY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04002\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Tielinen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kurt\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@081525.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075024887\", \"Member_Identification_Number\": \"10000065557\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"member unable to do virtual\"}', 1, b'0', b'0', '{\"date\": \"04-10-2026 11:34:55\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}', '{\"date\": \"2026-04-10 11:34:56\", \"hrastatus\": \"\", \"reportstatus\": \"F2F Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T13:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-06T11:22\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-16T16:03\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-04-09T11:25\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-03-26T10:34\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2026-04-10T11:34\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-03-17T14:54\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-16T16:39\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-03-26T10:34\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-04-10T11:33\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-09T12:42\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T12:42\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-06T11:22\", \"reportStatus_date\": \"2026-03-06T11:22\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-16T16:39\", \"reportStatus_date\": \"2026-03-16T16:39\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-17T14:54\", \"reportStatus_date\": \"2026-03-17T14:54\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-26T10:34\", \"reportStatus_date\": \"2026-03-26T10:34\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": 3, \"hraStatus_date\": \"2026-04-10T11:33\", \"reportStatus_date\": \"2026-04-10T11:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-03-06T11:22\", \"username\": null}, {\"date\": \"2026-03-06T11:22\", \"username\": \"jsmith\"}, {\"date\": \"2026-03-17T14:54\", \"username\": null}, {\"date\": \"2026-03-17T14:54\", \"username\": \"KCoash\"}, {\"date\": \"2026-04-09T11:25\", \"username\": null}, {\"date\": \"2026-04-09T11:25\", \"username\": \"KAtobatele\"}], \"inProgress\": [{\"date\": \"2026-03-16T16:03\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-16T16:39\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-26T10:34\", \"username\": \"KCoash\"}, {\"date\": \"2026-04-10T11:33\", \"username\": \"KCoash\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:27\", \"value\": [{\"add\": \"32 AVERY RD\", \"age\": 50, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-12-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075024887\", \"zip\": \"04002\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Alfred\", \"gend\": 0, \"insh\": \"10000065557\", \"mzip\": \"04002\", \"name\": \"Kurt E Tielinen\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LEE, BRENDA C\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@081525.com\", \"ename\": \"\", \"madd1\": \"32 AVERY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Alfred\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"16 PEASLEE RD,\", \"pcpnpi\": \"1649835224\", \"pcpzip\": \"38674523\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"ROCHESTER\", \"pcpname\": \"NASSON HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7QK4VD7AU01\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-16-2026\", \"time\": \"12:44:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:27\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-16T16:39\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"provider sent links for doxyme, doximity nd Google meet. member states did not receive any messages. FaceTime would not go through. member agreeable to in person visit \", \"cancelStatus\": \"0\"}, {\"date\": \"2026-03-26T10:34\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 3, \"cancelText\": \"member unable to rcvd txt and has no email - needs F2F Call Back\", \"cancelStatus\": 0}, {\"date\": \"2026-04-10T11:33\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 3, \"cancelText\": \"member unable to do virtual\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 14, \"callLog\": [{\"date\": \"4/10/2026 @ 11:34 AM\", \"result\": 14, \"comment\": \"member can not do virtual appointments - unable to rcv text and does not have email - F2F ONLY - I called to cx the appt but was unable to leave a voicemail\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"4/13/2026 @ 11:34 AM\"}, {\"date\": \"4/9/2026 @ 10:25 AM\", \"result\": 0, \"comment\": \"Scheduled virtual visit with Amanda for APRIL 11. 9AM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 10:34 AM\", \"result\": 14, \"comment\": \"member unable to rcv txt and does not have email - needs F2F Call Back\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/27/2026 @ 10:34 AM\"}, {\"date\": \"3/17/2026 @ 02:54 PM\", \"result\": 12, \"comment\": \"resched w/Amanda 3/26 at 2 virtual\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 11:22 AM\", \"result\": 0, \"comment\": \"scheduled virtual w/ Amanda Milliken 3/16/2026 at 4PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:27 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/5/2026 @ 01:27 PM\"}, {\"date\": \"2/9/2026 @ 12:42 PM\", \"result\": 6, \"comment\": \"member is in rehab, try back 3/1/2026\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/2/2026 @ 12:42 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000065557\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000065557\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000065557\", \"scheduleDate\": \"2026-4-11T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"03-03-2026 13:27:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}, {\"date\": \"03-16-2026 16:39:08\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}, {\"date\": \"03-26-2026 10:34:21\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}, {\"date\": \"04-10-2026 11:33:36\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"04-10-2026 11:33:36\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, 'Virtual', '2026-4-11T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1750, NULL, NULL, NULL, '10000065625', '', '', '1019044', 'Deborah', 'Boyajian', '', '', '{\"DOB\": 19083, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1649239765\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"EMERY, PETER\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5TV0JR5CN25\", \"Member_City\": \"Portland\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Portland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"100 FODEN RD WEST,STE 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"172 FALMOUTH ST UNIT 101\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04102\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"172 FALMOUTH ST UNIT 101\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04102\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Boyajian\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deborah\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"boyajiand@mac.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078316998\", \"Member_Identification_Number\": \"10000065625\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-27-2026 10:25:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-27 10:25:22\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-24T09:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T09:48\", \"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-27T10:25\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-27T10:25\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:29\", \"value\": [{\"add\": \"172 FALMOUTH ST UNIT 101\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-03-30\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078316998\", \"zip\": \"04102\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Portland\", \"gend\": 1, \"insh\": \"10000065625\", \"mzip\": \"04102\", \"name\": \"Deborah E Boyajian\", \"plan\": \"Martin\'s Point\", \"pphy\": \"EMERY, PETER\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"boyajiand@mac.com\", \"ename\": \"\", \"madd1\": \"172 FALMOUTH ST UNIT 101\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Portland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN RD WEST,STE 203\", \"pcpnpi\": \"1649239765\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5TV0JR5CN25\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:59:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:29\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/27/2026 @ 10:25 AM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Sandra but member need a call back prefers to be seen by Jennifer Landry once her appointments become available  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"4/7/2026 @ 10:25 AM\"}, {\"date\": \"2/27/2026 @ 09:48 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 09:48 AM\"}, {\"date\": \"2/24/2026 @ 09:33 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/27/2026 @ 09:32 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-24-2026 09:33:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"02-13-2026 23:35:40\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1775555255}', 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(1751, 71932120, 44829497, '17537038', '10000065717', '', '', '94743867', 'Christopher', 'Neagle', 'English', '', '{\"DOB\": 19074, \"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\": 1720421217, \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"KAREN CUSHING\", \"Rank_All\": 1, \"PCP_Phone\": 2077745816, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2J40XF1GU08\", \"Member_City\": \"Cumberland\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cumberland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"84 Marginal Way Ste 800\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2075238597, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"76 ORCHARD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04021\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"76 ORCHARD RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04021\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Neagle\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Christopher\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"cneagle1952@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2078319508, \"Member_Identification_Number\": \"10000065717\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:07:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:07:43\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T17:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-12T12:07\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-16T15:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-16T18:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-10T17:10\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-12T11:20\", \"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-04T17:51\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-10T17:10\", \"reportStatus_date\": \"2026-02-10T17:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-16T18:42\", \"reportStatus_date\": \"2026-03-16T18:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:07\", \"reportStatus_date\": \"2026-03-17T16:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:07\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-10T17:10\", \"username\": null}, {\"date\": \"2026-02-10T17:10\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-03-12T11:20\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:56\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-12T12:07\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-12T12:07\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-16T13:34\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-16T13:37\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-16T13:40\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-16T14:05\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-16T18:42\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-16T15:46\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-16T18:42\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-16T13:40\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"16:17:27\", \"value\": [{\"add\": \"76 ORCHARD RD\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-03-21\", \"eno\": \"3478716157\", \"lob\": \"GA - 2026\", \"pno\": 2078319508, \"zip\": \"04021\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Cumberland\", \"gend\": 0, \"insh\": \"10000065717\", \"mzip\": \"04021\", \"name\": \"Christopher S Neagle\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KAREN CUSHING\", \"ppno\": 2077745816, \"cliId\": \"\", \"email\": \"cneagle1952@gmail.com\", \"ename\": \"Son Scott\", \"madd1\": \"76 ORCHARD RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cumberland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"84 Marginal Way Ste 800\", \"pcpnpi\": 1720421217, \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2075238597, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2J40XF1GU08\", \"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-10-2026\", \"time\": \"17:41:48\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 16:17:27\"}', NULL, NULL, '{\"memberId\": \"10000065717\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Mon, 16 Mar 2026 17:40:01 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1. In the assessment of diagnosis neuro psych section, depression was supported by medication. However, there was no medications noted on the med list for depression diagnosis. Escitalopram is noted for anxiety. Is the member also taking it for depression? if so, please add depression diagnosis to Escitalopram in addition to anxiety diagnosis.\\n2. The member is on Escitalopram for anxiety. However, the condition was not addressed in the assessment of diagnosis neuro psych section. Is this an active ongoing condition?\\n\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 16 Mar 2026 18:05:06 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Manoucheca, \\n\\nThe escitalopram is for both anxiety and depression. I have made the corrections. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Christopher Neagle\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/12/2026 11:15 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/10/2026 @ 05:10 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 12, 2026 at 11:15am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/4/2026 @ 04:51 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; Left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 04:50 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000065717\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000065717\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000065717\", \"scheduleDate\": \"2026-3-12T11:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:51:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-10-2026 17:10:05\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:07:41\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"f47c602f-f65b-42b3-a523-29278988fe85\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"f47c602f-f65b-42b3-a523-29278988fe85\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"8555764814\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:12:57.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\\\":286,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":286,\\\"start_timestamp\\\":\\\"2026-03-17T20:07:51.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:12:57.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-12T11:15', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:17', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065717\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Neagle_10000065717_03122026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:07:40\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000065717.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Neagle_10000065717_03122026.pdf', NULL, 'Summary_10000065717.pdf', NULL, '[{\"date\": \"2026-03-12T16:07:23.523Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-16T18:05:06.631Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-12T11:49', 'Member_Summary_10000065717.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065717\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000065717.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:07:42\"}', 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
(1752, 71932120, 44829497, '31048908', '10000065727', '', '', NULL, 'Susan', 'Gefvert', 'English', '', '{\"DOB\": 16239, \"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\": \"1205190220\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"KIMBERLY DEKKER\", \"Rank_All\": 1, \"PCP_Phone\": \"2073303950\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3MQ1FF1MU96\", \"Member_City\": \"CUMBERLAND FORESIDE\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CUMBERLAND FORESIDE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-06-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2073303955\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"4 HALLMARK RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04110\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4 HALLMARK RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04110\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gefvert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Susan\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"sgefver1@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\": \"2077126850\", \"Member_Identification_Number\": \"10000065727\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:25:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:25:14\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-14T15:51\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T17:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T18:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-03T06:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-14T09:39\", \"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-03T06:09\", \"reportStatus_date\": \"2026-02-03T06:09\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-14T15:51\", \"reportStatus_date\": \"2026-02-14T15:51\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T18:05\", \"reportStatus_date\": \"2026-02-17T18:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:25\", \"reportStatus_date\": \"2026-03-03T17:25\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:25\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-03T06:09\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-14T09:39\", \"username\": \"NMattison\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:26\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-14T15:51\", \"username\": \"NMattison\"}, {\"date\": \"2026-02-14T15:51\", \"username\": \"NMattison\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T18:05\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T17:24\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T18:05\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-18-2026\", \"time\": \"15:59:00\", \"value\": [{\"add\": \"4 HALLMARK RD\", \"age\": 81, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1944-06-16\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2077126850\", \"zip\": \"04110\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CUMBERLAND FORESIDE\", \"gend\": 1, \"insh\": \"10000065727\", \"mzip\": \"04110\", \"name\": \"Susan E Gefvert\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KIMBERLY DEKKER\", \"ppno\": \"2073303950\", \"cliId\": \"\", \"email\": \"sgefver1@gmail.com\", \"ename\": \"\", \"madd1\": \"4 HALLMARK RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CUMBERLAND FORESIDE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 Foden Rd Ste 203\", \"pcpnpi\": \"1205190220\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073303955\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3MQ1FF1MU96\", \"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\": \"11:31:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-18-2026 15:59:00\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000065727, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"31048908\", \"memberId\": 10000065727}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"31048908\", \"memberId\": 10000065727, \"scheduleDate\": \"2026-02-14T10:00:00.000\"}}', NULL, '{\"date\": \"01-31-2026 23:38:58\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, '[{\"date\": \"2026-03-03 17:25:13\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"69f49452-ba41-4ea5-9a23-2aa86c1969e9\\\",\\\"destination_fax_number\\\":\\\"12073303955\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"69f49452-ba41-4ea5-9a23-2aa86c1969e9\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12073303955\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:30:41.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\\\":282,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":282,\\\"start_timestamp\\\":\\\"2026-03-03T22:25:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:30:41.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-14T10:00:00.000', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:59:17', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065727\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Gefvert_10000065727_02142026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:25:12\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000065727.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Gefvert_10000065727_02142026.pdf', NULL, 'Summary_10000065727.pdf', NULL, '[{\"date\": \"2026-02-14T20:51:45.386Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-14T10:33', 'Member_Summary_10000065727.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000065727\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000065727.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:25:13\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
