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
(2845, NULL, NULL, NULL, '10000011380', '', '', '66650973', 'Dalton', 'Scovil', '', '', '{\"DOB\": 11222, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"\", \"Program\": \"Medicare\", \"Pcp_City\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Medicare_ID\": \"6EJ1DT1MC97\", \"Member_City\": \"BLAINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BLAINE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1930-09-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Aroostook\", \"Member_Country\": \"Aroostook\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"46 MILITARY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04734\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 273\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04734\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Scovil\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dalton\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"DECLINED@01262026.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077689192\", \"Member_Identification_Number\": \"10000011380\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2075517441\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 18:32:06\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}', '{\"date\": \"2026-02-25 18:32:06\", \"hrastatus\": \"\", \"reportstatus\": \"Wrong Number\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2026-02-25T18:32\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-25T18:32\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:45:46\", \"value\": [{\"add\": \"46 MILITARY RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2075517441\", \"dob\": \"1930-09-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077689192\", \"zip\": \"04734\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BLAINE\", \"gend\": 0, \"insh\": \"10000011380\", \"mzip\": \"04734\", \"name\": \"Dalton L Scovil\", \"plan\": \"Martin\'s Point\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"DECLINED@01262026.COM\", \"ename\": \"\", \"madd1\": \"PO BOX 273\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BLAINE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6EJ1DT1MC97\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:35:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:45:46\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"2/25/2026 @ 06:32 PM\", \"result\": 4, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:32:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-25-2026 18:32:07\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:35:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2846, NULL, NULL, NULL, '10000013189', '', '', '66650973', 'Sharron', 'Boyd', '', '', '{\"DOB\": 17059, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1265404867\", \"Pcp_Zip\": \"04983\", \"Program\": \"Medicare\", \"Pcp_City\": \"Strong\", \"Pcp_Name\": \"BESSE, MADELYN\", \"Rank_All\": 1, \"PCP_Phone\": \"2076844010\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2CA9G91AH15\", \"Member_City\": \"STRONG\", \"Office_Name\": \"STRONG AREA HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"STRONG\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-09-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"Strong Area Health Center,177 North Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Franklin\", \"Member_Country\": \"Franklin\", \"PCP_Fax_Number\": \"2076843368\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"58 NORTON HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04983\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 11\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04983\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Boyd\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sharron\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2074911191\", \"Member_Identification_Number\": \"10000013189\", \"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 18:10:18\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-03 18:10:18\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-03T18:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T18:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T13:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T11:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T17:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T18: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\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-03-02T17:35\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T18:10\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:46:38\", \"value\": [{\"add\": \"58 NORTON HILL RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-09-14\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074911191\", \"zip\": \"04983\", \"add2\": \"\", \"add3\": \"\", \"city\": \"STRONG\", \"gend\": 1, \"insh\": \"10000013189\", \"mzip\": \"04983\", \"name\": \"Sharron Boyd\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BESSE, MADELYN\", \"ppno\": \"2076844010\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 11\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"STRONG\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Strong Area Health Center,177 North Main St\", \"pcpnpi\": \"1265404867\", \"pcpzip\": \"04983\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Strong\", \"pcpname\": \"STRONG AREA HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076843368\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2CA9G91AH15\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:36:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:46:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/16/2026 @ 10:03 AM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 03:40 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 07:05 PM\", \"result\": 3, \"comment\": \"03/04/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 06:10 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 05:35 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/6/2026 @ 05:35 PM\"}, {\"date\": \"2/27/2026 @ 11:03 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 11:03 AM\"}, {\"date\": \"2/26/2026 @ 01:19 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/2/2026 @ 01:18 PM\"}, {\"date\": \"2/25/2026 @ 06:34 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:34:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-03-2026 18:10:18\", \"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', '23-02-2026 11:36:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2847, NULL, NULL, NULL, '10000015861', '', '', '66650973', 'Kenneth', 'Buckley', '', '', '{\"DOB\": 11850, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1578057675\", \"Pcp_Zip\": \"42437291\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"RANNIE, MAX L\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073777\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1XD1YF1YY39\", \"Member_City\": \"BANGOR\", \"Office_Name\": \"NORTHERN LIGHT FAMILY MEDICINE AND RESIDENCY\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BANGOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1932-06-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"C/O ST MARYS HEALTH SYSTEM-PROVIDER ENROLLMENT,PO BOX 7291\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079073778\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"207 FOREST AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04401\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"207 FOREST AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04401\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Buckley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kenneth\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 46024, \"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\": \"2075731140\", \"Member_Identification_Number\": \"10000015861\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-03-2026 11:56:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-04-03 11:56:24\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-14T11:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-04-03T11:56\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-14T11:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-25T18:36\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-05T11:25\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-09T12:57\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-10T11:17\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-12T12:40\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-25T18:36\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T12:57\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-14T11:32\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-04-03T11:56\", \"reportStatus_date\": \"2026-04-03T11:56\"}]', '{\"utc\": [{\"date\": \"2026-04-03T11:56\", \"username\": \"LStewart\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:47:39\", \"value\": [{\"add\": \"207 FOREST AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1932-06-10\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075731140\", \"zip\": \"04401\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BANGOR\", \"gend\": 0, \"insh\": \"10000015861\", \"mzip\": \"04401\", \"name\": \"Kenneth D Buckley\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RANNIE, MAX L\", \"ppno\": \"2079073777\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"207 FOREST AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BANGOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"C/O ST MARYS HEALTH SYSTEM-PROVIDER ENROLLMENT,PO BOX 7291\", \"pcpnpi\": \"1578057675\", \"pcpzip\": \"42437291\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"NORTHERN LIGHT FAMILY MEDICINE AND RESIDENCY\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079073778\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1XD1YF1YY39\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:36:49\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:47:39\"}', '{\"utc\": [{\"date\": \"2026-04-03T11:56\", \"type\": null, \"subStaus\": \"\", \"username\": \"LStewart\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"4/7/2026 @ 01:52 PM\", \"result\": 7, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 11:56 AM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Sandra Caldwell or Erin Barker - member is not home \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 02:06 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:43 PM\", \"result\": 7, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 11:32 AM\", \"result\": 7, \"comment\": \"Called to schedule virtual with Amanda, Line is busy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 12:40 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 11:17 AM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Erin B\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/11/2026 @ 11:17 AM\"}, {\"date\": \"3/9/2026 @ 12:57 PM\", \"result\": 10, \"comment\": \"o/c to sched w/Erin\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/11/2026 @ 12:57 PM\"}, {\"date\": \"3/5/2026 @ 11:25 AM\", \"result\": 10, \"comment\": \"o/c to sched w/Erin B 3/9\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/6/2026 @ 11:25 AM\"}, {\"date\": \"2/25/2026 @ 06:36 PM\", \"result\": 10, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:36 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:36:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-14-2026 11:32:05\", \"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', '23-02-2026 11:36:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2848, NULL, NULL, NULL, '10000018795', '', '', '66650973', 'Eugene', 'Morton', '', '', '{\"DOB\": 15217, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1053805309\", \"Pcp_Zip\": \"04416\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bucksport\", \"Pcp_Name\": \"SHAWLEY, HEIDI\", \"Rank_All\": 1, \"PCP_Phone\": \"2074697371\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4E25AT6TJ60\", \"Member_City\": \"BUCKSPORT\", \"Office_Name\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BUCKSPORT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1941-08-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Bucksport Regional Health Center,110 Broadway Bucksport\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"53 BAXTER BLVD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04416\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"53 BAXTER BLVD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04416\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Morton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Eugene\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Mtmike67@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077456098\", \"Member_Identification_Number\": \"10000018795\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077456098\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-27-2026 13:00:09\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-27 13:00:09\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-27T11:42\", \"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-25T18:41\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-27T13:00\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-27T13:00\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:48:58\", \"value\": [{\"add\": \"53 BAXTER BLVD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2077456098\", \"dob\": \"1941-08-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077456098\", \"zip\": \"04416\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BUCKSPORT\", \"gend\": 0, \"insh\": \"10000018795\", \"mzip\": \"04416\", \"name\": \"Eugene Morton\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SHAWLEY, HEIDI\", \"ppno\": \"2074697371\", \"cliId\": \"\", \"email\": \"Mtmike67@yahoo.com\", \"ename\": \"\", \"madd1\": \"53 BAXTER BLVD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BUCKSPORT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Bucksport Regional Health Center,110 Broadway Bucksport\", \"pcpnpi\": \"1053805309\", \"pcpzip\": \"04416\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bucksport\", \"pcpname\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4E25AT6TJ60\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:37:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:48:58\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/27/2026 @ 01:00 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Nicole but member requested a call back has a home health nurse that comes in every day almost  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"9/2/2026 @ 01:00 PM\"}, {\"date\": \"2/27/2026 @ 11:42 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"3/2/2026 @ 11:41 AM\"}, {\"date\": \"2/25/2026 @ 06:41 PM\", \"result\": 6, \"comment\": \"Michael answered the phone and stated he will have to call back to schedule a virtual w/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:40 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:41:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-24-2026 23:45:19\", \"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', '23-02-2026 11:37:24', 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
(2849, 57818338, 44829497, '12383693', '10000019503', '', '', '47262451', 'Paul', 'Stanton', 'English', '', '{\"DOB\": 14653, \"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\": 1932133592, \"Pcp_Zip\": \"04988\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Unity\", \"Pcp_Name\": \"JONATHAN GASPER\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9XF1W50QV20\", \"Member_City\": \"FAIRFIELD\", \"Office_Name\": \"NORTHERN LIGHT HEALTH CENTER UNITY\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FAIRFIELD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-02-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"80 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Somerset\", \"Member_Country\": \"Somerset\", \"PCP_Fax_Number\": 2076243845, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"3 SAVAGE ST LOT 2\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04937\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 SAVAGE ST LOT 2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04937\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Stanton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Paul\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@11012022.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2073141229, \"Member_Identification_Number\": \"10000019503\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:11:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:11:48\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-12T17:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-11T19:14\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-13T12:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-13T15:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-25T13:02\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-08T18:57\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-25T13:02\", \"reportStatus_date\": \"2026-02-25T13:02\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-03-08T18:57\", \"reportStatus_date\": \"2026-03-08T18:57\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-13T15:13\", \"reportStatus_date\": \"2026-03-13T15:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:11\", \"reportStatus_date\": \"2026-03-17T16:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:11\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-25T13:02\", \"username\": null}, {\"date\": \"2026-02-25T13:02\", \"username\": \"LAnguiano\"}], \"inProgress\": [{\"date\": \"2026-03-08T18:57\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-03-12T10:31\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-11T19:14\", \"username\": \"KBaxter\"}, {\"date\": \"2026-03-11T19:14\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-13T15:13\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-13T12:03\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-13T15:13\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-10-2026\", \"time\": \"16:32:20\", \"value\": [{\"add\": \"3 SAVAGE ST LOT 2\", \"age\": 86, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-02-12\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2073141229, \"zip\": \"04937\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FAIRFIELD\", \"gend\": 0, \"insh\": \"10000019503\", \"mzip\": \"04937\", \"name\": \"Paul L Stanton\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JONATHAN GASPER\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@11012022.com\", \"ename\": \"\", \"madd1\": \"3 SAVAGE ST LOT 2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FAIRFIELD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"80 Main St\", \"pcpnpi\": 1932133592, \"pcpzip\": \"04988\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"Unity\", \"pcpname\": \"NORTHERN LIGHT HEALTH CENTER UNITY\", \"program\": \"Medicare\", \"pcpfaxno\": 2076243845, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9XF1W50QV20\", \"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-08-2026\", \"time\": \"18:57:49\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 16:32:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/25/2026 @ 01:02 PM\", \"result\": 0, \"comment\": \"Member scheduled with Kathryn f2f 3-11-2026 1045 am daughter Neila will also be present -\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000019503\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": \"10000019503\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": \"10000019503\", \"scheduleDate\": \"2026-3-11T10:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 13:02:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-25-2026 13:02:16\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:11:48\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"7b1949e7-2a87-4292-9eba-8a3f34cfcc11\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"7b1949e7-2a87-4292-9eba-8a3f34cfcc11\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"207 624 3845\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:23:33.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":2,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":362,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:11:59.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:12:34.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:14:40.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:15:06.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":362,\\\"start_timestamp\\\":\\\"2026-03-17T20:17:22.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:23:33.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-11T10:45', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:37:33', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000019503\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Stanton_10000019503_03112026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:11:47\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000019503.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Stanton_10000019503_03112026.pdf', NULL, 'Summary_10000019503.pdf', NULL, '[{\"date\": \"2026-03-11T23:14:04.106Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-11T11:49', 'Member_Summary_10000019503.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000019503\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000019503.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:11:48\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2850, NULL, NULL, NULL, '10000019846', '', '', '47262451', 'Melody', 'Weeks', 'English', '', '{\"DOB\": 23849, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1982169702\", \"Pcp_Zip\": \"04105\", \"Program\": \"Medicare\", \"Pcp_City\": \"Falmouth\", \"Pcp_Name\": \"CAMPBELL, HANNA R\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7UA0YK9KG44\", \"Member_City\": \"OAKLAND\", \"Office_Name\": \"NORTHERN LIGHT MERCY PRIMARY CARE WEST FALMOUTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waterville\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1965-04-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"Northern Light Mercy Primary Care West Falmouth,75 Gray Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"119 GAGNON RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04963\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 2415\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04903\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Weeks\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melody\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rwmw@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2074657886\", \"Member_Identification_Number\": \"10000019846\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076927396\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-13-2026 12:52:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-13 12:52:20\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-13T12:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T13:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T14:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-06T13:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T11:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T12:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-26T14:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T11:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-13T12:52\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:49:32\", \"value\": [{\"add\": \"119 GAGNON RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2076927396\", \"dob\": \"1965-04-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074657886\", \"zip\": \"04963\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OAKLAND\", \"gend\": 1, \"insh\": \"10000019846\", \"mzip\": \"04903\", \"name\": \"Melody D Weeks\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CAMPBELL, HANNA R\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"rwmw@roadrunner.com\", \"ename\": \"\", \"madd1\": \"PO BOX 2415\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waterville\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Northern Light Mercy Primary Care West Falmouth,75 Gray Rd\", \"pcpnpi\": \"1982169702\", \"pcpzip\": \"04105\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Falmouth\", \"pcpname\": \"NORTHERN LIGHT MERCY PRIMARY CARE WEST FALMOUTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7UA0YK9KG44\", \"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\": \"02-23-2026\", \"time\": \"23:37:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:49:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"4/7/2026 @ 02:11 PM\", \"result\": 7, \"comment\": \"Called to schedule F2F HRA w/ Erin Barker\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 06:03 PM\", \"result\": 7, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 04:56 PM\", \"result\": 7, \"comment\": \"o/c to sched F2F w/Erin on 4/8\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 04:13 PM\", \"result\": 7, \"comment\": \"Called to schedule virtual with Amanda, Line busy  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 12:52 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 11:26 AM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Kathryn but line was busy.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/12/2026 @ 11:26 AM\"}, {\"date\": \"3/6/2026 @ 01:09 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/11/2026 @ 01:09 PM\"}, {\"date\": \"2/26/2026 @ 02:34 PM\", \"result\": 7, \"comment\": \"Called to Schedule F2F HRA with Kathryn but line was busy.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 02:34 PM\"}, {\"date\": \"2/25/2026 @ 01:05 PM\", \"result\": 7, \"comment\": \"Called to schedule IHA w/ martins point nurse Kathryn B- Line busy \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/27/2026 @ 01:05 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 13:05:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-13-2026 12:52:20\", \"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', '23-02-2026 11:37:38', 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
(2851, NULL, NULL, NULL, '10000024027', '', '', '66650973', 'Rebecca', 'Henderson', '', '', '{\"DOB\": 17386, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1487370466\", \"Pcp_Zip\": \"47653007\", \"Program\": \"Medicare\", \"Pcp_City\": \"Patten\", \"Pcp_Name\": \"ALLMAN, SARAH\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5A85YF6PX74\", \"Member_City\": \"Dover Foxcroft\", \"Office_Name\": \"KATAHDIN VALLEY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dover Foxcroft\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-08-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"529 S Patten Rd,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Piscataquis\", \"Member_Country\": \"Piscataquis\", \"PCP_Fax_Number\": \"2075282595\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"137 PARK ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04426\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"137 PARK ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04426\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Henderson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rebecca\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073169879\", \"Member_Identification_Number\": \"10000024027\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-12-2026 15:30:37\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-12 15:30:38\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-12T15:30\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-12T15:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-25T18:44\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-26T12:19\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-27T10:56\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-27T14:13\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-02T19:04\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-05T15:02\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-03-02T19:04\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T15:02\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-12T15:30\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:51:17\", \"value\": [{\"add\": \"137 PARK ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-08-07\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073169879\", \"zip\": \"04426\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Dover Foxcroft\", \"gend\": 1, \"insh\": \"10000024027\", \"mzip\": \"04426\", \"name\": \"Rebecca D Henderson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ALLMAN, SARAH\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"137 PARK ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dover Foxcroft\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"529 S Patten Rd,\", \"pcpnpi\": \"1487370466\", \"pcpzip\": \"47653007\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Patten\", \"pcpname\": \"KATAHDIN VALLEY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075282595\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5A85YF6PX74\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:38:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:51:17\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/6/2026 @ 04:16 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 01:56 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:43 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 05:04 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 03:30 PM\", \"result\": 1, \"comment\": \"o/c to sched virt w/Erin B 3/16\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 03:02 PM\", \"result\": 10, \"comment\": \"o/c to sched w/Erin B 3/19 \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 07:04 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:13 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 02:13 PM\"}, {\"date\": \"2/27/2026 @ 10:56 AM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 10:56 AM\"}, {\"date\": \"2/26/2026 @ 12:19 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/2/2026 @ 12:18 PM\"}, {\"date\": \"2/25/2026 @ 06:44 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:43 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:44:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-12-2026 15:30:37\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:38:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2852, NULL, NULL, NULL, '10000024905', '', '', '47262451', 'John', 'Fisher', 'English', '', '{\"DOB\": 18735, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1053059899\", \"Pcp_Zip\": \"49016565\", \"Program\": \"Medicare\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"STRUCK, LAUREN\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7RG7HG8MX62\", \"Member_City\": \"WATERVILLE\", \"Office_Name\": \"ELMWOOD PRIMARY CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WATERVILLE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-04-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"10 Water St Ste 202,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078773401\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"11 VILLAGE GREEN RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"11 VILLAGE GREEN RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Fisher\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"fisherjohn977@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078733871\", \"Member_Identification_Number\": \"10000024905\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 13:08:08\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-25 13:08:08\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-25T13:08\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-25T13:08\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:51:35\", \"value\": [{\"add\": \"11 VILLAGE GREEN RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-04-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078733871\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WATERVILLE\", \"gend\": 0, \"insh\": \"10000024905\", \"mzip\": \"04901\", \"name\": \"John C Fisher\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STRUCK, LAUREN\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"fisherjohn977@gmail.com\", \"ename\": \"\", \"madd1\": \"11 VILLAGE GREEN RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WATERVILLE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"10 Water St Ste 202,\", \"pcpnpi\": \"1053059899\", \"pcpzip\": \"49016565\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"ELMWOOD PRIMARY CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078773401\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7RG7HG8MX62\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:38:34\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:51:35\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/25/2026 @ 01:08 PM\", \"result\": 6, \"comment\": \"Called to schedule IHA w/ martins point nurse Kathryn B- call back in May member has alot of dr appts right now \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"5/1/2026 @ 01:07 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 13:08:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-24-2026 23:45: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', '23-02-2026 11:38:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2853, NULL, NULL, NULL, '10000025553', '', '', '52197563', 'James', 'Brown', '', '', '{\"DOB\": 16566, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1235152935\", \"Pcp_Zip\": \"04853\", \"Program\": \"Medicare\", \"Pcp_City\": \"North Haven\", \"Pcp_Name\": \"SCHUMACHER, GRETCHEN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078672021\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7N22VY7EW70\", \"Member_City\": \"NORTH HAVEN\", \"Office_Name\": \"NORTH HAVEN MEDICAL CLINIC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"NORTH HAVEN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-05-09\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"ADULT NURSE PRACTITIONER\", \"Pcp_Address_1\": \"North Haven Medical Clinic,135 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Knox\", \"Member_Country\": \"Knox\", \"PCP_Fax_Number\": \"2078672256\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"33 SMITH STREET\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04853\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"33 SMITH STREET\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04853\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"O\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"candace@americamail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078672221\", \"Member_Identification_Number\": \"10000025553\", \"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 18:25:28\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-03 18:25:28\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-03T18:25\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-26T11:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T10:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T11:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T18:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T18:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-03-02T18:03\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T18:25\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:51:52\", \"value\": [{\"add\": \"33 SMITH STREET\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-05-09\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078672221\", \"zip\": \"04853\", \"add2\": \"\", \"add3\": \"\", \"city\": \"NORTH HAVEN\", \"gend\": 0, \"insh\": \"10000025553\", \"mzip\": \"04853\", \"name\": \"James O Brown\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCHUMACHER, GRETCHEN\", \"ppno\": \"2078672021\", \"cliId\": \"\", \"email\": \"candace@americamail.com\", \"ename\": \"\", \"madd1\": \"33 SMITH STREET\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"NORTH HAVEN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"North Haven Medical Clinic,135 Main St\", \"pcpnpi\": \"1235152935\", \"pcpzip\": \"04853\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"North Haven\", \"pcpname\": \"NORTH HAVEN MEDICAL CLINIC\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078672256\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7N22VY7EW70\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:38:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:51:52\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 01:58 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, Mailbox Full  \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/30/2026 @ 12:29 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda Mailbox full.  \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 04:05 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, caller disconnected\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 12:47 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda Mailbox full.  \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 06:25 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 06:03 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/6/2026 @ 06:02 PM\"}, {\"date\": \"2/27/2026 @ 11:25 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"3/2/2026 @ 11:25 AM\"}, {\"date\": \"2/27/2026 @ 10:36 AM\", \"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 @ 10:35 AM\"}, {\"date\": \"2/26/2026 @ 11:55 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole Mailbox full.  \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 11:55 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-26-2026 11:55:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-03-2026 18:25:28\", \"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', '23-02-2026 11:38:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2854, NULL, NULL, NULL, '10000028042', '', '', '66650973', 'David', 'Olmstead', '', '', '{\"DOB\": 16954, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1366403412\", \"Pcp_Zip\": \"04416\", \"Program\": \"Medicare\", \"Pcp_City\": \"BUCKSPORT\", \"Pcp_Name\": \"BISWAS, SHUBHRANGSHU\", \"Rank_All\": 1, \"PCP_Phone\": \"2074697371\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9CT9NN2RU28\", \"Member_City\": \"BANGOR\", \"Office_Name\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BANGOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-06-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"BUCKSPORT REG HLTH CTR,110 BROADWAY PO BOX 447\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2074697306\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"44 HOGAN RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04401\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"25 MEADOW FARM RD 9\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04401\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Olmstead\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076315663\", \"Member_Identification_Number\": \"10000028042\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074796917\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 11:20:06\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-10 11:20:06\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-10T11:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T18:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T13:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T11:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-10T11:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-03-09T13:04\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-27T13:43\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T13:04\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-10T11:20\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:53:16\", \"value\": [{\"add\": \"44 HOGAN RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2074796917\", \"dob\": \"1946-06-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076315663\", \"zip\": \"04401\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BANGOR\", \"gend\": 0, \"insh\": \"10000028042\", \"mzip\": \"04401\", \"name\": \"David A Olmstead\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BISWAS, SHUBHRANGSHU\", \"ppno\": \"2074697371\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"25 MEADOW FARM RD 9\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BANGOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"BUCKSPORT REG HLTH CTR,110 BROADWAY PO BOX 447\", \"pcpnpi\": \"1366403412\", \"pcpzip\": \"04416\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BUCKSPORT\", \"pcpname\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074697306\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9CT9NN2RU28\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:39:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:53:16\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 01:54 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 12:00 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/31/2026 @ 02:09 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:59 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 11:34 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 12:42 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 11:20 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Erin B 3/13\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 01:04 PM\", \"result\": 10, \"comment\": \"o/c to sched w/Erin 3/13\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/10/2026 @ 01:04 PM\"}, {\"date\": \"3/5/2026 @ 11:28 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 3/9\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/6/2026 @ 11:28 AM\"}, {\"date\": \"2/27/2026 @ 01:43 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA F2F with Erin Barker \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"3/2/2026 @ 01:42 PM\"}, {\"date\": \"2/25/2026 @ 06:50 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 12:00 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:50:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-10-2026 11:20:06\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:39:10', 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
(2855, 71932120, 44829497, '17537038', '10000036344', '', '', '66650973', 'William', 'Hayes', 'English', '', '{\"DOB\": 19065, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"Pcp_Zip\": \"\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"\", \"Pcp_Name\": \"needs new PCP \", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Medicare_ID\": \"9W48WQ5XR26\", \"Member_City\": \"CARRABASSETT VALLEY\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"HAMPTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-12\", \"Mailing_State\": \"NH\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Rockingham\", \"Member_Country\": \"Franklin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2026-03-31\", \"Member_Address1\": \"3185 CARRABASSETT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04947\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"703 OCEAN BLVD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"03842\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Hayes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"WIREHAYES@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2076708312, \"Member_Identification_Number\": \"10000036344\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 14:11:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-07 14:11:09\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-14T15:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T18:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T12:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T11:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T17:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T14:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-14T15:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-30T16:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-30T19:50\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-31T18:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T21:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-07T14:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-26T13:01\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-25T11:14\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-30T15:13\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-02T12:33\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-02T12:33\", \"reportStatus_date\": \"2026-03-02T12:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T17:25\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-14T15:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-30T19:50\", \"reportStatus_date\": \"2026-03-30T19:50\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-31T21:02\", \"reportStatus_date\": \"2026-03-31T21:02\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-04-07T14:11\", \"reportStatus_date\": \"2026-04-07T14:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-04-07T14:11\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-26T13:01\", \"username\": null}, {\"date\": \"2026-02-26T13:01\", \"username\": \"cwasilak\"}, {\"date\": \"2026-03-25T11:14\", \"username\": null}, {\"date\": \"2026-03-25T11:14\", \"username\": \"FBeckford\"}], \"inProgress\": [{\"date\": \"2026-03-30T15:13\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-31T11:23\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-30T19:50\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-30T19:50\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-31T21:02\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-31T18:11\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-31T21:02\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-02T12:33\", \"username\": \"JDingle\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-30-2026\", \"time\": \"15:16:29\", \"value\": [{\"add\": \"3185 CARRABASSETT RD\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-03-12\", \"eno\": \"9782703714\", \"lob\": \"GA - 2026\", \"pno\": 2076708312, \"zip\": \"04947\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CARRABASSETT VALLEY\", \"gend\": 0, \"insh\": \"10000036344\", \"mzip\": \"03842\", \"name\": \"William A Hayes\", \"plan\": \"Martin\'s Point\", \"pphy\": \"needs new PCP \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"WIREHAYES@gmail.com\", \"ename\": \"Jasselyn Hayes \", \"madd1\": \"703 OCEAN BLVD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"HAMPTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"NH\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9W48WQ5XR26\", \"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-30-2026\", \"time\": \"12:55:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-30-2026 19:50:47\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-02T12:33\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 3, \"cancelText\": \"Per Travis to reschedule member w/ different provider, because Ta`shariah Robinson is unavailable.\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/25/2026 @ 11:14 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 30th at 03:00PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 03:45 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:43 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Erin B 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/13/2026 @ 02:42 PM\"}, {\"date\": \"3/9/2026 @ 05:25 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/10/2026 @ 05:25 PM\"}, {\"date\": \"3/5/2026 @ 11:59 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/10/2026 @ 11:59 AM\"}, {\"date\": \"3/2/2026 @ 12:34 PM\", \"result\": 3, \"comment\": \"Called member to reschedule appointment w/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/4/2026 @ 12:34 PM\"}, {\"date\": \"2/26/2026 @ 01:01 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Ta\'Sharia on March 4, 2026 at 11:00am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 06:52 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:52 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000036344\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000036344\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000036344\", \"scheduleDate\": \"2026-3-30T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:52:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}, {\"date\": \"03-02-2026 12:33:40\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-25-2026 11:14:22\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2026-04-07 14:11:07\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"25e436b2-32ad-11f1-b62f-8f5ca1812c67\\\",\\\"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-30T15:00', '2026-03-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:41:02', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000036344\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Hayes_10000036344_03302026.pdf\", \"ftp_upload_date\": \"2026-04-07 14:11:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000036344.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Hayes_10000036344_03302026.pdf', NULL, 'Summary_10000036344.pdf', NULL, '[{\"date\": \"2026-03-30T23:50:46.125Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-30T15:30', 'Member_Summary_10000036344.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000036344\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000036344.pdf\", \"member_ftp_upload_date\": \"2026-04-07 14:11:08\"}', 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
(2856, NULL, NULL, NULL, '10000038512', '', '', '66650973', 'Gilbert', 'Page', '', '', '{\"DOB\": 13818, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1083906622\", \"Pcp_Zip\": \"44021599\", \"Program\": \"Medicare\", \"Pcp_City\": \"BANGOR\", \"Pcp_Name\": \"LANGLEY, AMY A\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3GN8KP7XA29\", \"Member_City\": \"BANGOR\", \"Office_Name\": \"PENOBSCOT COMMUNITY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BANGOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1937-10-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"PO BOX 1599,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079470435\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"4 L ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04401\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4 L ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04401\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Page\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gilbert\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gilpage34@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\": \"2073853046\", \"Member_Identification_Number\": \"10000038512\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073853046\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-05-2026 11:32:03\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}', '{\"date\": \"2026-03-05 11:32:03\", \"hrastatus\": \"\", \"reportstatus\": \"Ineligible\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T18:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T13:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-03-05T11:32\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-27T13:45\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-03-05T11:32\", \"reportStatus_date\": \"2026-03-05T11:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-03-05T11:32\", \"username\": \"KCoash\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:58:39\", \"value\": [{\"add\": \"4 L ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2073853046\", \"dob\": \"1937-10-30\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073853046\", \"zip\": \"04401\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BANGOR\", \"gend\": 0, \"insh\": \"10000038512\", \"mzip\": \"04401\", \"name\": \"Gilbert H Page\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LANGLEY, AMY A\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"gilpage34@gmail.com\", \"ename\": \"\", \"madd1\": \"4 L ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BANGOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 1599,\", \"pcpnpi\": \"1083906622\", \"pcpzip\": \"44021599\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BANGOR\", \"pcpname\": \"PENOBSCOT COMMUNITY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079470435\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3GN8KP7XA29\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:41:31\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:58:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"3/5/2026 @ 11:32 AM\", \"result\": 2, \"comment\": \"o/c to sched w/Erin B 3/10 - member stated he had his HA already this year\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 01:45 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA F2F with Erin Barker \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"3/2/2026 @ 01:45 PM\"}, {\"date\": \"2/25/2026 @ 06:54 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:54 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:54:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-24-2026 23:45:20\", \"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', '23-02-2026 11:41:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2857, NULL, NULL, NULL, '10000041281', '', '', '1019044', 'Ann', 'Edwards', 'English', '', '{\"DOB\": 16890, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1164868964\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"MCBRADY, MEGAN E\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2T37UA0QG76\", \"Member_City\": \"NORTH YARMOUTH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"NORTH YARMOUTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-03-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238586\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"37 FAYVIEW LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04097\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"37 FAYVIEW LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04097\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Edwards\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ann\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tedward1@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\": \"2078293252\", \"Member_Identification_Number\": \"10000041281\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 15:53:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-10 15:53:07\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-10T15:53\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T12:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T13:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T16:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T15:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-10T15:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-26T13:07\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T15:48\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-10T15:53\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:00:15\", \"value\": [{\"add\": \"37 FAYVIEW LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-03-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078293252\", \"zip\": \"04097\", \"add2\": \"\", \"add3\": \"\", \"city\": \"NORTH YARMOUTH\", \"gend\": 1, \"insh\": \"10000041281\", \"mzip\": \"04097\", \"name\": \"Ann K Edwards\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MCBRADY, MEGAN E\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"tedward1@maine.rr.com\", \"ename\": \"\", \"madd1\": \"37 FAYVIEW LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"NORTH YARMOUTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": \"1164868964\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238586\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2T37UA0QG76\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:42:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:00:15\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/23/2026 @ 01:40 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/18/2026 @ 02:41 PM\", \"result\": 3, \"comment\": \"03/18/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 12:49 PM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 03:53 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 03:48 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"3/11/2026 @ 03:47 PM\"}, {\"date\": \"3/4/2026 @ 04:50 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sam 3/8\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/5/2026 @ 04:49 PM\"}, {\"date\": \"2/26/2026 @ 01:07 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sam 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/27/2026 @ 01:07 PM\"}, {\"date\": \"2/25/2026 @ 12:03 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Samuel no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/27/2026 @ 12:03 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 12:03:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"03-10-2026 15:53:07\", \"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', '23-02-2026 11:42:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2858, NULL, NULL, '24116326', '10000050830', '', '', '66650973', 'Daniel', 'Hughes', 'English', '', '{\"DOB\": 16459, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1497134571\", \"Pcp_Zip\": \"04553\", \"Program\": \"Medicare\", \"Pcp_City\": \"Newcastle\", \"Pcp_Name\": \"SCOTT, SARAH J\", \"Rank_All\": 1, \"PCP_Phone\": \"2075633366\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7G74Y99FM75\", \"Member_City\": \"DAMARISCOTTA\", \"Office_Name\": \"LIFESPAN FAMILY HEALTHCARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DAMARISCOTTA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-01-22\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Lifespan Family Healthcare,80 River Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Lincoln\", \"Member_Country\": \"Lincoln\", \"PCP_Fax_Number\": \"2075634309\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"26 LEWIS POINT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04543\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"26 LEWIS POINT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04543\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Hughes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Daniel\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"DHUGHES202@GMAIL.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"7176736119\", \"Member_Identification_Number\": \"10000050830\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:44:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-31 13:44:58\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-25T12:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-31T13:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T18:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T12:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T11:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T14:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-14T16:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-25T12:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-26T13:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-02T12:37\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-02T12:37\", \"reportStatus_date\": \"2026-03-02T12:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T11:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-14T16:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-25T12:35\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-31T13:44\", \"reportStatus_date\": \"2026-03-31T13:44\"}]', '{\"utc\": [{\"date\": \"2026-03-31T13:44\", \"username\": \"FBeckford\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-26T13:07\", \"username\": null}, {\"date\": \"2026-02-26T13:07\", \"username\": \"cwasilak\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-02T12:37\", \"username\": \"JDingle\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:06:00\", \"value\": [{\"add\": \"26 LEWIS POINT RD\", \"age\": 81, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-01-22\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"7176736119\", \"zip\": \"04543\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DAMARISCOTTA\", \"gend\": 0, \"insh\": \"10000050830\", \"mzip\": \"04543\", \"name\": \"Daniel Hughes\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCOTT, SARAH J\", \"ppno\": \"2075633366\", \"cliId\": \"\", \"email\": \"DHUGHES202@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"26 LEWIS POINT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DAMARISCOTTA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Lifespan Family Healthcare,80 River Rd\", \"pcpnpi\": \"1497134571\", \"pcpzip\": \"04553\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Newcastle\", \"pcpname\": \"LIFESPAN FAMILY HEALTHCARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075634309\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7G74Y99FM75\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-03-2026\", \"time\": \"17:08:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:06:00\"}', '{\"utc\": [{\"date\": \"2026-03-31T13:44\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-02T12:37\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 3, \"cancelText\": \"Per Travis to reschedule member w/ different provider, because Ta`shariah Robinson is unavailable.\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/31/2026 @ 01:44 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Jennifer but member requested a call back in JUNE to reschedule please verify the steps on how he acess the appointment when scheduling \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 12:35 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 04:23 PM\", \"result\": 13, \"comment\": \"Called to schedule virtual with Amanda, Caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"3/31/2026 @ 04:23 PM\"}, {\"date\": \"3/12/2026 @ 02:58 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Erin B 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/13/2026 @ 02:58 PM\"}, {\"date\": \"3/5/2026 @ 11:36 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/9/2026 @ 11:36 AM\"}, {\"date\": \"3/2/2026 @ 12:38 PM\", \"result\": 13, \"comment\": \"Caller disconnected unable to leave a voicemail to reschedule appt w/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 12:37 PM\"}, {\"date\": \"2/26/2026 @ 01:07 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Ta\'Sharia on March 4, 2026 at 12:30pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 06:57 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 06:57 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000050830\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"24116326\", \"memberId\": \"10000050830\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"24116326\", \"memberId\": \"10000050830\", \"scheduleDate\": \"2026-3-4T12:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 18:57:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}, {\"date\": \"03-02-2026 12:37:29\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-25-2026 12:35:01\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, 'Virtual', '2026-3-4T12:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:44:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2859, NULL, NULL, NULL, '10000065213', '', '', '66650973', 'Clinton', 'Delano', 'English', '', '{\"DOB\": 9531, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1154326387\", \"Pcp_Zip\": \"42762100\", \"Program\": \"Medicare\", \"Pcp_City\": \"RUMFORD\", \"Pcp_Name\": \"DELUCA, THOMAS J\", \"Rank_All\": 1, \"PCP_Phone\": \"2073647831\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5AM1N59NH34\", \"Member_City\": \"SOUTH PARIS\", \"Office_Name\": \"ELSEMORE DIXFIELD FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LEWISTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1926-02-03\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"431 FRANKLIN ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Oxford\", \"PCP_Fax_Number\": \"2073699467\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"477 HIGH ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04281\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"20 TALL PINES DR APT 24\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04240\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Delano\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Clinton\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@012624.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\": \"2676141222\", \"Member_Identification_Number\": \"10000065213\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074189909\"}', 'client_014', '2026', '', '{\"hraStatus\":14,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-13-2026 14:54:25\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}', '{\"date\": \"2026-03-13 14:54:25\", \"hrastatus\": \"\", \"reportstatus\": \"Ineligible\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-02T19:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-27T10:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T19:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2026-03-13T14:54\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-25T19:00\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-26T12:20\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-27T14:14\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-03-02T19:05\"}, {\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2026-03-13T14:54\", \"reportStatus_date\": \"2026-03-13T14:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2026-03-13T14:54\", \"username\": \"KCoash\"}], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:15:16\", \"value\": [{\"add\": \"477 HIGH ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2074189909\", \"dob\": \"1926-02-03\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2676141222\", \"zip\": \"04281\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PARIS\", \"gend\": 0, \"insh\": \"10000065213\", \"mzip\": \"04240\", \"name\": \"Clinton T Delano\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DELUCA, THOMAS J\", \"ppno\": \"2073647831\", \"cliId\": \"\", \"email\": \"declined@012624.com\", \"ename\": \"\", \"madd1\": \"20 TALL PINES DR APT 24\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LEWISTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"431 FRANKLIN ST,\", \"pcpnpi\": \"1154326387\", \"pcpzip\": \"42762100\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"RUMFORD\", \"pcpname\": \"ELSEMORE DIXFIELD FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073699467\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5AM1N59NH34\", \"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\": \"02-23-2026\", \"time\": \"23:48:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:15:16\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"3/13/2026 @ 02:54 PM\", \"result\": 2, \"comment\": \"member is in a nursing home receiving care\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 06:44 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 07:05 PM\", \"result\": 13, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:14 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 02:14 PM\"}, {\"date\": \"2/27/2026 @ 10:58 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 10:58 AM\"}, {\"date\": \"2/26/2026 @ 12:20 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Nicole number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 12:20 PM\"}, {\"date\": \"2/25/2026 @ 07:00 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 07:00 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 19:00:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-05-2026 18:44:22\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:48: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
(2860, 71932120, 44829497, '17537038', '10000066228', '', '', '66650973', 'Kathleen', 'Warme', 'English', '', '{\"DOB\": 19744, \"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\": 1811559198, \"Pcp_Zip\": \"04444\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Hampden\", \"Pcp_Name\": \"LARA KIRKPATRICK\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5QG1J87RP15\", \"Member_City\": \"SOLON\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE HAMPDEN\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOLON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-01-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"7 Main Rd N\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Somerset\", \"Member_Country\": \"Somerset\", \"PCP_Fax_Number\": 3304534263, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"225 HOLE IN THE WALL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04979\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 224\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04979\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Warme\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kathleen\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"candkwarme@Live.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"2026-02-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 6036676451, \"Member_Identification_Number\": \"10000066228\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:11:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:11:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-11T10:10\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-12T21:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-13T04:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-25T19:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-09T16:08\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-25T19:07\", \"reportStatus_date\": \"2026-02-25T19:07\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-03-09T16:08\", \"reportStatus_date\": \"2026-03-09T16:08\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-13T04:57\", \"reportStatus_date\": \"2026-03-13T04:57\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:11\", \"reportStatus_date\": \"2026-03-17T16:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:11\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-25T19:07\", \"username\": null}, {\"date\": \"2026-02-25T19:07\", \"username\": \"JDingle\"}], \"inProgress\": [{\"date\": \"2026-03-09T16:08\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-11T10:42\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-11T10:10\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-11T10:10\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-11T20:57\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-12T12:10\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-13T04:57\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-12T21:59\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-13T04:57\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-11T20:59\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-10-2026\", \"time\": \"16:37:56\", \"value\": [{\"add\": \"225 HOLE IN THE WALL RD\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-01-20\", \"eno\": \"0000000000\", \"lob\": \"GA - 2026\", \"pno\": 6036676451, \"zip\": \"04979\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOLON\", \"gend\": 1, \"insh\": \"10000066228\", \"mzip\": \"04979\", \"name\": \"Kathleen K Warme\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LARA KIRKPATRICK\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"candkwarme@Live.com\", \"ename\": \"didnotprovide\", \"madd1\": \"PO BOX 224\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOLON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"7 Main Rd N\", \"pcpnpi\": 1811559198, \"pcpzip\": \"04444\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Hampden\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE HAMPDEN\", \"program\": \"Medicare\", \"pcpfaxno\": 3304534263, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5QG1J87RP15\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"1\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-09-2026\", \"time\": \"11:52:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 16:37:56\"}', NULL, NULL, '{\"memberId\": \"10000066228\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 12 Mar 2026 00:59:32 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1. Hyperlipidemia was supported by medication. However, the medication list noted that the member was not taking Rosuvastatin. Please clarify.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 12 Mar 2026 16:10:09 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Manoucheca, \\nI have added a comment to describe that she stopped taking the medicine and plans to discuss it more with her provider at her next appointment. \\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Kathleen Warme\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/09/2026 04:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/25/2026 @ 07:07 PM\", \"result\": 0, \"comment\": \"Scheduled a virtual w/Amanda Milliken 3/9 at 4 PM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000066228\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000066228\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000066228\", \"scheduleDate\": \"2026-3-9T16:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 19:07:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-25-2026 19:07:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:11:54\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"b2512ca6-b899-44b9-9475-64d8417076b2\\\",\\\"destination_fax_number\\\":\\\"13304534263\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"b2512ca6-b899-44b9-9475-64d8417076b2\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"13304534263\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"13304534263 32      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:16:30.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":244,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":244,\\\"start_timestamp\\\":\\\"2026-03-17T20:12:16.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:16:30.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-9T16:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:48:50', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000066228\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Warme_10000066228_03092026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:11:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000066228.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Warme_10000066228_03092026.pdf', NULL, 'Summary_10000066228.pdf', NULL, '[{\"date\": \"2026-03-11T14:10:50.525Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-12T16:10:08.667Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-09T17:33', 'Member_Summary_10000066228.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000066228\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000066228.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:11:55\"}', NULL, NULL, NULL, '2026-02-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
(2861, NULL, NULL, NULL, '10000071104', '', '', '66650973', 'Wesley', 'Babula', '', '', '{\"DOB\": 19996, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1396151619\", \"Pcp_Zip\": \"41033729\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"MERCIER, CHRISTOPHER F\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9H11MQ9DF04\", \"Member_City\": \"South Portland\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"South Portland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-09-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"441 ALLEN AVE,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"30 Bennett Street\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"30 Bennett Street\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Babula\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Wesley\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"babulawes@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\": \"2075003311\", \"Member_Identification_Number\": \"10000071104\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":0,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-27-2026 09:51:34\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-02-27 09:51:34\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T11:50\", \"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-27T09:51\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-27T09:51\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:18:39\", \"value\": [{\"add\": \"30 Bennett Street\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-09-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075003311\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"South Portland\", \"gend\": 0, \"insh\": \"10000071104\", \"mzip\": \"04106\", \"name\": \"Wesley F Babula\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MERCIER, CHRISTOPHER F\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"babulawes@gmail.com\", \"ename\": \"\", \"madd1\": \"30 Bennett Street\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"South Portland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"441 ALLEN AVE,\", \"pcpnpi\": \"1396151619\", \"pcpzip\": \"41033729\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9H11MQ9DF04\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:49:49\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:18:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/27/2026 @ 09:51 AM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Shellie but member not interested at this time Callback later in the year \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"8/12/2026 @ 09:51 AM\"}, {\"date\": \"2/25/2026 @ 11:50 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 11:50 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 11:50:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-24-2026 23:45:21\", \"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', '23-02-2026 11:49:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2862, 71932120, NULL, '39698290', '10000072541', '', '', '47262451', 'Linda', 'David', 'English', '', '{\"DOB\": 17923, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"Y\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1366544819\", \"Pcp_Zip\": \"03801\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portsmouth\", \"Pcp_Name\": \"LAUTER, M DAVID\", \"Rank_All\": 1, \"PCP_Phone\": \"6034337500\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"2TP2JT5PH96\", \"Member_City\": \"KENNEBUNK\", \"Office_Name\": \"M DAVID LAUTER MD\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"KENNEBUNK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-01-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"200 Griffin Rd Ste 11,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"6034337532\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"674 ALEWIVE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04043\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"674 ALEWIVE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04043\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"David\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Linda\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"2026-06-20\", \"Member_Primary_Phone_Number\": \"2079853465\", \"Member_Identification_Number\": \"10000072541\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":6,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-10-2026 08:58:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-04-10 08:58:27\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-26T14:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-10T08:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-04-09T20:20\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-17T14:26\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-09T19:15\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-03-05T13:30\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-26T14:59\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T13:30\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-17T14:26\", \"reportStatus_date\": \"2026-03-17T14:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 6, \"hraStatus_date\": \"2026-04-09T20:20\", \"reportStatus_date\": \"2026-04-10T08:58\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-03-17T14:26\", \"username\": null}, {\"date\": \"2026-03-17T14:26\", \"username\": \"LAnguiano\"}], \"inProgress\": [{\"date\": \"2026-04-09T19:15\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-04-10T14:12\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-04-09T20:20\", \"username\": \"SCadwell\"}, {\"date\": \"2026-04-09T20:20\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"19:17:15\", \"value\": [{\"add\": \"674 ALEWIVE RD\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-01-25\", \"eno\": \"2079853465\", \"lob\": \"GA - Wave 2\", \"pno\": \"2079853465\", \"zip\": \"04043\", \"add2\": \"\", \"add3\": \"\", \"city\": \"KENNEBUNK\", \"gend\": 1, \"insh\": \"10000072541\", \"mzip\": \"04043\", \"name\": \"Linda K David\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LAUTER, M DAVID\", \"ppno\": \"6034337500\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"THOMAS DAVID\", \"madd1\": \"674 ALEWIVE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"KENNEBUNK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"200 Griffin Rd Ste 11,\", \"pcpnpi\": \"1366544819\", \"pcpzip\": \"03801\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Portsmouth\", \"pcpname\": \"M DAVID LAUTER MD\", \"program\": \"Medicare\", \"pcpfaxno\": \"6034337532\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2TP2JT5PH96\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"04-09-2026\", \"time\": \"20:09:10\", \"value\": [[[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"Yes\", \"\", \"SOS Result: , T Score: -0.8, Z Score: 1.4\", \"2026-04-09\", \"\", \"\", \"yes\", \"OSTEOPENIA\", \"\", \"Exam completed\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", null, null, null, null, null], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]], \"status\": true, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 20:20:35\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/17/2026 @ 02:26 PM\", \"result\": 0, \"comment\": \"Member scheduled for IHA and DEXA with Sandy 4-9-2026 9am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 01:30 PM\", \"result\": 6, \"comment\": \"Member would like cb next week about IHA and dexa \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"3/11/2026 @ 01:30 PM\"}, {\"date\": \"2/26/2026 @ 02:59 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA and DEXA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/28/2026 @ 02:59 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000072541\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000072541\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000072541\", \"scheduleDate\": \"2026-4-9T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-26-2026 14:59:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-17-2026 14:26:49\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, NULL, 'In Person', '2026-4-9T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:50:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"date\": \"2026-04-10T00:20:34.809Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-04-09T10:40', NULL, NULL, NULL, NULL, NULL, '2026-06-20', '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
(2863, NULL, NULL, NULL, '10000075601', '', '', '66650973', 'Regina', 'Larrabee', 'English', '', '{\"DOB\": 19164, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1104867290\", \"Pcp_Zip\": \"44164612\", \"Program\": \"Medicare\", \"Pcp_City\": \"BUCKSPORT\", \"Pcp_Name\": \"PEPPER, CINDY E\", \"Rank_All\": 1, \"PCP_Phone\": \"2074697371\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6GG5A61DY53\", \"Member_City\": \"STOCKTON SPRINGS\", \"Office_Name\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"STOCKTON SPRINGS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-06-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"110 BROADWAY,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Waldo\", \"Member_Country\": \"Waldo\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"66 HAWES BRIDGE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04981\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"66 HAWES BRIDGE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04981\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Larrabee\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Regina\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"akaggs@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\": \"2075579231\", \"Member_Identification_Number\": \"10000075601\", \"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 18:01:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-03 18:01:39\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-03T18:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T19:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T10:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T11:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T11:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T18:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-03-02T11:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T18:01\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:20:49\", \"value\": [{\"add\": \"66 HAWES BRIDGE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-06-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075579231\", \"zip\": \"04981\", \"add2\": \"\", \"add3\": \"\", \"city\": \"STOCKTON SPRINGS\", \"gend\": 1, \"insh\": \"10000075601\", \"mzip\": \"04981\", \"name\": \"Regina E Larrabee\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PEPPER, CINDY E\", \"ppno\": \"2074697371\", \"cliId\": \"\", \"email\": \"akaggs@yahoo.com\", \"ename\": \"\", \"madd1\": \"66 HAWES BRIDGE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"STOCKTON SPRINGS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"110 BROADWAY,\", \"pcpnpi\": \"1104867290\", \"pcpzip\": \"44164612\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BUCKSPORT\", \"pcpname\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6GG5A61DY53\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:50:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:20:49\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"3/16/2026 @ 10:06 AM\", \"result\": 13, \"comment\": \"Called to Schedule Virtual HRA with Dean W. caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 03:33 PM\", \"result\": 1, \"comment\": \"o/c to sched w/Erin B virtual 3/16\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 03:51 PM\", \"result\": 13, \"comment\": \"o/c to sched virt w/Amanda\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 06:01 PM\", \"result\": 13, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 11:46 AM\", \"result\": 13, \"comment\": \"Called to schedule virtual HRA- caller answered then disconnected the call\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"3/6/2026 @ 11:46 AM\"}, {\"date\": \"2/27/2026 @ 11:43 AM\", \"result\": 13, \"comment\": \"Called to schedule HRA w/ Nicole Mattison CALLER DISCONNECTED \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"3/2/2026 @ 11:43 AM\"}, {\"date\": \"2/27/2026 @ 10:55 AM\", \"result\": 13, \"comment\": \"Called to Schedule Virtual HRA with Nicole caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/2/2026 @ 10:55 AM\"}, {\"date\": \"2/25/2026 @ 07:15 PM\", \"result\": 13, \"comment\": \"Call was answered and disconnected. Called to schedule w/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/26/2026 @ 07:14 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 19:15:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-03-2026 18:01:39\", \"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', '23-02-2026 11:50:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2864, NULL, NULL, NULL, '10000077929', '', '', '66650973', 'James', 'Rainey', '', '', '{\"DOB\": 20242, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1881210193\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"MALAY, DEVON C\", \"Rank_All\": 1, \"PCP_Phone\": \"2079073777\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7Y56XG0CM53\", \"Member_City\": \"BUCKSPORT\", \"Office_Name\": \"ST JOSEPH INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BUCKSPORT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-06-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"St Joseph Internal Medicine,900 Broadway Bldg 5\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"2077778800\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"62 WILLINS ORCHARD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04416\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 1401\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04416\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Rainey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tjmrainey@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073562512\", \"Member_Identification_Number\": \"10000077929\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073562512\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-25-2026 13:32:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-25 13:32:26\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-03T18:16\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-25T13:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-26T11:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T10:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T11:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T17:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T18:16\", \"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-03-02T17:39\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T18:16\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-25T13:32\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:22:21\", \"value\": [{\"add\": \"62 WILLINS ORCHARD RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2073562512\", \"dob\": \"1955-06-02\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073562512\", \"zip\": \"04416\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BUCKSPORT\", \"gend\": 0, \"insh\": \"10000077929\", \"mzip\": \"04416\", \"name\": \"James A Rainey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MALAY, DEVON C\", \"ppno\": \"2079073777\", \"cliId\": \"\", \"email\": \"tjmrainey@yahoo.com\", \"ename\": \"\", \"madd1\": \"PO BOX 1401\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BUCKSPORT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"St Joseph Internal Medicine,900 Broadway Bldg 5\", \"pcpnpi\": \"1881210193\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bangor\", \"pcpname\": \"ST JOSEPH INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077778800\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7Y56XG0CM53\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:51:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:22:21\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/6/2026 @ 03:45 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/1/2026 @ 10:18 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin B 4/6\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 01:32 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 02:34 PM\", \"result\": 10, \"comment\": \"Called to schedule virtual with Amanda, Call disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:29 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 10:53 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F/Virtual HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 04:30 PM\", \"result\": 3, \"comment\": \"03/06/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 06:16 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 05:39 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/5/2026 @ 05:39 PM\"}, {\"date\": \"2/27/2026 @ 11:12 AM\", \"result\": 3, \"comment\": \"CALLED TO SCHEDULE HRA/W Okeke, Adaora LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"3/2/2026 @ 11:12 AM\"}, {\"date\": \"2/27/2026 @ 10:29 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 10:29 AM\"}, {\"date\": \"2/26/2026 @ 11:13 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/2/2026 @ 11:13 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-26-2026 11:13:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-25-2026 13:32:26\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:51:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2865, NULL, NULL, '24116326', '10000082992', '', '', '66650973', 'Willard', 'Shannon', '', '', '{\"DOB\": 20443, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1649565672\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"MICHAELIS, TODD M\", \"Rank_All\": 1, \"PCP_Phone\": \"2078741489\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2J93F80HP79\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-12-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238590\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"10 NORMAN STREET\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"10 NORMAN STREET\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Shannon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Willard\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"SHANNONWILLARD5@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\": \"2072728736\", \"Member_Identification_Number\": \"10000082992\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":1,\"cancelText\":\"Per Travis to reschedule member w/ different provider, because Ta`shariah Robinson is unavailable.\"}', 1, b'0', b'0', '{\"date\": \"04-02-2026 16:44:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-04-02 16:44:07\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-04-02T16:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-25T11:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T09:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T13:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T12:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T18:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-20T10:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-23T17:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-04-02T16:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-02T11:58\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-02T12:48\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-02T12:48\", \"reportStatus_date\": \"2026-03-02T12:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T18:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-23T17:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-02T16:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-03-02T11:58\", \"username\": null}, {\"date\": \"2026-03-02T11:58\", \"username\": \"jsmith\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-02T12:48\", \"username\": \"JDingle\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:25:03\", \"value\": [{\"add\": \"10 NORMAN STREET\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-12-20\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072728736\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000082992\", \"mzip\": \"04106\", \"name\": \"Willard J Shannon\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MICHAELIS, TODD M\", \"ppno\": \"2078741489\", \"cliId\": \"\", \"email\": \"SHANNONWILLARD5@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"10 NORMAN STREET\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,100 Foden Rd Ste 203\", \"pcpnpi\": \"1649565672\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238590\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2J93F80HP79\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"23:52:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:25:03\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-02T12:48\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 3, \"cancelText\": \"Per Travis to reschedule member w/ different provider, because Ta`shariah Robinson is unavailable.\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/2/2026 @ 01:44 PM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 05:21 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/27/2026 @ 05:20 PM\"}, {\"date\": \"3/20/2026 @ 10:29 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/25/2026 @ 10:29 AM\"}, {\"date\": \"3/5/2026 @ 06:33 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Erin no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"3/10/2026 @ 06:32 PM\"}, {\"date\": \"3/2/2026 @ 12:48 PM\", \"result\": 13, \"comment\": \"Unable to leave a voicemail to cancel appt to reschedule w/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/4/2026 @ 12:48 PM\"}, {\"date\": \"3/2/2026 @ 11:58 AM\", \"result\": 0, \"comment\": \"scheduled virtual w/ Ta\'Shariah Robinson 3/6/2026 at 1230PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 01:14 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 01:13 PM\"}, {\"date\": \"2/27/2026 @ 09:53 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 09:52 AM\"}, {\"date\": \"2/25/2026 @ 11:53 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/27/2026 @ 11:52 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000082992\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"24116326\", \"memberId\": \"10000082992\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"24116326\", \"memberId\": \"10000082992\", \"scheduleDate\": \"2026-3-6T12:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-25-2026 11:53:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}, {\"date\": \"03-02-2026 12:48:06\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"04-02-2026 16:44:07\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, 'Virtual', '2026-3-6T12:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:52:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(2866, 55499828, 44829497, '27743162', '10000083101', '', '', '66650973', 'Larry', 'Michaud', 'English', '', '{\"DOB\": 22629, \"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\": 1629337902, \"Pcp_Zip\": \"04005\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Biddeford\", \"Pcp_Name\": \"MOREAU, SHANNON N\", \"Rank_All\": 1, \"PCP_Phone\": 2072831441, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2G25RX9QQ73\", \"Member_City\": \"BIDDEFORD\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BIDDEFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1961-12-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"Martins Point Health Care,61 Barra Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": 2075231136, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"35 SOUTH ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"35 SOUTH ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Michaud\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Larry\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46024, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@101123.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2074238637, \"Member_Identification_Number\": \"10000083101\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2073911399}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 14:11:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-07 14:11:17\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T10:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-26T11:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T16:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T12:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T12:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T10:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-31T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-31T09:56\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-04-01T18:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-01T19:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-07T14:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-25T11:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-31T09:09\", \"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-27T16:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T10:05\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-25T11:17\", \"reportStatus_date\": \"2026-03-25T11:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-04-01T19:23\", \"reportStatus_date\": \"2026-04-01T19:23\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-04-07T14:11\", \"reportStatus_date\": \"2026-04-07T14:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-04-07T14:11\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-25T11:17\", \"username\": null}, {\"date\": \"2026-03-25T11:17\", \"username\": \"cwasilak\"}], \"inProgress\": [{\"date\": \"2026-03-31T09:09\", \"username\": \"SHafer\"}], \"qaAssigned\": [{\"date\": \"2026-03-31T10:59\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-31T09:56\", \"username\": \"SHafer\"}, {\"date\": \"2026-03-31T09:56\", \"username\": \"SHafer\"}, {\"date\": \"2026-03-31T12:10\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-31T15:43\", \"username\": \"SHafer\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-04-01T19:23\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-04-01T18:01\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-04-01T19:23\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-31T12:12\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-31-2026\", \"time\": \"09:56:36\", \"value\": [{\"add\": \"35 SOUTH ST\", \"age\": 64, \"ano\": \"\", \"cno\": 2073911399, \"dob\": \"1961-12-14\", \"eno\": \"2074238637\", \"lob\": \"GA - 2026\", \"pno\": 2074238637, \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BIDDEFORD\", \"gend\": 0, \"insh\": \"10000083101\", \"mzip\": \"04005\", \"name\": \"Larry L Michaud\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MOREAU, SHANNON N\", \"ppno\": 2072831441, \"race\": \"\", \"cliId\": \"\", \"email\": \"declined@101123.com\", \"ename\": \"Jamie \", \"madd1\": \"35 SOUTH ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BIDDEFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,61 Barra Rd\", \"pcpnpi\": 1629337902, \"pcpzip\": \"04005\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Separated\", \"pcpFlag\": \"\", \"pcpcity\": \"Biddeford\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"evalDate\": \"2026-3-31 09:00 AM\", \"evalName\": \"Shellie Hafer, NP\", \"pcpfaxno\": 2075231136, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2G25RX9QQ73\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"male \"}, {\"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-31-2026\", \"time\": \"09:09:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 15:43:28\"}', NULL, NULL, '{\"memberId\": \"10000083101\", \"clinician\": \"Shellie Hafer\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Tue, 31 Mar 2026 16:12:31 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Shellie,\\n1) CAD listed on the med list, can you add to the cardiac section\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 31 Mar 2026 19:43:28 GMT\", \"name\": \"Shellie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I have updated\\nThanks\\nShellie \"}, \"mailId\": \"\"}], \"memberName\": \"Larry Michaud\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/31/2026 09:00 AM\", \"clinicianMailId\": \"s.hafer@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/25/2026 @ 11:17 AM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Shellie on March 31, 2026 at 9:00am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 01:42 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 05:26 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- no vm \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 11:17 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- no vm set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 03:24 PM\", \"result\": 3, \"comment\": \"o/c to sched w/ Shellie 3/23\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 10:05 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer No VM Setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 12:27 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer No VM Setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/9/2026 @ 12:27 PM\"}, {\"date\": \"3/3/2026 @ 12:43 PM\", \"result\": 3, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"3/10/2026 @ 12:42 PM\"}, {\"date\": \"2/27/2026 @ 04:08 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 04:08 PM\"}, {\"date\": \"2/26/2026 @ 11:18 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 11:18 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000083101\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": \"10000083101\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": \"10000083101\", \"scheduleDate\": \"2026-3-31T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-26-2026 11:18:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-25-2026 11:17:49\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 0, NULL, '[{\"date\": \"2026-04-07 14:11:15\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"d07fc54e-126c-409d-af49-b38692049928\\\",\\\"destination_fax_number\\\":\\\"12075231136\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"d07fc54e-126c-409d-af49-b38692049928\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12075231136\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552241284 4       \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-04-07T18:16:17.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":255,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":255,\\\"start_timestamp\\\":\\\"2026-04-07T18:11:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-04-07T18:16:17.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-31T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '23-02-2026 11:52:06', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000083101\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Michaud_10000083101_03312026.pdf\", \"ftp_upload_date\": \"2026-04-07 14:11:14\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000083101.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Michaud_10000083101_03312026.pdf', NULL, 'Summary_10000083101.pdf', NULL, '[{\"date\": \"2026-03-31T19:43:28.576Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-31T09:53', 'Member_Summary_10000083101.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000083101\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000083101.pdf\", \"member_ftp_upload_date\": \"2026-04-07 14:11:16\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
