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
(104, 55499828, 44829497, '8715496', '10000071804', '', '', '14133640', 'James', 'Nisbett', 'English', '', '{\"DOB\": 18046, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": \"1649239765\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"Jennifer Landry \", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2CX3PN8YW03\", \"Member_City\": \"OLD ORCHARD BEACH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OLD ORCHARD BEACH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-05-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"84 MARGINAL WAY SUITE 700\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2075238597\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"86 WILD DUNES WAY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04064\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"86 WILD DUNES WAY\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04064\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Nisbett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"sjnisbett@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\": \"2074470800\", \"Member_Identification_Number\": \"10000071804\", \"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:08:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:08:18\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-04T10:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T09:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T14:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-03T11:19\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-04T10:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-04T10:08\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-04T10:09\", \"reportStatus_date\": \"2026-02-04T10:09\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T14:28\", \"reportStatus_date\": \"2026-02-23T14:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:08\", \"reportStatus_date\": \"2026-03-03T17:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-02-04T10:04\", \"username\": \"AWalsh\"}, {\"date\": \"2026-03-03T17:08\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-02-04T10:09\", \"username\": \"AWalsh\"}], \"inProgress\": [{\"date\": \"2026-02-03T11:19\", \"username\": \"chembrick\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-02-19T08:50\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-19T08:53\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-20T20:50\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T14:28\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T09:12\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T14:28\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T08:55\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-20T20:49\", \"username\": \"chembrick\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-04T10:08\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"09:30:53\", \"value\": [{\"add\": \"86 WILD DUNES WAY\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-05-28\", \"eno\": \"2076501427\", \"lob\": \"GA - 2026\", \"pno\": \"2074470800\", \"zip\": \"04064\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OLD ORCHARD BEACH\", \"gend\": 0, \"insh\": \"10000071804\", \"mzip\": \"04064\", \"name\": \"James W Nisbett\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Jennifer Landry \", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"sjnisbett@gmail.com\", \"ename\": \"Staci Nisbett (daughter) (207) 632-9815; Donna Weatherby (partner) (207) 650-1427\", \"madd1\": \"86 WILD DUNES WAY\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OLD ORCHARD BEACH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"84 MARGINAL WAY SUITE 700\", \"pcpnpi\": \"\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238597\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2CX3PN8YW03\", \"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-03-2026\", \"time\": \"11:19:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 09:30:53\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-04T10:08\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"done in 2.0\", \"cancelStatus\": \"1\"}]}', NULL, '{\"memberId\": \"10000071804\", \"clinician\": \"Candace Hembrick \", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 13:55:01 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Candace,\\n1) Can you add marital status and emergency contact if the member provided this information\\n2) Some medications on the med list, can you select taking or not taking: prednisone, pentasa, balsalazide disodium\\n3) exam review blank, not sure if some of your answers didn\'t save \\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 21 Feb 2026 01:50:34 GMT\", \"name\": \"Candace \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Completed - This was a transfer from the new system back to the old system due to the loss data.  \\nThank you! \\nCandace H. \"}, \"mailId\": \"\"}], \"memberName\": \"James Nisbett\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/03/2026 12:00 PM\", \"clinicianMailId\": \"c.hembrick@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000071804, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": 10000071804}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": 10000071804, \"scheduleDate\": \"2026-02-03T12:00:00\"}}', NULL, '{\"date\": \"02-04-2026 10:08:27\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 0}', '{\"orderType\": 1, \"sortOrder\": 1770217707}', 1, NULL, '[{\"date\": \"2026-03-03 17:08:18\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"333b6ae2-1036-4937-9365-f1d92e99eb6c\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"333b6ae2-1036-4937-9365-f1d92e99eb6c\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12075238597\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:56.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:34.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:41.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:10:52.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:11.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:13:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:41.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:15:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:04.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:18:07.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:21.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:20:38.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:56.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-03T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:58', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000071804\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Nisbett_10000071804_02032026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:08:16\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000071804.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Nisbett_10000071804_02032026.pdf', NULL, 'Summary_10000071804.pdf', NULL, '[{\"date\": \"2026-02-03T23:59:45.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-21T01:50:34.371Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T14:30', 'Member_Summary_10000071804.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000071804\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000071804.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:08:18\"}', 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
(105, 62035418, 44829497, '22140773', '10000048690', '', '', '14133640', 'Peter', 'Gould', 'English', '', '{\"DOB\": 17752, \"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\": \"1669577938\", \"Pcp_Zip\": \"04444\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Hampden\", \"Pcp_Name\": \"JOHN PATTEN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078620300\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2NY0T90FA90\", \"Member_City\": \"BANGOR\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE HAMPDEN\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BANGOR\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-08-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"21 Western Ave\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2077778800\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"666 FINSON RD LOT 153\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04401\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"666 FINSON RD LOT 153\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04401\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gould\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"mary959@hotmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2073551847\", \"Member_Identification_Number\": \"10000048690\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073551847\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:08:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:08:22\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-11T12:54\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-15T20:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-16T13:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-10T06:21\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-16T13:29\", \"reportStatus_date\": \"2026-02-16T13:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:08\", \"reportStatus_date\": \"2026-03-03T17:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:08\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-10T06:21\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:23\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-11T12:54\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-11T12:54\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-16T13:29\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-15T20:23\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-16T13:29\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"09:33:30\", \"value\": [{\"add\": \"666 FINSON RD LOT 153\", \"age\": 77, \"ano\": \"\", \"cno\": \"2073551847\", \"dob\": \"1948-08-07\", \"eno\": \"2073413999\", \"lob\": \"GA - 2026\", \"pno\": \"2073551847\", \"zip\": \"04401\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BANGOR\", \"gend\": 0, \"insh\": \"10000048690\", \"mzip\": \"04401\", \"name\": \"Peter E Gould\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JOHN PATTEN\", \"ppno\": \"2078620300\", \"cliId\": \"\", \"email\": \"mary959@hotmail.com\", \"ename\": \"Mary Gould - wife\", \"madd1\": \"666 FINSON RD LOT 153\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BANGOR\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"21 Western Ave\", \"pcpnpi\": \"1669577938\", \"pcpzip\": \"04444\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Hampden\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE HAMPDEN\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077778800\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"2NY0T90FA90\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP is Kathy Boutin-Semmel, NP\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-10-2026\", \"time\": \"06:21:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 09:33:30\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000048690, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000048690}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000048690, \"scheduleDate\": \"2026-02-10T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:56\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:08:21\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3d67a347-2928-4e27-ae48-fe2697a99ff0\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3d67a347-2928-4e27-ae48-fe2697a99ff0\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:34.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\\\":337,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":337,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:40.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:34.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-10T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:59', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000048690\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Gould_10000048690_02102026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:08:21\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000048690.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Gould_10000048690_02102026.pdf', NULL, 'Summary_10000048690.pdf', NULL, '[{\"date\": \"2026-02-11T17:54:46.047Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-10T13:35', 'Member_Summary_10000048690.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000048690\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000048690.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:08: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
(106, 57818338, 44829497, '22140773', '10000114076', '', '', '14133640', 'Ronald', 'Murchison', 'English', '', '{\"DOB\": 19899, \"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\": \"1245662642\", \"Pcp_Zip\": \"04402\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BANGOR\", \"Pcp_Name\": \"OTTILLA BOROS\", \"Rank_All\": 1, \"PCP_Phone\": \"2079455247\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2TW0D55AK44\", \"Member_City\": \"OLD TOWN\", \"Office_Name\": \"PENOBSCOT COMMUNITY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"OLD TOWN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-06-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"PO BOX 1599\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079470435\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"370 WEST OLD TOWN RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04468\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"370 WEST OLD TOWN RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04468\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Murchison\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ronald\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"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\": \"2072492780\", \"Member_Identification_Number\": \"10000114076\", \"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:08:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:08:26\", \"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-10T11:27\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-10T11:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T22:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T23:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-10T06:09\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-10T11:27\", \"reportStatus_date\": \"2026-02-10T11:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T23:42\", \"reportStatus_date\": \"2026-02-23T23:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:08\", \"reportStatus_date\": \"2026-03-03T17:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:08\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-10T06:09\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-10T12:33\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-10T11:27\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-10T11:27\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T22:03\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T22:15\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-22T22:23\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-23T08:49\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T23:42\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T22:13\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T23:42\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T22:35\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-19T22:37\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-22T22:18\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-22T22:23\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-22T22:24\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"09:37:19\", \"value\": [{\"add\": \"370 WEST OLD TOWN RD\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-06-24\", \"eno\": \"2075514535\", \"lob\": \"GA - 2026\", \"pno\": \"2072492780\", \"zip\": \"04468\", \"add2\": \"\", \"add3\": \"\", \"city\": \"OLD TOWN\", \"gend\": 0, \"insh\": \"10000114076\", \"mzip\": \"04468\", \"name\": \"Ronald A Murchison\", \"plan\": \"Martin\'s Point\", \"pphy\": \"OTTILLA BOROS\", \"ppno\": \"2079455247\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Jason Murchison - son\", \"madd1\": \"370 WEST OLD TOWN RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"OLD TOWN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 1599\", \"pcpnpi\": \"1245662642\", \"pcpzip\": \"04402\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BANGOR\", \"pcpname\": \"PENOBSCOT COMMUNITY HEALTH CENTER\", \"program\": \"Medicare\", \"evalDate\": \"2026-02-10 09:00:00 AM\", \"evalName\": \"Erin Barker, FNP\", \"pcpfaxno\": \"2079470435\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"2TW0D55AK44\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP change but same location\", \"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-09-2026\", \"time\": \"18:19:54\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 09:37:19\"}', NULL, NULL, '{\"memberId\": \"10000114076\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Fri, 20 Feb 2026 03:35:25 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin\\n1.  AOD Neuropsych PHQ9 score is 10.  Member is not receiving any treatment for depression at this time.\\n2.  Vital Signs pulse is 57.\\n3.  Exam Review neck and monofilament need answers.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Feb 2026 03:37:46 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin\\n1.  AOD Neuropsych PHQ9 score is 10.  Member is not receiving any treatment for depression at this time.\\n2.  Vital Signs pulse is 57.\\nPlease send a case management referral for number 1 and 2\\n3.  Exam Review neck and monofilament need answers.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 03:03:21 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. It\'s documented under psych that a CM referral was made, and I can see that it was previously submitted.\\n2. 57 must have been a typo, as my assessment said regular rate and rhythm. This has been fixed.\\n3. I did not perform neck or monofilament portions of the exam as it wasn\'t appropriate for the neck and he was up to date w/ his diabetic foot exam, which is why there is no documentation here.\\n\\nThank you!\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 03:18:32 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin\\n1.  The last question in the PHQ9 is not answered Thoughts that you would be better off dead or hurting yourself question is not answered.\\nAlso I do not see that a case management  referral has been sent for mental health follow up r/t the PHQ9 score of 10.  I will send one.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 03:24:58 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin\\n1.  The last question in the PHQ9 is not answered Thoughts that you would be better off dead or hurting yourself question is not answered.\\n\\nPlease disregard the info below.  I was not aware that the info for referrals has been changed to a different section in the HRA.  Sorry for the confusion on my behalf.\\n\\nAlso I do not see that a case management  referral has been sent for mental health follow up r/t the PHQ9 score of 10.  I will send one.\\n\\nThanks\\nJudi\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 13:49:10 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"No worries!\"}, \"mailId\": \"\"}], \"memberName\": \"Ronald Murchison\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/10/2026 09:00 AM\", \"clinicianMailId\": \"e.barker@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000114076, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000114076}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000114076, \"scheduleDate\": \"2026-02-10T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:56\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:08:25\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e2391423-4002-4ee3-a3d1-bd4660f9d328\\\",\\\"destination_fax_number\\\":\\\"12079470435\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"e2391423-4002-4ee3-a3d1-bd4660f9d328\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12079470435\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"PCHC Fax Server\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:56.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":244,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":244,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:38.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:56.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-10T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:59', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000114076\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Murchison_10000114076_02102026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:08:24\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000114076.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Murchison_10000114076_02102026.pdf', NULL, 'Summary_10000114076.pdf', NULL, '[{\"date\": \"2026-02-10T16:27:58.181Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T03:03:21.350Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T03:23:07.654Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T13:49:10.013Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-10T10:22', 'Member_Summary_10000114076.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000114076\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000114076.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:08:25\"}', 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
(107, 71932120, 44829497, '48822527', '10000050592', '', '', '14133640', 'Alan', 'Caron', 'English', '', '{\"DOB\": 18897, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": 1750580486, \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"JEFFREY GRASSMANN\", \"Rank_All\": 1, \"PCP_Phone\": 2078282402, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8XN8VQ6GJ26\", \"Member_City\": \"FREEPORT\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FREEPORT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-09-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 GANNETT DR STE C\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2078741483, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"5 WESTON POINT\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04032\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5 WESTON POINT\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04032\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Caron\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alan\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@06232021.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2072729531, \"Member_Identification_Number\": \"10000050592\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:08:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:08:28\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-24T17:52\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-26T15:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T15:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-22T17:04\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-22T17:04\", \"reportStatus_date\": \"2026-02-22T17:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T15:43\", \"reportStatus_date\": \"2026-02-26T15:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:08\", \"reportStatus_date\": \"2026-03-03T17:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:08\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-22T17:04\", \"username\": \"JLandry\"}], \"qaAssigned\": [{\"date\": \"2026-02-24T22:20\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-24T17:52\", \"username\": \"JLandry\"}, {\"date\": \"2026-02-24T17:52\", \"username\": \"JLandry\"}, {\"date\": \"2026-02-25T11:01\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-25T20:37\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T15:43\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-26T15:31\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T15:43\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-25T11:01\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"09:40:01\", \"value\": [{\"add\": \"5 WESTON POINT\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-09-26\", \"eno\": \"2072103396\", \"lob\": \"GA - 2026\", \"pno\": 2072729531, \"zip\": \"04032\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FREEPORT\", \"gend\": 0, \"insh\": \"10000050592\", \"mzip\": \"04032\", \"name\": \"Alan R Caron\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JEFFREY GRASSMANN\", \"ppno\": 2078282402, \"cliId\": \"\", \"email\": \"declined@06232021.com\", \"ename\": \"Kristina egan\", \"madd1\": \"5 WESTON POINT\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FREEPORT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DR STE C\", \"pcpnpi\": 1750580486, \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2078741483, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8XN8VQ6GJ26\", \"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-22-2026\", \"time\": \"17:04:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 09:40:01\"}', NULL, NULL, '{\"memberId\": \"10000050592\", \"clinician\": \"Jennifer Landry\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Wed, 25 Feb 2026 16:01:39 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Jennifer,\\n\\n1. Does the member have any allergies? Please answer yes or no in the allergy section. Please update.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 01:37:34 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Alan Caron\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/24/2026 03:40 PM\", \"clinicianMailId\": \"j.landry@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000050592, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": 10000050592}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": 10000050592, \"scheduleDate\": \"2026-02-24T15:40:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:56\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:08:28\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"00d407fc-150f-4ebe-ac94-8a3cf7a7e74f\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"00d407fc-150f-4ebe-ac94-8a3cf7a7e74f\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:15.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:48.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:58.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:12:17.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:24.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:15:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:49.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:10.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:23.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:22:30.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:44.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:25:55.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:15.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-24T15:40:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:59', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000050592\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Caron_10000050592_02242026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:08:27\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000050592.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Caron_10000050592_02242026.pdf', NULL, 'Summary_10000050592.pdf', NULL, '[{\"date\": \"2026-02-24T22:51:59.750Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-26T01:37:33.934Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-24T16:11', 'Member_Summary_10000050592.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000050592\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000050592.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:08:28\"}', 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
(108, 57818338, 44829497, '8715496', '10000051534', '', '', '14133640', 'David', 'Tebbets', 'English', '', '{\"DOB\": 18330, \"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\": \"1629074240\", \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Auburn\", \"Pcp_Name\": \"EDWIN TAN\", \"Rank_All\": 1, \"PCP_Phone\": \"2073303950\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4VU9Q82DH29\", \"Member_City\": \"DURHAM\", \"Office_Name\": \"AUBURN MEDICAL ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DURHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-03-08\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"2 Great Falls Plaza Second Floor Auburn\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2073303955\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"947 ROYALSBOROUGH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04222\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"947 ROYALSBOROUGH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04222\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Tebbets\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"tebbetsam@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2073532441\", \"Member_Identification_Number\": \"10000051534\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073300197\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:08:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:08:32\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-20T13:45\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-23T22:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-23T23:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-10T09:39\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-10T12:13\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-10T12:13\", \"reportStatus_date\": \"2026-02-10T12:13\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-23T23:34\", \"reportStatus_date\": \"2026-02-23T23:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:08\", \"reportStatus_date\": \"2026-03-03T17:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:08\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-02-10T09:39\", \"username\": \"GMedranoAdmin\"}], \"inProgress\": [{\"date\": \"2026-02-10T12:13\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-23T17:16\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-20T13:45\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-20T13:45\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-23T23:34\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T22:43\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-23T23:34\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"09:42:37\", \"value\": [{\"add\": \"947 ROYALSBOROUGH RD\", \"age\": 76, \"ano\": \"\", \"cno\": \"2073300197\", \"dob\": \"1950-03-08\", \"eno\": \"2073532441\", \"lob\": \"GA - 2026\", \"pno\": \"2073532441\", \"zip\": \"04222\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DURHAM\", \"gend\": 0, \"insh\": \"10000051534\", \"mzip\": \"04222\", \"name\": \"David J Tebbets\", \"plan\": \"Martin\'s Point\", \"pphy\": \"EDWIN TAN\", \"ppno\": \"2073303950\", \"cliId\": \"\", \"email\": \"tebbetsam@gmail.com\", \"ename\": \"Brenda Tebbets (sister)\", \"madd1\": \"947 ROYALSBOROUGH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DURHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"2 Great Falls Plaza Second Floor Auburn\", \"pcpnpi\": \"1629074240\", \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Auburn\", \"pcpname\": \"AUBURN MEDICAL ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073303955\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4VU9Q82DH29\", \"currentgend\": \"Female\", \"pphycomment\": \"verified with member\", \"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\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visits\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-09-2026\", \"time\": \"15:51:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 09:42:37\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000051534, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"33038445\", \"memberId\": 10000051534}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"33038445\", \"memberId\": 10000051534, \"scheduleDate\": \"2026-02-05T12:00:00\"}}', NULL, '{\"date\": \"02-10-2026 09:39:04\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:08:32\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ab0304d9-795b-4a42-a2c6-cfde15c80472\\\",\\\"destination_fax_number\\\":\\\"12073303955\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"ab0304d9-795b-4a42-a2c6-cfde15c80472\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12073303955\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:07.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\\\":306,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":306,\\\"start_timestamp\\\":\\\"2026-03-03T22:08:42.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:07.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-2-10T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:00', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000051534\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Tebbets_10000051534_02102026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:08:31\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000051534.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Tebbets_10000051534_02102026.pdf', NULL, 'Summary_10000051534.pdf', NULL, '[{\"date\": \"2026-02-20T18:45:04.234Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-10T13:29', 'Member_Summary_10000051534.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000051534\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000051534.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:08: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
(109, 57818338, 44829497, '34707077', '10000052452', '', '', '14133640', 'Carole', 'Thoits', 'English', '', '{\"DOB\": 16181, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"Anthony Bustamante\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Medicare_ID\": \"1PT0UH1UQ25\", \"Member_City\": \"Falmouth\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Falmouth\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-04-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"100 GANNETT DRIVE, SUITE C\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"21 SQUIDERE LN APT 204\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04105\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"21 SQUIDERE LN APT 204\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04105\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Thoits\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carole\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Carole.thoits@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2077475986, \"Member_Identification_Number\": \"10000052452\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:27:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:27:28\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-28T17:52\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-04T19:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-04T21:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-28T13:19\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-28T17:52\", \"reportStatus_date\": \"2026-02-28T17:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-04T21:37\", \"reportStatus_date\": \"2026-03-04T21:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:27\", \"reportStatus_date\": \"2026-03-10T14:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:27\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-28T13:19\", \"username\": \"JDoughty\"}], \"qaAssigned\": [{\"date\": \"2026-03-03T13:18\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-28T17:52\", \"username\": \"JDoughty\"}, {\"date\": \"2026-02-28T17:52\", \"username\": \"JDoughty\"}, {\"date\": \"2026-03-03T17:49\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-03T17:52\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-04T17:47\", \"username\": \"JDoughty\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-04T21:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-04T19:43\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-04T21:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-03T17:54\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"12:32:43\", \"value\": [{\"add\": \"21 SQUIDERE LN APT 204\", \"age\": 81, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1944-04-19\", \"eno\": \"2077475986\", \"lob\": \"GA - 2026\", \"pno\": 2077475986, \"zip\": \"04105\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Falmouth\", \"gend\": 1, \"insh\": \"10000052452\", \"mzip\": \"04105\", \"name\": \"Carole L Thoits\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Anthony Bustamante\", \"ppno\": \"2077745816\", \"race\": \"\", \"cliId\": \"\", \"email\": \"Carole.thoits@yahoo.com\", \"ename\": \"Carleton Thoits (husband) \", \"madd1\": \"21 SQUIDERE LN APT 204\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Falmouth\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 GANNETT DRIVE, SUITE C\", \"pcpnpi\": \"1487753125\", \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"evalDate\": \"2026-02-28 2:00:00 PM\", \"evalName\": \"Jessica Doughty, FNP\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1PT0UH1UQ25\", \"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-28-2026\", \"time\": \"17:48:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 12:32:43\"}', NULL, NULL, '{\"memberId\": \"10000052452\", \"clinician\": \"Jessica Doughty\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Tue, 03 Mar 2026 22:54:59 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Jessica\\n1.  Medical History DME devices question needs answer.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 04 Mar 2026 22:47:56 GMT\", \"name\": \"Jessica \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Carole Thoits\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/28/2026 02:00 PM\", \"clinicianMailId\": \"j.doughty@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000052452, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"34707077\", \"memberId\": 10000052452}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"34707077\", \"memberId\": 10000052452, \"scheduleDate\": \"2026-02-28T14:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:57\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:27:27\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"0afa96bf-bd1a-4c05-87d6-e6a9486b4abb\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"0afa96bf-bd1a-4c05-87d6-e6a9486b4abb\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367197\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:46:01.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:27:39.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:28:51.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:31:04.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:32:18.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:34:38.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:35:51.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:38:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:39:17.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:41:26.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:42:34.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-10T18:44:53.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:46:01.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-28T14:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:00', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000052452\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Thoits_10000052452_02282026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:27:26\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000052452.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Thoits_10000052452_02282026.pdf', NULL, 'Summary_10000052452.pdf', NULL, '[{\"date\": \"2026-02-28T22:52:17.932Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-04T22:47:55.773Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-28T15:05', 'Member_Summary_10000052452.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000052452\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000052452.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:27:27\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
