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
(247, 55499828, 44829497, '8715496', '10000111533', '', '', NULL, 'Joseph', 'Wright Ii', 'English', '', '{\"DOB\": 14968, \"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\": 1205171147, \"Pcp_Zip\": \"04401\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Bangor\", \"Pcp_Name\": \"CASSIE BIALER\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6D63HP4VX12\", \"Member_City\": \"ORONO\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"ORONO\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-12-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \" 700 Mt Hope Ave #210\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": 2077778800, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"1 HATHORN CT\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04473\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1 HATHORN CT\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04473\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Wright Ii\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joseph\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"ltcjwright@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\": 2072664521, \"Member_Identification_Number\": \"10000111533\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:17:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:17:14\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-25T16:36\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-27T14:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-27T16:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-01T02:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T09:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-25T13:08\", \"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-02-01T02:17\", \"reportStatus_date\": \"2026-02-01T02:17\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-05T09:29\", \"reportStatus_date\": \"2026-02-05T09:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-27T16:06\", \"reportStatus_date\": \"2026-02-27T16:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:17\", \"reportStatus_date\": \"2026-03-03T17:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:17\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-01T02:17\", \"username\": null}, {\"date\": \"2026-02-01T02:17\", \"username\": null}, {\"date\": \"2026-02-05T09:29\", \"username\": \"TFerness2\"}], \"inProgress\": [{\"date\": \"2026-02-25T13:08\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-26T11:23\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-26T11:24\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-26T11:25\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-25T16:36\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-25T16:36\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-27T16:06\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-27T14:43\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-27T16:06\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:24:09\", \"value\": [{\"add\": \"1 HATHORN CT\", \"age\": 85, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-12-23\", \"eno\": \"2078661060\", \"lob\": \"GA - 2026\", \"pno\": 2072664521, \"zip\": \"04473\", \"add2\": \"\", \"add3\": \"\", \"city\": \"ORONO\", \"gend\": 0, \"insh\": \"10000111533\", \"mzip\": \"04473\", \"name\": \"Joseph A Wright Ii\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CASSIE BIALER\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ltcjwright@gmail.com\", \"ename\": \"Cassandra Wright (wife)\", \"madd1\": \"1 HATHORN CT\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"ORONO\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \" 700 Mt Hope Ave #210\", \"pcpnpi\": 1205171147, \"pcpzip\": \"04401\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Bangor\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2077778800, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6D63HP4VX12\", \"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\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visit\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"10:04:36\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:24:09\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000111533, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": 10000111533}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": 10000111533, \"scheduleDate\": \"2026-02-05T11:00:00\"}}', NULL, '{\"date\": \"02-05-2026 09:29:13\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:17:13\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"f239f528-90b3-4a8e-8691-5b4c81506060\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"f239f528-90b3-4a8e-8691-5b4c81506060\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:36:51.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":1,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":312,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:28:41.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:29:10.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":312,\\\"start_timestamp\\\":\\\"2026-03-03T22:31:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:36:51.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-2-25T13:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:38', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000111533\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Wright Ii_10000111533_02252026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:17:13\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000111533.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Wright Ii_10000111533_02252026.pdf', NULL, 'Summary_10000111533.pdf', NULL, '[{\"date\": \"2026-02-25T21:36:11.869Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-25T14:40', 'Member_Summary_10000111533.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000111533\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000111533.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:17:14\"}', 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
(248, 71932120, 44829497, '12383693', '10000112516', '', '', NULL, 'Isadora', 'Quimby', 'English', '', '{\"DOB\": 13282, \"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\": \"1679534770\", \"Pcp_Zip\": \"04330\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Augusta\", \"Pcp_Name\": \"GENE CHENG\", \"Rank_All\": 1, \"PCP_Phone\": \"2076224400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8MJ0KA4XY05\", \"Member_City\": \"AUGUSTA\", \"Office_Name\": \"GENE CHENG MD\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUGUSTA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1936-05-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"6 Middle St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2076229894\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"27 CENTER ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04330\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"27 CENTER ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04330\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Quimby\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Isadora\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"declined@11122025.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\": \"2076232003\", \"Member_Identification_Number\": \"10000112516\", \"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:17:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:17:23\", \"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-04T20:09\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-09T18:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-09T21:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-01T02:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-03T15:39\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-03T19:31\", \"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-02-01T02:17\", \"reportStatus_date\": \"2026-02-01T02:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-09T21:25\", \"reportStatus_date\": \"2026-02-09T21:25\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:17\", \"reportStatus_date\": \"2026-03-03T17:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:17\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-01T02:17\", \"username\": null}, {\"date\": \"2026-02-01T02:17\", \"username\": null}, {\"date\": \"2026-02-03T15:39\", \"username\": \"AWalsh\"}], \"inProgress\": [{\"date\": \"2026-02-03T19:31\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-02-05T12:13\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-04T20:09\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-04T20:09\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-09T21:25\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-09T18:06\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-09T21:25\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:26:55\", \"value\": [{\"add\": \"27 CENTER ST\", \"age\": 89, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1936-05-12\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2076232003\", \"zip\": \"04330\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUGUSTA\", \"gend\": 1, \"insh\": \"10000112516\", \"mzip\": \"04330\", \"name\": \"Isadora Quimby\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GENE CHENG\", \"ppno\": \"2076224400\", \"race\": \"\", \"cliId\": \"\", \"email\": \"declined@11122025.com\", \"ename\": \"\", \"madd1\": \"27 CENTER ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUGUSTA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"6 Middle St\", \"pcpnpi\": \"1679534770\", \"pcpzip\": \"04330\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Augusta\", \"pcpname\": \"GENE CHENG MD\", \"program\": \"Medicare\", \"evalDate\": \"2026-2-4 12:30 PM\", \"evalName\": \"Kathryn Baxter, FNP\", \"pcpfaxno\": \"2076229894\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8MJ0KA4XY05\", \"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-03-2026\", \"time\": \"17:05:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:26:55\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"2/3/2026 @ 12:57 PM\", \"result\": 12, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000112516, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": 10000112516}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": 10000112516, \"scheduleDate\": \"2026-02-04T12:30:00.000\"}}', NULL, '{\"date\": \"02-03-2026 15:39:41\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:17:22\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ad807724-bd0f-4d81-acb9-3f19fe01adcf\\\",\\\"destination_fax_number\\\":\\\"12076229894\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"ad807724-bd0f-4d81-acb9-3f19fe01adcf\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12076229894\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:43.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":141,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":141,\\\"start_timestamp\\\":\\\"2026-03-03T22:17:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:43.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-4T12:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:38', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000112516\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Quimby_10000112516_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:17:20\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000112516.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Quimby_10000112516_02042026.pdf', NULL, 'Summary_10000112516.pdf', NULL, '[{\"date\": \"2026-02-05T01:09:47.336Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T14:15', 'Member_Summary_10000112516.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000112516\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000112516.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:17:22\"}', 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
(249, 71932120, 44829497, '8715496', '10000114294', '', '', NULL, 'Gregory', 'Mehlhorn', 'English', '', '{\"DOB\": 20963, \"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\": \"1982030961\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"Kathryn Hamann\", \"Rank_All\": 1, \"PCP_Phone\": \"(207) 828-2402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2CG5HF4XF80\", \"Member_City\": \"Windham\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Windham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1957-05-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"33 Lakeside Drive\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"33 Lakeside Drive\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Mehlhorn\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gregory\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"mehlhorn4957@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\": \"2074080354\", \"Member_Identification_Number\": \"10000114294\", \"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:17:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:17:32\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-06T19:55\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-09T20:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-09T21:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-01T02:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T13:02\", \"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-02-01T02:17\", \"reportStatus_date\": \"2026-02-01T02:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-09T21:20\", \"reportStatus_date\": \"2026-02-09T21:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:17\", \"reportStatus_date\": \"2026-03-03T17:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:17\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-01T02:17\", \"username\": null}, {\"date\": \"2026-02-01T02:17\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T13:02\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:45\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-06T19:55\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-06T19:55\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-09T20:39\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-09T20:42\", \"username\": \"MJoseph\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-09T21:20\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-09T20:42\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-09T21:20\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:45:40\", \"value\": [{\"add\": \"33 Lakeside Drive\", \"age\": 68, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1957-05-23\", \"eno\": \"2072812350\", \"lob\": \"GA - 2026\", \"pno\": \"2074080354\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Windham\", \"gend\": 0, \"insh\": \"10000114294\", \"mzip\": \"04062\", \"name\": \"Gregory P Mehlhorn\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Kathryn Hamann\", \"ppno\": \"(207) 828-2402\", \"cliId\": \"\", \"email\": \"mehlhorn4957@gmail.com\", \"ename\": \"Maureen Mehlhorn\", \"madd1\": \"33 Lakeside Drive\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Windham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"331 Veranda St\", \"pcpnpi\": \"1982030961\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2CG5HF4XF80\", \"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\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visit\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"10:00:31\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:45:40\"}', NULL, NULL, '{\"memberId\": \"10000114294\", \"clinician\": \"Candace Hembrick \", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Tue, 10 Feb 2026 01:42:02 GMT\", \"name\": \"MJoseph\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Candace,\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Gregory Mehlhorn\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/05/2026 01:00 PM\", \"clinicianMailId\": \"c.hembrick@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/28/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000114294, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": 10000114294}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": 10000114294, \"scheduleDate\": \"2026-02-05T13:00:00\"}}', NULL, '{\"date\": \"02-01-2026 02:17:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:17:31\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"b1001819-63b6-44cc-99ca-af3a969a650c\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"b1001819-63b6-44cc-99ca-af3a969a650c\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552411835 3       \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:59.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":238,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":238,\\\"start_timestamp\\\":\\\"2026-03-03T22:17:48.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:59.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-05T13:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:38', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000114294\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Mehlhorn_10000114294_02052026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:17:29\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000114294.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Mehlhorn_10000114294_02052026.pdf', NULL, 'Summary_10000114294.pdf', NULL, '[{\"date\": \"2026-02-07T00:55:51.313Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-05T13:58', 'Member_Summary_10000114294.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000114294\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000114294.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:17:32\"}', 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
(250, NULL, NULL, '48822527', '00000007396', '', '', '14133640', 'William', 'Kline Jr', '', '', '{\"DOB\": 15988, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1932692803\", \"Pcp_Zip\": \"41023344\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"WARD, HANNAH\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6XM3R94GK96\", \"Member_City\": \"Westbrook\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Westbrook\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-10-09\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"66 BRAMHALL ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"20 DOTTIES WAY APT 29\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04092\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"20 DOTTIES WAY APT 29\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04092\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Kline Jr\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"wkline29@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"00000007396\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"3525301699\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"1\",\"cancelText\":\"issue with system\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 11:31:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-24 11:31:39\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-24T11:31\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-03-10T15:40\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [{\"date\": \"2026-03-12T11:01\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-13T17:14\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-17T11:15\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-20T11:30\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-03-24T11:31\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": 3, \"hraStatus_date\": \"2026-03-10T15:40\", \"reportStatus_date\": \"2026-03-13T17:14\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-20T11:30\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-24T11:31\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-10T15:40\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:43:13\", \"value\": [{\"add\": \"20 DOTTIES WAY APT 29\", \"age\": 82, \"ano\": \"\", \"cno\": \"3525301699\", \"dob\": \"1943-10-09\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"3525301699\", \"zip\": \"04092\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Westbrook\", \"gend\": 0, \"insh\": \"00000007396\", \"mzip\": \"04092\", \"name\": \"William S Kline Jr\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WARD, HANNAH\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"wkline29@gmail.com\", \"ename\": \"\", \"madd1\": \"20 DOTTIES WAY APT 29\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Westbrook\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"66 BRAMHALL ST,\", \"pcpnpi\": \"1932692803\", \"pcpzip\": \"41023344\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6XM3R94GK96\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-10-2026\", \"time\": \"16:07:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:43:13\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-03-10T15:40\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"issue with system\", \"cancelStatus\": \"1\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 10, \"callLog\": [{\"date\": \"3/24/2026 @ 11:31 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 11:30 AM\", \"result\": 10, \"comment\": \"Called to Schedule F2F HRA with Pamela number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/31/2026 @ 11:30 AM\"}, {\"date\": \"3/17/2026 @ 11:15 AM\", \"result\": 10, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"3/19/2026 @ 11:15 AM\"}, {\"date\": \"3/13/2026 @ 05:14 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/14/2026 @ 05:14 PM\"}, {\"date\": \"3/12/2026 @ 11:01 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/13/2026 @ 11:01 AM\"}, {\"date\": \"2/3/2026 @ 01:40 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": true, \"noAnswer\": \"-1\", \"scheduler\": \"Mary Carmen Valdez\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"2/3/2026 @ 11:40 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"2/3/2026 @ 11:10 AM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"00000007396\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": \"00000007396\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": \"00000007396\", \"scheduleDate\": \"2026-02-03T14:30:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"03-17-2026 11:15:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-24-2026 11:31:39\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, 'In Person', '2026-02-03T14:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(251, 55499828, 44829497, '8715496', '00007434200', '', '', '14133640', 'Brenda', 'Brackett', 'English', '', '{\"DOB\": 15638, \"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\": \"1740240290\", \"Pcp_Zip\": \"04048\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"LIMERICK\", \"Pcp_Name\": \"KATHRYN GALBRAITH\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1P16MT1QK30\", \"Member_City\": \"Waterboro\", \"Office_Name\": \"GALBRAITH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waterboro\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-10-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"44 ELM ST\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2077939587\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"555 OSSIPEE HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04087\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 719\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04087\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Brackett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brenda\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"c.gallantnsons@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\": \"2072060944\", \"Member_Identification_Number\": \"00007434200\", \"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:17:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:17:44\", \"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-20T19:09\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-24T08:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-24T13:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-17T10:20\", \"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:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-20T19:09\", \"reportStatus_date\": \"2026-02-20T19:09\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-24T13:19\", \"reportStatus_date\": \"2026-02-24T13:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:17\", \"reportStatus_date\": \"2026-03-03T17:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:17\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-17T10:20\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-23T17:26\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-20T19:09\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-20T19:09\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-24T13:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-24T08:10\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-24T13:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:48:43\", \"value\": [{\"add\": \"555 OSSIPEE HILL RD\", \"age\": 83, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1942-10-24\", \"eno\": \"2072064358\", \"lob\": \"GA - 2026\", \"pno\": \"2072060944\", \"zip\": \"04087\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Waterboro\", \"gend\": 1, \"insh\": \"00007434200\", \"mzip\": \"04087\", \"name\": \"Brenda J Brackett\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KATHRYN GALBRAITH\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"c.gallantnsons@gmail.com\", \"ename\": \"Christine Gallant (daughter)\", \"madd1\": \"PO BOX 719\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waterboro\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"44 ELM ST\", \"pcpnpi\": \"1740240290\", \"pcpzip\": \"04048\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"LIMERICK\", \"pcpname\": \"GALBRAITH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077939587\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1P16MT1QK30\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Jehovah Witness - no blood products - DPA- alternatives to blood products and solutions is carried with her. \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visit. \"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-17-2026\", \"time\": \"10:20:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:48:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"00007434200\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": \"00007434200\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": \"00007434200\", \"scheduleDate\": \"2026-02-17T10:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:32\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:17:41\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"8654622c-fa41-432c-8912-26fdcca3e9da\\\",\\\"destination_fax_number\\\":\\\"12077939587\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"8654622c-fa41-432c-8912-26fdcca3e9da\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12077939587\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"SpanDSP Fax Ident\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:22.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":304,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":304,\\\"start_timestamp\\\":\\\"2026-03-03T22:18:02.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:22.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-17T10:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"00007434200\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Brackett_00007434200_02172026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:17:40\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_00007434200.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Brackett_00007434200_02172026.pdf', NULL, 'Summary_00007434200.pdf', NULL, '[{\"date\": \"2026-02-21T00:09:54.283Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-17T12:06', 'Member_Summary_00007434200.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"00007434200\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_00007434200.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:17:43\"}', 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
(252, 55499828, 44829497, '39698290', '10000010800', '', '', '14133640', 'Rina', 'Harvey', 'English', '', '{\"DOB\": 14844, \"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\": 1164782819, \"Pcp_Zip\": \"04086\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Topsham\", \"Pcp_Name\": \"Ross Watson\", \"Rank_All\": 1, \"PCP_Phone\": \"2077986200\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4RN2AY3EW86\", \"Member_City\": \"Bowdoin\", \"Office_Name\": \"TOPSHAM FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bowdoin\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1940-08-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"4 horton place\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"389 DEAD RIVER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04287\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"389 DEAD RIVER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04287\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Harvey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rina\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"refused@refused.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2076668008, \"Member_Identification_Number\": \"10000010800\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:04:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:04:09\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-14T16:23\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-17T12:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T15:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-12T17:18\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-12T17:19\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-12T22:34\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-11T10:21\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2026-03-02T13:23\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2026-03-05T11:39\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-11T10:20\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-11T10:20\", \"reportStatus_date\": \"2026-02-11T10:21\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T13:23\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T11:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-14T16:23\", \"reportStatus_date\": \"2026-03-14T16:23\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:04\", \"reportStatus_date\": \"2026-03-17T16:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:04\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-03-12T17:18\", \"username\": null}, {\"date\": \"2026-03-12T17:19\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-03-12T22:34\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-16T12:55\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-14T16:23\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-14T16:23\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-17T15:57\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-17T12:50\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-17T15:57\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-11T10:20\", \"username\": \"KCoash\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"09:47:57\", \"value\": [{\"add\": \"389 DEAD RIVER RD\", \"age\": 85, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1940-08-21\", \"eno\": \"2073195592\", \"lob\": \"GA - 2026\", \"pno\": 2076668008, \"zip\": \"04287\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Bowdoin\", \"gend\": 1, \"insh\": \"10000010800\", \"mzip\": \"04287\", \"name\": \"Rina M Harvey\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Ross Watson\", \"ppno\": \"2077986200\", \"cliId\": \"\", \"email\": \"refused@refused.com\", \"ename\": \"Michael Harvey\", \"madd1\": \"389 DEAD RIVER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bowdoin\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"4 horton place\", \"pcpnpi\": \"\", \"pcpzip\": \"04086\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Topsham\", \"pcpname\": \"TOPSHAM FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4RN2AY3EW86\", \"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-09-2026\", \"time\": \"17:13:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 09:47:57\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-11T10:20\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 3, \"cancelText\": \"mbr is unable to do a virtual appointment - call back to do F2F\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/12/2026 @ 05:18 PM\", \"result\": 0, \"comment\": \"Scheduled with sandra cadwell 3/13/2026 @ 4:30pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 11:39 AM\", \"result\": 14, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/10/2026 @ 11:39 AM\"}, {\"date\": \"3/2/2026 @ 01:23 PM\", \"result\": 14, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/9/2026 @ 01:22 PM\"}, {\"date\": \"2/11/2026 @ 10:21 AM\", \"result\": 14, \"comment\": \"member unable to do Virtual - call back to sched F2F\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/12/2026 @ 10:21 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000010800\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000010800\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000010800\", \"scheduleDate\": \"2026-3-13T16:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-11-2026 10:21:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-12-2026 17:18:59\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:04:06\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"741a7964-223c-11f1-8b98-5347db95b001\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-3-13T16:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000010800\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Harvey_10000010800_03132026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:04:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000010800.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Harvey_10000010800_03132026.pdf', NULL, 'Summary_10000010800.pdf', NULL, '[{\"date\": \"2026-03-14T20:23:55.669Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-13T17:15', 'Member_Summary_10000010800.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000010800\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000010800.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:04:08\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(253, 55499828, 44829497, '12383693', '10000012547', '', '', '14133640', 'Jimmie', 'Bickford', 'English', '', '{\"DOB\": 22698, \"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_Zip\": \"\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Medicare_ID\": \"5U97HU3HF42\", \"Member_City\": \"Waterville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waterville\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1962-02-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"6 KIMBALL ST APT 309\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6 KIMBALL ST APT 309\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bickford\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jimmie\", \"Member_Middle_name\": \"P\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"bigbruick@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2074469083, \"Member_Identification_Number\": \"10000012547\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2074469083}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:28:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:28:11\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-03T19:34\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-07T19:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-08T19:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-14T17:19\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-17T11:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-27T13:28\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-14T17:19\", \"reportStatus_date\": \"2026-02-14T17:19\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-17T11:12\", \"reportStatus_date\": \"2026-02-17T11:12\"}, {\"text\": \"Call Back\", \"type\": \"HraStatus\", \"status\": 9, \"hraStatus\": 2, \"hraStatus_date\": \"2026-03-02T11:24\", \"reportStatus_date\": \"2026-02-27T13:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-08T19:30\", \"reportStatus_date\": \"2026-03-08T19:30\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:28\", \"reportStatus_date\": \"2026-03-10T14:28\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:28\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-02-17T11:12\", \"username\": null}, {\"date\": \"2026-02-17T11:12\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-02-14T17:19\", \"username\": \"KBaxter\"}, {\"date\": \"2026-03-02T11:24\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-03-04T16:31\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-03T19:34\", \"username\": \"KBaxter\"}, {\"date\": \"2026-03-03T19:34\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-08T19:30\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-07T19:07\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-08T19:30\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-03-2026\", \"time\": \"10:44:43\", \"value\": [{\"add\": \"6 KIMBALL ST APT 309\", \"age\": 64, \"ano\": \"\", \"cno\": 2074469083, \"dob\": \"1962-02-21\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2074469083, \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Waterville\", \"gend\": 0, \"insh\": \"10000012547\", \"mzip\": \"04901\", \"name\": \"Jimmie P Bickford\", \"plan\": \"Martin\'s Point\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bigbruick@yahoo.com\", \"ename\": \"\", \"madd1\": \"6 KIMBALL ST APT 309\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waterville\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5U97HU3HF42\", \"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-14-2026\", \"time\": \"17:19:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 16:01:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/27/2026 @ 01:28 PM\", \"result\": 6, \"comment\": \"Member returning a call to Laura Ring member requested a call back.\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/3/2026 @ 01:27 PM\"}, {\"date\": \"2/17/2026 @ 11:12 AM\", \"result\": 12, \"comment\": \"resched w/Kathryn 3/3 at 10:45 am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000012547\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": \"10000012547\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": \"10000012547\", \"scheduleDate\": \"2026-3-3T10:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-17-2026 11:12:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-17-2026 11:12:42\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1772529884}', 0, NULL, '[{\"date\": \"2026-03-10 14:28:10\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"e4119244-1cae-11f1-8190-75238fce44b1\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-3-3T10:45', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012547\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Bickford_10000012547_03032026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:28:09\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000012547.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Bickford_10000012547_03032026.pdf', NULL, 'Summary_10000012547.pdf', NULL, '[{\"date\": \"2026-03-04T00:34:39.795Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-03T12:47', 'Member_Summary_10000012547.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000012547\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000012547.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:28:10\"}', 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
(254, 57818338, 44829497, '22140773', '10000015739', '', '', '14133640', 'Alan', 'Baker', 'English', '', '{\"DOB\": 10812, \"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\": \"1053805309\", \"Pcp_Zip\": \"04416\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Bucksport\", \"Pcp_Name\": \"HEIDI SHAWLEY\", \"Rank_All\": 1, \"PCP_Phone\": \"2074697371\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1J20FK6KP02\", \"Member_City\": \"ORRINGTON\", \"Office_Name\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"ORRINGTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1929-08-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"110 Broadway Bucksport\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"69 BALD HILL REACH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04474\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"69 BALD HILL REACH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04474\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Baker\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alan\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"alanlbaker29@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\": \"No\", \"Member_Primary_Phone_Number\": \"2078253965\", \"Member_Identification_Number\": \"10000015739\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2072170217\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:17:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:17:53\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-18T19:17\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-22T22:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T13:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-17T11:52\", \"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:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T13:54\", \"reportStatus_date\": \"2026-02-23T13:54\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:17\", \"reportStatus_date\": \"2026-03-03T17:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:17\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-17T11:52\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-19T12:44\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-18T19:17\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-18T19:17\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T22:18\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T13:54\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-22T22:34\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T13:54\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-21T23:38\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:51:54\", \"value\": [{\"add\": \"69 BALD HILL REACH RD\", \"age\": 96, \"ano\": \"\", \"cno\": \"2072170217\", \"dob\": \"1929-08-07\", \"eno\": \"2072174423\", \"lob\": \"GA - 2026\", \"pno\": \"2078253965\", \"zip\": \"04474\", \"add2\": \"\", \"add3\": \"\", \"city\": \"ORRINGTON\", \"gend\": 0, \"insh\": \"10000015739\", \"mzip\": \"04474\", \"name\": \"Alan L Baker\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HEIDI SHAWLEY\", \"ppno\": \"2074697371\", \"race\": \"\", \"cliId\": \"\", \"email\": \"alanlbaker29@gmail.com\", \"ename\": \"Mary Martin - close family friend, medical POA\", \"madd1\": \"69 BALD HILL REACH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"ORRINGTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"110 Broadway Bucksport\", \"pcpnpi\": \"1053805309\", \"pcpzip\": \"04416\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Bucksport\", \"pcpname\": \"BUCKSPORT REGIONAL HEALTH CENTER\", \"program\": \"Medicare\", \"evalDate\": \"2026-02-18 10:30:00 AM\", \"evalName\": \"Erin Barker, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Hancock\", \"medicaidid\": \"\", \"medicareid\": \"1J20FK6KP02\", \"currentgend\": \"Male\", \"pphycomment\": \"PLEASE CONTACT MEMBER\'S EMERGENCY CONTACT/POA, MARY MARTIN, FOR ALL CORRESPONDENCE. MEMBER IS HARD OF HEARING, AND SHE HELPS HIM WITH HIS APPTS.\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Methodist\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-17-2026\", \"time\": \"11:52:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:51:54\"}', NULL, NULL, '{\"memberId\": \"10000015739\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Sun, 22 Feb 2026 04:38:50 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin\\n1.  Demographics marital needs answer\\n2.  AOD Neuropsych med list reports anxiety please add.\\n3.  Vital Signs Temp and pulse OX need correct answers.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 03:18:32 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. I did not get his marital status. \\n2 and 3. Done!\"}, \"mailId\": \"\"}], \"memberName\": \"Alan Baker\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/18/2026 10:30 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000015739, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000015739}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000015739, \"scheduleDate\": \"2026-02-18T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:32\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:17:51\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"d16f835e-174e-11f1-acbf-2f9672b2d1e9\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-02-18T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000015739\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Baker_10000015739_02182026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:17:50\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000015739.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Baker_10000015739_02182026.pdf', NULL, 'Summary_10000015739.pdf', NULL, '[{\"date\": \"2026-02-19T00:17:07.231Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T03:18:32.342Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-18T12:21', 'Member_Summary_10000015739.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000015739\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000015739.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:17:53\"}', 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
(255, NULL, NULL, '39698290', '10000023725', '', '', '14133640', 'Gabor', 'Kele', '', '', '{\"DOB\": 12450, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1801232608\", \"Pcp_Zip\": \"04276\", \"Program\": \"Medicare\", \"Pcp_City\": \"Rumford\", \"Pcp_Name\": \"MUELLER, ZACHARY\", \"Rank_All\": 1, \"PCP_Phone\": \"2073690146\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2G09G06PR42\", \"Member_City\": \"Bridgton\", \"Office_Name\": \"SWIFT RIVER FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bridgton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1934-01-31\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Swift River Family Medicine,430 Franklin St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2073648626\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"210 SAM INGALLS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04009\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 775\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04009\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Kele\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gabor\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072394391\", \"Member_Identification_Number\": \"10000023725\", \"Member_Alternate_Phone_Number\": \"2074205815\", \"Member_Secondary_Phone_Number\": \"2075953081\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-05-2026 15:23:38\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-05 15:23:38\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-05T15:23\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-03T16:39\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-05T15:23\", \"reportStatus_date\": \"2026-02-05T15:23\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-05T15:23\", \"username\": \"LStewart\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:39\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:51:09\", \"value\": [{\"add\": \"210 SAM INGALLS RD\", \"age\": \"\", \"ano\": \"2074205815\", \"cno\": \"2075953081\", \"dob\": \"1934-01-31\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072394391\", \"zip\": \"04009\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Bridgton\", \"gend\": 0, \"insh\": \"10000023725\", \"mzip\": \"04009\", \"name\": \"Gabor R Kele\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MUELLER, ZACHARY\", \"ppno\": \"2073690146\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 775\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bridgton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Swift River Family Medicine,430 Franklin St\", \"pcpnpi\": \"1801232608\", \"pcpzip\": \"04276\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Rumford\", \"pcpname\": \"SWIFT RIVER FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073648626\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2G09G06PR42\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:50:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:51:09\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-05T15:23\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"LStewart\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:39\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"need to reschedule\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/5/2026 @ 03:23 PM\", \"result\": 9, \"comment\": \"in memory care unit \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000023725, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000023725}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000023725, \"scheduleDate\": \"2026-02-19T15:00:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 15:23:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"02-03-2026 16:39:28\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, 'In Person', '2026-02-19T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(256, 71932120, 44829497, '71460194', '10000024274', '', '', '14133640', 'Patricia', 'Hunter', 'English', '', '{\"DOB\": 17014, \"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\": \"1801875018\", \"Pcp_Zip\": \"04263\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"LYDIA THORP\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7PD3W32EE03\", \"Member_City\": \"LEWISTON\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LEWISTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-07-31\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"180 CHURCH HILL RD STE 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2075242093\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"143 BLAKE ST UNIT 205\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04240\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"143 BLAKE ST UNIT 205\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04240\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hunter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Patricia\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"WINTERBRIGHTPAT@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\": \"2075046043\", \"Member_Identification_Number\": \"10000024274\", \"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:18:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:18:01\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-16T12:27\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T17:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T18:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-15T10:24\", \"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:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T12:27\", \"reportStatus_date\": \"2026-02-16T12:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T18:11\", \"reportStatus_date\": \"2026-02-17T18:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:18\", \"reportStatus_date\": \"2026-03-03T17:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:18\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-15T10:24\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T09:22\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-16T12:27\", \"username\": \"SAcha\"}, {\"date\": \"2026-02-16T12:27\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T18:11\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T17:48\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T18:11\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:55:30\", \"value\": [{\"add\": \"143 BLAKE ST UNIT 205\", \"age\": 79, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-07-31\", \"eno\": \"2073738830\", \"lob\": \"GA - 2026\", \"pno\": \"2075046043\", \"zip\": \"04240\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LEWISTON\", \"gend\": 1, \"insh\": \"10000024274\", \"mzip\": \"04240\", \"name\": \"Patricia J Hunter\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LYDIA THORP\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"WINTERBRIGHTPAT@GMAIL.COM\", \"ename\": \"Sarah Hunter\", \"madd1\": \"143 BLAKE ST UNIT 205\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LEWISTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD STE 1\", \"pcpnpi\": \"1801875018\", \"pcpzip\": \"04263\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075242093\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7PD3W32EE03\", \"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-13-2026\", \"time\": \"11:20:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:55:30\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000024274, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000024274}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000024274, \"scheduleDate\": \"2026-02-15T10:10:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:33\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:17:59\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"17804a8f-5500-4250-b6c2-bbf0da3c765b\\\",\\\"destination_fax_number\\\":\\\"12075242093\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"17804a8f-5500-4250-b6c2-bbf0da3c765b\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12075242093\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18334505438 7       \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:22:03.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":204,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":204,\\\"start_timestamp\\\":\\\"2026-03-03T22:18:16.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:22:03.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-15T10:10:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:40', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000024274\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Hunter_10000024274_02152026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:17:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000024274.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Hunter_10000024274_02152026.pdf', NULL, 'Summary_10000024274.pdf', NULL, '[{\"date\": \"2026-02-16T17:27:54.879Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-15T11:27', 'Member_Summary_10000024274.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000024274\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000024274.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:01\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(257, 71932120, 44829497, '17537038', '10000025390', '', '', '14133640', 'Glenys', 'Michaud', 'English', '', '{\"DOB\": 17679, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Busy. The destination number was busy.\", \"Aligned\": \"\", \"PCP_NPI\": \"1154773935\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"CHRISTINA LEBLANC\", \"Rank_All\": 1, \"PCP_Phone\": \"2078731098\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1X93EY1NR81\", \"Member_City\": \"VASSALBORO\", \"Office_Name\": \"THAYER INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WATERVILLE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-05-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"149 North St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078615461\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"617 NELSON\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04989\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 583\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04903\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Michaud\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Glenys\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"gtnwlife@roadrunner.com\", \"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\": \"2076499899\", \"Member_Identification_Number\": \"10000025390\", \"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:18:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:18:09\", \"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-12T09:51\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T17:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T21:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-12T09:03\", \"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:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-12T09:51\", \"reportStatus_date\": \"2026-02-12T09:51\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T21:20\", \"reportStatus_date\": \"2026-02-19T21:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:18\", \"reportStatus_date\": \"2026-03-03T17:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:18\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-12T09:03\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:20\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T15:59\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-12T09:51\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-12T09:51\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-18T20:40\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-18T20:43\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T16:53\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T21:20\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T17:40\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T21:20\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-18T20:46\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T16:53\", \"username\": \"AMilliken\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"08:59:13\", \"value\": [{\"add\": \"617 NELSON\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-05-26\", \"eno\": \"2076499601\", \"lob\": \"GA - 2026\", \"pno\": \"2076499899\", \"zip\": \"04989\", \"add2\": \"\", \"add3\": \"\", \"city\": \"VASSALBORO\", \"gend\": 1, \"insh\": \"10000025390\", \"mzip\": \"04903\", \"name\": \"Glenys L Michaud\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CHRISTINA LEBLANC\", \"ppno\": \"2078731098\", \"cliId\": \"\", \"email\": \"gtnwlife@roadrunner.com\", \"ename\": \"Thomas Hunter\", \"madd1\": \"PO BOX 583\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WATERVILLE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"149 North St\", \"pcpnpi\": \"1154773935\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"THAYER INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078615461\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1X93EY1NR81\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"11:46:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 08:59:13\"}', NULL, NULL, '{\"memberId\": \"10000025390\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 01:46:15 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1. Please select the dose/units, route, and frequency of the OTC medication list. Please update.\\n2. Please select if the member experiences any glaucoma symptoms in the assessment of diagnosis eyes section.\\n3. In the assessment of diagnosis, musculoskeletal section was left unanswered. Please select yes or no.\\n4. Please complete all the questions in the vital signs section.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Feb 2026 21:53:13 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Manoucheca, \\n\\nI have added the changes. \\n\\nThank you, \\nAmanda\\n\"}, \"mailId\": \"\"}], \"memberName\": \"Glenys Michaud\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/12/2026 09:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000025390, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"\", \"memberId\": 10000025390}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"\", \"memberId\": 10000025390, \"scheduleDate\": \"2026-02-12T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:33\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:18:07\", \"status\": 0, \"message\": \"Busy. The destination number was busy.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"15d48785-4b0c-411c-b587-f23c2183dcc4\\\",\\\"destination_fax_number\\\":\\\"12078615461\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"15d48785-4b0c-411c-b587-f23c2183dcc4\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12078615461\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:32:35.005+0000\\\",\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\",\\\"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:18:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:45.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:21:06.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:45.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:24:06.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:35.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:26:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:23.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:29:54.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:32:04.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:32:35.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-12T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:40', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000025390\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Michaud_10000025390_02122026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:18:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000025390.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Michaud_10000025390_02122026.pdf', NULL, 'Summary_10000025390.pdf', NULL, '[{\"date\": \"2026-02-12T14:51:32.604Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-19T21:53:13.360Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-12T09:47', 'Member_Summary_10000025390.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000025390\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000025390.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:08\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
