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
(1408, 57818338, 44829497, '56716210', '0005762601001', '376918', '', '26056802', 'Rhonda', 'Glover', '', '{\"DOB\": 23914, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1811287360, \"Pcp_Zip\": \"30517\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"BRASELTON\", \"Pcp_Name\": \"Kimberly Barrett\", \"PCP_Phone\": \"7708489335\", \"Pcp_State\": \"GA\", \"Member_City\": \"Buford\", \"Office_Name\": \"Northeast Georgia Physicians Group OB/GYN\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buford\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-06-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1404 RIVER PL STE 303\", \"Screening_IHA\": \"No\", \"member_id_two\": 376918, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7708489336\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4270 Chatuge Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30519, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4270 Chatuge Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30519, \"Member_Last_name\": \"Glover\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rhonda\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"rglover4@bellsouth.net\", \"Member_Suspect_Codes\": \"120, 161.2, 30, 56\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7703631555, \"Member_Identification_Number\": \"0005762601001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-06-2024 11:48:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-06 11:48:28\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T13:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-26T18:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-10T16:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T12:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T16:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-01T10:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-05T13:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-05T19:02\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T11:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-30T17:30\", \"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-26T18:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-10T16:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T12:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T16:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T13:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-05T19:02\", \"reportStatus_date\": \"2024-08-05T19:02\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-06T11:48\", \"reportStatus_date\": \"2024-08-06T11:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-06T11:48\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-07-30T17:30\", \"username\": null}, {\"date\": \"2024-07-30T17:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-31T22:29\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-01T13:19\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-01T10:58\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-01T10:58\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-01T21:04\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-02T13:19\", \"username\": \"JSilverio\"}, {\"date\": \"2024-08-02T14:49\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-05T19:02\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-05T13:42\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-05T19:02\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-01T15:28\", \"username\": \"JSilverio\"}, {\"date\": \"2024-08-02T13:21\", \"username\": \"JSilverio\"}, {\"date\": \"2024-08-02T14:40\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-02T14:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-02T14:46\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-13-2024\", \"time\": \"11:23:55\", \"value\": [{\"add\": \"4270 Chatuge Dr\", \"age\": 59, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-06-21\", \"eno\": \"6788580935\", \"lob\": \"On Exchange\", \"pno\": 7703631555, \"zip\": 30519, \"add2\": \"\", \"add3\": \"\", \"city\": \"Buford\", \"gend\": 1, \"insh\": \"0005762601001\", \"mzip\": 30519, \"name\": \"Rhonda Glover\", \"plan\": \"Alliant\", \"pphy\": \"Kimberly Barrett\", \"ppno\": \"7708489335\", \"race\": \"\", \"cliId\": \"\", \"email\": \"rglover4@bellsouth.net\", \"ename\": \"John Glover\", \"madd1\": \"4270 Chatuge Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buford\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1404 RIVER PL STE 303\", \"pcpnpi\": 1811287360, \"pcpzip\": \"30517\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"BRASELTON\", \"pcpname\": \"Northeast Georgia Physicians Group OB/GYN\", \"program\": \"ACA\", \"evalDate\": \"2024-8-1 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7708489336\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-30-2024\", \"time\": \"17:38:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-13-2024 11:23:55\"}', NULL, NULL, '{\"memberId\": \"0005762601001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 01 Aug 2024 19:28:36 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD Neuropsych anxiety treatments needs answer.\\n2.  AOD nose reports AR please add.\\n3.  AOD neuropsych med list reports epilepsy please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 02 Aug 2024 01:04:16 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Added. Thank you. \"}, \"mailId\": \"\"}, {\"date\": \"Fri, 02 Aug 2024 17:21:14 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  It is reported in the vital signs section that the member would like to get more weight loss medication and it was denied by Alliant.\\nShould a case management referral be sent to assist the member with this issue?\\nThanks\\nJudi\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 02 Aug 2024 18:49:02 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Would not hurt to try. I figured it was denied because she is not prediabetic or diabetic and BMI is not too bad (26). Will add the referral. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Rhonda Glover\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/01/2024 09:45 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/30/2024 @ 05:30 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS member scheduled for -8/01/2024 @9:45am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 01:10 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 04:47 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 04:47 PM\"}, {\"date\": \"6/3/2024 @ 12:55 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/10/2024 @ 12:55 PM\"}, {\"date\": \"5/10/2024 @ 04:56 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule IHA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/15/2024 @ 04:56 PM\"}, {\"date\": \"4/26/2024 @ 06:04 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/10/2024 @ 06:04 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005762601001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0005762601001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0005762601001\", \"scheduleDate\": \"2024-8-1T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 18:04:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-30-2024 17:30:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2024-08-06 11:48:27\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"5251f1d0-540b-11ef-bc93-a3e7a52bfb4f\\\",\\\"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-8-1T09:45', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:54', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005762601001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005762601001_Glover, Rhonda_08012024.pdf\", \"ftp_upload_date\": \"2024-08-06 11:48:26\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Barrett, Kimberly_0005762601001_08012024.pdf\"}', 'ACA_0005762601001_Glover, Rhonda_08012024', NULL, 'PCP_Barrett, Kimberly_0005762601001_08012024', NULL, '[{\"date\": \"2024-08-01T14:58:37.785Z\", \"signature\": \"data:image/png;base64,[encoded data, 23488 characters]\"}, {\"date\": \"2024-08-02T01:04:16.477Z\", \"signature\": \"data:image/png;base64,[encoded data, 23456 characters]\"}, {\"date\": \"2024-08-02T18:49:01.795Z\", \"signature\": \"data:image/png;base64,[encoded data, 23452 characters]\"}]', '2024-08-01T10:18', 'Member_Summary_0005762601001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005762601001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005762601001.pdf\", \"member_ftp_upload_date\": \"2024-08-06 11:48:28\"}', 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
(1409, NULL, NULL, NULL, '0005763817001', '366244', '', '26056802', 'Megan', 'Toal', '', '{\"DOB\": 34129, \"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\": \"Dawsonville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-06-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 366244, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"235 Robertson Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"235 Robertson Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Last_name\": \"Toal\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Megan\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"toal.megan@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6782650472, \"Member_Identification_Number\": \"0005763817001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:54\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:54\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-05-14T16:55\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-03T17:29\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-03T17:29\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-14T16:55\", \"reportStatus_date\": \"2024-05-14T16:55\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-14T16:55\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:58:54\", \"value\": [{\"add\": \"235 Robertson Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-06-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782650472, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0005763817001\", \"mzip\": 30534, \"name\": \"Megan Toal\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"toal.megan@gmail.com\", \"ename\": \"\", \"madd1\": \"235 Robertson Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-14T16:55\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/14/2024 @ 04:55 PM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IN 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/3/2024 @ 05:29 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Call Back - member is currently driving and needs time to look at her planner to schedule accordingly \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/17/2024 @ 05:29 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-03-2024 17:29:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:14\", \"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 05:58:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1410, NULL, NULL, NULL, '0005765122002', '361862', '', '21881792', 'Aaron', 'Keene', '', '{\"DOB\": 32339, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1962667915, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"ANTONY LABADY\", \"PCP_Phone\": 4789224281, \"Pcp_State\": \"GA\", \"Member_City\": \"Macon\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1988-07-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"400 CHARTER BLVD\", \"Screening_IHA\": \"No\", \"member_id_two\": 361862, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1220 Beaver Oaks Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31220, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1220 Beaver Oaks Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31220, \"Member_Last_name\": \"Keene\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Aaron\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 82, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4785011746, \"Member_Identification_Number\": \"0005765122002\", \"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:32:54\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:54\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-06-12T16:15\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}, {\"date\": \"2024-06-15T16:36\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-15T16:36\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"07-31-2024\", \"time\": \"15:42:59\", \"value\": [{\"add\": \"1220 Beaver Oaks Dr\", \"age\": 36, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1988-07-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4785011746, \"zip\": 31220, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 0, \"insh\": \"0005765122002\", \"mzip\": 31220, \"name\": \"Aaron Keene\", \"plan\": \"Alliant\", \"pphy\": \"ANTONY LABADY\", \"ppno\": 4789224281, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1220 Beaver Oaks Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"400 CHARTER BLVD\", \"pcpnpi\": 1962667915, \"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\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-31-2024\", \"time\": \"15:42:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-31-2024 16:08:10\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"6/15/2024 @ 04:36 PM\", \"result\": 4, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"6/12/2024 @ 04:15 PM\", \"result\": 4, \"comment\": \"Number belongs to a tree service company. Attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-12-2024 16:15:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-15-2024 16:36:32\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1411, NULL, NULL, NULL, '0005765836001', '224029', '', '16281210', 'Barry', 'Davidson', '', '{\"DOB\": 23063, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1598920357, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DEMOREST\", \"Pcp_Name\": \"RAVIN TALATI\", \"PCP_Phone\": 7067543113, \"Pcp_State\": \"GA\", \"Member_City\": \"Clarksville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"purnville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-02-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"101 ADAMS DRIVE  DNE\", \"Screening_IHA\": \"No\", \"member_id_two\": 224029, \"Member_Country\": \"Habersham\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"256 Snow Shoe Lane\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305230000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"P.O box 187\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30580, \"Member_Last_name\": \"Davidson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Barry\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bigred@hemc.net\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069680071, \"Member_Identification_Number\": \"0005765836001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:54\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:54\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:31\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T14:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T18:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T15:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-28T18:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:31\", \"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-06-04T14:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T18:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-28T18:30\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:31\"}]', '{\"utc\": [{\"date\": \"2024-10-30T13:58\", \"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\": \"05:58:55\", \"value\": [{\"add\": \"256 Snow Shoe Lane\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-02-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069680071, \"zip\": 305230000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarksville\", \"gend\": 0, \"insh\": \"0005765836001\", \"mzip\": 30580, \"name\": \"Barry Davidson\", \"plan\": \"Alliant\", \"pphy\": \"RAVIN TALATI\", \"ppno\": 7067543113, \"cliId\": \"\", \"email\": \"bigred@hemc.net\", \"ename\": \"\", \"madd1\": \"P.O box 187\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"purnville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"101 ADAMS DRIVE  DNE\", \"pcpnpi\": 1598920357, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DEMOREST\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 11:52 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/5/2024 @ 06:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:31 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/28/2024 @ 06:30 PM\", \"result\": 3, \"comment\": \"06/28/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/12/2024 @ 06:30 PM\"}, {\"date\": \"6/27/2024 @ 03:13 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBBIE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 03:13 PM\"}, {\"date\": \"6/20/2024 @ 06:28 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/27/2024 @ 06:28 PM\"}, {\"date\": \"6/4/2024 @ 02:52 PM\", \"result\": 3, \"comment\": \"called and left VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Cathy Reyes\", \"callbackDate\": \"6/5/2024 @ 02:51 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 14:52:00\", \"schedulerId\": \"16281210\", \"schedulerLeadId\": \"16281210\"}]}', '{\"date\": \"07-03-2024 17:31:49\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1412, NULL, NULL, NULL, '0005766544002', '377180', '', NULL, 'MERRITT', 'MYERS', '', '{\"DOB\": 32453, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1063478691, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BLAIRSVILLE\", \"Pcp_Name\": \"Alan Sanders\", \"PCP_Phone\": 7067458849, \"Pcp_State\": \"GA\", \"Member_City\": \"BLAIRSVILLE\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"BLAIRSVILLE\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1988-11-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"401 PAT HARALSON DR UNIT 2\", \"Screening_IHA\": \"No\", \"member_id_two\": 377180, \"Member_Country\": \"UNION\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"187 NAVAHO RD LOT 3\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30512, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 2072\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30514, \"Member_Last_name\": \"MYERS\", \"Medication_Review\": \"N\", \"Member_first_name\": \"MERRITT\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 161.2, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0005766544002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:54\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:54\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:58:55\", \"value\": [{\"add\": \"187 NAVAHO RD LOT 3\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1988-11-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30512, \"add2\": \"\", \"add3\": \"\", \"city\": \"BLAIRSVILLE\", \"gend\": 1, \"insh\": \"0005766544002\", \"mzip\": 30514, \"name\": \"MERRITT MYERS\", \"plan\": \"Alliant\", \"pphy\": \"Alan Sanders\", \"ppno\": 7067458849, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO BOX 2072\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"BLAIRSVILLE\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"401 PAT HARALSON DR UNIT 2\", \"pcpnpi\": 1063478691, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BLAIRSVILLE\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1413, NULL, NULL, NULL, '0005767881001', '371186', '', '2661185', 'Milus', 'Maney', '', '{\"DOB\": 22169, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1588658330, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"TOCCOA\", \"Pcp_Name\": \"William Mills\", \"PCP_Phone\": 7702199000, \"Pcp_State\": \"GA\", \"Member_City\": \"Eastanollee\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Eastanollee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-09-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"58 BIG A RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 371186, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1710 Highway 145\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30538, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1710 Highway 145\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30538, \"Member_Last_name\": \"Maney\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Milus\", \"Member_Middle_name\": \"T\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Sheilamae0758@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7162446236, \"Member_Identification_Number\": \"0005767881001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:54\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-05-10T16:07\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-13T13:30\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-17T11:21\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-20T15:41\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-08T19:08\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-29T16:21\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-20T10:38\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-13T13:30\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T15:41\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-08T19:08\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-29T16:21\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-20T10:38\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:44\"}]', '{\"utc\": [{\"date\": \"2024-10-30T13:58\", \"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\": \"05:58:55\", \"value\": [{\"add\": \"1710 Highway 145\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-09-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7162446236, \"zip\": 30538, \"add2\": \"\", \"add3\": \"\", \"city\": \"Eastanollee\", \"gend\": 0, \"insh\": \"0005767881001\", \"mzip\": 30538, \"name\": \"Milus T Maney\", \"plan\": \"Alliant\", \"pphy\": \"William Mills\", \"ppno\": 7702199000, \"cliId\": \"\", \"email\": \"Sheilamae0758@gmail.com\", \"ename\": \"\", \"madd1\": \"1710 Highway 145\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Eastanollee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"58 BIG A RD\", \"pcpnpi\": 1588658330, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"TOCCOA\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"10/30/2024 @ 02:36 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 10:38 AM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a virtual HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 04:21 PM\", \"result\": 10, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm or w/NP Faith Enwefah line disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/8/2024 @ 07:08 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"5/20/2024 @ 03:41 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:41 PM\"}, {\"date\": \"5/17/2024 @ 11:21 AM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 11:21 AM\"}, {\"date\": \"5/13/2024 @ 01:30 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"5/23/2024 @ 01:29 PM\"}, {\"date\": \"5/10/2024 @ 04:07 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:07 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:07:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-11-2024 00:44:06\", \"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 05:58:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1414, NULL, NULL, NULL, '0005769195001', '379124', '', '21881792', 'Deanna', 'Anderson', '', '{\"DOB\": 25492, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1720163868, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Holly Coleman\", \"PCP_Phone\": 7705329250, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-10-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"440 WASHINGTON ST SE\", \"Screening_IHA\": \"No\", \"member_id_two\": 379124, \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1306 Coventry Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30504, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"8715Covestone dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"Anderson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Deanna\", \"Member_Middle_name\": \"Kimberly\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dkanderson1016@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7635161159, \"Member_Identification_Number\": \"0005769195001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-19T18:34\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T13:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T19:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T13:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-19T18:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-15T15:24\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-25T17:17\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T17:17\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T15:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T19:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T13:33\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-19T18:34\"}]', '{\"utc\": [{\"date\": \"2024-10-30T13:58\", \"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\": \"05:58:56\", \"value\": [{\"add\": \"1306 Coventry Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-10-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7635161159, \"zip\": 30504, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0005769195001\", \"mzip\": 30506, \"name\": \"Deanna Kimberly Anderson\", \"plan\": \"Alliant\", \"pphy\": \"Holly Coleman\", \"ppno\": 7705329250, \"cliId\": \"\", \"email\": \"dkanderson1016@gmail.com\", \"ename\": \"\", \"madd1\": \"8715Covestone dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"440 WASHINGTON ST SE\", \"pcpnpi\": 1720163868, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GAINESVILLE\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 01:15 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:07 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\": \"7/19/2024 @ 06:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 01:33 PM\", \"result\": 3, \"comment\": \"Called to set up HRA with Faith Enwefah Left voicemail\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 07:32 PM\", \"result\": 13, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 07:32 PM\"}, {\"date\": \"6/4/2024 @ 01:46 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/11/2024 @ 01:46 PM\"}, {\"date\": \"5/15/2024 @ 03:24 PM\", \"result\": 14, \"comment\": \"Member is currently going through some things and asks that we call back later in the year. Placed as a F2F callback. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/8/2024 @ 03:24 PM\"}, {\"date\": \"4/25/2024 @ 05:17 PM\", \"result\": 6, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/28/2024 @ 05:17 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 15:24:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-19-2024 18:34:33\", \"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 05:58:56', 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
(1415, NULL, NULL, NULL, '0005771106001', '364326', '', '2661185', 'Mikala', 'Moore', '', '{\"DOB\": 34650, \"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\": \"Clayton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"CLAYTON\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1994-11-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 364326, \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"148 Golden Pond Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30525, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"164  STAVE MILL ST\", \"Mailing_Address2\": \"APT C1\", \"Mailing_Zip_Code\": 30525, \"Member_Last_name\": \"Moore\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mikala\", \"Member_Middle_name\": \"Ann\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Mikalaannmoore@gmail.com\", \"Member_Suspect_Codes\": \"120, 37.1, 82, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069493098, \"Member_Identification_Number\": \"0005771106001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T16:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:32\", \"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-13T13:31\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-17T11:21\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-13T13:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T15:43\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:32\"}]', '{\"utc\": [{\"date\": \"2024-10-30T13:58\", \"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\": \"05:58:56\", \"value\": [{\"add\": \"148 Golden Pond Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1994-11-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069493098, \"zip\": 30525, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clayton\", \"gend\": 1, \"insh\": \"0005771106001\", \"mzip\": 30525, \"name\": \"Mikala Ann Moore\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Mikalaannmoore@gmail.com\", \"ename\": \"\", \"madd1\": \"164  STAVE MILL ST\", \"madd2\": \"APT C1\", \"madd3\": \"\", \"mcity\": \"CLAYTON\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/29/2024 @ 11:53 AM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/5/2024 @ 06:10 PM\", \"result\": 7, \"comment\": \"Called to Schedule Virtual HRA with Candace but line was busy.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:52 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 03:59 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:32 PM\", \"result\": 7, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"5/20/2024 @ 03:43 PM\", \"result\": 7, \"comment\": \"LINE BUSY - UNABLE TO LEAVE A MESSAGE.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:43 PM\"}, {\"date\": \"5/17/2024 @ 11:21 AM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 11:21 AM\"}, {\"date\": \"5/13/2024 @ 01:31 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"5/20/2024 @ 01:31 PM\"}, {\"date\": \"5/10/2024 @ 04:09 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:09 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:09:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 17:32:40\", \"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 05:58:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1416, NULL, NULL, NULL, '0005771276001', '374163', '', '2661185', 'James', 'Hutto', '', '{\"DOB\": 22605, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1538239389, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"JEFFREY STEPHENS\", \"PCP_Phone\": 4783014111, \"Pcp_State\": \"GA\", \"Member_City\": \"Macon\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-11-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"180 EMERY HWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 374163, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"855 College St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31201, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"855 College St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31201, \"Member_Last_name\": \"Hutto\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"Alfred\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Jimhutto00@gmail.com\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4787315213, \"Member_Identification_Number\": \"0005771276001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T19:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-07T12:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T16:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T16:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-07-02T16:58\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2024-07-16T18:50\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2024-07-23T19:08\", \"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-29T19:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T12:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T16:42\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-07-02T16:58\", \"reportStatus_date\": \"2024-07-02T16:58\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-07-16T18:50\", \"reportStatus_date\": \"2024-07-16T18:50\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-07-23T19:08\", \"reportStatus_date\": \"2024-07-23T19:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-07-02T16:58\", \"username\": null}, {\"date\": \"2024-07-16T18:50\", \"username\": null}, {\"date\": \"2024-07-23T19:08\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:58:57\", \"value\": [{\"add\": \"855 College St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-11-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4787315213, \"zip\": 31201, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 0, \"insh\": \"0005771276001\", \"mzip\": 31201, \"name\": \"James Alfred Hutto\", \"plan\": \"Alliant\", \"pphy\": \"JEFFREY STEPHENS\", \"ppno\": 4783014111, \"cliId\": \"\", \"email\": \"Jimhutto00@gmail.com\", \"ename\": \"\", \"madd1\": \"855 College St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"180 EMERY HWY\", \"pcpnpi\": 1538239389, \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-07-02T16:58\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-07-16T18:50\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-07-23T19:08\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"7/23/2024 @ 07:08 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 06:50 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 04:58 PM\", \"result\": 9, \"comment\": \"REFUSAL - Member declined offer prior to/after stating reason for call. Member then disconnected call.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 04:42 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 @ 04:42 PM\"}, {\"date\": \"6/12/2024 @ 04:18 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 04:18 PM\"}, {\"date\": \"6/7/2024 @ 12:54 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBORAH YORK MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 12:54 PM\"}, {\"date\": \"4/29/2024 @ 07:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/30/2024 @ 07:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 19:34:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:57', 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
(1417, 93442164, 44829497, '62685179', '0005772535001', '369801', '', '2661185', 'Rileigh', 'Smith', '', '{\"DOB\": 34311, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1225300494, \"Pcp_Zip\": \"30535\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"DEMOREST\", \"Pcp_Name\": \"DEREK KLEMM\", \"PCP_Phone\": 7067544348, \"Pcp_State\": \"GA\", \"Member_City\": \"Clarkesville\", \"Office_Name\": \"Medlink Pharmacy-Habersham\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-12-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"396 HISTORIC HIGHWAY 441 N\", \"Screening_IHA\": \"No\", \"member_id_two\": 369801, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"7067540731\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"806 Railroad Ave\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"806 Railroad Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Last_name\": \"Smith\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rileigh\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"rileighsmith41@outlook.com\", \"Member_Suspect_Codes\": \"48, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7622850137, \"Member_Identification_Number\": \"0005772535001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-13-2024 08:59:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-13 08:59:10\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:33\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T16:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T10:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-23T11:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T14:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-05T15:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T20:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T21:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-13T08:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-01T13:56\", \"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-25T16:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T10:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T11:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T14:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-08-05T15:01\", \"reportStatus_date\": \"2024-08-05T15:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-06T21:40\", \"reportStatus_date\": \"2024-08-06T21:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-13T08:59\", \"reportStatus_date\": \"2024-08-13T08:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-13T08:59\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-01T13:56\", \"username\": null}, {\"date\": \"2024-08-01T13:56\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-05T07:04\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-08-05T15:59\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-05T15:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-08-05T15:01\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-06T21:40\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-06T20:27\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-06T21:40\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-23-2025\", \"time\": \"06:11:01\", \"value\": [{\"add\": \"806 Railroad Ave\", \"age\": 31, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-12-08\", \"eno\": \"478 538 0603\", \"lob\": \"On Exchange\", \"pno\": 7622850137, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 1, \"insh\": \"0005772535001\", \"mzip\": 30523, \"name\": \"Rileigh Smith\", \"plan\": \"Alliant\", \"pphy\": \"DEREK KLEMM\", \"ppno\": 7067544348, \"cliId\": \"\", \"email\": \"rileighsmith41@outlook.com\", \"ename\": \"Sharon Smith\", \"madd1\": \"806 Railroad Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"396 HISTORIC HIGHWAY 441 N\", \"pcpnpi\": 1225300494, \"pcpzip\": \"30535\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"DEMOREST\", \"pcpname\": \"Medlink Pharmacy-Habersham\", \"program\": \"ACA\", \"pcpfaxno\": \"7067540731\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-01-2024\", \"time\": \"17:44:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-23-2025 06:11:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/1/2024 @ 01:56 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/ Faith Enwefah on 8/5 @ 1pm - doxy/android - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 03:07 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 04:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:33 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 02:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 02:12 PM\"}, {\"date\": \"5/23/2024 @ 11:58 AM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/30/2024 @ 11:58 AM\"}, {\"date\": \"5/16/2024 @ 10:58 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 10:58 AM\"}, {\"date\": \"4/25/2024 @ 04:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 04:34 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005772535001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0005772535001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0005772535001\", \"scheduleDate\": \"2024-8-5T13:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:34:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-01-2024 13:56:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 0, NULL, '[{\"date\": \"2024-08-13 08:59:09\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"d47bd1bd-5973-11ef-a05d-ebb1a4760587\\\",\\\"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-8-5T13:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:57', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005772535001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005772535001_Smith, Rileigh_08052024.pdf\", \"ftp_upload_date\": \"2024-08-13 08:59:08\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_KLEMM, DEREK_0005772535001_08052024.pdf\"}', 'ACA_0005772535001_Smith, Rileigh_08052024', NULL, 'PCP_KLEMM, DEREK_0005772535001_08052024', NULL, '[{\"date\": \"2024-08-05T19:01:07.453Z\", \"signature\": \"data:image/png;base64,[encoded data, 23412 characters]\"}]', '2024-08-05T14:00', 'Member_Summary_0005772535001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005772535001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005772535001.pdf\", \"member_ftp_upload_date\": \"2024-08-13 08:59:10\"}', NULL, NULL, NULL, NULL),
(1418, NULL, NULL, NULL, '0005773414001', '353438', '', '2661185', 'Terry', 'Plott', '', '{\"DOB\": 21874, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1316960123, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BLAIRSVILLE\", \"Pcp_Name\": \"Kathryn Blocker\", \"PCP_Phone\": 8283892273, \"Pcp_State\": \"GA\", \"Member_City\": \"Blairsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Young Harris\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-11-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"123A-2 WEAVER RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 353438, \"Member_Country\": \"UNION\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"53 Brasstown View\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30512, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 521\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30582, \"Member_Last_name\": \"Plott\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Terry\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"plotttown@yahoo.com\", \"Member_Suspect_Codes\": \"142, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068977987, \"Member_Identification_Number\": \"0005773414001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"11-22-2024 23:30:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-11-22 23:30:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T16:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T11:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-06-27T15:19\", \"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-05-10T16:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T15:46\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-27T15:19\", \"reportStatus_date\": \"2024-06-27T15:19\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-27T15:19\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:58:57\", \"value\": [{\"add\": \"53 Brasstown View\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-11-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068977987, \"zip\": 30512, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blairsville\", \"gend\": 0, \"insh\": \"0005773414001\", \"mzip\": 30582, \"name\": \"Terry D Plott\", \"plan\": \"Alliant\", \"pphy\": \"Kathryn Blocker\", \"ppno\": 8283892273, \"cliId\": \"\", \"email\": \"plotttown@yahoo.com\", \"ename\": \"\", \"madd1\": \"PO BOX 521\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Young Harris\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"123A-2 WEAVER RD\", \"pcpnpi\": 1316960123, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BLAIRSVILLE\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-27T15:19\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"6/27/2024 @ 03:19 PM\", \"result\": 9, \"comment\": \"REFUSAL DOES NOT WANT TO COMPLETE IT \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"5/20/2024 @ 03:46 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:46 PM\"}, {\"date\": \"5/17/2024 @ 11:21 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/20/2024 @ 11:20 AM\"}, {\"date\": \"5/10/2024 @ 04:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:11 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:11:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:14\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:57', 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
(1419, NULL, NULL, NULL, '0005773461001', '355960', '', '2661185', 'Travis', 'Bagley', '', '{\"DOB\": 24439, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1205029352, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MC RAE\", \"Pcp_Name\": \"BRIAN SIDDALL\", \"PCP_Phone\": 2298680017, \"Pcp_State\": \"GA\", \"Member_City\": \"Milan\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Milan\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-11-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"280 E WILLOW CREEK LANE 340B00928900CH\", \"Screening_IHA\": \"No\", \"member_id_two\": 355960, \"Mailing_County\": \"TELFAIR\", \"Member_Country\": \"TELFAIR\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"148 Larry Wells Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 310600000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"148 Larry Wells Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31060, \"Member_Last_name\": \"Bagley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Travis\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"travisbg02@gmail.com\", \"Member_Suspect_Codes\": \"130, 131, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 8636085948, \"Member_Identification_Number\": \"0005773461001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T16:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T11:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-28T18:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:38\", \"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-02T16:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-16T18:51\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-23T19:11\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T16:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T15:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-28T18:32\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T16:59\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T18:51\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-23T19:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:38\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:58:58\", \"value\": [{\"add\": \"148 Larry Wells Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-11-28\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 8636085948, \"zip\": 310600000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Milan\", \"gend\": 0, \"insh\": \"0005773461001\", \"mzip\": 31060, \"name\": \"Travis Bagley\", \"plan\": \"Alliant\", \"pphy\": \"BRIAN SIDDALL\", \"ppno\": 2298680017, \"cliId\": \"\", \"email\": \"travisbg02@gmail.com\", \"ename\": \"\", \"madd1\": \"148 Larry Wells Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Milan\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"280 E WILLOW CREEK LANE 340B00928900CH\", \"pcpnpi\": 1205029352, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MC RAE\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 01:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 07:11 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 06:51 PM\", \"result\": 10, \"comment\": \"07/16/2024 JC: called for HRA-Connie Middleton-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 04:59 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/28/2024 @ 06:32 PM\", \"result\": 3, \"comment\": \"06/28/2024 JC: called for HRA-Faith Enwefah-Virtual: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/12/2024 @ 06:32 PM\"}, {\"date\": \"5/20/2024 @ 03:48 PM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE A MESSAGE.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:48 PM\"}, {\"date\": \"5/17/2024 @ 11:23 AM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE A MESSAGE.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/21/2024 @ 11:23 AM\"}, {\"date\": \"5/10/2024 @ 04:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:13 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:13:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"12-16-2024 00:38:33\", \"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 05:58:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1420, NULL, NULL, NULL, '0005774105001', '385212', '', '21881792', 'Dennis', 'Ball', '', '{\"DOB\": 23639, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1700273828, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATTANOOGA\", \"Pcp_Name\": \"MARY GILLILAND\", \"PCP_Phone\": 4236488480, \"Pcp_State\": \"TN\", \"Member_City\": \"Crandall\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Crandall\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-09-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"5959 SHALLOWFORD RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 385212, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3015 Halls Chapel Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30711, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3015 Halls Chapel Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30711, \"Member_Last_name\": \"Ball\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dennis\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Karenball123@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064834609, \"Member_Identification_Number\": \"0005774105001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T13:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-15T17:22\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-24T15:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-03T11:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-31T18:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T13:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13: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-04-24T15:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-03T11:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-31T18:01\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T13:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-07-15T17:22\", \"reportStatus_date\": \"2024-07-15T17:22\"}]', '{\"utc\": [{\"date\": \"2024-07-15T17:22\", \"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\": \"05:58:58\", \"value\": [{\"add\": \"3015 Halls Chapel Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-09-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064834609, \"zip\": 30711, \"add2\": \"\", \"add3\": \"\", \"city\": \"Crandall\", \"gend\": 0, \"insh\": \"0005774105001\", \"mzip\": 30711, \"name\": \"Dennis Ball\", \"plan\": \"Alliant\", \"pphy\": \"MARY GILLILAND\", \"ppno\": 4236488480, \"cliId\": \"\", \"email\": \"Karenball123@gmail.com\", \"ename\": \"\", \"madd1\": \"3015 Halls Chapel Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Crandall\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"5959 SHALLOWFORD RD\", \"pcpnpi\": 1700273828, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATTANOOGA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"TN\", \"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:24:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:38\"}', '{\"utc\": [{\"date\": \"2024-07-15T17:22\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 12:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:39 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 05:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 04:37 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 04:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 11:27 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 06:44 PM\", \"result\": 1, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 05:36 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:22 PM\", \"result\": 6, \"comment\": \"Member not available.  Call attempt to schedule a virtual HRA w/ Delise Adams.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 01:10 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 01:11 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/12/2024 @ 01:11 PM\"}, {\"date\": \"5/31/2024 @ 06:01 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Deborah York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/7/2024 @ 06:01 PM\"}, {\"date\": \"5/3/2024 @ 11:10 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE DEBBIE Y. 5/7 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/8/2024 @ 11:10 AM\"}, {\"date\": \"4/24/2024 @ 03:46 PM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/25/2024 @ 03:46 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 15:46:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-11-2024 13:10:14\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 14}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:58', 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
(1421, 50892900, 44829497, '62685179', '0005775529001', '383131', '', '2661185', 'Angela', 'Reece', '', '{\"DOB\": 24036, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1073564480, \"Pcp_Zip\": \"30525\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"Dr. Kimberly Martin\", \"PCP_Phone\": \"7067825991\", \"Pcp_State\": \"GA\", \"Member_City\": \"Clayton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clayton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-10-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"896 HIGHWAY 441 S\", \"Screening_IHA\": \"No\", \"member_id_two\": 383131, \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"7067825111\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"597 Duggan Hill Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30525, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 1283\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30525, \"Member_Last_name\": \"Reece\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angela\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"angelareece72@yahoo.com\", \"Member_Suspect_Codes\": \"142, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7064901409, \"Member_Identification_Number\": \"0005775529001\", \"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:33:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:33:39\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-25T06:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-30T09:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-30T13:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-10T16:20\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-10T16:20\", \"reportStatus_date\": \"2024-05-10T16:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-25T06:43\", \"reportStatus_date\": \"2024-05-25T06:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:33\", \"reportStatus_date\": \"2024-05-31T14:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:33\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-10T16:20\", \"username\": null}, {\"date\": \"2024-05-10T16:20\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-24T07:23\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-28T08:19\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-24T07:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T07:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T10:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T10:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:16\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T12:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-25T06:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-25T06:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-29T05:30\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-30T13:53\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-30T09:24\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-30T13:53\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-28T18:51\", \"username\": \"fcopeland1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-28-2024\", \"time\": \"16:09:38\", \"value\": [{\"add\": \"597 Duggan Hill Dr\", \"age\": 58, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-10-21\", \"eno\": \"7069821227\", \"lob\": \"On Exchange\", \"pno\": 7064901409, \"zip\": 30525, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clayton\", \"gend\": 1, \"insh\": \"0005775529001\", \"mzip\": 30525, \"name\": \"Angela Reece\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Kimberly Martin\", \"ppno\": \"7067825991\", \"cliId\": \"\", \"email\": \"angelareece72@yahoo.com\", \"ename\": \"Kelcey Reece\", \"madd1\": \"PO Box 1283\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clayton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"896 HIGHWAY 441 S\", \"pcpnpi\": 1073564480, \"pcpzip\": \"30525\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Widowed\", \"pcpcity\": \"CLAYTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7067825111\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-24-2024\", \"time\": \"07:23:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-28-2024 16:09:38\"}', NULL, NULL, '{\"memberId\": \"0005775529001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"Tue, 28 May 2024 22:55:58 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"MUSCULOSKELETAL-\\\"other\\\"-\\\"symptoms\\\"-appears blank\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 29 May 2024 09:30:43 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Angela Reece\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/24/2024 11:00 AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"fcopeland@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/10/2024 @ 04:20 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Faith Enwefah for 5/24/24 @ 11:00am- MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005775529001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0005775529001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0005775529001\", \"scheduleDate\": \"2024-5-24T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:20:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-10-2024 16:20:02\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:33:38\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"4bd4d656-1f7c-11ef-851b-c14ab611f149\\\",\\\"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-5-24T11:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:58', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005775529001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005775529001_Reece, Angela_05242024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:33:37\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Martin, Kimberly_0005775529001_05242024.pdf\"}', 'ACA_0005775529001_Reece, Angela_05242024', NULL, 'PCP_Martin, Kimberly_0005775529001_05242024', NULL, '[{\"date\": \"2024-05-25T10:43:54.012Z\", \"signature\": \"data:image/png;base64,[encoded data, 23432 characters]\"}, {\"date\": \"2024-05-29T09:30:43.314Z\", \"signature\": \"data:image/png;base64,[encoded data, 23420 characters]\"}]', '2024-05-24T12:00', 'Member_Summary_0005775529001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005775529001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005775529001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:33:39\"}', 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
(1422, 2888643, 44829497, '62685179', '0005776575001', '369207', '', '2661185', 'Michael', 'Chase', '', '{\"DOB\": 22543, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1225012446, \"Pcp_Zip\": \"30577\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"TOCCOA\", \"Pcp_Name\": \"Dr. Thomas Yates\", \"PCP_Phone\": \"7068866819\", \"Pcp_State\": \"GA\", \"Member_City\": \"Toccoa\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Toccoa\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-09-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"58 BIG A RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 369207, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"7068275008\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4444 Riverdale Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30577, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4444 Riverdale Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30577, \"Member_Last_name\": \"Chase\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Member_Middle_name\": \"Walter\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"MichaelChase@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4044033896, \"Member_Identification_Number\": \"0005776575001\", \"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:33:46\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:33:46\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-14T15:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-20T07:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-20T14:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-10T16:27\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-12T06:35\", \"reportStatus_date\": \"2024-05-10T16:27\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-20T14:37\", \"reportStatus_date\": \"2024-05-20T14:37\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:33\", \"reportStatus_date\": \"2024-05-31T14:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:33\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-10T16:27\", \"username\": null}, {\"date\": \"2024-05-10T16:27\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-11T19:36\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-14T17:05\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-12T06:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-12T06:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-12T06:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-12T06:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-12T06:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-12T06:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T10:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:33\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T11:57\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:57\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-19T05:45\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-20T14:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-20T07:44\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-20T14:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-16T11:10\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-28-2024\", \"time\": \"16:15:22\", \"value\": [{\"add\": \"4444 Riverdale Rd\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-09-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4044033896, \"zip\": 30577, \"add2\": \"\", \"add3\": \"\", \"city\": \"Toccoa\", \"gend\": 0, \"insh\": \"0005776575001\", \"mzip\": 30577, \"name\": \"Michael Walter Chase\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Thomas Yates\", \"ppno\": \"7068866819\", \"cliId\": \"\", \"email\": \"MichaelChase@gmail.com\", \"ename\": \"Jessica brown\", \"madd1\": \"4444 Riverdale Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Toccoa\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"58 BIG A RD\", \"pcpnpi\": 1225012446, \"pcpzip\": \"30577\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"TOCCOA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7068275008\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"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\": \"19:36:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-28-2024 16:15:22\"}', NULL, NULL, '{\"memberId\": \"0005776575001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Thu, 16 May 2024 15:10:51 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThank you for the assessment\\n1. In the medication section,long term use- insulin is selected, but insulin is not listed in the medications. Please review and make\\nany updates\\n2.  The member is being treated for hypokalemia, please add this condition to the HRA\\n3.  In the physical exam- please update the word \\\"virtue\\\". I think you meant \\\"virtual\\\"\\n- In the musculoskeletal system- please comment. \\\"limited assessment\\\"\\n- The diabetic foot exam has NA listed. The member is diabetic, but this was not able to be done due to a virtual visit. Please add a comment\\n- His skin was \\\"normal\\\"- can you comment on his scalp since he is being treated? is the tx working so there are no visible sx?\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 19 May 2024 09:45:40 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Michael Chase\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/14/2024 11:00AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/10/2024 @ 04:27 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual appt w/Faith Enwefah for 5/14/24 @11:00am -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005776575001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0005776575001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0005776575001\", \"scheduleDate\": \"2024-5-14T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:27:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-10-2024 16:27:27\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:33:44\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"4fcdfcc6-1f7c-11ef-a344-c318b235fb2c\\\",\\\"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-5-14T11:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:58', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005776575001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005776575001_Chase, Michael_05142024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:33:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Yates, Thomas_0005776575001_05142024.pdf\"}', 'ACA_0005776575001_Chase, Michael_05142024', NULL, 'PCP_Yates, Thomas_0005776575001_05142024', NULL, '[{\"date\": \"2024-05-14T19:54:50.451Z\", \"signature\": \"data:image/png;base64,[encoded data, 23384 characters]\"}, {\"date\": \"2024-05-19T09:45:39.694Z\", \"signature\": \"data:image/png;base64,[encoded data, 23412 characters]\"}]', '2024-05-14T12:00', 'Member_Summary_0005776575001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005776575001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005776575001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:33:46\"}', 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
(1423, NULL, NULL, NULL, '0005776646001', '289479', '', '21881792', 'Auseno M', 'Angeles', '', '{\"DOB\": 22151, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1013302561, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DALTON\", \"Pcp_Name\": \"ALEJANDRA STAUBS\", \"PCP_Phone\": 7065293245, \"Pcp_State\": \"GA\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-08-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1107 MEMORIAL DR STE G2\", \"Screening_IHA\": \"No\", \"member_id_two\": 289479, \"Mailing_County\": \"Whitfield\", \"Member_Country\": \"Whitfield\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"303 N Spencer St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307213116, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"303 N Spencer St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30721, \"Member_Last_name\": \"Angeles\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Auseno M\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mmoskiro@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7622313338, \"Member_Identification_Number\": \"0005776646001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-23T09:23\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-02T12:24\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-24T09:29\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-06-11T15:24\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-24T09:29\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T09:23\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T15:24\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-02T12:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:42\"}]', '{\"utc\": [{\"date\": \"2024-07-15T17:22\", \"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\": \"05:58:59\", \"value\": [{\"add\": \"303 N Spencer St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-08-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7622313338, \"zip\": 307213116, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 0, \"insh\": \"0005776646001\", \"mzip\": 30721, \"name\": \"Auseno M Angeles\", \"plan\": \"Alliant\", \"pphy\": \"ALEJANDRA STAUBS\", \"ppno\": 7065293245, \"cliId\": \"\", \"email\": \"mmoskiro@gmail.com\", \"ename\": \"\", \"madd1\": \"303 N Spencer St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1107 MEMORIAL DR STE G2\", \"pcpnpi\": 1013302561, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DALTON\", \"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:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 11:23 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:39 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 12:24 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"8/9/2024 @ 12:24 PM\"}, {\"date\": \"6/11/2024 @ 12:24 PM\", \"result\": 6, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: member req call back per perv note member out of country until august   \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/1/2024 @ 12:24 PM\"}, {\"date\": \"5/23/2024 @ 09:23 AM\", \"result\": 14, \"comment\": \"Call attempt to schedule Debbie Y. 5/28 with interpreter Lucas 17312 - member currently working in Texas won\'t be available until 2 months from date of call. Placed as a F2F call back. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/23/2024 @ 09:21 AM\"}, {\"date\": \"4/24/2024 @ 09:29 AM\", \"result\": 6, \"comment\": \"MEMBER REQUESTED A CALL BACK FOR A LATER DATE AND TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/24/2024 @ 09:29 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 09:29:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:42:10\", \"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 05:58:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1424, NULL, NULL, NULL, '0005776857001', '379450', '', '26056802', 'Paul', 'Hall', '', '{\"DOB\": 22826, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1437142320, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DOUGLAS\", \"Pcp_Name\": \"James Sinclair\", \"PCP_Phone\": 9123837826, \"Pcp_State\": \"GA\", \"Member_City\": \"Pearson\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Pearson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-06-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"306 WESTSIDE DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 379450, \"Mailing_County\": \"ATKINSON\", \"Member_Country\": \"ATKINSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"135 GARDNER LN\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31642, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"135 GARDNER LN\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31642, \"Member_Last_name\": \"Hall\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Paul\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"paulhall724@mail.com\", \"Member_Suspect_Codes\": \"130, 142, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9124225191, \"Member_Identification_Number\": \"0005776857001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T17:00\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-08-19T12:33\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-17T11:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T15:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T17:00\", \"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-20T15:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T15:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T17:00\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-08-19T12:33\", \"reportStatus_date\": \"2024-08-19T12:33\"}]', '{\"utc\": [{\"date\": \"2024-08-19T12:33\", \"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\": \"05:58:59\", \"value\": [{\"add\": \"135 GARDNER LN\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-06-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9124225191, \"zip\": 31642, \"add2\": \"\", \"add3\": \"\", \"city\": \"Pearson\", \"gend\": 0, \"insh\": \"0005776857001\", \"mzip\": 31642, \"name\": \"Paul Hall\", \"plan\": \"Alliant\", \"pphy\": \"James Sinclair\", \"ppno\": 9123837826, \"cliId\": \"\", \"email\": \"paulhall724@mail.com\", \"ename\": \"\", \"madd1\": \"135 GARDNER LN\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Pearson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"306 WESTSIDE DR\", \"pcpnpi\": 1437142320, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DOUGLAS\", \"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:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', '{\"utc\": [{\"date\": \"2024-08-19T12:33\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 03:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 10:45 AM\", \"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\": \"8/19/2024 @ 12:33 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Debbie but member requested a call back\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 07:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 06:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 05:00 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 03:29 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBORAH MV\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 03:28 PM\"}, {\"date\": \"5/20/2024 @ 03:53 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:53 PM\"}, {\"date\": \"5/20/2024 @ 03:50 PM\", \"result\": 3, \"comment\": \"5/10 MR LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/20/2024 @ 03:50 PM\"}, {\"date\": \"5/17/2024 @ 11:24 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 11:24 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-17-2024 11:24:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-02-2024 17:00:28\", \"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 05:58:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1425, NULL, NULL, NULL, '0005776886001', '380208', '', '2661185', 'Lee', 'Christensen', '', '{\"DOB\": 25747, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1548202401, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"LINCOLNTON\", \"Pcp_Name\": \"ROBERT WILLIAMS\", \"PCP_Phone\": 7063591115, \"Pcp_State\": \"GA\", \"Member_City\": \"Lincolnton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lincolnton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-06-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"111 S WASHINGTON ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 380208, \"Mailing_County\": \"LINCOLN\", \"Member_Country\": \"LINCOLN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1332 Baker Davis Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30817, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1332 Baker Davis Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30817, \"Member_Last_name\": \"Christensen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"leet1christensen@gmail.com\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2394780584, \"Member_Identification_Number\": \"0005776886001\", \"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:32:55\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:55\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-30T17:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T16:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-30T10:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T16:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-15T17:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-30T17:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-17T11:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-23T09:44\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T16:56\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-17T11:31\", \"reportStatus_date\": \"2024-05-17T11:31\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-23T09:44\", \"reportStatus_date\": \"2024-05-23T09:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T10:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T16:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T17:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-30T17:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-17T11:31\", \"username\": null}, {\"date\": \"2024-05-17T11:31\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-23T09:23\", \"username\": \"DYork\"}], \"qaAssigned\": [], \"readyForQa\": [{\"date\": \"2024-05-23T09:24\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:24\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:24\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:24\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:25\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:25\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:25\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:25\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:26\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:28\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:31\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:35\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:36\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:37\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:37\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T09:42\", \"username\": \"DYork\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-23T09:44\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-23-2024\", \"time\": \"09:36:07\", \"value\": [{\"add\": \"1332 Baker Davis Rd\", \"age\": 53, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-06-28\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2394780584, \"zip\": 30817, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lincolnton\", \"gend\": 0, \"insh\": \"0005776886001\", \"mzip\": 30817, \"name\": \"Lee Christensen\", \"plan\": \"Alliant\", \"pphy\": \"ROBERT WILLIAMS\", \"ppno\": 7063591115, \"cliId\": \"\", \"email\": \"leet1christensen@gmail.com\", \"ename\": \"\", \"madd1\": \"1332 Baker Davis Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lincolnton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"111 S WASHINGTON ST\", \"pcpnpi\": 1548202401, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"LINCOLNTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"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-23-2024\", \"time\": \"09:23:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-23-2024 09:42:34\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-23T09:44\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 01:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 10:04 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 01:44 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\": \"8/19/2024 @ 12:34 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 05:38 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:24 PM\", \"result\": 3, \"comment\": \"07/15/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/29/2024 @ 05:24 PM\"}, {\"date\": \"7/11/2024 @ 01:11 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/29/2024 @ 01:10 PM\"}, {\"date\": \"6/27/2024 @ 04:09 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH  DEBBIE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 04:09 PM\"}, {\"date\": \"5/30/2024 @ 10:48 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL TO RESCHEDULE - Call attempt to reschedule virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 10:48 AM\"}, {\"date\": \"5/17/2024 @ 11:31 AM\", \"result\": 0, \"comment\": \"SCHEDULED DEBBIE Y ON 5/23 @ 9:30 - TEXTED LINK TO MEMBERS PHONE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 04:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:56:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-23-2024 09:44:23\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-30-2024 17:38:22\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:58:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1426, NULL, NULL, NULL, '0005777954001', '367522', '', '2661185', 'Tammy', 'Carter', '', '{\"DOB\": 24296, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1134344195, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"GARY JORDAN\", \"PCP_Phone\": 7708486195, \"Pcp_State\": \"GA\", \"Member_City\": \"Cornelia\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cornelia\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-07-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"597 S ENOTA DR NE\", \"Screening_IHA\": \"No\", \"member_id_two\": 367522, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"156 Sunset Oaks Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30531, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"156 Sunset Oaks Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30531, \"Member_Last_name\": \"Carter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tammy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tlcarter40@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9122231966, \"Member_Identification_Number\": \"0005777954001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T17:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T12:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-23T16:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-06-20T17:09\", \"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-25T17:23\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T12:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T16:20\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-20T17:09\", \"reportStatus_date\": \"2024-06-20T17:09\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-20T17:09\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:00\", \"value\": [{\"add\": \"156 Sunset Oaks Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-07-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9122231966, \"zip\": 30531, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cornelia\", \"gend\": 1, \"insh\": \"0005777954001\", \"mzip\": 30531, \"name\": \"Tammy Carter\", \"plan\": \"Alliant\", \"pphy\": \"GARY JORDAN\", \"ppno\": 7708486195, \"cliId\": \"\", \"email\": \"tlcarter40@yahoo.com\", \"ename\": \"\", \"madd1\": \"156 Sunset Oaks Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cornelia\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"597 S ENOTA DR NE\", \"pcpnpi\": 1134344195, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GAINESVILLE\", \"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:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-20T17:09\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"6/20/2024 @ 05:09 PM\", \"result\": 9, \"comment\": \"Refusal, member not able to schedule because of her work. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}, {\"date\": \"5/23/2024 @ 04:20 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/30/2024 @ 04:20 PM\"}, {\"date\": \"5/16/2024 @ 12:10 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:09 PM\"}, {\"date\": \"4/25/2024 @ 05:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 05:23 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 17:23:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1427, NULL, NULL, NULL, '0005779273001', '367083', '', '26056802', 'Carol', 'Reddicks', '', '{\"DOB\": 24534, \"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\": \"Flowery Branch\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-03-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 367083, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3759 Old Plainview Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3759 Old Plainview Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Last_name\": \"Reddicks\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Carol\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Reddicksc@bellsouth.net\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7707104116, \"Member_Identification_Number\": \"0005779273001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T13:11\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T17:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T12:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T17:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T18:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T17:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T12:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T17:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T18:01\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T13:11\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:00\", \"value\": [{\"add\": \"3759 Old Plainview Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-03-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7707104116, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 1, \"insh\": \"0005779273001\", \"mzip\": 30542, \"name\": \"Carol Reddicks\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Reddicksc@bellsouth.net\", \"ename\": \"\", \"madd1\": \"3759 Old Plainview Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"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:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 04:27 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Faith Enwefah-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 04:15 PM\", \"result\": 1, \"comment\": \"attempt to sched virtual appt w/Nykya Cox\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 12:37 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 05:39 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:25 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 01:11 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 06:01 PM\", \"result\": 1, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 06:01 PM\"}, {\"date\": \"6/3/2024 @ 05:13 PM\", \"result\": 1, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/10/2024 @ 05:13 PM\"}, {\"date\": \"5/13/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/16/2024 @ 12:05 PM\"}, {\"date\": \"4/30/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 05:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 17:55:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-11-2024 13:11:36\", \"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 05:59:00', 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
(1428, NULL, NULL, NULL, '0005786832001', '363139', '', '16281210', 'William', 'Lund', '', '{\"DOB\": 35341, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1063708006, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"MADISON\", \"Pcp_Name\": \"AWHARITEFE URHUOGO\", \"PCP_Phone\": 6784962774, \"Pcp_State\": \"GA\", \"Member_City\": \"Buckhead\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buckhead\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1996-10-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1740 LIONS CLUB RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 363139, \"Mailing_County\": \"PUTNAM\", \"Member_Country\": \"PUTNAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"113A Shadow Lake Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30625, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"113A Shadow Lake Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30625, \"Member_Last_name\": \"Lund\", \"Medication_Review\": \"N\", \"Member_first_name\": \"William\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"llund@cblakeoconee.com\", \"Member_Suspect_Codes\": \"21, 22\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7707147097, \"Member_Identification_Number\": \"0005786832001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:03\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T14:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T15:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T12:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T13:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-30T09:46\", \"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-06-06T15:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T13:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:03\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-30T09:46\", \"reportStatus_date\": \"2024-10-30T09:46\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-11-11T11:37\", \"reportStatus_date\": \"2024-11-11T11:37\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-11T11:37\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T09:46\", \"username\": null}, {\"date\": \"2024-10-30T09:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:15\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-08-2024\", \"time\": \"01:15:06\", \"value\": [{\"add\": \"113A Shadow Lake Dr\", \"age\": 28, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1996-10-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7707147097, \"zip\": 30625, \"add2\": \"\", \"add3\": \"\", \"city\": \"Buckhead\", \"gend\": 0, \"insh\": \"0005786832001\", \"mzip\": 30625, \"name\": \"William Lund\", \"plan\": \"Alliant\", \"pphy\": \"AWHARITEFE URHUOGO\", \"ppno\": 6784962774, \"cliId\": \"\", \"email\": \"llund@cblakeoconee.com\", \"ename\": \"\", \"madd1\": \"113A Shadow Lake Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buckhead\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1740 LIONS CLUB RD\", \"pcpnpi\": 1063708006, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MADISON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"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\": \"11-08-2024\", \"time\": \"01:15:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-08-2024 07:46:50\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-11-11T11:37\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 09:46 AM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : scheduled for 11/08 @ 11:30am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 04:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 03:53 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 @ 02:54 PM\", \"result\": 13, \"comment\": \"Called to Schedule Virtual HRA with Faith caller disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/7/2024 @ 01:43 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 07:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 06:55 PM\", \"result\": 3, \"comment\": \"07/16/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 01:34 PM\", \"result\": 3, \"comment\": \"06/17/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/1/2024 @ 01:33 PM\"}, {\"date\": \"6/13/2024 @ 12:15 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/14/2024 @ 12:15 PM\"}, {\"date\": \"6/6/2024 @ 03:12 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/7/2024 @ 03:11 PM\"}, {\"date\": \"6/4/2024 @ 02:53 PM\", \"result\": 3, \"comment\": \"called and left a VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Cathy Reyes\", \"callbackDate\": \"6/5/2024 @ 02:53 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 14:53:00\", \"schedulerId\": \"16281210\", \"schedulerLeadId\": \"16281210\"}, {\"date\": \"11-11-2024 11:37:40\", \"schedulerId\": \"16281210\", \"schedulerLeadId\": \"16281210\"}]}', '{\"date\": \"11-11-2024 11:37:40\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1429, NULL, NULL, NULL, '0005786924001', '370907', '', '2661185', 'Shacize', 'Raiford', '', '{\"DOB\": 31747, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1700179983, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"THOMASVILLE\", \"Pcp_Name\": \"Aymen Bukannan\", \"PCP_Phone\": 2295844100, \"Pcp_State\": \"GA\", \"Member_City\": \"Quitman\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Quitman\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1986-12-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"112 MIMOSA DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 370907, \"Mailing_County\": \"BROOKS\", \"Member_Country\": \"BROOKS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"805 W Stewart St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31643, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"805 W Stewart St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31643, \"Member_Last_name\": \"Raiford\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shacize\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"candiceraiford@gmail.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294449288, \"Member_Identification_Number\": \"0005786924001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:04\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T16:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T11:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T16:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:04\", \"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-10T16:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T15:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T16:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:04\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:01\", \"value\": [{\"add\": \"805 W Stewart St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1986-12-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294449288, \"zip\": 31643, \"add2\": \"\", \"add3\": \"\", \"city\": \"Quitman\", \"gend\": 1, \"insh\": \"0005786924001\", \"mzip\": 31643, \"name\": \"Shacize Raiford\", \"plan\": \"Alliant\", \"pphy\": \"Aymen Bukannan\", \"ppno\": 2295844100, \"cliId\": \"\", \"email\": \"candiceraiford@gmail.com\", \"ename\": \"\", \"madd1\": \"805 W Stewart St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Quitman\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"112 MIMOSA DR\", \"pcpnpi\": 1700179983, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"THOMASVILLE\", \"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:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 03:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 11:27 AM\", \"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/16/2024 @ 06:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:04 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting. Call attempt to schedule F2F HRA.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 04:12 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH  DEBBIE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 04:11 PM\"}, {\"date\": \"5/20/2024 @ 03:55 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:55 PM\"}, {\"date\": \"5/17/2024 @ 11:26 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 11:26 AM\"}, {\"date\": \"5/10/2024 @ 04:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:56:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:04:54\", \"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 05:59:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
