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
(64, 62035418, 44829497, '34707077', '10000033428', '', '', '14133640', 'Mark', 'Foss', 'English', '', '{\"DOB\": 17961, \"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\": 1396371282, \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"JORDAN, DANIEL\", \"Rank_All\": 1, \"PCP_Phone\": 2078282402, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3A63QP4UE88\", \"Member_City\": \"Portland\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Portland\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-03-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2078282433, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"86 HOLIDAY DR APT 237\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04103\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"86 HOLIDAY DR APT 237\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04103\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Foss\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mark\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"MARK.FOSS1949@GMAIL.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2077563672\", \"Member_Identification_Number\": \"10000033428\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2077563672}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 14:00:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 14:00:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-08T19:27\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-24T18:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T19:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T14:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-17T15:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-03T18:54\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-17T10:36\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-17T15:24\", \"reportStatus_date\": \"2026-02-17T15:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-08T19:27\", \"reportStatus_date\": \"2026-03-08T19:27\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2026-03-10T21:37\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-24T19:04\", \"reportStatus_date\": \"2026-03-24T19:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T14:00\", \"reportStatus_date\": \"2026-03-31T14:00\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T14:00\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-02-17T15:24\", \"username\": null}, {\"date\": \"2026-02-17T15:24\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-03-03T18:54\", \"username\": \"JDoughty\"}], \"qaAssigned\": [{\"date\": \"2026-03-09T16:38\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-08T19:27\", \"username\": \"JDoughty\"}, {\"date\": \"2026-03-08T19:27\", \"username\": \"JDoughty\"}, {\"date\": \"2026-03-24T16:02\", \"username\": \"JDoughty\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-24T19:04\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-24T18:34\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-24T19:04\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-10T21:37\", \"username\": \"NSchaaf\"}, {\"date\": \"2026-03-24T16:02\", \"username\": \"JDoughty\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T10:36\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-08-2026\", \"time\": \"18:39:51\", \"value\": [{\"add\": \"86 HOLIDAY DR APT 237\", \"age\": 77, \"ano\": \"\", \"cno\": 2077563672, \"dob\": \"1949-03-04\", \"eno\": \"207-409-6874\", \"lob\": \"GA - 2026\", \"pno\": \"2077563672\", \"zip\": \"04103\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Portland\", \"gend\": 0, \"insh\": \"10000033428\", \"mzip\": \"04103\", \"name\": \"Mark D Foss\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JORDAN, DANIEL\", \"ppno\": 2078282402, \"cliId\": \"\", \"email\": \"MARK.FOSS1949@GMAIL.COM\", \"ename\": \"Thomas Foss (son)\", \"madd1\": \"86 HOLIDAY DR APT 237\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Portland\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": 1396371282, \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2078282433, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3A63QP4UE88\", \"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\": [false, true, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"Assisted Living - Birchwoods at Canco  Portland, ME\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-08-2026\", \"time\": \"19:21:51\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 13:50:39\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T10:36\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"unable to make appt\", \"cancelStatus\": 1}]}', NULL, '{\"memberId\": \"10000033428\", \"clinician\": \"Jessica Doughty\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Wed, 11 Mar 2026 01:37:15 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Jessica,\\n\\n1) since patient is seeing neurologist for epilepsy please add to neuro assessment of diagnosis and then add\\nsupported by data\\n2) in medication section can you answer questions about med compliance\\n\\n\\nthank you! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Mar 2026 20:02:30 GMT\", \"name\": \"Jessica \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Hi Natalie:\\n\\nI\'m sorry for the lengthy delay - I was traveling out of the country.\\nI did make Amanda aware that I would not be able to address any outstanding issues w/assessments until my return.\\nI have addressed the issues below - thanks for checking my work. \\nHope you\'re having a good week!\\n\\n-Jess\"}, \"mailId\": \"\"}], \"memberName\": \"Mark Foss\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/07/2026 03:30 PM\", \"clinicianMailId\": \"j.doughty@focuscares.com\", \"qaAnalystMailId\": \"n.schaaf@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/17/2026 @ 12:24 PM\", \"result\": 0, \"comment\": \"scheduled appt w/ Jessica D on 3/7/2026 3:30\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000033428\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"34707077\", \"memberId\": \"10000033428\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"34707077\", \"memberId\": \"10000033428\", \"scheduleDate\": \"2026-3-7T15:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-17-2026 12:24:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"02-17-2026 15:24:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 14:00:55\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"f3031a40-a2ef-4a39-a7cb-8b1098eea763\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"f3031a40-a2ef-4a39-a7cb-8b1098eea763\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552411835 12      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:06:57.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":7,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":320,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":320,\\\"start_timestamp\\\":\\\"2026-03-31T18:01:24.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T18:06:57.005+0000\\\",\\\"pages_sent\\\":7,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-7T15:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:47', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000033428\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Foss_10000033428_03072026.pdf\", \"ftp_upload_date\": \"2026-03-31 14:00:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000033428.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Foss_10000033428_03072026.pdf', NULL, 'Summary_10000033428.pdf', NULL, '[{\"date\": \"2026-03-08T23:27:11.012Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-24T20:02:30.156Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-07T17:25', 'Member_Summary_10000033428.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000033428\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000033428.pdf\", \"member_ftp_upload_date\": \"2026-03-31 14:00:56\"}', 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
(65, 71932120, 44829497, '17537038', '10000047881', '', '', '14133640', 'Mary', 'Bryant', 'English', '', '{\"DOB\": 18326, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"Y\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Successful fax\", \"Aligned\": \"\", \"PCP_NPI\": \"1841220431\", \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Bangor \", \"Pcp_Name\": \"unknown has not yet been seen for the first time but it is scheduled \", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2V85GN8TV92\", \"Member_City\": \"GUILFORD\", \"Office_Name\": \"St Joseph Healthcare\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GUILFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-03-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"900 Broadway Ave\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Piscataquis\", \"Member_Country\": \"Piscataquis\", \"PCP_Fax_Number\": \"2079476720\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"40 RIVERBEND DRIVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04443\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"40 RIVERBEND DRIVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04443\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Bryant\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mary\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"MARYBRYANT04@GMAIL.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"02-15-2026\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2077170350\", \"Member_Identification_Number\": \"10000047881\", \"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:06:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-05T14:46\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-16T19:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T14:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T09:13\", \"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:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-05T14:46\", \"reportStatus_date\": \"2026-02-05T14:46\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 7, \"hraStatus_date\": \"2026-02-16T19:43\", \"reportStatus_date\": \"2026-02-16T19:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T14:38\", \"reportStatus_date\": \"2026-02-17T14:38\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T09:13\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-06T16:29\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-10T10:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-05T14:46\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-05T14:46\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-11T11:40\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-11T15:46\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-14T05:04\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T14:38\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-16T19:43\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T14:38\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-10T20:14\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-11T15:49\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"14:20:31\", \"value\": [{\"add\": \"40 RIVERBEND DRIVE\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1950-03-04\", \"eno\": \"2072796216\", \"lob\": \"GA - 2026\", \"pno\": \"2077170350\", \"zip\": \"04443\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GUILFORD\", \"gend\": 1, \"insh\": \"10000047881\", \"mzip\": \"04443\", \"name\": \"Mary C Bryant\", \"plan\": \"Martin\'s Point\", \"pphy\": \"unknown has not yet been seen for the first time but it is scheduled \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"MARYBRYANT04@GMAIL.COM\", \"ename\": \"Craig Bryant \", \"madd1\": \"40 RIVERBEND DRIVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GUILFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"900 Broadway Ave\", \"pcpnpi\": \"1841220431\", \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Bangor \", \"pcpname\": \"St Joseph Healthcare\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079476720\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2V85GN8TV92\", \"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-05-2026\", \"time\": \"14:37:29\", \"value\": [[[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"Yes\", \"\", \"\", \"\", \"\", \"\", \"yes\", \"\", \"\", \"Unable to perform - Telehealth visit\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", null, null, null, null, null], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]], \"status\": true, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 14:20:31\"}', NULL, NULL, '{\"memberId\": \"10000047881\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Wed, 11 Feb 2026 01:14:15 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1. Please highlight steroid in long term use in the allergies/medication section.\\n2. The member is on blood pressure medication; however, the condition as not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition?\\n3. The member is on acid reflux medication; however, the condition as not addressed in the assessment of diagnosis gastrointestinal section. Is this an active ongoing condition?\\n4. The member is on neuropathy medication; however, the condition as not addressed in the assessment of diagnosis neuro-psych section. Is this an active ongoing condition?\\n5. Please add comments/note in the patient summary.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 16:40:56 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \". Please highlight steroid in long term use in the allergies/medication section. - complete\\n2. The member is on blood pressure medication; however, the condition as not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition? - complete\\n3. The member is on acid reflux medication; however, the condition as not addressed in the assessment of diagnosis gastrointestinal section. Is this an active ongoing condition? - complete\\n4. The member is on neuropathy medication; however, the condition as not addressed in the assessment of diagnosis neuro-psych section. Is this an active ongoing condition? - complete\\n5. Please add comments/note in the patient summary.\\n\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 20:49:19 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\nThank you for updating the HRA.\\n\\n1. Please add the details for peripheral neuropathy in the assessment of diagnosis neuro-psych section. \\n2. Please add comments/note in the patient summary. \\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 14 Feb 2026 10:04:39 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I have made the changes\"}, \"mailId\": \"\"}], \"memberName\": \"Mary Bryant\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/05/2026 01:30 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 04:20 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000047881, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000047881}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000047881, \"scheduleDate\": \"2026-02-05T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:46\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:06:46\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"47c5c481-48db-404d-80ba-f149f049c42e\\\",\\\"destination_fax_number\\\":\\\"12079476720\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"47c5c481-48db-404d-80ba-f149f049c42e\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12079476720\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2079476720 EMMC Nort\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:38.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\\\":264,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":264,\\\"start_timestamp\\\":\\\"2026-03-03T22:06:55.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:38.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-05T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:48', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000047881\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Bryant_10000047881_02052026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:45\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000047881.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Bryant_10000047881_02052026.pdf', NULL, 'Summary_10000047881.pdf', NULL, '[{\"date\": \"2026-02-05T19:46:53.569Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-11T16:40:55.769Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-14T10:04:39.692Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-05T14:43', 'Member_Summary_10000047881.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000047881\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000047881.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:46\"}', NULL, NULL, NULL, '02-15-2026', '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
(66, 57818338, 44829497, '17537038', '10000033633', '', '', '14133640', 'Judy', 'Jalbert', 'English', '', '{\"DOB\": 15629, \"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\": 1568469401, \"Pcp_Zip\": \"04530\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BATH\", \"Pcp_Name\": \"AMY ETZWEILER\", \"Rank_All\": 1, \"PCP_Phone\": 2073861800, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7E27TJ4MV76\", \"Member_City\": \"Lisbon Falls\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lisbon Falls\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-10-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"108 CENTRE ST\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": 2074429822, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"2 ENTERPRISE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04252\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2 ENTERPRISE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04252\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Jalbert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Judy\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"bertjalbert@myfairpoint.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2075042620, \"Member_Identification_Number\": \"10000033633\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:06:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:50\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T11:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-24T16:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T14:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T16:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-18T12:30\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-18T12:30\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-18T12:30\", \"reportStatus_date\": \"2026-02-20T11:57\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-02T14:59\", \"reportStatus_date\": \"2026-02-24T16:18\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-18T12:30\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-24T22:20\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-24T16:18\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2026-02-25T11:55\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-26T00:03\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-26T09:19\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-26T16:54\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-26T23:26\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-27T09:44\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-01T13:12\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-02T07:42\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-02T14:08\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-02T14:24\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-02T14:59\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-03T16:05\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-03T14:40\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-03T16:05\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-24T23:39\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-26T00:03\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-26T12:31\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-26T23:26\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-01T13:13\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-02T13:10\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-02T14:25\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-02T14:58\", \"username\": \"AMilliken\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-18T12:30\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"14:44:19\", \"value\": [{\"add\": \"2 ENTERPRISE ST\", \"age\": 83, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1942-10-15\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2075042620, \"zip\": \"04252\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Lisbon Falls\", \"gend\": 1, \"insh\": \"10000033633\", \"mzip\": \"04252\", \"name\": \"Judy J Jalbert\", \"plan\": \"Martin\'s Point\", \"pphy\": \"AMY ETZWEILER\", \"ppno\": 2073861800, \"cliId\": \"\", \"email\": \"bertjalbert@myfairpoint.net\", \"ename\": \"\", \"madd1\": \"2 ENTERPRISE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lisbon Falls\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"108 CENTRE ST\", \"pcpnpi\": 1568469401, \"pcpzip\": \"04530\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BATH\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2074429822, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7E27TJ4MV76\", \"currentgend\": \"\", \"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-10-2026\", \"time\": \"10:36:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 14:44:19\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-18T12:30\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"submitted through new HRA\", \"cancelStatus\": \"1\"}]}', NULL, '{\"memberId\": \"10000033633\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 25 Feb 2026 04:39:37 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Medication list please correct and remove medications not taking.\\nThanks \\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 25 Feb 2026 16:55:02 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\nI have corrected the medication list. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 05:03:50 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Cardiovascular med list reports CHF please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 14:19:21 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\n The medication list has been completed. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 17:31:30 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  AOD Cardiovascular med list reports CHF please add this diagnosis to this section of the HRA.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 21:54:23 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"atorvastatin frequency added. thank you \"}, \"mailId\": \"\"}, {\"date\": \"Fri, 27 Feb 2026 04:26:38 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Per the information reported in the medication list that CHF is the diagnosis for Furosemide please add CHF as a diagnosis in the assessment of diagnosis cardiovascular section.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 27 Feb 2026 14:44:57 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"All medication sections are complete.\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 01 Mar 2026 18:13:03 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\nThis is not a request to change the medication list.  I am requesting the you report that CHF diagnosis in the assessment of diagnosis section of the HRA in the cardiovascular section of the HRA.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 02 Mar 2026 12:42:54 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judith, \\n\\nThe medication  lists up to date. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 02 Mar 2026 18:10:25 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\nPlease add the diagnosis of CHF  that is listed in the medication list  to the assessment of diagnosis cardiovascular section of the HRA.\\nI have sent you an email for the issue today.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 02 Mar 2026 19:08:31 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judith, \\n\\nI have edited the Assessment/Diagnosis section.\\n\\nThank you, \\nAmanda\\n\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 02 Mar 2026 19:25:06 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  AOD cardiovascular CHF and hyperlipidemia are both currently being treated with medication they should be active not history of.  Please correct.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 02 Mar 2026 19:59:41 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judith, \\n\\nI have made corrections to the form. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Judy Jalbert\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/02/2026 03:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"2/20/2026 @ 11:57 AM\", \"result\": 1, \"comment\": \"Called to get member rescheduled with mphp nurses -dead air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 11:57 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000033633, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000033633}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000033633, \"scheduleDate\": \"2026-02-02T15:00:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 11:57:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-18-2026 12:30:40\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 1}', '{\"orderType\": 0, \"sortOrder\": 1771840440}', 1, NULL, '[{\"date\": \"2026-03-03 17:06:49\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"08410fb4-1727-4160-a3b5-04f07a4bb704\\\",\\\"destination_fax_number\\\":\\\"12074429822\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"08410fb4-1727-4160-a3b5-04f07a4bb704\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12074429822\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:30.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:07:09.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:19.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:10:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:47.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:13:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:12.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:17:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:37.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:20:52.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:22:03.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:24:10.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:30.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-02T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:48', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000033633\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Jalbert_10000033633_02022026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:49\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000033633.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Jalbert_10000033633_02022026.pdf', NULL, 'Summary_10000033633.pdf', NULL, '[{\"date\": \"2026-02-25T16:55:01.953Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-26T14:19:21.512Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-26T21:54:22.967Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-27T14:44:56.931Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-02T12:42:53.779Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-02T19:08:31.188Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-02T19:59:41.709Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', NULL, 'Member_Summary_10000033633.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000033633\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000033633.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:49\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
