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
(2036, NULL, NULL, NULL, '10000079271', '', '', '26056802', 'Merilee', 'Raines', '', '', '{\"DOB\": 20397, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1134206352\", \"Pcp_Zip\": \"41066143\", \"Program\": \"Medicare\", \"Pcp_City\": \"SOUTH PORTLAND\", \"Pcp_Name\": \"FRASER, ROBERT J\", \"Rank_All\": 1, \"PCP_Phone\": \"2077745816\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8HM3JQ4PH04\", \"Member_City\": \"CAPE ELIZABETH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CAPE ELIZABETH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-11-04\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"100 FODEN RD. W,SUITE 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"21 COLE FIELD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04107\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"21 COLE FIELD RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04107\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Raines\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Merilee\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"merileeraines@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2076711087\", \"Member_Identification_Number\": \"10000079271\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-13-2026 09:41:02\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-13 09:41:02\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-13T09:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T09:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T16:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T12:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T10:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T09:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T09:36\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T09:41\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:06\", \"value\": [{\"add\": \"21 COLE FIELD RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-11-04\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2076711087\", \"zip\": \"04107\", \"add2\": \"\", \"add3\": \"\", \"city\": \"CAPE ELIZABETH\", \"gend\": 1, \"insh\": \"10000079271\", \"mzip\": \"04107\", \"name\": \"Merilee Raines\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FRASER, ROBERT J\", \"ppno\": \"2077745816\", \"cliId\": \"\", \"email\": \"merileeraines@gmail.com\", \"ename\": \"\", \"madd1\": \"21 COLE FIELD RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"CAPE ELIZABETH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 FODEN RD. W,SUITE 203\", \"pcpnpi\": \"1134206352\", \"pcpzip\": \"41066143\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SOUTH PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8HM3JQ4PH04\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:00:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:06\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 12:46 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 03:32 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 03:47 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 07:50 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 08:41 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 04:35 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 04:56 PM\", \"result\": 3, \"comment\": \"03/19/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 03:23 PM\", \"result\": 3, \"comment\": \"o/c to sched w/ Shellie 3/24\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 09:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 10:38 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 09:08 AM\", \"result\": 3, \"comment\": \" called to schedule face to face \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 09:07 AM\"}, {\"date\": \"2/10/2026 @ 04:40 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 04:39 PM\"}, {\"date\": \"2/5/2026 @ 09:36 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"2/19/2026 @ 09:36 AM\"}, {\"date\": \"2/3/2026 @ 10:35 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 09:36:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"02-13-2026 09:41:02\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 15}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2037, NULL, NULL, NULL, '10000079305', '', '', '66650973', 'Benjamin', 'Peabody', 'English', '', '{\"DOB\": 19007, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1831179803\", \"Pcp_Zip\": \"42407634\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"STADNICKI, MICHAEL R\", \"Rank_All\": 1, \"PCP_Phone\": \"2077537655\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6C04X24PV05\", \"Member_City\": \"DENMARK\", \"Office_Name\": \"NORTH BRIDGTON FAMILY PRACTICE AND WALK IN CLINIC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DENMARK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-01-14\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"12 HIGH ST,STE 302\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Oxford\", \"Member_Country\": \"Oxford\", \"PCP_Fax_Number\": \"2077537656\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"852 DENMARK RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04022\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"852 DENMARK RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04022\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Peabody\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Benjamin\", \"Member_Middle_name\": \"I\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"benntammy@yahoo.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\": \"2074610164\", \"Member_Identification_Number\": \"10000079305\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-02-2026 19:10:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-02 19:10:52\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-02T19:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T13:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T13:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T11:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-02T19:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T13:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T11:41\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-02T19:10\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:07\", \"value\": [{\"add\": \"852 DENMARK RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-01-14\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074610164\", \"zip\": \"04022\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DENMARK\", \"gend\": 0, \"insh\": \"10000079305\", \"mzip\": \"04022\", \"name\": \"Benjamin I Peabody\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STADNICKI, MICHAEL R\", \"ppno\": \"2077537655\", \"cliId\": \"\", \"email\": \"benntammy@yahoo.com\", \"ename\": \"\", \"madd1\": \"852 DENMARK RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DENMARK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"12 HIGH ST,STE 302\", \"pcpnpi\": \"1831179803\", \"pcpzip\": \"42407634\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"NORTH BRIDGTON FAMILY PRACTICE AND WALK IN CLINIC\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077537656\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6C04X24PV05\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:00:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:07\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/8/2026 @ 12:55 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"4/7/2026 @ 04:10 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 04:12 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"3/31/2026 @ 01:51 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jennifer no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 01:24 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 02:28 PM\", \"result\": 3, \"comment\": \"03/23/2026- CALLED TO SCH -MPHP- VIRTUAL HRA W/ Amanda Milliken or Julie Cummings \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 04:44 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 03:07 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 10:51 AM\", \"result\": 3, \"comment\": \"called F2F appt with Sandy , no answer left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 07:10 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA- LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 11:41 AM\", \"result\": 1, \"comment\": \"Called to schedule HRA w/ Nicole Mattison DEAD AIR. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:33 PM\", \"result\": 3, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/11/2026 @ 01:31 PM\"}, {\"date\": \"2/9/2026 @ 01:26 PM\", \"result\": 3, \"comment\": \"Calling to schedule F2F w/Sandy 2/19/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/10/2026 @ 01:25 PM\"}, {\"date\": \"2/6/2026 @ 01:31 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 01:31 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 13:31:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"03-02-2026 19:10:52\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 15}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(2038, 57818338, 44829497, '39698290', '10000079345', '', '', '94743867', 'Virginia', 'Bickford', 'English', '', '{\"DOB\": 20086, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"\", \"PCP_NPI\": 1952622151, \"Pcp_Zip\": \"04101\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \" PORTLAND\", \"Pcp_Name\": \"ELIZABETH MOHAN\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9WX6E04YP68\", \"Member_City\": \"Westbrook\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WESTBROOK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-12-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"GERIATRIC MEDICINE\", \"Pcp_Address_1\": \"86 Marginal Way \", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"919 SPRING ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04092\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"919 SPRING ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04092\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bickford\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Virginia\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"lostmymarbles54@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2076503546, \"Member_Identification_Number\": \"10000079345\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-17-2026 16:08:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-17 16:08:43\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-06T14:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-11T23:50\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-16T10:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-16T13:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-17T16:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-12T18:54\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-10T13:46\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T14:46\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-12T18:54\", \"reportStatus_date\": \"2026-02-12T18:54\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-16T13:44\", \"reportStatus_date\": \"2026-03-16T13:44\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-17T16:08\", \"reportStatus_date\": \"2026-03-17T16:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-17T16:08\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-12T18:54\", \"username\": null}, {\"date\": \"2026-02-12T18:54\", \"username\": \"JDingle\"}], \"inProgress\": [{\"date\": \"2026-03-10T13:46\", \"username\": \"SCadwell\"}], \"qaAssigned\": [{\"date\": \"2026-03-12T10:33\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-11T23:50\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-11T23:50\", \"username\": \"SCadwell\"}, {\"date\": \"2026-03-13T18:52\", \"username\": \"SCadwell\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-16T13:44\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-16T10:23\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-16T13:44\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-03-13T11:40\", \"username\": \"JSilverio\"}, {\"date\": \"2026-03-13T18:52\", \"username\": \"SCadwell\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-10-2026\", \"time\": \"10:17:57\", \"value\": [{\"add\": \"919 SPRING ST\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-12-28\", \"eno\": \"2074671048\", \"lob\": \"GA - 2026\", \"pno\": 2076503546, \"zip\": \"04092\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Westbrook\", \"gend\": 1, \"insh\": \"10000079345\", \"mzip\": \"04092\", \"name\": \"Virginia C Bickford\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ELIZABETH MOHAN\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"lostmymarbles54@gmail.com\", \"ename\": \"Christopher Pare\", \"madd1\": \"919 SPRING ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WESTBROOK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"86 Marginal Way \", \"pcpnpi\": 1952622151, \"pcpzip\": \"04101\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \" PORTLAND\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9WX6E04YP68\", \"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\": \"03-06-2026\", \"time\": \"15:12:11\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 10:17:57\"}', NULL, NULL, '{\"memberId\": \"10000079345\", \"clinician\": \"Sandra Cadwell\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Fri, 13 Mar 2026 15:40:33 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sandra\\n1.  AOD gastro med list reports nausea please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 13 Mar 2026 22:52:47 GMT\", \"name\": \"Sandra \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"done\"}, \"mailId\": \"\"}], \"memberName\": \"Virginia Bickford\", \"codingAnalyst\": \"\", \"dateOfService\": \"03/10/2026 01:30 PM\", \"clinicianMailId\": \"s.cadwell@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/12/2026 @ 06:54 PM\", \"result\": 0, \"comment\": \"The member is scheduled w/Sandra Cadwell 3/10 at 130 PM.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 01:46 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual hra with MP nurse Nancy H; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 01:45 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000079345\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000079345\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000079345\", \"scheduleDate\": \"2026-3-10T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 13:46:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-12-2026 18:54:28\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2026-03-17 16:08:41\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"17bfc882-223d-11f1-b20f-2bd4b1055856\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2026-3-10T13:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:58', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079345\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Bickford_10000079345_03102026.pdf\", \"ftp_upload_date\": \"2026-03-17 16:08:40\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000079345.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Bickford_10000079345_03102026.pdf', NULL, 'Summary_10000079345.pdf', NULL, '[{\"date\": \"2026-03-12T03:50:50.306Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-13T22:51:41.137Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-13T22:51:55.749Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-13T22:52:07.862Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-13T22:52:23.990Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-13T22:52:37.190Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-10T14:30', 'Member_Summary_10000079345.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079345\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000079345.pdf\", \"member_ftp_upload_date\": \"2026-03-17 16:08:42\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(2039, NULL, NULL, NULL, '10000079355', '', '', '47262451', 'Alan', 'Smith', '', '', '{\"DOB\": 19924, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1972540110\", \"Pcp_Zip\": \"04614\", \"Program\": \"Medicare\", \"Pcp_City\": \"Blue Hill\", \"Pcp_Name\": \"MURNIK, MICHAEL G\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2H96TQ0KR51\", \"Member_City\": \"BROOKLIN\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE BLUE HILL\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BROOKLIN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-07-19\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Blue Hill Family Medicine,65 Water St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Hancock\", \"Member_Country\": \"Hancock\", \"PCP_Fax_Number\": \"2073743991\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"10 MAPLEBROOK LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04616\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"10 MAPLEBROOK LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04616\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Smith\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alan\", \"Member_Middle_name\": \"H\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073598895\", \"Member_Identification_Number\": \"10000079355\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-11-2026 16:56:25\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-11 16:56:25\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T16:11\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-11T16:56\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T11:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T15:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T18:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T16:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T15:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T18:52\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T16:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-11T16:56\", \"reportStatus_date\": \"2026-03-11T16:56\"}]', '{\"utc\": [{\"date\": \"2026-03-11T16:56\", \"username\": \"cwasilak\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:09\", \"value\": [{\"add\": \"10 MAPLEBROOK LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-07-19\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073598895\", \"zip\": \"04616\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BROOKLIN\", \"gend\": 0, \"insh\": \"10000079355\", \"mzip\": \"04616\", \"name\": \"Alan H Smith\", \"plan\": \"Martin\'s Point\", \"pphy\": \"MURNIK, MICHAEL G\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"10 MAPLEBROOK LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BROOKLIN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Blue Hill Family Medicine,65 Water St\", \"pcpnpi\": \"1972540110\", \"pcpzip\": \"04614\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Blue Hill\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE BLUE HILL\", \"program\": \"Medicare\", \"pcpfaxno\": \"2073743991\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2H96TQ0KR51\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:00:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:09\"}', '{\"utc\": [{\"date\": \"2026-03-11T16:56\", \"type\": null, \"subStaus\": \"\", \"username\": \"cwasilak\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/11/2026 @ 04:56 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Erin but member requested a call back. member returned call he said he would like to wait until later in year...just had checkup with PCP and is ok for now \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 04:42 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F/Virtual HRA with Erin no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 03:46 PM\", \"result\": 3, \"comment\": \"03/05/2026- CALLED TO SCH VIRTUAL HRA W/ERIN BAKER \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 04:11 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 06:52 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 11:28 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/12/2026 @ 11:28 AM\"}, {\"date\": \"2/9/2026 @ 03:26 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/12/2026 @ 03:26 PM\"}, {\"date\": \"2/6/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/9/2026 @ 11:46 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 11:47:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-24-2026 16:11:11\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(2040, 71932120, 44829497, '27743162', '10000079435', '', '', NULL, 'Robert', 'Mackinnon', 'English', '', '{\"DOB\": 19867, \"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\": 1093774119, \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"Anthony Bustamante\", \"Rank_All\": 1, \"PCP_Phone\": 2078469013, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8AJ8V88EN26\", \"Member_City\": \"YARMOUTH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"YARMOUTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1954-05-23\", \"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\": \"44 SMITH ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04096\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"44 SMITH ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04096\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mackinnon\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"N\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"rmackinn@maine.rr.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2072334252, \"Member_Identification_Number\": \"10000079435\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-03-2026 17:26:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:26:17\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-24T15:12\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-25T15:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-25T16:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-03T06:08\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-24T14:52\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-03T06:08\", \"reportStatus_date\": \"2026-02-03T06:08\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-25T16:49\", \"reportStatus_date\": \"2026-02-25T16:49\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:26\", \"reportStatus_date\": \"2026-03-03T17:26\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:26\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-03T06:08\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-24T14:52\", \"username\": \"SHafer\"}], \"qaAssigned\": [{\"date\": \"2026-02-24T22:20\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-02-24T15:12\", \"username\": \"SHafer\"}, {\"date\": \"2026-02-24T15:12\", \"username\": \"SHafer\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-25T16:49\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-25T15:28\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-25T16:49\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-19-2026\", \"time\": \"08:23:43\", \"value\": [{\"add\": \"44 SMITH ST\", \"age\": 71, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-05-23\", \"eno\": \"2074095502\", \"lob\": \"GA - 2026\", \"pno\": 2072334252, \"zip\": \"04096\", \"add2\": \"\", \"add3\": \"\", \"city\": \"YARMOUTH\", \"gend\": 0, \"insh\": \"10000079435\", \"mzip\": \"04096\", \"name\": \"Robert N Mackinnon\", \"plan\": \"Martin\'s Point\", \"pphy\": \"Anthony Bustamante\", \"ppno\": 2078469013, \"cliId\": \"\", \"email\": \"rmackinn@maine.rr.com\", \"ename\": \"Jane Oconor\", \"madd1\": \"44 SMITH ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"YARMOUTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"259 Main St\", \"pcpnpi\": 1093774119, \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": 2078741483, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8AJ8V88EN26\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"Male\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-23-2026\", \"time\": \"12:08:31\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-19-2026 08:23:43\"}', 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\": 10000079435, \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": 10000079435}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": 10000079435, \"scheduleDate\": \"2026-02-24T15:00:00.000\"}}', NULL, '{\"date\": \"01-31-2026 23:40:27\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, '[{\"date\": \"2026-03-03 17:26:16\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"06351e70-8da6-44df-91bf-ea65031c2cf5\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"06351e70-8da6-44df-91bf-ea65031c2cf5\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"12136034292\\\",\\\"destination_fax_number\\\":\\\"12078741483\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:44:45.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:26:29.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:40.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:29:54.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:31:04.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:33:27.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:34:45.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:36:59.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:38:06.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:40:11.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:41:25.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:43:29.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:44:45.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-02-24T15:00:00.000', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:59', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079435\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Mackinnon_10000079435_02242026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:26:15\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000079435.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Mackinnon_10000079435_02242026.pdf', NULL, 'Summary_10000079435.pdf', NULL, '[{\"date\": \"2026-02-24T20:12:02.087Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-24T15:11', 'Member_Summary_10000079435.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079435\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000079435.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:26:16\"}', 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
(2041, NULL, NULL, NULL, '10000079472', '', '', '52498339', 'Loretta', 'Ward', 'English', '', '{\"DOB\": 15413, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1477120590\", \"Pcp_Zip\": \"04011\", \"Program\": \"Medicare\", \"Pcp_City\": \"Brunswick\", \"Pcp_Name\": \"UDUEBOR, MIRIAM\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5M91WX8EP09\", \"Member_City\": \"Harpswell\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Harpswell\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1942-03-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,\\t114 Bath Rd\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2076267401\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"223 ASH POINT RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04079\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"223 ASH POINT RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04079\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Ward\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Loretta\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2078336325\", \"Member_Identification_Number\": \"10000079472\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-05-2026 12:12:14\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-05 12:12:14\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-26T15:29\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T19:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-19T12:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-05T12:12\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-09T14:48\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-26T15:29\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T14:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T12:36\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-26T15:29\", \"reportStatus_date\": \"2026-02-26T15:29\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-05T12:12\", \"reportStatus_date\": \"2026-03-05T12:12\"}]', '{\"utc\": [{\"date\": \"2026-02-26T15:29\", \"username\": \"KCoash\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-05T12:12\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:14\", \"value\": [{\"add\": \"223 ASH POINT RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1942-03-13\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078336325\", \"zip\": \"04079\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Harpswell\", \"gend\": 1, \"insh\": \"10000079472\", \"mzip\": \"04079\", \"name\": \"Loretta L Ward\", \"plan\": \"Martin\'s Point\", \"pphy\": \"UDUEBOR, MIRIAM\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"223 ASH POINT RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Harpswell\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,\\t114 Bath Rd\", \"pcpnpi\": \"1477120590\", \"pcpzip\": \"04011\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Brunswick\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076267401\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5M91WX8EP09\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:00:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:14\"}', '{\"utc\": [{\"date\": \"2026-02-26T15:29\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-05T12:12\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/5/2026 @ 12:12 PM\", \"result\": 9, \"comment\": \"Called to Schedule F2F HRA with Samuel but member refused. stated she was all set no further explantion  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 03:29 PM\", \"result\": 6, \"comment\": \"o/c to sched w/Sam 3/7 - member not home\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 12:36 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 02:48 PM\", \"result\": 14, \"comment\": \"F2F CALL BACK \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 02:47 PM\"}, {\"date\": \"2/4/2026 @ 07:19 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/5/2026 @ 07:18 PM\"}, {\"date\": \"2/3/2026 @ 02:16 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 19:19:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"01-31-2026 23:40:28\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2042, NULL, NULL, NULL, '10000079500', '', '', '543416', 'Sherilyn', 'Jordan', '', '', '{\"DOB\": 17880, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1194801993\", \"Pcp_Zip\": \"42633418\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"RIVARD, GARY S\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2RM8HW9AA40\", \"Member_City\": \"LEEDS\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LEEDS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1948-12-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"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\": \"109 BERNIE HARTFORD RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04263\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"109 BERNIE HARTFORD RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04263\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Jordan\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sherilyn\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@083122.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2079462473\", \"Member_Identification_Number\": \"10000079500\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-09-2026 15:18:51\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-09 15:18:51\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-09T15:18\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T15:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T17:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T14:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T15:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-03-09T15:18\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T15:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T17:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T14:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-09T15:18\", \"reportStatus_date\": \"2026-03-09T15:18\"}]', '{\"utc\": [{\"date\": \"2026-03-09T15:18\", \"username\": \"jsmith\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:15\", \"value\": [{\"add\": \"109 BERNIE HARTFORD RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1948-12-13\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2079462473\", \"zip\": \"04263\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LEEDS\", \"gend\": 1, \"insh\": \"10000079500\", \"mzip\": \"04263\", \"name\": \"Sherilyn M Jordan\", \"plan\": \"Martin\'s Point\", \"pphy\": \"RIVARD, GARY S\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"declined@083122.com\", \"ename\": \"\", \"madd1\": \"109 BERNIE HARTFORD RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LEEDS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD,STE 1\", \"pcpnpi\": \"1194801993\", \"pcpzip\": \"42633418\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076476015\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2RM8HW9AA40\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:00:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:15\"}', '{\"utc\": [{\"date\": \"2026-03-09T15:18\", \"type\": null, \"subStaus\": \"\", \"username\": \"jsmith\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/9/2026 @ 03:18 PM\", \"result\": 6, \"comment\": \"Called to schedule IHA w/ Samuel Acha- member not interested at this time states they see their PCP enough right now, stated we could give her a call back in june\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 03:55 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 02:11 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA w/Jennifer Winslow.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 05:41 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/17/2026 @ 05:40 PM\"}, {\"date\": \"2/6/2026 @ 03:24 PM\", \"result\": 3, \"comment\": \"02/06/2026- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/11/2026 @ 03:24 PM\"}, {\"date\": \"2/3/2026 @ 11:46 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa Scott\", \"callbackDate\": \"2/16/2026 @ 09:00 AM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 15:24:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"01-31-2026 23:40:28\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:00:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2043, NULL, NULL, NULL, '10000079646', '', '', NULL, 'David', 'Grimaldi', '', '', '{\"DOB\": 20268, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1720067317\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"PATCH, JEFFREY S\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2NC4JG8HU84\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-06-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"InterMed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"20 OVERVIEW DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"20 OVERVIEW DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Grimaldi\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dlgrimaldi55@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2072724348\", \"Member_Identification_Number\": \"10000079646\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:22:56\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:56\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:22\", \"reportStatus_date\": \"2026-02-03T06:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:20\", \"value\": [{\"add\": \"20 OVERVIEW DR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-06-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072724348\", \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 0, \"insh\": \"10000079646\", \"mzip\": \"04011\", \"name\": \"David L Grimaldi\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PATCH, JEFFREY S\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"dlgrimaldi55@gmail.com\", \"ename\": \"\", \"madd1\": \"20 OVERVIEW DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"InterMed,259 Main St\", \"pcpnpi\": \"1720067317\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2NC4JG8HU84\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:01:00\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:20\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/22/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:40:28\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:01:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(2044, 71932120, NULL, '52653458', '10000079661', '', '', '47262451', 'Gary', 'Richardson', 'English', '', '{\"DOB\": 20390, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1811559198\", \"Pcp_Zip\": \"04444\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Hampden\", \"Pcp_Name\": \"KIRKPATRICK, LARA M\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"6HG9WM8UR37\", \"Member_City\": \"DEXTER\", \"Office_Name\": \"NORTHERN LIGHT PRIMARY CARE HAMPDEN\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DEXTER\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-10-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Northern Light Primary Care Hampden,7 Main Rd N\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Penobscot\", \"Member_Country\": \"Penobscot\", \"PCP_Fax_Number\": \"3304534263\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"61 ACADIA STREET\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04930\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"61 ACADIA STREET\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04930\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Richardson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gary\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"grichardson2855@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"01-01-1900\", \"Member_Primary_Phone_Number\": \"2072701435\", \"Member_Identification_Number\": \"10000079661\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":8,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-16-2026 19:28:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 19:26:32\", \"hrastatus\": 8, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-16T19:28\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-06T17:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-13T14:13\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-06T17:24\", \"reportStatus_date\": \"2026-02-06T17:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T19:28\", \"reportStatus_date\": \"2026-02-16T19:28\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2026-02-17T19:48\", \"reportStatus_date\": null}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2026-03-03T19:26\", \"reportStatus_date\": null}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-06T17:24\", \"username\": null}, {\"date\": \"2026-02-06T17:24\", \"username\": \"LAnguiano\"}], \"inProgress\": [{\"date\": \"2026-02-13T14:13\", \"username\": \"NHoneychuck\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:53\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-16T19:28\", \"username\": \"NHoneychuck\"}, {\"date\": \"2026-02-16T19:28\", \"username\": \"NHoneychuck\"}, {\"date\": \"2026-02-17T19:41\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-17T19:44\", \"username\": \"MJoseph\"}, {\"date\": \"2026-02-17T19:47\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-03T15:49\", \"username\": \"NHoneychuck\"}, {\"date\": \"2026-03-03T19:24\", \"username\": \"MJoseph\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [{\"date\": \"2026-02-17T19:48\", \"username\": \"MJoseph\"}, {\"date\": \"2026-03-03T19:26\", \"username\": \"MJoseph\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"02-16-2026\", \"time\": \"18:24:45\", \"value\": [{\"add\": \"61 ACADIA STREET\", \"age\": 70, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-10-28\", \"eno\": \"\", \"lob\": \"GA - 2026\", \"pno\": \"2072701435\", \"zip\": \"04930\", \"add2\": \"\", \"add3\": \"\", \"city\": \"DEXTER\", \"gend\": 0, \"insh\": \"10000079661\", \"mzip\": \"04930\", \"name\": \"Gary Richardson\", \"plan\": \"Martin’s Point\", \"pphy\": \"KIRKPATRICK, LARA M\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"grichardson2855@gmail.com\", \"ename\": \"\", \"madd1\": \"61 ACADIA STREET\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DEXTER\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Northern Light Primary Care Hampden,7 Main Rd N\", \"pcpnpi\": \"1811559198\", \"pcpzip\": \"04444\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Hampden\", \"pcpname\": \"NORTHERN LIGHT PRIMARY CARE HAMPDEN\", \"program\": \"Medicare\", \"pcpfaxno\": \"3304534263\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"Penobscot\", \"medicaidid\": \"\", \"medicareid\": \"6HG9WM8UR37\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-10-2026\", \"time\": \"16:41:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-03-2026 15:49:42\"}', NULL, NULL, '{\"memberId\": \"10000079661\", \"clinician\": \"Nancy Honeychuck\", \"qaAnalyst\": \"Manoucheca Joseph\", \"queryData\": [{\"date\": \"Wed, 18 Feb 2026 00:48:45 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Nancy,\\n\\n1. Please add the diagnoses, dose, frequency, and status of each medication (please remove any inactive medications).\\n2. The member is on Eliquis, however, there was no condition addressed in the assessment of diagnosis cardiovascular section. Please clarify.\\n3. The member is on Escitalopram, however, there was no condition addressed in the assessment of diagnosis neuro psych section. Is this an active ongoing condition? Please clarify.\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 03 Mar 2026 20:49:42 GMT\", \"name\": \"Nancy \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 04 Mar 2026 00:26:32 GMT\", \"name\": \"Manoucheca \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Nancy,\\n\\nThank you for updating the HRA.\\n\\n1. The member is on the medication for HTN. However, the condition was not addressed in the assessment of diagnosis cardiovascular section. Is this an active ongoing condition?\\n\\nThank you,\\nManoucheca\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Gary Richardson\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/13/2026 01:30 PM\", \"clinicianMailId\": \"n.honeychuck@focuscares.com\", \"qaAnalystMailId\": \"m.joseph@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/6/2026 @ 05:24 PM\", \"result\": 0, \"comment\": \"Member scheduled with Nancy 2-13-2026 130pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"2/3/2026 @ 10:42 AM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": 10000079661, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"52653458\", \"memberId\": 10000079661}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"52653458\", \"memberId\": 10000079661, \"scheduleDate\": \"2026-02-13T13:30:00.000\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 17:24:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"02-06-2026 17:24:03\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, NULL, 'Virtual', '2026-2-13T13:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:01:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"date\": \"2026-02-17T00:28:04.236Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-03-03T20:49:42.620Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-13T14:40', NULL, NULL, 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
(2045, NULL, NULL, NULL, '10000079736', '', '', '52197563', 'Debra', 'Sheerer', 'English', '', '{\"DOB\": 20380, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1891189288\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"BAIER, ROBIN\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"9XH2K02CW21\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-10-18\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"28 GROVER LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"28 GROVER LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Sheerer\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Debra\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077290479\", \"Member_Identification_Number\": \"10000079736\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-14-2026 14:28:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-14 14:28:01\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-26T15:22\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-14T14:28\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-09T14:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T12:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T12:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-19T11:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:21\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2026-02-26T15:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T14:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T12:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-19T11:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-02-26T15:22\", \"reportStatus_date\": \"2026-02-26T15:22\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-03-14T14:28\", \"reportStatus_date\": \"2026-03-14T14:28\"}]', '{\"utc\": [{\"date\": \"2026-02-26T15:22\", \"username\": \"KCoash\"}, {\"date\": \"2026-03-14T14:28\", \"username\": \"KAtobatele\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:24\", \"value\": [{\"add\": \"28 GROVER LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-10-18\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077290479\", \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 1, \"insh\": \"10000079736\", \"mzip\": \"04011\", \"name\": \"Debra A Sheerer\", \"plan\": \"Martin\'s Point\", \"pphy\": \"BAIER, ROBIN\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"28 GROVER LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1891189288\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"9XH2K02CW21\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:01:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:24\"}', '{\"utc\": [{\"date\": \"2026-02-26T15:22\", \"type\": null, \"subStaus\": \"\", \"username\": \"KCoash\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2026-03-14T14:28\", \"type\": null, \"subStaus\": \"\", \"username\": \"KAtobatele\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"3/14/2026 @ 02:28 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual with Amanda, call back in months\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 03:22 PM\", \"result\": 6, \"comment\": \"Per five9 record 2/18/26 member wants c/b in April\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 11:09 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison LVM. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 12:21 PM\", \"result\": 3, \"comment\": \"LVM F2F JESS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 12:21 PM\"}, {\"date\": \"2/10/2026 @ 12:02 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.u00a0 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 12:01 PM\"}, {\"date\": \"2/9/2026 @ 02:48 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 02:48 PM\"}, {\"date\": \"1/27/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 14:48:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"01-31-2026 23:40:29\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:01:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(2046, NULL, NULL, NULL, '10000079766', '', '', NULL, 'Robert', 'Brown Jr', 'English', '', '{\"DOB\": 22416, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1619918307\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"PHAN, ANDREW T\", \"Rank_All\": 1, \"PCP_Phone\": \"2078282402\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3K90DR8EA28\", \"Member_City\": \"Buxton\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buxton\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1961-05-15\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"26 CEMETERY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04093\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"26 CEMETERY RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04093\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Brown Jr\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"declined@02112021.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\": \"2072396793\", \"Member_Identification_Number\": \"10000079766\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-03-2026 06:22:56\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-03 06:22:56\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-03T06:22\", \"reportStatus_date\": \"2026-02-03T06:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:23:24\", \"value\": [{\"add\": \"26 CEMETERY RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-05-15\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2072396793\", \"zip\": \"04093\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Buxton\", \"gend\": 0, \"insh\": \"10000079766\", \"mzip\": \"04093\", \"name\": \"Robert D Brown Jr\", \"plan\": \"Martin\'s Point\", \"pphy\": \"PHAN, ANDREW T\", \"ppno\": \"2078282402\", \"cliId\": \"\", \"email\": \"declined@02112021.com\", \"ename\": \"\", \"madd1\": \"26 CEMETERY RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buxton\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1619918307\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3K90DR8EA28\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"10:01:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:23:24\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-03T06:22\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', NULL, '{\"date\": \"01-31-2026 23:40:29\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:01:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
INSERT INTO `HRA_member_client_014_2026` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `language`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`, `jsonYear`, `statusForRef`, `ncqa`) VALUES
(2047, 62035418, 44829497, '17537038', '10000079768', '', '', NULL, 'Daniel', 'Pooler', 'English', '', '{\"DOB\": 20406, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Busy. The destination number was busy.\", \"Aligned\": \"\", \"PCP_NPI\": \"1598086241\", \"Pcp_Zip\": \"03820\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"DOVER\", \"Pcp_Name\": \"AMANDA IANTOSCA\", \"Rank_All\": 1, \"PCP_Phone\": \"2073772111\", \"Pcp_State\": \"NH\", \"Medicare_ID\": \"6W30UG5DM11\", \"Member_City\": \"Waterville\", \"Office_Name\": \"WINTHROP FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Waterville\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1955-11-13\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"789 CENTRAL AVE\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Kennebec\", \"Member_Country\": \"Kennebec\", \"PCP_Fax_Number\": \"2076243845\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"70 FRANCIS ST APT 1\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04901\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"70 FRANCIS ST APT 1\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04901\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Pooler\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Daniel\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"dbpooler@yahoo.com\", \"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\": \"2076496791\", \"Member_Identification_Number\": \"10000079768\", \"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:26:22\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:26:22\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-13T15:41\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T21:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-18T00:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-03T06:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-13T15:01\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-03T06:09\", \"reportStatus_date\": \"2026-02-03T06:09\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-13T15:41\", \"reportStatus_date\": \"2026-02-13T15:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-18T00:41\", \"reportStatus_date\": \"2026-02-18T00:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:26\", \"reportStatus_date\": \"2026-03-03T17:26\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:26\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-03T06:09\", \"username\": null}], \"inProgress\": [{\"date\": \"2026-02-13T15:01\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-17T13:55\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-13T15:41\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-13T15:41\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-18T00:41\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T21:14\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-18T00:41\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-19-2026\", \"time\": \"08:54:34\", \"value\": [{\"add\": \"70 FRANCIS ST APT 1\", \"age\": 70, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1955-11-13\", \"eno\": \"2075120469\", \"lob\": \"GA - 2026\", \"pno\": \"2076496791\", \"zip\": \"04901\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Waterville\", \"gend\": 0, \"insh\": \"10000079768\", \"mzip\": \"04901\", \"name\": \"Daniel B Pooler\", \"plan\": \"Martin\'s Point\", \"pphy\": \"AMANDA IANTOSCA\", \"ppno\": \"2073772111\", \"cliId\": \"\", \"email\": \"dbpooler@yahoo.com\", \"ename\": \"Shawn Pooler - son\", \"madd1\": \"70 FRANCIS ST APT 1\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Waterville\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"789 CENTRAL AVE\", \"pcpnpi\": \"1598086241\", \"pcpzip\": \"03820\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": \"\", \"pcpcity\": \"DOVER\", \"pcpname\": \"WINTHROP FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2076243845\", \"pcpstate\": \"NH\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"6W30UG5DM11\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-10-2026\", \"time\": \"16:22:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-19-2026 08:54: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\": 10000079768, \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": 10000079768}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": 10000079768, \"scheduleDate\": \"2026-02-13T15:00:00.000\"}}', NULL, '{\"date\": \"01-31-2026 23:40:29\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, '[{\"date\": \"2026-03-03 17:26:21\", \"status\": 0, \"message\": \"Busy. The destination number was busy.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"3b363084-e07c-4915-9a39-c1aeb213849e\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"3b363084-e07c-4915-9a39-c1aeb213849e\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367160\\\",\\\"destination_fax_number\\\":\\\"12076243845\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:40:11.005+0000\\\",\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\",\\\"total_pages_sent\\\":0,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":5,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":0,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:26:42.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:08.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":2,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:29:15.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:29:42.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":3,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:31:51.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:32:14.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":4,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:34:33.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:34:54.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":5,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:37:09.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:37:39.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"},{\\\"attempt_number\\\":6,\\\"attempt_status\\\":\\\"ERROR\\\",\\\"duration\\\":0,\\\"start_timestamp\\\":\\\"2026-03-03T22:39:41.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:40:11.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E41\\\",\\\"error_message\\\":\\\"Busy. The destination number was busy.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-02-13T15:00:00.000', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 10:01:02', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079768\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Pooler_10000079768_02132026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:26:20\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000079768.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Pooler_10000079768_02132026.pdf', NULL, 'Summary_10000079768.pdf', NULL, '[{\"date\": \"2026-02-13T20:41:51.903Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-13T15:40', 'Member_Summary_10000079768.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000079768\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000079768.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:26:21\"}', NULL, NULL, NULL, '01-01-1900', '2025', '0', '0');
