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
(1595, 93442164, 44829497, '27743162', '10000059299', '', '', '94743867', 'Carolyn', 'Southwick', 'English', '', '{\"DOB\": 18970, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Successful fax\", \"Aligned\": \"\", \"PCP_NPI\": 1952890485, \"Pcp_Zip\": \"04106\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"South Portland\", \"Pcp_Name\": \"KARYN KING\", \"Rank_All\": 1, \"PCP_Phone\": 2078741489, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"8CD9XE3TK58\", \"Member_City\": \"BIDDEFORD\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BIDDEFORD\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-12-08\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"100 Foden Rd Ste 203\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": 2075238590, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"16 CONGRESS ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"16 CONGRESS ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Southwick\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carolyn\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"winepower@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\": \"Yes\", \"Member_Primary_Phone_Number\": 2072845149, \"Member_Identification_Number\": \"10000059299\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2072293016}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-10-2026 14:30:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-10 14:30:50\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-09T11:04\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-09T18:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-09T19:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-10T14:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-06T18:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-06T19:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-09T10:33\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2026-02-06T19:30\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-06T19:31\", \"reportStatus_date\": \"2026-02-06T19:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-09T19:10\", \"reportStatus_date\": \"2026-03-09T19:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-10T14:30\", \"reportStatus_date\": \"2026-03-10T14:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-10T14:30\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-06T18:07\", \"username\": null}, {\"date\": \"2026-02-06T18:07\", \"username\": \"LRivera\"}, {\"date\": \"2026-02-06T19:31\", \"username\": null}, {\"date\": \"2026-02-06T19:31\", \"username\": \"LRivera\"}], \"inProgress\": [{\"date\": \"2026-03-09T10:33\", \"username\": \"SHafer\"}], \"qaAssigned\": [{\"date\": \"2026-03-09T15:06\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-09T11:04\", \"username\": \"SHafer\"}, {\"date\": \"2026-03-09T11:04\", \"username\": \"SHafer\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-09T19:10\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-09T18:49\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-09T19:10\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-06T19:30\", \"username\": \"LRivera\"}], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-23-2026\", \"time\": \"11:28:30\", \"value\": [{\"add\": \"16 CONGRESS ST\", \"age\": 74, \"ano\": \"\", \"cno\": 2072293016, \"dob\": \"1951-12-08\", \"eno\": \"2072291544\", \"lob\": \"GA - 2026\", \"pno\": 2072845149, \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BIDDEFORD\", \"gend\": 1, \"insh\": \"10000059299\", \"mzip\": \"04005\", \"name\": \"Carolyn M Southwick\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KARYN KING\", \"ppno\": 2078741489, \"race\": \"\", \"cliId\": \"\", \"email\": \"winepower@maine.rr.com\", \"ename\": \"Bill Southwick\", \"madd1\": \"16 CONGRESS ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BIDDEFORD\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"100 Foden Rd Ste 203\", \"pcpnpi\": 1952890485, \"pcpzip\": \"04106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"South Portland\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"evalDate\": \"2026-3-9 10:30 AM\", \"evalName\": \"Shellie Hafer, NP\", \"pcpfaxno\": 2075238590, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"8CD9XE3TK58\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"Female \"}, {\"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:33:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-23-2026 11:28:30\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2026-02-06T19:30\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"LRivera\", \"hraStatus\": 3, \"cancelText\": \"Wrong provider; should be Shellie Hafer.\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/6/2026 @ 06:31 PM\", \"result\": 0, \"comment\": \"Scheduled f2f hra with Shellie H - 3/9 at 10:30am; one very old dog; park in the driveway; email conf to winepower@maine.rr.com\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 05:07 PM\", \"result\": 0, \"comment\": \"Called to schedule virtual hra with MP nurse Nancy H; Sandy C - 3/9 at 10:30am; one very old dog; park in the driveway; email conf to winepower@maine.rr.com\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000059299\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"27743162\", \"memberId\": \"10000059299\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"27743162\", \"memberId\": \"10000059299\", \"scheduleDate\": \"2026-3-9T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 17:07:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}, {\"date\": \"02-06-2026 19:30:45\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-06-2026 19:31:40\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-03-10 14:30:49\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e8178c01-6fdb-4176-af97-9b09be624f2f\\\",\\\"destination_fax_number\\\":\\\"12075238590\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"e8178c01-6fdb-4176-af97-9b09be624f2f\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"13054023144\\\",\\\"destination_fax_number\\\":\\\"12075238590\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"2075238590\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:36:06.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":277,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":277,\\\"start_timestamp\\\":\\\"2026-03-10T18:31:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-10T18:36:06.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'In Person', '2026-3-9T10:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:24', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059299\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Home_Southwick_10000059299_03092026.pdf\", \"ftp_upload_date\": \"2026-03-10 14:30:48\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059299.pdf\"}', 'Martin\'s Point_GA - 2026_Home_Southwick_10000059299_03092026.pdf', NULL, 'Summary_10000059299.pdf', NULL, '[{\"date\": \"2026-03-09T15:04:21.740Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-09T11:04', 'Member_Summary_10000059299.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059299\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059299.pdf\", \"member_ftp_upload_date\": \"2026-03-10 14:30:49\"}', 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
(1596, NULL, NULL, NULL, '10000059345', '', '', '14035267', 'Eleanor', 'Vigue', '', '', '{\"DOB\": 13079, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1093774119\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"AIKEN, DOUGLAS\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2AJ6AQ2EP66\", \"Member_City\": \"YARMOUTH\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"YARMOUTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1935-10-22\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Intermed,259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078741483\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"238 SEA MEADOWS LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04096\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"238 SEA MEADOWS LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04096\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Vigue\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Eleanor\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 44927, \"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\": \"2078464941\", \"Member_Identification_Number\": \"10000059345\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-25-2026 16:43:16\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-25 16:43:16\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-25T16:43\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-06T14:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-23T16:11\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T14:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T11:15\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T16:11\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-25T16:43\", \"reportStatus_date\": \"2026-02-25T16:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-25T16:43\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:38\", \"value\": [{\"add\": \"238 SEA MEADOWS LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1935-10-22\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078464941\", \"zip\": \"04096\", \"add2\": \"\", \"add3\": \"\", \"city\": \"YARMOUTH\", \"gend\": 1, \"insh\": \"10000059345\", \"mzip\": \"04096\", \"name\": \"Eleanor E Vigue\", \"plan\": \"Martin\'s Point\", \"pphy\": \"AIKEN, DOUGLAS\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"238 SEA MEADOWS LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"YARMOUTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Intermed,259 Main St\", \"pcpnpi\": \"1093774119\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078741483\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2AJ6AQ2EP66\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:38\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-25T16:43\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/25/2026 @ 04:43 PM\", \"result\": 9, \"comment\": \"Called to Schedule F2F HRA with Samuel but member refused. is aware of the benifit but want to stick with there doctor  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 04:11 PM\", \"result\": 6, \"comment\": \"The member did not answer. The person who answered indicated that she is resting and requesting a callback at a later time.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/24/2026 @ 12:10 PM\"}, {\"date\": \"2/10/2026 @ 11:15 AM\", \"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 @ 11:14 AM\"}, {\"date\": \"2/6/2026 @ 11:59 AM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/20/2026 @ 11:59 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-06-2026 11:59:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"01-31-2026 23:38:06\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1597, NULL, NULL, NULL, '10000059419', '', '', '94743867', 'Brian', 'Woodman', 'English', '', '{\"DOB\": 19295, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1659865970\", \"Pcp_Zip\": \"04103\", \"Program\": \"Medicare\", \"Pcp_City\": \"Portland\", \"Pcp_Name\": \"FLORY, ELIZABETH\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2TY0MF6DY37\", \"Member_City\": \"FALMOUTH\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"FALMOUTH\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-10-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,331 Veranda St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2077984018\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"136 MIDDLE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04105\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"136 MIDDLE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04105\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Woodman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brian\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"wood@maine.rr.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\": \"2077812834\", \"Member_Identification_Number\": \"10000059419\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073295370\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-06-2026 13:25:38\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-06 13:25:38\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-10T11:54\", \"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-04T18:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T17:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T12:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-06T13:25\", \"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\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T12:39\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-10T11:54\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-06T13:25\", \"reportStatus_date\": \"2026-03-06T13:25\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-06T13:25\", \"username\": \"LAnguiano\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:39\", \"value\": [{\"add\": \"136 MIDDLE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2073295370\", \"dob\": \"1952-10-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077812834\", \"zip\": \"04105\", \"add2\": \"\", \"add3\": \"\", \"city\": \"FALMOUTH\", \"gend\": 0, \"insh\": \"10000059419\", \"mzip\": \"04105\", \"name\": \"Brian L Woodman\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FLORY, ELIZABETH\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"wood@maine.rr.com\", \"ename\": \"\", \"madd1\": \"136 MIDDLE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"FALMOUTH\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,331 Veranda St\", \"pcpnpi\": \"1659865970\", \"pcpzip\": \"04103\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Portland\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077984018\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2TY0MF6DY37\", \"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\": \"09:58:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:39\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-06T13:25\", \"type\": null, \"subStaus\": \"\", \"username\": \"LAnguiano\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/6/2026 @ 01:25 PM\", \"result\": 9, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- refusal \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 01:23 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 11:47 AM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 02:59 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 10:12 AM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/19/2026 @ 02:18 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 03:26 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 03:21 PM\", \"result\": 3, \"comment\": \"o/c to sched IHA w/Sandy 3/10\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 11:43 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 11:34 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Sandra no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 08:54 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 09:39 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 09:20 AM\", \"result\": 3, \"comment\": \" called to schedule face to face appt with Jessica D\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/11/2026 @ 09:20 AM\"}, {\"date\": \"2/5/2026 @ 05:45 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 05:45 PM\"}, {\"date\": \"2/4/2026 @ 05:45 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; Left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 05:44 PM\"}, {\"date\": \"2/3/2026 @ 01:08 PM\", \"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-04-2026 17:45:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-10-2026 11:54:27\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 17}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1598, NULL, NULL, NULL, '10000059425', '', '', '52197563', 'Catherine', 'Atkins', 'English', '', '{\"DOB\": 18776, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1386603397\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"TRAPP, KATHLEEN R\", \"Rank_All\": 1, \"PCP_Phone\": \"2077984400\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2RJ4WE2NW63\", \"Member_City\": \"BRUNSWICK\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BRUNSWICK\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-05-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"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\": \"22 FRANKLIN ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04011\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 595\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04011\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Atkins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Catherine\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"catherinefrances1@ymail.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\": \"\", \"Member_Identification_Number\": \"10000059425\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2077025022\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-16-2026 17:20:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-03-16 17:20:49\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-26T16:13\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-16T17:20\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T10:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-20T14:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-25T16:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T16:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-10T14:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T10:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-20T14:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T16:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-16T17:20\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:40\", \"value\": [{\"add\": \"22 FRANKLIN ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"2077025022\", \"dob\": \"1951-05-28\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077025022\", \"zip\": \"04011\", \"add2\": \"\", \"add3\": \"\", \"city\": \"BRUNSWICK\", \"gend\": 1, \"insh\": \"10000059425\", \"mzip\": \"04011\", \"name\": \"Catherine F Atkins\", \"plan\": \"Martin\'s Point\", \"pphy\": \"TRAPP, KATHLEEN R\", \"ppno\": \"2077984400\", \"cliId\": \"\", \"email\": \"catherinefrances1@ymail.com\", \"ename\": \"\", \"madd1\": \"PO BOX 595\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BRUNSWICK\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1386603397\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2RJ4WE2NW63\", \"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\": \"09:58:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 10:10 AM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 03:31 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/2/2026 @ 07:14 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 02:04 PM\", \"result\": 13, \"comment\": \"Called to schedule F2F W/Sandra Cadwell. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 03:22 PM\", \"result\": 7, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Sandy- Line busy \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 02:40 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Pamela no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 05:20 PM\", \"result\": 3, \"comment\": \"Called to F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/11/2026 @ 05:20 PM\", \"result\": 10, \"comment\": \"Called to Schedule F2F/Virtual HRA with Erin number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 11:17 AM\", \"result\": 10, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 02:09 PM\", \"result\": 10, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/2/2026 @ 02:19 PM\", \"result\": 10, \"comment\": \"DISCONNECTED F2F\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 04:13 PM\", \"result\": 13, \"comment\": \"o/c to sched w/Sam 3/7\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 04:40 PM\", \"result\": 13, \"comment\": \"Called to Schedule F2F HRA with Samuel caller disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"2/20/2026 @ 02:29 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Samuel no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/24/2026 @ 02:29 PM\"}, {\"date\": \"2/12/2026 @ 10:59 AM\", \"result\": 3, \"comment\": \"NO VM SETUP F2F JESS \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 10:58 AM\"}, {\"date\": \"2/10/2026 @ 02:59 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"2/13/2026 @ 02:59 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-10-2026 14:59:00\", \"schedulerId\": \"52197563\", \"schedulerLeadId\": \"52197563\"}]}', '{\"date\": \"03-16-2026 17:20:49\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 17}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:25', 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
(1599, 62035418, 44829497, '17537038', '10000059452', '', '', '94743867', 'Linda', 'Hollander', 'English', '', '{\"DOB\": 16518, \"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\": \"1306229521\", \"Pcp_Zip\": \"04096\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Yarmouth\", \"Pcp_Name\": \"ANTHONY BUSTAMANTE\", \"Rank_All\": 1, \"PCP_Phone\": \"2078469013\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"2UA3VP8TN19\", \"Member_City\": \"Falmouth\", \"Office_Name\": \"INTERMED\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Falmouth\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1945-03-22\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"259 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2075238586\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"100 CLEARWATER DR APT 169\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04105\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"100 CLEARWATER DR APT 169\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04105\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Hollander\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Linda\", \"Member_Middle_name\": \"I\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"linda5051@aol.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\": \"2076504583\", \"Member_Identification_Number\": \"10000059452\", \"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:24:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-03 17:24:31\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-10T11:57\", \"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-04T18:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T17:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T12:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T12:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T11:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-03T17:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-02-11T16:35\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-02-17T16:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-02-17T18:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-03T17:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-10T12:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-11T14:57\", \"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-09T12:44\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-02-16T07:57\", \"reportStatus_date\": \"2026-02-11T16:35\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-02-17T18:02\", \"reportStatus_date\": \"2026-02-17T18:02\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-03T17:24\", \"reportStatus_date\": \"2026-03-03T17:24\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-03T17:24\", \"username\": \"TOdleAdmin\"}], \"scheduled\": [{\"date\": \"2026-02-10T12:09\", \"username\": null}, {\"date\": \"2026-02-10T12:09\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-02-11T14:57\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-02-12T10:22\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-02-11T16:35\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-11T16:35\", \"username\": \"AMilliken\"}, {\"date\": \"2026-02-16T07:57\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-02-17T18:02\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-02-17T16:39\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-02-17T18:02\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2026-02-15T14:32\", \"username\": \"NSchaaf\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-18-2026\", \"time\": \"15:38:19\", \"value\": [{\"add\": \"100 CLEARWATER DR APT 169\", \"age\": 80, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1945-03-22\", \"eno\": \"5082326332\", \"lob\": \"GA - 2026\", \"pno\": \"2076504583\", \"zip\": \"04105\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Falmouth\", \"gend\": 1, \"insh\": \"10000059452\", \"mzip\": \"04105\", \"name\": \"Linda I Hollander\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ANTHONY BUSTAMANTE\", \"ppno\": \"2078469013\", \"cliId\": \"\", \"email\": \"linda5051@aol.com\", \"ename\": \"Emma Hollander\", \"madd1\": \"100 CLEARWATER DR APT 169\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Falmouth\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"259 Main St\", \"pcpnpi\": \"1306229521\", \"pcpzip\": \"04096\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Divorced\", \"pcpFlag\": \"\", \"pcpcity\": \"Yarmouth\", \"pcpname\": \"INTERMED\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075238586\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"2UA3VP8TN19\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-11-2026\", \"time\": \"09:59:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-18-2026 15:38:19\"}', NULL, NULL, '{\"memberId\": \"10000059452\", \"clinician\": \"Amanda Milliken\", \"qaAnalyst\": \"Natalie Schaaf\", \"queryData\": [{\"date\": \"Sun, 15 Feb 2026 19:32:46 GMT\", \"name\": \"Natalie \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Amanda,\\n\\n1) since patient is taking medication for thyroid please add to endocrine assessment of diagnosis\\nwith supported by boxes selected as well\\n\\nthank you! \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 16 Feb 2026 12:57:12 GMT\", \"name\": \"Amanda \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"completed. thank you\"}, \"mailId\": \"\"}], \"memberName\": \"Linda Hollander\", \"codingAnalyst\": \"\", \"dateOfService\": \"02/11/2026 03:00 PM\", \"clinicianMailId\": \"a.milliken@focuscares.com\", \"qaAnalystMailId\": \"n.schaaf@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": \"0\", \"callLog\": [{\"date\": \"2/10/2026 @ 09:09 AM\", \"result\": 0, \"comment\": \"scheduled virtual appt with Amanda on 2/11/2026 at 3 pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 08:57 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 09:44 AM\", \"result\": 3, \"comment\": \" called to schedule virtual appt with Amanda M,left vm \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 09:22 AM\", \"result\": 3, \"comment\": \" called to schedule face to face appt with Jessica D\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/11/2026 @ 09:22 AM\"}, {\"date\": \"2/5/2026 @ 05:47 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 05:46 PM\"}, {\"date\": \"2/4/2026 @ 05:46 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP NP Shellie H 2/10; Left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/6/2026 @ 05:46 PM\"}, {\"date\": \"2/3/2026 @ 11:42 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\": {\"type\": \"visitType\", \"memberId\": \"10000059452\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000059452\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000059452\", \"scheduleDate\": \"2026-2-11T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 17:46:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"02-10-2026 12:09:52\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 0, NULL, '[{\"date\": \"2026-03-03 17:24:29\", \"status\": 0, \"message\": \"Transmission error.\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"b615ee32-1e39-4943-8430-4111016fd5ef\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"b615ee32-1e39-4943-8430-4111016fd5ef\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12075238586\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"\\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"ERROR\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:37:44.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:25:12.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:25:27.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:27:39.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:27:49.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:30:03.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:30:16.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:32:26.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:32:38.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:35:00.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:35:10.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:37:29.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-03-03T22:37:44.005+0000\\\",\\\"pages_sent\\\":0,\\\"error_code\\\":\\\"E49\\\",\\\"error_message\\\":\\\"Transmission error.\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-2-11T15:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:25', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059452\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Hollander_10000059452_02112026.pdf\", \"ftp_upload_date\": \"2026-03-03 17:24:28\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059452.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Hollander_10000059452_02112026.pdf', NULL, 'Summary_10000059452.pdf', NULL, '[{\"date\": \"2026-02-11T21:35:07.706Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}, {\"date\": \"2026-02-16T12:57:12.327Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-02-11T16:34', 'Member_Summary_10000059452.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059452\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059452.pdf\", \"member_ftp_upload_date\": \"2026-03-03 17:24:30\"}', 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
(1600, NULL, NULL, '39698290', '10000059492', '', '', '1019044', 'Catherine', 'Wessel', '', '', '{\"DOB\": 19395, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1548293772\", \"Pcp_Zip\": \"41013776\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"STOCKWELL, GEORGE W\", \"Rank_All\": 1, \"PCP_Phone\": \"2078930290\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3DK7FG7UT61\", \"Member_City\": \"WINDHAM\", \"Office_Name\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"WINDHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-02-05\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"144 STATE ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2078930295\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"482 FALMOUTH RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04062\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"482 FALMOUTH RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04062\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Wessel\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Catherine\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"Cwessel47@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\": \"2078920121\", \"Member_Identification_Number\": \"10000059492\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":1,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-11-2026 13:45:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}', '{\"date\": \"2026-02-11 13:45:29\", \"hrastatus\": \"\", \"reportstatus\": \"Scheduled\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-06T17:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-10T11:22\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-02-11T13:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-06T17:07\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T17:10\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-11T13:45\", \"reportStatus_date\": \"2026-02-11T13:45\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-02-10T11:22\", \"username\": null}, {\"date\": \"2026-02-10T11:22\", \"username\": \"KCoash\"}, {\"date\": \"2026-02-11T13:45\", \"username\": null}, {\"date\": \"2026-02-11T13:45\", \"username\": \"admin\"}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-10-2026\", \"time\": \"17:38:13\", \"value\": [{\"add\": \"482 FALMOUTH RD\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-02-05\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2078920121\", \"zip\": \"04062\", \"add2\": \"\", \"add3\": \"\", \"city\": \"WINDHAM\", \"gend\": 1, \"insh\": \"10000059492\", \"mzip\": \"04062\", \"name\": \"Catherine T Wessel\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STOCKWELL, GEORGE W\", \"ppno\": \"2078930290\", \"cliId\": \"\", \"email\": \"Cwessel47@gmail.com\", \"ename\": \"\", \"madd1\": \"482 FALMOUTH RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"WINDHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"144 STATE ST,\", \"pcpnpi\": \"1548293772\", \"pcpzip\": \"41013776\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"PORTLAND\", \"pcpname\": \"NORTHERN LIGHT MERCY HEALTH CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078930295\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3DK7FG7UT61\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [false, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"04-10-2026\", \"time\": \"17:38:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-10-2026 17:39:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"2/11/2026 @ 01:45 PM\", \"result\": 0, \"comment\": \"SCHEDULED \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 11:22 AM\", \"result\": 0, \"comment\": \"Sched 3/9 at 12 pm w/Sandy\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 05:07 PM\", \"result\": 6, \"comment\": \"Called to Schedule F2F HRA with Erin but member requested a call back. in a couple of weeks not happy that benefits was cut  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"2/18/2026 @ 05:07 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000059492\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"39698290\", \"memberId\": \"10000059492\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"39698290\", \"memberId\": \"10000059492\", \"scheduleDate\": \"2026-4-13T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-06-2026 17:07:00\", \"schedulerId\": \"1019044\", \"schedulerLeadId\": \"1019044\"}]}', '{\"date\": \"02-11-2026 13:45:29\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, NULL, 'In Person', '2026-4-13T09:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1601, NULL, NULL, NULL, '10000059589', '', '', '52661009', 'George', 'Bell', '', '', '{\"DOB\": 18739, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1174519235\", \"Pcp_Zip\": \"04072\", \"Program\": \"Medicare\", \"Pcp_City\": \"SACO\", \"Pcp_Name\": \"WELCH, JUDY L\", \"Rank_All\": 1, \"PCP_Phone\": \"2072830500\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4W45GK7AH99\", \"Member_City\": \"Biddeford\", \"Office_Name\": \"JUDY WELCH MD PA\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Biddeford\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1951-04-21\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"3 Eastview Pkwy,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"York\", \"Member_Country\": \"York\", \"PCP_Fax_Number\": \"2072834207\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"13 ANDREWS RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04005\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"13 ANDREWS RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04005\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Bell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"George\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"macangus52@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2074683468\", \"Member_Identification_Number\": \"10000059589\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-24-2026 14:40:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-24 14:40:58\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T14:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T13:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T13:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T17:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T14:40\", \"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:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-11T17:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T14:40\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:45\", \"value\": [{\"add\": \"13 ANDREWS RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1951-04-21\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2074683468\", \"zip\": \"04005\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Biddeford\", \"gend\": 0, \"insh\": \"10000059589\", \"mzip\": \"04005\", \"name\": \"George A Bell\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WELCH, JUDY L\", \"ppno\": \"2072830500\", \"cliId\": \"\", \"email\": \"macangus52@yahoo.com\", \"ename\": \"\", \"madd1\": \"13 ANDREWS RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Biddeford\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"3 Eastview Pkwy,\", \"pcpnpi\": \"1174519235\", \"pcpzip\": \"04072\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"SACO\", \"pcpname\": \"JUDY WELCH MD PA\", \"program\": \"Medicare\", \"pcpfaxno\": \"2072834207\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4W45GK7AH99\", \"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\": \"09:58:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:45\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"4/7/2026 @ 02:42 PM\", \"result\": 3, \"comment\": \"called to schedule with leana chan virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 12:45 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"4/2/2026 @ 02:00 PM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/30/2026 @ 11:31 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 08:48 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 @ 07:43 AM\", \"result\": 3, \"comment\": \"called to schedule F2F Appt w/ Shellie (NH) Hafer\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}, {\"date\": \"3/25/2026 @ 11:02 AM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM.u00a0 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/20/2026 @ 01:11 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 @ 03:26 PM\", \"result\": 3, \"comment\": \"Called to get member rescheduled with mphp virtual nurses -LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 05:13 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/16/2026 @ 11:06 AM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point Nurses-Shellie or Sandy- LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 11:36 AM\", \"result\": 1, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- line rang twice then went to dead air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 12:15 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Shellie Hafer- LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 02:44 PM\", \"result\": 3, \"comment\": \"Called to Schedule F2F HRA with Shellie no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"3/3/2026 @ 01:20 PM\", \"result\": 3, \"comment\": \"03/03/2026- CALLED TO SCH F2F-HRA W/Shellie Hafer \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 03:37 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F IHA W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 02:40 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 05:08 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:38 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/12/2026 @ 01:38 PM\"}, {\"date\": \"2/9/2026 @ 01:14 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F W/Shellie Hafer. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/10/2026 @ 01:14 PM\"}, {\"date\": \"2/4/2026 @ 01:42 PM\", \"result\": 3, \"comment\": \"calling to sched virtual IHA w/Amanda M\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"2/5/2026 @ 01:42 PM\"}, {\"date\": \"2/3/2026 @ 12:09 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"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-04-2026 13:42:00\", \"schedulerId\": \"52661009\", \"schedulerLeadId\": \"52661009\"}]}', '{\"date\": \"02-24-2026 14:40:58\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 23}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:26', 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
(1602, 62035418, 44829497, '17537038', '10000059604', '', '', '52498339', 'Dorothy', 'Gosselin', 'English', '', '{\"DOB\": 19295, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": 1861029654, \"Pcp_Zip\": \"42407691\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"KAZAL, HANNAH R\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4KN5U08KH74\", \"Member_City\": \"SABATTUS\", \"Office_Name\": \"CENTRAL MAINE FAMILY MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SABATTUS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-10-28\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"76 HIGH ST STE 200,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"16 LAKE ST\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": \"04280\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 486\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04280\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gosselin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dorothy\", \"Member_Middle_name\": \"J\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"bobbysuegosselin@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\": 2073752557, \"Member_Identification_Number\": \"10000059604\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2073122925-CELL\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-31-2026 13:52:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-03-31 13:52:35\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T18:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T18:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T14:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-12T11:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-13T16:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-17T09:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-22T21:48\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-25T20:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-25T20:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T13:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-02-10T15:17\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-18T16:58\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-22T15:44\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2026-02-28T15:41\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T18:16\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2026-02-10T15:17\", \"reportStatus_date\": \"2026-02-10T15:17\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2026-02-28T15:41\", \"reportStatus_date\": \"2026-02-28T15:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-13T16:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-22T21:48\", \"reportStatus_date\": \"2026-03-22T21:48\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-25T20:46\", \"reportStatus_date\": \"2026-03-25T20:46\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-03-31T13:52\", \"reportStatus_date\": \"2026-03-31T13:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2026-02-28T15:41\", \"username\": \"NHoneychuck\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-03-31T13:52\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-02-10T15:17\", \"username\": null}, {\"date\": \"2026-02-10T15:17\", \"username\": \"jsmith\"}, {\"date\": \"2026-03-18T16:58\", \"username\": null}, {\"date\": \"2026-03-18T16:58\", \"username\": \"JCopeland\"}], \"inProgress\": [{\"date\": \"2026-03-22T15:44\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-23T11:21\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2026-03-22T21:48\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-22T21:48\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-25T20:46\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-25T20:39\", \"username\": \"NSchaaf\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-25T20:46\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-22-2026\", \"time\": \"16:44:34\", \"value\": [{\"add\": \"16 LAKE ST\", \"age\": 73, \"ano\": \"\", \"cno\": \"2073122925-CELL\", \"dob\": \"1952-10-28\", \"eno\": \"2072129047\", \"lob\": \"GA - 2026\", \"pno\": 2073752557, \"zip\": \"04280\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SABATTUS\", \"gend\": 1, \"insh\": \"10000059604\", \"mzip\": \"04280\", \"name\": \"Dorothy J Gosselin\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KAZAL, HANNAH R\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bobbysuegosselin@yahoo.com\", \"ename\": \"Louise Matthew\", \"madd1\": \"PO BOX 486\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SABATTUS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"76 HIGH ST STE 200,\", \"pcpnpi\": 1861029654, \"pcpzip\": \"42407691\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Widowed\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"CENTRAL MAINE FAMILY MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4KN5U08KH74\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, false], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"02-27-2026\", \"time\": \"10:41:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-23-2026 11:21:48\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2026-02-28T15:41\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NHoneychuck\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/18/2026 @ 04:58 PM\", \"result\": 0, \"comment\": \"03/18/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken ON 3/22/2026 @ 3:30PM, MRB WILL BE USING ANDRIOD FOR APPT CELL PHONE NUMBER IS 2073122925 \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/17/2026 @ 09:46 AM\", \"result\": 3, \"comment\": \"called to schedule with amanda millikin virtual\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/18/2026 @ 09:46 AM\"}, {\"date\": \"3/13/2026 @ 04:31 PM\", \"result\": 3, \"comment\": \"called to schedule with sandra cadwell f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"3/14/2026 @ 04:31 PM\"}, {\"date\": \"3/12/2026 @ 11:55 AM\", \"result\": 3, \"comment\": \"o/c to resched missed virt appt - lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"3/13/2026 @ 11:55 AM\"}, {\"date\": \"2/10/2026 @ 03:17 PM\", \"result\": 0, \"comment\": \"Scheduled virtual w/ Nancy Honeychuck 2/28/2026 at 3PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 02:45 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/13/2026 @ 02:44 PM\"}, {\"date\": \"2/9/2026 @ 06:16 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/12/2026 @ 06:15 PM\"}, {\"date\": \"2/5/2026 @ 06:54 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 06:54 PM\"}, {\"date\": \"2/3/2026 @ 03:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"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\": \"10000059604\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000059604\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000059604\", \"scheduleDate\": \"2026-3-22T15:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 18:54:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}, {\"date\": \"02-28-2026 15:41:49\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"03-18-2026 16:58:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2026-03-31 13:52:34\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"65f509d1-2d2a-11f1-90f3-91c2c10b047c\\\",\\\"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\": \"null\"}]', 'Virtual', '2026-3-22T15:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:26', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059604\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Gosselin_10000059604_03222026.pdf\", \"ftp_upload_date\": \"2026-03-31 13:52:34\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059604.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Gosselin_10000059604_03222026.pdf', NULL, 'Summary_10000059604.pdf', NULL, '[{\"date\": \"2026-03-23T01:48:44.184Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-22T16:37', 'Member_Summary_10000059604.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059604\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059604.pdf\", \"member_ftp_upload_date\": \"2026-03-31 13:52:35\"}', 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
(1603, NULL, NULL, '9103191', '10000059689', '', '', '66650973', 'John', 'Stone', 'English', '', '{\"DOB\": 19352, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": \"1538176789\", \"Pcp_Zip\": \"41045040\", \"Program\": \"Medicare\", \"PCP_Flag\": 0, \"Pcp_City\": \"PORTLAND\", \"Pcp_Name\": \"STEELE, ERIK N\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"7EM5EJ9MY67\", \"Member_City\": \"Arrowsic\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Arrowsic\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-12-24\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO BOX 9746,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Sagadahoc\", \"Member_Country\": \"Sagadahoc\", \"PCP_Fax_Number\": \"2078287850\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"42 OLD STAGE RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04530\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"42 OLD STAGE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04530\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Stone\", \"Medication_Review\": \"N\", \"Member_first_name\": \"John\", \"Member_Middle_name\": \"F\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"jackteak1@gmail.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\": \"2073803722\", \"Member_Identification_Number\": \"10000059689\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"2074431208\"}', 'client_014', '2026', '', '{\"hraStatus\":6,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-11-2026 19:50:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-11 19:50:59\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-18T14:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-19T19:50\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-03-30T13:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2026-04-01T18:59\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-05T13:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-17T10:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-18T14:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-04-11T19:50\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-04-07T12:00\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-04-11T10:33\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2026-02-11T11:38\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2026-02-12T12:56\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-03T06:22\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-05T13:48\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T12:56\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-18T14:40\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-19T19:50\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-30T13:38\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2026-04-01T18:59\", \"reportStatus_date\": \"2026-04-01T18:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-04-11T19:50\", \"reportStatus_date\": \"2026-04-11T19:50\"}]', '{\"utc\": [{\"date\": \"2026-04-01T18:59\", \"username\": \"JDingle\"}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2026-04-07T12:00\", \"username\": null}, {\"date\": \"2026-04-07T12:00\", \"username\": \"AChevalier\"}], \"inProgress\": [{\"date\": \"2026-04-11T10:33\", \"username\": \"LChan\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2026-04-11T19:50\", \"username\": \"LChan\"}, {\"date\": \"2026-04-11T19:50\", \"username\": \"LChan\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-11-2026\", \"time\": \"19:15:51\", \"value\": [{\"add\": \"42 OLD STAGE RD\", \"age\": 73, \"ano\": \"\", \"cno\": \"2074431208\", \"dob\": \"1952-12-24\", \"eno\": \"207-350-7508\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073803722\", \"zip\": \"04530\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Arrowsic\", \"gend\": 0, \"insh\": \"10000059689\", \"mzip\": \"04530\", \"name\": \"John F Stone\", \"plan\": \"Martin\'s Point\", \"pphy\": \"STEELE, ERIK N\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"jackteak1@gmail.com\", \"ename\": \"Patricia Stone\", \"madd1\": \"42 OLD STAGE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Arrowsic\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO BOX 9746,\", \"pcpnpi\": \"1538176789\", \"pcpzip\": \"41045040\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"PORTLAND\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2078287850\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"7EM5EJ9MY67\", \"currentgend\": \"Male\", \"pphycomment\": \"Dr.Edwards in Brunswick Landing at Martin\'s Point -- first appt summer of 2026\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"1\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Christian\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true, false, false, false, true], \"score\": [\"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"via telehealth\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"04-10-2026\", \"time\": \"13:58:58\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-11-2026 19:50:59\"}', '{\"utc\": [{\"date\": \"2026-04-01T18:59\", \"type\": null, \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/7/2026 @ 12:00 PM\", \"result\": 0, \"comment\": \"Scheduled with Leana Chan 4/11/2026 @ 10:30am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/6/2026 @ 02:35 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/3/2026 @ 04:35 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"4/1/2026 @ 06:59 PM\", \"result\": 6, \"comment\": \"Member requested a callback Friday at 10 AM. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/30/2026 @ 01:38 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda but no answer No VM setup.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 10:16 AM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda Both numbers disconnected. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/27/2026 @ 10:14 AM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/26/2026 @ 10:39 AM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 10:58 AM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -no vm set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 07:50 PM\", \"result\": 3, \"comment\": \"03/19/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/14/2026 @ 11:18 AM\", \"result\": 10, \"comment\": \"Disconnected, No vm set up\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 12:26 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Amanda number disconnected.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 01:07 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 10:14 AM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 03:45 PM\", \"result\": 3, \"comment\": \"o/c to sched virtual HA w/Amanda\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/18/2026 @ 02:40 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/17/2026 @ 10:40 AM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Nicole Mattison NO VM SETUP. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 12:55 PM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Candace number disconnected.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"3/2/2026 @ 12:55 PM\"}, {\"date\": \"2/11/2026 @ 11:38 AM\", \"result\": 10, \"comment\": \"Called to Schedule Virtual HRA with Leanna no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/13/2026 @ 11:38 AM\"}, {\"date\": \"2/5/2026 @ 01:48 PM\", \"result\": 3, \"comment\": \"Called to schedule a virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"2/9/2026 @ 01:47 PM\"}, {\"date\": \"1/26/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000059689\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"9103191\", \"memberId\": \"10000059689\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"9103191\", \"memberId\": \"10000059689\", \"scheduleDate\": \"2026-4-11T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-05-2026 13:48:00\", \"schedulerId\": \"66650973\", \"schedulerLeadId\": \"66650973\"}]}', '{\"date\": \"04-07-2026 12:00:47\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 21}', NULL, 0, NULL, NULL, 'Virtual', '2026-4-11T10:30', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"date\": \"2026-04-11T23:50:58.031Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-04-11T11:20', 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
(1604, NULL, NULL, NULL, '10000059718', '', '', '52498339', 'Diane', 'St Hilaire', '', '', '{\"DOB\": 18072, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1144200833\", \"Pcp_Zip\": \"04240\", \"Program\": \"Medicare\", \"Pcp_City\": \"Lewiston\", \"Pcp_Name\": \"ROSS, PAMELA E\", \"Rank_All\": 1, \"PCP_Phone\": \"2077955700\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3N65VA9NT99\", \"Member_City\": \"SABATTUS\", \"Office_Name\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SABATTUS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-06-23\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"Central Maine Internal Medicine,12 High St Ste 400\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077955727\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"201 FISHER FARM RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04280\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"201 FISHER FARM RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04280\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"St Hilaire\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Diane\", \"Member_Middle_name\": \"G\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dsthilaire@roadrunner.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2073758275\", \"Member_Identification_Number\": \"10000059718\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":5,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-24-2026 16:26:12\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}', '{\"date\": \"2026-02-24 16:26:12\", \"hrastatus\": \"\", \"reportstatus\": \"UTC\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-24T16:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-05T18:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-09T18:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-23T19:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-24T16:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2026-02-09T18:23\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2026-02-16T01:26\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T18:23\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-16T01:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-23T19:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-24T16:26\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:50\", \"value\": [{\"add\": \"201 FISHER FARM RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-06-23\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2073758275\", \"zip\": \"04280\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SABATTUS\", \"gend\": 1, \"insh\": \"10000059718\", \"mzip\": \"04280\", \"name\": \"Diane G St Hilaire\", \"plan\": \"Martin\'s Point\", \"pphy\": \"ROSS, PAMELA E\", \"ppno\": \"2077955700\", \"cliId\": \"\", \"email\": \"dsthilaire@roadrunner.com\", \"ename\": \"\", \"madd1\": \"201 FISHER FARM RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SABATTUS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Central Maine Internal Medicine,12 High St Ste 400\", \"pcpnpi\": \"1144200833\", \"pcpzip\": \"04240\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"Lewiston\", \"pcpname\": \"CENTRAL MAINE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077955727\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3N65VA9NT99\", \"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\": \"09:58:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:50\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"3/19/2026 @ 10:35 AM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/13/2026 @ 04:33 PM\", \"result\": 3, \"comment\": \"called to schedule with sandra cadwell f2f\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"\"}, {\"date\": \"2/25/2026 @ 04:43 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sandy 3/26\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/24/2026 @ 04:26 PM\", \"result\": 3, \"comment\": \"02/24/2026- F2F HRA WITH Sandra Cadwell,  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/23/2026 @ 07:09 PM\", \"result\": 3, \"comment\": \"02/23/2026- F2F HRA WITH Sandra Cadwell,  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 06:23 PM\", \"result\": 14, \"comment\": \"Called to schedule virtual HRA-Call back member does not have camera access\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/9/2026 @ 06:20 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/11/2026 @ 06:17 PM\"}, {\"date\": \"2/5/2026 @ 06:56 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/6/2026 @ 06:55 PM\"}, {\"date\": \"2/3/2026 @ 12:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa Scott\", \"callbackDate\": \"\"}, {\"date\": \"1/29/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 18:56:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"02-24-2026 16:26:12\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1605, NULL, NULL, NULL, '10000059724', '', '', '47262451', 'Francis', 'Andre', '', '', '{\"DOB\": 18075, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1114689817\", \"Pcp_Zip\": \"42404106\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEWISTON\", \"Pcp_Name\": \"KELLY, NICOLE S\", \"Rank_All\": 1, \"PCP_Phone\": \"2077958475\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"4MC6QP4KH75\", \"Member_City\": \"LEEDS\", \"Office_Name\": \"FAMILY HEALTH CARE ASSOCIATES\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"LEEDS\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1949-06-26\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"FAMILY NURSE PRACTITIONER\", \"Pcp_Address_1\": \"18 LAURIER ST,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Androscoggin\", \"PCP_Fax_Number\": \"2077958490\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"433 CHURCHHILL RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04263\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 7\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04263\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Andre\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Francis\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Declined@071322.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077543481\", \"Member_Identification_Number\": \"10000059724\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-26-2026 17:58:03\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-26 17:58:03\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-09T15:15\", \"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-05T12:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-26T19:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T17:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-09T15:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-26T17:58\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2026-02-06T14:56\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-06T14:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-26T19:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-09T15:15\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-26T17:58\", \"reportStatus_date\": \"2026-03-26T17:58\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-26T17:58\", \"username\": \"JDingle\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:51\", \"value\": [{\"add\": \"433 CHURCHHILL RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1949-06-26\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077543481\", \"zip\": \"04263\", \"add2\": \"\", \"add3\": \"\", \"city\": \"LEEDS\", \"gend\": 0, \"insh\": \"10000059724\", \"mzip\": \"04263\", \"name\": \"Francis C Andre\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KELLY, NICOLE S\", \"ppno\": \"2077958475\", \"cliId\": \"\", \"email\": \"Declined@071322.com\", \"ename\": \"\", \"madd1\": \"PO BOX 7\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"LEEDS\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"18 LAURIER ST,\", \"pcpnpi\": \"1114689817\", \"pcpzip\": \"42404106\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEWISTON\", \"pcpname\": \"FAMILY HEALTH CARE ASSOCIATES\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077958490\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"4MC6QP4KH75\", \"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\": \"09:58:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:51\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-26T17:58\", \"type\": null, \"subStaus\": \"\", \"username\": \"JDingle\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/26/2026 @ 05:58 PM\", \"result\": 9, \"comment\": \"Caller declined the assessment, stated member is not interested and already sees multiple doctors.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:03 AM\", \"result\": 3, \"comment\": \"Called to get member scheduled with mphp virtual nurses -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/10/2026 @ 12:57 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/9/2026 @ 03:15 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ Samuel Acha- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 05:49 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA W/Amanda Milliken.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 07:08 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual IHA w/Jennifer Winslow.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jennifer Dingle\", \"callbackDate\": \"\"}, {\"date\": \"2/6/2026 @ 02:56 PM\", \"result\": 6, \"comment\": \"02/062026- SPOKE WITH MRBS WIFE SAID HE WOULNDT DO APPT BUT MRB WAS NOT THERE TO REFUSE \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"2/17/2026 @ 02:56 PM\"}, {\"date\": \"2/5/2026 @ 12:02 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"2/9/2026 @ 12:02 PM\"}, {\"date\": \"2/3/2026 @ 11:54 AM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"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-05-2026 12:02:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"03-09-2026 15:15:59\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1606, NULL, NULL, NULL, '10000059731', '', '', '14035267', 'Peter', 'Horsman', '', '', '{\"DOB\": 19391, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1730507336\", \"Pcp_Zip\": \"41079604\", \"Program\": \"Medicare\", \"Pcp_City\": \"CAPE ELIZABETH\", \"Pcp_Name\": \"KABAEVA, ZHYLDYZ T\", \"Rank_All\": 1, \"PCP_Phone\": \"2077672174\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3DG0DE9KP25\", \"Member_City\": \"SOUTH PORTLAND\", \"Office_Name\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SOUTH PORTLAND\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-02-01\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"M\", \"PCP_Specality\": \"INTERNAL MEDICINE\", \"Pcp_Address_1\": \"155 SPURWINK AVE,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"2077671348\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"224 HIGHLAND AVE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04106\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"224 HIGHLAND AVE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04106\", \"Member_Ethnicity\": \"Declined\", \"Member_Last_name\": \"Horsman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 46023, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"PETERTHORSMAN@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\": \"2077993818\", \"Member_Identification_Number\": \"10000059731\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"03-20-2026 10:16:24\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-03-20 10:16:24\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-03-05T17:07\", \"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-11T14:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T16:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-13T11:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-27T17:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-05T17:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-03-20T10:16\", \"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\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-03T06:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-13T11:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-27T17:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-03-05T17:07\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-03-20T10:16\", \"reportStatus_date\": \"2026-03-20T10:16\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-03-20T10:16\", \"username\": \"FBeckford\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:53\", \"value\": [{\"add\": \"224 HIGHLAND AVE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-02-01\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077993818\", \"zip\": \"04106\", \"add2\": \"\", \"add3\": \"\", \"city\": \"SOUTH PORTLAND\", \"gend\": 0, \"insh\": \"10000059731\", \"mzip\": \"04106\", \"name\": \"Peter T Horsman\", \"plan\": \"Martin\'s Point\", \"pphy\": \"KABAEVA, ZHYLDYZ T\", \"ppno\": \"2077672174\", \"cliId\": \"\", \"email\": \"PETERTHORSMAN@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"224 HIGHLAND AVE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SOUTH PORTLAND\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"155 SPURWINK AVE,\", \"pcpnpi\": \"1730507336\", \"pcpzip\": \"41079604\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"CAPE ELIZABETH\", \"pcpname\": \"MAINEHEALTH PRIMARY CARE INTERNAL MEDICINE\", \"program\": \"Medicare\", \"pcpfaxno\": \"2077671348\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3DG0DE9KP25\", \"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\": \"09:58:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:53\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-03-20T10:16\", \"type\": null, \"subStaus\": \"\", \"username\": \"FBeckford\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"3/20/2026 @ 10:16 AM\", \"result\": 9, \"comment\": \"Called to Schedule F2F HRA with Pamela but member refused aske us to stop calling  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/5/2026 @ 05:07 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Erin caller disconnected.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"\"}, {\"date\": \"2/27/2026 @ 05:12 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Nicole no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 08:19 AM\", \"result\": 3, \"comment\": \"called to schedule face to face w/ Shellie H\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/16/2026 @ 08:19 AM\"}, {\"date\": \"2/12/2026 @ 04:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Amy Chevalier\", \"callbackDate\": \"2/19/2026 @ 04:13 PM\"}, {\"date\": \"2/11/2026 @ 11:04 AM\", \"result\": 3, \"comment\": \"Called to schedule F2F appt \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"2/17/2026 @ 11:03 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-11-2026 11:04:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"03-05-2026 17:07:12\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1900-01-01', '2025', '0', '0'),
(1607, NULL, NULL, NULL, '10000059732', '', '', '94743867', 'Kathryn', 'Moore', '', '', '{\"DOB\": 19284, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - Wave 2\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"PCP_NPI\": \"1801875018\", \"Pcp_Zip\": \"42633418\", \"Program\": \"Medicare\", \"Pcp_City\": \"LEEDS\", \"Pcp_Name\": \"THORP, LYDIA A\", \"Rank_All\": 1, \"PCP_Phone\": \"2075243501\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"5AN6VH0TK47\", \"Member_City\": \"AUBURN\", \"Office_Name\": \"DFD RUSSELL MEDICAL CENTER\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"AUBURN\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1952-10-17\", \"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\": \"2075242093\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"44 LUCILLE ST APT 2\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04210\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"44 LUCILLE ST APT 2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04210\", \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Moore\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kathryn\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45658, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kathymoorekm52@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": \"2077844971\", \"Member_Identification_Number\": \"10000059732\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":4,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"02-11-2026 14:00:54\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}', '{\"date\": \"2026-02-11 14:00:54\", \"hrastatus\": \"\", \"reportstatus\": \"Refusal\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-09T13:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T15:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2026-02-11T14:00\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"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}], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2026-02-09T13:16\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2026-02-11T14:00\", \"reportStatus_date\": \"2026-02-11T14:00\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2026-02-11T14:00\", \"username\": \"LRivera\"}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-09-2026\", \"time\": \"01:11:53\", \"value\": [{\"add\": \"44 LUCILLE ST APT 2\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-10-17\", \"eno\": \"\", \"lob\": \"GA - Wave 2\", \"pno\": \"2077844971\", \"zip\": \"04210\", \"add2\": \"\", \"add3\": \"\", \"city\": \"AUBURN\", \"gend\": 1, \"insh\": \"10000059732\", \"mzip\": \"04210\", \"name\": \"Kathryn A Moore\", \"plan\": \"Martin\'s Point\", \"pphy\": \"THORP, LYDIA A\", \"ppno\": \"2075243501\", \"cliId\": \"\", \"email\": \"kathymoorekm52@gmail.com\", \"ename\": \"\", \"madd1\": \"44 LUCILLE ST APT 2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"AUBURN\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"180 CHURCH HILL RD STE 1,\", \"pcpnpi\": \"1801875018\", \"pcpzip\": \"42633418\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"LEEDS\", \"pcpname\": \"DFD RUSSELL MEDICAL CENTER\", \"program\": \"Medicare\", \"pcpfaxno\": \"2075242093\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"5AN6VH0TK47\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"01-31-2026\", \"time\": \"09:58:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-09-2026 01:11:53\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2026-02-11T14:00\", \"type\": null, \"subStaus\": \"\", \"username\": \"LRivera\", \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"2/11/2026 @ 01:00 PM\", \"result\": 9, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell Feb 13 or 27th; not interested at the moment; member stated she\'s had a lot of health issues last year and has a great care team.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 02:49 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/27; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/12/2026 @ 02:46 PM\"}, {\"date\": \"2/9/2026 @ 12:16 PM\", \"result\": 3, \"comment\": \"Called to schedule f2f hra with MP nurse Sandra Cadwell 2/13; LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lesly Rivera\", \"callbackDate\": \"2/11/2026 @ 12:16 PM\"}, {\"date\": \"1/30/2026 @ 12:00 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Travis Odle\", \"callbackDate\": \"2/8/2026 @ 09:00 AM\"}], \"visitType\": \"\", \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-09-2026 12:16:00\", \"schedulerId\": \"94743867\", \"schedulerLeadId\": \"94743867\"}]}', '{\"date\": \"01-31-2026 23:38:10\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:28', 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
(1608, 71932120, 44829497, '17537038', '10000059750', '', '', '52498339', 'Cindy', 'Rideout', 'English', '', '{\"DOB\": 19407, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Aligned\": \"\", \"PCP_NPI\": 1669470969, \"Pcp_Zip\": \"04236\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Greene\", \"Pcp_Name\": \"WANSKER, PAMELA\", \"Rank_All\": 1, \"PCP_Phone\": \"\", \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3RH3Q35AY93\", \"Member_City\": \"Harpswell\", \"Office_Name\": \"PAMELA WANSKER DO\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Greene\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-02-17\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"PO Box 539,\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Androscoggin\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"116 EDGEWATER COLONY RD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04079\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"272 RT 202\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04236\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Rideout\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Cindy\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"DECLINED@03052020.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"P\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Member_Primary_Phone_Number\": 2077540377, \"Member_Identification_Number\": \"10000059750\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 14:07:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-07 14:07:48\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2026-02-12T17:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2026-02-03T06:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-04T19:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-06T15:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-10T13:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-11T13:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-02-12T17:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2026-03-30T16:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-30T14:36\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-31T18:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T21:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-07T14:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-25T14:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-30T13:59\", \"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-06T15:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2026-02-12T17:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-30T14:36\", \"reportStatus_date\": \"2026-03-30T16:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-31T21:16\", \"reportStatus_date\": \"2026-03-31T21:16\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-04-07T14:07\", \"reportStatus_date\": \"2026-04-07T14:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-04-07T14:07\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-25T14:57\", \"username\": null}, {\"date\": \"2026-03-25T14:57\", \"username\": \"FBeckford\"}], \"inProgress\": [{\"date\": \"2026-03-30T13:59\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-30T18:31\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-03-30T14:36\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-30T14:36\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-31T21:16\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-31T18:26\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-31T21:16\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-30-2026\", \"time\": \"13:59:44\", \"value\": [{\"add\": \"116 EDGEWATER COLONY RD\", \"age\": 73, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1953-02-17\", \"eno\": \"8156790272\", \"lob\": \"GA - 2026\", \"pno\": 2077540377, \"zip\": \"04079\", \"add2\": \"\", \"add3\": \"\", \"city\": \"Harpswell\", \"gend\": 1, \"insh\": \"10000059750\", \"mzip\": \"04236\", \"name\": \"Cindy L Rideout\", \"plan\": \"Martin\'s Point\", \"pphy\": \"WANSKER, PAMELA\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"DECLINED@03052020.com\", \"ename\": \"Casey Wright - Daughter \", \"madd1\": \"272 RT 202\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Greene\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"PO Box 539,\", \"pcpnpi\": 1669470969, \"pcpzip\": \"04236\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"Greene\", \"pcpname\": \"PAMELA WANSKER DO\", \"program\": \"Medicare\", \"pcpfaxno\": \"\", \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3RH3Q35AY93\", \"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-30-2026\", \"time\": \"12:51:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-30-2026 14:36:14\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/25/2026 @ 02:57 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Amanda on March 30th at 2:00PM  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"3/23/2026 @ 11:53 AM\", \"result\": 3, \"comment\": \"o/c to sched w/Pamela 3/30\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/19/2026 @ 02:50 PM\", \"result\": 3, \"comment\": \"03/19/2026- CALLED TO SCH MPHC Virtual - Amanda Milliken \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"3/15/2026 @ 11:31 AM\", \"result\": 3, \"comment\": \"Called to schedule virtual with Amanda, LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kehinde Atobatele\", \"callbackDate\": \"\"}, {\"date\": \"3/12/2026 @ 05:28 PM\", \"result\": 3, \"comment\": \"o/c to sched virt w/Erin B 3/16\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"3/6/2026 @ 03:10 PM\", \"result\": 3, \"comment\": \"Called to schedule IHA w/ martins point nurse Samuel- LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"3/4/2026 @ 04:07 PM\", \"result\": 3, \"comment\": \"o/c to sched F2F w/Sam A 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/26/2026 @ 05:07 PM\", \"result\": 3, \"comment\": \"o/c to sched w/Sam 3/7\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"2/13/2026 @ 11:29 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/12/2026 @ 05:48 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Amanda no answer LVM.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christine Wasilak\", \"callbackDate\": \"\"}, {\"date\": \"2/11/2026 @ 01:39 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"\"}, {\"date\": \"2/10/2026 @ 01:52 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"2/13/2026 @ 01:52 PM\"}, {\"date\": \"2/6/2026 @ 03:10 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.u202f \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"callbackDate\": \"2/9/2026 @ 02:57 PM\"}, {\"date\": \"2/4/2026 @ 07:17 PM\", \"result\": 3, \"comment\": \"Called to schedule virtual HRA-voicemail \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Josie Smith\", \"callbackDate\": \"2/5/2026 @ 07:17 PM\"}, {\"date\": \"2/3/2026 @ 01:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Roody Dodoye\", \"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\": \"10000059750\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000059750\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000059750\", \"scheduleDate\": \"2026-3-30T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"02-04-2026 19:17:00\", \"schedulerId\": \"52498339\", \"schedulerLeadId\": \"52498339\"}]}', '{\"date\": \"03-25-2026 14:57:38\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 16}', NULL, 0, NULL, '[{\"date\": \"2026-04-07 14:07:46\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"ae062d94-32ac-11f1-80ba-db97bec3a6a2\\\",\\\"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\": \"null\"}]', 'Virtual', '2026-3-30T14:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:28', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059750\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Rideout_10000059750_03302026.pdf\", \"ftp_upload_date\": \"2026-04-07 14:07:45\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059750.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Rideout_10000059750_03302026.pdf', NULL, 'Summary_10000059750.pdf', NULL, '[{\"date\": \"2026-03-30T18:36:14.295Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-30T14:30', 'Member_Summary_10000059750.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059750\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059750.pdf\", \"member_ftp_upload_date\": \"2026-04-07 14:07:47\"}', 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
(1609, 71932120, 44829497, '17537038', '10000059781', '', '', '14035267', 'Patricia', 'Meserve', 'English', '', '{\"DOB\": 19460, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"GA - 2026\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Martin\'s Point\", \"HBA1C\": \"N\", \"Notes\": \"Successful fax\", \"Aligned\": \"\", \"PCP_NPI\": 1467038042, \"Pcp_Zip\": \"04038\", \"Program\": \"Medicare\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Gorham\", \"Pcp_Name\": \"FAY SHIELDS, JACOB A\", \"Rank_All\": 1, \"PCP_Phone\": 2078392559, \"Pcp_State\": \"ME\", \"Medicare_ID\": \"3F10CM5HG25\", \"Member_City\": \"GORHAM\", \"Office_Name\": \"MARTINS POINT HEALTH CARE\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"GORHAM\", \"Member_State\": \"ME\", \"Date_Of_Birth\": \"1953-04-11\", \"Mailing_State\": \"ME\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"PCP_Specality\": \"FAMILY MEDICINE\", \"Pcp_Address_1\": \"Martins Point Health Care,575 Main St\", \"Screening_IHA\": \"No\", \"Mailing_County\": \"Cumberland\", \"Member_Country\": \"Cumberland\", \"PCP_Fax_Number\": 2075231135, \"Plan_Term_Date\": \"9999-12-31\", \"Member_Address1\": \"3 DANA ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": \"04038\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 DANA ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": \"04038\", \"Member_Ethnicity\": \"Not Hispanic or Latino\", \"Member_Last_name\": \"Meserve\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Patricia\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 44927, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"pmeserve1@outlook.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Language\": \"English\", \"OMW_COMPLIANCE_DEADLINE\": \"1900-01-01\", \"Successful_Reaching_PCP\": \"Yes\", \"Member_Primary_Phone_Number\": \"2078395062\", \"Member_Identification_Number\": \"10000059781\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2077762633}', 'client_014', '2026', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"04-07-2026 14:07:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2026-04-07 14:07:57\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2026-03-30T14:52\", \"text\": \"Completed\", \"method\": \"import\", \"status\": 20}, {\"date\": \"2026-03-31T18:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-03-31T21:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2026-04-07T14:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2026-03-25T15:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2026-03-30T11:02\", \"text\": \"Scheduled\", \"method\": \"import\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": [], \"transferredToHealthPlan\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2026-03-30T14:52\", \"reportStatus_date\": \"2026-03-30T14:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2026-03-31T21:07\", \"reportStatus_date\": \"2026-03-31T21:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2026-04-07T14:07\", \"reportStatus_date\": \"2026-04-07T14:07\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2026-04-07T14:07\", \"username\": \"AWalsh\"}], \"scheduled\": [{\"date\": \"2026-03-25T15:29\", \"username\": null}, {\"date\": \"2026-03-25T15:29\", \"username\": \"MDouglas\"}], \"inProgress\": [{\"date\": \"2026-03-30T11:02\", \"username\": \"AMilliken\"}], \"qaAssigned\": [{\"date\": \"2026-03-30T18:31\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2026-03-30T14:52\", \"username\": \"AMilliken\"}, {\"date\": \"2026-03-30T14:52\", \"username\": \"AMilliken\"}], \"inEligibile\": [], \"termExpired\": [], \"unScheduled\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2026-03-31T21:07\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2026-03-31T18:13\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2026-03-31T21:07\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": [], \"transferredToHealthPlan\": []}', '{\"history\": [{\"modified\": [{\"date\": \"03-30-2026\", \"time\": \"11:08:06\", \"value\": [{\"add\": \"3 DANA ST\", \"age\": 72, \"ano\": \"\", \"cno\": 2077762633, \"dob\": \"1953-04-11\", \"eno\": \"2078395062\", \"lob\": \"GA - 2026\", \"pno\": \"2078395062\", \"zip\": \"04038\", \"add2\": \"\", \"add3\": \"\", \"city\": \"GORHAM\", \"gend\": 1, \"insh\": \"10000059781\", \"mzip\": \"04038\", \"name\": \"Patricia A Meserve\", \"plan\": \"Martin\'s Point\", \"pphy\": \"FAY SHIELDS, JACOB A\", \"ppno\": 2078392559, \"cliId\": \"\", \"email\": \"pmeserve1@outlook.com\", \"ename\": \"Elaine Presby - spouse \", \"madd1\": \"3 DANA ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"GORHAM\", \"pcpid\": \"\", \"state\": \"ME\", \"mstate\": \"ME\", \"pcpadd\": \"Martins Point Health Care,575 Main St\", \"pcpnpi\": 1467038042, \"pcpzip\": \"04038\", \"region\": \"\", \"aligned\": \"\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Gorham\", \"pcpname\": \"MARTINS POINT HEALTH CARE\", \"program\": \"Medicare\", \"pcpfaxno\": 2075231135, \"pcpstate\": \"ME\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"3F10CM5HG25\", \"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-30-2026\", \"time\": \"11:02:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-30-2026 14:52:29\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"3/25/2026 @ 12:29 PM\", \"result\": 0, \"comment\": \"SCHEDULED VIRTUAL APPT W/ AMANDA AT 11 AM - SENT CONFIRMATION VIA EMAIL\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Megan Douglas\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"10000059781\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"17537038\", \"memberId\": \"10000059781\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"17537038\", \"memberId\": \"10000059781\", \"scheduleDate\": \"2026-3-30T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"03-25-2026 12:29:00\", \"schedulerId\": \"14035267\", \"schedulerLeadId\": \"14035267\"}]}', '{\"date\": \"03-25-2026 15:29:41\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2026-04-07 14:07:55\", \"status\": 1, \"message\": \"Fax sent successfully\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e664b652-def0-4891-a50d-00a41915ad5a\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"fax_id\\\":\\\"e664b652-def0-4891-a50d-00a41915ad5a\\\",\\\"direction\\\":\\\"OUTBOUND\\\",\\\"originating_fax_number\\\":\\\"15034367151\\\",\\\"destination_fax_number\\\":\\\"12075231135\\\",\\\"originating_fax_tsid\\\":\\\"18883730493\\\",\\\"destination_fax_csid\\\":\\\"18552631139 9       \\\",\\\"transmission_data\\\":{\\\"transmission_status\\\":\\\"COMPLETE\\\",\\\"completed_timestamp\\\":\\\"2026-04-07T18:12:42.005+0000\\\",\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\",\\\"total_pages_sent\\\":6,\\\"billable_retries\\\":0,\\\"non_billable_retries\\\":0,\\\"human_answer_retries\\\":0,\\\"total_duration\\\":253,\\\"attempts\\\":[{\\\"attempt_number\\\":1,\\\"attempt_status\\\":\\\"COMPLETE\\\",\\\"duration\\\":253,\\\"start_timestamp\\\":\\\"2026-04-07T18:08:13.001+0000\\\",\\\"completed_timestamp\\\":\\\"2026-04-07T18:12:42.005+0000\\\",\\\"pages_sent\\\":6,\\\"error_code\\\":\\\"SFAX\\\",\\\"error_message\\\":\\\"Successful fax\\\"}]}}\", \"http_status_code\": 200}}]', 'Virtual', '2026-3-30T11:00', '9999-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '31-01-2026 09:58:29', NULL, NULL, NULL, NULL, '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059781\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"Martin\'s Point_GA - 2026_Virtual_Meserve_10000059781_03302026.pdf\", \"ftp_upload_date\": \"2026-04-07 14:07:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"Summary_10000059781.pdf\"}', 'Martin\'s Point_GA - 2026_Virtual_Meserve_10000059781_03302026.pdf', NULL, 'Summary_10000059781.pdf', NULL, '[{\"date\": \"2026-03-30T18:52:28.970Z\", \"signature\": \"data:image/png;base64,[BLOB]\"}]', '2026-03-30T11:30', 'Member_Summary_10000059781.pdf', '{\"year\": \"2026\", \"client_id\": \"client_014\", \"member_id\": \"10000059781\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_10000059781.pdf\", \"member_ftp_upload_date\": \"2026-04-07 14:07:56\"}', NULL, NULL, NULL, '1900-01-01', '2025', '0', '0');
