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
(58, 62035418, 44829497, '17537038', '10000030765', '', '', '14133640', 'Marnela', 'Haskell', 'English', '', '{\"DOB\": 18654, \"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\": \"1447571864\", \"Pcp_Zip\": \"04072\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Saco\", \"Pcp_Name\": \"CATHERINE CORNELIO\", \"Rank_All\": 1, \"PCP_Phone\": \"2072838800\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9CT0FH5DT27\", \"Member_City\": \"PALMYRA\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"PALMYRA\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-01-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"13 Industrial Park Rd Ste 2\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Somerset\", \"Member_Country\": \"Somerset\", \"PCP_Fax_Number\": \"2072943561\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"88 SMITH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04965\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"88 SMITH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04965\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Haskell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marnela\", \"Member_Middle_name\": \"I\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"marniehask@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2078371671\", \"Member_Identification_Number\": \"10000030765\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2078371605\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:06:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:24\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-10T06:25\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T16:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T17:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-09T15:15\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-09T15:15\", \"reportStatus_date\": \"2026-02-09T15:15\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T18:31\", \"reportStatus_date\": \"2026-02-10T06:25\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T17:56\", \"reportStatus_date\": \"2026-02-17T17:56\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-09T15:15\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-10T10:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-10T06:25\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-10T06:25\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-15T14:22\", \"username\": \"NSchaaf\"}, {\"date\": \"2026-02-16T18:31\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T17:56\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T16:44\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T17:56\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-15T14:25\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"13:52:33\", \"value\": [{\"add\": \"88 SMITH RD\", \"age\": 75, \"ano\": \"\", \"cno\": \"2078371605\", \"dob\": \"1951-01-26\", \"eno\": \"2078371605\", \"lob\": \"GA - 2026\", \"pno\": \"2078371671\", \"zip\": \"04965\", \"add2\": \"\", \"add3\": \"\", \"city\": \"PALMYRA\", \"gend\": 1, \"insh\": \"10000030765\", \"mzip\": \"04965\", \"name\": \"Marnela I Haskell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CATHERINE CORNELIO\", \"ppno\": \"2072838800\", \"cliId\": \"\", \"email\": \"marniehask@gmail.com\", \"ename\": \"Michael Haskell\", \"madd1\": \"88 SMITH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"PALMYRA\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"13 Industrial Park Rd Ste 2\", \"pcpnpi\": \"1447571864\", \"pcpzip\": \"04072\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Saco\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2072943561\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9CT0FH5DT27\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Jehovah’s Witnesses\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-06-2026\", \"time\": \"12:33:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 13:52:33\"}', NULL, NULL, '{\"memberId\": \"10000030765\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Sun, 15 Feb 2026 19:25:11 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1) Can you add emergency contact for client, if they did not provide one you can type NA etc\\n2) for the KATZ index score, score should not be \\\"0\\\", 1 is the lowest score\\n3) In the medication list, can you be sure each medication has route and frequency\\n4) Since patient is taking medications for neuropathy and Diabetes can you add to endocrine assessment of diagnosis and then be sure to select boxes\\nfor supported by \\n5) since patient has prn nitro for chest pain i would add to cardiac assessment of diagnosis and then supported by data, can add comment that not currently etc\\n6) Is IBD drug for irritable bowl disease, maybe include this in GI assessment of diagnosis as well with supported by \\n7) in the pain section can you answer all questions in this section, couple missing.\\n8) in patient summary can you add something here so it is not blank\\n9) lastly, I see in the assessment that you have patient having hard time financially with medications/food disparity and that you placed CM referral, I do not see referral under referral tab, were\\nyou able to submit one?\\n\\nthank you! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 16 Feb 2026 23:31:20 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"All set. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Marnela Haskell\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/09/2026 03:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"n.schaaf@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\": 10000030765, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000030765}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000030765, \"scheduleDate\": \"2026-02-09T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:44\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:06:23\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"df933ba8-296b-4876-8ef2-df9d5fbf8e45\\\",\\\"destination_fax_number\\\":\\\"12072943561\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"df933ba8-296b-4876-8ef2-df9d5fbf8e45\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12072943561\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"12072943561         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:09.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":8,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":376,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":376,\\\"start_timestamp\\\":\\\"2026-03-03T22:06:36.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:09.005+0000\\\",\\\"pages_sent\\\":8,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-09T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:46', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000030765\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Haskell_10000030765_02092026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:22\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000030765.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Haskell_10000030765_02092026.pdf', NULL, 'Summary_10000030765.pdf', NULL, '[{\"date\": \"2026-02-10T11:25:41.700Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-16T23:31:20.709Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-09T17:04', 'Member_Summary_10000030765.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000030765\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000030765.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:23\"}', 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
(59, 57818338, 44829497, '71460194', '10000087355', '', '', '14133640', 'Thomas', 'Dudley', 'English', '', '{\"DOB\": 22742, \"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\": \"1861451080\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"DANIEL PIERCE\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8RC5A43CF54\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1962-04-06\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"10 MAGEAN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"10 MAGEAN ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dudley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Thomas\", \"Member_Middle_name\": \"K\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"thomaskd06@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\": \"2077299074\", \"Member_Identification_Number\": \"10000087355\", \"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:06:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:27\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-07T11:00\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-19T15:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-19T15:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-07T10: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:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-07T11:00\", \"reportStatus_date\": \"2026-02-07T11:00\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-19T15:27\", \"reportStatus_date\": \"2026-02-19T15:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-07T10:25\", \"username\": \"SAcha\"}], \"qaAssigned\": [{\"date\": \"2026-02-09T11:47\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-07T11:00\", \"username\": \"SAcha\"}, {\"date\": \"2026-02-07T11:00\", \"username\": \"SAcha\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-19T15:27\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-19T15:22\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-19T15:27\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"13:57:18\", \"value\": [{\"add\": \"10 MAGEAN ST\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-04-06\", \"eno\": \"2073193834\", \"lob\": \"GA - 2026\", \"pno\": \"2077299074\", \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 0, \"insh\": \"10000087355\", \"mzip\": \"04011\", \"name\": \"Thomas K Dudley\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DANIEL PIERCE\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"thomaskd06@yahoo.com\", \"ename\": \"Daniel Dudley\", \"madd1\": \"10 MAGEAN ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"259 Main St\", \"pcpnpi\": \"1861451080\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8RC5A43CF54\", \"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\": \"13:15:36\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 13:57:18\"}', 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\": 10000087355, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000087355}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000087355, \"scheduleDate\": \"2026-02-07T10:10:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:44\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:06:26\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3e5bba7c-5631-432f-b59e-3895040c4811\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3e5bba7c-5631-432f-b59e-3895040c4811\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:22.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:06:53.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:11.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:10:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:37.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:13:54.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:11.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:17:25.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:40.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:20:48.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:22:01.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:24:13.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:22.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-07T10:10:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:46', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000087355\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Dudley_10000087355_02072026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:25\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000087355.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Dudley_10000087355_02072026.pdf', NULL, 'Summary_10000087355.pdf', NULL, '[{\"date\": \"2026-02-07T15:59:59.403Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-07T10:59', 'Member_Summary_10000087355.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000087355\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000087355.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:27\"}', 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
(60, 57818338, 44829497, '17537038', '10000031315', '', '', '14133640', 'Colin', 'Robinson', 'English', '', '{\"DOB\": 13633, \"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\": \"1891717872\", \"Pcp_Zip\": \"04104\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"MARCUS DECK\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4JW8RQ6FR38\", \"Member_City\": \"Orrs Island\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Orrs Island\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1937-04-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746 \", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2077984018\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"48 GRASSY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04066\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"48 GRASSY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04066\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Robinson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Colin\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"COLIN_ROBINSON@COMCAST.NET\", \"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\": \"2078332940\", \"Member_Identification_Number\": \"10000031315\", \"Member_Alternate_Phone_Number\": \"2077518614\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:06:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:31\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-04T10:07\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-20T13:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-20T14:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-04T09:08\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-04T10:07\", \"reportStatus_date\": \"2026-02-04T10:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-20T14:03\", \"reportStatus_date\": \"2026-02-20T14:03\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T09:08\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-04T18:55\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-04T10:07\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-04T10:07\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-19T11:58\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-19T12:01\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-19T16:47\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-20T13:18\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-20T14:03\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-20T13:55\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-20T14:03\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T12:03\", \"username\": \"JSilverio\"}, {\"date\": \"2026-02-19T22:20\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"13:59:25\", \"value\": [{\"add\": \"48 GRASSY RD\", \"age\": 88, \"ano\": \"2077518614\", \"cno\": \"\", \"dob\": \"1937-04-28\", \"eno\": \"2077518614\", \"lob\": \"GA - 2026\", \"pno\": \"2078332940\", \"zip\": \"04066\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Orrs Island\", \"gend\": 0, \"insh\": \"10000031315\", \"mzip\": \"04066\", \"name\": \"Colin Robinson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MARCUS DECK\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"COLIN_ROBINSON@COMCAST.NET\", \"ename\": \"Sandra Robinson\", \"madd1\": \"48 GRASSY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Orrs Island\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746 \", \"pcpnpi\": \"1891717872\", \"pcpzip\": \"04104\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077984018\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4JW8RQ6FR38\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Clergy as available\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-04-2026\", \"time\": \"09:08:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 13:59:25\"}', NULL, NULL, '{\"memberId\": \"10000031315\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 17:03:49 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda\\n1.  Demographics gender needs answer\\n2.  Self assessment ADl 1 =independent please do not use zero\\n3.  AOD musculoskeletal gout symptoms needs answer\\n4.  AOD Hematology other chosen please add name of the diagnosis\\n5.  vital signs please choose option\\n6.  Exam Review please answer all question you could visualize during the virtual visit and and answer psychological\\n7.  Home safety quality of life question and are there things you would like to change question need answers.\\n8.  Assessors comments needs information reported about the visit.\\\\\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 19 Feb 2026 21:47:26 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\nI have added the information to the HRA. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Feb 2026 03:20:08 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n1.  Medical History reports CPAP.  There is no mention of sleep apnea in the HRA.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Feb 2026 18:18:57 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Judi, \\n\\n I have completed the changes. \\n\\nThank you, \\nAmanda\"}, \"mailId\": \"\"}], \"memberName\": \"Colin Robinson\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/04/2026 09:00 AM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000031315, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000031315}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000031315, \"scheduleDate\": \"2026-02-04T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:44\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:06:30\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"01305ac3-ff53-47fa-9ee2-9f6660c278a9\\\",\\\"destination_fax_number\\\":\\\"12077984018\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"01305ac3-ff53-47fa-9ee2-9f6660c278a9\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055037548\\\",\\\"destination_fax_number\\\":\\\"12077984018\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552141038 23      \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:11.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":5,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":1,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":203,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:06:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:07:16.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":203,\\\"start_timestamp\\\":\\\"2026-03-03T22:09:32.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:11.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-04T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:46', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000031315\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Robinson_10000031315_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:29\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000031315.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Robinson_10000031315_02042026.pdf', NULL, 'Summary_10000031315.pdf', NULL, '[{\"date\": \"2026-02-04T15:07:47.734Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-19T21:47:26.131Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-20T18:18:57.601Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T10:02', 'Member_Summary_10000031315.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000031315\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000031315.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:31\"}', 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
(61, 55499828, 44829497, '48822527', '10000031702', '', '', '14133640', 'Edwin', 'Childs', '', '', '{\"DOB\": 13333, \"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\": \"1609836238\", \"Pcp_Zip\": \"04048\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LIMERICK\", \"Pcp_Name\": \"DAVID GALBRAITH\", \"Rank_All\": 1, \"PCP_Phone\": \"2077939586\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9R02TN3RV25\", \"Member_City\": \"Limington\", \"Office_Name\": \"GALBRAITH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Limington\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1936-07-02\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"44 ELM ST\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2077939587\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"65 NOTORN AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04049\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 234\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04049\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Childs\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Edwin\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"ticumoff@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2072980370\", \"Member_Identification_Number\": \"10000031702\", \"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:06:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:35\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-20T15:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-20T16:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-20T16:31\", \"reportStatus_date\": \"2026-02-20T16:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-02-19T19:45\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-20T16:31\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-20T15:40\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-20T16:31\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"14:07:43\", \"value\": [{\"add\": \"65 NOTORN AVE\", \"age\": 89, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1936-07-02\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2072980370\", \"zip\": \"04049\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Limington\", \"gend\": 0, \"insh\": \"10000031702\", \"mzip\": \"04049\", \"name\": \"Edwin Childs\", \"plan\": \"Martin\'s Point\", \"pphy\": \"DAVID GALBRAITH\", \"ppno\": \"2077939586\", \"cliId\": \"\", \"email\": \"ticumoff@icloud.com\", \"ename\": \"\", \"madd1\": \"PO BOX 234\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Limington\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"44 ELM ST\", \"pcpnpi\": \"1609836238\", \"pcpzip\": \"04048\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LIMERICK\", \"pcpname\": \"GALBRAITH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077939587\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9R02TN3RV25\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-09-2026\", \"time\": \"17:03:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 14:07:43\"}', NULL, NULL, '{\"memberId\": \"10000031702\", \"clinician\": \"Jennifer Landry\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Tue, 04 Feb 2026 14:25:50 GMT\", \"name\": \"Holly Beck\", \"role\": \"QA\", \"files\": [], \"query\": {\"feedback\": \"Hey Jennifer, can you select taking or not taking for TROSPIUM on the med list  Under the RESP section can you select yes or no\\n\", \"response\": \"\"}, \"mailId\": \"h.beck@focuscares.com\"}, {\"date\": \"Fri, 20 Feb 2026 00:45:11 GMT\", \"name\": \"Jennifer \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"On my view listed as not taking\\n\\nJen\"}, \"mailId\": \"\"}], \"memberName\": \"Edwin Childs\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/03/2026 12:10 PM\", \"clinicianMailId\": \"j.landry@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\": 10000031702, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": 10000031702}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": 10000031702, \"scheduleDate\": \"2026-02-03T12:10:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:45\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:06:34\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"2b7de1bc-fb24-4395-84cd-5045c59b3113\\\",\\\"destination_fax_number\\\":\\\"12077939587\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"2b7de1bc-fb24-4395-84cd-5045c59b3113\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12077939587\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"SpanDSP Fax Ident\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:24.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\\\":257,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":257,\\\"start_timestamp\\\":\\\"2026-03-03T22:06:49.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:24.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T12:10:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:47', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000031702\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Childs_10000031702_02032026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:33\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000031702.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Childs_10000031702_02032026.pdf', NULL, 'Summary_10000031702.pdf', NULL, '[{\"date\": \"2026-02-03T22:00:57.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-20T00:45:11.575Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T12:35', 'Member_Summary_10000031702.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000031702\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000031702.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:34\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(62, 57818338, 44829497, '39698290', '10000031705', '', '', '14133640', 'Roberta', 'Mocciola', 'English', '', '{\"DOB\": 16929, \"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\": \"1942653415\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"CAROLYN FERGUSON\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9QK1T00EK05\", \"Member_City\": \"Mechanic Falls\", \"Office_Name\": \"CENTRAL MAINE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Mechanic Falls\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-05-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"12 High St Ste 302\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"4027292102\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"31 PURINGTON AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04256\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"31 PURINGTON AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04256\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mocciola\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Roberta\", \"Member_Middle_name\": \"W\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"declined@022825.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\": \"2073123196\", \"Member_Identification_Number\": \"10000031705\", \"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:06:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:39\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-21T14:34\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-24T11:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-24T12:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-16T21:48\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2026-02-16T21:48\", \"reportStatus_date\": \"2026-02-16T21:48\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-21T14:34\", \"reportStatus_date\": \"2026-02-21T14:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-24T12:55\", \"reportStatus_date\": \"2026-02-24T12:55\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-16T21:48\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-23T17:31\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-21T14:34\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-21T14:34\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-24T12:55\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-24T11:50\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-24T12:55\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"14:10:38\", \"value\": [{\"add\": \"31 PURINGTON AVE\", \"age\": 79, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-05-07\", \"eno\": \"2073329650\", \"lob\": \"GA - 2026\", \"pno\": \"2073123196\", \"zip\": \"04256\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Mechanic Falls\", \"gend\": 1, \"insh\": \"10000031705\", \"mzip\": \"04256\", \"name\": \"Roberta W Mocciola\", \"plan\": \"Martin\'s Point\", \"pphy\": \"CAROLYN FERGUSON\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"declined@022825.com\", \"ename\": \"Tina Pasquale\", \"madd1\": \"31 PURINGTON AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Mechanic Falls\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"12 High St Ste 302\", \"pcpnpi\": \"1942653415\", \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"Lewiston\", \"pcpname\": \"CENTRAL MAINE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"4027292102\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9QK1T00EK05\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-16-2026\", \"time\": \"21:48:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 14:10:38\"}', 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\": 10000031705, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000031705}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000031705, \"scheduleDate\": \"2026-02-03T16:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:45\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:06:38\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"6065e9bc-d685-4ddd-83f5-0549393fd699\\\",\\\"destination_fax_number\\\":\\\"14027292102\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"6065e9bc-d685-4ddd-83f5-0549393fd699\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"14027292102\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:09.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\\\":291,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":291,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:07.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:12:09.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T16:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:47', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000031705\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Mocciola_10000031705_02032026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:37\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000031705.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Mocciola_10000031705_02032026.pdf', NULL, 'Summary_10000031705.pdf', NULL, '[{\"date\": \"2026-02-21T19:34:45.124Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T17:29', 'Member_Summary_10000031705.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000031705\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000031705.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:38\"}', 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
(63, 50892900, 44829497, '71460194', '10000032797', '', '', '14133640', 'Reynard', 'Gilbert', 'English', '', '{\"DOB\": 16514, \"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\": \"1194801993\", \"Pcp_Zip\": \"04265\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"GARY RIVARD\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3RU9VK9EQ26\", \"Member_City\": \"Turner\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Turner\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-03-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"180 CHURCH HILL RD, STE 1\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2076476015\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"454 UPPER ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04282\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"454 UPPER ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04282\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gilbert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Reynard\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"2072253927\", \"Member_Identification_Number\": \"10000032797\", \"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:06:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:06:43\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:06\", \"reportStatus_date\": \"2026-03-03T17:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:06\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"14:15:02\", \"value\": [{\"add\": \"454 UPPER ST\", \"age\": 80, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-03-18\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2072253927\", \"zip\": \"04282\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Turner\", \"gend\": 0, \"insh\": \"10000032797\", \"mzip\": \"04282\", \"name\": \"Reynard S Gilbert\", \"plan\": \"Martin\'s Point\", \"pphy\": \"GARY RIVARD\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"454 UPPER ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Turner\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD, STE 1\", \"pcpnpi\": \"1194801993\", \"pcpzip\": \"04265\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076476015\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3RU9VK9EQ26\", \"currentgend\": \"\", \"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-03-2026\", \"time\": \"15:59:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2026 14:15:02\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 01:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000032797, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"71460194\", \"memberId\": 10000032797}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"71460194\", \"memberId\": 10000032797, \"scheduleDate\": \"2026-02-01T11:20:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:45\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:06:42\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"9a4f2eb8-b873-4a6d-86ce-470b2b362981\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"9a4f2eb8-b873-4a6d-86ce-470b2b362981\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12076476015\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:53.005+0000\\\",\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:07:16.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:31.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:10:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:11:51.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:13:59.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:15:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:17:20.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:18:27.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:20:45.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:21:24.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:23:39.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:24:53.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-01T11:20:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:47', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000032797\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Gilbert_10000032797_02012026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:06:41\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000032797.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Gilbert_10000032797_02012026.pdf', NULL, 'Summary_10000032797.pdf', NULL, '[{\"date\": \"2026-02-02T02:24:22.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-01T12:30', 'Member_Summary_10000032797.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000032797\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000032797.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:06:42\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
