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
(181, NULL, NULL, '22140773', '10000096263', '', '', '14133640', 'C', 'Vermette', '', '', '{\"DOB\": 18213, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1467658112\", \"Pcp_Zip\": \"04468\", \"Program\": \"Medicare\", \"Pcp_City\": \"Indian Island\", \"Pcp_Name\": \"HUERTH, BENJAMIN W\", \"Rank_All\": 1, \"PCP_Phone\": \"2079737979\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5D22TD5YF85\", \"Member_City\": \"Old Town\", \"Office_Name\": \"PENOBSCOT NATION HEALTH DEPARTMENT\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Old Town\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-11-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Penobscot Nation Health Dept,23 Wabanaki Way\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2078177459\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"14 ROLLING THUNDER DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04468\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"14 ROLLING THUNDER DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04468\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Vermette\", \"Medication_Review\": \"N\", \"Member_first_name\": \"C\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44565, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@070723.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078277573\", \"Member_Identification_Number\": \"10000096263\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":1,\"cancelText\":\"Family emergency\"}', 1, b'0', b'0', '{\"date\": \"03-25-2026 14:42:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-25 14:42:10\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-25T14:42\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T14:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T13:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-15T16:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-20T13:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-25T14:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T14:02\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-13T12:28\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-02-25T08:59\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-13T12:28\", \"reportStatus_date\": \"2026-02-13T12:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T14:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-25T08:59\", \"reportStatus_date\": \"2026-02-27T13:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T14:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-15T16:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-20T13:05\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-25T14:42\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-24T14:02\", \"username\": null}, {\"date\": \"2026-02-24T14:02\", \"username\": \"MDouglas\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-13T12:28\", \"username\": \"LRing1\"}, {\"date\": \"2026-02-25T08:59\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:32:01\", \"value\": [{\"add\": \"14 ROLLING THUNDER DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-11-11\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078277573\", \"zip\": \"04468\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Old Town\", \"gend\": 1, \"insh\": \"10000096263\", \"mzip\": \"04468\", \"name\": \"C E Vermette\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HUERTH, BENJAMIN W\", \"ppno\": \"2079737979\", \"cliId\": \"\", \"email\": \"declined@070723.com\", \"ename\": \"\", \"madd1\": \"14 ROLLING THUNDER DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Old Town\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Penobscot Nation Health Dept,23 Wabanaki Way\", \"pcpnpi\": \"1467658112\", \"pcpzip\": \"04468\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Indian Island\", \"pcpname\": \"PENOBSCOT NATION HEALTH DEPARTMENT\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078177459\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5D22TD5YF85\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:32:01\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-13T12:28\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"LRing1\", \"hraStatus\": 3, \"cancelText\": \"Spoke with the member but she double booked and has a doctor`s appointment the same day and would like to cancel.  Would like a call back to reschedule for a later date. Voided assessment in TSS and database.\", \"cancelStatus\": 0}, {\"date\": \"2026-02-25T08:59\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"Family emergency\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 02:06 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 03:07 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/25/2026 @ 02:42 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 01:05 PM\", \"result\": 3, \"comment\": \"03/20/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"3/31/2026 @ 01:05 PM\"}, {\"date\": \"3/15/2026 @ 04:47 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"5/7/2026 @ 04:46 PM\"}, {\"date\": \"3/9/2026 @ 02:14 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Erin 3/13 - no answer\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/11/2026 @ 02:14 PM\"}, {\"date\": \"2/27/2026 @ 01:56 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA F2F with Erin Barker \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patrick Joseph\", \"callbackDate\": \"3/2/2026 @ 01:55 PM\"}, {\"date\": \"2/24/2026 @ 11:02 AM\", \"result\": 0, \"comment\": \"SCHEDULED F2F APPT W/ ERIN BARKER ON 3/3/2026 AT 11 AM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 11:14 AM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/25/2026 @ 11:14 AM\"}, {\"date\": \"2/20/2026 @ 02:32 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 02:32 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000096263\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": \"10000096263\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": \"10000096263\", \"scheduleDate\": \"2026-3-3T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 14:32:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-25-2026 14:42:10\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, 'In Person', '2026-3-3T11:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:19', 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
(182, 55499828, 44829497, '39698290', '10000098118', '', '', '14133640', 'Rebecca', 'Cote', 'English', '', '{\"DOB\": 23845, \"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\": 1215917919, \"Pcp_Zip\": \"42407634\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"Waggs, Sharon\", \"Rank_All\": 1, \"PCP_Phone\": 2077955700, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2V42PQ5HA23\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1965-04-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"ADULT NURSE PRACTITIONER\", \"Pcp_Address_1\": \"12 HIGH ST,STE 400\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": 2077955727, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"465 MERROW RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"465 MERROW RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cote\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rebecca\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"bcote34196@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2077134452, \"Member_Identification_Number\": \"10000098118\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 14:57:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 14:57:22\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-16T19:22\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-20T17:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-20T18:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T14:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [{\"date\": \"2026-02-22T17:14\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-19T09:00\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-24T13:52\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-15T21:55\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"F2F No Show\", \"type\": \"ReportStatus\", \"status\": 24, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-22T17:14\", \"reportStatus_date\": \"2026-02-22T17:14\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-24T13:52\", \"reportStatus_date\": \"2026-02-24T13:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-16T19:22\", \"reportStatus_date\": \"2026-03-16T19:22\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-20T18:21\", \"reportStatus_date\": \"2026-03-20T18:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T14:57\", \"reportStatus_date\": \"2026-03-24T14:57\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-22T17:14\", \"username\": \"SCadwell\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-24T14:57\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-24T13:52\", \"username\": null}, {\"date\": \"2026-02-24T13:52\", \"username\": \"JCopeland\"}], \"inProgress\": [{\"date\": \"2026-02-19T09:00\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-15T21:55\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-17T12:59\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-16T19:22\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-16T19:22\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-19T14:57\", \"username\": \"HBeck\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-20T18:21\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-20T17:20\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-20T18:21\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-16-2026\", \"time\": \"15:10:15\", \"value\": [{\"add\": \"465 MERROW RD\", \"age\": 60, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-04-13\", \"eno\": \"2072406325\", \"lob\": \"GA - 2026\", \"pno\": 2077134452, \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 1, \"insh\": \"10000098118\", \"mzip\": \"04210\", \"name\": \"Rebecca Cote\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Waggs, Sharon\", \"ppno\": 2077955700, \"cliId\": \"\", \"email\": \"bcote34196@roadrunner.com\", \"ename\": \"Jeffrey Cote \", \"madd1\": \"465 MERROW RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"12 HIGH ST,STE 400\", \"pcpnpi\": 1215917919, \"pcpzip\": \"42407634\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"LEWISTON\", \"pcpname\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2077955727, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2V42PQ5HA23\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Catholic \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-19-2026\", \"time\": \"09:00:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-16-2026 19:22:11\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-22T17:14\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"SCadwell\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"10000098118\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Thu, 19 Mar 2026 18:57:55 GMT\", \"name\": \"HBeck\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\n1) Under the NEURO section for TBI active is selected, I see\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Rebecca Cote\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/16/2026 03:00 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/24/2026 @ 01:52 PM\", \"result\": 0, \"comment\": \"02/24/2026- F2F HRA WITH Sandra Cadwell, ON 3/16/2024 @ 3:00PM, MRB HAS 2 labs will be put away when nurse arrives; parking available in front of the garage. PLS CALL TO LET HER KNOE YOU ARE ON THE WAY  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000098118\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000098118\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000098118\", \"scheduleDate\": \"2026-3-16T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-24-2026 13:52:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"02-24-2026 13:52:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-24 14:57:19\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"619b5281-e967-40a0-a552-74debfcc5fc2\\\",\\\"destination_fax_number\\\":\\\"12077955727\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"619b5281-e967-40a0-a552-74debfcc5fc2\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12077955727\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:03:22.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\\\":328,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":328,\\\"start_timestamp\\\":\\\"2026-03-24T18:57:38.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:03:22.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-16T15:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:19', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000098118\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Cote_10000098118_03162026.pdf\", \"ftp_upload_date\": \"2026-03-24 14:57:19\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000098118.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Cote_10000098118_03162026.pdf', NULL, 'Summary_10000098118.pdf', NULL, '[{\"date\": \"2026-03-16T23:22:10.009Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-16T16:08', 'Member_Summary_10000098118.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000098118\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000098118.pdf\", \"member_ftp_upload_date\": \"2026-03-24 14:57:21\"}', 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
(183, 55499828, 44829497, '39698290', '10000098455', '', '', '14133640', 'Stanley', 'Henry', 'English', '', '{\"DOB\": 17389, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": \"1770528143\", \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Auburn\", \"Pcp_Name\": \"NATHAN RABY\", \"Rank_All\": 1, \"PCP_Phone\": \"2079982100\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8F99T18QN10\", \"Member_City\": \"NEW GLOUCESTER\", \"Office_Name\": \"CENTRAL MAINE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"NEW GLOUCESTER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-08-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"798 Minot Ave\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"482 TOBEY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04260\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 534\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04260\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Henry\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stanley\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2079264696\", \"Member_Identification_Number\": \"10000098455\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076071867\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:11:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:39\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-11T14:36\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-23T09:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T13:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-06T09:36\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-06T09:36\", \"reportStatus_date\": \"2026-02-06T09:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-11T14:36\", \"reportStatus_date\": \"2026-02-11T14:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T13:40\", \"reportStatus_date\": \"2026-02-23T13:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-06T09:36\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:14\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-20T11:16\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-11T14:36\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-11T14:36\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T13:40\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T09:31\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T13:40\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:26:37\", \"value\": [{\"add\": \"482 TOBEY RD\", \"age\": 78, \"ano\": \"\", \"cno\": \"2076071867\", \"dob\": \"1947-08-10\", \"eno\": \"2075767532\", \"lob\": \"GA - 2026\", \"pno\": \"2079264696\", \"zip\": \"04260\", \"add2\": \"\", \"add3\": \"\", \"city\": \"NEW GLOUCESTER\", \"gend\": 0, \"insh\": \"10000098455\", \"mzip\": \"04260\", \"name\": \"Stanley D Henry\", \"plan\": \"Martin\'s Point\", \"pphy\": \"NATHAN RABY\", \"ppno\": \"2079982100\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Marilyn Henry\", \"madd1\": \"PO BOX 534\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"NEW GLOUCESTER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"798 Minot Ave\", \"pcpnpi\": \"1770528143\", \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"Auburn\", \"pcpname\": \"CENTRAL MAINE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8F99T18QN10\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"12:51:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:26:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000098455, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000098455}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000098455, \"scheduleDate\": \"2026-02-06T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:14\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:37\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"f25df3e2-174d-11f1-b913-87ac7bfafbb1\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-02-06T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:20', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000098455\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Henry_10000098455_02062026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:36\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000098455.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Henry_10000098455_02062026.pdf', NULL, 'Summary_10000098455.pdf', NULL, '[{\"date\": \"2026-02-11T19:36:44.307Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-06T10:25', 'Member_Summary_10000098455.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000098455\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000098455.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:39\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0'),
(184, NULL, NULL, '39698290', '10000101567', '', '', '14133640', 'Peter', 'Young', '', '', '{\"DOB\": 21204, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1265895502\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"LENA, SEAN R\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5DG7FX2DT58\", \"Member_City\": \"WINDHAM\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-01-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"InterMed,84 Marginal Way Ste 800\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"20 COYOTE CT\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"20 COYOTE CT\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Young\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Pmyoung58@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\": \"2077769440\", \"Member_Identification_Number\": \"10000101567\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Member just went to the doctor and would prefer to hold off on assessment for now \"}', 1, b'0', b'0', '{\"date\": \"04-08-2026 10:17:58\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-04-08 10:17:58\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-18T09:31\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-20T15:01\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-04-08T10:17\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-18T09:31\", \"reportStatus_date\": \"2026-02-20T15:01\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-04-08T10:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-18T09:31\", \"username\": \"GMedranoAdmin\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:35:11\", \"value\": [{\"add\": \"20 COYOTE CT\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-01-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077769440\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDHAM\", \"gend\": 0, \"insh\": \"10000101567\", \"mzip\": \"04062\", \"name\": \"Peter Young\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LENA, SEAN R\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"Pmyoung58@gmail.com\", \"ename\": \"\", \"madd1\": \"20 COYOTE CT\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,84 Marginal Way Ste 800\", \"pcpnpi\": \"1265895502\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5DG7FX2DT58\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:35:11\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-18T09:31\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"GMedranoAdmin\", \"hraStatus\": 3, \"cancelText\": \"Member just went to the doctor and would prefer to hold off on assessment for now \", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"4/8/2026 @ 10:17 AM\", \"result\": 6, \"comment\": \"o/c to sched w/Sandy for 4/16 - spoke to wife who indicated ok to c/b in August\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"8/5/2026 @ 10:17 AM\"}, {\"date\": \"2/20/2026 @ 03:01 PM\", \"result\": 6, \"comment\": \"Called to get member rescheduled with mphp nurses - member wants a call back later in the year to possibly reschedule \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"4/1/2026 @ 03:00 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000101567, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000101567}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000101567, \"scheduleDate\": \"2026-02-20T12:00:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 15:01:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-18-2026 09:31:03\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, 'In Person', '2026-02-20T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(185, 55499828, 44829497, '48822527', '10000101970', '', '', '14133640', 'Linda', 'Brower', 'English', '', '{\"DOB\": 17304, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": \"1740249861\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"Sarah Krah\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7CG3G35WJ71\", \"Member_City\": \"CORNISH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CORNISH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-05-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"84 Marginal Way\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"81 MAIN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04020\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 99\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04020\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brower\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Linda\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"linda@browers.me\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2076258371\", \"Member_Identification_Number\": \"10000101970\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:11:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-10T11:29\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-16T12:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-16T13:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-08T18:15\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-08T18:15\", \"reportStatus_date\": \"2026-02-08T18:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-16T13:21\", \"reportStatus_date\": \"2026-02-16T13:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-08T18:15\", \"username\": \"JLandry\"}], \"qaAssigned\": [{\"date\": \"2026-02-10T13:14\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-10T11:29\", \"username\": \"JLandry\"}, {\"date\": \"2026-02-10T11:29\", \"username\": \"JLandry\"}, {\"date\": \"2026-02-15T16:57\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-16T13:21\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-16T12:36\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-16T13:21\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-13T15:46\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:29:58\", \"value\": [{\"add\": \"81 MAIN ST\", \"age\": 78, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-05-17\", \"eno\": \"2076258371\", \"lob\": \"GA - 2026\", \"pno\": \"2076258371\", \"zip\": \"04020\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CORNISH\", \"gend\": 1, \"insh\": \"10000101970\", \"mzip\": \"04020\", \"name\": \"Linda S Brower\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Sarah Krah\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"linda@browers.me\", \"ename\": \"John\", \"madd1\": \"PO BOX 99\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CORNISH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"84 Marginal Way\", \"pcpnpi\": \"1740249861\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7CG3G35WJ71\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-08-2026\", \"time\": \"18:15:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:29:58\"}', NULL, NULL, '{\"memberId\": \"10000101970\", \"clinician\": \"Jennifer Landry\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 13 Feb 2026 20:46:45 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Jennifer,\\n1) Pt is using wixela BID on the medication list, has the patient been using this medication long term? If so, can you please add steroids to long term use box.\\n2) EARs in the assessment of diagnosis is left blank, please select yes or no\\n3) Night terrors listed on the medication list, Under the Neuro section anxiety is selected, with PTSD, is this related to the night terror? If so, can you add comment that pt is taking medication for night terrors under the anxiety diagnosis \\n4) Under the integument section, dermatitis is selected but on the med list, it has eczema listed as the reason she is using the ketocanozole, can you clarify\\n5) Under the Endocrine section, for diabetes, peripheral neuropathy selected and supporting data was medication, I saw she is taking pregabalin for fibromyalgia but is this also for diabetic neuropathy as well?\\n6) I see VITD listed on the OTC list, is it for a deficiency ? If so, can you add to the hematology section, if not then disregard\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 15 Feb 2026 21:57:33 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Linda Brower\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/10/2026 11:00 AM\", \"clinicianMailId\": \"j.landry@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000101970, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": 10000101970}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": 10000101970, \"scheduleDate\": \"2026-02-10T11:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:45\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"96c60f16-51c2-4ddc-8ef2-6ab5627cfe72\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"96c60f16-51c2-4ddc-8ef2-6ab5627cfe72\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:30:38.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:15:38.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:55.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:01.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:16.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:22:32.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:44.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:26:02.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:22.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:30:38.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-10T11:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:21', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000101970\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Brower_10000101970_02102026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000101970.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Brower_10000101970_02102026.pdf', NULL, 'Summary_10000101970.pdf', NULL, '[{\"date\": \"2026-02-10T16:29:53.369Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-15T21:57:33.155Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-10T11:29', 'Member_Summary_10000101970.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000101970\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000101970.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:45\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(186, 57818338, 44829497, '71460194', '10000103194', '', '', '14133640', 'Orise', 'Sargent', 'English', '', '{\"DOB\": 12942, \"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\": \"1306885207\", \"Pcp_Zip\": \"04330\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Augusta\", \"Pcp_Name\": \"PETER GUZZETTI\", \"Rank_All\": 1, \"PCP_Phone\": \"2076238434\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4C11NE2TN29\", \"Member_City\": \"AUGUSTA\", \"Office_Name\": \"KENNEBEC INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUGUSTA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1935-06-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"9 Glenridge Dr\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2076214370\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"53 PARKVIEW TER\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04330\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"53 PARKVIEW TER\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04330\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Sargent\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Orise\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"declined@080123.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2076220316\", \"Member_Identification_Number\": \"10000103194\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:11:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:11:53\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-09T10:46\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T23:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-20T01:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-08T12:22\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-09T10:46\", \"reportStatus_date\": \"2026-02-09T10:46\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-20T01:00\", \"reportStatus_date\": \"2026-02-20T01:00\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:11\", \"reportStatus_date\": \"2026-03-03T17:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:11\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-08T12:22\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:56\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-10T09:59\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-09T10:46\", \"username\": \"SAcha\"}, {\"date\": \"2026-02-09T10:46\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-20T01:00\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T23:20\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-20T01:00\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"15:33:45\", \"value\": [{\"add\": \"53 PARKVIEW TER\", \"age\": 90, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1935-06-07\", \"eno\": \"2076222215\", \"lob\": \"GA - 2026\", \"pno\": \"2076220316\", \"zip\": \"04330\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUGUSTA\", \"gend\": 1, \"insh\": \"10000103194\", \"mzip\": \"04330\", \"name\": \"Orise M Sargent\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PETER GUZZETTI\", \"ppno\": \"2076238434\", \"cliId\": \"\", \"email\": \"declined@080123.com\", \"ename\": \"Debra Bernier (Daughter)\", \"madd1\": \"53 PARKVIEW TER\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUGUSTA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"9 Glenridge Dr\", \"pcpnpi\": \"1306885207\", \"pcpzip\": \"04330\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Augusta\", \"pcpname\": \"KENNEBEC INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076214370\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4C11NE2TN29\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"11:22:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 15:33:45\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000103194, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000103194}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000103194, \"scheduleDate\": \"2026-02-08T12:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:52\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"f2070acd-e288-4822-bca7-c09a2c069423\\\",\\\"destination_fax_number\\\":\\\"12076214370\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"f2070acd-e288-4822-bca7-c09a2c069423\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12076214370\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:28:37.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":155,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:10.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:36.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-03T22:14:43.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:10.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:17:17.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:41.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:32.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:22:58.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:32.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":155,\\\"start_timestamp\\\":\\\"2026-03-03T22:25:42.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:28:37.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-08T12:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:21', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000103194\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Sargent_10000103194_02082026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:51\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000103194.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Sargent_10000103194_02082026.pdf', NULL, 'Summary_10000103194.pdf', NULL, '[{\"date\": \"2026-02-09T15:46:42.371Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-08T13:15', 'Member_Summary_10000103194.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000103194\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000103194.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:11:52\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(187, 57818338, 44829497, '39698290', '10000103324', '', '', '14133640', 'Vincent', 'Ayotte', 'English', '', '{\"DOB\": 20634, \"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\": \"1265693360\", \"Pcp_Zip\": \"04268\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Norway\", \"Pcp_Name\": \"THOMAS JOHNSON\", \"Rank_All\": 1, \"PCP_Phone\": \"2077446444\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1HW0Y13RM35\", \"Member_City\": \"OXFORD\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY AND INTERNAL MEDIC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OXFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1956-06-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"8 Pikes Hill RD \", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Oxford\", \"Member_Country\": \"Oxford\", \"PCP_Fax_Number\": \"2075362156\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"187 TIGER HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04270\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"187 TIGER HILL RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04270\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Ayotte\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Vincent\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"Declined@112425.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2073467560\", \"Member_Identification_Number\": \"10000103324\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:12:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:12:02\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-26T14:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T15:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-04T17:48\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-04T17:48\", \"reportStatus_date\": \"2026-02-04T17:48\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T15:40\", \"reportStatus_date\": \"2026-02-26T15:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:12\", \"reportStatus_date\": \"2026-03-03T17:12\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:12\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T17:48\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-19T12:52\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-25T15:43\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-25T23:42\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-25T23:45\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-26T14:18\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T15:40\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-26T14:29\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T15:40\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-24T23:25\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-25T23:45\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"16:29:27\", \"value\": [{\"add\": \"187 TIGER HILL RD\", \"age\": 69, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1956-06-28\", \"eno\": \"2075955840\", \"lob\": \"GA - 2026\", \"pno\": \"2073467560\", \"zip\": \"04270\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OXFORD\", \"gend\": 0, \"insh\": \"10000103324\", \"mzip\": \"04270\", \"name\": \"Vincent D Ayotte\", \"plan\": \"Martin\'s Point\", \"pphy\": \"THOMAS JOHNSON\", \"ppno\": \"2077446444\", \"cliId\": \"\", \"email\": \"Declined@112425.com\", \"ename\": \"Tony Ayotte, Tyler Ayotte, Mika \", \"madd1\": \"187 TIGER HILL RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OXFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"8 Pikes Hill RD \", \"pcpnpi\": \"1265693360\", \"pcpzip\": \"04268\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Norway\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY AND INTERNAL MEDIC\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075362156\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1HW0Y13RM35\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-04-2026\", \"time\": \"17:48:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 16:29:27\"}', NULL, NULL, '{\"memberId\": \"10000103324\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 25 Feb 2026 04:25:22 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra\\n1.  Medication List please add all info needed for medications using and remove medications not using.\\n2.  Assessors comments needs info reported.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 25 Feb 2026 20:43:46 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"completed. \"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 04:45:42 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra\\n1.  AOD Nose Seasonal allergies is reported in the medication list please add to this section of the HRA.\\n2.  AOD Cardiovascular Orthostatic Hypotension is reported in the medication list please add to this section of the HRA.\\n3.  AOD Neuropsych depression anxiety and insomnia are reported in the medication list please add to this section of the HRA.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 19:18:55 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"2nd round corrected. \"}, \"mailId\": \"\"}], \"memberName\": \"Vincent Ayotte\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/03/2026 12:00 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000103324, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000103324}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000103324, \"scheduleDate\": \"2026-02-03T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:11:59\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3f95ede3-a501-4d39-af73-ae53df73274e\\\",\\\"destination_fax_number\\\":\\\"12075362156\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3f95ede3-a501-4d39-af73-ae53df73274e\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12075362156\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"MaineHealth         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:49.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\\\":256,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":256,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:13.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:49.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:21', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000103324\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Ayotte_10000103324_02032026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:11:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000103324.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Ayotte_10000103324_02032026.pdf', NULL, 'Summary_10000103324.pdf', NULL, '[{\"date\": \"2026-02-11T19:12:59.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-26T19:18:53.680Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T13:24', 'Member_Summary_10000103324.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000103324\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000103324.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:12:01\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(188, 71932120, 44829497, '22140773', '10000104456', '', '', '14133640', 'Ann', 'Perry', 'English', '', '{\"DOB\": 21161, \"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\": \"1356380729\", \"Pcp_Zip\": \"04412\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BREWER\", \"Pcp_Name\": \"JULIE KINGSBURY\", \"Rank_All\": 1, \"PCP_Phone\": \"2079455247\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8T98YH2KU23\", \"Member_City\": \"DIXMONT\", \"Office_Name\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DIXMONT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1957-12-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"43 WHITING HILL RD STE 300\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079472674\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"18 WESTERN AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04932\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"18 WESTERN AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04932\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Perry\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ann\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"ann_perry1257@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2072344623\", \"Member_Identification_Number\": \"10000104456\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:28:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:28:03\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-04T16:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-05T08:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-05T13:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-23T18:36\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-05T13:00\", \"reportStatus_date\": \"2026-03-05T13:00\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:28\", \"reportStatus_date\": \"2026-03-10T14:28\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:28\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-02-19T17:32\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:35\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-22T21:41\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-04T16:13\", \"username\": \"AWalsh\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-05T13:00\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-05T08:29\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-05T13:00\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T17:35\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-22T21:31\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T21:34\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T21:37\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T21:40\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-23T18:36\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"14:42:35\", \"value\": [{\"add\": \"18 WESTERN AVE\", \"age\": 68, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1957-12-07\", \"eno\": \"2076056429\", \"lob\": \"GA - 2026\", \"pno\": \"2072344623\", \"zip\": \"04932\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DIXMONT\", \"gend\": 1, \"insh\": \"10000104456\", \"mzip\": \"04932\", \"name\": \"Ann M Perry\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JULIE KINGSBURY\", \"ppno\": \"2079455247\", \"cliId\": \"\", \"email\": \"ann_perry1257@yahoo.com\", \"ename\": \"Floyd Neal - sig other\", \"madd1\": \"18 WESTERN AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DIXMONT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"43 WHITING HILL RD STE 300\", \"pcpnpi\": \"1356380729\", \"pcpzip\": \"04412\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"BREWER\", \"pcpname\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079472674\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8T98YH2KU23\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-03-2026\", \"time\": \"16:12:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 14:42:35\"}', NULL, NULL, '{\"memberId\": \"10000104456\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 22:35:29 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Please remove any medication the member no longer is taking from the medication list.\\n2. Please select the treatment for COPD in the assessment of diagnosis, respiratory section of the HRA.\\n3. Please complete the vital signs section.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 02:41:59 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"As mentioned under a prior member, visits done on 2/2 and 2/3 when we started using the new HRA is that these visits were also showing up on my schedule in the old HRA (which I did not document in). This member\'s visit is no longer in the new HRA, which is where I entered the med list. So again, I don\'t know what the member is taking or what to do.\\nThere is definitely other info that did not transfer over, such as the vital signs and exercise info. Luckily, I still had that info written down. \"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 23:36:06 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\nIs it possible to reach out to the member via telephone and get an update on the medications they\'re taking?\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Ann Perry\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/03/2026 10:30 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000104456, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000104456}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000104456, \"scheduleDate\": \"2026-02-03T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:16\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:28:02\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"5386b9c0-6013-43cf-9cf9-5b057b0b1faa\\\",\\\"destination_fax_number\\\":\\\"12079472674\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"5386b9c0-6013-43cf-9cf9-5b057b0b1faa\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12079472674\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2079472674 EMMC Nort\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:32:33.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":238,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":238,\\\"start_timestamp\\\":\\\"2026-03-10T18:28:18.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:32:33.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:22', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000104456\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Perry_10000104456_02032026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:28:01\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000104456.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Perry_10000104456_02032026.pdf', NULL, 'Summary_10000104456.pdf', NULL, '[{\"date\": \"2026-02-03T20:57:09.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T02:41:58.426Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T11:20', 'Member_Summary_10000104456.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000104456\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000104456.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:28:02\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
