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
(140, 55499828, 44829497, '17537038', '10000079726', '', '', '14133640', 'Arthur', 'Magnuson', 'English', '', '{\"DOB\": 20418, \"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\": \"1659876571\", \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"SCOTT CATHCART\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7DQ2MY2JQ13\", \"Member_City\": \"SCARBOROUGH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SCARBOROUGH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-11-25\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"84 Marginal Way Ste 700\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"35 DRESSER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04074\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"35 DRESSER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04074\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Magnuson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Arthur\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"artmagnuson@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2073034864\", \"Member_Identification_Number\": \"10000079726\", \"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:09:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:09:44\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-12T16:17\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-20T08:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-20T14:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-12T14:58\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-12T16:17\", \"reportStatus_date\": \"2026-02-12T16:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-20T14:06\", \"reportStatus_date\": \"2026-02-20T14:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:09\", \"reportStatus_date\": \"2026-03-03T17:09\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:09\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-12T14:58\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-13T13:47\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-18T16:01\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-12T16:17\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-12T16:17\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-20T14:06\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-20T08:37\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-20T14:06\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"12:46:31\", \"value\": [{\"add\": \"35 DRESSER RD\", \"age\": 70, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-11-25\", \"eno\": \"3154495052\", \"lob\": \"GA - 2026\", \"pno\": \"2073034864\", \"zip\": \"04074\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SCARBOROUGH\", \"gend\": 0, \"insh\": \"10000079726\", \"mzip\": \"04074\", \"name\": \"Arthur C Magnuson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"SCOTT CATHCART\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"artmagnuson@yahoo.com\", \"ename\": \"Gen Magnuson \", \"madd1\": \"35 DRESSER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SCARBOROUGH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"84 Marginal Way Ste 700\", \"pcpnpi\": \"1659876571\", \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7DQ2MY2JQ13\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-10-2026\", \"time\": \"15:22:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 12:46:31\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000079726, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000079726}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000079726, \"scheduleDate\": \"2026-02-12T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:04\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:09:44\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"af0c1024-174d-11f1-bfb3-75f8d418c32c\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2026-02-12T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:08', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079726\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Magnuson_10000079726_02122026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:09:43\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000079726.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Magnuson_10000079726_02122026.pdf', NULL, 'Summary_10000079726.pdf', NULL, '[{\"date\": \"2026-02-12T21:17:40.037Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-12T16:15', 'Member_Summary_10000079726.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079726\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000079726.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:09:44\"}', 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
(141, 57818338, 44829497, '17537038', '10000058683', '', '', '14133640', 'Darrell', 'Dallaire', 'English', '', '{\"DOB\": 23169, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Transmission error.\", \"Aligned\": \"\", \"PCP_NPI\": 1316906589, \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"DANIEL LOISELLE\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3GH1CC9GC06\", \"Member_City\": \"Biddeford\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Biddeford\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1963-06-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"100 FODEN ROAD WEST, SUITE 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"44 GUINEA RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"44 GUINEA RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dallaire\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Darrell\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"ddallaire@maine.rr.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2075908285, \"Member_Identification_Number\": \"10000058683\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:03:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:03:44\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-20T14:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-09T15:38\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-12T09:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-12T11:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T14:35\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-08T21:41\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-17T11:45\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-17T11:45\", \"reportStatus_date\": \"2026-02-20T14:05\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-24T14:35\", \"reportStatus_date\": \"2026-02-24T14:35\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-09T15:38\", \"reportStatus_date\": \"2026-03-09T15:38\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-12T11:45\", \"reportStatus_date\": \"2026-03-12T11:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:03\", \"reportStatus_date\": \"2026-03-17T16:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:03\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-24T14:35\", \"username\": null}, {\"date\": \"2026-02-24T14:35\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-03-08T21:41\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-09T16:28\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-09T15:38\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-09T15:38\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-11T10:51\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-11T10:54\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-11T10:57\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-11T16:55\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-12T11:45\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-12T09:47\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-12T11:45\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-11T10:59\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T11:45\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"09:43:17\", \"value\": [{\"add\": \"44 GUINEA RD\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-06-07\", \"eno\": \"2075905704\", \"lob\": \"GA - 2026\", \"pno\": 2075908285, \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Biddeford\", \"gend\": 0, \"insh\": \"10000058683\", \"mzip\": \"04005\", \"name\": \"Darrell R Dallaire\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DANIEL LOISELLE\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"ddallaire@maine.rr.com\", \"ename\": \"Laurie Dallaire \", \"madd1\": \"44 GUINEA RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Biddeford\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN ROAD WEST, SUITE 203\", \"pcpnpi\": 1316906589, \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3GH1CC9GC06\", \"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-13-2026\", \"time\": \"12:06:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 09:43:17\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-17T11:45\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"provider cancellation\", \"cancelStatus\": 1}]}', NULL, '{\"memberId\": \"10000058683\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 11 Mar 2026 14:59:30 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Medication list what is the diagnosis for bupropion?\\n2.  Vital Signs reports actual.  It is a virtual visit.  Please add comment or change status.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Mar 2026 20:55:16 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judith, \\n1. Anxiety\\n2. I have updated. \\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Darrell Dallaire\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/09/2026 12:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/24/2026 @ 02:35 PM\", \"result\": 0, \"comment\": \"Sched virtual 3/9 at 12 pm w/Amanda\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 02:05 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 02:05 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000058683\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000058683\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000058683\", \"scheduleDate\": \"2026-3-9T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-20-2026 14:05:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-24-2026 14:35:20\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:03:41\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"88fa8fd5-aaef-4271-ade8-753b90adfa1d\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"88fa8fd5-aaef-4271-ade8-753b90adfa1d\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:21:37.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:03:55.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:05:07.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:07:09.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:08:26.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:10:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:11:48.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:13:52.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:14:58.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:17:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:18:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-17T20:20:29.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-17T20:21:37.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-9T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:09', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000058683\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Dallaire_10000058683_03092026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:03:40\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000058683.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Dallaire_10000058683_03092026.pdf', NULL, 'Summary_10000058683.pdf', NULL, '[{\"date\": \"2026-03-09T19:38:52.357Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-11T20:55:15.880Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-09T13:11', 'Member_Summary_10000058683.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000058683\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000058683.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:03:42\"}', 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
(142, 62035418, 44829497, '39698290', '10000059076', '', '', '1019044', 'Elizabeth', 'Michaud', 'English', '', '{\"DOB\": 21189, \"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\": 1659908101, \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"JENNIFER SCONTRAS\", \"Rank_All\": 1, \"PCP_Phone\": \"2078392559\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8KQ6MN1CH67\", \"Member_City\": \"CASCO\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CASCO\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1958-01-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"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\": \"50 GALASSETTI DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04015\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"50 GALASSETTI DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04015\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Michaud\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Elizabeth\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Lizm_6@hotmail.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\": \"2076932911\", \"Member_Identification_Number\": \"10000059076\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2076932911}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:27:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:27:55\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T16:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-28T18:40\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-04T20:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-04T21:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-09T11:30\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T08:45\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-09T11:30\", \"reportStatus_date\": \"2026-02-09T11:30\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-28T18:40\", \"reportStatus_date\": \"2026-02-28T18:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-04T21:30\", \"reportStatus_date\": \"2026-03-04T21:30\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:27\", \"reportStatus_date\": \"2026-03-10T14:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:27\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-09T11:30\", \"username\": null}, {\"date\": \"2026-02-09T11:30\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-02-24T08:45\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-03T13:23\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-28T18:40\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-28T18:40\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-04T21:30\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-04T20:39\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-04T21:30\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"14:12:44\", \"value\": [{\"add\": \"50 GALASSETTI DR\", \"age\": 68, \"ano\": \"\", \"cno\": 2076932911, \"dob\": \"1958-01-04\", \"eno\": \"2076935095\", \"lob\": \"GA - 2026\", \"pno\": \"2076932911\", \"zip\": \"04015\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CASCO\", \"gend\": 1, \"insh\": \"10000059076\", \"mzip\": \"04015\", \"name\": \"Elizabeth A Michaud\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JENNIFER SCONTRAS\", \"ppno\": \"2078392559\", \"cliId\": \"\", \"email\": \"Lizm_6@hotmail.com\", \"ename\": \"Dennis\", \"madd1\": \"50 GALASSETTI DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CASCO\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"575 Main St \", \"pcpnpi\": 1659908101, \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2075231135, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8KQ6MN1CH67\", \"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-23-2026\", \"time\": \"11:36:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 14:12:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/9/2026 @ 11:30 AM\", \"result\": 0, \"comment\": \"Sched w/Sandra 2/24 at 9\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 04:12 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Erin no answer No VM Setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/10/2026 @ 04:12 PM\"}, {\"date\": \"2/3/2026 @ 11:55 AM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000059076, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000059076}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000059076, \"scheduleDate\": \"2026-02-24T09:00:00.000\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 16:12:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"02-09-2026 11:30:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:27:54\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"d2506f7e-e3cc-42ae-a966-2481209a32d6\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"d2506f7e-e3cc-42ae-a966-2481209a32d6\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552631139 49      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:33:36.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":7,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":298,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":298,\\\"start_timestamp\\\":\\\"2026-03-10T18:28:28.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:33:36.005+0000\\\",\\\"pages_sent\\\":7,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-2-24T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:09', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059076\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Michaud_10000059076_02242026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:27:52\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059076.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Michaud_10000059076_02242026.pdf', NULL, 'Summary_10000059076.pdf', NULL, '[{\"date\": \"2026-02-28T23:40:25.045Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-24T12:46', 'Member_Summary_10000059076.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059076\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059076.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:27:54\"}', 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
(143, NULL, NULL, '17537038', '10000060453', '', '', '14133640', 'Bernard', 'Ridley', '', '', '{\"DOB\": 21625, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1952334864\", \"Pcp_Zip\": \"04938\", \"Program\": \"Medicare\", \"Pcp_City\": \"Farmington\", \"Pcp_Name\": \"HAMILTON, DEBORAH J\", \"Rank_All\": 1, \"PCP_Phone\": \"2078604090\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4KW5WF1YK54\", \"Member_City\": \"LIVERMORE\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LIVERMORE\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1959-03-16\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Franklin Health Primary Care,131 Franklin Health Commons\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2078604098\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"917 RIVER RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04253\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"917 RIVER RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04253\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Ridley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Bernard\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"judyridley@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2079317181\", \"Member_Identification_Number\": \"10000060453\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":3,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"Member changed his mind, would like to reschedule later in the year \"}', 1, b'0', b'0', '{\"date\": \"03-02-2026 15:58:59\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}', '{\"date\": \"2026-03-02 15:58:59\", \"hrastatus\": \"\", \"reportstatus\": \"Call Back\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T09:12\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}, {\"date\": \"2026-02-05T10:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-19T10:42\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-20T14:55\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-03-02T15:58\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-05T10:31\", \"reportStatus_date\": \"2026-02-05T10:31\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-19T10:42\", \"reportStatus_date\": \"2026-02-20T14:55\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T15:58\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-05T10:31\", \"username\": null}, {\"date\": \"2026-02-05T10:31\", \"username\": \"KCoash\"}], \"inProgress\": [{\"date\": \"2026-02-05T09:12\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-19T10:42\", \"username\": \"GMedranoAdmin\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:23\", \"value\": [{\"add\": \"917 RIVER RD\", \"age\": 66, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-03-16\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2079317181\", \"zip\": \"04253\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LIVERMORE\", \"gend\": 0, \"insh\": \"10000060453\", \"mzip\": \"04253\", \"name\": \"Bernard J Ridley\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HAMILTON, DEBORAH J\", \"ppno\": \"2078604090\", \"cliId\": \"\", \"email\": \"judyridley@icloud.com\", \"ename\": \"\", \"madd1\": \"917 RIVER RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LIVERMORE\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Franklin Health Primary Care,131 Franklin Health Commons\", \"pcpnpi\": \"1952334864\", \"pcpzip\": \"04938\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Farmington\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078604098\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4KW5WF1YK54\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-05-2026\", \"time\": \"09:12:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:23\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-19T10:42\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"GMedranoAdmin\", \"hraStatus\": 3, \"cancelText\": \"Member changed his mind, would like to reschedule later in the year \", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"3/2/2026 @ 03:58 PM\", \"result\": 6, \"comment\": \"Member requested a call back at a later time. They stated they are dealing with medical issues and do not wish to reschedule right now. They will call back when ready.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"5/20/2026 @ 03:58 PM\"}, {\"date\": \"2/20/2026 @ 02:55 PM\", \"result\": 6, \"comment\": \"Called to get member rescheduled with mphp nurses -call back member not home \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/23/2026 @ 02:55 PM\"}, {\"date\": \"2/5/2026 @ 10:31 AM\", \"result\": 12, \"comment\": \"rescheduled from 2/5 at 12 to 2/19 at 3 w/Amanda M\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000060453\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000060453\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000060453\", \"scheduleDate\": \"2026-2-19T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 10:31:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-19-2026 10:42:41\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, 'Virtual', '2026-2-19T15:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(144, NULL, NULL, '17537038', '10000061045', '', '', '14133640', 'Harold', 'Bridgham', 'English', '', '{\"DOB\": 19528, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1063049377\", \"Pcp_Zip\": \"40748897\", \"Program\": \"Medicare\", \"Pcp_City\": \"Scarborough\", \"Pcp_Name\": \"HEPPE, ANDREW\", \"Rank_All\": 1, \"PCP_Phone\": \"2078833491\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7Q04C12UX77\", \"Member_City\": \"MINOT\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"MINOT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-06-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"MMP Scarborough Internal Medicine,300 Professional Dr Ste 2B\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2078855587\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"307 CENTER MINOT HILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04258\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"307 CENTER MINOT HILL ROAD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04258\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Bridgham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Harold\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kbtreeservicesME@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075768028\", \"Member_Identification_Number\": \"10000061045\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077130800\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-16-2026 13:44:40\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-16 13:44:40\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-26T12:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T15:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-16T13:44\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T22:22\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-02-06T16:44\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-02-23T15:44\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}, {\"date\": \"2026-02-25T15:09\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-03T16:42\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-02-25T15:52\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-06T16:44\", \"reportStatus_date\": \"2026-02-06T16:44\"}, {\"text\": \"Rescheduled\", \"type\": \"ReportStatus\", \"status\": 16, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-23T15:44\", \"reportStatus_date\": \"2026-02-23T15:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-25T15:52\", \"reportStatus_date\": \"2026-02-26T12:26\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-16T13:44\", \"reportStatus_date\": \"2026-03-16T13:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-02-06T16:44\", \"username\": null}, {\"date\": \"2026-02-06T16:44\", \"username\": \"KCoash\"}, {\"date\": \"2026-02-24T22:22\", \"username\": \"AWalsh\"}], \"inProgress\": [{\"date\": \"2026-02-23T15:44\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-25T15:09\", \"username\": \"AMilliken\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-16T13:44\", \"username\": \"AChevalier\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:42\", \"username\": \"AWalsh\"}, {\"date\": \"2026-02-25T15:52\", \"username\": \"AMilliken\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:12:50\", \"value\": [{\"add\": \"307 CENTER MINOT HILL RD\", \"age\": 72, \"ano\": \"\", \"cno\": \"2077130800\", \"dob\": \"1953-06-18\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075768028\", \"zip\": \"04258\", \"add2\": \"\", \"add3\": \"\", \"city\": \"MINOT\", \"gend\": 0, \"insh\": \"10000061045\", \"mzip\": \"04258\", \"name\": \"Harold W Bridgham\", \"plan\": \"Martin\'s Point\", \"pphy\": \"HEPPE, ANDREW\", \"ppno\": \"2078833491\", \"cliId\": \"\", \"email\": \"kbtreeservicesME@gmail.com\", \"ename\": \"\", \"madd1\": \"307 CENTER MINOT HILL ROAD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"MINOT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"MMP Scarborough Internal Medicine,300 Professional Dr Ste 2B\", \"pcpnpi\": \"1063049377\", \"pcpzip\": \"40748897\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Scarborough\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078855587\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7Q04C12UX77\", \"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-23-2026\", \"time\": \"15:44:12\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:12:50\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-16T13:44\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AChevalier\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:42\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"reschedule\", \"cancelStatus\": 0}, {\"date\": \"2026-02-25T15:52\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AMilliken\", \"hraStatus\": 3, \"cancelText\": \"member did not present on doxy. I called both phone numbers and left a voicemail. I sent a link with my phone number to members cell phone and email. member did not respond. please try and reschedule. thank you. \", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/16/2026 @ 01:44 PM\", \"result\": 9, \"comment\": \"does not want to participate if it not mandatory\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 03:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/14/2026 @ 03:59 PM\"}, {\"date\": \"2/26/2026 @ 12:26 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"3/3/2026 @ 12:26 PM\"}, {\"date\": \"2/6/2026 @ 04:44 PM\", \"result\": 12, \"comment\": \"resched w/Amanda 2/25/26 at 3 pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 01:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000061045\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000061045\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000061045\", \"scheduleDate\": \"2026-2-25T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 16:44:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-25-2026 15:52:44\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, 'Virtual', '2026-2-25T15:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:09', 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
(145, 55499828, 44829497, '45509507', '10000061433', '', '', '14133640', 'John', 'Michael', 'English', '', '{\"DOB\": 18473, \"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\": \"1679884522\", \"Pcp_Zip\": \"04210\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"AUBURN\", \"Pcp_Name\": \"ADAM DUQUETTE\", \"Rank_All\": 1, \"PCP_Phone\": \"2077847388\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2J44QE2WM01\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"FAMILY HEALTH CARE ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1950-07-29\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"190 STETSON RD\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077952043\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"163 SUMMER ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 233\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04212\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Michael\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"F\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2075188060\", \"Member_Identification_Number\": \"10000061433\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073335106\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:09:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:09:48\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-08T16:55\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-11T07:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-11T13:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-08T11: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:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-09T11:43\", \"reportStatus_date\": \"2026-02-08T16:55\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-11T13:48\", \"reportStatus_date\": \"2026-02-11T13:48\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:09\", \"reportStatus_date\": \"2026-03-03T17:09\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:09\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-08T11:25\", \"username\": \"JWinslow\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T10:26\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-08T16:55\", \"username\": \"JWinslow\"}, {\"date\": \"2026-02-08T16:55\", \"username\": \"JWinslow\"}, {\"date\": \"2026-02-09T11:41\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-10T19:20\", \"username\": \"JWinslow\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-11T13:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-11T07:42\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-11T13:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-09T11:43\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"14:21:08\", \"value\": [{\"add\": \"163 SUMMER ST\", \"age\": 75, \"ano\": \"\", \"cno\": \"2073335106\", \"dob\": \"1950-07-29\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2075188060\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 0, \"insh\": \"10000061433\", \"mzip\": \"04212\", \"name\": \"John M Michael\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ADAM DUQUETTE\", \"ppno\": \"2077847388\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 233\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"190 STETSON RD\", \"pcpnpi\": \"1679884522\", \"pcpzip\": \"04210\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"AUBURN\", \"pcpname\": \"FAMILY HEALTH CARE ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077952043\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2J44QE2WM01\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"12:34:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 14:21:08\"}', NULL, NULL, '{\"memberId\": \"10000061433\", \"clinician\": \"Jennifer Winslow\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Mon, 09 Feb 2026 16:43:20 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Jennifer,\\n1) can you add marital status and emergency contact\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 00:20:34 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I missed that during the appt and unable to add it at this time. \"}, \"mailId\": \"\"}], \"memberName\": \"John Michael\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/08/2026 11:30 AM\", \"clinicianMailId\": \"jennifer.winslow@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000061433, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"45509507\", \"memberId\": 10000061433}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"45509507\", \"memberId\": 10000061433, \"scheduleDate\": \"2026-02-08T11:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:05\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:09:47\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"33f13f77-f75a-4e43-aef3-bb0c15d072df\\\",\\\"destination_fax_number\\\":\\\"12077952043\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"33f13f77-f75a-4e43-aef3-bb0c15d072df\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12077952043\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:38.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":264,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":264,\\\"start_timestamp\\\":\\\"2026-03-03T22:10:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:14:38.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-08T11:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:10', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061433\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Michael_10000061433_02082026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:09:47\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000061433.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Michael_10000061433_02082026.pdf', NULL, 'Summary_10000061433.pdf', NULL, '[{\"date\": \"2026-02-08T21:55:35.986Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-11T00:20:34.226Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-08T12:07', 'Member_Summary_10000061433.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000061433\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000061433.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:09:48\"}', 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
(146, 71932120, 44829497, '27743162', '10000062779', '', '', '14133640', 'Doris', 'Principe', 'English', '', '{\"DOB\": 19637, \"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\": 1629431622, \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"LETELLIER, TERESA\", \"Rank_All\": 1, \"PCP_Phone\": 2072831441, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3JW3J15KW92\", \"Member_City\": \"Biddeford\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Biddeford\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-10-05\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": 2075231136, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"41 CUTTS ST APT 2\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"41 CUTTS ST APT 2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Principe\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Doris\", \"Member_Middle_name\": \"N\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": 2072052495, \"Member_Identification_Number\": \"10000062779\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:50:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:50:53\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-27T14:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-06T11:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T13:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T14:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-23T15:37\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-25T13:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-25T14:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-03T16:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-23T11:39\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-04T13:49\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-03T16:42\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-09T18:24\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-24T14:42\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-03T16:42\", \"reportStatus_date\": \"2026-02-09T18:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T14:52\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-03-03T16:45\", \"reportStatus_date\": \"2026-03-03T16:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-23T15:37\", \"reportStatus_date\": \"2026-03-23T15:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-25T14:14\", \"reportStatus_date\": \"2026-03-25T14:14\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:50\", \"reportStatus_date\": \"2026-03-31T13:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:50\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-03-03T16:45\", \"username\": null}, {\"date\": \"2026-03-03T16:45\", \"username\": \"JCopeland\"}], \"inProgress\": [{\"date\": \"2026-03-23T11:39\", \"username\": \"SHafer\"}], \"qaAssigned\": [{\"date\": \"2026-03-23T18:19\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-03-23T15:37\", \"username\": \"SHafer\"}, {\"date\": \"2026-03-23T15:37\", \"username\": \"SHafer\"}, {\"date\": \"2026-03-24T15:35\", \"username\": \"SHafer\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-25T14:14\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-25T13:14\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-25T14:14\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-24T10:48\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:42\", \"username\": \"AWalsh\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-23-2026\", \"time\": \"11:39:04\", \"value\": [{\"add\": \"41 CUTTS ST APT 2\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-10-05\", \"eno\": \"2072051927\", \"lob\": \"GA - 2026\", \"pno\": 2072052495, \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Biddeford\", \"gend\": 1, \"insh\": \"10000062779\", \"mzip\": \"04005\", \"name\": \"Doris N Principe\", \"plan\": \"Martin\'s Point\", \"pphy\": \"LETELLIER, TERESA\", \"ppno\": 2072831441, \"cliId\": \"\", \"email\": \"\", \"ename\": \"Michael Gagnon\", \"madd1\": \"41 CUTTS ST APT 2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Biddeford\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": 1629431622, \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2075231136, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3JW3J15KW92\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"Female \"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Catholic \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"03-20-2026\", \"time\": \"12:53:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-24-2026 15:35:17\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:42\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"reschedule\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"10000062779\", \"clinician\": \"Shellie Hafer\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Tue, 24 Mar 2026 14:48:08 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Shellie.\\n\\n1. In the assessment of diagnosis cardiovascular, CHF was supported by medication. However, there is no medication noted for CHF on the med list. HTN are noted on the med list, are these medications used or CHF as well? If so, please add CHF diagnosis to HTN medications on the med list.\\n2. In the assessment of diagnosis musculoskeletal section, the question \\\"Have you had an amputation?\\\" was left unanswered. Please update.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Mar 2026 19:35:17 GMT\", \"name\": \"Shellie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I have update the information \\nThank you\\nShellie \"}, \"mailId\": \"\"}], \"memberName\": \"Doris Principe\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/23/2026 12:00 PM\", \"clinicianMailId\": \"s.hafer@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/3/2026 @ 04:45 PM\", \"result\": 0, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer 3/23/2026 @ 12PM, MRB SAID TO PARK IN HER DRIVEWAY, TO CALL WHEN YOU ARRIVE SO SHE CAN TOSS THE KEYS DOWN OUT OF HER WINDOW SO YOU CAN GET UP \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 02:52 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 02:42 PM\", \"result\": 6, \"comment\": \"per notes in Five9 mbr asked for c/b in a week\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/3/2026 @ 02:42 PM\"}, {\"date\": \"2/9/2026 @ 06:24 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Leanna but member requested a call backu202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/11/2026 @ 06:24 PM\"}, {\"date\": \"2/9/2026 @ 01:52 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 @ 01:52 PM\"}, {\"date\": \"2/6/2026 @ 10:53 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual hra with MP nurse Nancy H; LVM. Member previously requested F2F call back - can be scheduled with Shellie H 3/9/26\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 10:52 AM\"}, {\"date\": \"2/4/2026 @ 01:49 PM\", \"result\": 14, \"comment\": \"calling to sched virtual IHA w/Amanda M - mbr in rehab currently - call back in a couple weeks\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/18/2026 @ 01:49 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000062779\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": \"10000062779\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": \"10000062779\", \"scheduleDate\": \"2026-3-23T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 13:49:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"03-03-2026 16:45:27\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:50:52\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"07ef635b-3c7c-40c9-8e32-65c3a0ec4d1c\\\",\\\"destination_fax_number\\\":\\\"12075231136\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"07ef635b-3c7c-40c9-8e32-65c3a0ec4d1c\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12075231136\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552241284 3       \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:55:34.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":252,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":252,\\\"start_timestamp\\\":\\\"2026-03-31T17:51:05.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-31T17:55:34.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-23T12:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:10', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000062779\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Principe_10000062779_03232026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:50:52\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000062779.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Principe_10000062779_03232026.pdf', NULL, 'Summary_10000062779.pdf', NULL, '[{\"date\": \"2026-03-23T19:37:23.296Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-24T19:35:16.746Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-23T12:45', 'Member_Summary_10000062779.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000062779\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000062779.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:50:53\"}', 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
(147, 71932120, 44829497, '48822527', '10000064019', '', '', '14133640', 'George', 'Small', 'English', '', '{\"DOB\": 16114, \"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\": \"1710066410\", \"Pcp_Zip\": \"04039\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"GRAY\", \"Pcp_Name\": \"MANJU HILARY\", \"Rank_All\": 1, \"PCP_Phone\": \"2076573308\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9M93RW1JH94\", \"Member_City\": \"GRAY\", \"Office_Name\": \"GRAY FAMILY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GRAY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1944-02-12\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"126 SHAKER RD\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076573309\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"6 LEDGEWOOD LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04039\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6 LEDGEWOOD LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04039\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Small\", \"Medication_Review\": \"N\", \"Member_first_name\": \"George\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined123025@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"4075519544\", \"Member_Identification_Number\": \"10000064019\", \"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:09:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:09:53\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-10T14:46\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-13T18:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-13T20:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-08T18:19\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:12\", \"reportStatus_date\": \"2026-01-31T10:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-08T18:19\", \"reportStatus_date\": \"2026-02-08T18:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-13T20:45\", \"reportStatus_date\": \"2026-02-13T20:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:09\", \"reportStatus_date\": \"2026-03-03T17:09\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:09\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:12\", \"username\": null}, {\"date\": \"2026-01-31T10:12\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-08T18:19\", \"username\": \"JLandry\"}], \"qaAssigned\": [{\"date\": \"2026-02-11T11:03\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-10T14:46\", \"username\": \"JLandry\"}, {\"date\": \"2026-02-10T14:46\", \"username\": \"JLandry\"}, {\"date\": \"2026-02-11T15:17\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-12T19:58\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-13T20:45\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-13T18:26\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-13T20:45\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-11T15:20\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-12-2026\", \"time\": \"14:24:52\", \"value\": [{\"add\": \"6 LEDGEWOOD LN\", \"age\": 82, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1944-02-12\", \"eno\": \"2078071407\", \"lob\": \"GA - 2026\", \"pno\": \"4075519544\", \"zip\": \"04039\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GRAY\", \"gend\": 0, \"insh\": \"10000064019\", \"mzip\": \"04039\", \"name\": \"George L Small\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MANJU HILARY\", \"ppno\": \"2076573308\", \"cliId\": \"\", \"email\": \"declined123025@gmail.com\", \"ename\": \"james small\", \"madd1\": \"6 LEDGEWOOD LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GRAY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"126 SHAKER RD\", \"pcpnpi\": \"1710066410\", \"pcpzip\": \"04039\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"GRAY\", \"pcpname\": \"GRAY FAMILY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076573309\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9M93RW1JH94\", \"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-08-2026\", \"time\": \"18:19:53\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-12-2026 14:24:52\"}', NULL, NULL, '{\"memberId\": \"10000064019\", \"clinician\": \"Jennifer Landry\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Wed, 11 Feb 2026 20:20:01 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Jennifer,\\n\\n1. Please highlight steroids in the long term use of the allergies/medication section.\\n2. Please add the diastolic reading of the blood pressure in the vital signs section.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 13 Feb 2026 00:58:07 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"George Small\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/10/2026 12:10 PM\", \"clinicianMailId\": \"j.landry@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000064019, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": 10000064019}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": 10000064019, \"scheduleDate\": \"2026-02-10T12:10:00\"}}', NULL, '{\"date\": \"01-31-2026 10:12:06\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:09:52\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"92e6cf67-ab7c-4626-8e86-e7db2bd56525\\\",\\\"destination_fax_number\\\":\\\"12076573309\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"92e6cf67-ab7c-4626-8e86-e7db2bd56525\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12076573309\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15: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\\\":293,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":293,\\\"start_timestamp\\\":\\\"2026-03-03T22:10:16.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:31.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-10T12:10:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:50:10', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000064019\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Small_10000064019_02102026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:09:51\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000064019.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Small_10000064019_02102026.pdf', NULL, 'Summary_10000064019.pdf', NULL, '[{\"date\": \"2026-02-10T19:45:59.733Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-13T00:58:07.308Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-10T12:50', 'Member_Summary_10000064019.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000064019\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000064019.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:09:53\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
