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
(29, NULL, NULL, '48822527', '10000015487', '', '', '14133640', 'Doris', 'Bicknell', 'English', '', '{\"DOB\": 17143, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1841569720\", \"Pcp_Zip\": \"04062\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"windham\", \"Pcp_Name\": \"Kelly Gilford\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1XK4G08WN77\", \"Member_City\": \"Windham\", \"Office_Name\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Windham\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-12-07\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"Roosevlt trail\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078280188\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"286 FALMOUTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"286 FALMOUTH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bicknell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Doris\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"DECLINE@2024.COM\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2075729453\", \"Member_Identification_Number\": \"10000015487\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":6,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-11-2026 15:06:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-11 15:06:15\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-24T11:29\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-03-02T14:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T14:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-04T19:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-16T15:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-24T11:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-04-11T15:06\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-08T15:01\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-09T19:34\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2026-02-04T13:52\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}, {\"date\": \"2026-02-26T18:32\", \"text\": \"Recheduled\", \"method\": \"import\", \"status\": -1}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-03T16:38\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2026-02-28T12:39\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-03-16T15:12\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-04T13:52\", \"reportStatus_date\": \"2026-02-04T13:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2026-02-28T12:39\", \"reportStatus_date\": \"2026-03-02T14:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-04T19:39\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-16T15:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-24T11:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-04-11T15:06\", \"reportStatus_date\": \"2026-04-11T15:06\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-02-04T13:52\", \"username\": null}, {\"date\": \"2026-02-04T13:52\", \"username\": \"LRivera\"}, {\"date\": \"2026-04-08T15:01\", \"username\": null}, {\"date\": \"2026-04-08T15:01\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-02-26T18:32\", \"username\": \"JLandry\"}, {\"date\": \"2026-04-09T19:34\", \"username\": \"JLandry\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-04-11T15:06\", \"username\": \"JLandry\"}, {\"date\": \"2026-04-11T15:06\", \"username\": \"JLandry\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:38\", \"username\": \"AWalsh\"}, {\"date\": \"2026-02-28T12:39\", \"username\": \"JLandry\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-11-2026\", \"time\": \"12:51:43\", \"value\": [{\"add\": \"286 FALMOUTH RD\", \"age\": 79, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1946-12-07\", \"eno\": \"2075729453\", \"lob\": \"GA - Wave 2\", \"pno\": \"2075729453\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Windham\", \"gend\": 1, \"insh\": \"10000015487\", \"mzip\": \"04062\", \"name\": \"Doris E Bicknell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Kelly Gilford\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"DECLINE@2024.COM\", \"ename\": \"Caryn\", \"madd1\": \"286 FALMOUTH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Windham\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Roosevlt trail\", \"pcpnpi\": \"1841569720\", \"pcpzip\": \"04062\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"windham\", \"pcpname\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078280188\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"1XK4G08WN77\", \"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-26-2026\", \"time\": \"17:57:46\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-11-2026 15:06:14\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-03T16:38\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 3, \"cancelText\": \"needs to cancel\", \"cancelStatus\": 0}, {\"date\": \"2026-02-28T12:39\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"JLandry\", \"hraStatus\": 3, \"cancelText\": \"went to urgent care\", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/8/2026 @ 12:01 PM\", \"result\": 0, \"comment\": \"scheduled f2f appt w/ jennifer ladny 1:20 on 4/11\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"4/8/2026 @ 11:48 AM\", \"result\": 3, \"comment\": \"called to schedule w/ Jennifer Landry\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/24/2026 @ 11:29 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 03:12 PM\", \"result\": 6, \"comment\": \"inbound call- member returning call- she states she is out of town right now be better to give a call back next week\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"3/23/2026 @ 03:11 PM\"}, {\"date\": \"3/16/2026 @ 03:10 PM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/17/2026 @ 03:10 PM\"}, {\"date\": \"3/4/2026 @ 07:39 PM\", \"result\": 3, \"comment\": \"03/04/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"3/11/2026 @ 07:39 PM\"}, {\"date\": \"3/3/2026 @ 02:18 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA/Erin Barker.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/5/2026 @ 02:18 PM\"}, {\"date\": \"3/2/2026 @ 02:13 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"3/5/2026 @ 02:13 PM\"}, {\"date\": \"2/4/2026 @ 12:52 PM\", \"result\": 12, \"comment\": \"Member was already rescheduled by Laura A on 1/28; she is rescheduled with Jennifer Laundry 2/28 at 1:10 PM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000015487\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"48822527\", \"memberId\": \"10000015487\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"48822527\", \"memberId\": \"10000015487\", \"scheduleDate\": \"2026-4-11T13:20\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 12:52:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"04-08-2026 15:01:29\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 0, NULL, NULL, 'In Person', '2026-4-11T13:20', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"date\": \"2026-04-11T19:06:13.864Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-04-11T14:00', 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
(30, 71932120, 44829497, '22140773', '10000016185', '', '', '14133640', 'Stuart', 'Sachs', 'English', '', '{\"DOB\": 14208, \"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\": \"1558302273\", \"Pcp_Zip\": \"04243\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"BRYAN LUNDQUIST\", \"Rank_All\": 1, \"PCP_Phone\": \"207\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"1KE7Y03FW79\", \"Member_City\": \"HAMPDEN\", \"Office_Name\": \"ST JOSEPH FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"HAMPDEN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1938-11-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 7291\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2077778800\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"261 WESTERN AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04444\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"261 WESTERN AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04444\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Sachs\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stuart\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"ogyrfalcon@roadrunner.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\": \"2078623566\", \"Member_Identification_Number\": \"10000016185\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073569402\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}', '{\"date\": \"2026-03-03 17:05:04\", \"hrastatus\": \"\", \"reportstatus\": \"Pending\"}', '{\"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-11T11:19\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-12T15:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-12T17:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-11T06: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:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-12T17:19\", \"reportStatus_date\": \"2026-02-12T17:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-11T06:58\", \"username\": \"EBarker\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:18\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-11T11:19\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-11T11:19\", \"username\": \"EBarker\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-12T17:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-12T15:34\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-12T17:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:13:37\", \"value\": [{\"add\": \"261 WESTERN AVE\", \"age\": 87, \"ano\": \"\", \"cno\": \"2073569402\", \"dob\": \"1938-11-24\", \"eno\": \"2073564010\", \"lob\": \"GA - 2026\", \"pno\": \"2078623566\", \"zip\": \"04444\", \"add2\": \"\", \"add3\": \"\", \"city\": \"HAMPDEN\", \"gend\": 0, \"insh\": \"10000016185\", \"mzip\": \"04444\", \"name\": \"Stuart H Sachs\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BRYAN LUNDQUIST\", \"ppno\": \"207\", \"cliId\": \"\", \"email\": \"ogyrfalcon@roadrunner.com\", \"ename\": \"Barbara Lawrence - signifcant other\", \"madd1\": \"261 WESTERN AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"HAMPDEN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 7291\", \"pcpnpi\": \"1558302273\", \"pcpzip\": \"04243\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"LEWISTON\", \"pcpname\": \"ST JOSEPH FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077778800\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"1KE7Y03FW79\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP is Scott Simpson, PA, in the same office\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-09-2026\", \"time\": \"16:34:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 12:48:34\"}', 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\": 10000016185, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000016185}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000016185, \"scheduleDate\": \"2026-02-11T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:36\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:03\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"088da3ed-1ef6-4635-83cc-2f81640e8328\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"088da3ed-1ef6-4635-83cc-2f81640e8328\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12077778800\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:35.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\\\":300,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":300,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:10:35.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-11T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:38', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016185\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Sachs_10000016185_02112026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:02\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000016185.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Sachs_10000016185_02112026.pdf', NULL, 'Summary_10000016185.pdf', NULL, '[{\"date\": \"2026-02-11T16:19:11.926Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-11T10:11', 'Member_Summary_10000016185.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000016185\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000016185.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:03\"}', 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
(31, 55499828, 44829497, '17537038', '10000105141', '', '', '14133640', 'Scott', 'Swett', 'English', '', '{\"DOB\": 18857, \"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\": \"1285038174\", \"Pcp_Zip\": \"04254\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LIVERMORE FALLS\", \"Pcp_Name\": \"JOLINE SAGE\", \"Rank_All\": 1, \"PCP_Phone\": \"2075624226\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3RN3DU7MD71\", \"Member_City\": \"JAY\", \"Office_Name\": \"WESTERN MAINE FAMILY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"JAY\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-08-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"16 DEPOT ST SUITE 300\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Franklin\", \"Member_Country\": \"Franklin\", \"PCP_Fax_Number\": \"2078972321\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"3 SCHOOL BUS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04239\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 SCHOOL BUS RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04239\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Swett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Scott\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"scottswett@hotmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"6178751701\", \"Member_Identification_Number\": \"10000105141\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:07\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-05T15:39\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-11T14:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-11T17:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-05T09:14\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-01-31T10:11\", \"reportStatus_date\": \"2026-01-31T10:11\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-07T10:43\", \"reportStatus_date\": \"2026-02-05T15:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-11T17:44\", \"reportStatus_date\": \"2026-02-11T17:44\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-05T09:14\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-06T16:29\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-05T15:39\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-05T15:39\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-07T10:38\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-07T10:41\", \"username\": \"HBeck\"}, {\"date\": \"2026-02-11T10:43\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-11T17:44\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-11T14:56\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-11T17:44\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-07T10:43\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:17:05\", \"value\": [{\"add\": \"3 SCHOOL BUS RD\", \"age\": 74, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-08-17\", \"eno\": \"7812967082\", \"lob\": \"GA - 2026\", \"pno\": \"6178751701\", \"zip\": \"04239\", \"add2\": \"\", \"add3\": \"\", \"city\": \"JAY\", \"gend\": 0, \"insh\": \"10000105141\", \"mzip\": \"04239\", \"name\": \"Scott L Swett\", \"plan\": \"Martin\'s Point\", \"pphy\": \"JOLINE SAGE\", \"ppno\": \"2075624226\", \"cliId\": \"\", \"email\": \"scottswett@hotmail.com\", \"ename\": \"Wife Huimi Swett \\\"Celeste\\\"\\\"\", \"madd1\": \"3 SCHOOL BUS RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"JAY\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"16 DEPOT ST SUITE 300\", \"pcpnpi\": \"1285038174\", \"pcpzip\": \"04254\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"LIVERMORE FALLS\", \"pcpname\": \"WESTERN MAINE FAMILY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078972321\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3RN3DU7MD71\", \"currentgend\": \"Male\", \"pphycomment\": \"uses VA for most services \", \"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-05-2026\", \"time\": \"09:14:09\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 15:31:27\"}', NULL, NULL, '{\"memberId\": \"10000105141\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Sat, 07 Feb 2026 15:43:38 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Amanda,\\n1) please add marital status \\n2) For the ADL chart please use numbers 1-4, 1 if she is completely independent \\n3) Question about seeing any medical specialist is selected yes but no additional information listed \\n4) For every medication on the med list , can you select taking or not taking \\n5) ASA listed on the OTC list as him taking it daily, has he been taking the medication for a while, if so, can you add to long term use box right above the OTC list \\n6) Under the GU section, GERD is a box you can select and add supporting data ( medications) \\n7) CAD listed on the med list, can you add to cardiac section\\n8) please add information to the patient summary box at the end of the HRA \\n\\n\\n\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 15:43:35 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1) please add marital status - complete \\n2) For the ADL chart please use numbers 1-4, 1 if she is completely independent  - complete\\n3) Question about seeing any medical specialist is selected yes but no additional information listed  - corrected\\n4) For every medication on the med list , can you select taking or not taking  - completed\\n5) ASA listed on the OTC list as him taking it daily, has he been taking the medication for a while, if so, can you add to long term use box right above the OTC list - completed\\n6) Under the GU section, GERD is a box you can select and add supporting data ( medications) - completed \\n7) CAD listed on the med list, can you add to cardiac section - completed\"}, \"mailId\": \"\"}], \"memberName\": \"Scott Swett\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/05/2026 03:00 PM\", \"clinicianMailId\": \"a.milliken@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\": 10000105141, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000105141}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000105141, \"scheduleDate\": \"2026-02-05T15:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:06\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"11c94ffd-e682-4c82-89cc-d07802fd55eb\\\",\\\"destination_fax_number\\\":\\\"12078972321\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"11c94ffd-e682-4c82-89cc-d07802fd55eb\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12078972321\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:27.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\\\":214,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":214,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:27.005+0000\\\",\\\"pages_sent\\\":5,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-05T15:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:38', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000105141\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Swett_10000105141_02052026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000105141.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Swett_10000105141_02052026.pdf', NULL, 'Summary_10000105141.pdf', NULL, '[{\"date\": \"2026-02-05T20:39:42.309Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-11T15:43:34.948Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-05T15:38', 'Member_Summary_10000105141.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000105141\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000105141.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:07\"}', 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
(32, 71932120, 44829497, '17537038', '10000017452', '', '', '14133640', 'Richard', 'Anderson', 'English', '', '{\"DOB\": 17173, \"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\": \"1124067194\", \"Pcp_Zip\": \"04605\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Ellsworth\", \"Pcp_Name\": \"KATHRYN RENSENBRINK\", \"Rank_All\": 1, \"PCP_Phone\": \"2076647780\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2H42K14GF87\", \"Member_City\": \"ELLSWORTH\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE ELLSWORTH\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"ELLSWORTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-01-06\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"32 Resort Way\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"2076647721\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"93 MADDOCKS AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04605\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"93 MADDOCKS AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04605\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Anderson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"declined@061623.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\": \"2074602583\", \"Member_Identification_Number\": \"10000017452\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074602583\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:12\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-04T23:17\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-11T15:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-11T17:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-04T13:55\", \"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-04T23:17\", \"reportStatus_date\": \"2026-02-04T23:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-11T17:48\", \"reportStatus_date\": \"2026-02-11T17:48\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-04T13:55\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-05T12:13\", \"username\": \"PFrey1\"}, {\"date\": \"2026-02-10T10:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-04T23:17\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-04T23:17\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-10T19:55\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-10T20:01\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-11T11:52\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-11T17:48\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-11T15:40\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-11T17:48\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-10T20:04\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:22:00\", \"value\": [{\"add\": \"93 MADDOCKS AVE\", \"age\": 79, \"ano\": \"\", \"cno\": \"2074602583\", \"dob\": \"1947-01-06\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2074602583\", \"zip\": \"04605\", \"add2\": \"\", \"add3\": \"\", \"city\": \"ELLSWORTH\", \"gend\": 0, \"insh\": \"10000017452\", \"mzip\": \"04605\", \"name\": \"Richard Anderson\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KATHRYN RENSENBRINK\", \"ppno\": \"2076647780\", \"cliId\": \"\", \"email\": \"declined@061623.com\", \"ename\": \"Beth Bunker-Anderson \", \"madd1\": \"93 MADDOCKS AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"ELLSWORTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"32 Resort Way\", \"pcpnpi\": \"1124067194\", \"pcpzip\": \"04605\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Ellsworth\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE ELLSWORTH\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076647721\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2H42K14GF87\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"would like clergy service for critical illnesses \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-04-2026\", \"time\": \"13:55:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 16:34:02\"}', NULL, NULL, '{\"memberId\": \"10000017452\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Wed, 11 Feb 2026 00:55:54 GMT\", \"name\": \"MJoseph\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\nPlease select if the status \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 01:04:02 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanada,\\n\\n1. Please select the status for metoprolol on the medication list.\\n2. Member is on medication for hypertension; however, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition? Please clarify.\\n3. The member is on medication for DVT/PE;  however, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition? Please clarify.\\n4. Please add comments/note to the patient summary.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 11 Feb 2026 16:52:38 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Please select the status for metoprolol on the medication list. - completed\\n2. Member is on medication for hypertension; however, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition? Please clarify. - completed\\n3. The member is on medication for DVT/PE;  however, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition? Please clarify. - completed\\n4. Please add comments/note to the patient summary.\\n\"}, \"mailId\": \"\"}], \"memberName\": \"Richard Anderson\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/04/2026 01:30 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"2/3/2026 @ 10:55 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Ring\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000017452, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000017452}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000017452, \"scheduleDate\": \"2026-02-04T13:30:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1771235018}', 0, NULL, '[{\"date\": \"2026-03-03 17:05:11\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"59730321-d874-486a-9d3c-b030b6a3ac78\\\",\\\"destination_fax_number\\\":\\\"12076647721\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"59730321-d874-486a-9d3c-b030b6a3ac78\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12076647721\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2076647721 MCMH Nort\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:55.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\\\":237,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":237,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:25.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:09:55.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-04T13:30:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000017452\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Anderson_10000017452_02042026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:10\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000017452.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Anderson_10000017452_02042026.pdf', NULL, 'Summary_10000017452.pdf', NULL, '[{\"date\": \"2026-02-05T04:17:01.166Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-11T16:52:38.686Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-04T15:03', 'Member_Summary_10000017452.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000017452\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000017452.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:11\"}', 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
(33, 55499828, 44829497, '39698290', '10000018387', '', '', '14133640', 'Lynda', 'Bell', 'English', '', '{\"DOB\": 17157, \"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\": \"1205863156\", \"Pcp_Zip\": \"04268\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"NORWAY\", \"Pcp_Name\": \"INGA JOHANNESSON\", \"Rank_All\": 1, \"PCP_Phone\": \"2077437721\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7R09G60TK27\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE FAMILY AND INTERNAL MEDIC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1946-12-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"8 PIKES HL\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077436306\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"200 STETSON RD APT 205\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"200 STETSON RD APT 205\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Bell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lynda\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Lyndabell2146@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\": \"4107079987\", \"Member_Identification_Number\": \"10000018387\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"4107079987\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:05:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:05:16\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-23T20:07\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-26T18:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-26T20:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-23T09:16\", \"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-23T20:07\", \"reportStatus_date\": \"2026-02-23T20:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-26T20:05\", \"reportStatus_date\": \"2026-02-26T20:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:05\", \"reportStatus_date\": \"2026-03-03T17:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:05\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-23T09:16\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-02-24T11:11\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-23T20:07\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-23T20:07\", \"username\": \"SCadwell\"}, {\"date\": \"2026-02-26T14:20\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-26T20:05\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-26T18:25\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-26T20:05\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-26T10:45\", \"username\": \"HBeck\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-11-2026\", \"time\": \"11:25:19\", \"value\": [{\"add\": \"200 STETSON RD APT 205\", \"age\": 79, \"ano\": \"\", \"cno\": \"4107079987\", \"dob\": \"1946-12-21\", \"eno\": \"4435381946\", \"lob\": \"GA - 2026\", \"pno\": \"4107079987\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 1, \"insh\": \"10000018387\", \"mzip\": \"04210\", \"name\": \"Lynda E Bell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"INGA JOHANNESSON\", \"ppno\": \"2077437721\", \"cliId\": \"\", \"email\": \"Lyndabell2146@gmail.com\", \"ename\": \"Kelly Day \", \"madd1\": \"200 STETSON RD APT 205\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"8 PIKES HL\", \"pcpnpi\": \"1205863156\", \"pcpzip\": \"04268\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": 0, \"pcpcity\": \"NORWAY\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE FAMILY AND INTERNAL MEDIC\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077436306\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7R09G60TK27\", \"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-20-2026\", \"time\": \"11:04:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-31-2026 17:13:08\"}', NULL, NULL, '{\"memberId\": \"10000018387\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Holly Beck\", \"queryData\": [{\"date\": \"Thu, 26 Feb 2026 15:45:10 GMT\", \"name\": \"Holly \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hey Sandra,\\n1) Under Neuro section, it says active for cerebral ischemia, did you mean to put history of?\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 26 Feb 2026 19:20:46 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"yes. completed\"}, \"mailId\": \"\"}], \"memberName\": \"Lynda Bell\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/23/2026 09:00 AM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"h.beck@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000018387, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": 10000018387}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": 10000018387, \"scheduleDate\": \"2026-02-23T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:05:16\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3ae5f8f4-a1cf-4e8e-8218-43daccb29e81\\\",\\\"destination_fax_number\\\":\\\"12077436306\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3ae5f8f4-a1cf-4e8e-8218-43daccb29e81\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038892\\\",\\\"destination_fax_number\\\":\\\"12077436306\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"MaineHealth         \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:55.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":2,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":581,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":159,\\\"start_timestamp\\\":\\\"2026-03-03T22:05:37.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:08:30.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E44\\\",\\\"error_message\\\":\\\"The transmission was interrupted.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":160,\\\"start_timestamp\\\":\\\"2026-03-03T22:10:57.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:13:52.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E44\\\",\\\"error_message\\\":\\\"The transmission was interrupted.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":262,\\\"start_timestamp\\\":\\\"2026-03-03T22:16:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:20:55.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-23T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000018387\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Bell_10000018387_02232026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:05:14\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000018387.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Bell_10000018387_02232026.pdf', NULL, 'Summary_10000018387.pdf', NULL, '[{\"date\": \"2026-02-24T01:07:07.951Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-26T19:20:44.960Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-23T10:54', 'Member_Summary_10000018387.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000018387\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000018387.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:05:16\"}', 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
(34, 71932120, 44829497, '22140773', '10000018625', '', '', '14133640', 'Floyd', 'Neal', 'English', '', '{\"DOB\": 17372, \"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\": \"1922487412\", \"Pcp_Zip\": \"04412\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"BREWER\", \"Pcp_Name\": \"RUTA GREBLIUNAITE\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5WM9FT0RE31\", \"Member_City\": \"DIXMONT\", \"Office_Name\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DIXMONT\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1947-07-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"43 WHITING HILL RD, SUITE 300\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"2079735042\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"18 WESTERN AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04932\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"18 WESTERN AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04932\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Neal\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Floyd\", \"Member_Middle_name\": \"O\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2072344623\", \"Member_Identification_Number\": \"10000018625\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:27:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:27:07\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-04T16:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-05T08:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-05T12:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"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\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-23T18:34\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-05T12:58\", \"reportStatus_date\": \"2026-03-05T12:58\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:27\", \"reportStatus_date\": \"2026-03-10T14:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:27\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-01-31T10:11\", \"username\": null}, {\"date\": \"2026-01-31T10:11\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-02-19T17:25\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-19T17:28\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-22T21:28\", \"username\": \"EBarker\"}, {\"date\": \"2026-03-04T16:05\", \"username\": \"AWalsh\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-05T12:58\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-05T08:28\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-05T12:58\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-19T17:29\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-22T21:18\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T21:24\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-22T21:27\", \"username\": \"EBarker\"}, {\"date\": \"2026-02-23T18:34\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-20-2026\", \"time\": \"12:16:13\", \"value\": [{\"add\": \"18 WESTERN AVE\", \"age\": 78, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1947-07-24\", \"eno\": \"2074783506\", \"lob\": \"GA - 2026\", \"pno\": \"2072344623\", \"zip\": \"04932\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DIXMONT\", \"gend\": 0, \"insh\": \"10000018625\", \"mzip\": \"04932\", \"name\": \"Floyd O Neal\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RUTA GREBLIUNAITE\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Ann Perry - sig other\", \"madd1\": \"18 WESTERN AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DIXMONT\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"43 WHITING HILL RD, SUITE 300\", \"pcpnpi\": \"1922487412\", \"pcpzip\": \"04412\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"BREWER\", \"pcpname\": \"NORTHERN LIGHT HUSSON FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2079735042\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5WM9FT0RE31\", \"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-03-2026\", \"time\": \"16:13:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-20-2026 12:16:13\"}', NULL, NULL, '{\"memberId\": \"10000018625\", \"clinician\": \"Erin Barker\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Thu, 19 Feb 2026 22:28:59 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\n1. Please complete the medication list. If the member no longer takes the medication, please remove them from the list.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 02:28:17 GMT\", \"name\": \"Erin \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"So the issue with visits done on 2/2 and 2/3 when we started using the new HRA is that these visits were also showing up on my schedule in the old HRA (which I did not document in). I just went into the new HRA and this member\'s visit is no longer in there. Just a referral that I entered that does not include info about his med list. So I don\'t know what the member is taking, as I would have put this info in my note in the new HRA. What\'s next?\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 23 Feb 2026 23:34:54 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Erin,\\n\\nThank you for responding. Is it possible to reach out to the member via telephone and get an update on the medication list?\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Floyd Neal\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/03/2026 09:00 AM\", \"clinicianMailId\": \"e.barker@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\": 10000018625, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"22140773\", \"memberId\": 10000018625}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"22140773\", \"memberId\": 10000018625, \"scheduleDate\": \"2026-02-03T09:00:00\"}}', NULL, '{\"date\": \"01-31-2026 10:11:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:27:06\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"6789c302-c813-4150-8bfe-c07cc53e4414\\\",\\\"destination_fax_number\\\":\\\"12079735042\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"6789c302-c813-4150-8bfe-c07cc53e4414\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13055038807\\\",\\\"destination_fax_number\\\":\\\"12079735042\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2079735042 Northern \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:31:58.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\\\":260,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":260,\\\"start_timestamp\\\":\\\"2026-03-10T18:27:19.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:31:58.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-03T09:00:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:49:39', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000018625\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Neal_10000018625_02032026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:27:05\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000018625.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Neal_10000018625_02032026.pdf', NULL, 'Summary_10000018625.pdf', NULL, '[{\"date\": \"2026-02-03T20:53:41.000Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-23T02:28:17.322Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-03T10:30', 'Member_Summary_10000018625.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000018625\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000018625.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:27:06\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
