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
(35, NULL, NULL, '17537038', '10000086121', '', '', '14133640', 'Irma', 'Lovejoy', '', '', '{\"DOB\": 20483, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1528474814\", \"Pcp_Zip\": \"46433043\", \"Program\": \"Medicare\", \"Pcp_City\": \"HARRINGTON\", \"Pcp_Name\": \"PAINE, REBECCA H\", \"Rank_All\": 1, \"PCP_Phone\": \"2074834502\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9GE0K11FE25\", \"Member_City\": \"COLUMBIA FALLS\", \"Office_Name\": \"HARRINGTON FAMILY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"COLUMBIA FALLS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1956-01-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"PHYSICIAN ASSOCIATE\", \"Pcp_Address_1\": \"50 E MAIN ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Washington\", \"Member_Country\": \"Washington\", \"PCP_Fax_Number\": \"2074832525\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"206 CROSS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04623\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"206 CROSS RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04623\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Lovejoy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Irma\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Angel_al_dl@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2074832755\", \"Member_Identification_Number\": \"10000086121\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-05-2026 12:05:34\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-05 12:05:34\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T12:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-05T12:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T09:11\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2026-02-05T11:27\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2026-02-05T11:59\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-26T17:19\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-05T11:27\", \"reportStatus_date\": \"2026-02-05T11:59\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T17:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T12:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-05T11:27\", \"username\": \"GMedranoAdmin\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T09:11\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:26:41\", \"value\": [{\"add\": \"206 CROSS RD\", \"age\": 70, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1956-01-29\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074832755\", \"zip\": \"04623\", \"add2\": \"\", \"add3\": \"\", \"city\": \"COLUMBIA FALLS\", \"gend\": 1, \"insh\": \"10000086121\", \"mzip\": \"04623\", \"name\": \"Irma Lovejoy\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PAINE, REBECCA H\", \"ppno\": \"2074834502\", \"cliId\": \"\", \"email\": \"Angel_al_dl@yahoo.com\", \"ename\": \"\", \"madd1\": \"206 CROSS RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"COLUMBIA FALLS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"50 E MAIN ST,\", \"pcpnpi\": \"1528474814\", \"pcpzip\": \"46433043\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"HARRINGTON\", \"pcpname\": \"HARRINGTON FAMILY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2074832525\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9GE0K11FE25\", \"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-05-2026\", \"time\": \"09:11:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:26:41\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-05T11:27\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"GMedranoAdmin\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 11:54 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"4/8/2026 @ 11:51 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 01:01 PM\", \"result\": 14, \"comment\": \"Called to Schedule Virtual HRA with Amanda but member requested a F2F call back no virtual capabilities Mic issues when called  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 12:30 PM\", \"result\": 14, \"comment\": \"03/20/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken, MRB REQ A F2F C/B CANT DO VIRTUAL\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 04:02 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 02:53 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 12:05 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 05:19 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Nicole but member requested a call back member was not home  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"3/3/2026 @ 05:19 PM\"}, {\"date\": \"2/5/2026 @ 08:59 AM\", \"result\": 6, \"comment\": \"called to confirm if member wanted to reschedule she stated she was really sick and adv to callback next week to reschedule\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/11/2026 @ 08:57 AM\"}, {\"date\": \"2/3/2026 @ 04:18 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000086121, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000086121}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000086121, \"scheduleDate\": \"2026-02-05T10:30:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 08:59:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"03-05-2026 12:05:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, 'Virtual', '2026-02-05T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:39', 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
(36, 93442164, 44829497, '39698290', '10000020939', '', '', '14133640', 'Margaret', 'Felts', 'English', '', '{\"DOB\": 17804, \"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\": \"1134143514\", \"Pcp_Zip\": \"04055\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Naples \", \"Pcp_Name\": \"Charles Poulin\", \"Rank_All\": 1, \"PCP_Phone\": \"2076936106\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7A26EM2KA61\", \"Member_City\": \"Bridgton\", \"Office_Name\": \"Naples Family Practice\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bridgton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-09-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"410 Roosevelt Trail\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076934026\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"78 FOX CROSSING ROAD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04009\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 296\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04009\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Felts\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Margaret\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"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\": \"2076938012\", \"Member_Identification_Number\": \"10000020939\", \"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:05:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:20\", \"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-21T13:39\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-24T18:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-24T19:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-19T09:01\", \"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-21T13:39\", \"reportStatus_date\": \"2026-02-21T13:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-24T19:33\", \"reportStatus_date\": \"2026-02-24T19:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-19T09:01\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-23T16:49\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-21T13:39\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-21T13:39\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-24T19:33\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-24T18:31\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-24T19:33\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:28:46\", \"value\": [{\"add\": \"78 FOX CROSSING ROAD\", \"age\": 77, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-09-28\", \"eno\": \"2077565651\", \"lob\": \"GA - 2026\", \"pno\": \"2076938012\", \"zip\": \"04009\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Bridgton\", \"gend\": 1, \"insh\": \"10000020939\", \"mzip\": \"04009\", \"name\": \"Margaret L Felts\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Charles Poulin\", \"ppno\": \"2076936106\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"William Felts\", \"madd1\": \"PO BOX 296\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bridgton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"410 Roosevelt Trail\", \"pcpnpi\": \"\", \"pcpzip\": \"04055\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Naples \", \"pcpname\": \"Naples Family Practice\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076934026\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7A26EM2KA61\", \"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-18-2026\", \"time\": \"16:02:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 17:25:15\"}', 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\": 10000020939, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000020939}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000020939, \"scheduleDate\": \"2026-02-19T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:38\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:19\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"096575ca-ffba-448e-b530-b1e0c53ccb34\\\",\\\"destination_fax_number\\\":\\\"12076934026\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"096575ca-ffba-448e-b530-b1e0c53ccb34\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12076934026\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:37.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\\\":329,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":329,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:48.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:37.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-19T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:40', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000020939\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Felts_10000020939_02192026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:19\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000020939.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Felts_10000020939_02192026.pdf', NULL, 'Summary_10000020939.pdf', NULL, '[{\"date\": \"2026-02-21T18:39:01.603Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-19T14:51', 'Member_Summary_10000020939.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000020939\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000020939.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:20\"}', 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
(37, NULL, NULL, '39698290', '10000021047', '', '', '14133640', 'Roger', 'Deschenes', '', '', '{\"DOB\": 11988, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1194801993\", \"Pcp_Zip\": \"42633418\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"RIVARD, GARY S\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6XT9K43TP14\", \"Member_City\": \"Turner\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Turner\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1932-10-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"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\": \"2076476015\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"339 PLEASANT POND RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04282\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"339 PLEASANT POND RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04282\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Deschenes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Roger\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"joan@jdmaine.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075762667\", \"Member_Identification_Number\": \"10000021047\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2072242252\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Member lost two teeth`s he have to see a dentist tomorrow\"}', 1, b'0', b'0', '{\"date\": \"03-16-2026 10:33:43\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-03-16 10:33:43\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T16:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-09T11:40\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-09T16:02\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-16T10:33\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-09T11:40\", \"reportStatus_date\": \"2026-02-09T16:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-03T16:31\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-16T10:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-09T11:40\", \"username\": \"RDodoye\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"00:50:05\", \"value\": [{\"add\": \"339 PLEASANT POND RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2072242252\", \"dob\": \"1932-10-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075762667\", \"zip\": \"04282\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Turner\", \"gend\": 0, \"insh\": \"10000021047\", \"mzip\": \"04282\", \"name\": \"Roger A Deschenes\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RIVARD, GARY S\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"joan@jdmaine.com\", \"ename\": \"\", \"madd1\": \"339 PLEASANT POND RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Turner\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD,STE 1\", \"pcpnpi\": \"1194801993\", \"pcpzip\": \"42633418\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076476015\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6XT9K43TP14\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:49:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 00:50:05\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-09T11:40\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"RDodoye\", \"hraStatus\": 3, \"cancelText\": \"Member lost two teeth`s he have to see a dentist tomorrow\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"3/16/2026 @ 10:33 AM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Amanda but member requested a call back member is in the hospital and its not looking to good (Please give a few weeks before reaching back out)\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"5/5/2026 @ 10:33 AM\"}, {\"date\": \"3/3/2026 @ 04:31 PM\", \"result\": 3, \"comment\": \"Called to reschedule a virtual IHA w/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/6/2026 @ 04:30 PM\"}, {\"date\": \"2/9/2026 @ 04:02 PM\", \"result\": 6, \"comment\": \"The member\'s wife called and requested a call back in a few weeks to reschedule the appointment.\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/2/2026 @ 10:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000021047, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000021047}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000021047, \"scheduleDate\": \"2026-02-10T10:30:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 16:02:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"02-09-2026 11:40:19\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, 'In Person', '2026-02-10T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49: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
(38, 71932120, 44829497, '12383693', '10000021602', '', '', '14133640', 'Hermon', 'Gile', 'English', '', '{\"DOB\": 15747, \"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\": \"1871559203\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"DAVID PRESTON\", \"Rank_All\": 1, \"PCP_Phone\": \"2078731098\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4R42T88XK81\", \"Member_City\": \"Sidney\", \"Office_Name\": \"THAYER INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Sidney\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-02-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"325B Kennedy Memorial Dr\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078735461\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"22 SUNSET RIDGE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04330\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"22 SUNSET RIDGE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04330\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gile\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Hermon\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"chgile1@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\": \"No\", \"Member_Primary_Phone_Number\": \"2075474824\", \"Member_Identification_Number\": \"10000021602\", \"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:05:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:24\", \"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-12T16:28\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T17:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T21:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-02-10T09:05\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-02-11T18:05\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"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\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-13T18:25\", \"reportStatus_date\": \"2026-02-12T16:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T21:08\", \"reportStatus_date\": \"2026-02-19T21:08\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-02-10T09:05\", \"username\": null}, {\"date\": \"2026-02-10T09:05\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-02-11T18:05\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-02-13T13:47\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-12T16:28\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-12T16:28\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-13T18:07\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-13T18:10\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-13T18:13\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-13T18:16\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-13T18:19\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-13T18:22\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-13T18:25\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-18T23:04\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T21:08\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T17:38\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T21:08\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-13T18:25\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-18T22:41\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T22:44\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T22:47\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T22:50\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T22:53\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T22:56\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T22:59\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T23:02\", \"username\": \"KBaxter\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:31:30\", \"value\": [{\"add\": \"22 SUNSET RIDGE\", \"age\": 83, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1943-02-10\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2075474824\", \"zip\": \"04330\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Sidney\", \"gend\": 0, \"insh\": \"10000021602\", \"mzip\": \"04330\", \"name\": \"Hermon E Gile\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DAVID PRESTON\", \"ppno\": \"2078731098\", \"cliId\": \"\", \"email\": \"chgile1@gmail.com\", \"ename\": \"\", \"madd1\": \"22 SUNSET RIDGE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Sidney\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"325B Kennedy Memorial Dr\", \"pcpnpi\": \"1871559203\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"THAYER INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078735461\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4R42T88XK81\", \"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-10-2026\", \"time\": \"15:33:49\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 17:37:51\"}', NULL, NULL, '{\"memberId\": \"10000021602\", \"clinician\": \"Kathryn Baxter\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Fri, 13 Feb 2026 23:25:45 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Kathryn,\\n\\n1. The member is on medication for hyperlipidemia. However, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition?\\n2. The member is on medication for GERD. However, the condition was not addressed in the assessment of diagnosis gastrointestinal section. Is this an active ongoing condition?\\n3. The member is on medication for neuropathy/phantom limb. However, the condition was not addressed in the assessment of diagnosis neuro-psych section. Is this an active ongoing condition?\\n4. The member is on medication for eczema. However, the condition was not addressed in the assessment of diagnosis integument section. Is this an active ongoing condition?\\n5. Hypothyroidism was marked \\\"history of\\\". However, the member is currently taking medication for hypothyroidism. Please clarify.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Feb 2026 04:04:49 GMT\", \"name\": \"Kathryn \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Hi Joseph, \\nBear with me,  I am new.  Next time please send me the initials, it still takes me a while to find things!\\nI had phantom limb pain in  musculoskeletal and pain but  moved it to   neuro.\\nHe has no history of GERD. He was started on Pantoprazole because of ulcers which has since healed and not a problem while he is on the med. \\nFixed hypothyroid/eczema, I didn\'t save.  \\nLet me know anything else, thank you. \\n\"}, \"mailId\": \"\"}], \"memberName\": \"Hermon Gile\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/12/2026 10:30 AM\", \"clinicianMailId\": \"k.baxter@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"2/10/2026 @ 09:05 AM\", \"result\": 12, \"comment\": \"appointment was sched for 2/12 at 10:30 am - updating the date/time\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000021602\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": \"10000021602\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": \"10000021602\", \"scheduleDate\": \"2026-2-12T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-10-2026 09:05:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-10-2026 09:05:33\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:24\", \"status\": 0, \"message\": \"Busy. The destination number was busy.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"8b33a1a8-b2a8-4d9a-af25-42f1e49ec6d7\\\",\\\"destination_fax_number\\\":\\\"12078735461\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"8b33a1a8-b2a8-4d9a-af25-42f1e49ec6d7\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12078735461\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:19:12.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:05:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:06:18.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:08:22.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:42.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:10:59.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:15.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:13:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:56.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:16:10.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:16:35.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:18:54.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:19:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-12T10:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:40', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000021602\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Gile_10000021602_02122026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:23\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000021602.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Gile_10000021602_02122026.pdf', NULL, 'Summary_10000021602.pdf', NULL, '[{\"date\": \"2026-02-12T21:28:54.878Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-19T04:04:48.969Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-12T11:30', 'Member_Summary_10000021602.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000021602\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000021602.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:24\"}', 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
(39, 71932120, 44829497, '12383693', '10000021701', '', '', '14133640', 'Mack', 'Moody', 'English', '', '{\"DOB\": 16060, \"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\": \"1700224094\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"TRISTAN REYNOLDS\", \"Rank_All\": 1, \"PCP_Phone\": \"2078615000\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4E08E78WU24\", \"Member_City\": \"Benton\", \"Office_Name\": \"MAINE DARTMOUTH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Benton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1943-12-20\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"149 North St Dept Family Med\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078615101\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"29 SIDING STREET\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"29 SIDING STREET\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Moody\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mack\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"mmoody43@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2074310224\", \"Member_Identification_Number\": \"10000021701\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074530107\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:29\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-11T14:05\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T17:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T21:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-10T12:48\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-11T14:05\", \"reportStatus_date\": \"2026-02-11T14:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T21:11\", \"reportStatus_date\": \"2026-02-19T21:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-10T12:48\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:19\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T16:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-11T14:05\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-11T14:05\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-18T20:31\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-18T20:34\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-18T20:37\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-18T23:11\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T21:11\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T17:39\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T21:11\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-18T20:37\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:34:32\", \"value\": [{\"add\": \"29 SIDING STREET\", \"age\": 82, \"ano\": \"\", \"cno\": \"2074530107\", \"dob\": \"1943-12-20\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2074310224\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Benton\", \"gend\": 0, \"insh\": \"10000021701\", \"mzip\": \"04901\", \"name\": \"Mack M Moody\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TRISTAN REYNOLDS\", \"ppno\": \"2078615000\", \"cliId\": \"\", \"email\": \"mmoody43@yahoo.com\", \"ename\": \"\", \"madd1\": \"29 SIDING STREET\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Benton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"149 North St Dept Family Med\", \"pcpnpi\": \"1700224094\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"MAINE DARTMOUTH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078615101\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4E08E78WU24\", \"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-09-2026\", \"time\": \"17:01:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-01-2026 16:52:54\"}', NULL, NULL, '{\"memberId\": \"10000021701\", \"clinician\": \"Kathryn Baxter\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 01:37:46 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Kathryn,\\n\\n1. The member is medication for hyperlipidemia. However, the condition was not addressed in the in the assessment of diagnosis, cardiovascular section. Is this an active ongoing condition? Please clarify.\\n2. The member is currently on medication for BPH. However, BPH was marked as history of. Since the member is actively taking medication for BPH, it is considered as active. Please clarify.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Feb 2026 04:11:04 GMT\", \"name\": \"Kathryn \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Mack Moody\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/11/2026 10:30 AM\", \"clinicianMailId\": \"k.baxter@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\": 10000021701, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": 10000021701}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": 10000021701, \"scheduleDate\": \"2026-02-11T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:39\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:27\", \"status\": 0, \"message\": \"Busy. The destination number was busy.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ae991849-95be-42e8-9a7f-e694b3d31779\\\",\\\"destination_fax_number\\\":\\\"12078615101\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"ae991849-95be-42e8-9a7f-e694b3d31779\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12078615101\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:27.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:05:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:06:15.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:08:47.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:19.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:11:53.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:18.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:14:24.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:01.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:17:10.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:38.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:19:50.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:27.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-11T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:41', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000021701\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Moody_10000021701_02112026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:26\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000021701.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Moody_10000021701_02112026.pdf', NULL, 'Summary_10000021701.pdf', NULL, '[{\"date\": \"2026-02-11T19:05:36.433Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-19T04:11:03.798Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-11T11:30', 'Member_Summary_10000021701.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000021701\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000021701.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:28\"}', 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
(40, 55499828, 44829497, '39698290', '10000043571', '', '', '14133640', 'Charles', 'Farrell', '', '', '{\"DOB\": 18543, \"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\": \"1306229521\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"ANTHONY BUSTAMANTE\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7VF0RW3GN23\", \"Member_City\": \"DURHAM\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DURHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-10-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2075238586\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"408 DAVIS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04222\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"408 DAVIS RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04222\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Farrell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Charles\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"FARRELLFRAMES@COMCAST.NET\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2074073026\", \"Member_Identification_Number\": \"10000043571\", \"Member_Alternate_Phone_Number\": \"2074073026\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-24-2026 14:56:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-24 14:56:21\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-16T16:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-18T12:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-18T14:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-24T14:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-12T08:59\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-16T16:24\", \"reportStatus_date\": \"2026-03-16T16:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-18T14:33\", \"reportStatus_date\": \"2026-03-18T14:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-24T14:56\", \"reportStatus_date\": \"2026-03-24T14:56\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2026-03-24T14:56\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-03-12T08:59\", \"username\": \"admin\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-03-16T16:24\", \"username\": \"AWalsh\"}, {\"date\": \"2026-03-17T08:34\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-17T19:11\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [{\"date\": \"2026-03-18T12:47\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-18T14:33\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-17T08:35\", \"username\": \"HBeck\"}, {\"date\": \"2026-03-17T19:10\", \"username\": \"SCadwell\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"19:09:18\", \"value\": [{\"add\": \"408 DAVIS RD\", \"age\": 75, \"ano\": \"2074073026\", \"cno\": \"\", \"dob\": \"1950-10-07\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2074073026\", \"zip\": \"04222\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DURHAM\", \"gend\": 0, \"insh\": \"10000043571\", \"mzip\": \"04222\", \"name\": \"Charles J Farrell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ANTHONY BUSTAMANTE\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"FARRELLFRAMES@COMCAST.NET\", \"ename\": \"\", \"madd1\": \"408 DAVIS RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DURHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"259 Main St\", \"pcpnpi\": \"1306229521\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238586\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7VF0RW3GN23\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"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\": \"03-12-2026\", \"time\": \"08:59:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-02-2026 14:06:39\"}', NULL, NULL, '{\"memberId\": \"10000043571\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Tue, 17 Mar 2026 12:35:50 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\n1) please add marital status and emergency contact\\n2) under vitals can you add decimal for temperature currently says 981 \\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 17 Mar 2026 23:11:12 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I have completed the below however  in my view I cannot see  emergency contact or diagnoses in medlist.  I am asking for this HRA go to IT\"}, \"mailId\": \"\"}], \"memberName\": \"Charles Farrell\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/02/2026 01:30 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000043571, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000043571}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000043571, \"scheduleDate\": \"2026-02-02T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:39\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:31\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"27e3c674-0b6b-4bbc-89f7-6e8402f435c4\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"27e3c674-0b6b-4bbc-89f7-6e8402f435c4\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2075238586\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:53.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\\\":225,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":225,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:41.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:53.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}, {\"date\": \"2026-03-24 14:56:19\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ec11bbaa-80ea-494b-9c1f-1a7ce661d569\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"ec11bbaa-80ea-494b-9c1f-1a7ce661d569\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:09:05.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-24T18:56:34.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T18:56:53.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T18:59:06.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T18:59: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-24T19:01:28.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:01:47.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:04:05.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:04:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:06:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:06:40.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-24T19:08:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-24T19:09:05.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-02T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:41', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000043571\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Farrell_10000043571_02022026.pdf\", \"ftp_upload_date\": \"2026-03-24 14:56:17\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000043571.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Farrell_10000043571_02022026.pdf', NULL, 'Summary_10000043571.pdf', NULL, '[{\"date\": \"2026-02-03T02:26:36.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-17T23:11:11.846Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-02T14:30', 'Member_Summary_10000043571.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000043571\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000043571.pdf\", \"member_ftp_upload_date\": \"2026-03-24 14:56:20\"}', 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
(41, 55499828, 44829497, '27743162', '10000023194', '', '', '14133640', 'Stephen', 'Kittredge', 'English', '', '{\"DOB\": 15614, \"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\": \"1477992097\", \"Pcp_Zip\": \"04104\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"MEAGAN KINGMAN\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2M00FY6UR42\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-09-30\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078282433\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"425 BROADWAY EAST APT 711\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"425 BROADWAY EAST APT 711\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Kittredge\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephen\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@03312025.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\": \"2077991198\", \"Member_Identification_Number\": \"10000023194\", \"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:05:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:36\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:46:48\", \"value\": [{\"add\": \"425 BROADWAY EAST APT 711\", \"age\": 83, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1942-09-30\", \"eno\": \"2078293881\", \"lob\": \"GA - 2026\", \"pno\": \"2077991198\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000023194\", \"mzip\": \"04106\", \"name\": \"Stephen F Kittredge\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MEAGAN KINGMAN\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"declined@03312025.com\", \"ename\": \"Patricia Powers\", \"madd1\": \"425 BROADWAY EAST APT 711\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746\", \"pcpnpi\": \"1477992097\", \"pcpzip\": \"04104\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078282433\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2M00FY6UR42\", \"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-10-2026\", \"time\": \"10:18:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-02-2026 14:29:49\"}', NULL, NULL, '{\"memberId\": \"10000023194\", \"clinician\": \"Shellie Hafer\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"2026-02-03T12:46:59.969Z\", \"name\": \"Holly Beck\", \"role\": \"QA\", \"files\": [], \"query\": {\"feedback\": \"Hey Shellie, Can you update Exam review section, currently no boxes are selected \", \"response\": \"\"}, \"mailId\": \"h.beck@focuscares.com\"}, {\"date\": \"2026-02-03T13:14:13.851Z\", \"name\": \"Shellie Hafer\", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"Ok, I knew I forgot it and the VS and have now updated Shellie \", \"response\": \"\"}, \"mailId\": \"s.hafer@focuscares.com\"}], \"memberName\": \"Stephen Kittredge\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/02/2026 10:30 AM\", \"clinicianMailId\": \"s.hafer@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"2/3/2026 @ 02:15 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000023194, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": 10000023194}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": 10000023194, \"scheduleDate\": \"2026-02-02T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:39\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:05:35\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"92329b76-645f-40e6-9132-53ccb740f085\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"92329b76-645f-40e6-9132-53ccb740f085\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12078282433\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552411835 12      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:20.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":248,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":248,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:20.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-02T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:41', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000023194\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Kittredge_10000023194_02022026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:34\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000023194.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Kittredge_10000023194_02022026.pdf', NULL, 'Summary_10000023194.pdf', NULL, '[{\"date\": \"2026-02-02T16:09:37.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-02T11:08', 'Member_Summary_10000023194.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000023194\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000023194.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:36\"}', 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
(42, 71932120, 44829497, '17537038', '10000023928', '', '', '14133640', 'Barbara', 'Gould', 'English', '', '{\"DOB\": 16240, \"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\": \"1083683833\", \"Pcp_Zip\": \"03801\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Portsmouth\", \"Pcp_Name\": \"DANIEL DAVIES\", \"Rank_All\": 1, \"PCP_Phone\": \"6034338434\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"8FX0P19KD38\", \"Member_City\": \"Berwick\", \"Office_Name\": \"BEACON INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Berwick\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-06-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"155 Borthwick Ave W Bldg Ste 202\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"6034335196\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"15 FOX RIDGE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"03901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 FOX RIDGE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"03901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gould\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Barbara\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Samgould4344@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\": \"2076984899\", \"Member_Identification_Number\": \"10000023928\", \"Member_Alternate_Phone_Number\": \"6035052238\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:40\", \"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-04T23:19\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-16T19:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-16T23:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-04T15:06\", \"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\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-09T20:26\", \"reportStatus_date\": \"2026-02-04T23:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-16T23:22\", \"reportStatus_date\": \"2026-02-16T23:22\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T15:06\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-05T12:14\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-04T23:19\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-04T23:19\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-11T11:36\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-14T05:00\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-16T23:22\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-16T19:42\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-16T23:22\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-09T20:26\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-11T15:43\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:51:12\", \"value\": [{\"add\": \"15 FOX RIDGE DR\", \"age\": 81, \"ano\": \"6035052238\", \"cno\": \"\", \"dob\": \"1944-06-17\", \"eno\": \"2076984899\", \"lob\": \"GA - 2026\", \"pno\": \"2076984899\", \"zip\": \"03901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Berwick\", \"gend\": 1, \"insh\": \"10000023928\", \"mzip\": \"03901\", \"name\": \"Barbara A Gould\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DANIEL DAVIES\", \"ppno\": \"6034338434\", \"cliId\": \"\", \"email\": \"Samgould4344@gmail.com\", \"ename\": \"Arnold (Sam) Husband\", \"madd1\": \"15 FOX RIDGE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Berwick\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"155 Borthwick Ave W Bldg Ste 202\", \"pcpnpi\": \"1083683833\", \"pcpzip\": \"03801\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Portsmouth\", \"pcpname\": \"BEACON INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"6034335196\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8FX0P19KD38\", \"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-04-2026\", \"time\": \"15:06:53\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-02-2026 14:38:39\"}', NULL, NULL, '{\"memberId\": \"10000023928\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Tue, 10 Feb 2026 01:26:58 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1. Please add the route and frequency of the meds on the medication list.\\n2. Please add the details to valvular disease in the assessment of diagnosis cardiovascular section.\\n3. Please answer yes or no in the assessment of diagnosis gastrointestinal section of the HRA.\\n4. The member\'s BMI was noted as 27.2. However, BMI 27.2 falls under \\\"overweight category\\\". Please clarify.\\n5. Please add a comments/note in the patient summary.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 16:36:38 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\\n1. Please add the route and frequency of the meds on the medication list. - complete \\n2. Please add the details to valvular disease in the assessment of diagnosis cardiovascular section. - complete \\n3. Please answer yes or no in the assessment of diagnosis gastrointestinal section of the HRA. - complete \\n4. The member\'s BMI was noted as 27.2. However, BMI 27.2 falls under \\\"overweight category\\\". Please clarify. - corrected\\n5. Please add a comments/note in the patient summary.\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 20:43:26 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\nPlease remove the query I sent you out of the patient summary.\\n\\nThank you\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 14 Feb 2026 10:00:24 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \" I have made the changes. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Barbara Gould\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/04/2026 03:00 PM\", \"clinicianMailId\": \"a.milliken@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\": 10000023928, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000023928}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000023928, \"scheduleDate\": \"2026-02-04T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:40\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:40\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"5a59141f-a70a-4f27-a77c-16138c4f6590\\\",\\\"destination_fax_number\\\":\\\"16034335196\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"5a59141f-a70a-4f27-a77c-16138c4f6590\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"16034335196\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:35.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:05:56.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:07:07.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:09:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:50.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:12:53.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:08.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:16:22.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:17:37.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:00.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:23:24.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:35.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-04T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:41', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000023928\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Gould_10000023928_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:38\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000023928.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Gould_10000023928_02042026.pdf', NULL, 'Summary_10000023928.pdf', NULL, '[{\"date\": \"2026-02-05T04:19:16.247Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-11T16:36:38.390Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-14T10:00:24.001Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T15:53', 'Member_Summary_10000023928.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000023928\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000023928.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:40\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
