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
(189, 55499828, 44829497, '22140773', '10000104523', '', '', '14133640', 'Leana', 'Seekins', 'English', '', '{\"DOB\": 21206, \"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\": \"1760491294\", \"Pcp_Zip\": \"04402\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BANGOR\", \"Pcp_Name\": \"MARY EYERER\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4XD3DA2KW98\", \"Member_City\": \"SEARSPORT\", \"Office_Name\": \"BREWER MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SEARSPORT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-01-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 1599\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Waldo\", \"Member_Country\": \"Waldo\", \"PCP_Fax_Number\": \"2079470435\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"724 MT EPHRAIM RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04974\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"724 MT EPHRAIM RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04974\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Seekins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Leana\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"lseekins1@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2073229933\", \"Member_Identification_Number\": \"10000104523\", \"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:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:12:13\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-13T09:26\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T09:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T13:39\", \"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-08T14: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-08T14:48\", \"reportStatus_date\": \"2026-02-08T14:48\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T16:29\", \"reportStatus_date\": \"2026-02-13T09:26\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T13:39\", \"reportStatus_date\": \"2026-02-17T13:39\"}, {\"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-08T14:48\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-13T13:48\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-13T09:26\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-13T09:26\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-16T12:40\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-16T12:43\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-16T12:46\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-16T16:29\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T13:39\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T09:51\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T13:39\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-16T12:47\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"16:52:40\", \"value\": [{\"add\": \"724 MT EPHRAIM RD\", \"age\": 68, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-01-21\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2073229933\", \"zip\": \"04974\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SEARSPORT\", \"gend\": 1, \"insh\": \"10000104523\", \"mzip\": \"04974\", \"name\": \"Leana M Seekins\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MARY EYERER\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"lseekins1@roadrunner.com\", \"ename\": \"\", \"madd1\": \"724 MT EPHRAIM RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SEARSPORT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 1599\", \"pcpnpi\": \"1760491294\", \"pcpzip\": \"04402\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"BANGOR\", \"pcpname\": \"BREWER MEDICAL CENTER\", \"program\": \"Medicare\", \"evalDate\": \"2026-02-09 10:30:00 AM\", \"evalName\": \"Erin Barker, FNP\", \"pcpfaxno\": \"2079470435\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4XD3DA2KW98\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"14:07:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 16:52:40\"}', NULL, NULL, '{\"memberId\": \"10000104523\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Mon, 16 Feb 2026 17:47:26 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Erin,\\n1) on the medication list can you select taking or not taking for angular chelitis \\n2) under long term use, I see anti platelet  selected but it looks she she takes eliquis to, if this is a long term med, can you add anticoagulant \\n3) under vitals, pain number listed as 410\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 16 Feb 2026 21:29:05 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Done!\"}, \"mailId\": \"\"}], \"memberName\": \"Leana Seekins\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/09/2026 10:30 AM\", \"clinicianMailId\": \"e.barker@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\": 10000104523, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000104523}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000104523, \"scheduleDate\": \"2026-02-09T10: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-03 17:12:11\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"424c7107-bf31-4627-917d-0d268d99303d\\\",\\\"destination_fax_number\\\":\\\"12079470435\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"424c7107-bf31-4627-917d-0d268d99303d\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12079470435\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"PCHC Fax Server\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:58.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\\\":308,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":308,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:34.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:58.005+0000\\\",\\\"pages_sent\\\":7,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-09T10: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\": \"10000104523\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Seekins_10000104523_02092026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:12:10\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000104523.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Seekins_10000104523_02092026.pdf', NULL, 'Summary_10000104523.pdf', NULL, '[{\"date\": \"2026-02-13T14:26:11.941Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-16T21:29:05.107Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-09T11:57', 'Member_Summary_10000104523.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000104523\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000104523.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:12:13\"}', 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
(190, 55499828, 44829497, '8715496', '10000105357', '', '', '14133640', 'James', 'Longfellow', 'English', '', '{\"DOB\": 21212, \"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\": \"1295159085\", \"Pcp_Zip\": \"04341\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Coopers Mill\", \"Pcp_Name\": \"Unsure - new provider visit\", \"Rank_All\": 1, \"PCP_Phone\": \"(207) 549-7581\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8NP6YR7VG55\", \"Member_City\": \"WINDSOR\", \"Office_Name\": \"Sheepscot Valley Health Center\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDSOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-01-27\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"47 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"431 SOUTH BELFAST RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04363\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"431 SOUTH BELFAST RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04363\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Longfellow\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44928, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"jim@seeding.guru\", \"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\": \"2074622200\", \"Member_Identification_Number\": \"10000105357\", \"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:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:12:20\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-06T19:44\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-09T14:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-09T15:52\", \"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-05T14:14\", \"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\": 10, \"hraStatus_date\": \"2026-02-09T15:52\", \"reportStatus_date\": \"2026-02-09T15:52\"}, {\"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-05T14:14\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:58\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-06T19:44\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-06T19:44\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-09T15:52\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-09T14:47\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-09T15:52\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"02-06-2026\", \"time\": \"19:19:28\", \"value\": [{\"add\": \"431 SOUTH BELFAST RD\", \"age\": 68, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-01-27\", \"eno\": \"2074622220\", \"lob\": \"GA - 2026\", \"pno\": \"2074622200\", \"zip\": \"04363\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDSOR\", \"gend\": 0, \"insh\": \"10000105357\", \"mzip\": \"04363\", \"name\": \"James L Longfellow\", \"plan\": \"martin’s point\", \"pphy\": \"Unsure - new provider visit\", \"ppno\": \"(207) 549-7581\", \"cliId\": \"\", \"email\": \"jim@seeding.guru\", \"ename\": \"Tammy Longfellow (wife)\", \"madd1\": \"431 SOUTH BELFAST RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDSOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"47 Main St\", \"pcpnpi\": \"\", \"pcpzip\": \"04341\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Coopers Mill\", \"pcpname\": \"Sheepscot Valley Health Center\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8NP6YR7VG55\", \"currentgend\": \"Male\", \"pphycomment\": \"verified with member\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visit. \"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"10:01:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-13-2026 12:01:41\"}', 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\": 10000105357, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": 10000105357}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": 10000105357, \"scheduleDate\": \"2026-02-05T10:00: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-03 17:12:18\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"0b14177a-174e-11f1-b913-9d8fd141f3ad\\\",\\\"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}}]', 'Virtual', '2026-02-05T10:00: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\": \"10000105357\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Longfellow_10000105357_02052026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:12:18\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000105357.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Longfellow_10000105357_02052026.pdf', NULL, 'Summary_10000105357.pdf', NULL, '[{\"date\": \"2026-02-07T00:44:56.072Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-05T15:39', 'Member_Summary_10000105357.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000105357\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000105357.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:12:19\"}', 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
(191, 55499828, 44829497, '71460194', '10000106491', '', '', '14133640', 'Michael', 'Healy', 'English', '', '{\"DOB\": 15731, \"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\": 1003891177, \"Pcp_Zip\": \"04011\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Brunswick\", \"Pcp_Name\": \"SARAH DAVIS\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3EK5P60UC60\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-01-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"329 Maine St Ste A200\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2076185688, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"48 UNION ST 301\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"48 UNION ST 301\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Healy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 44930, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"mthealy52@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\": 2076509514, \"Member_Identification_Number\": \"10000106491\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:12:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:12:28\", \"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-05T10:43\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-01T09:28\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-02T10:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-02T13:46\", \"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-05T08:55\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-23T14:42\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-01T09:25\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-11T19:17\", \"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\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-06T11:12\", \"reportStatus_date\": \"2026-02-05T10:43\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-11T19:17\", \"reportStatus_date\": \"2026-02-11T19:17\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-23T14:42\", \"reportStatus_date\": \"2026-02-23T14:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-02T13:46\", \"reportStatus_date\": \"2026-03-02T13:46\"}, {\"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}, {\"date\": \"2026-02-23T14:42\", \"username\": null}, {\"date\": \"2026-02-23T14:42\", \"username\": \"JDingle\"}], \"inProgress\": [{\"date\": \"2026-02-05T08:55\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-01T09:25\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-05T12:11\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-05T10:43\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-05T10:43\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-06T10:56\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-06T10:59\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-06T11:02\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-06T11:05\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-06T11:08\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-06T11:11\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-11T11:58\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-01T09:28\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-02T13:46\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-02T10:12\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-02T13:46\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-06T11:12\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-11T11:55\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-11T15:20\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-11T19:17\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-16-2026\", \"time\": \"09:01:21\", \"value\": [{\"add\": \"48 UNION ST 301\", \"age\": 83, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1943-01-25\", \"eno\": \"2076503728\", \"lob\": \"GA - 2026\", \"pno\": 2076509514, \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 0, \"insh\": \"10000106491\", \"mzip\": \"04011\", \"name\": \"Michael T Healy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SARAH DAVIS\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mthealy52@gmail.com\", \"ename\": \"Bridget Healy                                                                                   \", \"madd1\": \"48 UNION ST 301\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"329 Maine St Ste A200\", \"pcpnpi\": 1003891177, \"pcpzip\": \"04011\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Brunswick\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2076185688, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3EK5P60UC60\", \"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\": \"08:55:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-16-2026 09:01:21\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-11T19:17\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"Member internet unstable for Doxy. Unable to accept invite to Google meet. Connection poor and unable to Face time. Assessment started via audio with plan to complete remainder in person. Provider scheduled for 9. Called at 821 with accident on interstate. Member had conflicting out of town appointment. Winter storm advisory for afternoon and evening. Member will need to be rescheduled. \", \"cancelStatus\": \"1\"}]}', NULL, '{\"memberId\": \"10000106491\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Fri, 06 Feb 2026 16:12:13 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"**** I saw it noted under mincing no video connection was established... was this for the whole visit? The visit has to be audio and visual per virtual guidelines\\nHey Amanda,\\n1) please add martial status under demographics\\n2) Pt listed as using fluctisone QD can you add steroids if he has been using this medication for a while \\n3) Under the cardiac section, for there diagnosis cardio rest shock, active is selected but for that diagnosis to be active it would have to be within 6 months of the date of HRA, in the comment field it says April 2020, if that is the correct date can you change to history of \\n4) For HLD under the cardiac section, the question regarding  statins is selected as no,  but on the medication list, statins is selected as actively taking, can you update\\n5) Pt taking medication for A-FiB can you add to cardiac section\\n 6) Pt using a CPAP is it for sleep apnea? If so, can you add to the cardiac section\\n7) Pt taking medication for neuropathy, can you add to NEURO section\\n8) can you add information to patient summary \\n\\n\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 16:58:31 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1) please add martial status under demographics - completed\\n2) Pt listed as using fluctisone QD can you add steroids if he has been using this medication for a while  - completed \\n3) Under the cardiac section, for there diagnosis cardio rest shock, active is selected but for that diagnosis to be active it would have to be within 6 months of the date of HRA, in the comment field it says April 2020, if that is the correct date can you change to history of - completed\\n4) For HLD under the cardiac section, the question regarding  statins is selected as no,  but on the medication list, statins is selected as actively taking, can you update - completed\\n5) Pt taking medication for A-FiB can you add to cardiac section - completed\\n 6) Pt using a CPAP is it for sleep apnea? If so, can you add to the cardiac section - completed\\n7) Pt taking medication for neuropathy, can you add to NEURO section - completed\\n8) can you add information to patient summary \"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 20:20:36 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Michael Healy\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/05/2026 09:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/23/2026 @ 02:42 PM\", \"result\": 0, \"comment\": \"Scheduled member w/Samuel Acha 3/1 at 9 :00 AM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000106491\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": \"10000106491\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": \"10000106491\", \"scheduleDate\": \"2026-3-1T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-23-2026 14:42:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-23-2026 14:42:00\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:12:26\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3bcd2cca-90b3-4ef8-995b-28107d61d4e2\\\",\\\"destination_fax_number\\\":\\\"12076185688\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3bcd2cca-90b3-4ef8-995b-28107d61d4e2\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12076185688\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"MaineHealth         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:17.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":248,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":248,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:53.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:17.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-1T09: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\": \"10000106491\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Healy_10000106491_03012026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:12:25\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000106491.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Healy_10000106491_03012026.pdf', NULL, 'Summary_10000106491.pdf', NULL, '[{\"date\": \"2026-02-05T15:42:59.345Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-11T16:58:31.560Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-01T08:23:26.950Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-01T09:53', 'Member_Summary_10000106491.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000106491\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000106491.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:12:27\"}', 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
(192, 55499828, 44829497, '39698290', '10000107102', '', '', '14133640', 'Robert', 'Randall', 'English', '', '{\"DOB\": 20414, \"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\": \"1972559367\", \"Pcp_Zip\": \"03820\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Dover\", \"Pcp_Name\": \"MARK BERMAN\", \"Rank_All\": 1, \"PCP_Phone\": \"6037427338\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"9YG0FK5KH39\", \"Member_City\": \"Windham\", \"Office_Name\": \"WHP BELLAMY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Windham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-11-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"15 Old Rollinsford Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"6037409528\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"46 CONIFER DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"46 CONIFER DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Randall\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"randallrbt@gmail.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\": \"6037676764\", \"Member_Identification_Number\": \"10000107102\", \"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:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:12:34\", \"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-18T20:27\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-24T08:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-24T12:58\", \"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-17T14:46\", \"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\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-23T16:59\", \"reportStatus_date\": \"2026-02-18T20:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-24T12:58\", \"reportStatus_date\": \"2026-02-24T12:58\"}, {\"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-17T14:46\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-19T12:36\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-18T20:27\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-18T20:27\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-23T09:20\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-23T09:23\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-23T16:59\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-24T08:50\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-24T12:58\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-24T08:53\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-24T12:58\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-23T09:24\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-24T08:02\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-24T08:49\", \"username\": \"SCadwell\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-16-2026\", \"time\": \"09:03:58\", \"value\": [{\"add\": \"46 CONIFER DR\", \"age\": 70, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-11-21\", \"eno\": \"6037811065\", \"lob\": \"GA - 2026\", \"pno\": \"6037676764\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Windham\", \"gend\": 0, \"insh\": \"10000107102\", \"mzip\": \"04062\", \"name\": \"Robert H Randall\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MARK BERMAN\", \"ppno\": \"6037427338\", \"cliId\": \"\", \"email\": \"randallrbt@gmail.com\", \"ename\": \"Pamela Randall\", \"madd1\": \"46 CONIFER DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Windham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"15 Old Rollinsford Rd\", \"pcpnpi\": \"1972559367\", \"pcpzip\": \"03820\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Dover\", \"pcpname\": \"WHP BELLAMY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"6037409528\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9YG0FK5KH39\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"1\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-13-2026\", \"time\": \"13:00:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-16-2026 09:03:58\"}', NULL, NULL, '{\"memberId\": \"10000107102\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Mon, 23 Feb 2026 14:24:58 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\n1) Pt listed as taking asa for OTC, has he been taking it long term use can you add it to long term use box \\n2) pt taking medication for Gerd can you add to GI section\\n3) Under medical history CKD and kidney removal mentioned, can you add to the assessment of diagnosis section \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 21:59:17 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Completed. \"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Feb 2026 13:02:51 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\non my end it doesn\'t look like any changes made? let me know it could be IT issue? \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Feb 2026 13:50:47 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"its an IT issue. I could not see either but I corrected this. \"}, \"mailId\": \"\"}], \"memberName\": \"Robert Randall\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/17/2026 03:00 PM\", \"clinicianMailId\": \"s.cadwell@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\": 10000107102, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000107102}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000107102, \"scheduleDate\": \"2026-02-17T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:17\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:12:33\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"7b9f1045-497b-411c-b289-ca33673db501\\\",\\\"destination_fax_number\\\":\\\"16037409528\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"7b9f1045-497b-411c-b289-ca33673db501\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"16037409528\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:05.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\\\":301,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":301,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:52.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:05.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-17T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:23', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000107102\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Randall_10000107102_02172026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:12:32\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000107102.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Randall_10000107102_02172026.pdf', NULL, 'Summary_10000107102.pdf', NULL, '[{\"date\": \"2026-02-19T01:27:11.976Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-24T13:50:46.436Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-17T15:27', 'Member_Summary_10000107102.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000107102\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000107102.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:12:34\"}', 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
(193, 71932120, 44829497, '22140773', '10000107186', '', '', '14133640', 'William', 'Foley', 'English', '', '{\"DOB\": 15844, \"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\": \"1982789087\", \"Pcp_Zip\": \"04416\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Bucksport\", \"Pcp_Name\": \"DAVID LOXTERKAMP\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7MT3RU7TX91\", \"Member_City\": \"BELFAST\", \"Office_Name\": \"SEAPORT COMMUNITY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BELFAST\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-05-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"110 Broadway\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Waldo\", \"Member_Country\": \"Waldo\", \"PCP_Fax_Number\": \"2079735042\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1016 WALDO RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04915\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1016 WALDO RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04915\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Foley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 44931, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"Bilfol88@gmail.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\": \"2075055390\", \"Member_Identification_Number\": \"10000107186\", \"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:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:12:41\", \"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-09T20:07\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-13T18:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-13T20:59\", \"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-08T15:47\", \"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-09T20:07\", \"reportStatus_date\": \"2026-02-09T20:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-13T20:59\", \"reportStatus_date\": \"2026-02-13T20:59\"}, {\"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-08T15:47\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-10T10:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-09T20:07\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-09T20:07\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-12T06:11\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-12T20:02\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-13T20:59\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-13T18:28\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-13T20:59\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-10T19:52\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-12T16:19\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-16-2026\", \"time\": \"09:06:30\", \"value\": [{\"add\": \"1016 WALDO RD\", \"age\": 82, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1943-05-18\", \"eno\": \"2079305101\", \"lob\": \"GA - 2026\", \"pno\": \"2075055390\", \"zip\": \"04915\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BELFAST\", \"gend\": 0, \"insh\": \"10000107186\", \"mzip\": \"04915\", \"name\": \"William D Foley\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DAVID LOXTERKAMP\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Bilfol88@gmail.com\", \"ename\": \"Ken and June Smart - friends\", \"madd1\": \"1016 WALDO RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BELFAST\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"110 Broadway\", \"pcpnpi\": \"1982789087\", \"pcpzip\": \"04416\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bucksport\", \"pcpname\": \"SEAPORT COMMUNITY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079735042\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Hancock\", \"medicaidid\": \"\", \"medicareid\": \"7MT3RU7TX91\", \"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-06-2026\", \"time\": \"17:38:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-16-2026 09:06:30\"}', NULL, NULL, '{\"memberId\": \"10000107186\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Wed, 11 Feb 2026 00:52:47 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Please select \\\"anticoagulant\\\" in the long term section of allergies/medication instead of antiplatelet.\\n2. In the assessment of diagnosis section, endocrine, please select what type of diabetic medication the member is taking and if the member has any complications from diabetes.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 12 Feb 2026 11:11:25 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 12 Feb 2026 21:19:31 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\nThank you for responding. \\n\\n1. In the assessment of diagnosis section, endocrine, please select if the member has any complications from diabetes.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 13 Feb 2026 01:02:07 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"William Foley\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/09/2026 12:00 PM\", \"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\": 10000107186, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000107186}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000107186, \"scheduleDate\": \"2026-02-09T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:17\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:12:39\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"0b7268fd-dd2d-4e78-9a17-2091d6283194\\\",\\\"destination_fax_number\\\":\\\"12079735042\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"0b7268fd-dd2d-4e78-9a17-2091d6283194\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12079735042\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2079735042 Northern \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:19.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\\\":309,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":309,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:59.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:19.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-09T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:23', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000107186\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Foley_10000107186_02092026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:12:38\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000107186.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Foley_10000107186_02092026.pdf', NULL, 'Summary_10000107186.pdf', NULL, '[{\"date\": \"2026-02-10T01:07:23.543Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-12T11:11:25.260Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-13T01:02:06.880Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-09T13:36', 'Member_Summary_10000107186.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000107186\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000107186.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:12:40\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
