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
(1643, NULL, NULL, NULL, '10000060874', '', '', '47262451', 'Linda', 'Houle', 'English', '', '{\"DOB\": 19535, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1619518719\", \"Pcp_Zip\": \"42407027\", \"Program\": \"Medicare\", \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"FACENDOLA, WARREN\", \"Rank_All\": 1, \"PCP_Phone\": \"2077955700\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1GD2CH4RE14\", \"Member_City\": \"LEWISTON\", \"Office_Name\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LEWISTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-06-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"ADULT NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Central Maine Internal Medicine,12 High St Ste 400\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"211 Randall RD APT 34\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04240\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"211 Randall RD APT 34\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04240\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Houle\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Linda\", \"Member_Middle_name\": \"G\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@02282023.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076893905\", \"Member_Identification_Number\": \"10000060874\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-26-2026 19:05:59\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-26 19:05:59\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T16:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-02-17T16:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-02-24T16:19\", \"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:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T18:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T16:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-26T19:05\", \"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-09T18:04\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T16:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-17T16:09\", \"reportStatus_date\": \"2026-02-17T16:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-24T16:19\", \"reportStatus_date\": \"2026-02-24T16:19\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-26T19:05\", \"reportStatus_date\": \"2026-03-26T19:05\"}]', '{\"utc\": [{\"date\": \"2026-02-17T16:09\", \"username\": \"KCoash\"}, {\"date\": \"2026-02-24T16:19\", \"username\": \"JCopeland\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-26T19:05\", \"username\": \"JDingle\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:40\", \"value\": [{\"add\": \"211 Randall RD APT 34\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-06-25\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076893905\", \"zip\": \"04240\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LEWISTON\", \"gend\": 1, \"insh\": \"10000060874\", \"mzip\": \"04240\", \"name\": \"Linda G Houle\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FACENDOLA, WARREN\", \"ppno\": \"2077955700\", \"cliId\": \"\", \"email\": \"declined@02282023.com\", \"ename\": \"\", \"madd1\": \"211 Randall RD APT 34\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LEWISTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Central Maine Internal Medicine,12 High St Ste 400\", \"pcpnpi\": \"1619518719\", \"pcpzip\": \"42407027\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Lewiston\", \"pcpname\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1GD2CH4RE14\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:40\"}', '{\"utc\": [{\"date\": \"2026-02-17T16:09\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-02-24T16:19\", \"type\": null, \"subStaus\": \"\", \"username\": \"JCopeland\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-26T19:05\", \"type\": null, \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/26/2026 @ 07:05 PM\", \"result\": 9, \"comment\": \"Member declined scheduling due to ongoing medical issues. Member. Advised calling back.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 05:24 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:18 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 01:42 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 03:58 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 10:24 AM\", \"result\": 3, \"comment\": \"called to schedule with sandra cadwell f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 04:19 PM\", \"result\": 6, \"comment\": \"02/24/2026- F2F HRA WITH Sandra Cadwell, MRB NOT THERE \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 07:16 PM\", \"result\": 3, \"comment\": \"02/23/2026- F2F HRA WITH Sandra Cadwell,  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 11:43 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 01:53 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 04:09 PM\", \"result\": 6, \"comment\": \"o/c to sched IHA w/Sandy 3/2\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 12:13 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell; LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 03:10 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell; LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:01 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 05:04 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 05:04 PM\"}, {\"date\": \"2/6/2026 @ 01:04 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA- Left Voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/9/2026 @ 01:04 PM\"}, {\"date\": \"2/4/2026 @ 04:45 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/6/2026 @ 04: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 16:45:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-11-2026 16:10:55\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 19}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1644, NULL, NULL, NULL, '10000060929', '', '', '66650973', 'Gerard', 'Lamontagne', '', '', '{\"DOB\": 19569, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1730110586\", \"Pcp_Zip\": \"04062\", \"Program\": \"Medicare\", \"Pcp_City\": \"Windham\", \"Pcp_Name\": \"PALUSO, EUGENE P\", \"Rank_All\": 1, \"PCP_Phone\": \"2078923233\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3Q30GR2QC43\", \"Member_City\": \"STANDISH\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE AND PED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"STANDISH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-07-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"MMP Lakes Region Primary,584 Roosevelt Trl Unit 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078930752\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"51 ISAIAH DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04084\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"51 ISAIAH DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04084\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Lamontagne\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gerard\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"oldjer@fairpoint.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076425620\", \"Member_Identification_Number\": \"10000060929\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 16:52:22\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-03 16:52:22\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T12:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-03T16:52\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-06T18:02\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T18:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T12:58\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-03T16:52\", \"reportStatus_date\": \"2026-03-03T16:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-03T16:52\", \"username\": \"KCoash\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:42\", \"value\": [{\"add\": \"51 ISAIAH DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-07-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076425620\", \"zip\": \"04084\", \"add2\": \"\", \"add3\": \"\", \"city\": \"STANDISH\", \"gend\": 0, \"insh\": \"10000060929\", \"mzip\": \"04084\", \"name\": \"Gerard P Lamontagne\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PALUSO, EUGENE P\", \"ppno\": \"2078923233\", \"cliId\": \"\", \"email\": \"oldjer@fairpoint.net\", \"ename\": \"\", \"madd1\": \"51 ISAIAH DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"STANDISH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"MMP Lakes Region Primary,584 Roosevelt Trl Unit 1\", \"pcpnpi\": \"1730110586\", \"pcpzip\": \"04062\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Windham\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE AND PED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078930752\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3Q30GR2QC43\", \"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:58:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:42\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-03T16:52\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/3/2026 @ 04:52 PM\", \"result\": 9, \"comment\": \"o/c to sched F2F w/Sandy 3/9 - member stated not happening bye now and hung up\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 12:58 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/3/2026 @ 12:58 PM\"}, {\"date\": \"2/6/2026 @ 06:02 PM\", \"result\": 6, \"comment\": \"Member is currently in the hospital and requested a call back in a couple of weeks.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/23/2026 @ 12:00 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-06-2026 18:02:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"01-31-2026 23:38:22\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1645, NULL, NULL, NULL, '10000060985', '', '', '52661009', 'John', 'Deschene', '', '', '{\"DOB\": 18144, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1871023127\", \"Pcp_Zip\": \"41013637\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"DECKER, CHRISTOPHER C\", \"Rank_All\": 1, \"PCP_Phone\": \"2077958475\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8NG4Y35NT08\", \"Member_City\": \"LITCHFIELD\", \"Office_Name\": \"MINOT AVENUE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LITCHFIELD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-09-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"272 CONGRESS ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2077958490\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"412 RICHMOND RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04350\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"412 RICHMOND RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04350\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Deschene\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"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\": \"2072684550\", \"Member_Identification_Number\": \"10000060985\", \"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 10:52:42\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-13 10:52:42\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-13T10:52\", \"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-05T14:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T16:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T10:52\", \"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-06T10:20\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-09T16:24\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-16T01:26\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T16:24\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T16:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-13T10:52\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:46\", \"value\": [{\"add\": \"412 RICHMOND RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-09-03\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072684550\", \"zip\": \"04350\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LITCHFIELD\", \"gend\": 0, \"insh\": \"10000060985\", \"mzip\": \"04350\", \"name\": \"John A Deschene\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DECKER, CHRISTOPHER C\", \"ppno\": \"2077958475\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"412 RICHMOND RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LITCHFIELD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"272 CONGRESS ST,\", \"pcpnpi\": \"1871023127\", \"pcpzip\": \"41013637\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MINOT AVENUE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077958490\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8NG4Y35NT08\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:46\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:09 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 12:21 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:21 AM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 01:25 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 10:52 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 04:08 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 04:24 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Amanda but member requested a call back member was outside \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 10:20 AM\", \"result\": 6, \"comment\": \"calling to sched virtual IHA w/Amanda M - mbr unavailable\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 10:20 AM\"}, {\"date\": \"2/5/2026 @ 02:32 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/6/2026 @ 02:31 PM\"}, {\"date\": \"2/3/2026 @ 11:49 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-05-2026 14:32:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-13-2026 10:52:42\", \"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:58:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1646, NULL, NULL, NULL, '10000061023', '', '', '1019044', 'James', 'Byrne', '', '', '{\"DOB\": 21089, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1265793574\", \"Pcp_Zip\": \"40861747\", \"Program\": \"Medicare\", \"Pcp_City\": \"TOPSHAM\", \"Pcp_Name\": \"LIEGNER, ADAM\", \"Rank_All\": 1, \"PCP_Phone\": \"2075826608\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7PQ8FN5GE54\", \"Member_City\": \"Winslow\", \"Office_Name\": \"GARDINER FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winslow\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1957-09-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"4 HORTON PL,SUITE 101\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2075822258\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"295 GARLAND RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"295 GARLAND RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Byrne\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jbyrne207@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\": \"2076494396\", \"Member_Identification_Number\": \"10000061023\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-13-2026 11:15:47\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}', '{\"date\": \"2026-02-13 11:15:48\", \"hrastatus\": \"\", \"reportstatus\": \"Ineligible\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-02-13T11:15\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:20\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-02-13T11:15\", \"reportStatus_date\": \"2026-02-13T11:15\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-02-13T11:15\", \"username\": \"FBeckford\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:47\", \"value\": [{\"add\": \"295 GARLAND RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1957-09-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076494396\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Winslow\", \"gend\": 0, \"insh\": \"10000061023\", \"mzip\": \"04901\", \"name\": \"James A Byrne\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LIEGNER, ADAM\", \"ppno\": \"2075826608\", \"cliId\": \"\", \"email\": \"jbyrne207@gmail.com\", \"ename\": \"\", \"madd1\": \"295 GARLAND RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winslow\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"4 HORTON PL,SUITE 101\", \"pcpnpi\": \"1265793574\", \"pcpzip\": \"40861747\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"TOPSHAM\", \"pcpname\": \"GARDINER FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075822258\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7PQ8FN5GE54\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:47\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"2/13/2026 @ 11:15 AM\", \"result\": 2, \"comment\": \"Called to Schedule Virtual HRA with Amanda but member is ineligible. *Member stated he is already scheduled with martins point home visit\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-13-2026 11:15:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"01-31-2026 23:38:22\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(1647, 55499828, 44829497, '39698290', '10000061140', '', '', '52197563', 'Claudia', 'Pandora', 'English', '', '{\"DOB\": 14670, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": \"1659876571\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"SCOTT CATHCART\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4N93E80AA08\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-02-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"84 Marginal Way Ste 700\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"830 OCEAN AVE UNIT 336\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"830 OCEAN AVE UNIT 336\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Pandora\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Claudia\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"declined@12022024.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2077976542\", \"Member_Identification_Number\": \"10000061140\", \"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:24:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:24:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T17:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T12:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-15T20:28\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T07:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T09:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-11T14:23\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-11T14:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-12T15:13\", \"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-09T14:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-15T20:28\", \"reportStatus_date\": \"2026-02-15T20:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T09:50\", \"reportStatus_date\": \"2026-02-19T09:50\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:24\", \"reportStatus_date\": \"2026-03-03T17:24\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:24\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-11T14:23\", \"username\": null}, {\"date\": \"2026-02-11T14:23\", \"username\": \"cwasilak\"}, {\"date\": \"2026-02-11T14:24\", \"username\": null}, {\"date\": \"2026-02-11T14:24\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-02-12T15:13\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T15:25\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-15T20:28\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-15T20:28\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-18T16:09\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T09:50\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T07:15\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T09:50\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-18T09:46\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-18-2026\", \"time\": \"15:45:51\", \"value\": [{\"add\": \"830 OCEAN AVE UNIT 336\", \"age\": 86, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-02-29\", \"eno\": \"2076517128\", \"lob\": \"GA - 2026\", \"pno\": \"2077976542\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 1, \"insh\": \"10000061140\", \"mzip\": \"04103\", \"name\": \"Claudia B Pandora\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCOTT CATHCART\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"declined@12022024.com\", \"ename\": \"Stephanie Pandora\", \"madd1\": \"830 OCEAN AVE UNIT 336\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"84 Marginal Way Ste 700\", \"pcpnpi\": \"1659876571\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4N93E80AA08\", \"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\": \"10:05:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-18-2026 15:45:51\"}', NULL, NULL, '{\"memberId\": \"10000061140\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Wed, 18 Feb 2026 14:46:36 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\n1 Vertigo mentioned in the medication list for her taking medication PRN for it, can you add vertigo in the EARS section\\n2) CKD mentioned on the med list, can you add to the GU or ENDOCRINE section depending if its related to DM or not \\nthanks! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 18 Feb 2026 21:09:28 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I added Vertigo and CKD .  Thank You!\"}, \"mailId\": \"\"}], \"memberName\": \"Claudia Pandora\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/12/2026 03:00 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/11/2026 @ 02:24 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Sandra on February 12, 2026 at 3:00pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 02:23 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Sandra on February 12, 2026 at 3:00pm  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 12:52 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 02:04 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/10/2026 @ 02:03 PM\"}, {\"date\": \"2/6/2026 @ 02:18 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:17 PM\"}, {\"date\": \"2/4/2026 @ 04:23 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:22 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\": \"10000061140\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000061140\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000061140\", \"scheduleDate\": \"2026-2-12T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:23:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-11-2026 14:24:39\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:24:45\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"c8277477-174f-11f1-b913-496b7980185b\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-2-12T15:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:41', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061140\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Pandora_10000061140_02122026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:24:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000061140.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Pandora_10000061140_02122026.pdf', NULL, 'Summary_10000061140.pdf', NULL, '[{\"date\": \"2026-02-16T01:28:24.347Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-18T21:09:28.483Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-12T16:31', 'Member_Summary_10000061140.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061140\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000061140.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:24:46\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(1648, NULL, NULL, NULL, '10000061158', '', '', NULL, 'Edward', 'Molleo', 'English', '', '{\"DOB\": 18517, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1114308277\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"RIDDLEBERGER, JAMES M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5QE6CF7AN82\", \"Member_City\": \"GRAY\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GRAY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-09-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"46 YARMOUTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 818\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Molleo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Edward\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"EMOLLEO1@MAINE.RR.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076500112\", \"Member_Identification_Number\": \"10000061158\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:22:47\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:47\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:22\", \"reportStatus_date\": \"2026-02-03T06:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:54\", \"value\": [{\"add\": \"46 YARMOUTH RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-09-11\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076500112\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GRAY\", \"gend\": 0, \"insh\": \"10000061158\", \"mzip\": \"04039\", \"name\": \"Edward F Molleo\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RIDDLEBERGER, JAMES M\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"EMOLLEO1@MAINE.RR.COM\", \"ename\": \"\", \"madd1\": \"PO BOX 818\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GRAY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1114308277\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5QE6CF7AN82\", \"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:58:41\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:54\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:38:23\", \"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:58:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1649, NULL, NULL, NULL, '10000061177', '', '', '1019044', 'Paul', 'Beote', '', '', '{\"DOB\": 17383, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1720421217\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"HEARD CUSHING, KAREN S\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3HR1DH0EF96\", \"Member_City\": \"PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-08-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"InterMed,84 Marginal Way Ste 800\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238597\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"30 RICHARDSON ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"30 RICHARDSON ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Beote\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Paul\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gbeote@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\": \"2077731085\", \"Member_Identification_Number\": \"10000061177\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-10-2026 13:00:29\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-10 13:00:29\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-10T13:00\", \"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-03T06:20\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-10T13:00\", \"reportStatus_date\": \"2026-02-10T13:00\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-10T13:00\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:55\", \"value\": [{\"add\": \"30 RICHARDSON ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-08-04\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077731085\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 0, \"insh\": \"10000061177\", \"mzip\": \"04103\", \"name\": \"Paul R Beote\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HEARD CUSHING, KAREN S\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"gbeote@aol.com\", \"ename\": \"\", \"madd1\": \"30 RICHARDSON ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,84 Marginal Way Ste 800\", \"pcpnpi\": \"1720421217\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238597\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3HR1DH0EF96\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:41\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:55\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-10T13:00\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/10/2026 @ 01:00 PM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Amanda but member refused.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 13:00:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"01-31-2026 23:38:23\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1650, NULL, NULL, NULL, '10000061203', '', '', '14035267', 'Doris', 'Pickrell', '', '', '{\"DOB\": 19527, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1417269242\", \"Pcp_Zip\": \"04930\", \"Program\": \"Medicare\", \"Pcp_City\": \"Dexter\", \"Pcp_Name\": \"TOWNE, LORI M\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2RT1CJ4PA13\", \"Member_City\": \"CORINNA\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE DOVER FOXCROFT\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CORINNA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-06-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Northern Light Primary Care Dover Foxcroft,891 W Main St Ste 200\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079245992\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"589 CORINNA CENTER ROAD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04928\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"589 CORINNA CENTER ROAD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04928\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Pickrell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Doris\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"doris.pickrell@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2079245956\", \"Member_Identification_Number\": \"10000061203\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-03-2026 12:33:26\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-04-03 12:33:26\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-04-03T12:33\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-04T16:55\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-06T10:46\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T10:46\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-04-03T12:33\", \"reportStatus_date\": \"2026-04-03T12:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-04-03T12:33\", \"username\": \"AChevalier\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:57\", \"value\": [{\"add\": \"589 CORINNA CENTER ROAD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-06-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2079245956\", \"zip\": \"04928\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CORINNA\", \"gend\": 1, \"insh\": \"10000061203\", \"mzip\": \"04928\", \"name\": \"Doris M Pickrell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TOWNE, LORI M\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"doris.pickrell@gmail.com\", \"ename\": \"\", \"madd1\": \"589 CORINNA CENTER ROAD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CORINNA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Northern Light Primary Care Dover Foxcroft,891 W Main St Ste 200\", \"pcpnpi\": \"1417269242\", \"pcpzip\": \"04930\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Dexter\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE DOVER FOXCROFT\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079245992\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2RT1CJ4PA13\", \"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:58:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:57\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-04-03T12:33\", \"type\": null, \"subStaus\": \"\", \"username\": \"AChevalier\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/3/2026 @ 12:33 PM\", \"result\": 9, \"comment\": \"does not want to participate\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 10:45 AM\", \"result\": 6, \"comment\": \"Called to schedule IHA w/ martins point -member cant scheduled at this time wants call back later in 20206 april \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"4/1/2026 @ 10:45 AM\"}, {\"date\": \"2/4/2026 @ 01:55 PM\", \"result\": 6, \"comment\": \" called to schedule face to face , no answer callback \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 01:54 PM\"}, {\"date\": \"1/23/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 13:55:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"01-31-2026 23:38:23\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:42', 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
(1651, 55499828, 44829497, '22140773', '10000061287', '', '', '24168610', 'Deborah', 'Goering', 'English', '', '{\"DOB\": 19616, \"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\": 1164782819, \"Pcp_Zip\": \"42407649\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"GREENLEAF, REBECCA\", \"Rank_All\": 1, \"PCP_Phone\": 2077952800, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6VC1XG1DY99\", \"Member_City\": \"BOWDOINHAM\", \"Office_Name\": \"TOPSHAM FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BOWDOINHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-09-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"76 HIGH ST FL 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": 2077952808, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1147 POST RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04008\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1147 POST RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04008\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Goering\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deborah\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"declined@120524.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\": 2077510795, \"Member_Identification_Number\": \"10000061287\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 15:04:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 15:04:20\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T15:57\", \"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-09T19:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T15:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T18:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T15:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-17T16:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-17T15:14\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-21T17:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-22T23:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T15:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-12T14:03\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-16T07:43\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T19:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T18:32\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T15:57\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-03-16T07:43\", \"reportStatus_date\": \"2026-03-16T07:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-22T23:01\", \"reportStatus_date\": \"2026-03-22T23:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T15:04\", \"reportStatus_date\": \"2026-03-24T15:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T15:04\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-12T14:03\", \"username\": null}, {\"date\": \"2026-03-12T14:03\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-03-16T07:43\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-03-17T16:09\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-03-17T15:14\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-17T15:14\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-20T17:59\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-22T23:01\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-21T17:56\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-22T23:01\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-20T17:35\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"14:49:28\", \"value\": [{\"add\": \"1147 POST RD\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-09-14\", \"eno\": \"5187964611\", \"lob\": \"GA - 2026\", \"pno\": 2077510795, \"zip\": \"04008\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BOWDOINHAM\", \"gend\": 1, \"insh\": \"10000061287\", \"mzip\": \"04008\", \"name\": \"Deborah J Goering\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GREENLEAF, REBECCA\", \"ppno\": 2077952800, \"race\": \"\", \"cliId\": \"\", \"email\": \"declined@120524.com\", \"ename\": \"Cammy Goering - sister-in-law\", \"madd1\": \"1147 POST RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BOWDOINHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 HIGH ST FL 1\", \"pcpnpi\": 1164782819, \"pcpzip\": \"42407649\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"TOPSHAM FAMILY MEDICINE\", \"program\": \"Medicare\", \"evalDate\": \"2026-3-16 03:00 AM\", \"evalName\": \"Erin Barker, FNP\", \"pcpfaxno\": 2077952808, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Androscoggin\", \"medicaidid\": \"\", \"medicareid\": \"6VC1XG1DY99\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"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-16-2026\", \"time\": \"07:43:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 12:21:20\"}', NULL, NULL, '{\"memberId\": \"10000061287\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 20 Mar 2026 21:35:01 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Erin,\\n1) Under the neuro section can you select yes or no\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Mar 2026 21:59:40 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Deborah Goering\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/16/2026 03:00 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/12/2026 @ 02:03 PM\", \"result\": 0, \"comment\": \"sched virt w/Erin 3/16 at 3\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 03:59 PM\", \"result\": 13, \"comment\": \"03/06/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER, MRB COULDNT HEAR ME \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 03:57 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 06:32 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 03:06 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 @ 03:05 PM\"}, {\"date\": \"2/10/2026 @ 11:15 AM\", \"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 @ 11:13 AM\"}, {\"date\": \"2/9/2026 @ 07:24 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 @ 07:24 PM\"}, {\"date\": \"2/3/2026 @ 07:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"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\": \"10000061287\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": \"10000061287\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": \"10000061287\", \"scheduleDate\": \"2026-3-16T03:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 19:24:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"03-12-2026 14:03:12\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 15:04:18\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"d81c25ac-9853-4d84-8c14-50c718087159\\\",\\\"destination_fax_number\\\":\\\"12077952808\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"d81c25ac-9853-4d84-8c14-50c718087159\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12077952808\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:10:14.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\\\":325,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":325,\\\"start_timestamp\\\":\\\"2026-03-24T19:04:31.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:10:14.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-16T03:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:42', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061287\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Goering_10000061287_03162026.pdf\", \"ftp_upload_date\": \"2026-03-24 15:04:17\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000061287.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Goering_10000061287_03162026.pdf', NULL, 'Summary_10000061287.pdf', NULL, '[{\"date\": \"2026-03-17T19:14:43.418Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-20T21:59:40.401Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-16T16:12', 'Member_Summary_10000061287.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061287\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000061287.pdf\", \"member_ftp_upload_date\": \"2026-03-24 15:04:20\"}', 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
(1652, NULL, NULL, NULL, '10000061341', '', '', '543416', 'Janelle', 'Kitchen Siebert', 'English', '', '{\"DOB\": 19599, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1457456733\", \"Pcp_Zip\": \"04412\", \"Program\": \"Medicare\", \"Pcp_City\": \"Brewer\", \"Pcp_Name\": \"MAMULA, MEGHAN R\", \"Rank_All\": 1, \"PCP_Phone\": \"2079891567\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1QD8U55KX39\", \"Member_City\": \"STOCKTON SPRINGS\", \"Office_Name\": \"BREWER MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"STOCKTON SPRINGS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-08-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Brewer Medical Center,735 Wilson St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Waldo\", \"Member_Country\": \"Waldo\", \"PCP_Fax_Number\": \"2079470435\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"342 CAPE JELLISON RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04981\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"342 CAPE JELLISON RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04981\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Kitchen Siebert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Janelle\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Jkitchensiebert@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076694937\", \"Member_Identification_Number\": \"10000061341\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-10-2026 12:28:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-10 12:28:07\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-10T12:28\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T16:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T13:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T18:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T12:28\", \"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:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T12:28\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:01\", \"value\": [{\"add\": \"342 CAPE JELLISON RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-08-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076694937\", \"zip\": \"04981\", \"add2\": \"\", \"add3\": \"\", \"city\": \"STOCKTON SPRINGS\", \"gend\": 1, \"insh\": \"10000061341\", \"mzip\": \"04981\", \"name\": \"Janelle Kitchen Siebert\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MAMULA, MEGHAN R\", \"ppno\": \"2079891567\", \"cliId\": \"\", \"email\": \"Jkitchensiebert@icloud.com\", \"ename\": \"\", \"madd1\": \"342 CAPE JELLISON RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"STOCKTON SPRINGS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Brewer Medical Center,735 Wilson St\", \"pcpnpi\": \"1457456733\", \"pcpzip\": \"04412\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Brewer\", \"pcpname\": \"BREWER MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079470435\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1QD8U55KX39\", \"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:58:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/26/2026 @ 02:40 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin on 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:24 AM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 03:27 PM\", \"result\": 3, \"comment\": \"03/18/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 10:00 AM\", \"result\": 3, \"comment\": \"called to schedule virtual with Amanda millikin\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 03:30 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 @ 07:17 PM\", \"result\": 3, \"comment\": \"03/05/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 09:40 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 06:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:28 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 12:44 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 01:06 PM\", \"result\": 3, \"comment\": \"02/05/2026- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/18/2026 @ 01:03 PM\"}, {\"date\": \"2/4/2026 @ 04:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/9/2026 @ 04:01 PM\"}, {\"date\": \"2/3/2026 @ 02:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:01:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"02-10-2026 12:28:07\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 14}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1653, NULL, NULL, NULL, '10000061353', '', '', '14035267', 'Shaun', 'Kieran', 'English', '', '{\"DOB\": 17486, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1114308277\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"RIDDLEBERGER, JAMES M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2GE5AK1PM61\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-11-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"41 BOOTHBY AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"41 BOOTHBY AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Kieran\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shaun\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"SHAUNK41@GMAIL.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077672574\", \"Member_Identification_Number\": \"10000061353\", \"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 17:08:29\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-05 17:08:29\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T17:08\", \"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-11T13:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T16:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T11:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T12:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T17:08\", \"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-16T01:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T12:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T17:08\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:02\", \"value\": [{\"add\": \"41 BOOTHBY AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-11-15\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077672574\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000061353\", \"mzip\": \"04106\", \"name\": \"Shaun S Kieran\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RIDDLEBERGER, JAMES M\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"SHAUNK41@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"41 BOOTHBY AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1114308277\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2GE5AK1PM61\", \"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:58:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:02\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/23/2026 @ 05:02 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandra 4/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 01:27 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer No VM Setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 02:31 PM\", \"result\": 1, \"comment\": \"Called to Schedule F2F HRA with Elizabeth, dead air.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 05:08 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/24/2026 @ 12:11 PM\", \"result\": 3, \"comment\": \"LVM F2F \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 08:16 AM\", \"result\": 1, \"comment\": \"called to schedule face to face w/ Shellie H, dead air\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 04:15 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/19/2026 @ 04:15 PM\"}, {\"date\": \"2/11/2026 @ 10:55 AM\", \"result\": 3, \"comment\": \" called to schedule face to face \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 10:55 AM\"}, {\"date\": \"2/3/2026 @ 05:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-11-2026 10:55:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"03-05-2026 17:08:29\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1654, NULL, NULL, NULL, '10000061414', '', '', '14035267', 'Kathleen', 'Kulick', 'English', '', '{\"DOB\": 16640, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1235220740\", \"Pcp_Zip\": \"40112092\", \"Program\": \"Medicare\", \"Pcp_City\": \"BRUNSWICK\", \"Pcp_Name\": \"MACDONALD, MICHAEL C\", \"Rank_All\": 1, \"PCP_Phone\": \"2073736848\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8F27MK2EC52\", \"Member_City\": \"HARTLAND\", \"Office_Name\": \"HOMETOWN HEALTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"HARTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-07-22\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"22 STATION AVE,SUITE 101\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Somerset\", \"Member_Country\": \"Somerset\", \"PCP_Fax_Number\": \"2073736849\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"157 HELENS LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04943\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 472\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04943\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Kulick\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kathleen\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Kulickkathleen@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"6035052493\", \"Member_Identification_Number\": \"10000061414\", \"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 17:44:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-05 17:44:05\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T17:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T13:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T17:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T16:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T17: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\": [{\"date\": \"2026-02-05T11:36\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T11:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T17:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T16:17\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T17:44\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:04\", \"value\": [{\"add\": \"157 HELENS LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-07-22\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"6035052493\", \"zip\": \"04943\", \"add2\": \"\", \"add3\": \"\", \"city\": \"HARTLAND\", \"gend\": 1, \"insh\": \"10000061414\", \"mzip\": \"04943\", \"name\": \"Kathleen M Kulick\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MACDONALD, MICHAEL C\", \"ppno\": \"2073736848\", \"cliId\": \"\", \"email\": \"Kulickkathleen@yahoo.com\", \"ename\": \"\", \"madd1\": \"PO BOX 472\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"HARTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"22 STATION AVE,SUITE 101\", \"pcpnpi\": \"1235220740\", \"pcpzip\": \"40112092\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BRUNSWICK\", \"pcpname\": \"HOMETOWN HEALTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073736849\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8F27MK2EC52\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 12:20 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/2/2026 @ 04:36 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 4/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 04:25 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin on 4/8\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:29 AM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 11:44 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 09:52 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 05:44 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 04:17 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA w/Jennifer Winslow.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 05:56 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/16/2026 @ 05:55 PM\"}, {\"date\": \"2/11/2026 @ 01:31 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/18/2026 @ 01:30 PM\"}, {\"date\": \"2/5/2026 @ 08:36 AM\", \"result\": 6, \"comment\": \"called to schedule IHA . member was on the way to the doctor adv will callback \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/10/2026 @ 08:36 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 08:36:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"03-05-2026 17:44:05\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1655, NULL, NULL, NULL, '10000061459', '', '', '52197563', 'Mary', 'Chick', '', '', '{\"DOB\": 17813, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"\", \"Program\": \"Medicare\", \"Pcp_City\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Medicare_ID\": \"4AR8JA6UJ68\", \"Member_City\": \"PORTLAND\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-10-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"86 ASHLEY LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"86 ASHLEY LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Chick\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mary\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Marychick75@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\": \"2072337630\", \"Member_Identification_Number\": \"10000061459\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 12:03:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-10 12:03:39\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-23T17:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-10T12:03\", \"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:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T17:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T12:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T17:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T14:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T12:14\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T17:14\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-10T12:03\", \"reportStatus_date\": \"2026-03-10T12:03\"}]', '{\"utc\": [{\"date\": \"2026-03-10T12:03\", \"username\": \"jsmith\"}], \"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:13:06\", \"value\": [{\"add\": \"86 ASHLEY LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-10-07\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072337630\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PORTLAND\", \"gend\": 1, \"insh\": \"10000061459\", \"mzip\": \"04103\", \"name\": \"Mary L Chick\", \"plan\": \"Martin\'s Point\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Marychick75@gmail.com\", \"ename\": \"\", \"madd1\": \"86 ASHLEY LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4AR8JA6UJ68\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:06\"}', '{\"utc\": [{\"date\": \"2026-03-10T12:03\", \"type\": null, \"subStaus\": \"\", \"username\": \"jsmith\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/10/2026 @ 12:03 PM\", \"result\": 6, \"comment\": \"inbound call- member is going through cancer treatment at the moment, seeing multiple doctors at least once a week at this time, call member back in august \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 04:05 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 05:55 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 06:15 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 05:14 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:14 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 02:07 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/10/2026 @ 02:07 PM\"}, {\"date\": \"2/6/2026 @ 02:19 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:18 PM\"}, {\"date\": \"2/4/2026 @ 04:24 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:24 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 16:24:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"02-23-2026 17:14:55\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1656, NULL, NULL, NULL, '10000061495', '', '', '47262451', 'Vickie', 'Sennett', '', '', '{\"DOB\": 19592, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1801670989\", \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"Pcp_City\": \"Auburn\", \"Pcp_Name\": \"GAMAL ELDIN, MOHAMED\", \"Rank_All\": 1, \"PCP_Phone\": \"2075133550\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8NK8WG5FH23\", \"Member_City\": \"TURNER\", \"Office_Name\": \"AUBURN MEDICAL ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"TURNER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-08-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"LA Internal Medicine,3 Willow Run\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077956140\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"150 CONANT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04282\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"150 CONANT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04282\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Sennett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Vickie\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Vickiesennett7@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\": \"2072252193\", \"Member_Identification_Number\": \"10000061495\", \"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 14:24:07\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-04-06 14:24:07\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-04T12:46\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-04-06T14:24\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-04T12:46\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-06T14:24\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:09\", \"value\": [{\"add\": \"150 CONANT RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-08-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072252193\", \"zip\": \"04282\", \"add2\": \"\", \"add3\": \"\", \"city\": \"TURNER\", \"gend\": 1, \"insh\": \"10000061495\", \"mzip\": \"04282\", \"name\": \"Vickie M Sennett\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GAMAL ELDIN, MOHAMED\", \"ppno\": \"2075133550\", \"cliId\": \"\", \"email\": \"Vickiesennett7@gmail.com\", \"ename\": \"\", \"madd1\": \"150 CONANT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"TURNER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"LA Internal Medicine,3 Willow Run\", \"pcpnpi\": \"1801670989\", \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Auburn\", \"pcpname\": \"AUBURN MEDICAL ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077956140\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8NK8WG5FH23\", \"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:58:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:09\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"4/6/2026 @ 02:24 PM\", \"result\": 6, \"comment\": \"member requested c/b later in the year - c/b in June\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"6/8/2026 @ 02:23 PM\"}, {\"date\": \"2/4/2026 @ 12:46 PM\", \"result\": 6, \"comment\": \"Per notes member wants cb later in the year\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"3/23/2026 @ 12:46 PM\"}, {\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 12:46:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"01-31-2026 23:38:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:44', 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
(1657, NULL, NULL, NULL, '10000061554', '', '', '52661009', 'William', 'Ward', '', '', '{\"DOB\": 17135, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1730158403\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"FUCHS ERTMAN, DEBRA\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4C52T66WG10\", \"Member_City\": \"STANDISH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"STANDISH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-11-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"100 GANNETT DRIVE,SUITE C\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"178 STUART SHORES\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04084\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"178 STUART SHORES\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04084\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Ward\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Billyward04947@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\": \"2072370136\", \"Member_Identification_Number\": \"10000061554\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2078612663\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-16-2026 01:26:05\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-16 01:26:05\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T11:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T14:55\", \"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-09T10:34\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-16T01:26\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T10:34\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:11\", \"value\": [{\"add\": \"178 STUART SHORES\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2078612663\", \"dob\": \"1946-11-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072370136\", \"zip\": \"04084\", \"add2\": \"\", \"add3\": \"\", \"city\": \"STANDISH\", \"gend\": 0, \"insh\": \"10000061554\", \"mzip\": \"04084\", \"name\": \"William A Ward\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FUCHS ERTMAN, DEBRA\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"Billyward04947@gmail.com\", \"ename\": \"\", \"madd1\": \"178 STUART SHORES\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"STANDISH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DRIVE,SUITE C\", \"pcpnpi\": \"1730158403\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4C52T66WG10\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:11\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": \"6\", \"callLog\": [{\"date\": \"2/9/2026 @ 10:34 AM\", \"result\": 6, \"comment\": \"Calling to schedule F2F w/Sandy in March - c/b in May - mbr not interested now\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/5/2026 @ 02:55 PM\", \"result\": 13, \"comment\": \"Called to Schedule F2F HRA with Sandra caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/10/2026 @ 02:55 PM\"}, {\"date\": \"2/4/2026 @ 11:55 AM\", \"result\": 3, \"comment\": \"calling to sched IHA w/Sandy for 2/5/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 11:55 AM\"}, {\"date\": \"2/3/2026 @ 10:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 11:55:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:38:25\", \"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:58:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1658, NULL, NULL, NULL, '10000061572', '', '', '66650973', 'Diane', 'Saucier', '', '', '{\"DOB\": 19626, \"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\": \"4M28RM3UJ30\", \"Member_City\": \"ALBION\", \"Office_Name\": \"THAYER INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"ALBION\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-09-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"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\": \"94 WINSLOW RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04910\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"94 WINSLOW RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04910\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Saucier\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Diane\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@11202024.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2074626583\", \"Member_Identification_Number\": \"10000061572\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074374066\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-26-2026 15:25:39\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-26 15:25:39\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-18T12:21\", \"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-05T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T16:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T14:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T12:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-26T15:25\", \"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-09T16:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-18T12:21\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-26T15:25\", \"reportStatus_date\": \"2026-03-26T15:25\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-26T15:25\", \"username\": \"KCoash\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:12\", \"value\": [{\"add\": \"94 WINSLOW RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2074374066\", \"dob\": \"1953-09-24\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074626583\", \"zip\": \"04910\", \"add2\": \"\", \"add3\": \"\", \"city\": \"ALBION\", \"gend\": 1, \"insh\": \"10000061572\", \"mzip\": \"04910\", \"name\": \"Diane T Saucier\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KNAUSENBERGER, ROLAND H\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@11202024.com\", \"ename\": \"\", \"madd1\": \"94 WINSLOW RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"ALBION\", \"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\": \"4M28RM3UJ30\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:12\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-26T15:25\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/26/2026 @ 03:25 PM\", \"result\": 9, \"comment\": \"o/c to sched F2F w/Erin on 4/8 - member stated has had her annual w/her doctor and has a follow up in 6 months so is all set\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:31 AM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 07:35 PM\", \"result\": 3, \"comment\": \"03/19/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 01:07 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 12:10 PM\", \"result\": 13, \"comment\": \"Called to Schedule F2F HRA with Elizabeth caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 10:00 AM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 03:41 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 12:21 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM. 2/25 possible date\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 02:48 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 04:59 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/13/2026 @ 04:58 PM\"}, {\"date\": \"2/6/2026 @ 01:03 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/9/2026 @ 01:03 PM\"}, {\"date\": \"2/5/2026 @ 01:21 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/6/2026 @ 01:21 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-05-2026 13:21:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-18-2026 12:21:36\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:45', 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
(1659, 71932120, 44829497, '71460194', '10000061613', '', '', '52498339', 'Daniel', 'Lennon', 'English', '', '{\"DOB\": 19592, \"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\": 1265793574, \"Pcp_Zip\": \"40861747\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"TOPSHAM\", \"Pcp_Name\": \"LIEGNER, ADAM\", \"Rank_All\": 1, \"PCP_Phone\": 2075826608, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2D64X35DT79\", \"Member_City\": \"RICHMOND\", \"Office_Name\": \"GARDINER FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"RICHMOND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-08-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"4 HORTON PL,SUITE 101\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": 2075822258, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"720 ALEXANDER REED RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04357\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"720 ALEXANDER REED RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04357\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Lennon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Daniel\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"danolenn@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2077372938, \"Member_Identification_Number\": \"10000061613\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:52:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:52:38\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-16T14:50\", \"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-05T18:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T11:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T11:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-16T14:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-29T07:39\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-30T14:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-30T15:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-16T16:22\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-28T10:32\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-06T11:48\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T11:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T11:33\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-16T16:22\", \"reportStatus_date\": \"2026-03-16T16:22\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-30T15:36\", \"reportStatus_date\": \"2026-03-30T15:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:52\", \"reportStatus_date\": \"2026-03-31T13:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:52\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-16T16:22\", \"username\": null}, {\"date\": \"2026-03-16T16:22\", \"username\": \"JCopeland\"}], \"inProgress\": [{\"date\": \"2026-03-28T10:32\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-03-30T13:13\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-29T07:39\", \"username\": \"SAcha\"}, {\"date\": \"2026-03-29T07:39\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-30T15:36\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-30T14:21\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-30T15:36\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-28-2026\", \"time\": \"10:32:18\", \"value\": [{\"add\": \"720 ALEXANDER REED RD\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-08-21\", \"eno\": \"2077511324\", \"lob\": \"GA - 2026\", \"pno\": 2077372938, \"zip\": \"04357\", \"add2\": \"\", \"add3\": \"\", \"city\": \"RICHMOND\", \"gend\": 0, \"insh\": \"10000061613\", \"mzip\": \"04357\", \"name\": \"Daniel J Lennon\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LIEGNER, ADAM\", \"ppno\": 2075826608, \"cliId\": \"\", \"email\": \"danolenn@yahoo.com\", \"ename\": \"Lisa Pulsifier (Sister Inlaw)\", \"madd1\": \"720 ALEXANDER REED RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"RICHMOND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"4 HORTON PL,SUITE 101\", \"pcpnpi\": 1265793574, \"pcpzip\": \"40861747\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"TOPSHAM\", \"pcpname\": \"GARDINER FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2075822258, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2D64X35DT79\", \"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-09-2026\", \"time\": \"11:49:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-29-2026 07:39:14\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/16/2026 @ 04:22 PM\", \"result\": 0, \"comment\": \"MRB C/B IN TO SCH- DNF F2F W/SAMUEL ACHE ON 3/28/2026 @ 10:10AM, MRB HAS A LONG DRIVWAY  HAS NAME ON MAILBOX SAYS ITS VERY NICE LOOKING\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 02:50 PM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 11:33 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 11:50 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/13/2026 @ 11:49 AM\"}, {\"date\": \"2/6/2026 @ 11:48 AM\", \"result\": 14, \"comment\": \"member unable to do virtual - needs F2F for march or may - will be out of state in April\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/20/2026 @ 11:47 AM\"}, {\"date\": \"2/5/2026 @ 06:21 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 06:21 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\": \"10000061613\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": \"10000061613\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": \"10000061613\", \"scheduleDate\": \"2026-3-28T10:10\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 18:21:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"03-16-2026 16:22:04\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:52:37\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"a635beb4-4972-4b2f-8bac-2f7f69af5c22\\\",\\\"destination_fax_number\\\":\\\"12075822258\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"a635beb4-4972-4b2f-8bac-2f7f69af5c22\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12075822258\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"207 582 2258\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:58:47.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":302,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":302,\\\"start_timestamp\\\":\\\"2026-03-31T17:53:21.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:58:47.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-28T10:10', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:45', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061613\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Lennon_10000061613_03282026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:52:36\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000061613.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Lennon_10000061613_03282026.pdf', NULL, 'Summary_10000061613.pdf', NULL, '[{\"date\": \"2026-03-29T11:39:13.645Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-28T11:39', 'Member_Summary_10000061613.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061613\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000061613.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:52:37\"}', 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
(1660, NULL, NULL, '48822527', '10000061753', '', '', '24168610', 'Rikki', 'Oneal', 'English', '', '{\"DOB\": 17857, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1649565672\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"MICHAELIS, TODD M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3UC2Q92GD11\", \"Member_City\": \"GORHAM\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GORHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-11-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238590\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"28 RIDGEFIELD DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04038\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"28 RIDGEFIELD DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04038\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Oneal\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rikki\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"Rikoneal1@mac.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\": \"2072323031\", \"Member_Identification_Number\": \"10000061753\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":6,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-11-2026 12:48:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-11 12:48:40\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-23T14:21\", \"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-09T12:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T11:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T14:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-30T14:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-06T10:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-04-11T12:48\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}], \"f2fNoShow\": [{\"date\": \"2026-03-23T12:30\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-23T16:40\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-06T11:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-09T19:32\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-03-31T11:58\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T12:23\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T11:31\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-23T16:40\", \"reportStatus_date\": \"2026-02-23T16:40\"}, {\"text\": \"F2F No Show\", \"type\": \"ReportStatus\", \"status\": 24, \"hraStatus\": 19, \"hraStatus_date\": \"2026-03-23T12:30\", \"reportStatus_date\": \"2026-03-23T12:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-30T14:24\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-04-06T11:16\", \"reportStatus_date\": \"2026-04-06T11:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-04-11T12:48\", \"reportStatus_date\": \"2026-04-11T12:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-03-23T12:30\", \"username\": \"SCadwell\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-23T16:40\", \"username\": null}, {\"date\": \"2026-02-23T16:40\", \"username\": \"KCoash\"}, {\"date\": \"2026-04-06T11:16\", \"username\": null}, {\"date\": \"2026-04-06T11:16\", \"username\": \"FBeckford\"}], \"inProgress\": [{\"date\": \"2026-04-09T19:32\", \"username\": \"JLandry\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-04-11T12:48\", \"username\": \"JLandry\"}, {\"date\": \"2026-04-11T12:48\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-11-2026\", \"time\": \"11:56:22\", \"value\": [{\"add\": \"28 RIDGEFIELD DR\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-11-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072323031\", \"zip\": \"04038\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GORHAM\", \"gend\": 0, \"insh\": \"10000061753\", \"mzip\": \"04038\", \"name\": \"Rikki D Oneal\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MICHAELIS, TODD M\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"Rikoneal1@mac.com\", \"ename\": \"2072323799\", \"madd1\": \"28 RIDGEFIELD DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GORHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,100 Foden Rd Ste 203\", \"pcpnpi\": \"1649565672\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238590\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3UC2Q92GD11\", \"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-23-2026\", \"time\": \"11:52:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-11-2026 12:48:39\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-03-23T12:30\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"SCadwell\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/6/2026 @ 11:16 AM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Jennifer April 11th at 12:10PM * member goes by Rick or Oneal \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 10:02 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"4/9/2026 @ 10:01 AM\"}, {\"date\": \"3/31/2026 @ 11:58 AM\", \"result\": 6, \"comment\": \"member called in and would like a call back\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"4/1/2026 @ 11:58 AM\"}, {\"date\": \"3/30/2026 @ 02:24 PM\", \"result\": 3, \"comment\": \"o/c to resched missed F2F appt w/Sandy\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/31/2026 @ 02:23 PM\"}, {\"date\": \"2/23/2026 @ 04:40 PM\", \"result\": 0, \"comment\": \"sched w/Sandy 3/23 at 9 am\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:21 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 11:31 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 11:03 AM\", \"result\": 3, \"comment\": \"LVM VIRTUAL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 11:03 AM\"}, {\"date\": \"2/9/2026 @ 12:23 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 12:22 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:27 PM\"}, {\"date\": \"2/3/2026 @ 11:22 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\": {\"type\": \"visitType\", \"memberId\": \"10000061753\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": \"10000061753\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": \"10000061753\", \"scheduleDate\": \"2026-4-11T12:10\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 13:29:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}, {\"date\": \"03-23-2026 12:30:48\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"04-06-2026 11:16:13\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, NULL, 'In Person', '2026-4-11T12:10', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"date\": \"2026-04-11T16:48:35.953Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-04-11T12:48', 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
(1661, NULL, NULL, NULL, '10000061773', '', '', '52661009', 'Margaret', 'Denham', '', '', '{\"DOB\": 19633, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1740249861\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"MARTIN, STEPHEN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7CD8AT7WC52\", \"Member_City\": \"GRAY\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gray\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-10-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"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\": \"300 YARMOUTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 1020\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Denham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Margaret\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mmdenham820@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\": \"2078318710\", \"Member_Identification_Number\": \"10000061773\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-08-2026 13:19:57\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-04-08 13:19:57\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T12:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-02-13T12:04\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-02-17T13:12\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-09T14:50\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T13:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T12:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T12:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-04-08T13:19\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T13:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-13T12:04\", \"reportStatus_date\": \"2026-02-13T12:04\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-17T13:12\", \"reportStatus_date\": \"2026-02-17T13:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-09T14:50\", \"reportStatus_date\": \"2026-03-09T14:50\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-04-08T13:19\", \"reportStatus_date\": \"2026-04-08T13:19\"}]', '{\"utc\": [{\"date\": \"2026-02-13T12:04\", \"username\": \"admin\"}, {\"date\": \"2026-02-17T13:12\", \"username\": \"KCoash\"}, {\"date\": \"2026-03-09T14:50\", \"username\": \"jsmith\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-04-08T13:19\", \"username\": \"KAtobatele\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:13:21\", \"value\": [{\"add\": \"300 YARMOUTH RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-10-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078318710\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GRAY\", \"gend\": 1, \"insh\": \"10000061773\", \"mzip\": \"04039\", \"name\": \"Margaret M Denham\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MARTIN, STEPHEN\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"mmdenham820@gmail.com\", \"ename\": \"\", \"madd1\": \"PO BOX 1020\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gray\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Intermed,259 Main St\", \"pcpnpi\": \"1740249861\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7CD8AT7WC52\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:13:21\"}', '{\"utc\": [{\"date\": \"2026-02-13T12:04\", \"type\": null, \"subStaus\": \"\", \"username\": \"admin\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-02-17T13:12\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-03-09T14:50\", \"type\": null, \"subStaus\": \"\", \"username\": \"jsmith\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-04-08T13:19\", \"type\": null, \"subStaus\": \"\", \"username\": \"KAtobatele\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/8/2026 @ 12:19 PM\", \"result\": 9, \"comment\": \"Called to schedule virtual with Amanda, Refusal\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 02:50 PM\", \"result\": 6, \"comment\": \"call back requested for july per notes \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 01:12 PM\", \"result\": 6, \"comment\": \"Call Back in July to sched w/Her husband who asked for a c/b in the summer\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 12:04 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/ Nicole Mattison CALLBACK. IN MAY.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 12:20 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:09 PM\", \"result\": 1, \"comment\": \"DEAD AIR VIRTUAL \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 10:11 AM\", \"result\": 3, \"comment\": \"NO VM SETUP\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 10:10 AM\"}, {\"date\": \"2/6/2026 @ 03:41 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 03:40 PM\"}, {\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 15:41:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-11-2026 12:20:41\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:46', 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
(1662, 93442164, 44829497, '39698290', '10000061878', '', '', '1019044', 'Gary', 'Beckwith', 'English', '', '{\"DOB\": 19596, \"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\": 1447328125, \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"CAREY, SEAN P\", \"Rank_All\": 1, \"PCP_Phone\": 2078392559, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8KE2AR1PT26\", \"Member_City\": \"Windham\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Windham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-08-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,575 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2075231135, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"55 BARNES RD\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"55 BARNES RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Beckwith\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gary\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"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\": \"2075723466\", \"Member_Identification_Number\": \"10000061878\", \"Member_Alternate_Phone_Number\": \"2075723411\", \"Member_Secondary_Phone_Number\": 2075723466}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 15:04:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 15:04:32\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-11T14:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T09:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T09:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T17:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T17:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-11T21:01\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-19T20:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-19T20:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T15:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-03T17:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-09T09:29\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T17:33\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T14:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 2, \"hraStatus_date\": \"2026-03-09T09:29\", \"reportStatus_date\": \"2026-03-09T17:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-11T21:01\", \"reportStatus_date\": \"2026-03-11T21:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-19T20:45\", \"reportStatus_date\": \"2026-03-19T20:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T15:04\", \"reportStatus_date\": \"2026-03-24T15:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T15:04\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-03T17:12\", \"username\": null}, {\"date\": \"2026-03-03T17:12\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-03-09T09:29\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:54\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-11T21:01\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-11T21:01\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-19T20:45\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-19T20:39\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-19T20:45\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-09-2026\", \"time\": \"09:29:32\", \"value\": [{\"add\": \"55 BARNES RD\", \"age\": 72, \"ano\": \"2075723411\", \"cno\": 2075723466, \"dob\": \"1953-08-25\", \"eno\": \"2075723466\", \"lob\": \"GA - 2026\", \"pno\": \"2075723466\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Windham\", \"gend\": 0, \"insh\": \"10000061878\", \"mzip\": \"04062\", \"name\": \"Gary W Beckwith\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CAREY, SEAN P\", \"ppno\": 2078392559, \"cliId\": \"\", \"email\": \"\", \"ename\": \"Terri\", \"madd1\": \"55 BARNES RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Windham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,575 Main St\", \"pcpnpi\": 1447328125, \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2075231135, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8KE2AR1PT26\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-06-2026\", \"time\": \"13:35:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 21:01:15\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/3/2026 @ 05:12 PM\", \"result\": 0, \"comment\": \"Sched w/Sandy 3/9 at 9 am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 01:45 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:09 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 01:07 PM\", \"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 @ 03:19 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 10:14 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 11:50 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 01:49 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 10:10 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 01:52 PM\", \"result\": 3, \"comment\": \"02/12/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 02:14 PM\", \"result\": 3, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:39 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.u00a0 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 05:33 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 05:33 PM\"}, {\"date\": \"2/6/2026 @ 09:51 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/11/2026 @ 09:50 AM\"}, {\"date\": \"2/5/2026 @ 09:43 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/10/2026 @ 09:43 AM\"}, {\"date\": \"2/3/2026 @ 03:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000061878\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000061878\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000061878\", \"scheduleDate\": \"2026-3-9T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 09:43:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"03-03-2026 17:12:27\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 17}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 15:04:30\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"85ff392d-2104-455c-9bd4-160f3e205a76\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"85ff392d-2104-455c-9bd4-160f3e205a76\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552631139 6       \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:09:33.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\\\":270,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":270,\\\"start_timestamp\\\":\\\"2026-03-24T19:04:48.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:09:33.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-9T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:46', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061878\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Beckwith_10000061878_03092026.pdf\", \"ftp_upload_date\": \"2026-03-24 15:04:29\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000061878.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Beckwith_10000061878_03092026.pdf', NULL, 'Summary_10000061878.pdf', NULL, '[{\"date\": \"2026-03-12T01:01:15.633Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-09T22:16', 'Member_Summary_10000061878.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061878\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000061878.pdf\", \"member_ftp_upload_date\": \"2026-03-24 15:04:31\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
