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
(1939, NULL, NULL, NULL, '0006731005001', '413533', '', '2661185', 'Edrick', 'Jordan', '', '{\"DOB\": 27577, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Warner Robins\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warner Robins\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-07-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413533, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"100 ROBINS WEST PKWY\", \"Member_Address2\": \"APT 101\", \"Member_Zip_Code\": 31088, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"100 ROBINS WEST PKWY\", \"Mailing_Address2\": \"APT 101\", \"Mailing_Zip_Code\": 31088, \"Member_Last_name\": \"Jordan\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Edrick\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ejordan75@aol.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 3057335266, \"Member_Identification_Number\": \"0006731005001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T19:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-31T18:16\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T17:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T17:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-06-12T17:48\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-15T19:31\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T17:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T17:50\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T19:31\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-31T18:16\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:36\", \"value\": [{\"add\": \"100 ROBINS WEST PKWY\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-07-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 3057335266, \"zip\": 31088, \"add2\": \"APT 101\", \"add3\": \"\", \"city\": \"Warner Robins\", \"gend\": 0, \"insh\": \"0006731005001\", \"mzip\": 31088, \"name\": \"Edrick Jordan\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ejordan75@aol.com\", \"ename\": \"\", \"madd1\": \"100 ROBINS WEST PKWY\", \"madd2\": \"APT 101\", \"madd3\": \"\", \"mcity\": \"Warner Robins\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"11/6/2024 @ 05:52 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:16 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:04 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 07:26 PM\", \"result\": 7, \"comment\": \"Called to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 07:31 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 07:31 PM\"}, {\"date\": \"6/12/2024 @ 05:48 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 05:48 PM\"}, {\"date\": \"6/10/2024 @ 02:50 PM\", \"result\": 3, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/14/2024 @ 02:49 PM\"}, {\"date\": \"4/29/2024 @ 05:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/30/2024 @ 05:22 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 17:22:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-31-2024 18:16:27\", \"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', '21-04-2024 06:01:36', 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
(1940, 57818338, 44829497, '56716210', '0006732199001', '413759', '', '26056802', 'bennly', 'jeanlouis', '', '{\"DOB\": 29783, \"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\": \"1\", \"Pcp_City\": \"Gainesville\", \"Pcp_Name\": \"Dr. David Hocker\", \"PCP_Phone\": \"7705361004\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-07-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1990 Limestone Circle Suite 370\", \"Screening_IHA\": \"No\", \"member_id_two\": 413759, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7705360905\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"602 NORTH POINTE DR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"602 NORTH POINTE DR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"jeanlouis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"bennly\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"edwidge0626@gmail.com\", \"Member_Suspect_Codes\": 130, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7726260188, \"Member_Identification_Number\": \"0006732199001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:37:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:37:19\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-22T21:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-24T16:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-27T01:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-15T18:43\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-20T17:45\", \"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-04-25T15:20\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-20T17:45\", \"reportStatus_date\": \"2024-05-20T17:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-27T01:34\", \"reportStatus_date\": \"2024-05-27T01:34\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:37\", \"reportStatus_date\": \"2024-05-31T14:37\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:37\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-15T18:43\", \"username\": null}, {\"date\": \"2024-05-15T18:43\", \"username\": null}, {\"date\": \"2024-05-20T17:45\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-21T05:42\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-05-23T07:58\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-21T05:45\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:27\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:37\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:49\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:57\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T12:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:04\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:09\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:21\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:22\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:25\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T13:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-21T14:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T03:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T03:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T03:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T04:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T04:04\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T04:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T04:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T04:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:37\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:46\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:49\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T06:55\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:01\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:04\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:07\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:10\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:13\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T07:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T13:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T19:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T19:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T19:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T19:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T19:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:07\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:52\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T20:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:31\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:49\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:51\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:51\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T21:51\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-23T11:57\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-23T12:00\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-23T15:48\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-27T01:34\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-24T16:12\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-27T01:34\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-23T12:01\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-23T15:47\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"15:06:27\", \"value\": [{\"add\": \"602 NORTH POINTE DR\", \"age\": 42, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1981-07-16\", \"eno\": \"7726260188\", \"lob\": \"On Exchange\", \"pno\": 7726260188, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0006732199001\", \"mzip\": 30501, \"name\": \"bennly jeanlouis\", \"plan\": \"Alliant\", \"pphy\": \"Dr. David Hocker\", \"ppno\": \"7705361004\", \"race\": \"\", \"cliId\": \"\", \"email\": \"edwidge0626@gmail.com\", \"ename\": \"Edwidge Jeanlouis\", \"madd1\": \"602 NORTH POINTE DR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1990 Limestone Circle Suite 370\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"Gainesville\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-5-21 11:30 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7705360905\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]], \"comment\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"Haitian creole\"]]}, \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Christian- pray to God only\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-17-2024\", \"time\": \"17:24:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-09-2024 13:24:54\"}', NULL, NULL, '{\"memberId\": \"0006732199001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 23 May 2024 16:01:34 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  ADL section reports 1 for all scores.  Is member able to preform all activities independently  r/t  left sided hemiparesis?\\n2.  AOD Neuropsych section hemiparesis ?  please select side.\\n3.  AOD Endocrine section please answer the met with nurse dietician or DM educator ?.\\nThanks \\nJudi\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 23 May 2024 19:48:45 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Yes\\n2. Corrected\\n3. As I\'m correcting this, I realized that I forgot to add nutritionist referral. Will add and resubmit the CM referral form. \\n\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"bennly jeanlouis\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/21/2024 12:15 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/15/2024 @ 06:43 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Delise Adas on 5/21 - 8am - 12pm - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/25/2024 @ 03:20 PM\", \"result\": 3, \"comment\": \"LS first call attempt\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:19 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006732199001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006732199001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006732199001\", \"scheduleDate\": \"2024-5-21T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 18:43:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-20-2024 17:45:38\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:37:17\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"e67ca639-3ad9-47dc-91d6-1ac1516726df\\\",\\\"destination_fax_number\\\":\\\"17705360905\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"transaction_id\\\":\\\"6254bee6-f5b2-11f0-88e4-5d6aa08b7dff\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"UNAUTHORIZED\\\",\\\"developer_message\\\":\\\"Access token expired\\\",\\\"user_message\\\":\\\"Authentication token is expired.\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 401}}]', 'In Person', '2024-5-21T11:30', '2024-12-31', '2024-05-21T12:15', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:36', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006732199001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006732199001_jeanlouis, bennly_05212024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:37:16\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Hocker, David_0006732199001_05212024.pdf\"}', 'ACA_0006732199001_jeanlouis, bennly_05212024', NULL, 'PCP_Hocker, David_0006732199001_05212024', NULL, '[{\"date\": \"2024-05-23T01:51:48.134Z\", \"signature\": \"data:image/png;base64,[encoded data, 23448 characters]\"}, {\"date\": \"2024-05-23T19:48:44.737Z\", \"signature\": \"data:image/png;base64,[encoded data, 23492 characters]\"}]', '2024-05-21T13:55', 'Member_Summary_0006732199001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006732199001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006732199001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:37:19\"}', 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
(1941, NULL, NULL, NULL, '0006733460001', '406194', '', '26056802', 'Carlie', 'Black', '', '{\"DOB\": 33664, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Clermont\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clermont\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-03-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406194, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5633 Cottage Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30527, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5633 Cottage Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30527, \"Member_Last_name\": \"Black\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carlie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 212, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9045365032, \"Member_Identification_Number\": \"0006733460001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T14:21\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T12:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T14:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T14:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:21\", \"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-06-20T14:27\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T12:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T14:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T14:04\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T14:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:21\"}]', '{\"utc\": [{\"date\": \"2024-07-29T18:26\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:37\", \"value\": [{\"add\": \"5633 Cottage Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-03-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9045365032, \"zip\": 30527, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clermont\", \"gend\": 1, \"insh\": \"0006733460001\", \"mzip\": 30527, \"name\": \"Carlie Black\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"5633 Cottage Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clermont\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 01:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/5/2024 @ 06:17 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Candace no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 05:12 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/24/2024 @ 03:07 PM\", \"result\": 3, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F: Mailbox Full \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 03:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 02:27 PM\", \"result\": 6, \"comment\": \"Call back, Carlie is just about to have a baby and needs some time because she isn\'t sure exactly when the baby is coming and will need a little bit after the baby comes to get settled. Scheduled call back for end of July. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/29/2024 @ 02:27 PM\"}, {\"date\": \"5/24/2024 @ 02:04 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 02:04 PM\"}, {\"date\": \"5/16/2024 @ 02:18 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 02:18 PM\"}, {\"date\": \"4/30/2024 @ 12:57 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 12:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 12:57:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-10-2024 14:21:02\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1942, NULL, NULL, NULL, '0006734724001', '415769', '', '26056802', 'Jordan', 'Ellis', '', '{\"DOB\": 29577, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Buford\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buford\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1980-12-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415769, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6000 Chimney Springs Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30518, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6000 Chimney Springs Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30518, \"Member_Last_name\": \"Ellis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jordan\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Jtellis2041@gmail.com\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 8033121855, \"Member_Identification_Number\": \"0006734724001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-26T18:38\", \"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-04-26T18:38\", \"reportStatus_date\": \"2024-04-26T18:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-26T18:38\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:37\", \"value\": [{\"add\": \"6000 Chimney Springs Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1980-12-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 8033121855, \"zip\": 30518, \"add2\": \"\", \"add3\": \"\", \"city\": \"Buford\", \"gend\": 0, \"insh\": \"0006734724001\", \"mzip\": 30518, \"name\": \"Jordan Ellis\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Jtellis2041@gmail.com\", \"ename\": \"\", \"madd1\": \"6000 Chimney Springs Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buford\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:04\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:04\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-26T18:38\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/26/2024 @ 06:38 PM\", \"result\": 9, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - Refused - Member stated he received the flyer but would like to call us back when he is ready \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 18:38:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:39\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1943, NULL, NULL, NULL, '0006736668001', '407885', '', '2661185', 'Kristi', 'Simmons', '', '{\"DOB\": 27744, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Leesburg\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Leesburg\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-12-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407885, \"Mailing_County\": \"LEE\", \"Member_Country\": \"LEE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"159A Crow Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31763, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"159A Crow Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31763, \"Member_Last_name\": \"Simmons\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kristi\", \"Member_Middle_name\": \"Sue\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"ksim37@yahoo.com\", \"Member_Suspect_Codes\": 130, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2292883723, \"Member_Identification_Number\": \"0006736668001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-06T18:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T13:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-07T14:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:39\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-06-03T09:54\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-05-29T09:23\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-05-30T14:55\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-02T19:29\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-14T17:39\", \"reportStatus_date\": \"2024-05-14T17:39\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-06-03T09:54\", \"reportStatus_date\": \"2024-06-03T09:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T18:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T13:09\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-07T14:25\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-29T09:23\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:39\", \"username\": null}, {\"date\": \"2024-05-14T17:39\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-03T09:54\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-16-2024\", \"time\": \"11:18:24\", \"value\": [{\"add\": \"159A Crow Dr\", \"age\": 48, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-12-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2292883723, \"zip\": 31763, \"add2\": \"\", \"add3\": \"\", \"city\": \"Leesburg\", \"gend\": 1, \"insh\": \"0006736668001\", \"mzip\": 31763, \"name\": \"Kristi Sue Simmons\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ksim37@yahoo.com\", \"ename\": \"\", \"madd1\": \"159A Crow Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Leesburg\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-16-2024\", \"time\": \"11:18:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-16-2024 11:18:24\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-29T09:23\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"SKey\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-03T09:54\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 01:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 10:02 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/7/2024 @ 02:25 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/14/2024 @ 02:25 PM\"}, {\"date\": \"7/2/2024 @ 07:29 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 07:28 PM\"}, {\"date\": \"7/1/2024 @ 01:09 PM\", \"result\": 13, \"comment\": \"Caller answered the call prior to and/or after greeting then disconnected the call.  Call attempt to reschedule a virtual HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 01:09 PM\"}, {\"date\": \"6/6/2024 @ 03:48 PM\", \"result\": 13, \"comment\": \"06/06/2024 JC: called for HRA-Faith Enwefah: caller hung up, \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/10/2024 @ 03:48 PM\"}, {\"date\": \"5/30/2024 @ 02:55 PM\", \"result\": 6, \"comment\": \"Member will need a call back in the later afternoon after 4:30. Attempt to reschedule virtual appt. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 04:30 PM\"}, {\"date\": \"5/14/2024 @ 05:39 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Sallie Key for 5/21/24 @ 4:30pm. Sent confirmation e-mail to ksim37@yahoo.com. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:39:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-29-2024 09:23:57\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-15-2024 05:41:35\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1944, NULL, NULL, NULL, '0006738043001', '407431', '', '26056802', 'Kristen', 'Minor', '', '{\"DOB\": 34572, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1994-08-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407431, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5460 Concord Circle\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30506, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5460 Concord Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"Minor\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kristen\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kristen.minor2024@gmail.com\", \"Member_Suspect_Codes\": \"37.1, 37.2, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7709409734, \"Member_Identification_Number\": \"0006738043001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"10-15-2024 00:30:10\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-10-15 00:30:10\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T11: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-05-15T18:48\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-06T19:57\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-11T12:26\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-02T15:27\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:19\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T18:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T11:01\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:57\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T12:26\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-02T15:27\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:37\", \"value\": [{\"add\": \"5460 Concord Circle\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1994-08-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7709409734, \"zip\": 30506, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006738043001\", \"mzip\": 30506, \"name\": \"Kristen Minor\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kristen.minor2024@gmail.com\", \"ename\": \"\", \"madd1\": \"5460 Concord Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 10, \"callLog\": [{\"date\": \"8/2/2024 @ 03:27 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a virtual HRA w/ Connie Middleton.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 12:26 PM\", \"result\": 10, \"comment\": \"DISCONNECTED F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:57 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 07:57 PM\"}, {\"date\": \"5/29/2024 @ 11:01 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 11:01 AM\"}, {\"date\": \"5/15/2024 @ 06:48 PM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 06:48 PM\"}, {\"date\": \"4/25/2024 @ 03:19 PM\", \"result\": 3, \"comment\": \"LS 4/24/2024 first call attempt\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/7/2024 @ 04:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 18:48:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"08-02-2024 15:27:53\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-09-30', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1945, NULL, NULL, NULL, '0006738288001', '241393', '', '21881792', 'Candice', 'Worley', '', '{\"DOB\": 30487, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1983-06-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 241393, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"79 Dogwood Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305280000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"79 Dogwood Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Worley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Candice\", \"Member_Middle_name\": \"Marie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"uniquecandi22@icloud.com\", \"Member_Suspect_Codes\": \"21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6783347053, \"Member_Identification_Number\": \"0006738288001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'1', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T18:19\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-08-01T14:42\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-01T16:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-09T16:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T14:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T16:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T18:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-29T13:54\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-11-02T13:39\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-01T16:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-09T16:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T16:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T18:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-08-01T14:42\", \"reportStatus_date\": \"2024-08-01T14:42\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-11-02T13:39\", \"reportStatus_date\": \"2024-11-02T13:39\"}]', '{\"utc\": [{\"date\": \"2024-08-01T14:42\", \"username\": null}], \"other\": [], \"noShow\": [{\"date\": \"2024-11-02T13:39\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-29T13:54\", \"username\": null}, {\"date\": \"2024-10-29T13:54\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:38\", \"value\": [{\"add\": \"79 Dogwood Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1983-06-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6783347053, \"zip\": 305280000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0006738288001\", \"mzip\": 30528, \"name\": \"Candice Marie Worley\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"uniquecandi22@icloud.com\", \"ename\": \"\", \"madd1\": \"79 Dogwood Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', '{\"utc\": [{\"date\": \"2024-08-01T14:42\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [{\"date\": \"2024-11-02T13:39\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/29/2024 @ 01:54 PM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : scheduled for 11/02 @ 12pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 10:52 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 02:17 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 02:42 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 06:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 06:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 06:19 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"5/24/2024 @ 04:08 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 04:08 PM\"}, {\"date\": \"5/21/2024 @ 02:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/27/2024 @ 02:16 PM\"}, {\"date\": \"5/9/2024 @ 04:33 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/16/2024 @ 04:33 PM\"}, {\"date\": \"5/1/2024 @ 04:34 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/2/2024 @ 04:34 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006738288001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0006738288001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0006738288001\", \"scheduleDate\": \"2024-11-2T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-01-2024 16:34:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"11-02-2024 13:39:38\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-02-2024 13:39:37\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 11}', '{\"orderType\": 1, \"sortOrder\": 1730569177}', 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1946, NULL, NULL, NULL, '0006739526001', '410165', '', '2661185', 'Carol', 'Wittschen', '', '{\"DOB\": 22016, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Washington\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Washington\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-04-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410165, \"Mailing_County\": \"WILKES\", \"Member_Country\": \"WILKES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"913 Laprade St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30673, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"913 Laprade St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30673, \"Member_Last_name\": \"Wittschen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carol\", \"Member_Middle_name\": \"B\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"carolbethbrent@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7067994737, \"Member_Identification_Number\": \"0006739526001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 7067994737}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [{\"date\": \"2024-05-14T17:46\", \"text\": \"Ineligible\", \"method\": \"api\", \"status\": 2}], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Ineligible\", \"type\": \"ReportStatus\", \"status\": 2, \"hraStatus\": 14, \"hraStatus_date\": \"2024-05-14T17:46\", \"reportStatus_date\": \"2024-05-14T17:46\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [{\"date\": \"2024-05-14T17:46\", \"username\": null}], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:38\", \"value\": [{\"add\": \"913 Laprade St\", \"age\": \"\", \"ano\": \"\", \"cno\": 7067994737, \"dob\": \"1960-04-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7067994737, \"zip\": 30673, \"add2\": \"\", \"add3\": \"\", \"city\": \"Washington\", \"gend\": 1, \"insh\": \"0006739526001\", \"mzip\": 30673, \"name\": \"Carol B Wittschen\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"carolbethbrent@gmail.com\", \"ename\": \"\", \"madd1\": \"913 Laprade St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Washington\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 2, \"callLog\": [{\"date\": \"5/14/2024 @ 05:46 PM\", \"result\": 2, \"comment\": \"Member informed me she is no longer a member of Alliant and that she cancelled the insurance in April. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:46:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:39\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:38', 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
(1947, 57818338, 44829497, '62685179', '0006742274001', '406871', '', '21881792', 'Shameka', 'Boykin', '', '{\"DOB\": 30978, \"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\": \"30117\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CARROLLTON\", \"Pcp_Name\": \"Dr. Hanna Creel\", \"PCP_Phone\": \"7708125831\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-10-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"706 DIXIE ST STE 350\", \"Screening_IHA\": \"No\", \"member_id_two\": 406871, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"7708125832\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"628 Cedar St\", \"Member_Address2\": \"Apt B\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"628 Cedar St\", \"Mailing_Address2\": \"Apt B\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Boykin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shameka\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"shameka.boykin@yahoo.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7708962734, \"Member_Identification_Number\": \"0006742274001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:37:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:37:26\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T16:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-13T17:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-17T11:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-19T20:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [{\"date\": \"2024-05-09T12:24\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-06T15:14\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-07T18:55\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-08T14:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-08T16:47\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-09T12:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-09T12:28\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-10T11:52\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-05-09T13:16\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-07T19:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T16:07\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-06T15:14\", \"reportStatus_date\": \"2024-05-06T15:14\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-13T17:46\", \"reportStatus_date\": \"2024-05-13T17:46\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-19T20:19\", \"reportStatus_date\": \"2024-05-19T20:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:37\", \"reportStatus_date\": \"2024-05-31T14:37\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-09T12:24\", \"username\": \"PFrey1\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:37\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-06T15:14\", \"username\": null}, {\"date\": \"2024-05-06T15:14\", \"username\": null}, {\"date\": \"2024-05-07T18:55\", \"username\": null}, {\"date\": \"2024-05-08T14:45\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2024-05-08T16:47\", \"username\": null}, {\"date\": \"2024-05-08T16:47\", \"username\": null}, {\"date\": \"2024-05-09T12:24\", \"username\": null}, {\"date\": \"2024-05-09T12:28\", \"username\": null}, {\"date\": \"2024-05-09T12:28\", \"username\": null}, {\"date\": \"2024-05-09T13:16\", \"username\": null}, {\"date\": \"2024-05-09T13:16\", \"username\": null}, {\"date\": \"2024-05-10T11:52\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-08T04:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-08T14:45\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2024-05-12T06:14\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-14T08:55\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-13T13:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T13:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T14:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T14:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T14:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T14:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T14:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T16:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T16:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T16:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T16:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T16:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T16:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:33\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:33\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T17:40\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-15T19:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T13:40\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-17T02:49\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-19T20:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-17T11:04\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-19T20:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-15T17:43\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-16T13:40\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"15:23:23\", \"value\": [{\"add\": \"628 Cedar St\", \"age\": 39, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-10-23\", \"eno\": \"7708558131\", \"lob\": \"On Exchange\", \"pno\": 7708962734, \"zip\": 30117, \"add2\": \"Apt B\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0006742274001\", \"mzip\": 30117, \"name\": \"Shameka R Boykin\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Hanna Creel\", \"ppno\": \"7708125831\", \"cliId\": \"\", \"email\": \"shameka.boykin@yahoo.com\", \"ename\": \"Laura kight\", \"madd1\": \"628 Cedar St\", \"madd2\": \"Apt B\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"706 DIXIE ST STE 350\", \"pcpnpi\": \"\", \"pcpzip\": \"30117\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"CARROLLTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7708125832\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"added\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 15:23:23\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-09T12:24\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0006742274001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 15 May 2024 21:43:20 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  preventative care cholesterol needs answer.\\n2.  assessment of diagnosis Endocrine PN please add pain location.\\n3.  home safety members gait needs answer.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 15 May 2024 23:20:14 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 16 May 2024 17:40:40 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  assessment of diagnosis Endocrine PN please add pain location.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 17 May 2024 06:49:38 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you\"}, \"mailId\": \"\"}], \"memberName\": \"Shameka Boykin\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/13/2024 02:30 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"5/9/2024 @ 01:16 PM\", \"result\": 12, \"comment\": \"Member called and rescheduled for 05/13/24 pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tema Ferness\", \"callbackDate\": \"\"}, {\"date\": \"5/9/2024 @ 12:28 PM\", \"result\": 0, \"comment\": \"Member called and rescheduled appt for 5/13/24 PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tema Ferness\", \"callbackDate\": \"\"}, {\"date\": \"5/8/2024 @ 04:47 PM\", \"result\": 12, \"comment\": \"member called in to reschedule HRA appt for 5/13/24 PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"5/7/2024 @ 07:23 PM\", \"result\": 6, \"comment\": \"Member called in requesting to reschedule her HRA w/Faith from tomorrow, 5/8 to 5/9. We don\'t have that available but do have 5/14/24 open in her town to reschedule her for. Tried to get in touch but no answer x2 and her VM is full. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/8/2024 @ 07:21 PM\"}, {\"date\": \"5/6/2024 @ 03:14 PM\", \"result\": 0, \"comment\": \"SCHEDULED FAITH E 5/8 - NO PETS, PLEASE PARK IN VISITOR\'S PARKING ACROSS THE STREET FROM BUILDING. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/29/2024 @ 04:07 PM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE MESSAGE\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 04:07 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006742274001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006742274001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006742274001\", \"scheduleDate\": \"2024-5-13T13:16\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:07:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"05-09-2024 12:24:25\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-10-2024 11:52:41\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:37:24\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"d2791173-1f7c-11ef-af93-e144e2d4027c\\\",\\\"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-5-13T14:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:38', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006742274001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006742274001_Boykin, Shameka_05132024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:37:23\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_creel, Hanna_0006742274001_05132024.pdf\"}', 'ACA_0006742274001_Boykin, Shameka_05132024', NULL, 'PCP_creel, Hanna_0006742274001_05132024', NULL, '[{\"date\": \"2024-05-13T21:46:56.319Z\", \"signature\": \"data:image/png;base64,[encoded data, 23404 characters]\"}, {\"date\": \"2024-05-15T23:20:13.765Z\", \"signature\": \"data:image/png;base64,[encoded data, 23412 characters]\"}, {\"date\": \"2024-05-17T06:49:38.469Z\", \"signature\": \"data:image/png;base64,[encoded data, 23408 characters]\"}]', '2024-05-13T13:30', 'Member_Summary_0006742274001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006742274001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006742274001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:37:25\"}', 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
(1948, NULL, NULL, NULL, '0006743172001', '403341', '', '21881792', 'DANNY', 'BRITT', '', '{\"DOB\": 25704, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-05-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 403341, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"540 Lee Williams Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"540 Lee Williams Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"BRITT\", \"Medication_Review\": \"N\", \"Member_first_name\": \"DANNY\", \"Member_Middle_name\": \"RAY\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dbritt9086@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4707915466, \"Member_Identification_Number\": \"0006743172001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-22T10:50\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T16:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T15:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T14:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T15:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-22T10:50\", \"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-04-29T16:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T15:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T15:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-22T10:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-29T09:23\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:39\", \"username\": null}, {\"date\": \"2024-05-14T17:39\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-03T09:54\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:39\", \"value\": [{\"add\": \"540 Lee Williams Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-05-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4707915466, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 0, \"insh\": \"0006743172001\", \"mzip\": 30117, \"name\": \"DANNY RAY BRITT\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dbritt9086@gmail.com\", \"ename\": \"\", \"madd1\": \"540 Lee Williams Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 09:35 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 05:25 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 05:28 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith Mailbox full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 01:52 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule HRA w/ Faith Enwefah.- Mailbox Full.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/22/2024 @ 10:50 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 03:59 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 03:59 PM\"}, {\"date\": \"6/13/2024 @ 02:32 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/20/2024 @ 02:32 PM\"}, {\"date\": \"5/6/2024 @ 03:17 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 03:17 PM\"}, {\"date\": \"4/29/2024 @ 04:10 PM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE MESSAGE.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 04:10 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:10:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-22-2024 10:50:48\", \"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', '21-04-2024 06:01:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1949, NULL, NULL, NULL, '0006746869001', '404078', '', '21881792', 'Neina', 'Parham', '', '{\"DOB\": 29444, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1980-08-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 404078, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1210 Stewart St Apt A2\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1210 Stewart St Apt A2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Parham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Neina\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"neinamp34@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6782158439, \"Member_Identification_Number\": \"0006746869001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T16:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T15:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T14:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T16:01\", \"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-06-22T10:54\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T16:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T15:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T16:01\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-22T10:54\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-29T09:23\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:39\", \"username\": null}, {\"date\": \"2024-05-14T17:39\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-03T09:54\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:39\", \"value\": [{\"add\": \"1210 Stewart St Apt A2\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1980-08-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782158439, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0006746869001\", \"mzip\": 30117, \"name\": \"Neina Parham\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"neinamp34@gmail.com\", \"ename\": \"\", \"madd1\": \"1210 Stewart St Apt A2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 10:36 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:04 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 09:35 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"6/22/2024 @ 10:54 AM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox or Faith Enwefah - member is currently at the hospital w/ her wife and requests a call back at a later time  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/24/2024 @ 10:54 AM\"}, {\"date\": \"6/17/2024 @ 04:01 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 04:01 PM\"}, {\"date\": \"6/13/2024 @ 02:34 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/20/2024 @ 02:34 PM\"}, {\"date\": \"5/6/2024 @ 03:20 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 03:20 PM\"}, {\"date\": \"4/29/2024 @ 04:12 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 04:12 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:12:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:32:26\", \"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', '21-04-2024 06:01:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1950, NULL, NULL, NULL, '0006747932001', '397333', '', '2661185', 'Julie', 'Merck', '', '{\"DOB\": 28670, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1740472208, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLEVELAND\", \"Pcp_Name\": \"JAMES MURPHEY\", \"PCP_Phone\": 7068651234, \"Pcp_State\": \"GA\", \"Member_City\": \"Demorest\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Demorest\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-06-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2578 HELEN HWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 397333, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"463 Yearwood Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30535, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"463 Yearwood Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30535, \"Member_Last_name\": \"Merck\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Julie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gigijules0629@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069695293, \"Member_Identification_Number\": \"0006747932001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:43\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:43\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T16:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T11:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-23T12:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T18:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-07-03T18:21\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T16:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T11:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T12:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T18:41\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T18:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-29T09:23\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:39\", \"username\": null}, {\"date\": \"2024-05-14T17:39\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-03T09:54\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:39\", \"value\": [{\"add\": \"463 Yearwood Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-06-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069695293, \"zip\": 30535, \"add2\": \"\", \"add3\": \"\", \"city\": \"Demorest\", \"gend\": 1, \"insh\": \"0006747932001\", \"mzip\": 30535, \"name\": \"Julie Merck\", \"plan\": \"Alliant\", \"pphy\": \"JAMES MURPHEY\", \"ppno\": 7068651234, \"cliId\": \"\", \"email\": \"gigijules0629@gmail.com\", \"ename\": \"\", \"madd1\": \"463 Yearwood Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Demorest\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2578 HELEN HWY\", \"pcpnpi\": 1740472208, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CLEVELAND\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 02:25 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 06:21 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/10/2024 @ 06:21 PM\"}, {\"date\": \"6/20/2024 @ 06:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 06:41 PM\"}, {\"date\": \"5/23/2024 @ 12:30 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise Adams \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/30/2024 @ 12:30 PM\"}, {\"date\": \"5/16/2024 @ 11:52 AM\", \"result\": 3, \"comment\": \"NO VM SETUP - UNABLE TO LEAVE A MESSAGE. ATTEMPT TO SCHEDULE HRA. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 11:52 AM\"}, {\"date\": \"4/25/2024 @ 04:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 04:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:55:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-11-2024 00:43:53\", \"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', '21-04-2024 06:01:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1951, NULL, NULL, NULL, '0006748274001', '407451', '', '26056802', 'Lee', 'Edwards', '', '{\"DOB\": 30720, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gillsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buford\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-02-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407451, \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4333 Harmony Church Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30543, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4017 Suddeth Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30518, \"Member_Last_name\": \"Edwards\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"leeedwards531@gmail.com\", \"Member_Suspect_Codes\": \"130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6788585106, \"Member_Identification_Number\": \"0006748274001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:58\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T16:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T10:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T15:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:58\", \"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-04-29T16:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T10:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T15:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T15:41\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:58\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-29T09:23\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T17:39\", \"username\": null}, {\"date\": \"2024-05-14T17:39\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-03T09:54\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:40\", \"value\": [{\"add\": \"4333 Harmony Church Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-02-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6788585106, \"zip\": 30543, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gillsville\", \"gend\": 0, \"insh\": \"0006748274001\", \"mzip\": 30518, \"name\": \"Lee Edwards\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"leeedwards531@gmail.com\", \"ename\": \"\", \"madd1\": \"4017 Suddeth Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buford\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:10 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:25 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 11:29 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 11:40 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 01:37 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:58 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 03:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/11/2024 @ 03:41 PM\"}, {\"date\": \"6/21/2024 @ 03:25 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/27/2024 @ 03:25 PM\"}, {\"date\": \"5/13/2024 @ 10:14 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/15/2024 @ 10:14 AM\"}, {\"date\": \"4/29/2024 @ 04:43 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/13/2024 @ 04:43 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:43:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-11-2024 15:58:15\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:40', 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
(1952, 55499828, 44829497, '62685179', '0006748452001', '414310', '', '2661185', 'Vivie', 'Perez', '', '{\"DOB\": 23919, \"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\": \"30308\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Atlanta\", \"Pcp_Name\": \"Joung Y. Kim\", \"PCP_Phone\": \"4047782020\", \"Member_City\": \"Hiawassee\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hiawassee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-06-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"550 PEACHTREE STREET 9TH FLOOR\", \"Screening_IHA\": \"No\", \"member_id_two\": 414310, \"Mailing_County\": \"TOWNS\", \"Member_Country\": \"TOWNS\", \"PCP_Fax_Number\": \"4047782244\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2511 Jim Watson Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30546, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2511 Jim Watson Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30546, \"Member_Ethnicity\": \"White\", \"Member_Last_name\": \"Perez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Vivie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"vivie_perez@yahoo.com\", \"Member_Suspect_Codes\": 110, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4044887079, \"Member_Identification_Number\": \"0006748452001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-23-2024 11:14:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-23 11:14:11\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T17:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T09:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T13:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-15T19:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-16T15:09\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-16T16:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-23T11:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-03T18:27\", \"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-05-17T13:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T09:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T13:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-03T18:27\", \"reportStatus_date\": \"2024-07-03T18:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-07-15T19:31\", \"reportStatus_date\": \"2024-07-15T19:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-16T16:27\", \"reportStatus_date\": \"2024-07-16T16:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-23T11:14\", \"reportStatus_date\": \"2024-07-23T11:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-23T11:14\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-07-03T18:27\", \"username\": null}, {\"date\": \"2024-07-03T18:27\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-14T19:56\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-07-16T09:48\", \"username\": \"AWalsh\"}, {\"date\": \"2024-07-16T09:52\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-07-15T19:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-15T19:31\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-16T16:27\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-16T15:09\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-16T16:27\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-06-2024\", \"time\": \"18:29:05\", \"value\": [{\"add\": \"2511 Jim Watson Rd\", \"age\": 59, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-06-26\", \"eno\": \"7063945877\", \"lob\": \"On Exchange\", \"pno\": 4044887079, \"zip\": 30546, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hiawassee\", \"gend\": 1, \"insh\": \"0006748452001\", \"mzip\": 30546, \"name\": \"Vivie Perez\", \"plan\": \"Alliant\", \"pphy\": \"Joung Y. Kim\", \"ppno\": \"4047782020\", \"cliId\": \"\", \"email\": \"vivie_perez@yahoo.com\", \"ename\": \"Gina Dills\", \"madd1\": \"2511 Jim Watson Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hiawassee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"550 PEACHTREE STREET 9TH FLOOR\", \"pcpnpi\": \"\", \"pcpzip\": \"30308\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"Atlanta\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"4047782244\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"PCP added and member does not know their number.\", \"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\": \"07-14-2024\", \"time\": \"19:56:35\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-06-2024 18:29:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/3/2024 @ 06:27 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 01:11 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 01:11 PM\"}, {\"date\": \"5/21/2024 @ 09:37 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 09:36 AM\"}, {\"date\": \"5/17/2024 @ 01:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/20/2024 @ 01:56 PM\"}, {\"date\": \"5/14/2024 @ 05:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 05:47 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006748452001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006748452001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006748452001\", \"scheduleDate\": \"2024-7-15T11:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:47:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 18:27:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-07-23 11:14:09\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"35bcc6ab-4906-11ef-a70b-05717ede93c1\\\",\\\"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-7-15T11:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:40', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006748452001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006748452001_Perez, Vivie_07152024.pdf\", \"ftp_upload_date\": \"2024-07-23 11:14:08\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Dr. Joung_0006748452001_07152024.pdf\"}', 'ACA_0006748452001_Perez, Vivie_07152024', NULL, 'PCP_, Dr. Joung_0006748452001_07152024', NULL, '[{\"date\": \"2024-07-15T23:31:08.226Z\", \"signature\": \"data:image/png;base64,[encoded data, 23424 characters]\"}]', '2024-07-15T12:30', 'Member_Summary_0006748452001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006748452001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006748452001.pdf\", \"member_ftp_upload_date\": \"2024-07-23 11:14:11\"}', 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
(1953, 2888643, 44829497, '62685179', '0006749696001', '414918', '', '2661185', 'Stephanie', 'Wood', '', '{\"DOB\": 25488, \"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\": \"30125\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"Cedartown\", \"Pcp_Name\": \"Dr. Julaine B. Cross\", \"PCP_Phone\": \"7707485212\", \"Member_City\": \"Cedartown\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cedartown\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-10-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1025 N Main St\", \"Screening_IHA\": \"No\", \"member_id_two\": 414918, \"Mailing_County\": \"POLK\", \"Member_Country\": \"POLK\", \"PCP_Fax_Number\": \"7707482944\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"38 Colquitt Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30125, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"38 Colquitt Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30125, \"Member_Last_name\": \"Wood\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephanie\", \"Member_Middle_name\": \"S\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"stef4031@gmail.com\", \"Member_Suspect_Codes\": \"130, 161.2, 20, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7708916591, \"Member_Identification_Number\": \"0006749696001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:37:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:37:34\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-04-25T19:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-04-29T10:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-04-29T17:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-23T15:06\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-04-29T17:20\", \"reportStatus_date\": \"2024-04-29T17:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:37\", \"reportStatus_date\": \"2024-05-31T14:37\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:37\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-23T15:06\", \"username\": null}, {\"date\": \"2024-04-23T15:06\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-04-24T07:51\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-04-25T19:58\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-04-25T19:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-04-26T09:15\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-04-26T09:18\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-04-26T09:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-04-26T11:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-04-26T11:39\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-04-29T17:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-04-29T10:00\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-04-29T17:20\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-04-26T09:20\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-04-26T10:31\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-04-26T11:39\", \"username\": \"FEnwefah\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-23-2025\", \"time\": \"06:28:12\", \"value\": [{\"add\": \"38 Colquitt Rd\", \"age\": 55, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-10-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7708916591, \"zip\": 30125, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cedartown\", \"gend\": 1, \"insh\": \"0006749696001\", \"mzip\": 30125, \"name\": \"Stephanie S Wood\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Julaine B. Cross\", \"ppno\": \"7707485212\", \"race\": \"\", \"cliId\": \"\", \"email\": \"stef4031@gmail.com\", \"ename\": \"unknow\", \"madd1\": \"38 Colquitt Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cedartown\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1025 N Main St\", \"pcpnpi\": \"\", \"pcpzip\": \"30125\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"Cedartown\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-04-24 11:00 AM\", \"evalName\": \"Faith Enwefah, NP\", \"pcpfaxno\": \"7707482944\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"PCP added\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-23-2025 06:28:12\"}', NULL, NULL, '{\"memberId\": \"0006749696001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Fri, 26 Apr 2024 13:20:19 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThe assessment looks good, thank you for adding information after we reviewed it together.\\n1. IN the assessment of dx section, DVT dx- please select if the eliquis is prophylactic? that answer is blank.\\n2. In the assessment of dx, endocrine, diabetes , peripheral neuropathy dx- Please select the location of symptoms\\nin that section.\\n- I also wanted to clarify - the diabetic foot exam  was documented as normal.  Since she reported decreased \\nsensation I wanted to check with you. Please add a comment in the physical exam or make any updates.\\n- In the CKD secondary to Diabetes- can you add to your commment  that it is unknown if she has a or b of Stage 3? This way the \\ncoders can accurately capture the condition.\\n3. Did you send a CM referral? I hadnt received it. We had discussed, food disparity, affordability of Dulera and obtaining Narcan .\\n\\nI appreciate your hard work.\\n\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 26 Apr 2024 13:36:58 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 26 Apr 2024 14:31:33 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThe assessment looks great and i recieved the CM referral. Please add a comment in the summary that the referral was submitted.\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 26 Apr 2024 15:39:34 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 26 Apr 2024 15:39:34 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved\"}, \"mailId\": \"\"}], \"memberName\": \"Stephanie Wood\", \"codingAnalyst\": \"\", \"dateOfService\": \"04/24/2024 11:00AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/23/2024 @ 03:06 PM\", \"result\": 0, \"comment\": \"Scheduled HRA w/ Faith Enwefah for 4/24/24 @ 11:00am -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006749696001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006749696001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0006749696001\", \"scheduleDate\": \"2024-4-24T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 15:06:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-23-2024 15:06:54\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:37:32\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"d7afe843-1f7c-11ef-8dfc-b950a63564fd\\\",\\\"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-4-24T11:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:40', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006749696001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006749696001_Wood, Stephanie_04242024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:37:32\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_cross, Dr_0006749696001_04242024.pdf\"}', 'ACA_0006749696001_Wood, Stephanie_04242024', NULL, 'PCP_cross, Dr_0006749696001_04242024', NULL, '[{\"date\": \"2024-04-25T23:13:35.220Z\", \"signature\": \"data:image/png;base64,[encoded data, 23408 characters]\"}, {\"date\": \"2024-04-26T13:36:57.869Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}, {\"date\": \"2024-04-26T15:39:33.458Z\", \"signature\": \"data:image/png;base64,[encoded data, 23408 characters]\"}]', '2024-04-24T12:17', 'Member_Summary_0006749696001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006749696001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006749696001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:37:34\"}', 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
(1954, NULL, NULL, NULL, '0006753112001', '387647', '', '21881792', 'Evy', 'Willingham', '', '{\"DOB\": 22110, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1811170566, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"LEAH BARBEE\", \"PCP_Phone\": 4787468626, \"Pcp_State\": \"GA\", \"Member_City\": \"Macon\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-07-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"265 SHERATON BLVD\", \"Screening_IHA\": \"No\", \"member_id_two\": 387647, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"215 Castlegate Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31210, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"215 Castlegate Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31210, \"Member_Last_name\": \"Willingham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Evy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ecw215@gmail.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4787377273, \"Member_Identification_Number\": \"0006753112001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T12:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T15:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-07T14:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T17:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T19:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T12: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\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T15:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T14:06\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T19:33\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T12:09\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:40\", \"value\": [{\"add\": \"215 Castlegate Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-07-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4787377273, \"zip\": 31210, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 1, \"insh\": \"0006753112001\", \"mzip\": 31210, \"name\": \"Evy Willingham\", \"plan\": \"Alliant\", \"pphy\": \"LEAH BARBEE\", \"ppno\": 4787468626, \"cliId\": \"\", \"email\": \"ecw215@gmail.com\", \"ename\": \"\", \"madd1\": \"215 Castlegate Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"265 SHERATON BLVD\", \"pcpnpi\": 1811170566, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MACON\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 11:29 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 02:55 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Debbie York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 12:09 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 07:33 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 07:33 PM\"}, {\"date\": \"6/12/2024 @ 05:51 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting.  Call attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 05:51 PM\"}, {\"date\": \"6/7/2024 @ 02:06 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBORAH YORK MV 6/18\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 02:06 PM\"}, {\"date\": \"4/30/2024 @ 03:24 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 03:24 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 15:24:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-03-2024 12:09:52\", \"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', '21-04-2024 06:01:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1955, NULL, NULL, NULL, '0006753901001', '409805', '', '2661185', 'Brett', 'Shuman', '', '{\"DOB\": 33224, \"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\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Winterville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winterville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1990-12-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 409805, \"Mailing_County\": \"CLARKE\", \"Member_Country\": \"CLARKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"180 Double Bridges Xing\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30683, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"180 Double Bridges Xing\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30683, \"Member_Last_name\": \"Shuman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brett\", \"Member_Middle_name\": \"m\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"bmshum3812@gmail.com\", \"Member_Suspect_Codes\": 82, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062072103, \"Member_Identification_Number\": \"0006753901001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T17:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T09:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T13:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-07-09T14:12\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T13:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T09:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T13:14\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T14:12\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-11-11T11:57\", \"reportStatus_date\": \"2024-11-11T11:57\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:45\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-11-11T11:57\", \"username\": null}, {\"date\": \"2024-11-11T11:57\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-23-2024\", \"time\": \"21:19:15\", \"value\": [{\"add\": \"180 Double Bridges Xing\", \"age\": 33, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1990-12-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062072103, \"zip\": 30683, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winterville\", \"gend\": 0, \"insh\": \"0006753901001\", \"mzip\": 30683, \"name\": \"Brett m Shuman\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bmshum3812@gmail.com\", \"ename\": \"\", \"madd1\": \"180 Double Bridges Xing\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winterville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"11-23-2024\", \"time\": \"21:19:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"12-03-2024 09:07:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:57 AM\", \"result\": 0, \"comment\": \"Scheduled virtual HRA w/ Nykya C on 11/22 @ 4:30 - texted doxy link - member will use their phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 07:35 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 06:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 02:12 PM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 01:14 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 01:14 PM\"}, {\"date\": \"5/21/2024 @ 09:39 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 09:39 AM\"}, {\"date\": \"5/17/2024 @ 01:58 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/20/2024 @ 01:58 PM\"}, {\"date\": \"5/14/2024 @ 05:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 05:47 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:47:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-15-2024 05:45:12\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 0, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1956, NULL, NULL, NULL, '0006756504001', '408661', '', '2661185', 'Alicia', 'Joyner', '', '{\"DOB\": 24450, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Rebecca\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rebecca\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-12-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 408661, \"Mailing_County\": \"TURNER\", \"Member_Country\": \"TURNER\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"285 Joyner Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31783, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"285 Joyner Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31783, \"Member_Last_name\": \"Joyner\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alicia\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ajoyner@jayfirm.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2295664933, \"Member_Identification_Number\": \"0006756504001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T12:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T17:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T09:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T13:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T12:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T13:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T09:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T13:17\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T12:10\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-11-11T11:57\", \"username\": null}, {\"date\": \"2024-11-11T11:57\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:41\", \"value\": [{\"add\": \"285 Joyner Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-12-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2295664933, \"zip\": 31783, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rebecca\", \"gend\": 1, \"insh\": \"0006756504001\", \"mzip\": 31783, \"name\": \"Alicia Joyner\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ajoyner@jayfirm.com\", \"ename\": \"\", \"madd1\": \"285 Joyner Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rebecca\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:33 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 02:42 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:40 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:52 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 11:38 AM\", \"result\": 13, \"comment\": \" CALLER DISCONNECTED -Caller answered the call prior to greeting and disconnected the call.  Call attempt to schedule a F2F or a virtual HRA w/Deborah york \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:21 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:07 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 12:10 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 01:17 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 01:17 PM\"}, {\"date\": \"5/21/2024 @ 09:41 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 09:41 AM\"}, {\"date\": \"5/17/2024 @ 01:59 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 01:59 PM\"}, {\"date\": \"5/14/2024 @ 05:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 05:49 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 17:51:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 12:10:53\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1957, NULL, NULL, NULL, '0006757771001', '412318', '', '26056802', 'Miriam', 'Selevan', '', '{\"DOB\": 23652, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Jasper\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Jasper\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-10-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412318, \"Mailing_County\": \"PICKENS\", \"Member_Country\": \"PICKENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"299 Grand Circle\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30143, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"299 Grand Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30143, \"Member_Last_name\": \"Selevan\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Miriam\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mimimiami27@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 3054969363, \"Member_Identification_Number\": \"0006757771001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T17:59\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-15T13:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-22T14:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T15:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T13:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T17:59\", \"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-05-15T13:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-22T14:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T15:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T13:18\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:59\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:41\", \"value\": [{\"add\": \"299 Grand Circle\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-10-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 3054969363, \"zip\": 30143, \"add2\": \"\", \"add3\": \"\", \"city\": \"Jasper\", \"gend\": 1, \"insh\": \"0006757771001\", \"mzip\": 30143, \"name\": \"Miriam Selevan\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mimimiami27@gmail.com\", \"ename\": \"\", \"madd1\": \"299 Grand Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Jasper\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 09:26 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 12:46 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Debbie York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 03:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:59 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 01:18 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 01:18 PM\"}, {\"date\": \"5/29/2024 @ 03:22 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 03:22 PM\"}, {\"date\": \"5/22/2024 @ 02:38 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 02:37 PM\"}, {\"date\": \"5/15/2024 @ 01:00 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Nykea Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 01:00 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 13:00:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-09-2024 17:59:28\", \"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', '21-04-2024 06:01:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1958, NULL, NULL, NULL, '0006757803001', '413248', '', '26056802', 'Milton', 'Hunter', '', '{\"DOB\": 21892, \"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\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Winder\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-12-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413248, \"Mailing_County\": \"BARROW\", \"Member_Country\": \"BARROW\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"645 Cnee Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30680, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"645 Cnee Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Last_name\": \"Hunter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Milton\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"miltonhunter@gmail.com\", \"Member_Suspect_Codes\": 130, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4704293390, \"Member_Identification_Number\": \"0006757803001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-25T17:04\", \"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-04-25T17:04\", \"reportStatus_date\": \"2024-04-25T17:04\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-25T17:04\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:42\", \"value\": [{\"add\": \"645 Cnee Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-12-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4704293390, \"zip\": 30680, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winder\", \"gend\": 0, \"insh\": \"0006757803001\", \"mzip\": 30680, \"name\": \"Milton Hunter\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"miltonhunter@gmail.com\", \"ename\": \"\", \"madd1\": \"645 Cnee Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-25T17:04\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/25/2024 @ 05:04 PM\", \"result\": 9, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key- Member refused and states he sees his PCP regularly. I asked if he would like a call back later this year and he refused\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 17:04:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:40\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1959, NULL, NULL, NULL, '0006761487001', '200123', '', '21881792', 'Sharon', 'Hooper', '', '{\"DOB\": 27542, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1285620831, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATSWORTH\", \"Pcp_Name\": \"JAMES BROWN\", \"PCP_Phone\": 7066950466, \"Pcp_State\": \"GA\", \"Member_City\": \"Chatsworth\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-05-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"320 W MARKET ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 200123, \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5425 Old CCC Camp Road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307050000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4525 Old CCC Camp Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Last_name\": \"Hooper\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sharon\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dawnhoo33@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068472819, \"Member_Identification_Number\": \"0006761487001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:44\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:44\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T09:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-05-03T12:58\", \"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\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T09:17\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-03T12:58\", \"reportStatus_date\": \"2024-05-03T12:58\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-03T12:58\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:42\", \"value\": [{\"add\": \"5425 Old CCC Camp Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-05-28\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068472819, \"zip\": 307050000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 1, \"insh\": \"0006761487001\", \"mzip\": 30705, \"name\": \"Sharon Hooper\", \"plan\": \"Alliant\", \"pphy\": \"JAMES BROWN\", \"ppno\": 7066950466, \"cliId\": \"\", \"email\": \"dawnhoo33@gmail.com\", \"ename\": \"\", \"madd1\": \"4525 Old CCC Camp Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"320 W MARKET ST\", \"pcpnpi\": 1285620831, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATSWORTH\", \"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\": \"05-11-2024\", \"time\": \"03:25:05\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:05\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-03T12:58\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/3/2024 @ 12:58 PM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IHA IN 2024.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/25/2024 @ 09:17 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/26/2024 @ 09:17 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 09:17:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:40\", \"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', '21-04-2024 06:01:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
