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
(265, 62035418, 44829497, '39698290', '10000050603', '', '', '14133640', 'Mary Kay', 'Christensen', 'English', '', '{\"DOB\": 18734, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": \"1821095241\", \"Pcp_Zip\": \"04074\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"SHERI CLARK\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7PN6NA4VW46\", \"Member_City\": \"HOLLIS\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BUXTON\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-04-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"153 US Rte 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"19 NATHAN SMITH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04042\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 401\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04093\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Christensen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mary Kay\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"MAKACHRISTENSEN@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\": \"2076715902\", \"Member_Identification_Number\": \"10000050603\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2076715902\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:18:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:18:34\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-11T15:43\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-15T20:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-16T13:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T12:41\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-05T12:41\", \"reportStatus_date\": \"2026-02-05T12:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-16T13:37\", \"reportStatus_date\": \"2026-02-16T13:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:18\", \"reportStatus_date\": \"2026-03-03T17:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:18\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T12:41\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:22\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-11T15:43\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-11T15:43\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-16T13:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-15T20:23\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-16T13:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"09:12:28\", \"value\": [{\"add\": \"19 NATHAN SMITH RD\", \"age\": 74, \"ano\": \"\", \"cno\": \"2076715902\", \"dob\": \"1951-04-16\", \"eno\": \"2076715553\", \"lob\": \"GA - 2026\", \"pno\": \"2076715902\", \"zip\": \"04042\", \"add2\": \"\", \"add3\": \"\", \"city\": \"HOLLIS\", \"gend\": 1, \"insh\": \"10000050603\", \"mzip\": \"04093\", \"name\": \"Mary Kay Christensen\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SHERI CLARK\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"MAKACHRISTENSEN@GMAIL.COM\", \"ename\": \"Joshua Christiansen \", \"madd1\": \"PO BOX 401\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BUXTON\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"153 US Rte 1\", \"pcpnpi\": \"1821095241\", \"pcpzip\": \"04074\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7PN6NA4VW46\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"09:54:36\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 09:12:28\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 03:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000050603, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000050603}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000050603, \"scheduleDate\": \"2026-02-05T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:35\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235019}', 0, NULL, '[{\"date\": \"2026-03-03 17:18:33\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ea539508-174e-11f1-8429-4924fcbdd443\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-02-05T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:42', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000050603\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Christensen_10000050603_02052026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:18:32\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000050603.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Christensen_10000050603_02052026.pdf', NULL, 'Summary_10000050603.pdf', NULL, '[{\"date\": \"2026-02-11T20:43:07.653Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-05T13:30', 'Member_Summary_10000050603.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000050603\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000050603.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:34\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(266, NULL, NULL, '17537038', '10000052386', '', '', '14133640', 'Melissa', 'Obrien', '', '', '{\"DOB\": 22943, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1861451080\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"PIERCE, DANIEL C\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5H34DT7MA01\", \"Member_City\": \"GRAY\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GRAY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1962-10-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"127 SHAKER RD 48\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"127 SHAKER RD 48\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Obrien\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melissa\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"papatrem@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073762059\", \"Member_Identification_Number\": \"10000052386\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":\"0\",\"cancelText\":\"member declined virtual appointment. did not wish to attempt an electronic methods. willing to do in person \"}', 1, b'0', b'0', '{\"date\": \"04-06-2026 13:54:20\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}', '{\"date\": \"2026-04-06 13:54:20\", \"hrastatus\": \"\", \"reportstatus\": \"Cancellation\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T15:12\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T12:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T09:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T10:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T15:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [{\"date\": \"2026-02-15T20:44\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-26T15:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-04-03T12:56\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-04-06T13:02\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-04-01T12:59\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-04-06T13:54\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-26T14:01\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"F2F No Show\", \"type\": \"ReportStatus\", \"status\": 24, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-15T20:44\", \"reportStatus_date\": \"2026-02-15T20:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T09:43\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T14:01\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T15:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-26T15:09\", \"reportStatus_date\": \"2026-03-26T15:09\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-04-06T13:54\", \"reportStatus_date\": \"2026-04-06T13:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-15T20:44\", \"username\": \"SCadwell\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-03-26T15:09\", \"username\": null}, {\"date\": \"2026-03-26T15:09\", \"username\": \"FBeckford\"}, {\"date\": \"2026-04-03T12:56\", \"username\": null}, {\"date\": \"2026-04-03T12:56\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-04-06T13:02\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-04-01T12:59\", \"username\": \"AMilliken\"}, {\"date\": \"2026-04-06T13:54\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:07:04\", \"value\": [{\"add\": \"127 SHAKER RD 48\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-10-24\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073762059\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GRAY\", \"gend\": 1, \"insh\": \"10000052386\", \"mzip\": \"04039\", \"name\": \"Melissa A Obrien\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PIERCE, DANIEL C\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"papatrem@yahoo.com\", \"ename\": \"\", \"madd1\": \"127 SHAKER RD 48\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GRAY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": \"1861451080\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5H34DT7MA01\", \"currentgend\": \"Female\", \"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-30-2026\", \"time\": \"12:28:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:07:04\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-15T20:44\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"SCadwell\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-04-01T12:59\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"did not present to doxy or return messages by provider\", \"cancelStatus\": \"0\"}, {\"date\": \"2026-04-06T13:54\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"member declined virtual appointment. did not wish to attempt an electronic methods. willing to do in person \", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"4/3/2026 @ 12:56 PM\", \"result\": 12, \"comment\": \"Scheduled with Amanda Millikin 4/6/2026 @ 1:00pm virtual\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 03:09 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 29th at 2:00PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 10:44 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer No VM Setup. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 03:39 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 02:49 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- no vm setup\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 02:12 PM\", \"result\": 3, \"comment\": \"called to schedule with Amanda Milliken. LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Maccimene  Jean\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 02:01 PM\", \"result\": 6, \"comment\": \"o/c to sched w/Jennifer 3/5 - member in the hospital c/b in a week\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/5/2026 @ 02:01 PM\"}, {\"date\": \"2/24/2026 @ 10:59 AM\", \"result\": 3, \"comment\": \"o/c to schedule F2F w/Sandy 3/9/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/25/2026 @ 10:58 AM\"}, {\"date\": \"2/23/2026 @ 09:43 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leana no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/26/2026 @ 09:42 AM\"}, {\"date\": \"2/20/2026 @ 12:04 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 12:04 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000052386\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000052386\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000052386\", \"scheduleDate\": \"2026-4-6T13:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 12:04:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"04-06-2026 13:54:20\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 0}', '{\"orderType\": 1, \"sortOrder\": 1775498060}', 1, NULL, NULL, 'Virtual', '2026-4-6T13:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(267, NULL, NULL, '45509507', '10000056497', '', '', '14133640', 'Marc', 'Mutty', '', '', '{\"DOB\": 17980, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1861451080\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"PIERCE, DANIEL C\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9D99HH8NX16\", \"Member_City\": \"Bath\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bath\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-03-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"38 WEST CHOPS POINT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04530\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"38 WEST CHOPS POINT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04530\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mutty\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marc\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"marron2@aol.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078313148\", \"Member_Identification_Number\": \"10000056497\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-04-2026 09:38:07\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-04 09:38:07\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-09T17:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T14:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T14:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T16:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-04T09:38\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-08T08:41\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2026-02-08T14:58\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-08T14:58\", \"reportStatus_date\": \"2026-02-09T17:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T14:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-18T16:17\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-04T09:38\", \"reportStatus_date\": \"2026-03-04T09:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-08T14:58\", \"username\": \"JWinslow\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-08T08:41\", \"username\": \"JWinslow\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-04T09:38\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:09:48\", \"value\": [{\"add\": \"38 WEST CHOPS POINT RD\", \"age\": 76, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-03-23\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078313148\", \"zip\": \"04530\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Bath\", \"gend\": 0, \"insh\": \"10000056497\", \"mzip\": \"04530\", \"name\": \"Marc R Mutty\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PIERCE, DANIEL C\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"marron2@aol.com\", \"ename\": \"\", \"madd1\": \"38 WEST CHOPS POINT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bath\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": \"1861451080\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9D99HH8NX16\", \"currentgend\": \"\", \"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\": \"02-08-2026\", \"time\": \"08:41:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:09:48\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-08T14:58\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JWinslow\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [{\"date\": \"2026-03-04T09:38\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/4/2026 @ 09:38 AM\", \"result\": 9, \"comment\": \"Called to Schedule F2F HRA with Samuel but member refused. sees and bunch of doctors and has allot  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 04:17 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"2/20/2026 @ 04:17 PM\"}, {\"date\": \"2/12/2026 @ 02:44 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/16/2026 @ 02:44 PM\"}, {\"date\": \"2/11/2026 @ 02:01 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/13/2026 @ 02:00 PM\"}, {\"date\": \"2/9/2026 @ 05:33 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/11/2026 @ 05:33 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000056497, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"45509507\", \"memberId\": 10000056497}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"45509507\", \"memberId\": 10000056497, \"scheduleDate\": \"2026-02-08T08:30:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 17:33:00\", \"schedulerId\": \"24168610\", \"schedulerLeadId\": \"24168610\"}]}', '{\"date\": \"02-08-2026 14:58:35\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, 'Virtual', '2026-02-08T08:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:43', 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
(268, 57818338, 44829497, '12383693', '10000058206', '', '', '14133640', 'Hamlyn', 'Robbins', 'English', '', '{\"DOB\": 19077, \"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\": 1306885207, \"Pcp_Zip\": \"04330\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Augusta\", \"Pcp_Name\": \"PETER GUZZETTI\", \"Rank_All\": 1, \"PCP_Phone\": 2076238434, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7QT7ER3NK51\", \"Member_City\": \"READFIELD\", \"Office_Name\": \"KENNEBEC INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"READFIELD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-03-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"9 Glenridge Dr\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": 2076214370, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"254 SOUTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04355\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"254 SOUTH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04355\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Robbins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Hamlyn\", \"Member_Middle_name\": \"N\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"hamrobbins@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2072702720, \"Member_Identification_Number\": \"10000058206\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:18:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:18:41\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-25T15:26\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-26T23:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T23:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T12:45\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-24T22:21\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-25T09:12\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T23:51\", \"reportStatus_date\": \"2026-02-26T23:51\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:18\", \"reportStatus_date\": \"2026-03-03T17:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:18\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-02-24T22:21\", \"username\": \"AWalsh\"}], \"inProgress\": [{\"date\": \"2026-02-24T12:45\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-25T09:12\", \"username\": \"KBaxter\"}], \"qaAssigned\": [{\"date\": \"2026-02-26T11:25\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-25T15:26\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-25T15:26\", \"username\": \"KBaxter\"}, {\"date\": \"2026-02-26T14:15\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-26T16:14\", \"username\": \"KBaxter\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T23:51\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-26T23:22\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T23:51\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-26T14:15\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"09:22:38\", \"value\": [{\"add\": \"254 SOUTH RD\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-03-24\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": 2072702720, \"zip\": \"04355\", \"add2\": \"\", \"add3\": \"\", \"city\": \"READFIELD\", \"gend\": 0, \"insh\": \"10000058206\", \"mzip\": \"04355\", \"name\": \"Hamlyn N Robbins\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PETER GUZZETTI\", \"ppno\": 2076238434, \"cliId\": \"\", \"email\": \"hamrobbins@roadrunner.com\", \"ename\": \"\", \"madd1\": \"254 SOUTH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"READFIELD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"9 Glenridge Dr\", \"pcpnpi\": 1306885207, \"pcpzip\": \"04330\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Augusta\", \"pcpname\": \"KENNEBEC INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": 2076214370, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7QT7ER3NK51\", \"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-24-2026\", \"time\": \"12:04:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 09:22:38\"}', NULL, NULL, '{\"memberId\": \"10000058206\", \"clinician\": \"Kathryn Baxter\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 26 Feb 2026 19:15:50 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Kathryn\\n1.  AOD Cardiovascular med list reports ASHD please add.\\n2.  AOD Neuropsych med list reports migraines please add.\\n3.  AOD Genitourinary med list reports BPH please add.\\n4.  AOD Musculoskeletal med list reports gout please add.\\nThanks\\nJudi\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 21:14:53 GMT\", \"name\": \"Kathryn \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Thank you Judy.  Long day yesterday. \"}, \"mailId\": \"\"}], \"memberName\": \"Hamlyn Robbins\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/25/2026 09:00 AM\", \"clinicianMailId\": \"k.baxter@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000058206, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"12383693\", \"memberId\": 10000058206}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"12383693\", \"memberId\": 10000058206, \"scheduleDate\": \"2026-02-25T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:18:39\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"2bcd7256-0a09-4578-a3b9-64c770349371\\\",\\\"destination_fax_number\\\":\\\"12076214370\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"2bcd7256-0a09-4578-a3b9-64c770349371\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12076214370\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:35:39.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":4,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":330,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:01.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:19:26.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:21:46.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:22:12.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:24:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:53.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:27:07.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:35.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":330,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:35:39.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-25T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:43', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000058206\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Robbins_10000058206_02252026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:18:38\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000058206.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Robbins_10000058206_02252026.pdf', NULL, 'Summary_10000058206.pdf', NULL, '[{\"date\": \"2026-02-25T20:26:46.105Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-26T21:14:53.599Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-25T10:00', 'Member_Summary_10000058206.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000058206\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000058206.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:40\"}', 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
(269, 57818338, 44829497, '17537038', '10000059631', '', '', '14133640', 'Robert', 'Nichols', 'English', '', '{\"DOB\": 19391, \"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\": \"1346225711\", \"Pcp_Zip\": \"04901\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Waterville\", \"Pcp_Name\": \"ROSALIND WALDRON\", \"Rank_All\": 1, \"PCP_Phone\": \"2078725139\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4D50AP2ND26\", \"Member_City\": \"Winslow\", \"Office_Name\": \"ROSALIND WALDRON MD\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winslow\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-02-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"32 College Ave Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2078725148\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"7 LEE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7 LEE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Nichols\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"N\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"r.nichols2010@hotmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2073143848\", \"Member_Identification_Number\": \"10000059631\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:18:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:18:47\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-23T22:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-24T01:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 7, \"hraStatus_date\": \"2026-02-23T22:21\", \"reportStatus_date\": \"2026-02-23T22:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-24T01:17\", \"reportStatus_date\": \"2026-02-24T01:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:18\", \"reportStatus_date\": \"2026-03-03T17:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:18\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-02-22T13:31\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-23T15:14\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-24T01:17\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-23T22:21\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-24T01:17\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-22T13:33\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-23T14:15\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-23T14:18\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-23T14:21\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-23T14:24\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-23T14:27\", \"username\": \"AMilliken\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"09:25:27\", \"value\": [{\"add\": \"7 LEE ST\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-02-01\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2073143848\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Winslow\", \"gend\": 0, \"insh\": \"10000059631\", \"mzip\": \"04901\", \"name\": \"Robert N Nichols\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ROSALIND WALDRON\", \"ppno\": \"2078725139\", \"cliId\": \"\", \"email\": \"r.nichols2010@hotmail.com\", \"ename\": \"\", \"madd1\": \"7 LEE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winslow\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"32 College Ave Ste 203\", \"pcpnpi\": \"1346225711\", \"pcpzip\": \"04901\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Waterville\", \"pcpname\": \"ROSALIND WALDRON MD\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078725148\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4D50AP2ND26\", \"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\": \"11:26:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 09:25:27\"}', NULL, NULL, '{\"memberId\": \"10000059631\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Sun, 22 Feb 2026 18:33:19 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Demographics gender and marital status need answers.\\n2.  ADL please choose 1 for independent .\\n3.  medication list please remove medications not taking.\\n4.  AOD Eye why does he get retina scan every 3 months?\\n5.  AOD Endocrine please add DM as per medication list reports.\\n6.  Home Safety what is something you can work on to improve your life question needs answer.\\n7 assessors comments needs info reported.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 19:27:33 GMT\", \"name\": \"AMilliken\", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1.  Demographics gender and marital status need answers - complete \\n2.  ADL please choose 1 for independent - completed\\n3.  medication list please remove medications not taking. - completed\\n4.  AOD Eye why does he get retina scan every 3 months? - addressed \\n5.  AOD Endocrine please add DM as per medication list reports.\\n6.  Home Safety what is something you can work on to improve your life question needs answer.\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 20:14:00 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\nAll set. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Robert Nichols\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/02/2026 01:30 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"2/3/2026 @ 02:32 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000059631, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"\", \"memberId\": 10000059631}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"\", \"memberId\": 10000059631, \"scheduleDate\": \"2026-02-02T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235019}', 0, NULL, '[{\"date\": \"2026-03-03 17:18:45\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"7506f8c9-fe7b-4f76-bbfe-dd37af232d18\\\",\\\"destination_fax_number\\\":\\\"12078725148\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"7506f8c9-fe7b-4f76-bbfe-dd37af232d18\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12078725148\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:36.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\\\":251,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":251,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:23:36.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-02T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:43', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059631\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Nichols_10000059631_02022026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:18:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059631.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Nichols_10000059631_02022026.pdf', NULL, 'Summary_10000059631.pdf', NULL, '[{\"date\": \"2026-02-03T01:59:26.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T20:14:00.567Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-02T14:29', 'Member_Summary_10000059631.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059631\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059631.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:46\"}', 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
(270, 55499828, 44829497, '17537038', '10000073563', '', '', '14133640', 'Robert', 'Gould Sr', 'English', '', '{\"DOB\": 19168, \"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\": \"1245585108\", \"Pcp_Zip\": \"04364\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Winthrop\", \"Pcp_Name\": \"ROCHELLE MURPHY\", \"Rank_All\": 1, \"PCP_Phone\": \"2076243800\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1N90K93EP00\", \"Member_City\": \"GREENE\", \"Office_Name\": \"WINTHROP FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GREENE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-06-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"149 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2076243845\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"964 RTE 202\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04236\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"964 RTE 202\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04236\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gould Sr\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"FIREFIGHTER16108@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\": \"Yes\", \"Member_Primary_Phone_Number\": \"2073997879\", \"Member_Identification_Number\": \"10000073563\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:18:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:18:51\", \"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-14T13:11\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T19:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T21:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-14T12:25\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-14T13:11\", \"reportStatus_date\": \"2026-02-14T13:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T21:17\", \"reportStatus_date\": \"2026-02-19T21:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:18\", \"reportStatus_date\": \"2026-03-03T17:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:18\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-14T12:25\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T15:25\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-14T13:11\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-14T13:11\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-19T11:43\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T21:17\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T19:10\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T21:17\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T08:08\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"09:30:44\", \"value\": [{\"add\": \"964 RTE 202\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-06-23\", \"eno\": \"2073996677\", \"lob\": \"GA - 2026\", \"pno\": \"2073997879\", \"zip\": \"04236\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GREENE\", \"gend\": 0, \"insh\": \"10000073563\", \"mzip\": \"04236\", \"name\": \"Robert L Gould Sr\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ROCHELLE MURPHY\", \"ppno\": \"2076243800\", \"cliId\": \"\", \"email\": \"FIREFIGHTER16108@YAHOO.com\", \"ename\": \"Karyn Sutton Gould\", \"madd1\": \"964 RTE 202\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GREENE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"149 Main St\", \"pcpnpi\": \"1245585108\", \"pcpzip\": \"04364\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Winthrop\", \"pcpname\": \"WINTHROP FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076243845\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1N90K93EP00\", \"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-19-2026\", \"time\": \"11:39:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-23-2026 17:05:06\"}', NULL, NULL, '{\"memberId\": \"10000073563\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 13:08:11 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda,\\n1) CAD listed on the med list, can you add to the cardiac section \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Feb 2026 16:43:01 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"ASA is preventative  - updated. \\nCAD - called and verified member  has a valve that is being monitored and left ventricle hypertrophy. he has never had PCA/CABG\\nmember reported cluadication. referral updated\"}, \"mailId\": \"\"}], \"memberName\": \"Robert Gould Sr\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/14/2026 12:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000073563, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"\", \"memberId\": 10000073563}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"\", \"memberId\": 10000073563, \"scheduleDate\": \"2026-02-14T12:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:18:50\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"7788b9b0-0119-445c-b9df-c223c1886b30\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"7788b9b0-0119-445c-b9df-c223c1886b30\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"207 624 3845\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:31.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\\\":362,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":362,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:09.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:31.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-14T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:44', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000073563\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Gould Sr_10000073563_02142026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:18:50\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000073563.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Gould Sr_10000073563_02142026.pdf', NULL, 'Summary_10000073563.pdf', NULL, '[{\"date\": \"2026-02-14T18:11:05.950Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-19T16:43:00.887Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-14T13:08', 'Member_Summary_10000073563.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000073563\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000073563.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:51\"}', 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
(271, 62035418, 44829497, '8715496', '10000080554', '', '', '14133640', 'Bruce', 'Lowell', 'English', '', '{\"DOB\": 20081, \"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\": \"1447328125\", \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"SEAN CAREY\", \"Rank_All\": 1, \"PCP_Phone\": \"2078392559\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8KP3EC4VQ11\", \"Member_City\": \"WESTBROOK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WESTBROOK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-12-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"575 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075231135\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"52 ANDERSON AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04092\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"52 ANDERSON AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04092\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Lowell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Bruce\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"blowell1423@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2077497599\", \"Member_Identification_Number\": \"10000080554\", \"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:19:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:19:01\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-11T14:38\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-15T20:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-16T12:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-11T11:08\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-16T12:56\", \"reportStatus_date\": \"2026-02-16T12:56\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:19\", \"reportStatus_date\": \"2026-03-03T17:19\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:19\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-11T11:08\", \"username\": \"chembrick\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:24\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-11T14:38\", \"username\": \"chembrick\"}, {\"date\": \"2026-02-11T14:38\", \"username\": \"chembrick\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-16T12:56\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-15T20:22\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-16T12:56\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"09:33:42\", \"value\": [{\"add\": \"52 ANDERSON AVE\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-12-23\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2077497599\", \"zip\": \"04092\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WESTBROOK\", \"gend\": 0, \"insh\": \"10000080554\", \"mzip\": \"04092\", \"name\": \"Bruce A Lowell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SEAN CAREY\", \"ppno\": \"2078392559\", \"cliId\": \"\", \"email\": \"blowell1423@icloud.com\", \"ename\": \"Kristean Jacobs (daughter)\", \"madd1\": \"52 ANDERSON AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WESTBROOK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"575 Main St\", \"pcpnpi\": \"1447328125\", \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075231135\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8KP3EC4VQ11\", \"currentgend\": \"Male\", \"pphycomment\": \"verified with member\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"virtual visit. \"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-11-2026\", \"time\": \"09:31:52\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 09:33:42\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000080554, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"8715496\", \"memberId\": 10000080554}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"8715496\", \"memberId\": 10000080554, \"scheduleDate\": \"2026-02-11T11:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:18:58\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"945531b7-0b70-4a96-a24c-0215fb5cc150\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"945531b7-0b70-4a96-a24c-0215fb5cc150\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552631139 28      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:06.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\\\":262,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":262,\\\"start_timestamp\\\":\\\"2026-03-03T22:19:32.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:06.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-11T11:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:44', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000080554\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Lowell_10000080554_02112026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:18:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000080554.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Lowell_10000080554_02112026.pdf', NULL, 'Summary_10000080554.pdf', NULL, '[{\"date\": \"2026-02-11T19:38:33.716Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-11T12:10', 'Member_Summary_10000080554.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000080554\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000080554.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:18:59\"}', 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
(272, NULL, NULL, '17537038', '10000080806', '', '', '14133640', 'Wendy', 'Calvo', '', '', '{\"DOB\": 19094, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1548647225\", \"Pcp_Zip\": \"40112765\", \"Program\": \"Medicare\", \"Pcp_City\": \"BRUNSWICK\", \"Pcp_Name\": \"BOLDUC, KATELYN\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5NP3DK4PM09\", \"Member_City\": \"Winslow\", \"Office_Name\": \"OAKLAND FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winslow\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-04-10\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"81 MEDICAL CENTER DR STE 2200,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2076185670\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"2 MARIE ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2 MARIE ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Calvo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Wendy\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@112423.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078720853\", \"Member_Identification_Number\": \"10000080806\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Member cancelled when provider called to confirm appointment\"}', 1, b'0', b'0', '{\"date\": \"02-26-2026 15:05:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-02-26 15:05:04\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T12:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T13:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-09T11:54\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-09T11:54\", \"reportStatus_date\": \"2026-02-09T11:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T12:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T15:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-09T11:54\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:24:01\", \"value\": [{\"add\": \"2 MARIE ST\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-04-10\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078720853\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Winslow\", \"gend\": 1, \"insh\": \"10000080806\", \"mzip\": \"04901\", \"name\": \"Wendy S Calvo\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BOLDUC, KATELYN\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@112423.com\", \"ename\": \"\", \"madd1\": \"2 MARIE ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winslow\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"81 MEDICAL CENTER DR STE 2200,\", \"pcpnpi\": \"1548647225\", \"pcpzip\": \"40112765\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BRUNSWICK\", \"pcpname\": \"OAKLAND FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076185670\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5NP3DK4PM09\", \"currentgend\": \"\", \"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\": \"02-14-2026\", \"time\": \"05:26:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:24:01\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-09T11:54\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"Member cancelled when provider called to confirm appointment\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/26/2026 @ 03:05 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Kathryn no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 03:04 PM\"}, {\"date\": \"2/25/2026 @ 01:22 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point nurse Kathryn B- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/27/2026 @ 01:22 PM\"}, {\"date\": \"2/20/2026 @ 12:58 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 12:58 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000080806, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"\", \"memberId\": 10000080806}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"\", \"memberId\": 10000080806, \"scheduleDate\": \"2026-02-12T12:00:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 12:58:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-09-2026 11:54:13\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', '{\"orderType\": 0, \"sortOrder\": 1772529884}', 1, NULL, NULL, 'Virtual', '2026-02-12T12:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(273, 57818338, 44829497, '22140773', '10000083869', '', '', '14133640', 'Susan', 'Wilber', 'English', '', '{\"DOB\": 19962, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": \"1538794680\", \"Pcp_Zip\": \"04953\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"NEWPORT\", \"Pcp_Name\": \"DOROTHY OKEEFE\", \"Rank_All\": 1, \"PCP_Phone\": \"2079245200\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4R96QV6AG63\", \"Member_City\": \"CORINNA\", \"Office_Name\": \"SEBASTICOOK FAMILY DOCTORS\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CORINNA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-08-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"118 MOOSEHEAD TRL STE 5\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"16 SUNSHINE VILLAGE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04928\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"16 SUNSHINE VILLAGE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04928\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Wilber\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Susan\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"swilber881@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\": \"2076726181\", \"Member_Identification_Number\": \"10000083869\", \"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:19:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:19:10\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-14T14:40\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-20T14:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-20T16:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-12T06:21\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:16\", \"reportStatus_date\": \"2026-01-31T10:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-14T14:40\", \"reportStatus_date\": \"2026-02-14T14:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-20T16:25\", \"reportStatus_date\": \"2026-02-20T16:25\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:19\", \"reportStatus_date\": \"2026-03-03T17:19\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:19\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:16\", \"username\": null}, {\"date\": \"2026-01-31T10:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-12T06:21\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T15:26\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-14T14:40\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-14T14:40\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-20T16:25\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-20T14:30\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-20T16:25\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-17-2026\", \"time\": \"09:36:10\", \"value\": [{\"add\": \"16 SUNSHINE VILLAGE DR\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-08-26\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2076726181\", \"zip\": \"04928\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CORINNA\", \"gend\": 1, \"insh\": \"10000083869\", \"mzip\": \"04928\", \"name\": \"Susan E Wilber\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DOROTHY OKEEFE\", \"ppno\": \"2079245200\", \"cliId\": \"\", \"email\": \"swilber881@gmail.com\", \"ename\": \"\", \"madd1\": \"16 SUNSHINE VILLAGE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CORINNA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"118 MOOSEHEAD TRL STE 5\", \"pcpnpi\": \"1538794680\", \"pcpzip\": \"04953\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"NEWPORT\", \"pcpname\": \"SEBASTICOOK FAMILY DOCTORS\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"4R96QV6AG63\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Christian\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-12-2026\", \"time\": \"06:21:41\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-17-2026 09:36:10\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000083869, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000083869}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000083869, \"scheduleDate\": \"2026-02-12T10:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:16:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:19:09\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ff62aa6d-174e-11f1-8e2f-81703cf6563f\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-02-12T10:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:44', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000083869\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Wilber_10000083869_02122026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:19:07\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000083869.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Wilber_10000083869_02122026.pdf', NULL, 'Summary_10000083869.pdf', NULL, '[{\"date\": \"2026-02-14T19:40:00.634Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-12T12:17', 'Member_Summary_10000083869.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000083869\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000083869.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:19:09\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
