INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(2997, NULL, NULL, NULL, '0005641067001', '381345', '', '47262451', 'Crystal', 'berry', '', '{\"DOB\": 29598, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1760862346, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"PEARSON\", \"Pcp_Name\": \"AMANDA MERRITT\", \"Rank_All\": \"\", \"PCP_Phone\": 9123838806, \"Pcp_State\": \"GA\", \"Member_City\": \"Fitzgerald\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Fitzgerald\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-01-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"640 MAIN ST N\", \"Screening_IHA\": \"No\", \"member_id_two\": 381345, \"Mailing_County\": \"BEN HILL\", \"Member_Country\": \"BEN HILL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"808 n Merrimack Dr\", \"Member_Address2\": \"Apt 2\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31750, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"808 n Merrimack Dr\", \"Mailing_Address2\": \"Apt 2\", \"Mailing_Zip_Code\": 31750, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"berry\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Crystal\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2299479113, \"Member_Identification_Number\": \"0005641067001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T14:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-15T18:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-12T13:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:05\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T14:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-15T18:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-12T13:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-10-30T10:35\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:19\", \"value\": [{\"add\": \"808 n Merrimack Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1981-01-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2299479113, \"zip\": 31750, \"add2\": \"Apt 2\", \"add3\": \"\", \"city\": \"Fitzgerald\", \"gend\": 1, \"insh\": \"0005641067001\", \"mzip\": 31750, \"name\": \"Crystal berry\", \"plan\": \"Alliant\", \"pphy\": \"AMANDA MERRITT\", \"ppno\": 9123838806, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"808 n Merrimack Dr\", \"madd2\": \"Apt 2\", \"madd3\": \"\", \"mcity\": \"Fitzgerald\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"640 MAIN ST N\", \"pcpnpi\": 1760862346, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"PEARSON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:19\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 12:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 11:50 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 03:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/01/2024 @ 09:30 AM\"}, {\"date\": \"9/12/2024 @ 01:33 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/13/2024 @ 01:33 PM\"}, {\"date\": \"8/15/2024 @ 06:18 PM\", \"result\": 13, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"8/22/2024 @ 06:18 PM\"}, {\"date\": \"8/9/2024 @ 02:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/12/2024 @ 02:50 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 14:50:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"12-16-2024 01:05:59\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2998, NULL, NULL, NULL, '0005648899001', '375350', '', '21881792', 'Sheila', 'Cortez', '', '{\"DOB\": 34198, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1528128873, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"ROME\", \"Pcp_Name\": \"Barry Brass\", \"Rank_All\": \"\", \"PCP_Phone\": 7622352710, \"Pcp_State\": \"GA\", \"Member_City\": \"Rome\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-08-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"330 TURNER MCCALL BLVD SW\", \"Screening_IHA\": \"No\", \"member_id_two\": 375350, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"34 Frances Dr NW\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30165, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"34 Frances Dr NW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30165, \"Member_Ethnicity\": \"Puerto Rican\", \"Member_Last_name\": \"Cortez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sheila\", \"Member_Middle_name\": \"Marie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Sheilacortez14@yahoo.com\", \"Member_Suspect_Codes\": \"130, 21, 212\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4048016951, \"Member_Identification_Number\": \"0005648899001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-29T14:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-08-12T17:13\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-08-26T16:33\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T17:13\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T16:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T14:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:43\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:09\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-10-30T10:35\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:20\", \"value\": [{\"add\": \"34 Frances Dr NW\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-08-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4048016951, \"zip\": 30165, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 1, \"insh\": \"0005648899001\", \"mzip\": 30165, \"name\": \"Sheila Marie Cortez\", \"plan\": \"Alliant\", \"pphy\": \"Barry Brass\", \"ppno\": 7622352710, \"cliId\": \"\", \"email\": \"Sheilacortez14@yahoo.com\", \"ename\": \"\", \"madd1\": \"34 Frances Dr NW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"330 TURNER MCCALL BLVD SW\", \"pcpnpi\": 1528128873, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"ROME\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/19/2024 @ 04:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 10:17 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 04:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 04:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 04:23 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/9/2024 @ 04:59 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/25/2024 @ 12:48 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 03:00 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/08/2024 @ 09:30 AM\"}, {\"date\": \"8/29/2024 @ 02:26 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/Faith \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"9/3/2024 @ 02:26 PM\"}, {\"date\": \"8/26/2024 @ 04:33 PM\", \"result\": 14, \"comment\": \"Called to Schedule F2F HRA with Debbie but member requested a F2F call back for appt after 3:30\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/10/2024 @ 04:33 PM\"}, {\"date\": \"8/12/2024 @ 05:13 PM\", \"result\": 14, \"comment\": \"Member would like a F2F appt after 3:30 - call attempt to schedule a virtual HRA w/ Faith. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/13/2024 @ 05:12 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 17:13:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 01:09:49\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2999, NULL, NULL, NULL, '0005651226001', '367559', '', '21881792', 'Deborah', 'Reczek', '', '{\"DOB\": 22302, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dawsonville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-01-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 367559, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"337 River Sound Ln\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"337 River Sound Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Reczek\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deborah\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dreczek23@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6304768960, \"Member_Identification_Number\": \"0005651226001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-26T12:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-11T11:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-10-10T15:14\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-07T18:15\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-07T18:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T12:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-11T11:34\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-10-10T15:14\", \"reportStatus_date\": \"2024-10-10T15:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-10-10T15:14\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:20\", \"value\": [{\"add\": \"337 River Sound Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-01-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6304768960, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0005651226001\", \"mzip\": 30534, \"name\": \"Deborah Reczek\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dreczek23@gmail.com\", \"ename\": \"\", \"madd1\": \"337 River Sound Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:20\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-10-10T15:14\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"10/10/2024 @ 03:14 PM\", \"result\": 9, \"comment\": \"Member declined offer to schedule HRA - Refused \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/11/2024 @ 11:34 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/12/2024 @ 11:34 AM\"}, {\"date\": \"8/26/2024 @ 12:20 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/2/2024 @ 12:20 PM\"}, {\"date\": \"8/7/2024 @ 06:15 PM\", \"result\": 6, \"comment\": \"Member busy at the time of call and requested a call back at a later date and time. Call attempt to schedule a virtual HRA w/ Jansen Helm.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/8/2024 @ 06:15 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-07-2024 18:15:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-08-2024 00:31:23\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3000, NULL, NULL, NULL, '0005654321001', '385305', '', '21881792', 'Tiffany', 'Massey', '', '{\"DOB\": 32034, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dahlonega\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1987-09-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 385305, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2895 Nimblewill Church Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2895 Nimblewill Church Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Massey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tiffany\", \"Member_Middle_name\": \"Lynne\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"tiffanyfarris@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064298350, \"Member_Identification_Number\": \"0005654321001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-11-22T11:31\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-08-30T10:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-09-19T10:52\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-23T15:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-23T15:23\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-30T10:30\", \"reportStatus_date\": \"2024-08-30T10:31\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-09-19T10:52\", \"reportStatus_date\": \"2024-09-19T10:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:41\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-11-22T11:31\", \"reportStatus_date\": \"2024-11-22T11:31\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-17-2024\", \"time\": \"20:00:03\", \"value\": [{\"add\": \"2895 Nimblewill Church Rd\", \"age\": 37, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1987-09-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064298350, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 1, \"insh\": \"0005654321001\", \"mzip\": 30533, \"name\": \"Tiffany Lynne Massey\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"tiffanyfarris@gmail.com\", \"ename\": \"\", \"madd1\": \"2895 Nimblewill Church Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-17-2024\", \"time\": \"20:00:03\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-19-2024 06:43:41\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TOdleAdmin\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"11/22/2024 @ 11:31 AM\", \"result\": 9, \"comment\": \"Call attempt to reschedule HRA - Member stated that not a good time to reschedule - Refusal. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/19/2024 @ 10:14 AM\", \"result\": 3, \"comment\": \"Member LVM and cancelled appt. 9/17 - Returned members call to attempt reschedule virtual HRA.  - LVM to return call to reschedule with Debbie York on 9/24 @ 9:30\", \"inBound\": true, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/20/2024 @ 10:14 AM\"}, {\"date\": \"8/30/2024 @ 10:30 AM\", \"result\": 0, \"comment\": \"Scheduled virtual hra with Delise Adams on 9/13 at 9:45am. Link emailed, member using phone.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/23/2024 @ 03:23 PM\", \"result\": 6, \"comment\": \"Member requested a call back. Call attempt to schedule an HRA w/ Delise Adams 9/13.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 03:38 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-23-2024 15:23:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"09-19-2024 10:52:32\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"09-19-2024 10:52:32\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3001, NULL, NULL, NULL, '0005665348001', '366034', '', '84929813', 'Justin', 'Jackson', '', '{\"DOB\": 27069, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-02-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 366034, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6911 Trailing Ivy Way\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"6911 Trailing Ivy Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Jackson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Justin\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"flatout79@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4049060370, \"Member_Identification_Number\": \"0005665348001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-28T14:46\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-07T16:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-26T14:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T13:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T14:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T14:46\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-07T16:45\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T14:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T14:46\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:21\", \"value\": [{\"add\": \"6911 Trailing Ivy Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-02-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4049060370, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 0, \"insh\": \"0005665348001\", \"mzip\": 30542, \"name\": \"Justin Jackson\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"flatout79@gmail.com\", \"ename\": \"\", \"madd1\": \"6911 Trailing Ivy Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:21\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/6/2024 @ 12:47 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:36 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 04:26 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/28/2024 @ 02:46 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/28/2024 @ 02:45 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/6/2024 @ 02:45 PM\"}, {\"date\": \"8/27/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams NO VM SETUP \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/5/2024 @ 01:01 PM\"}, {\"date\": \"8/26/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/2/2024 @ 02:11 PM\"}, {\"date\": \"8/7/2024 @ 04:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/14/2024 @ 04:45 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-07-2024 16:45:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"08-28-2024 14:46:19\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3002, NULL, NULL, NULL, '0005672820001', '369702', '', '543416', 'Edward', 'Johnson', '', '{\"DOB\": 25197, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Pendergrass\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Pendergrass\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-12-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 369702, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1498 brooks rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30567, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1498 brooks rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30567, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Johnson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Edward\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063401684, \"Member_Identification_Number\": \"0005672820001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-14T17:01\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-11T15:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-14T17:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-16T17:03\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-19T15:35\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-22T13:47\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-19T15:35\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T13:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-14T17:01\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:21\", \"value\": [{\"add\": \"1498 brooks rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-12-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063401684, \"zip\": 30567, \"add2\": \"\", \"add3\": \"\", \"city\": \"Pendergrass\", \"gend\": 0, \"insh\": \"0005672820001\", \"mzip\": 30567, \"name\": \"Edward Johnson\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1498 brooks rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Pendergrass\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:21\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 03:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/14/2024 @ 05:01 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/11/2024 @ 03:45 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/14/2024 @ 03:45 PM\"}, {\"date\": \"8/22/2024 @ 01:47 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a virtual HRA w/ Delise Adams.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 01:47 PM\"}, {\"date\": \"8/19/2024 @ 03:35 PM\", \"result\": 10, \"comment\": \"Called to schedule screening w/ Delise Adams Disconnected phone number-8/19/2024 LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/23/2024 @ 03:35 PM\"}, {\"date\": \"8/16/2024 @ 05:03 PM\", \"result\": 10, \"comment\": \"08/16/2024 JC: called for HRA-Delise Adams-Virtual or F2F: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/20/2024 @ 05:03 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-16-2024 17:03:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"10-14-2024 17:01:24\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3003, NULL, NULL, NULL, '0005677314001', '386563', '', '21881792', 'Lori', 'Jones', '', '{\"DOB\": 25427, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gillsville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gillsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-08-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 386563, \"Mailing_County\": \"BANKS\", \"Member_Country\": \"BANKS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"628 Queen Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30543, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"628 Queen Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30543, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Jones\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lori\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"lorijones749@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7702820700, \"Member_Identification_Number\": \"0005677314001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T12:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-11T13:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-26T12:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-03T15:19\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T12:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-11T13:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-26T12:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-03T15:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:22\", \"value\": [{\"add\": \"628 Queen Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-08-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7702820700, \"zip\": 30543, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gillsville\", \"gend\": 1, \"insh\": \"0005677314001\", \"mzip\": 30543, \"name\": \"Lori Jones\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"lorijones749@gmail.com\", \"ename\": \"\", \"madd1\": \"628 Queen Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gillsville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:22\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 04:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/3/2024 @ 03:19 PM\", \"result\": 13, \"comment\": \"Call attempt to schedule an HRA - Caller disconnected. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/4/2024 @ 03:19 PM\"}, {\"date\": \"9/26/2024 @ 12:28 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/27/2024 @ 12:28 PM\"}, {\"date\": \"9/11/2024 @ 01:36 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA   - Mailbox Full. - 9/17 - Delise Adams.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/12/2024 @ 01:36 PM\"}, {\"date\": \"8/14/2024 @ 12:48 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/15/2024 @ 12:48 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 12:48:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:53:55\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3004, 71932120, 44829497, '56716210', '0005680439001', '375644', '', '543416', 'Oscar', 'Cortez', '', '{\"DOB\": 34810, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30096\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Duluth \", \"Pcp_Name\": \"Gabriel Nguena\", \"Rank_All\": \"\", \"PCP_Phone\": \"7709257232\", \"Pcp_State\": \"\", \"Member_City\": \"Braselton\", \"Office_Name\": \"Gwinnett Clinic\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Braselton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1995-04-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"3068 OLD NORCROSS RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 375644, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7706383315\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4631 Primrose Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30517, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"4631 Primrose Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30517, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cortez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Oscar\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"oskicortez@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4702344567, \"Member_Identification_Number\": \"0005680439001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"10-22-2024 12:34:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-22 12:34:44\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-16T17:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-21T19:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-10-15T21:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-17T10:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-18T01:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-22T12:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-10T11:40\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-16T17:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-21T19:00\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-10T11:40\", \"reportStatus_date\": \"2024-10-10T11:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-10-18T01:41\", \"reportStatus_date\": \"2024-10-18T01:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-22T12:34\", \"reportStatus_date\": \"2024-10-22T12:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-22T12:34\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-10-10T11:40\", \"username\": null}, {\"date\": \"2024-10-10T11:40\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-15T06:48\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-10-16T12:34\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-10-15T21:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-10-15T21:27\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-10-18T01:41\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-10-17T10:47\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-10-18T01:41\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-23-2025\", \"time\": \"06:31:50\", \"value\": [{\"add\": \"4631 Primrose Dr\", \"age\": 30, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1995-04-21\", \"eno\": \"4042596545\", \"lob\": \"On Exchange\", \"pno\": 4702344567, \"zip\": 30517, \"add2\": \"\", \"add3\": \"\", \"city\": \"Braselton\", \"gend\": 0, \"insh\": \"0005680439001\", \"mzip\": 30517, \"name\": \"Oscar Cortez\", \"plan\": \"Alliant\", \"pphy\": \"Gabriel Nguena\", \"ppno\": \"7709257232\", \"race\": \"\", \"cliId\": \"\", \"email\": \"oskicortez@gmail.com\", \"ename\": \"Diana Cortez\", \"madd1\": \"4631 Primrose Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Braselton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"3068 OLD NORCROSS RD\", \"pcpnpi\": \"\", \"pcpzip\": \"30096\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Duluth \", \"pcpname\": \"Gwinnett Clinic\", \"program\": \"ACA\", \"evalDate\": \"2024-10-15 03:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7706383315\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"10-15-2024\", \"time\": \"06:48:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-23-2025 06:31:50\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/10/2024 @ 11:40 AM\", \"result\": 0, \"comment\": \"Scheduled Delise A on 10/15 @ 3 - Texted doxy link to member - member will use their phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/21/2024 @ 07:00 PM\", \"result\": 3, \"comment\": \"08/21/2024 JC: called for HRA-Delise Adams-F2F/Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/28/2024 @ 07:00 PM\"}, {\"date\": \"8/16/2024 @ 05:43 PM\", \"result\": 13, \"comment\": \"08/16/2024 JC: called for HRA-Delise Adams-Virtual or F2F: caller hung up, \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/20/2024 @ 05:43 PM\"}, {\"date\": \"8/15/2024 @ 03:25 PM\", \"result\": 3, \"comment\": \"08/15/2024 JC: called for HRA-Delise Adams-Virtual or F2F: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/19/2024 @ 03:25 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005680439001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0005680439001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0005680439001\", \"scheduleDate\": \"2024-10-15T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 15:25:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"10-10-2024 11:40:03\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2024-10-22 12:34:42\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"8a320242-9093-11ef-af4f-8f57b959a9d2\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-10-15T15:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:22', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005680439001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005680439001_Cortez, Oscar_10152024.pdf\", \"ftp_upload_date\": \"2024-10-22 12:34:41\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Nguena, Gabriel_0005680439001_10152024.pdf\"}', 'ACA_0005680439001_Cortez, Oscar_10152024', NULL, 'PCP_Nguena, Gabriel_0005680439001_10152024', NULL, '[{\"date\": \"2024-10-16T01:27:26.837Z\", \"signature\": \"data:image/png;base64,[encoded data, 23424 characters]\"}]', '2024-10-15T15:30', 'Member_Summary_0005680439001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005680439001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005680439001.pdf\", \"member_ftp_upload_date\": \"2024-10-22 12:34:43\"}', NULL, NULL, NULL, NULL),
(3005, NULL, NULL, NULL, '0005687589002', '373226', '', NULL, 'James', 'Wainright', '', '{\"DOB\": 23674, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Cairo\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cairo\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-10-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 373226, \"Mailing_County\": \"GRADY\", \"Member_Country\": \"GRADY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"134 Oakdale Rd SE\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 39828, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"134 Oakdale Rd SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 39828, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Wainright\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0005687589002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:27\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:27\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:22\", \"value\": [{\"add\": \"134 Oakdale Rd SE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-10-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 39828, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cairo\", \"gend\": 0, \"insh\": \"0005687589002\", \"mzip\": 39828, \"name\": \"James A Wainright\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"134 Oakdale Rd SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cairo\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:22\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:31:24\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3006, NULL, NULL, NULL, '0005710668001', '358485', '', '21881792', 'William', 'Savage', '', '{\"DOB\": 30213, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"temple\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"temple\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1982-09-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 358485, \"Mailing_County\": \"Carroll\", \"Member_Country\": \"Carroll\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1958 n hwy113\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 301790000, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1958 n hwy113\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30179, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Savage\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"williamsavage512@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7709900780, \"Member_Identification_Number\": \"0005710668001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:28\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-13T11:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T17:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T17:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T12:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:48\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-13T11:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T17:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T12:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:23\", \"value\": [{\"add\": \"1958 n hwy113\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1982-09-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7709900780, \"zip\": 301790000, \"add2\": \"\", \"add3\": \"\", \"city\": \"temple\", \"gend\": 0, \"insh\": \"0005710668001\", \"mzip\": 30179, \"name\": \"William Savage\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"williamsavage512@yahoo.com\", \"ename\": \"\", \"madd1\": \"1958 n hwy113\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"temple\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:23\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 04:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 03:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 12:59 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/10/2024 @ 12:59 PM\"}, {\"date\": \"8/28/2024 @ 05:26 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/29/2024 @ 05:26 PM\"}, {\"date\": \"8/27/2024 @ 05:22 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/28/2024 @ 05:22 PM\"}, {\"date\": \"8/13/2024 @ 11:53 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/14/2024 @ 11:53 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 11:53:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 00:48:24\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3007, NULL, NULL, NULL, '0005715705001', '371371', '', '33985161', 'Brenda', 'Taylor', '', '{\"DOB\": 21891, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Jackson\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Jackson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-12-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 371371, \"Mailing_County\": \"MONROE\", \"Member_Country\": \"MONROE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"485 Lakeshore Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30233, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"485 Lakeshore Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30233, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Taylor\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brenda\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bluesman420@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4048406553, \"Member_Identification_Number\": \"0005715705001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:35:28\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-08-13T14:33\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2024-08-16T16:17\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-16T16:17\", \"reportStatus_date\": \"2024-08-16T16:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-08-13T14:33\", \"username\": null}, {\"date\": \"2024-08-16T16:17\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:23\", \"value\": [{\"add\": \"485 Lakeshore Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-12-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4048406553, \"zip\": 30233, \"add2\": \"\", \"add3\": \"\", \"city\": \"Jackson\", \"gend\": 1, \"insh\": \"0005715705001\", \"mzip\": 30233, \"name\": \"Brenda Taylor\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bluesman420@gmail.com\", \"ename\": \"\", \"madd1\": \"485 Lakeshore Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Jackson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:23\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-08-13T14:33\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-08-16T16:17\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/16/2024 @ 04:17 PM\", \"result\": 9, \"comment\": \"Caller refused on previous call - LLA see notes in comments\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"\"}, {\"date\": \"8/13/2024 @ 02:33 PM\", \"result\": 9, \"comment\": \"REFUSAL - Member declined offer to schedule in 2024. Would like a callback in new year to schedule an in-home/virtual assessment \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 14:33:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"08-08-2024 00:31:24\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3008, NULL, NULL, NULL, '0005719292001', '362173', '', '21881792', 'Richard', 'Thomas', '', '{\"DOB\": 26364, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1952806846, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"VALDOSTA\", \"Pcp_Name\": \"JOSEPH HAYES\", \"Rank_All\": \"\", \"PCP_Phone\": 9123507171, \"Pcp_State\": \"GA\", \"Member_City\": \"Valdosta\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Valdosta\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-03-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"2501 N PATTERSON ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 362173, \"Mailing_County\": \"LOWNDES\", \"Member_Country\": \"LOWNDES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"513 E Adair St\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31601, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"513 E Adair St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31601, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Thomas\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45323, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"raincontrolroofing@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2295060280, \"Member_Identification_Number\": \"0005719292001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:28\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-12T12:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-13T16:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-06T17:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-16T15:16\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T12:51\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-16T15:16\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T16:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-06T17:35\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:09\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:24\", \"value\": [{\"add\": \"513 E Adair St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-03-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2295060280, \"zip\": 31601, \"add2\": \"\", \"add3\": \"\", \"city\": \"Valdosta\", \"gend\": 0, \"insh\": \"0005719292001\", \"mzip\": 31601, \"name\": \"Richard Thomas\", \"plan\": \"Alliant\", \"pphy\": \"JOSEPH HAYES\", \"ppno\": 9123507171, \"cliId\": \"\", \"email\": \"raincontrolroofing@yahoo.com\", \"ename\": \"\", \"madd1\": \"513 E Adair St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Valdosta\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2501 N PATTERSON ST\", \"pcpnpi\": 1952806846, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"VALDOSTA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:24\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/11/2024 @ 12:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 12:30 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/25/2024 @ 01:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 05:35 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"11/7/2024 @ 05:35 PM\"}, {\"date\": \"9/13/2024 @ 04:05 PM\", \"result\": 1, \"comment\": \"Call answered but no sound on call. Call to schedule a virtual HRA. - Dead air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/16/2024 @ 04:05 PM\"}, {\"date\": \"8/16/2024 @ 03:16 PM\", \"result\": 6, \"comment\": \"Member at work- Cb requested \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/22/2024 @ 06:15 PM\"}, {\"date\": \"8/12/2024 @ 12:51 PM\", \"result\": 13, \"comment\": \"Caller answered the call. After stating reason for call member disconnected the call.  Call attempt to schedule a virtual or F2F HRA w/ Faith Enwefah.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/13/2024 @ 12:51 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 12:51:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 01:09:42\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3009, 57818338, 44829497, '56716210', '0005722563001', '379230', '', '99038484', 'Peter', 'Kasameyer', '', '{\"DOB\": 22672, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-01-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 379230, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2942 Waterford Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30504, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2942 Waterford Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Kasameyer\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Peter\", \"Member_Middle_name\": \"Bennett\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"hiwatt351@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6787255640, \"Member_Identification_Number\": \"0005722563001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-28-2024 11:18:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-28 11:18:58\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-16T14:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-21T13:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-21T13:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-28T11:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-12T16:33\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-08-12T16:34\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-12T16:34\", \"reportStatus_date\": \"2024-08-12T16:34\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-08-19T16:42\", \"reportStatus_date\": \"2024-08-16T14:47\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-21T13:58\", \"reportStatus_date\": \"2024-08-21T13:58\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-28T11:18\", \"reportStatus_date\": \"2024-08-28T11:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-28T11:18\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-12T16:34\", \"username\": null}, {\"date\": \"2024-08-12T16:34\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-15T00:33\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-19T10:56\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-16T14:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-16T14:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-21T05:49\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-21T13:58\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-21T13:46\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-21T13:58\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-19T16:42\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-16-2024\", \"time\": \"14:47:34\", \"value\": [{\"add\": \"2942 Waterford Dr\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-01-26\", \"eno\": \"6788977968\", \"lob\": \"On Exchange\", \"pno\": 6787255640, \"zip\": 30504, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0005722563001\", \"mzip\": 30504, \"name\": \"Peter Bennett Kasameyer\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"hiwatt351@icloud.com\", \"ename\": \"Bennett Kasameyer\", \"madd1\": \"2942 Waterford Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-8-15 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"needs one\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-15-2024\", \"time\": \"00:33:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-25-2024 16:33:54\"}', NULL, NULL, '{\"memberId\": \"0005722563001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Mon, 19 Aug 2024 20:42:21 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Mini Cog and TUG are reported as n/a please add comment why.\\n2.  Patient summary notes.  Please add that member does not currently have a PCP and if member verbalized understanding of the education you provided.  \\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 21 Aug 2024 09:49:35 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrections made. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Peter Kasameyer\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/15/2024 09:45 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/12/2024 @ 04:33 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Delise for 08/15/2024 @ 9:45AM in Gainesville\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005722563001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0005722563001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0005722563001\", \"scheduleDate\": \"2024-8-15T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 16:33:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"08-12-2024 16:34:00\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-08-28 11:18:56\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"d7d23083-6550-11ef-bd3a-db7a543490c4\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-8-15T09:45', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:24', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005722563001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005722563001_Kasameyer, Peter_08152024.pdf\", \"ftp_upload_date\": \"2024-08-28 11:18:55\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP__0005722563001_08152024.pdf\"}', 'ACA_0005722563001_Kasameyer, Peter_08152024', NULL, 'PCP__0005722563001_08152024', NULL, '[{\"date\": \"2024-08-16T18:47:34.351Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}, {\"date\": \"2024-08-21T09:49:34.957Z\", \"signature\": \"data:image/png;base64,[encoded data, 23480 characters]\"}]', '2024-08-15T10:45', 'Member_Summary_0005722563001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005722563001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005722563001.pdf\", \"member_ftp_upload_date\": \"2024-08-28 11:18:57\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3010, 57818338, 44829497, '56716210', '0005724357001', '364481', '', '99038484', 'Delma', 'Moran', '', '{\"DOB\": 26483, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Gainesville\", \"Pcp_Name\": \"Ernie Aldaco\", \"Rank_All\": \"\", \"PCP_Phone\": \"7702870290\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"Medlink\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-07-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"520 JESSE JEWELL PKWY SE\", \"Screening_IHA\": \"No\", \"member_id_two\": 364481, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7067882936\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2534 Mango Ct\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30504, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2534 Mango Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Ethnicity\": \"White\", \"Member_Last_name\": \"Moran\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Delma\", \"Member_Middle_name\": \"Luz\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"delmamoran@gmail.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7709120101, \"Member_Identification_Number\": \"0005724357001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-17-2024 14:05:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-17 14:05:13\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-20T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-05T22:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-09T20:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-10T14:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-17T14:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-23T11:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-12T16:36\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T16:36\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-23T11:31\", \"reportStatus_date\": \"2024-08-23T11:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 7, \"hraStatus_date\": \"2024-09-09T20:29\", \"reportStatus_date\": \"2024-09-09T20:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-10T14:47\", \"reportStatus_date\": \"2024-09-10T14:47\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-17T14:05\", \"reportStatus_date\": \"2024-09-17T14:05\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-17T14:05\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-23T11:31\", \"username\": null}, {\"date\": \"2024-08-23T11:31\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T00:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-09-06T09:28\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-09-05T22:31\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-05T22:31\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-10T14:47\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-09T20:29\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-10T14:47\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-11-2024\", \"time\": \"16:29:03\", \"value\": [{\"add\": \"2534 Mango Ct\", \"age\": 52, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-07-03\", \"eno\": \"6786898408\", \"lob\": \"On Exchange\", \"pno\": 7709120101, \"zip\": 30504, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0005724357001\", \"mzip\": 30504, \"name\": \"Delma Luz Moran\", \"plan\": \"Alliant\", \"pphy\": \"Ernie Aldaco\", \"ppno\": \"7702870290\", \"race\": \"\", \"cliId\": \"\", \"email\": \"delmamoran@gmail.com\", \"ename\": \"James Moran\", \"madd1\": \"2534 Mango Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"520 JESSE JEWELL PKWY SE\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Gainesville\", \"pcpname\": \"Medlink\", \"program\": \"ACA\", \"evalDate\": \"2024-9-5 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7067882936\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"]], \"comment\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]}, \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-04-2024\", \"time\": \"13:24:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-11-2024 16:29:03\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/23/2024 @ 11:31 AM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Delise Adams on 9/5 at 8am. No special instructions were given\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 03:25 PM\", \"result\": 1, \"comment\": \"Call answered but no sound on call. Call to schedule a HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/21/2024 @ 03:25 PM\"}, {\"date\": \"8/12/2024 @ 04:36 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Delise but member requested a call back.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/19/2024 @ 04:35 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005724357001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0005724357001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0005724357001\", \"scheduleDate\": \"2024-9-5T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 16:36:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"08-23-2024 11:31:24\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-09-17 14:05:12\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"62239686-751f-11ef-88af-ef3ccac66320\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-9-5T08:00', '2024-12-31', '2024-09-05T08:30', NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:24', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005724357001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005724357001_Moran, Delma_09052024.pdf\", \"ftp_upload_date\": \"2024-09-17 14:05:11\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Aldaco, Ernie_0005724357001_09052024.pdf\"}', 'ACA_0005724357001_Moran, Delma_09052024', NULL, 'PCP_Aldaco, Ernie_0005724357001_09052024', NULL, '[{\"date\": \"2024-09-06T02:31:06.765Z\", \"signature\": \"data:image/png;base64,[encoded data, 23472 characters]\"}]', '2024-09-05T11:00', 'Member_Summary_0005724357001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005724357001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005724357001.pdf\", \"member_ftp_upload_date\": \"2024-09-17 14:05:13\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3011, 71932120, 44829497, '96917241', '0005731399001', '372924', '', '99038484', 'Aleatha', 'Cassetta', '', '{\"DOB\": 21330, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1649263955, \"Pcp_Zip\": \"30534\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"DAWSONVILLE\", \"Pcp_Name\": \"Nabil Keith\", \"Rank_All\": \"\", \"PCP_Phone\": \"7062164444\", \"Pcp_State\": \"GA\", \"Member_City\": \"Dawsonville\", \"Office_Name\": \"Keith Family Medicine\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1958-05-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"150 Northside Dawson Drive\", \"Screening_IHA\": \"No\", \"member_id_two\": 372924, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"7064291140\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"331 Grant Ford Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"331 Grant Ford Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cassetta\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Aleatha\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"aleathaokon@gmail.com\", \"Member_Suspect_Codes\": \"142, 21, 37.1\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 8633078020, \"Member_Identification_Number\": \"0005731399001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'1', '{\"date\": \"11-05-2024 11:33:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-11-05 11:33:57\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-13T10:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-11T11:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-10-26T09:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-30T09:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-30T13:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-05T11:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-09T11:37\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-10-14T12:06\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-10-21T10:28\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-08-12T13:18\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-10-10T15:20\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-08-12T13:18\", \"reportStatus_date\": \"2024-08-12T13:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-13T10:06\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-11T11:36\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-14T12:06\", \"reportStatus_date\": \"2024-10-14T12:06\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-21T10:28\", \"reportStatus_date\": \"2024-10-21T10:28\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-10-26T09:52\", \"reportStatus_date\": \"2024-10-26T09:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-10-30T13:50\", \"reportStatus_date\": \"2024-10-30T13:50\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-11-05T11:33\", \"reportStatus_date\": \"2024-11-05T11:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-12T13:18\", \"username\": \"JHelm\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-05T11:33\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-09T11:37\", \"username\": null}, {\"date\": \"2024-08-09T11:37\", \"username\": null}, {\"date\": \"2024-10-14T12:06\", \"username\": null}, {\"date\": \"2024-10-14T12:06\", \"username\": null}, {\"date\": \"2024-10-21T10:28\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-26T09:13\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-10-28T09:12\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-10-26T09:52\", \"username\": \"NCox\"}, {\"date\": \"2024-10-26T09:52\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-10-30T13:50\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-10-30T09:56\", \"username\": \"MJoseph\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-10-30T13:50\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-14-2025\", \"time\": \"11:28:31\", \"value\": [{\"add\": \"331 Grant Ford Dr\", \"age\": 66, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-05-25\", \"eno\": \"8459887851\", \"lob\": \"On Exchange\", \"pno\": 8633078020, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0005731399001\", \"mzip\": 30534, \"name\": \"Aleatha Cassetta\", \"plan\": \"Alliant\", \"pphy\": \"Nabil Keith\", \"ppno\": \"7062164444\", \"race\": \"\", \"cliId\": \"\", \"email\": \"aleathaokon@gmail.com\", \"ename\": \"Angela Ottilo\", \"madd1\": \"331 Grant Ford Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"150 Northside Dawson Drive\", \"pcpnpi\": \"\", \"pcpzip\": \"30534\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"DAWSONVILLE\", \"pcpname\": \"Keith Family Medicine\", \"program\": \"ACA\", \"evalDate\": \"2024-10-26 09:00 AM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"7064291140\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"10-21-2024\", \"time\": \"10:29:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-14-2025 11:28:31\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-08-12T13:18\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"JHelm\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/14/2024 @ 12:06 PM\", \"result\": 0, \"comment\": \"Scheduled Nykya C on 10/26 @ 9:00 - member will use their iPad and texted doxy link to member. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/10/2024 @ 03:20 PM\", \"result\": 6, \"comment\": \"Member requested a call back - morning - call attempt to schedule an HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 10:00 AM\"}, {\"date\": \"9/11/2024 @ 11:36 AM\", \"result\": 3, \"comment\": \"Call attempt to reschedule an HRA - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/12/2024 @ 11:36 AM\"}, {\"date\": \"8/13/2024 @ 10:06 AM\", \"result\": 3, \"comment\": \"Called to Reschedule Virtual HRA with Delise no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/20/2024 @ 10:06 AM\"}, {\"date\": \"8/9/2024 @ 11:37 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Jansen for 08/12/2024 @ 11:30AM via Doxy.me\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005731399001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0005731399001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0005731399001\", \"scheduleDate\": \"2024-10-26T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 11:37:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}, {\"date\": \"08-12-2024 13:18:10\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"10-21-2024 10:28:33\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-11-05 11:33:54\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"bf06db8e-9b93-11ef-9947-116fc8b264c9\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-10-26T09:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:25', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005731399001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005731399001_Cassetta, Aleatha_10262024.pdf\", \"ftp_upload_date\": \"2024-11-05 11:33:53\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Dr. Keith_0005731399001_10262024.pdf\"}', 'ACA_0005731399001_Cassetta, Aleatha_10262024', NULL, 'PCP_, Dr. Keith_0005731399001_10262024', NULL, '[{\"date\": \"2024-10-26T13:52:48.393Z\", \"signature\": \"data:image/png;base64,[encoded data, 25520 characters]\"}]', '2024-10-26T09:52', 'Member_Summary_0005731399001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005731399001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005731399001.pdf\", \"member_ftp_upload_date\": \"2024-11-05 11:33:56\"}', NULL, NULL, NULL, NULL),
(3012, NULL, NULL, NULL, '0005731529001', '376418', '', '21881792', 'Timmy', 'Johns', '', '{\"DOB\": 28872, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Pelham\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Pelham\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1979-01-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 376418, \"Mailing_County\": \"MITCHELL\", \"Member_Country\": \"MITCHELL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"574 WADE RD\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31779, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"574 WADE RD\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31779, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Johns\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Timmy\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bitleejohns@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2295890492, \"Member_Identification_Number\": \"0005731529001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:28\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-13T13:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-27T12:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-09-30T16:40\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-09T17:48\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T17:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T13:13\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T16:40\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:25\", \"value\": [{\"add\": \"574 WADE RD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1979-01-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2295890492, \"zip\": 31779, \"add2\": \"\", \"add3\": \"\", \"city\": \"Pelham\", \"gend\": 0, \"insh\": \"0005731529001\", \"mzip\": 31779, \"name\": \"Timmy Johns\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bitleejohns@gmail.com\", \"ename\": \"\", \"madd1\": \"574 WADE RD\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Pelham\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:25\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"9/30/2024 @ 04:40 PM\", \"result\": 4, \"comment\": \"Call attempt to schedule an HRA - Wrong number\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"9/27/2024 @ 12:55 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/30/2024 @ 12:55 PM\"}, {\"date\": \"9/13/2024 @ 01:13 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/16/2024 @ 01:13 PM\"}, {\"date\": \"8/9/2024 @ 05:48 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a virtual HRA w/ Faith Enwefah.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/12/2024 @ 05:48 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 17:48:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"09-30-2024 16:40:36\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3013, NULL, NULL, NULL, '0005732479001', '354426', '', '21881792', 'Matthew', 'Bradford', '', '{\"DOB\": 33189, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dahlonega\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1990-11-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 354426, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1389 River Flow Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 305330000, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1389 River Flow Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bradford\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Matthew\", \"Member_Middle_name\": \"Erik\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"erikbradford2010@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6784783612, \"Member_Identification_Number\": \"0005732479001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:28\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-07T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T16:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T15:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-10T13:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-10-11T17:50\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-07T15:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-23T15:23\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-11T17:50\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:26\", \"value\": [{\"add\": \"1389 River Flow Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1990-11-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6784783612, \"zip\": 305330000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0005732479001\", \"mzip\": 30533, \"name\": \"Matthew Erik Bradford\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"erikbradford2010@yahoo.com\", \"ename\": \"\", \"madd1\": \"1389 River Flow Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 11:00 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:13 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/11/2024 @ 05:50 PM\", \"result\": 6, \"comment\": \"Member requested a call back at 9 when he is free - most days not free until the weekends. Did not have time to discuss the HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/14/2024 @ 09:00 AM\"}, {\"date\": \"10/10/2024 @ 01:16 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 01:16 PM\"}, {\"date\": \"8/23/2024 @ 03:23 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams MAILBOX FULL \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/3/2024 @ 03:23 PM\"}, {\"date\": \"8/22/2024 @ 04:38 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Delise Adams. - Mailbox Full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 04:38 PM\"}, {\"date\": \"8/7/2024 @ 03:25 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/8/2024 @ 03:25 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-07-2024 15:25:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:41:39\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3014, NULL, NULL, NULL, '0005739835001', '381912', '', '47262451', 'Jesse', 'Peacock', '', '{\"DOB\": 32695, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Fitzgerald\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Fitzgerald\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1989-07-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 381912, \"Mailing_County\": \"BEN HILL\", \"Member_Country\": \"BEN HILL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"509 Broxton Hwy\", \"Member_Address2\": \"apt 6\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31750, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"509 Broxton Hwy\", \"Mailing_Address2\": \"apt 6\", \"Mailing_Zip_Code\": 31750, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Peacock\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jesse\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jethropeacock@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294579866, \"Member_Identification_Number\": \"0005739835001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:28\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T15:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-15T18:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-12T13:35\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T15:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-15T18:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-12T13:35\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:52\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:26\", \"value\": [{\"add\": \"509 Broxton Hwy\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1989-07-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294579866, \"zip\": 31750, \"add2\": \"apt 6\", \"add3\": \"\", \"city\": \"Fitzgerald\", \"gend\": 0, \"insh\": \"0005739835001\", \"mzip\": 31750, \"name\": \"Jesse Peacock\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"jethropeacock@gmail.com\", \"ename\": \"\", \"madd1\": \"509 Broxton Hwy\", \"madd2\": \"apt 6\", \"madd3\": \"\", \"mcity\": \"Fitzgerald\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 03:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/12/2024 @ 01:35 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - Mailbox Full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/13/2024 @ 01:35 PM\"}, {\"date\": \"8/15/2024 @ 06:34 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"8/22/2024 @ 06:34 PM\"}, {\"date\": \"8/9/2024 @ 03:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/12/2024 @ 03:27 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 15:27:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"11-11-2024 00:52:51\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3015, NULL, NULL, NULL, '0005749359001', '357363', '', '84929813', 'Sydnie', 'Brown', '', '{\"DOB\": 36203, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Fort Oglethorpe\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Fort Oglethorpe\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1999-02-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 357363, \"Mailing_County\": \"CATOOSA\", \"Member_Country\": \"CATOOSA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"106 S Stovall St\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30742, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"106 S Stovall St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30742, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sydnie\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"sydniebrown0212@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4232982153, \"Member_Identification_Number\": \"0005749359001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:28\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T16:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T18:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-01T15:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T13:56\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T16:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T18:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-01T15:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T13:56\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:26\", \"value\": [{\"add\": \"106 S Stovall St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1999-02-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4232982153, \"zip\": 30742, \"add2\": \"\", \"add3\": \"\", \"city\": \"Fort Oglethorpe\", \"gend\": 1, \"insh\": \"0005749359001\", \"mzip\": 30742, \"name\": \"Sydnie L Brown\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"sydniebrown0212@icloud.com\", \"ename\": \"\", \"madd1\": \"106 S Stovall St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Fort Oglethorpe\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 09:33 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 01:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 01:56 PM\"}, {\"date\": \"10/1/2024 @ 03:57 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - No VM setup. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/2/2024 @ 03:57 PM\"}, {\"date\": \"8/22/2024 @ 06:04 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer No VM Setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/29/2024 @ 06:04 PM\"}, {\"date\": \"8/14/2024 @ 04:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/21/2024 @ 04:47 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 16:47:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"11-11-2024 00:48:03\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3016, NULL, NULL, NULL, '0005753371001', '367101', '', '21881792', 'Rebecca', 'Childers Sweany', '', '{\"DOB\": 21868, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dahlonega\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-11-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 367101, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"517 Rock Chimney Lane\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"517 Rock Chimney Lane\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Childers Sweany\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rebecca\", \"Member_Middle_name\": \"Arnette\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"customfenceofatlanta@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7706166084, \"Member_Identification_Number\": \"0005753371001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"11-22-2024 23:30:21\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"11-22-2024 23:30:21\", \"hrastatus\": \"\", \"reportstatus\": \"Termed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-11T17:54\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-07T15:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T16:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T15:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-10T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-11T17:54\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-07T15:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-23T15:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-11T17:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:27\", \"value\": [{\"add\": \"517 Rock Chimney Lane\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-11-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7706166084, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 1, \"insh\": \"0005753371001\", \"mzip\": 30533, \"name\": \"Rebecca Arnette Childers Sweany\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"customfenceofatlanta@gmail.com\", \"ename\": \"\", \"madd1\": \"517 Rock Chimney Lane\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:27\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/11/2024 @ 05:54 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/10/2024 @ 01:21 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 01:21 PM\"}, {\"date\": \"8/23/2024 @ 03:24 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Delise Adams 9/13. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 03:24 PM\"}, {\"date\": \"8/22/2024 @ 04:39 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"8/29/2024 @ 04:38 PM\"}, {\"date\": \"8/7/2024 @ 03:29 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/8/2024 @ 03:29 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-07-2024 15:29:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-11-2024 17:54:55\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', '{\"orderType\": 0, \"sortOrder\": 1730441224}', 1, NULL, NULL, NULL, NULL, '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3017, NULL, NULL, NULL, '0005754769001', '362047', '', '84929813', 'Teresa', 'McAllister', '', '{\"DOB\": 24786, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Chatsworth\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-11-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 362047, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"328 Big Oak Street\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30705, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"328 Big Oak Street\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"McAllister\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Teresa\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"teresaseawrighht@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7623441083, \"Member_Identification_Number\": \"0005754769001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:35:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-29T10:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-12T14:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-20T13:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T13:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T13:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-29T10:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T14:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T13:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T13:57\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-29T10:55\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:27\", \"value\": [{\"add\": \"328 Big Oak Street\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-11-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7623441083, \"zip\": 30705, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 1, \"insh\": \"0005754769001\", \"mzip\": 30705, \"name\": \"Teresa McAllister\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"teresaseawrighht@gmail.com\", \"ename\": \"\", \"madd1\": \"328 Big Oak Street\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:27\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 10:55 AM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 01:57 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 01:57 PM\"}, {\"date\": \"8/22/2024 @ 01:05 PM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Debbie , dead air.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/29/2024 @ 01:05 PM\"}, {\"date\": \"8/20/2024 @ 01:31 PM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Connie , dead air.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/27/2024 @ 01:31 PM\"}, {\"date\": \"8/12/2024 @ 02:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/19/2024 @ 02:13 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 14:13:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"10-29-2024 10:55:51\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3018, NULL, NULL, NULL, '0005756153002', '369775', '', NULL, 'Michal', 'Puckett', '', '{\"DOB\": 28337, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dahlonega\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-07-31\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 369775, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"89 Springwood Way\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"89 Springwood Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Puckett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michal\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0005756153002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:27\", \"value\": [{\"add\": \"89 Springwood Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-07-31\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0005756153002\", \"mzip\": 30533, \"name\": \"Michal Puckett\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"89 Springwood Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:27\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:31:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3019, NULL, NULL, NULL, '0005762346002', '368242', '', NULL, 'Ashley', 'Lawing', '', '{\"DOB\": 31931, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1987-06-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 368242, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4609 Union Pl\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"4609 Union Pl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Lawing\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ashley\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0005762346002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:28\", \"value\": [{\"add\": \"4609 Union Pl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1987-06-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 1, \"insh\": \"0005762346002\", \"mzip\": 30542, \"name\": \"Ashley Lawing\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"4609 Union Pl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:28\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:31:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3020, NULL, NULL, NULL, '0005768312001', '384876', '', '26605185', 'Toni', 'Crane', '', '{\"DOB\": 21868, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1386619526, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"BRASELTON\", \"Pcp_Name\": \"ROBERT KELLY\", \"Rank_All\": \"\", \"PCP_Phone\": 6783436195, \"Pcp_State\": \"GA\", \"Member_City\": \"Clarkesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Turnerville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-11-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"1515 RIVER PL STE 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 384876, \"Mailing_County\": \"\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"115 Chiefton Trl\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"po box 215\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30580, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Crane\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Toni\", \"Member_Middle_name\": \"Joyce\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"twhemc@yahoo.com\", \"Member_Suspect_Codes\": \"130, 160, 161.1, 184, 188, 20, 21, 23, 74\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069684035, \"Member_Identification_Number\": \"0005768312001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"11-22-2024 23:30:21\", \"text\": \"Termed\", \"method\": \"api\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-11-22 23:30:21\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-11-11T00:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-30T10:30\", \"username\": null}, {\"date\": \"2024-08-30T10:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T20:00\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T11:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-19T10:52\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:28\", \"value\": [{\"add\": \"115 Chiefton Trl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-11-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069684035, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 1, \"insh\": \"0005768312001\", \"mzip\": 30580, \"name\": \"Toni Joyce Crane\", \"plan\": \"Alliant\", \"pphy\": \"ROBERT KELLY\", \"ppno\": 6783436195, \"cliId\": \"\", \"email\": \"twhemc@yahoo.com\", \"ename\": \"\", \"madd1\": \"po box 215\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Turnerville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1515 RIVER PL STE 100\", \"pcpnpi\": 1386619526, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"BRASELTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:28\"}', NULL, NULL, NULL, 'null', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"10-29-2024 11:07:00\", \"schedulerId\": \"26605185\", \"schedulerLeadId\": \"26605185\"}]}', '{\"date\": \"08-08-2024 00:31:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', 'null', '{\"orderType\": 0, \"sortOrder\": 1730354824}', 1, NULL, NULL, NULL, NULL, '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3021, NULL, NULL, NULL, '0005773041001', '385947', '', '33985161', 'Amanda', 'Elliott', '', '{\"DOB\": 30886, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Macon\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-07-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 385947, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1777 Houston ave\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31201, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1777 Houston ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31201, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Elliott\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Amanda\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"the.roofer.pro@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4787140484, \"Member_Identification_Number\": \"0005773041001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:35:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:35:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-13T14:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-16T16:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-29T18:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:05\", \"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\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-16T16:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T18:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:05\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:27:29\", \"value\": [{\"add\": \"1777 Houston ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-07-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4787140484, \"zip\": 31201, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 1, \"insh\": \"0005773041001\", \"mzip\": 31201, \"name\": \"Amanda Elliott\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"the.roofer.pro@gmail.com\", \"ename\": \"\", \"madd1\": \"1777 Houston ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:27:29\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:27:29\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/19/2024 @ 04:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 09:26 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 09:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 09:44 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 09:59 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/9/2024 @ 10:18 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 12:37 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 11:11 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/03/2024 @ 09:30 AM\"}, {\"date\": \"8/29/2024 @ 06:10 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/5/2024 @ 06:09 PM\"}, {\"date\": \"8/16/2024 @ 04:18 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/22/2024 @ 04:18 PM\"}, {\"date\": \"8/13/2024 @ 02:35 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/14/2024 @ 02:35 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 14:35:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"12-16-2024 01:05:08\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `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`) VALUES
(3022, 3285757, 44829497, '62685179', '0005777269001', '391916', '', '33985161', 'KELSEE', 'POUNDS', '', '{\"DOB\": 38107, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1548743727, \"Pcp_Zip\": \"31061\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"MILLEDGEVILLE\", \"Pcp_Name\": \"Katlyn Taylor Hogg, NP\", \"Rank_All\": \"\", \"PCP_Phone\": \"4784530662\", \"Pcp_State\": \"GA\", \"Member_City\": \"McIntyre\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"McIntyre\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2004-04-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2803 N COLUMBIA ST UNIT D\", \"Screening_IHA\": \"No\", \"member_id_two\": 391916, \"Mailing_County\": \"WILKINSON\", \"Member_Country\": \"WILKINSON\", \"PCP_Fax_Number\": \"4784528067\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"112 Vinson Rd\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31054, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"112 Vinson Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31054, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"POUNDS\", \"Medication_Review\": \"N\", \"Member_first_name\": \"KELSEE\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"161.2, 56, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"4784569724\", \"Member_Identification_Number\": \"0005777269001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"4784566866\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'1', '{\"date\": \"10-15-2024 12:13:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-15 12:13:07\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-10-05T18:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-13T22:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-14T01:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-15T12:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-29T18:25\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-09-20T11:14\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-09-30T10:59\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-09-27T13:51\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-09-20T11:14\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-09-30T08:52\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-08-13T14:43\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-13T14:43\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-29T18:25\", \"reportStatus_date\": \"2024-08-29T18:25\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-09-20T11:14\", \"reportStatus_date\": \"2024-09-20T11:14\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-09-30T10:59\", \"reportStatus_date\": \"2024-09-30T10:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-10-05T18:56\", \"reportStatus_date\": \"2024-10-05T18:56\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-10-14T01:44\", \"reportStatus_date\": \"2024-10-14T01:44\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-15T12:13\", \"reportStatus_date\": \"2024-10-15T12:13\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-30T08:52\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-15T12:13\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-29T18:25\", \"username\": null}, {\"date\": \"2024-08-29T18:25\", \"username\": null}, {\"date\": \"2024-09-20T11:14\", \"username\": null}, {\"date\": \"2024-09-27T13:51\", \"username\": null}, {\"date\": \"2024-09-27T13:51\", \"username\": null}, {\"date\": \"2024-09-30T10:59\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-19T07:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-10-03T08:52\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-10-07T11:29\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-10-05T18:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-10-05T18:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-10-10T08:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-10-12T16:30\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-10-14T01:44\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-10-13T22:04\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-10-14T01:44\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-10-08T00:20\", \"username\": \"BClark\"}, {\"date\": \"2024-10-11T14:07\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-20T11:14\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-07-2025\", \"time\": \"10:42:48\", \"value\": [{\"add\": \"112 Vinson Rd\", \"age\": 20, \"ano\": \"\", \"cno\": \"4784566866\", \"dob\": \"2004-04-30\", \"eno\": \"4784566866\", \"lob\": \"On Exchange\", \"pno\": \"4784569724\", \"zip\": 31054, \"add2\": \"\", \"add3\": \"\", \"city\": \"McIntyre\", \"gend\": 1, \"insh\": \"0005777269001\", \"mzip\": 31054, \"name\": \"KELSEE POUNDS\", \"plan\": \"Alliant\", \"pphy\": \"Katlyn Taylor Hogg, NP\", \"ppno\": \"4784530662\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Tasha Pounds\", \"madd1\": \"112 Vinson Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"McIntyre\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2803 N COLUMBIA ST UNIT D\", \"pcpnpi\": 1548743727, \"pcpzip\": \"31061\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"MILLEDGEVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"4784528067\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"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\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-19-2024\", \"time\": \"07:35:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-07-2025 10:42:48\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-09-30T08:52\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-09-20T11:14\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": \"0\"}]}', NULL, '{\"memberId\": \"0005777269001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Tue, 08 Oct 2024 04:20:11 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThank you for your thorough assessment!\\n\\n1) Under medication compliance, it is marked that member does not have enough money to buy medication, can you please add a comment\\n2) Under assessment of dx, asthma is marked that member takes an oral steroid, I don\'t see this on the med list, can you please update\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 10 Oct 2024 12:54:03 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Hi Brianne,\\nResolved.\\nThank you\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 11 Oct 2024 18:07:36 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Thank you for your updates! \\nUnder the assessment of dx, asthma, can you just add a comment of \\\"neither\\\" since member does not take an oral steroid or use rescue inhaler 2x a week\\nThanks :)\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 12 Oct 2024 20:30:19 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved,\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"KELSEE POUNDS\", \"codingAnalyst\": \"\", \"dateOfService\": \"10/03/2024 02:30 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"9/27/2024 @ 01:51 PM\", \"result\": 12, \"comment\": \"Rescheduled virtual HRA w/ Faith -10/3 @ 2:30 - texted doxy link to member. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/29/2024 @ 06:25 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Faith for 09/19/2024 @ 11:30AM via doxy.me. Sent text and email with appointment information. Text was sent to 478-456-6866. Confirmed text was received. Sent email to kelseeelaine@gmail.com\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/13/2024 @ 02:43 PM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED - Member not available.  Call attempt to schedule a HRA w/ Nykya Cox per Tasha her mother also provided a new number for Kelsee\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/14/2024 @ 04:43 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005777269001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0005777269001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0005777269001\", \"scheduleDate\": \"2024-10-3T13:49\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 14:43:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}, {\"date\": \"09-20-2024 11:14:22\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}, {\"date\": \"09-30-2024 08:52:40\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"09-30-2024 10:59:24\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', '{\"orderType\": 1, \"sortOrder\": 1727700760}', 0, NULL, '[{\"date\": \"2024-10-15 12:13:05\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"5c53d4f2-8b10-11ef-bbdc-fdf1472b4c99\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-10-3T14:30', '2024-12-31', '2024-10-03T14:30', NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:27:29', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005777269001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005777269001_POUNDS, KELSEE_10032024.pdf\", \"ftp_upload_date\": \"2024-10-15 12:13:05\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Hogg, Katlyn_0005777269001_10032024.pdf\"}', 'ACA_0005777269001_POUNDS, KELSEE_10032024', NULL, 'PCP_Hogg, Katlyn_0005777269001_10032024', NULL, '[{\"date\": \"2024-10-05T22:56:41.152Z\", \"signature\": \"data:image/png;base64,[encoded data, 23384 characters]\"}, {\"date\": \"2024-10-10T12:54:02.992Z\", \"signature\": \"data:image/png;base64,[encoded data, 23376 characters]\"}, {\"date\": \"2024-10-12T20:30:18.744Z\", \"signature\": \"data:image/png;base64,[encoded data, 23392 characters]\"}]', '2024-10-03T15:30', 'Member_Summary_0005777269001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005777269001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005777269001.pdf\", \"member_ftp_upload_date\": \"2024-10-15 12:13:06\"}', NULL, NULL, NULL, NULL);
