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
(1450, NULL, NULL, NULL, '10000054234', '', '', '94743867', 'Kathleen', 'Roy', '', '', '{\"DOB\": 18735, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1497105605\", \"Pcp_Zip\": \"04530\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bath\", \"Pcp_Name\": \"JACOB, ROBERT T\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2V07HX5NY58\", \"Member_City\": \"WATERVILLE\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WATERVILLE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-04-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"MaineHealth Primary Care Internal Medicine,108 Centre St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2075176915\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"39 VILLAGE GREEN RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"39 VILLAGE GREEN RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Roy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kathleen\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kathlynmaryroy@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\": \"2078551180\", \"Member_Identification_Number\": \"10000054234\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-22-2026 18:53:06\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-22 18:53:06\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-09T12:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-22T18:53\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-06T14:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T15:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T13:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T14:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T12:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T14:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T15:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T14:54\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T12:32\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-22T18:53\", \"reportStatus_date\": \"2026-03-22T18:53\"}]', '{\"utc\": [{\"date\": \"2026-03-22T18:53\", \"username\": \"PJoseph\"}], \"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:08:20\", \"value\": [{\"add\": \"39 VILLAGE GREEN RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-04-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078551180\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WATERVILLE\", \"gend\": 1, \"insh\": \"10000054234\", \"mzip\": \"04901\", \"name\": \"Kathleen M Roy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JACOB, ROBERT T\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kathlynmaryroy@gmail.com\", \"ename\": \"\", \"madd1\": \"39 VILLAGE GREEN RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WATERVILLE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"MaineHealth Primary Care Internal Medicine,108 Centre St\", \"pcpnpi\": \"1497105605\", \"pcpzip\": \"04530\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bath\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075176915\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2V07HX5NY58\", \"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:57:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:20\"}', '{\"utc\": [{\"date\": \"2026-03-22T18:53\", \"type\": null, \"subStaus\": \"\", \"username\": \"PJoseph\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/22/2026 @ 06:53 PM\", \"result\": 6, \"comment\": \"Called to schedule virtual IHA with Amanda Milliken -Call Back Requested in June \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 05:09 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 12:32 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn  Mailbox full.  \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 02:54 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/4/2026 @ 02:54 PM\"}, {\"date\": \"2/25/2026 @ 01:12 PM\", \"result\": 3, \"comment\": \"LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/27/2026 @ 01:12 PM\"}, {\"date\": \"2/10/2026 @ 03:46 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/12/2026 @ 03:45 PM\"}, {\"date\": \"2/6/2026 @ 01:55 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual hra with MP nurse Nancy H; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 01:54 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 13:55:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"03-09-2026 12:32:41\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1451, NULL, NULL, NULL, '10000054251', '', '', '52661009', 'David', 'Appell', 'English', '', '{\"DOB\": 18441, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1629431622\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"LETELLIER, TERESA\", \"Rank_All\": 1, \"PCP_Phone\": \"2072831441\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3AP1DT6EJ17\", \"Member_City\": \"SACO\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SACO\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-06-27\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2075231136\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"24 SKYLINE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04072\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"24 SKYLINE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04072\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Appell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dappell@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\": \"\", \"Member_Identification_Number\": \"10000054251\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2072051441\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-05-2026 09:19:41\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-05 09:19:41\", \"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-05T09: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\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-05T09:19\", \"reportStatus_date\": \"2026-02-05T09:19\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-05T09:19\", \"username\": \"KCoash\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:21\", \"value\": [{\"add\": \"24 SKYLINE DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2072051441\", \"dob\": \"1950-06-27\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072051441\", \"zip\": \"04072\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SACO\", \"gend\": 0, \"insh\": \"10000054251\", \"mzip\": \"04072\", \"name\": \"David P Appell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LETELLIER, TERESA\", \"ppno\": \"2072831441\", \"cliId\": \"\", \"email\": \"dappell@maine.rr.com\", \"ename\": \"\", \"madd1\": \"24 SKYLINE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SACO\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1629431622\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075231136\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3AP1DT6EJ17\", \"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:57:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:21\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-05T09:19\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/5/2026 @ 09:19 AM\", \"result\": 9, \"comment\": \"mbr refused 2/2/26 per FIve9 record\", \"inBound\": false, \"noAnswer\": -1, \"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-05-2026 09:19:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:37:13\", \"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:57:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1452, NULL, NULL, NULL, '10000054266', '', '', '1019044', 'Ann', 'Cyr', '', '', '{\"DOB\": 18979, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1760971683\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"BILLINGS, HANNAH B\", \"Rank_All\": 1, \"PCP_Phone\": \"2079455247\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2GM8H20DA10\", \"Member_City\": \"OLD TOWN\", \"Office_Name\": \"PENOBSCOT COMMUNITY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OLD TOWN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-12-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"Penobscot Community Health Center,1012 Union St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079922154\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"25 HIGHLAND AVE UNIT 2\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04468\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"25 HIGHLAND AVE UNIT 2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04468\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cyr\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ann\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078274809\", \"Member_Identification_Number\": \"10000054266\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-15-2026 16:43:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-15 16:43:26\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-12T09:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-15T16:43\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-06T14:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T11:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T09:49\", \"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:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T09:49\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-15T16:43\", \"reportStatus_date\": \"2026-03-15T16:43\"}]', '{\"utc\": [{\"date\": \"2026-03-15T16:43\", \"username\": \"KAtobatele\"}], \"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:08:22\", \"value\": [{\"add\": \"25 HIGHLAND AVE UNIT 2\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-12-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078274809\", \"zip\": \"04468\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OLD TOWN\", \"gend\": 1, \"insh\": \"10000054266\", \"mzip\": \"04468\", \"name\": \"Ann M Cyr\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BILLINGS, HANNAH B\", \"ppno\": \"2079455247\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"25 HIGHLAND AVE UNIT 2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OLD TOWN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Penobscot Community Health Center,1012 Union St\", \"pcpnpi\": \"1760971683\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"PENOBSCOT COMMUNITY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079922154\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2GM8H20DA10\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:22\"}', '{\"utc\": [{\"date\": \"2026-03-15T16:43\", \"type\": null, \"subStaus\": \"\", \"username\": \"KAtobatele\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:12 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 03:12 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell or Erin Barker\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 01:41 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 02:34 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/22/2026 @ 06:54 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA with Amanda Milliken -LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 05:26 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 04:43 PM\", \"result\": 6, \"comment\": \"Called to schedule virtual with Amanda, member asks to call back\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 01:04 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 12:58 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin B 3/18\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 02:09 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 3/11\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 03:31 PM\", \"result\": 3, \"comment\": \"02/26/2026- F2F HRA WITH ERIN BARKER  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 10:51 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 11:12 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 10:42 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 09:40 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 02:29 PM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 09:49 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin B 2/13 at 9 am\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 11:34 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Erin B 2/13 at 9 am\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/12/2026 @ 11:33 AM\"}, {\"date\": \"2/10/2026 @ 11:39 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/16/2026 @ 11:37 AM\"}, {\"date\": \"2/9/2026 @ 02:12 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/13/2026 @ 02:09 PM\"}, {\"date\": \"2/6/2026 @ 02:55 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/11/2026 @ 02:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 14:55:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"02-12-2026 09:49:13\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 21}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:30', 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
(1453, 52478890, 44829497, '17537038', '10000054308', '', '', '24168610', 'Ellen', 'Decotiis', 'English', '', '{\"DOB\": 19049, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": 1821095241, \"Pcp_Zip\": \"04074\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Scarborough\", \"Pcp_Name\": \"CLARK, SHERI\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9W54XW3NT08\", \"Member_City\": \"BAR MILLS\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BAR MILLS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-02-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Martins Point Health Care,153 US Rte 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"PO BOX 608\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04004\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 608\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04004\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Decotiis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ellen\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"ehdecotiis1@hotmail.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\": 2078099496, \"Member_Identification_Number\": \"10000054308\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 15:03:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 15:03:11\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T11:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T11:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T10:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T15:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-13T08:40\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-20T12:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-20T14:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T15:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-12T11:54\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-13T08:00\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T10:05\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-12T11:54\", \"reportStatus_date\": \"2026-02-12T11:54\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-03-16T21:16\", \"reportStatus_date\": \"2026-03-13T08:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-20T14:24\", \"reportStatus_date\": \"2026-03-20T14:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T15:03\", \"reportStatus_date\": \"2026-03-24T15:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T15:03\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-12T11:54\", \"username\": null}, {\"date\": \"2026-02-12T11:54\", \"username\": \"LRivera\"}], \"inProgress\": [{\"date\": \"2026-03-13T08:00\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:48\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-13T08:40\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-13T08:40\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-19T14:27\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-19T22:07\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-20T10:54\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-20T14:24\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-20T12:05\", \"username\": \"CBryan\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-20T14:24\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-16T21:16\", \"username\": \"CBryan\"}, {\"date\": \"2026-03-19T14:27\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-19T22:09\", \"username\": \"CBryan\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-13-2026\", \"time\": \"08:39:21\", \"value\": [{\"add\": \"PO BOX 608\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-02-25\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2078099496, \"zip\": \"04004\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BAR MILLS\", \"gend\": 1, \"insh\": \"10000054308\", \"mzip\": \"04004\", \"name\": \"Ellen H Decotiis\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CLARK, SHERI\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ehdecotiis1@hotmail.com\", \"ename\": \"Elizabeth Decotiis - Daughter\", \"madd1\": \"PO BOX 608\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BAR MILLS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,153 US Rte 1\", \"pcpnpi\": 1821095241, \"pcpzip\": \"04074\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Separated\", \"pcpFlag\": \"\", \"pcpcity\": \"Scarborough\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9W54XW3NT08\", \"currentgend\": \"Female\", \"pphycomment\": \"meeting new provider in August. Sean\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-12-2026\", \"time\": \"12:56:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 10:54:13\"}', NULL, NULL, '{\"memberId\": \"10000054308\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Cynthia Bryan\", \"queryData\": [{\"date\": \"Tue, 17 Mar 2026 01:16:41 GMT\", \"name\": \"Cynthia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda.\\n1). Under Assessment of DX under Musculoskeletal, could you please mark \\\"Yes\\\" as member sees an Orthopedist for right hip tendonitis? \\n2). Just to clarify, member was unable to provide weight? \\nThank you,\\nCindy\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Mar 2026 18:27:34 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Cynthia, \\nThe member does not usually monitor her weight. She is working on weight loss . I called her back and she was willing to share this with me. I have updated the form. \\nThank you, \\nAmanda\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Mar 2026 02:09:18 GMT\", \"name\": \"Cynthia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda. \\nUnder Assessment of DX, Musculoskeletal, could you please mark the symptoms box for right hip tendonitis and the box concerning amputation below that?\\n\\nThank you,\\nCindy\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Mar 2026 14:54:11 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Cynthia, \\n\\nI have corrected the form. \\n\\nThank you,\\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Ellen Decotiis\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/13/2026 08:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"c.bryan@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/12/2026 @ 10:54 AM\", \"result\": 0, \"comment\": \"IC- scheduled virtual hra for March 13 at 8:00 AM with Amanda Milliken. \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 03:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 10:05 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 10:04 AM\"}, {\"date\": \"2/6/2026 @ 11:13 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/9/2026 @ 11:12 AM\"}, {\"date\": \"2/4/2026 @ 11:55 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/6/2026 @ 11:55 AM\"}, {\"date\": \"2/3/2026 @ 05:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000054308\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000054308\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000054308\", \"scheduleDate\": \"2026-3-13T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 11:55:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-12-2026 11:54:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 15:03:09\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"194cdc0c-27b4-11f1-a6a5-cb4e121d0bfc\\\",\\\"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\": \"null\"}]', 'Virtual', '2026-3-13T08:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:31', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000054308\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Decotiis_10000054308_03132026.pdf\", \"ftp_upload_date\": \"2026-03-24 15:03:09\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000054308.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Decotiis_10000054308_03132026.pdf', NULL, 'Summary_10000054308.pdf', NULL, '[{\"date\": \"2026-03-13T12:40:50.440Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-19T18:27:34.135Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-20T14:54:11.721Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-13T08:36', 'Member_Summary_10000054308.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000054308\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000054308.pdf\", \"member_ftp_upload_date\": \"2026-03-24 15:03:11\"}', 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
(1454, NULL, NULL, NULL, '10000054324', '', '', '14035267', 'Carole', 'Fiato', 'English', '', '{\"DOB\": 12857, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1245494095\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"THOMAS, ANNE L\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8UE2HX7WH70\", \"Member_City\": \"FALMOUTH\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FALMOUTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1935-03-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 HARRIETTE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04105\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 HARRIETTE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04105\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Fiato\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carole\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077812687\", \"Member_Identification_Number\": \"10000054324\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-01-2026 10:22:36\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-04-01 10:22:36\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-02T16:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-09T14:05\", \"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-06T12:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-04-01T10:22\", \"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-09T12:33\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-25T13:24\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-02T16:58\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T12:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T11:50\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-02T16:58\", \"reportStatus_date\": \"2026-03-02T16:58\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-09T14:05\", \"reportStatus_date\": \"2026-03-09T14:05\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-04-01T10:22\", \"reportStatus_date\": \"2026-04-01T10:22\"}]', '{\"utc\": [{\"date\": \"2026-03-02T16:58\", \"username\": \"MValdez\"}, {\"date\": \"2026-03-09T14:05\", \"username\": \"jsmith\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-04-01T10:22\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:25\", \"value\": [{\"add\": \"15 HARRIETTE ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1935-03-14\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077812687\", \"zip\": \"04105\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FALMOUTH\", \"gend\": 1, \"insh\": \"10000054324\", \"mzip\": \"04105\", \"name\": \"Carole Fiato\", \"plan\": \"Martin\'s Point\", \"pphy\": \"THOMAS, ANNE L\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"15 HARRIETTE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FALMOUTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1245494095\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8UE2HX7WH70\", \"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:57:31\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:25\"}', '{\"utc\": [{\"date\": \"2026-03-02T16:58\", \"type\": null, \"subStaus\": \"\", \"username\": \"MValdez\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-03-09T14:05\", \"type\": null, \"subStaus\": \"\", \"username\": \"jsmith\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-04-01T10:22\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/1/2026 @ 10:22 AM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Jennifer but member refused.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 02:05 PM\", \"result\": 6, \"comment\": \"Call back in April per notes\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 04:58 PM\", \"result\": 6, \"comment\": \"CALL BACK NEXT MONTH WAS IN SURGERY \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 01:24 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Samuel but member requested a call back.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/27/2026 @ 01:24 PM\"}, {\"date\": \"2/10/2026 @ 08:50 AM\", \"result\": 13, \"comment\": \" called to schedule virtual appt with Amanda M,left vm , caller disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/12/2026 @ 08:50 AM\"}, {\"date\": \"2/9/2026 @ 09:33 AM\", \"result\": 6, \"comment\": \" called to schedule virtual appt with Amanda M,callback  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/12/2026 @ 09:33 AM\"}, {\"date\": \"2/6/2026 @ 09:11 AM\", \"result\": 3, \"comment\": \" called to schedule face to face appt with Jessica D\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/11/2026 @ 09:10 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-06-2026 09:11:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"01-31-2026 23:37:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1455, NULL, NULL, NULL, '10000054347', '', '', '24168610', 'Mary', 'Craig', '', '', '{\"DOB\": 19073, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1982685459\", \"Pcp_Zip\": \"45533838\", \"Program\": \"Medicare\", \"Pcp_City\": \"NEW CASTLE\", \"Pcp_Name\": \"CLARK, MICHAEL H\", \"Rank_All\": 1, \"PCP_Phone\": \"2075633366\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2Q62U16JT09\", \"Member_City\": \"BRISTOL\", \"Office_Name\": \"LIFESPAN FAMILY HEALTHCARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRISTOL\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"80 RIVER ROAD,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Lincoln\", \"Member_Country\": \"Lincoln\", \"PCP_Fax_Number\": \"2075633393\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"132 WALPOLE MEETINGHOUSE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04539\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"132 WALPOLE MEETINGHOUSE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04539\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Craig\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mary\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Marycraig352@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\": \"2075636845\", \"Member_Identification_Number\": \"10000054347\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2075929757\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-11-2026 16:32:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-11 16:32:52\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T18:56\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-11T16:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T16:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T16:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T18:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T18:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T11:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T18:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T18:56\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-11T16:32\", \"reportStatus_date\": \"2026-03-11T16:32\"}]', '{\"utc\": [{\"date\": \"2026-03-11T16:32\", \"username\": \"cwasilak\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:26\", \"value\": [{\"add\": \"132 WALPOLE MEETINGHOUSE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2075929757\", \"dob\": \"1952-03-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075636845\", \"zip\": \"04539\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRISTOL\", \"gend\": 1, \"insh\": \"10000054347\", \"mzip\": \"04539\", \"name\": \"Mary C Craig\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CLARK, MICHAEL H\", \"ppno\": \"2075633366\", \"cliId\": \"\", \"email\": \"Marycraig352@gmail.com\", \"ename\": \"\", \"madd1\": \"132 WALPOLE MEETINGHOUSE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRISTOL\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"80 RIVER ROAD,\", \"pcpnpi\": \"1982685459\", \"pcpzip\": \"45533838\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"NEW CASTLE\", \"pcpname\": \"LIFESPAN FAMILY HEALTHCARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075633393\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2Q62U16JT09\", \"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:57:31\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:26\"}', '{\"utc\": [{\"date\": \"2026-03-11T16:32\", \"type\": null, \"subStaus\": \"\", \"username\": \"cwasilak\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/6/2026 @ 10:34 AM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/22/2026 @ 06:55 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA with Amanda Milliken -LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 04:32 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Erin but member requested a call back. husband answered phone...says wife had it done...he scheduled for himself will call back if mary needs one as well  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 06:56 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 06:34 PM\", \"result\": 3, \"comment\": \"02/27/2026- CALLED TO SCH VIRTUAL-HRA Leana Chan, Nicole Mattison, or Amanda Milliken  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 04:42 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 04:41 PM\"}, {\"date\": \"2/24/2026 @ 04:09 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/26/2026 @ 04:09 PM\"}, {\"date\": \"2/10/2026 @ 11:25 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:24 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 11:25:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"03-05-2026 18:56:45\", \"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:57:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1456, NULL, NULL, NULL, '10000054361', '', '', NULL, 'David', 'Reardon', '', '', '{\"DOB\": 19080, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1831501378\", \"Pcp_Zip\": \"02860\", \"Program\": \"Medicare\", \"Pcp_City\": \"PAWTUCKET\", \"Pcp_Name\": \"ERICKSON, EMILY J\", \"Rank_All\": 1, \"PCP_Phone\": \"2074394430\", \"Pcp_State\": \"RI\", \"Medicare_ID\": \"3CG9UM0AC45\", \"Member_City\": \"Portland\", \"Office_Name\": \"NORTHERN LIGHT MERCY PRIMARY CARE SOUTH PORTLAND\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Portland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-27\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"111 BREWSTER STREET,FCC TEAM B\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2074390968\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"880 FOREST AVE APT 10 6\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"880 FOREST AVE APT 10 6\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Reardon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"DAVIDEDWARDREARDON@OUTLOOK.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075101650\", \"Member_Identification_Number\": \"10000054361\", \"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:44\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:44\", \"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:08:27\", \"value\": [{\"add\": \"880 FOREST AVE APT 10 6\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-03-27\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075101650\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Portland\", \"gend\": 0, \"insh\": \"10000054361\", \"mzip\": \"04103\", \"name\": \"David E Reardon\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ERICKSON, EMILY J\", \"ppno\": \"2074394430\", \"cliId\": \"\", \"email\": \"DAVIDEDWARDREARDON@OUTLOOK.COM\", \"ename\": \"\", \"madd1\": \"880 FOREST AVE APT 10 6\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Portland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"111 BREWSTER STREET,FCC TEAM B\", \"pcpnpi\": \"1831501378\", \"pcpzip\": \"02860\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PAWTUCKET\", \"pcpname\": \"NORTHERN LIGHT MERCY PRIMARY CARE SOUTH PORTLAND\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074390968\", \"pcpstate\": \"RI\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3CG9UM0AC45\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:27\"}', '{\"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:37:15\", \"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:57:32', 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
(1457, 57818338, 44829497, '17537038', '10000054385', '', '', '24168610', 'Timothy', 'Nason', 'English', '', '{\"DOB\": 19039, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": 1275732364, \"Pcp_Zip\": \"04011\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Brunswick\", \"Pcp_Name\": \"SOMMER, JOHN E\", \"Rank_All\": 1, \"PCP_Phone\": 2077984400, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6UN1T08JE02\", \"Member_City\": \"DRESDEN\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DRESDEN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-02-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"PEDIATRICS\", \"Pcp_Address_1\": \"Martins Point Health Care,114 Bath Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Lincoln\", \"Member_Country\": \"Lincoln\", \"PCP_Fax_Number\": 2078287850, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"183 ALEXANDER ROAD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04342\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"183 ALEXANDER ROAD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04342\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Nason\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Timothy\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"timnason52@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2077379480, \"Member_Identification_Number\": \"10000054385\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:52:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:52:19\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-12T15:31\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T14:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T17:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T11:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-16T01:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T12:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T15:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-20T16:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-20T10:45\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-25T23:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-26T00:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-18T11:18\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-20T09:25\", \"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-05T14:49\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T12:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-12T15:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-20T10:45\", \"reportStatus_date\": \"2026-03-20T16:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-26T00:15\", \"reportStatus_date\": \"2026-03-26T00:15\"}, {\"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-18T11:18\", \"username\": null}, {\"date\": \"2026-03-18T11:18\", \"username\": \"FBeckford\"}], \"inProgress\": [{\"date\": \"2026-03-20T09:25\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-22T23:32\", \"username\": \"PFrey1\"}, {\"date\": \"2026-03-23T18:19\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-03-20T10:45\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-20T10:45\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-25T11:02\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-26T00:15\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-25T23:27\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-26T00:15\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-24T23:38\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-25T10:59\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-25T11:02\", \"username\": \"AMilliken\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"09:46:43\", \"value\": [{\"add\": \"183 ALEXANDER ROAD\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-02-15\", \"eno\": \"2072379502\", \"lob\": \"GA - 2026\", \"pno\": 2077379480, \"zip\": \"04342\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DRESDEN\", \"gend\": 0, \"insh\": \"10000054385\", \"mzip\": \"04342\", \"name\": \"Timothy B Nason\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SOMMER, JOHN E\", \"ppno\": 2077984400, \"cliId\": \"\", \"email\": \"timnason52@gmail.com\", \"ename\": \"Wife Susan Leiter \", \"madd1\": \"183 ALEXANDER ROAD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DRESDEN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,114 Bath Rd\", \"pcpnpi\": 1275732364, \"pcpzip\": \"04011\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Brunswick\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078287850, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6UN1T08JE02\", \"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-19-2026\", \"time\": \"13:33:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-25-2026 11:02:31\"}', NULL, NULL, '{\"memberId\": \"10000054385\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 25 Mar 2026 03:38:28 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  AOD Cardiovascular HTN reports treated with medication.  Please add to med list.\\n2.  AOD cardiovascular chest pain treated with medication.   Please add to med list.\\n3.  Exam review needs more answers.\\n4.  Mini Cog please add comment why the clock has not been completed.\\n5.  Home Safety quality of life question and I am already working on it question.  Need answers.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 25 Mar 2026 15:02:30 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judith, \\n 1. Metoprolol is for blood pressure and CAD. I have updated this. \\n2. Isosorbide is a a nitrate\\n3. I have added muskulostetal but no strength evaluated and ROM is significantly limited with telehealth\\n4. address with PCP selected. \\n5. home safety has already been selected. \\n\"}, \"mailId\": \"\"}], \"memberName\": \"Timothy Nason\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/20/2026 09:30 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/18/2026 @ 11:18 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 20th at 09:30AM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 12:53 PM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 05:06 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda,  LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 03:31 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Erin B 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 12:34 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 11:51 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 05:36 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:35 PM\"}, {\"date\": \"2/5/2026 @ 02:49 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 @ 02:48 PM\"}, {\"date\": \"2/3/2026 @ 11:19 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000054385\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000054385\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000054385\", \"scheduleDate\": \"2026-3-20T09:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 14:49:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"03-18-2026 11:18:44\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:52:18\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"d4e8c2e3-fc95-4dd1-ba85-625e94a478a1\\\",\\\"destination_fax_number\\\":\\\"12078287850\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"d4e8c2e3-fc95-4dd1-ba85-625e94a478a1\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12078287850\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:09:25.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":1,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T17:52:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:53:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T17:55:33.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:56:26.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T17:58:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:58:59.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:01:04.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:01:29.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:03:40.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:04:07.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:06:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:06:44.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":7,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-31T18:08:58.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:09:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-20T09:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:32', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000054385\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Nason_10000054385_03202026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:52:18\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000054385.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Nason_10000054385_03202026.pdf', NULL, 'Summary_10000054385.pdf', NULL, '[{\"date\": \"2026-03-20T14:45:49.001Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-25T15:02:30.342Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-20T10:39', 'Member_Summary_10000054385.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000054385\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000054385.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:52:18\"}', 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
(1458, NULL, NULL, NULL, '10000054403', '', '', '24168610', 'Jean', 'Palanza', '', '', '{\"DOB\": 17986, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1659458511\", \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"MCKENNEY, BRANDY M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078399101\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2GV9TG7XU59\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"NORTHERN LIGHT MERCY PRIMARY CARE GORHAM\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-03-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"Mercy Gorham Crossing Primary Care,19 S Gorham Crossing\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078399201\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"67 N KELSEY ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"67 N KELSEY ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Palanza\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jean\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@123019.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078317193\", \"Member_Identification_Number\": \"10000054403\", \"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 15:11:51\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-05 15:11:51\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T15:11\", \"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-10T18:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T17:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T16:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T11:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T15:11\", \"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:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T11:32\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T15:11\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:28\", \"value\": [{\"add\": \"67 N KELSEY ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-03-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078317193\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 1, \"insh\": \"10000054403\", \"mzip\": \"04106\", \"name\": \"Jean F Palanza\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MCKENNEY, BRANDY M\", \"ppno\": \"2078399101\", \"cliId\": \"\", \"email\": \"declined@123019.com\", \"ename\": \"\", \"madd1\": \"67 N KELSEY ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Mercy Gorham Crossing Primary Care,19 S Gorham Crossing\", \"pcpnpi\": \"1659458511\", \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Gorham\", \"pcpname\": \"NORTHERN LIGHT MERCY PRIMARY CARE GORHAM\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078399201\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2GV9TG7XU59\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:28\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/23/2026 @ 05:00 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 01:16 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 02:09 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Elizabeth no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 03:11 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/13/2026 @ 08:32 AM\", \"result\": 3, \"comment\": \"called to schedule face to face w/ Shellie H, no answer lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 04:07 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/19/2026 @ 04:07 PM\"}, {\"date\": \"2/11/2026 @ 02:29 PM\", \"result\": 3, \"comment\": \" called to schedule face to face \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 02:28 PM\"}, {\"date\": \"2/10/2026 @ 06:23 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/12/2026 @ 06:21 PM\"}, {\"date\": \"2/3/2026 @ 06:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 18:23:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"03-05-2026 15:11:51\", \"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:57:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1459, NULL, NULL, NULL, '10000054440', '', '', '52661009', 'Russell', 'Wing', '', '', '{\"DOB\": 15604, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1235696600\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"TAYLOR, ISABELLA\", \"Rank_All\": 1, \"PCP_Phone\": \"2077952800\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1KN4KK3VQ61\", \"Member_City\": \"Bowdoin\", \"Office_Name\": \"CMMC FAMILY MEDICINE RESIDENCY PROGRAM\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bowdoin\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-09-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"CMMC Family Medicine Residency Program,76 High St Ste 200\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"745 MAIN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04287\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"745 MAIN ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04287\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Wing\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Russell\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@01222025.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073538218\", \"Member_Identification_Number\": \"10000054440\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077136847\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-06-2026 15:50:42\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-03-06 15:50:42\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-04T13:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-05T12:57\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-06T15:50\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T12:57\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-06T15:50\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:30\", \"value\": [{\"add\": \"745 MAIN ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2077136847\", \"dob\": \"1942-09-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073538218\", \"zip\": \"04287\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Bowdoin\", \"gend\": 0, \"insh\": \"10000054440\", \"mzip\": \"04287\", \"name\": \"Russell A Wing\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TAYLOR, ISABELLA\", \"ppno\": \"2077952800\", \"cliId\": \"\", \"email\": \"declined@01222025.com\", \"ename\": \"\", \"madd1\": \"745 MAIN ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bowdoin\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"CMMC Family Medicine Residency Program,76 High St Ste 200\", \"pcpnpi\": \"1235696600\", \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Lewiston\", \"pcpname\": \"CMMC FAMILY MEDICINE RESIDENCY PROGRAM\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1KN4KK3VQ61\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:30\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"3/6/2026 @ 03:50 PM\", \"result\": 6, \"comment\": \"03/06/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER, MRB GOING THUR CHEMO C/B IN A FEW MONTHS  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"5/20/2026 @ 03:50 PM\"}, {\"date\": \"3/4/2026 @ 01:10 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/5/2026 @ 01:10 PM\"}, {\"date\": \"2/5/2026 @ 12:57 PM\", \"result\": 6, \"comment\": \"c/b in March per five9 notes\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/3/2026 @ 12:57 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-05-2026 12:57:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:37:16\", \"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:57:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1460, NULL, NULL, NULL, '10000054468', '', '', '94743867', 'Janice', 'Googins', '', '', '{\"DOB\": 18825, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1548372923\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"TOMPKINS, JODIE L\", \"Rank_All\": 1, \"PCP_Phone\": \"2073583310\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9HM2JK5PH24\", \"Member_City\": \"WINDHAM\", \"Office_Name\": \"HELLO IN THERE IN HOME PRIMARY CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-07-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"ADULT NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Hello In There In Home Primary Care,62 Dawson St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2073706045\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"59 WHITE BRIDGE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"59 WHITE BRIDGE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Googins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Janice\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jagoogs@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\": \"2076538053\", \"Member_Identification_Number\": \"10000054468\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076538053\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-12-2026 13:55:31\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-12 13:55:31\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-12T13:55\", \"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-04T14:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T17:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T14:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T13: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\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T17:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T13:55\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:32\", \"value\": [{\"add\": \"59 WHITE BRIDGE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2076538053\", \"dob\": \"1951-07-16\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076538053\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDHAM\", \"gend\": 1, \"insh\": \"10000054468\", \"mzip\": \"04062\", \"name\": \"Janice M Googins\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TOMPKINS, JODIE L\", \"ppno\": \"2073583310\", \"cliId\": \"\", \"email\": \"jagoogs@gmail.com\", \"ename\": \"\", \"madd1\": \"59 WHITE BRIDGE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Hello In There In Home Primary Care,62 Dawson St\", \"pcpnpi\": \"1548372923\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"HELLO IN THERE IN HOME PRIMARY CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073706045\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9HM2JK5PH24\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 12:20 PM\", \"result\": 3, \"comment\": \"called to schedule w/ Jennifer Landry\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 05:05 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 05:24 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 04:58 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9 or 3/20\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 01:11 PM\", \"result\": 3, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:57 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 10:29 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 01:01 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 02:06 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 2/24/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 01:55 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:23 PM\", \"result\": 3, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, MAILBOX FULL\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 11:11 AM\", \"result\": 3, \"comment\": \"o/c to schedule w/Sandy in March 9\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 11:11 AM\"}, {\"date\": \"2/6/2026 @ 05:13 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra Mailbox full.  \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/11/2026 @ 05:13 PM\"}, {\"date\": \"2/4/2026 @ 01:12 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; Left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 01:11 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 13:12:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-12-2026 13:55:31\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 15}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1461, NULL, NULL, NULL, '10000054502', '', '', '52661009', 'Barry', 'Bisco', '', '', '{\"DOB\": 19126, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1467094656\", \"Pcp_Zip\": \"04055\", \"Program\": \"Medicare\", \"Pcp_City\": \"Naples\", \"Pcp_Name\": \"SAUCIER, NICOLE M\", \"Rank_All\": 1, \"PCP_Phone\": \"2076936106\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6W54FV3RF60\", \"Member_City\": \"CASCO\", \"Office_Name\": \"NAPLES FAMILY PRACTICE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CASCO\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-05-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Naples Family Practice,410 Roosevelt Trl\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076934026\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"13 ROCKY TOP RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04015\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 281\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04015\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bisco\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Barry\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076277393\", \"Member_Identification_Number\": \"10000054502\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-22-2026 18:56:38\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}', '{\"date\": \"2026-03-22 18:56:38\", \"hrastatus\": \"\", \"reportstatus\": \"Wrong Number\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2026-03-22T18:56\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-06T11:56\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-09T11:26\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-10T12:49\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-11T19:54\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-19T17:09\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-25T16:12\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-06T13:28\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-09T11:57\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-12T10:18\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-12T14:45\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-14T15:47\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-20T11:54\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T11:26\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T19:54\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T17:09\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T16:12\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T11:57\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-14T15:47\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-22T18:56\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:34\", \"value\": [{\"add\": \"13 ROCKY TOP RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-05-12\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076277393\", \"zip\": \"04015\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CASCO\", \"gend\": 0, \"insh\": \"10000054502\", \"mzip\": \"04015\", \"name\": \"Barry L Bisco\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SAUCIER, NICOLE M\", \"ppno\": \"2076936106\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 281\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CASCO\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Naples Family Practice,410 Roosevelt Trl\", \"pcpnpi\": \"1467094656\", \"pcpzip\": \"04055\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Naples\", \"pcpname\": \"NAPLES FAMILY PRACTICE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076934026\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6W54FV3RF60\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:34\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"3/22/2026 @ 06:56 PM\", \"result\": 4, \"comment\": \"Called to schedule virtual IHA Amanda Milliken -Wrong Number  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 11:54 AM\", \"result\": 10, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 03:47 PM\", \"result\": 10, \"comment\": \"Call Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:45 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 10:18 AM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 08:57 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 10:28 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 04:12 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sandy 3/3\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 05:09 PM\", \"result\": 10, \"comment\": \"o/c to sched IHA w/Sandy 2/24\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 07:54 PM\", \"result\": 10, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, DISC\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 12:49 PM\", \"result\": 10, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 12:49 PM\"}, {\"date\": \"2/9/2026 @ 11:26 AM\", \"result\": 10, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/10/2026 @ 11:24 AM\"}, {\"date\": \"2/6/2026 @ 11:56 AM\", \"result\": 10, \"comment\": \"o/c to schedule w/Sandy 2/19\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 11:56 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 11:56:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-22-2026 18:56:38\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"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:57:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1462, NULL, NULL, NULL, '10000054520', '', '', '1019044', 'Alice', 'Persons', 'English', '', '{\"DOB\": 19107, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1558521807\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"GRZYSIEWICZ, AMY\", \"Rank_All\": 1, \"PCP_Phone\": \"2074394430\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3WN8CM7NA29\", \"Member_City\": \"WESTBROOK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WESTBROOK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-04-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"16 WALTON ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04092\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"16 WALTON ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04092\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Persons\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alice\", \"Member_Middle_name\": \"N\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"moonpiepress@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\": \"2077761045\", \"Member_Identification_Number\": \"10000054520\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 15:13:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-04-07 15:13:58\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-26T12:00\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-04-07T12:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-04-07T15:13\", \"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-05T11:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T18:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T14:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T10:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-26T12:00\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T11:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T18:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T14:53\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-26T12:00\", \"reportStatus_date\": \"2026-02-26T12:00\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-04-07T15:13\", \"reportStatus_date\": \"2026-04-07T15:13\"}]', '{\"utc\": [{\"date\": \"2026-02-26T12:00\", \"username\": \"KCoash\"}, {\"date\": \"2026-04-07T15:13\", \"username\": \"RDodoye\"}], \"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:08:35\", \"value\": [{\"add\": \"16 WALTON ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-04-23\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077761045\", \"zip\": \"04092\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WESTBROOK\", \"gend\": 1, \"insh\": \"10000054520\", \"mzip\": \"04092\", \"name\": \"Alice N Persons\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GRZYSIEWICZ, AMY\", \"ppno\": \"2074394430\", \"cliId\": \"\", \"email\": \"moonpiepress@yahoo.com\", \"ename\": \"\", \"madd1\": \"16 WALTON ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WESTBROOK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1558521807\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3WN8CM7NA29\", \"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:57:34\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:35\"}', '{\"utc\": [{\"date\": \"2026-02-26T12:00\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-04-07T15:13\", \"type\": null, \"subStaus\": \"\", \"username\": \"RDodoye\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"4/7/2026 @ 03:13 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Cindy but need call back  later on this year \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 09:01 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"member called in - not interested now but ok to c/b in Late July\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 10:23 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 02:53 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/26/2026 @ 02:53 PM\"}, {\"date\": \"2/10/2026 @ 06:53 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/13/2026 @ 06:53 PM\"}, {\"date\": \"2/5/2026 @ 11:03 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 @ 11:03 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 11:03:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"04-07-2026 12:01:56\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:34', 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
(1463, NULL, NULL, NULL, '10000054593', '', '', NULL, 'Susan', 'Pascarella', '', '', '{\"DOB\": 19062, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1841569720\", \"Pcp_Zip\": \"41062351\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"LAVALLEE, HEATHER A\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2TV8JF0PN35\", \"Member_City\": \"WINDHAM\", \"Office_Name\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-09\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"100 FODEN ROAD,WEST BUILDING SUITE 103\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078280188\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"117 WINDHAM CENTER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"117 WINDHAM CENTER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Pascarella\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Susan\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"sue.pasco@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\": \"2073184994\", \"Member_Identification_Number\": \"10000054593\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:21:40\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:21:40\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:21\", \"reportStatus_date\": \"2026-02-03T06:21\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:21\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:37\", \"value\": [{\"add\": \"117 WINDHAM CENTER RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-03-09\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073184994\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDHAM\", \"gend\": 1, \"insh\": \"10000054593\", \"mzip\": \"04062\", \"name\": \"Susan D Pascarella\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LAVALLEE, HEATHER A\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"sue.pasco@gmail.com\", \"ename\": \"\", \"madd1\": \"117 WINDHAM CENTER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN ROAD,WEST BUILDING SUITE 103\", \"pcpnpi\": \"1841569720\", \"pcpzip\": \"41062351\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078280188\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2TV8JF0PN35\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:34\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:37\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:21\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/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:37:17\", \"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:57:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1464, NULL, NULL, NULL, '10000054655', '', '', '52661009', 'Virginia', 'Porter', '', '', '{\"DOB\": 18573, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1659876571\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"CATHCART, SCOTT\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6DA2P55HT93\", \"Member_City\": \"STANDISH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"STANDISH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-11-06\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Intermed,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\": \"651 SACO RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04084\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"651 SACO RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04084\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Porter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Virginia\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076422259\", \"Member_Identification_Number\": \"10000054655\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-16-2026 01:26:22\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-16 01:26:22\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T11:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T17:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T14:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-11T16:23\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2026-02-16T01:26\", \"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-06T17:56\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-16T01:26\", \"reportStatus_date\": \"2026-02-16T01:26\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-11T16:23\", \"username\": \"JCopeland\"}, {\"date\": \"2026-02-16T01:26\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:39\", \"value\": [{\"add\": \"651 SACO RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-11-06\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076422259\", \"zip\": \"04084\", \"add2\": \"\", \"add3\": \"\", \"city\": \"STANDISH\", \"gend\": 1, \"insh\": \"10000054655\", \"mzip\": \"04084\", \"name\": \"Virginia M Porter\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CATHCART, SCOTT\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"651 SACO RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"STANDISH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Intermed,84 Marginal Way Ste 700\", \"pcpnpi\": \"1659876571\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6DA2P55HT93\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:34\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:39\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-11T16:23\", \"type\": null, \"subStaus\": \"\", \"username\": \"JCopeland\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-02-16T01:26\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": \"9\", \"callLog\": [{\"date\": \"2/11/2026 @ 04:23 PM\", \"result\": 9, \"comment\": \"02/11/2026- F2F HRA WITH Sandra Cadwell, REFUSAL \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 02:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/17/2026 @ 02:43 PM\"}, {\"date\": \"2/6/2026 @ 05:56 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 05:56 PM\"}, {\"date\": \"2/4/2026 @ 11:21 AM\", \"result\": 1, \"comment\": \"calling to sched IHA w/Sandy for 2/5/26\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 11:21 AM\"}, {\"date\": \"2/3/2026 @ 11:58 AM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"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:21:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"01-31-2026 23:37:18\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1465, NULL, NULL, NULL, '10000054678', '', '', '94743867', 'Philip', 'House', '', '', '{\"DOB\": 18421, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1679884522\", \"Pcp_Zip\": \"42107813\", \"Program\": \"Medicare\", \"Pcp_City\": \"AUBURN\", \"Pcp_Name\": \"DUQUETTE, ADAM\", \"Rank_All\": 1, \"PCP_Phone\": \"2077847388\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4Y21U11NP22\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"FAMILY HEALTH CARE ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-06-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"190 STETSON RD,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077952043\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"20 GREAT FALLS PLAZA APT 210\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"20 GREAT FALLS PLAZA APT 210\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"House\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Philip\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"house7685@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077838895\", \"Member_Identification_Number\": \"10000054678\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 13:36:42\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-25 13:36:42\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-25T13:36\", \"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-05T13:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T14:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T14:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T13:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-10T10:17\", \"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-09T14:26\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T10:17\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-25T13:36\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:40\", \"value\": [{\"add\": \"20 GREAT FALLS PLAZA APT 210\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-06-07\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077838895\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 0, \"insh\": \"10000054678\", \"mzip\": \"04210\", \"name\": \"Philip D House\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DUQUETTE, ADAM\", \"ppno\": \"2077847388\", \"cliId\": \"\", \"email\": \"house7685@roadrunner.com\", \"ename\": \"\", \"madd1\": \"20 GREAT FALLS PLAZA APT 210\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"190 STETSON RD,\", \"pcpnpi\": \"1679884522\", \"pcpzip\": \"42107813\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"AUBURN\", \"pcpname\": \"FAMILY HEALTH CARE ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077952043\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4Y21U11NP22\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 11:51 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/13\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 02:29 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 4/13\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 09:23 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 12:12 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 11:55 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 01:41 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/22/2026 @ 07:03 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA with Amanda Milliken -LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 12:51 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:40 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 09:41 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 08:25 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 08:37 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 01:36 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 10:17 AM\", \"result\": 14, \"comment\": \"Called to Schedule F2F HRA with Sandra but member need a call back. member was skepital we did not have the correct address its been updated and he ONLY wants Virtual no F2F \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/19/2026 @ 10:17 AM\"}, {\"date\": \"2/9/2026 @ 01:26 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 01:25 PM\"}, {\"date\": \"2/6/2026 @ 02:11 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/9/2026 @ 02:11 PM\"}, {\"date\": \"2/5/2026 @ 12:48 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/10; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/10/2026 @ 12:47 PM\"}, {\"date\": \"1/29/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 12:48:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-25-2026 13:36:42\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 18}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1466, NULL, NULL, NULL, '10000054684', '', '', '47262451', 'Lynn', 'Whitney', '', '', '{\"DOB\": 19018, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1720022866\", \"Pcp_Zip\": \"04614\", \"Program\": \"Medicare\", \"Pcp_City\": \"Blue Hill\", \"Pcp_Name\": \"LESKO, LISA A\", \"Rank_All\": 1, \"PCP_Phone\": \"2073742311\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4XH8GP4DW42\", \"Member_City\": \"HARBORSIDE\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE BLUE HILL\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"HARBORSIDE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-01-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Blue Hill Family Medicine,57 Water St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"2073742618\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1028 CAPE ROSIER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04642\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1028 CAPE ROSIER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04642\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Whitney\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lynn\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"zekespoint@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\": \"2073269051\", \"Member_Identification_Number\": \"10000054684\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074795484\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-16-2026 01:26:20\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-16 01:26:20\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-06T12:41\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2026-02-16T01:26\", \"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-06T12:41\", \"reportStatus_date\": \"2026-02-06T12:41\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-16T01:26\", \"reportStatus_date\": \"2026-02-16T01:26\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-06T12:41\", \"username\": \"LAnguiano\"}, {\"date\": \"2026-02-16T01:26\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:41\", \"value\": [{\"add\": \"1028 CAPE ROSIER RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2074795484\", \"dob\": \"1952-01-25\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073269051\", \"zip\": \"04642\", \"add2\": \"\", \"add3\": \"\", \"city\": \"HARBORSIDE\", \"gend\": 1, \"insh\": \"10000054684\", \"mzip\": \"04642\", \"name\": \"Lynn E Whitney\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LESKO, LISA A\", \"ppno\": \"2073742311\", \"cliId\": \"\", \"email\": \"zekespoint@gmail.com\", \"ename\": \"\", \"madd1\": \"1028 CAPE ROSIER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"HARBORSIDE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Blue Hill Family Medicine,57 Water St\", \"pcpnpi\": \"1720022866\", \"pcpzip\": \"04614\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Blue Hill\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE BLUE HILL\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073742618\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4XH8GP4DW42\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:41\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-06T12:41\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-02-16T01:26\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": \"9\", \"callLog\": [{\"date\": \"2/6/2026 @ 12:41 PM\", \"result\": 9, \"comment\": \"Per n otes in 5-9 member refused 2-3-2026 with Mary Carmen \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 11:50 AM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Mary Carmen Valdez\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 12:41:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"01-31-2026 23:37:18\", \"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:57:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1467, NULL, NULL, NULL, '10000054781', '', '', '1019044', 'Patrick', 'Ducale', 'English', '', '{\"DOB\": 19120, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1659865970\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"FLORY, ELIZABETH\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1TJ9QM8DN46\", \"Member_City\": \"Long Island\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Long Island\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-05-06\", \"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\": \"2077984018\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"974 ISLAND AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04050\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"974 ISLAND AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04050\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Ducale\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Patrick\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072328814\", \"Member_Identification_Number\": \"10000054781\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-06-2026 15:22:16\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-06 15:22:16\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T10:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T18:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-06T15:22\", \"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-13T13:52\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:21\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T13:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-17T10:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T18:29\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-06T15:22\", \"reportStatus_date\": \"2026-03-06T15:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-06T15:22\", \"username\": \"LAnguiano\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:44\", \"value\": [{\"add\": \"974 ISLAND AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-05-06\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072328814\", \"zip\": \"04050\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Long Island\", \"gend\": 0, \"insh\": \"10000054781\", \"mzip\": \"04050\", \"name\": \"Patrick J Ducale\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FLORY, ELIZABETH\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"974 ISLAND AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Long Island\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1659865970\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077984018\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1TJ9QM8DN46\", \"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:57:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:44\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-06T15:22\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/6/2026 @ 03:22 PM\", \"result\": 9, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- Patrick refused for the year \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 06:29 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 10:55 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/24/2026 @ 10:55 AM\"}, {\"date\": \"2/13/2026 @ 01:52 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Leana but member requested a call back member wife said he was unavaible but was not intrested will call back to speak with member   \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/18/2026 @ 01:51 PM\"}, {\"date\": \"2/3/2026 @ 11:54 AM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Mary Carmen Valdez\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-13-2026 13:52:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"01-31-2026 23:37:18\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:35', 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
(1468, NULL, NULL, NULL, '10000054808', '', '', '52661009', 'Richard', 'Emery', 'English', '', '{\"DOB\": 19172, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1447328125\", \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"CAREY, SEAN P\", \"Rank_All\": 1, \"PCP_Phone\": \"2078392559\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9QR8E93CN22\", \"Member_City\": \"BUXTON\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BUXTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-06-27\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,575 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2075231135\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"45 MARY JANE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04093\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"45A MARY JANE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04093\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Emery\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"inspro@sacoriver.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076328572\", \"Member_Identification_Number\": \"10000054808\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 13:48:08\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-03 13:48:08\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T16:56\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-03T13:48\", \"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-04T10:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T09:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T20:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T16:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T12:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T20:03\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T16:56\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-03T13:48\", \"reportStatus_date\": \"2026-03-03T13:48\"}]', '{\"utc\": [{\"date\": \"2026-03-03T13:48\", \"username\": \"KCoash\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:08:45\", \"value\": [{\"add\": \"45 MARY JANE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-06-27\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076328572\", \"zip\": \"04093\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BUXTON\", \"gend\": 0, \"insh\": \"10000054808\", \"mzip\": \"04093\", \"name\": \"Richard B Emery\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CAREY, SEAN P\", \"ppno\": \"2078392559\", \"cliId\": \"\", \"email\": \"inspro@sacoriver.net\", \"ename\": \"\", \"madd1\": \"45A MARY JANE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BUXTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,575 Main St\", \"pcpnpi\": \"1447328125\", \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075231135\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9QR8E93CN22\", \"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:57:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:45\"}', '{\"utc\": [{\"date\": \"2026-03-03T13:48\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:00 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Pamela Kratzer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 11:08 AM\", \"result\": 3, \"comment\": \"called to schedule w/ kathryn baxter \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:48 PM\", \"result\": 6, \"comment\": \"c/b in July/August - member not interested now\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 12:52 PM\", \"result\": 3, \"comment\": \"called member back as he called in \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 03:23 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 @ 04:56 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 08:03 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 @ 09:36 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/17/2026 @ 09:36 AM\"}, {\"date\": \"2/6/2026 @ 12:44 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 12:43 PM\"}, {\"date\": \"2/4/2026 @ 10:45 AM\", \"result\": 3, \"comment\": \"calling to sched IHA w/Sandy for 2/5/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 10:45 AM\"}, {\"date\": \"2/3/2026 @ 02:36 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 10:45:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-24-2026 16:56:59\", \"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:57:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1469, NULL, NULL, NULL, '10000054868', '', '', NULL, 'Karen', 'Boyer', '', '', '{\"DOB\": 18657, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1164653879\", \"Pcp_Zip\": \"42407676\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"FAGONE, RENEE S\", \"Rank_All\": 1, \"PCP_Phone\": \"2077955700\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2X90M75YC09\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-01-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"ADULT NURSE PRACTITIONER\", \"Pcp_Address_1\": \"12 HIGH ST,SUITE 400\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077955727\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"64 CLEVELAND AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"64 CLEVELAND AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Boyer\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Karen\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077845244\", \"Member_Identification_Number\": \"10000054868\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2075775376\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:22:44\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:44\", \"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:08:46\", \"value\": [{\"add\": \"64 CLEVELAND AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2075775376\", \"dob\": \"1951-01-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077845244\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 1, \"insh\": \"10000054868\", \"mzip\": \"04210\", \"name\": \"Karen S Boyer\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FAGONE, RENEE S\", \"ppno\": \"2077955700\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"64 CLEVELAND AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"12 HIGH ST,SUITE 400\", \"pcpnpi\": \"1164653879\", \"pcpzip\": \"42407676\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077955727\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2X90M75YC09\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:57:36\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:08:46\"}', '{\"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/21/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:37:19\", \"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:57:36', 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
(1470, 62035418, 44829497, '22140773', '10000054881', '', '', '14035267', 'Jeannine', 'Brooks', 'English', '', '{\"DOB\": 18809, \"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\": \"1396856944\", \"Pcp_Zip\": \"04243\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"SALLY SCHWARZE\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073300\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1KN4AA3EM08\", \"Member_City\": \"DIXMONT\", \"Office_Name\": \"ST JOSEPH INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DIXMONT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-06-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"PO BOX 7291\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2077778800\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"151 JEWEL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04932\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"151 JEWEL RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04932\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brooks\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jeannine\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"jnine1951@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2072302924\", \"Member_Identification_Number\": \"10000054881\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074168775\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:22:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:22:37\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T17:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-12T19:50\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-21T15:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-21T23:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-09T11:55\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-12T06:25\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-06T12:35\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-09T11:55\", \"reportStatus_date\": \"2026-02-09T11:55\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-12T19:50\", \"reportStatus_date\": \"2026-02-12T19:50\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-21T23:24\", \"reportStatus_date\": \"2026-02-21T23:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:22\", \"reportStatus_date\": \"2026-03-03T17:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:22\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-09T11:55\", \"username\": null}, {\"date\": \"2026-02-09T11:55\", \"username\": \"jsmith\"}], \"inProgress\": [{\"date\": \"2026-02-12T06:25\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-13T13:45\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-20T11:16\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-12T19:50\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-12T19:50\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-21T23:24\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-21T15:45\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-21T23:24\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-18-2026\", \"time\": \"14:52:47\", \"value\": [{\"add\": \"151 JEWEL RD\", \"age\": 74, \"ano\": \"\", \"cno\": \"2074168775\", \"dob\": \"1951-06-30\", \"eno\": \"2072342924\", \"lob\": \"GA - 2026\", \"pno\": \"2072302924\", \"zip\": \"04932\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DIXMONT\", \"gend\": 1, \"insh\": \"10000054881\", \"mzip\": \"04932\", \"name\": \"Jeannine M Brooks\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SALLY SCHWARZE\", \"ppno\": \"2079073300\", \"race\": \"\", \"cliId\": \"\", \"email\": \"jnine1951@gmail.com\", \"ename\": \"Charles Brooks - husband\", \"madd1\": \"151 JEWEL RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DIXMONT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 7291\", \"pcpnpi\": \"1396856944\", \"pcpzip\": \"04243\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"ST JOSEPH INTERNAL MEDICINE\", \"program\": \"Medicare\", \"evalDate\": \"2026-2-12 3:00 PM\", \"evalName\": \"Erin Barker, FNP\", \"pcpfaxno\": \"2077778800\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"1KN4AA3EM08\", \"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\": \"02-12-2026\", \"time\": \"06:25:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-18-2026 14:52:47\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/9/2026 @ 11:55 AM\", \"result\": 0, \"comment\": \"F2F scheduled w/ Erin Barker 2/12/2026 at 3PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 12:35 PM\", \"result\": 10, \"comment\": \"Called to schedule IHA w/ martins point -disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/9/2026 @ 12:35 PM\"}, {\"date\": \"2/4/2026 @ 02:10 PM\", \"result\": 3, \"comment\": \" called to schedule face to face \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/11/2026 @ 02:10 PM\"}, {\"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\": {\"type\": \"visitType\", \"memberId\": \"10000054881\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": \"10000054881\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": \"10000054881\", \"scheduleDate\": \"2026-2-12T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 14:10:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"02-09-2026 11:55:57\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:22:36\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"c10f04fd-e519-45a5-b1c8-31f4c755bdca\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"c10f04fd-e519-45a5-b1c8-31f4c755bdca\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:28:03.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\\\":282,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":282,\\\"start_timestamp\\\":\\\"2026-03-03T22:22:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:28:03.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-12T15:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:57:36', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000054881\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Brooks_10000054881_02122026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:22:35\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000054881.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Brooks_10000054881_02122026.pdf', NULL, 'Summary_10000054881.pdf', NULL, '[{\"date\": \"2026-02-13T00:50:28.688Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-12T16:46', 'Member_Summary_10000054881.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000054881\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000054881.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:22:36\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
