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
(1877, 2888643, 44829497, '62685179', '0006619582001', '400922', '', '26056802', 'BRENDA', 'WHITLOCK', '', '{\"DOB\": 24138, \"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\": 1225101371, \"Pcp_Zip\": \"30601\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Athens\", \"Pcp_Name\": \"Dr. Kelly Mackey\", \"PCP_Phone\": \"7063536000\", \"Pcp_State\": \"GA\", \"Member_City\": \"Martin\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Martin\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-01-31\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"485 Highway 29 North\", \"Screening_IHA\": \"No\", \"member_id_two\": 400922, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"7063532769\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"10834 Historic Hwy 17\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30557, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"10834 Historic Hwy 17\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30557, \"Member_Last_name\": \"WHITLOCK\", \"Medication_Review\": \"N\", \"Member_first_name\": \"BRENDA\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"brendawhitlock119@gmail.com\", \"Member_Suspect_Codes\": \"188, 20, 21, 74\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7063915190, \"Member_Identification_Number\": \"0006619582001\", \"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:36:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:36:35\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-24T06:25\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-29T10:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-29T10:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-17T13:51\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-14T14:27\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-17T13:51\", \"reportStatus_date\": \"2024-05-17T13:51\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-24T06:25\", \"reportStatus_date\": \"2024-05-24T06:25\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:36\", \"reportStatus_date\": \"2024-05-31T14:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:36\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-17T13:51\", \"username\": null}, {\"date\": \"2024-05-17T13:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-23T06:18\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-24T11:17\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-23T06:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T06:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T06:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T13:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T13:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T13:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T13:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:33\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:57\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T14:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T15:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T05:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T05:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T05:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T05:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T05:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T06:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-28T14:03\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-29T10:37\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-29T10:24\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-29T10:37\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-28T12:09\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"14:14:06\", \"value\": [{\"add\": \"10834 Historic Hwy 17\", \"age\": 58, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-01-31\", \"eno\": \"706 2971936\", \"lob\": \"On Exchange\", \"pno\": 7063915190, \"zip\": 30557, \"add2\": \"\", \"add3\": \"\", \"city\": \"Martin\", \"gend\": 1, \"insh\": \"0006619582001\", \"mzip\": 30557, \"name\": \"BRENDA WHITLOCK\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Kelly Mackey\", \"ppno\": \"7063536000\", \"cliId\": \"\", \"email\": \"brendawhitlock119@gmail.com\", \"ename\": \"Kimberly Hunt\", \"madd1\": \"10834 Historic Hwy 17\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Martin\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"485 Highway 29 North\", \"pcpnpi\": 1225101371, \"pcpzip\": \"30601\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpcity\": \"Athens\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7063532769\", \"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-23-2024\", \"time\": \"06:18:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 14:14:06\"}', NULL, NULL, '{\"memberId\": \"0006619582001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Tue, 28 May 2024 16:09:22 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\n1.  IN the medical history, specialists being seen- nephrologist is listed, but the reason has liver - please review and make any updates\\n2.  In the assessment of diagnosis, GI, please add any recommendations at the end of this section. \\n3.  Are you able to add any details on the cause of CKD? In the PAT it is listed a few ways, so I wanted to clarify if it was due to Diabetes?\\nThank you,\\nJessica\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 28 May 2024 18:03:39 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"BRENDA WHITLOCK\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/23/2024 02:00PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/17/2024 @ 01:51 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/ Faith Enwefah on 5/23 @ 2pm - doxy - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"5/14/2024 @ 02:27 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA w/ Nykea Cox - Member complained there was an echo and could not hear me  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/15/2024 @ 02:27 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006619582001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006619582001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006619582001\", \"scheduleDate\": \"2024-5-23T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 14:27:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-17-2024 13:51:23\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:36:33\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"b4788ed0-1f7c-11ef-8a35-116238dec44c\\\",\\\"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-23T14:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:17', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006619582001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006619582001_WHITLOCK, BRENDA_05232024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:36:33\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Mackey, Kelly_0006619582001_05232024.pdf\"}', 'ACA_0006619582001_WHITLOCK, BRENDA_05232024', NULL, 'PCP_Mackey, Kelly_0006619582001_05232024', NULL, '[{\"date\": \"2024-05-24T10:25:55.895Z\", \"signature\": \"data:image/png;base64,[encoded data, 23460 characters]\"}, {\"date\": \"2024-05-28T18:03:39.178Z\", \"signature\": \"data:image/png;base64,[encoded data, 23460 characters]\"}]', '2024-05-23T15:00', 'Member_Summary_0006619582001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006619582001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006619582001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:36:35\"}', 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
(1878, 2888643, 44829497, '56716210', '0006620004001', '414385', '', '21881792', 'Cathy', 'Rabun', '', '{\"DOB\": 21950, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \" Cumming\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cumming\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-02-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 414385, \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7931 Heardsville Cir\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": \"30028\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7931 Heardsville Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30028, \"Member_Last_name\": \"Rabun\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Cathy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 130, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6786150825, \"Member_Identification_Number\": \"0006620004001\", \"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:36:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:36:41\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-19T00:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-22T14:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-23T00:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-15T09:31\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-15T15:49\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-20T22:59\", \"reportStatus_date\": \"2024-05-19T00:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-23T00:04\", \"reportStatus_date\": \"2024-05-23T00:04\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:36\", \"reportStatus_date\": \"2024-05-31T14:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:36\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-15T09:31\", \"username\": null}, {\"date\": \"2024-05-15T09:31\", \"username\": null}, {\"date\": \"2024-05-15T15:49\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-17T05:02\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-05-19T11:46\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-17T05:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T05:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T05:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T05:15\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-17T05:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:42\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:47\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:54\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T22:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:03\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:14\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:20\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:23\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:26\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:29\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:35\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:38\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:42\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:45\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:48\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:50\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-18T23:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:01\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:02\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:08\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:11\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:15\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:18\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:19\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-19T00:19\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-20T22:59\", \"username\": \"DAdams\"}, {\"date\": \"2024-05-22T02:04\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-23T00:04\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-22T14:03\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-23T00:04\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-20T07:03\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-21T16:02\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-22T02:03\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-08-2025\", \"time\": \"01:08:03\", \"value\": [{\"add\": \"7931 Heardsville Cir\", \"age\": 65, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-02-04\", \"eno\": \"7704801639\", \"lob\": \"On Exchange\", \"pno\": 6786150825, \"zip\": \"30028\", \"add2\": \"\", \"add3\": \"\", \"city\": \" Cumming\", \"gend\": 1, \"insh\": \"0006620004001\", \"mzip\": 30028, \"name\": \"Cathy Rabun\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Richard Rabun\", \"madd1\": \"7931 Heardsville Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cumming\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-05-17 01:40 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"Needs a new PCP. Ebimoboere Okoro is out of network. \", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-15-2024\", \"time\": \"18:36:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-08-2025 01:08:03\"}', NULL, NULL, '{\"memberId\": \"0006620004001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Mon, 20 May 2024 11:03:22 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 02:59:41 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Added the statement to patient summary.\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 20:02:28 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n1. IN the medical history section, the question asking about surgery in the last year is blank. \\nthank you,\\nJessica\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 22 May 2024 06:04:02 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrected. Thank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Cathy Rabun\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/17/2024 01:40PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/15/2024 @ 09:31 AM\", \"result\": 0, \"comment\": \"SCHEDULED DELISE A. 5/17 AM - MEMBER HAS 4 CATS, PLEASE PARK IN DRIVEWAY. UPDATED MEMBERS ADDRESS 7931 HEARDSVILLE CIR, CUMMING GA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006620004001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006620004001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006620004001\", \"scheduleDate\": \"2024-5-17T09:29\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 09:31:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-15-2024 15:49:07\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:36:39\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"b83a9f5f-1f7c-11ef-8dfc-c7ac7286e808\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-5-17T10:30', '2024-12-31', '2024-05-17T13:40', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:18', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006620004001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006620004001_Rabun, Cathy_05172024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:36:39\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, _0006620004001_05172024.pdf\"}', 'ACA_0006620004001_Rabun, Cathy_05172024', NULL, 'PCP_, _0006620004001_05172024', NULL, '[{\"date\": \"2024-05-19T04:19:45.098Z\", \"signature\": \"data:image/png;base64,[encoded data, 23456 characters]\"}, {\"date\": \"2024-05-21T02:59:41.759Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}, {\"date\": \"2024-05-22T06:04:02.309Z\", \"signature\": \"data:image/png;base64,[encoded data, 23468 characters]\"}]', '2024-05-17T14:45', 'Member_Summary_0006620004001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006620004001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006620004001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:36:41\"}', 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
(1879, NULL, NULL, NULL, '0006622868001', '389375', '', '84555898', 'Kassell', 'Asbeury', '', '{\"DOB\": 26855, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1831784065, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"FLINTSTONE\", \"Pcp_Name\": \"STEPHANIE PIERCE\", \"PCP_Phone\": 7069353600, \"Pcp_State\": \"GA\", \"Member_City\": \"La Fayette\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Fort Oglethorpe\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-07-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"3257 CHATTANOOGA VALLEY RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 389375, \"Member_Country\": \"WALKER\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5780 Round Pond Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30728, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 2391\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30742, \"Member_Last_name\": \"Asbeury\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kassell\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kasbeury10@icloud.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4236053894, \"Member_Identification_Number\": \"0006622868001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:37\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:37\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-06-04T16:49\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-04T16:49\", \"reportStatus_date\": \"2024-06-04T16:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-04T16:49\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:18\", \"value\": [{\"add\": \"5780 Round Pond Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-07-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4236053894, \"zip\": 30728, \"add2\": \"\", \"add3\": \"\", \"city\": \"La Fayette\", \"gend\": 1, \"insh\": \"0006622868001\", \"mzip\": 30742, \"name\": \"Kassell Asbeury\", \"plan\": \"Alliant\", \"pphy\": \"STEPHANIE PIERCE\", \"ppno\": 7069353600, \"cliId\": \"\", \"email\": \"kasbeury10@icloud.com\", \"ename\": \"\", \"madd1\": \"PO Box 2391\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Fort Oglethorpe\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"3257 CHATTANOOGA VALLEY RD\", \"pcpnpi\": 1831784065, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"FLINTSTONE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:01\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-04T16:49\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"6/4/2024 @ 04:49 PM\", \"result\": 9, \"comment\": \"MEMBER REFUSED\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 16:49:00\", \"schedulerId\": \"84555898\", \"schedulerLeadId\": \"84555898\"}]}', '{\"date\": \"04-22-2024 00:31:36\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1880, NULL, NULL, NULL, '0006625741001', '412053', '', '21881792', 'Jason', 'Long', '', '{\"DOB\": 28374, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-09-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412053, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1600 Hwy 27 S\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1600 Hwy 27 S\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Long\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jason\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"longjason131@gmail.com\", \"Member_Suspect_Codes\": \"130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4704099077, \"Member_Identification_Number\": \"0006625741001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:37\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:37\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-27T12:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-04-29T16:00\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-10-09T13:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T16:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T15:05\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T13:59\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:18\", \"value\": [{\"add\": \"1600 Hwy 27 S\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-09-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4704099077, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 0, \"insh\": \"0006625741001\", \"mzip\": 30117, \"name\": \"Jason Long\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"longjason131@gmail.com\", \"ename\": \"\", \"madd1\": \"1600 Hwy 27 S\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"10/29/2024 @ 09:35 AM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 01:59 PM\", \"result\": 10, \"comment\": \"Call attempt to schedule an HRA - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/10/2024 @ 01:59 PM\"}, {\"date\": \"8/28/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/29/2024 @ 03:05 PM\"}, {\"date\": \"8/27/2024 @ 12:31 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/28/2024 @ 12:31 PM\"}, {\"date\": \"4/29/2024 @ 04:00 PM\", \"result\": 14, \"comment\": \"MEMBER NOT AVAILABLE - MEMBER WORKS DURING THE TIME OF CALL. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 03:59 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 16:00:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:32:22\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1881, NULL, NULL, NULL, '0006625828001', '415700', '', '2661185', 'Lori', 'Beasley', '', '{\"DOB\": 25999, \"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\": \"Alapaha\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Alapaha\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-03-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415700, \"Mailing_County\": \"BERRIEN\", \"Member_Country\": \"BERRIEN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1840 Mill Creek Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31622, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1840 Mill Creek Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31622, \"Member_Last_name\": \"Beasley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lori\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"loribeasley71@gmail.com\", \"Member_Suspect_Codes\": \"11, 12\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9123835896, \"Member_Identification_Number\": \"0006625828001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:37\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:37\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T13:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T14:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T09:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T13:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-07-01T12:43\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T13:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T09:30\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T12:43\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T13:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:19\", \"value\": [{\"add\": \"1840 Mill Creek Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-03-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9123835896, \"zip\": 31622, \"add2\": \"\", \"add3\": \"\", \"city\": \"Alapaha\", \"gend\": 1, \"insh\": \"0006625828001\", \"mzip\": 31622, \"name\": \"Lori Beasley\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"loribeasley71@gmail.com\", \"ename\": \"\", \"madd1\": \"1840 Mill Creek Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Alapaha\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 01:09 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 12:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 12:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 12:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 10:43 AM\", \"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 @ 10:40 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:08 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 02:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 01:48 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 12:43 PM\", \"result\": 6, \"comment\": \"Member would like a call back to schedule for a later date and time. Call attempt to schedule Delise Adams for a virtual assessment. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/22/2024 @ 12:43 PM\"}, {\"date\": \"5/21/2024 @ 09:30 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 09:30 AM\"}, {\"date\": \"5/17/2024 @ 01:48 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/20/2024 @ 01:48 PM\"}, {\"date\": \"5/14/2024 @ 02:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 02:27 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 14:27:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-09-2024 13:48:58\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1882, NULL, NULL, NULL, '0006626854001', '409753', '', '21881792', 'Daulat', 'Saleem', '', '{\"DOB\": 22775, \"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\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-05-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 409753, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1075 Orchard Way Unit 11\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30721, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1075 Orchard Way Unit 11\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30721, \"Member_Last_name\": \"Saleem\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Daulat\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dolly1962@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4232848887, \"Member_Identification_Number\": \"0006626854001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:37\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:37\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:46\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-24T10:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-02T11:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-22T16:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T09:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-24T10:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-02T11:47\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T09:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:46\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:19\", \"value\": [{\"add\": \"1075 Orchard Way Unit 11\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-05-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4232848887, \"zip\": 30721, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 1, \"insh\": \"0006626854001\", \"mzip\": 30721, \"name\": \"Daulat Saleem\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dolly1962@gmail.com\", \"ename\": \"\", \"madd1\": \"1075 Orchard Way Unit 11\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:01\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 11:30 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 11:03 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 12:51 PM\", \"result\": 3, \"comment\": \"attempt to sched virtual appt w/Nykya Cox\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 04:37 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 05:02 PM\", \"result\": 3, \"comment\": \"07/22/2024 JC: called for HRA-Connie Middleton-F2F: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"5/24/2024 @ 09:44 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 09:44 AM\"}, {\"date\": \"5/22/2024 @ 04:17 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 04:17 PM\"}, {\"date\": \"5/2/2024 @ 11:47 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/7/2024 @ 11:47 AM\"}, {\"date\": \"4/24/2024 @ 10:17 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/25/2024 @ 10:17 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 10:17:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-11-2024 15:46:01\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1883, NULL, NULL, NULL, '0006626879001', '410779', '', '2661185', 'Diangelo', 'Hester', '', '{\"DOB\": 33151, \"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\": \"Athens\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Athens\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1990-10-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410779, \"Mailing_County\": \"CLARKE\", \"Member_Country\": \"CLARKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"240 North Ave\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30601, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"240 North Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30601, \"Member_Last_name\": \"Hester\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Diangelo\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065168219, \"Member_Identification_Number\": \"0006626879001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-17-2024 00:00:12\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-05-17 00:00:12\", \"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-14T14:30\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-14T14:30\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:19\", \"value\": [{\"add\": \"240 North Ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1990-10-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065168219, \"zip\": 30601, \"add2\": \"\", \"add3\": \"\", \"city\": \"Athens\", \"gend\": 0, \"insh\": \"0006626879001\", \"mzip\": 30601, \"name\": \"Diangelo Hester\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"240 North Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Athens\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:02\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 10, \"callLog\": [{\"date\": \"5/14/2024 @ 02:30 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 02:30 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 14:30:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:36\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', '{\"orderType\": 0, \"sortOrder\": 1715755733}', 1, NULL, NULL, NULL, NULL, '2024-04-30', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:19', 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
(1884, 50892900, 44829497, '62685179', '0006626894001', '411505', '', '2661185', 'Robert', 'Weekley', '', '{\"DOB\": 21770, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Gainesville\", \"Pcp_Name\": \"Dr. Cheri Vachtsevanos\", \"PCP_Phone\": \"7705327501\", \"Member_City\": \"Commerce\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Commerce\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-08-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"667 Lanier Park Drive\", \"Screening_IHA\": \"No\", \"member_id_two\": 411505, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"7705328322\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3349 Waterworks Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30529, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3349 Waterworks Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30529, \"Member_Last_name\": \"Weekley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"weekleys2@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7705301638, \"Member_Identification_Number\": \"0006626894001\", \"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:36:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:36:48\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-17T01:51\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-21T12:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-22T12:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T14:37\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-19T05:52\", \"reportStatus_date\": \"2024-05-17T01:51\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-22T12:21\", \"reportStatus_date\": \"2024-05-22T12:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:36\", \"reportStatus_date\": \"2024-05-31T14:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:36\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-14T14:37\", \"username\": null}, {\"date\": \"2024-05-14T14:37\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-14T17:42\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-17T08:34\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-15T12:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T12:57\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T13:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T03:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:16\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T04:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T09:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-16T09:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T01:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T01:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T01:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T01:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T01:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T01:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T14:22\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-17T14:25\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-17T14:28\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-19T05:52\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-22T12:21\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-21T12:12\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-22T12:21\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-17T14:29\", \"username\": \"fcopeland1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"14:25:53\", \"value\": [{\"add\": \"3349 Waterworks Rd\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-08-08\", \"eno\": \"7069830609\", \"lob\": \"On Exchange\", \"pno\": 7705301638, \"zip\": 30529, \"add2\": \"\", \"add3\": \"\", \"city\": \"Commerce\", \"gend\": 0, \"insh\": \"0006626894001\", \"mzip\": 30529, \"name\": \"Robert Weekley\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Cheri Vachtsevanos\", \"ppno\": \"7705327501\", \"cliId\": \"\", \"email\": \"weekleys2@yahoo.com\", \"ename\": \"Laura Weekley\", \"madd1\": \"3349 Waterworks Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Commerce\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"667 Lanier Park Drive\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"Gainesville\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7705328322\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"Added\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-14-2024\", \"time\": \"17:42:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 14:25:53\"}', NULL, NULL, '{\"memberId\": \"0006626894001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"Fri, 17 May 2024 18:34:05 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"EARS-please answer \\\"yes or no\\\" as this question appears blank\\nALCOHOL DEPENDENCE-\\\"type\\\"-please change to \\\"episodic\\\" if this is current as its documented that the member drinks \\\"only on Friday and Saturday.\\\"  Remission would typically indicate  no alcohol consumption \\nMUSCOLOSKELETAL- \\\"diagnoses\\\"-please select \\\"other\\\" and indicate \\\"herniated disc\\\" as the diagnosis in the comment box that will appear; you will then be able to select \\\"active vs. history of\\\" etc.\\nEYES-as a friendly reminder, please utilize the \\\"virtual visit checklist\\\" which outlines how to assess the member\'s eyes during a virtual visit (have them pull down their eyelids to check the conjunctiva, etc.).  The checklist was created to indicate \\\"how to assess and document during a virtual visit\\\" :)\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sun, 19 May 2024 09:52:44 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Robert Weekley\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/15/2024 12:15 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"fcopeland@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/14/2024 @ 02:37 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Faith Enwefah for 5/15/24 @ 12:15pm. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006626894001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006626894001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006626894001\", \"scheduleDate\": \"2024-5-15T12:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 14:37:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-14-2024 14:37:55\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:36:46\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"bbd1f697-1f7c-11ef-af93-eba9d864c0d1\\\",\\\"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-15T12:15', '2024-08-05', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:19', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006626894001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006626894001_Weekley, Robert_05152024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:36:45\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_bachtsevanos, cheri _0006626894001_05152024.pdf\"}', 'ACA_0006626894001_Weekley, Robert_05152024', NULL, 'PCP_bachtsevanos, cheri _0006626894001_05152024', NULL, '[{\"date\": \"2024-05-17T05:51:22.366Z\", \"signature\": \"data:image/png;base64,[encoded data, 23388 characters]\"}, {\"date\": \"2024-05-19T09:52:44.341Z\", \"signature\": \"data:image/png;base64,[encoded data, 23432 characters]\"}]', '2024-05-15T13:15', 'Member_Summary_0006626894001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006626894001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006626894001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:36:47\"}', 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
(1885, 3285757, 44829497, '56716210', '0006629265001', '408317', '', '26056802', 'Maria', 'Ibague de Rojas', '', '{\"DOB\": 19026, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Gainesville\", \"Pcp_Name\": \"Maria Alban\", \"PCP_Phone\": \"7702870290\", \"Member_City\": \"Oakwood\", \"Office_Name\": \"MedLinik\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1952-02-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"528 Broad Street, Suite B\", \"Screening_IHA\": \"No\", \"member_id_two\": 408317, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7702877597\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5388 Fox hill LN\", \"Member_Address2\": \"\", \"Member_Address3\": \"5930 Nichols Ln\", \"Member_Zip_Code\": \"30566\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5930 Nichols Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"Ibague de Rojas\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Maria\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 9545156426, \"Member_Identification_Number\": \"0006629265001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'0', '{\"date\": \"11-19-2024 10:17:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-11-19 10:17:41\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-31T14:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-11-14T16:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-17T20:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-18T14:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-19T10:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-29T18:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-10-31T14:20\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-08-17T10:05\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-05-15T18:19\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-19T09:37\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:37\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T18:19\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-29T18:24\", \"reportStatus_date\": \"2024-07-29T18:24\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": 19, \"hraStatus_date\": \"2024-08-17T10:05\", \"reportStatus_date\": \"2024-08-19T09:37\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-31T14:20\", \"reportStatus_date\": \"2024-10-31T14:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-11-18T14:26\", \"reportStatus_date\": \"2024-11-18T14:26\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-11-19T10:17\", \"reportStatus_date\": \"2024-11-19T10:17\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-17T10:05\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-19T10:17\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-07-29T18:24\", \"username\": null}, {\"date\": \"2024-07-29T18:24\", \"username\": null}, {\"date\": \"2024-10-31T14:20\", \"username\": null}, {\"date\": \"2024-10-31T14:20\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-17T08:35\", \"username\": \"NCox\"}, {\"date\": \"2024-11-13T20:59\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-14T17:37\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-14T16:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-14T16:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-14T21:54\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T21:57\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:00\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:03\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:06\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:09\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:15\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:18\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:21\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:24\", \"username\": \"BClark\"}, {\"date\": \"2024-11-14T22:27\", \"username\": \"BClark\"}, {\"date\": \"2024-11-15T07:12\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-18T14:26\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-17T20:32\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-18T14:26\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-11-14T22:29\", \"username\": \"BClark\"}, {\"date\": \"2024-11-15T07:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T07:09\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T07:12\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-20-2024\", \"time\": \"12:08:38\", \"value\": [{\"add\": \"5388 Fox hill LN\", \"age\": 72, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1952-02-02\", \"eno\": \"9545156426\", \"lob\": \"On Exchange\", \"pno\": 9545156426, \"zip\": \"30566\", \"add2\": \"\", \"add3\": \"5930 Nichols Ln\", \"city\": \"Oakwood\", \"gend\": 1, \"insh\": \"0006629265001\", \"mzip\": 30506, \"name\": \"Maria Ibague de Rojas\", \"plan\": \"Alliant\", \"pphy\": \"Maria Alban\", \"ppno\": \"7702870290\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Anyela Ibague\", \"madd1\": \"5930 Nichols Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"528 Broad Street, Suite B\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Widowed\", \"pcpFlag\": 0, \"pcpcity\": \"Gainesville\", \"pcpname\": \"MedLinik\", \"program\": \"ACA\", \"evalDate\": \"2024-11-14 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7702877597\", \"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\": {\"sub\": [], \"indx\": [[\"Christian\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [null, null, null, null, true], \"score\": [], \"comment\": [null, null, null, null, \"virtual visit\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-17-2024\", \"time\": \"08:35:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"12-05-2024 12:33:32\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-08-17T10:05\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0006629265001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Fri, 15 Nov 2024 03:09:25 GMT\", \"name\": \"BClark\", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n\\nThank you for your thorough assessment!\\n\\n1) Under demographics, do you have any more info on member\'s PCP like phone number/address ect? If so, can you please add\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 15 Nov 2024 03:29:02 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n\\nThank you for your thorough assessment!\\n\\n1) Under demographics, do you have any more info on member\'s PCP like phone number/address ect? If so, can you please add\\n2) Can you please add a year for the diabetes screen under preventative care\\n3) Under home safety, can you mark normal, abnormal, or add a comment for member\'s gait\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 15 Nov 2024 12:12:55 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1.Member was not able to provide the number. I added the number from Google Maps. \\n2. Added.\\n3. Looks like it is marked on my end for gait. \\nThank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Maria Ibague de Rojas\", \"codingAnalyst\": \"\", \"dateOfService\": \"11/14/2024 08:00 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/31/2024 @ 02:20 PM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : scheduled for 11/14 @ 8am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:06 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"11/1/2024 @ 02:06 PM\"}, {\"date\": \"8/19/2024 @ 09:37 AM\", \"result\": 6, \"comment\": \"Called to reschedule Virtual HRA with Nykya Cox. Member was at work, requested call back after 5pm. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"8/26/2024 @ 09:36 AM\"}, {\"date\": \"7/29/2024 @ 06:24 PM\", \"result\": 0, \"comment\": \"07/29/2024 JC: called for HRA-Nykya Cox-Virtual: scheduled for 08/17/2024 @ 9:00am - 10:00am, member speaks Spanish needs interpreter, sent doxy link thru text \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"5/15/2024 @ 06:19 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Call Back - Member needs a weekend for HRA and would like a Spanish speaking agent or interpreter next call\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 06:19 PM\"}, {\"date\": \"4/25/2024 @ 03:37 PM\", \"result\": 3, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:37 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006629265001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006629265001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0006629265001\", \"scheduleDate\": \"2024-11-14T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 18:19:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"08-17-2024 10:05:49\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"10-31-2024 14:20:11\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2024-11-19 10:17:39\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"69ca4a68-a689-11ef-870a-2b8f711c8755\\\",\\\"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-11-14T08:00', '2024-12-31', '2024-11-14T08:00', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:20', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006629265001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006629265001_Ibague de Rojas, Maria_11142024.pdf\", \"ftp_upload_date\": \"2024-11-19 10:17:37\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Alban, Maria_0006629265001_11142024.pdf\"}', 'ACA_0006629265001_Ibague de Rojas, Maria_11142024', NULL, 'PCP_Alban, Maria_0006629265001_11142024', NULL, '[{\"date\": \"2024-11-14T21:17:13.618Z\", \"signature\": \"data:image/png;base64,[encoded data, 23332 characters]\"}, {\"date\": \"2024-11-15T12:12:54.343Z\", \"signature\": \"data:image/png;base64,[encoded data, 23356 characters]\"}]', '2024-11-14T09:30', 'Member_Summary_0006629265001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006629265001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006629265001.pdf\", \"member_ftp_upload_date\": \"2024-11-19 10:17:41\"}', 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
(1886, NULL, NULL, NULL, '0006630952002', '390558', '', '21881792', 'April', 'Mckee', '', '{\"DOB\": 28717, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1417046517, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"THOMASVILLE\", \"Pcp_Name\": \"Brandi Warren\", \"PCP_Phone\": 2292268800, \"Pcp_State\": \"GA\", \"Member_City\": \"Moultrie\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Moultrie\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-08-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2484 E PINETREE BLVD\", \"Screening_IHA\": \"No\", \"member_id_two\": 390558, \"Mailing_County\": \"COLQUITT\", \"Member_Country\": \"COLQUITT\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"125 Edmondson Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31788, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"125 Edmondson Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31788, \"Member_Last_name\": \"Mckee\", \"Medication_Review\": \"N\", \"Member_first_name\": \"April\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"5405504482\", \"Member_Identification_Number\": \"0006630952002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:38\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:38\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T19:15\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-12T17:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T19:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T14:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T12:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:15\", \"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-15T19:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T14:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T12:42\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:15\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:32\", \"value\": [{\"add\": \"125 Edmondson Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-08-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 5405504482, \"zip\": 31788, \"add2\": \"\", \"add3\": \"\", \"city\": \"Moultrie\", \"gend\": 1, \"insh\": \"0006630952002\", \"mzip\": 31788, \"name\": \"April Mckee\", \"plan\": \"Alliant\", \"pphy\": \"Brandi Warren\", \"ppno\": 2292268800, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"125 Edmondson Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Moultrie\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2484 E PINETREE BLVD\", \"pcpnpi\": 1417046517, \"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\": \"06-21-2024\", \"time\": \"01:15:32\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:32\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 02:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 03:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 02:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 07:15 PM\", \"result\": 3, \"comment\": \"call to schedule HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 12:42 PM\", \"result\": 3, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/15/2024 @ 12:42 PM\"}, {\"date\": \"6/21/2024 @ 02:25 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 02:24 PM\"}, {\"date\": \"6/15/2024 @ 07:20 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 07:20 PM\"}, {\"date\": \"6/12/2024 @ 05:30 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 @ 05:29 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-12-2024 17:30:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-02-2024 19:15:52\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1887, NULL, NULL, NULL, '0006631101001', '394582', '', '26056802', 'Ashlee', 'Hall', '', '{\"DOB\": 33035, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1205811262, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"SYLVESTER\", \"Pcp_Name\": \"Edward Bass\", \"PCP_Phone\": 9127766961, \"Pcp_State\": \"GA\", \"Member_City\": \"Albany\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Albany\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1990-06-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"807 S ISABELLA ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 394582, \"Mailing_County\": \"DOUGHERTY\", \"Member_Country\": \"DOUGHERTY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"507 Swift St Apt E6\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31705, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"507 Swift St Apt E6\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31705, \"Member_Last_name\": \"Hall\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ashlee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"Ashnhall90.ah2015@gmail.com\", \"Member_Suspect_Codes\": \"161.2, 19, 21, 22, 84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2292222530, \"Member_Identification_Number\": \"0006631101001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 2292222530}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:38\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:38\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-28T12:42\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-30T14:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T12:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T19:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-17T14:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-28T12:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T14:55\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-06-06T12:42\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-05-24T20:44\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}, {\"date\": \"2024-06-13T17:03\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-07-31T18:10\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-14T14:55\", \"reportStatus_date\": \"2024-05-14T14:55\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-05-24T20:44\", \"reportStatus_date\": \"2024-05-24T20:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T14:36\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-06T12:42\", \"reportStatus_date\": \"2024-06-06T12:42\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-06-13T17:03\", \"reportStatus_date\": \"2024-06-13T17:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T12:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T19:16\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T14:59\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-31T18:10\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-28T12:42\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-24T20:44\", \"username\": \"NCox\"}, {\"date\": \"2024-06-13T17:03\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T14:55\", \"username\": null}, {\"date\": \"2024-05-14T14:55\", \"username\": null}, {\"date\": \"2024-06-06T12:42\", \"username\": null}, {\"date\": \"2024-06-06T12:42\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-13T16:50\", \"username\": \"NCox\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-13-2024\", \"time\": \"16:50:36\", \"value\": [{\"add\": \"507 Swift St Apt E6\", \"age\": 34, \"ano\": \"\", \"cno\": 2292222530, \"dob\": \"1990-06-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2292222530, \"zip\": 31705, \"add2\": \"\", \"add3\": \"\", \"city\": \"Albany\", \"gend\": 1, \"insh\": \"0006631101001\", \"mzip\": 31705, \"name\": \"Ashlee Hall\", \"plan\": \"Alliant\", \"pphy\": \"Edward Bass\", \"ppno\": 9127766961, \"cliId\": \"\", \"email\": \"Ashnhall90.ah2015@gmail.com\", \"ename\": \"\", \"madd1\": \"507 Swift St Apt E6\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Albany\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"807 S ISABELLA ST\", \"pcpnpi\": 1205811262, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"SYLVESTER\", \"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-16-2024\", \"time\": \"10:47:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-13-2024 17:02:27\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-24T20:44\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-06-13T17:03\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"11/14/2024 @ 10:33 AM\", \"result\": 1, \"comment\": \"No sound on call. Call attempt to schedule an HRA. - Dead air  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 12:42 PM\", \"result\": 13, \"comment\": \"called for HRA-Virtual - Faith Enwefah-GA, RN,NP : caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:10 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS member could not hear me just kept saying Hello.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"8/2/2024 @ 06:10 PM\"}, {\"date\": \"7/17/2024 @ 02:59 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/18/2024 @ 02:59 PM\"}, {\"date\": \"7/2/2024 @ 07:16 PM\", \"result\": 7, \"comment\": \"LINE BUSY - Unable to leave a message.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/4/2024 @ 07:16 PM\"}, {\"date\": \"7/1/2024 @ 12:46 PM\", \"result\": 7, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: LINE BUSY \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/8/2024 @ 12:45 PM\"}, {\"date\": \"6/6/2024 @ 12:42 PM\", \"result\": 12, \"comment\": \"Rescheduled virtual HRA w/ Nykya C on 6/13 @ 4:50 - texted link to member\'s phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/30/2024 @ 02:36 PM\", \"result\": 7, \"comment\": \"Call attempt to reschedule virtual HRA.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 02:36 PM\"}, {\"date\": \"5/14/2024 @ 02:55 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/ Nykya Cox on 5/23 @ 450pm - doxy - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006631101001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0006631101001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0006631101001\", \"scheduleDate\": \"2024-6-13T16:50\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 14:55:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"05-24-2024 20:44:14\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"06-13-2024 17:03:30\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"10-28-2024 12:42:51\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1888, NULL, NULL, NULL, '0006632298001', '276663', '', '2661185', 'Jessica', 'Carter', '', '{\"DOB\": 29711, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1255626024, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ROME\", \"Pcp_Name\": \"Brian McNiece\", \"PCP_Phone\": 7622351000, \"Pcp_State\": \"GA\", \"Member_City\": \"Rome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-05-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1825 MARTHA BERRY BLVD NW\", \"Screening_IHA\": \"No\", \"member_id_two\": 276663, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3 Central Plz PMB 117\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 301610000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 Central Plz PMB 117\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30161, \"Member_Last_name\": \"Carter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jessica\", \"Member_Middle_name\": \"Gaines\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jessicacarter5581@comcast.net\", \"Member_Suspect_Codes\": \"130, 132, 20, 21, 22\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069367870, \"Member_Identification_Number\": \"0006632298001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-14-2024 00:00:20\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-08-14 00:00:20\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T17:57\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-22T19:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-07T14:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T19:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T12:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T17:57\", \"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-22T19:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T14:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T19:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T12:45\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:57\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:21\", \"value\": [{\"add\": \"3 Central Plz PMB 117\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1981-05-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069367870, \"zip\": 301610000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 1, \"insh\": \"0006632298001\", \"mzip\": 30161, \"name\": \"Jessica Gaines Carter\", \"plan\": \"Alliant\", \"pphy\": \"Brian McNiece\", \"ppno\": 7622351000, \"cliId\": \"\", \"email\": \"jessicacarter5581@comcast.net\", \"ename\": \"\", \"madd1\": \"3 Central Plz PMB 117\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1825 MARTHA BERRY BLVD NW\", \"pcpnpi\": 1255626024, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ROME\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:02\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"8/7/2024 @ 12:47 PM\", \"result\": 3, \"comment\": \"virtual w/Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 01:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:57 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 12:45 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 12:45 PM\"}, {\"date\": \"6/11/2024 @ 04:46 PM\", \"result\": 3, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/27/2024 @ 04:46 PM\"}, {\"date\": \"5/7/2024 @ 02:36 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH E. 5/10.   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 02:35 PM\"}, {\"date\": \"4/22/2024 @ 07:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/23/2024 @ 07:58 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-22-2024 19:59:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-09-2024 17:57:17\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1889, NULL, NULL, NULL, '0006635563001', '419758', '', '26056802', 'Lisa', 'Hatfield', '', '{\"DOB\": 28472, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-12-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 419758, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3628 Bert drive\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30506, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3628 Bert drive\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"Hatfield\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lisa\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 45, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7705391558, \"Member_Identification_Number\": \"0006635563001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:38\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:38\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-22T12:27\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-11T12:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T17:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-26T18:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-22T12:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [{\"date\": \"2024-05-02T11:19\", \"text\": \"F2F No Show\", \"method\": \"api\", \"status\": 24}], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:15\", \"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-04-25T16:15\", \"reportStatus_date\": \"2024-04-25T16:15\"}, {\"text\": \"F2F No Show\", \"type\": \"ReportStatus\", \"status\": 24, \"hraStatus\": 19, \"hraStatus_date\": \"2024-05-02T11:19\", \"reportStatus_date\": \"2024-05-02T11:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-13T17:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-26T18:23\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:15\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T12:27\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-02T11:19\", \"username\": \"PFrey1\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:15\", \"username\": null}, {\"date\": \"2024-04-25T16:15\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:21\", \"value\": [{\"add\": \"3628 Bert drive\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-12-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7705391558, \"zip\": 30506, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006635563001\", \"mzip\": 30506, \"name\": \"Lisa Hatfield\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3628 Bert drive\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:02\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-02T11:19\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 02:06 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:55 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 03:16 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Connie Middleton. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 12:27 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:15 PM\", \"result\": 3, \"comment\": \"07/10/2024 MB:: called for HRA-Nykya-Virtual: LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"7/17/2024 @ 02:15 PM\"}, {\"date\": \"6/26/2024 @ 06:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/3/2024 @ 06:23 PM\"}, {\"date\": \"6/13/2024 @ 05:41 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/20/2024 @ 05:41 PM\"}, {\"date\": \"6/11/2024 @ 12:16 PM\", \"result\": 1, \"comment\": \"DEAD AIR F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/14/2024 @ 12:16 PM\"}, {\"date\": \"4/25/2024 @ 04:15 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Delise Adams on 5/2 @ 8am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006635563001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006635563001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006635563001\", \"scheduleDate\": \"2024-5-2T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:15:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"05-02-2024 11:19:37\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-22-2024 12:27:07\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, 'In Person', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1890, NULL, NULL, NULL, '0006636541001', '408962', '', '21881792', 'Betty', 'Lewis', '', '{\"DOB\": 21868, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Bremen\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bremen\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-11-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 408962, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"350 Old Hamilton Mills Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30110, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"350 Old Hamilton Mills Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30110, \"Member_Last_name\": \"Lewis\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Betty\", \"Member_Middle_name\": \"Jane\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"betty.lewis19@aol.com\", \"Member_Suspect_Codes\": \"11, 12, 8, 9\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6784585455, \"Member_Identification_Number\": \"0006636541001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:33:38\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:38\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-30T09:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-27T12:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T14:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-30T09:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-04-29T14:46\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-10-09T14:03\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T14:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T14:02\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T14:03\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-30T09:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-18T10:13\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-31T11:46\", \"username\": null}, {\"date\": \"2024-10-31T11:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-11T21:10\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:22\", \"value\": [{\"add\": \"350 Old Hamilton Mills Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-11-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6784585455, \"zip\": 30110, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bremen\", \"gend\": 1, \"insh\": \"0006636541001\", \"mzip\": 30110, \"name\": \"Betty Jane Lewis\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"betty.lewis19@aol.com\", \"ename\": \"\", \"madd1\": \"350 Old Hamilton Mills Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bremen\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:02\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 09:38 AM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : no VM Setup\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/28/2024 @ 04:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 02:03 PM\", \"result\": 6, \"comment\": \"Member not available - requested a call back - Call attempt to schedule an HRA.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/10/2024 @ 02:03 PM\"}, {\"date\": \"8/28/2024 @ 02:02 PM\", \"result\": 13, \"comment\": \"Caller answered the call. After stating reason for call member disconnected the call.  Call attempt to schedule a virtual HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/29/2024 @ 02:01 PM\"}, {\"date\": \"8/27/2024 @ 12:15 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/3/2024 @ 12:15 PM\"}, {\"date\": \"4/29/2024 @ 02:46 PM\", \"result\": 14, \"comment\": \"MEMBER HAS CHEMO THERAPY AND NOT SURE WHEN TO SCHEDULE. PLACED AS A CALL BACK FOR A LATER DATE AND TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/8/2024 @ 02:46 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 14:46:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-30-2024 09:38:47\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', '{\"orderType\": 0, \"sortOrder\": 1730268410}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1891, NULL, NULL, NULL, '0006638741001', '404691', '', '21881792', 'Brian', 'McDonald', '', '{\"DOB\": 23499, \"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\": \"Blairsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Blairsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-05-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 404691, \"Mailing_County\": \"UNION\", \"Member_Country\": \"UNION\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"517 Rich Gap Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30512, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"517 Rich Gap Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30512, \"Member_Last_name\": \"McDonald\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brian\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"brimcdon219@gmail.com\", \"Member_Suspect_Codes\": 13, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9546753726, \"Member_Identification_Number\": \"0006638741001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:38\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:38\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T11:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-06-03T12:12\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-03T12:12\", \"reportStatus_date\": \"2024-06-03T12:12\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-03T12:12\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:01:22\", \"value\": [{\"add\": \"517 Rich Gap Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-05-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9546753726, \"zip\": 30512, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blairsville\", \"gend\": 0, \"insh\": \"0006638741001\", \"mzip\": 30512, \"name\": \"Brian McDonald\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"brimcdon219@gmail.com\", \"ename\": \"\", \"madd1\": \"517 Rich Gap Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Blairsville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:25:02\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-03T12:12\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"6/3/2024 @ 12:12 PM\", \"result\": 9, \"comment\": \"REFUSAL - Member declined offer to schedule HRA in 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/31/2024 @ 11:52 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 11:52 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 11:52:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:37\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1892, 2888643, 44829497, '62685179', '0006641471001', '406915', '', '2661185', 'Christian', 'Lane', '', '{\"DOB\": 25053, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30165\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Rome\", \"Pcp_Name\": \"Dr. Singh Amar\", \"PCP_Phone\": \"7062338506\", \"Member_City\": \"Rome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-08-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"550 Redmond Rd NW\", \"Screening_IHA\": \"No\", \"member_id_two\": 406915, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"7062338507\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"134 Melody Ln NW\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30165, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"134 Melody Ln NW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30165, \"Member_Last_name\": \"Lane\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Christian\", \"Member_Middle_name\": \"Paul\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"newsycpl@gmail.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7062527948, \"Member_Identification_Number\": \"0006641471001\", \"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:36:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:36:54\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-22T20:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-10T14:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-16T10:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-17T08:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-07T14:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-22T20:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-10T14:52\", \"reportStatus_date\": \"2024-05-10T14:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-17T08:58\", \"reportStatus_date\": \"2024-05-17T08:58\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:36\", \"reportStatus_date\": \"2024-05-31T14:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:36\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-07T14:45\", \"username\": null}, {\"date\": \"2024-05-07T14:45\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-09T15:06\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-13T08:40\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-10T14:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-15T19:17\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-17T08:58\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-16T10:27\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-17T08:58\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-15T12:38\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"14:37:24\", \"value\": [{\"add\": \"134 Melody Ln NW\", \"age\": 55, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-08-03\", \"eno\": \"678 603 3702\", \"lob\": \"On Exchange\", \"pno\": 7062527948, \"zip\": 30165, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 0, \"insh\": \"0006641471001\", \"mzip\": 30165, \"name\": \"Christian Paul Lane\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Singh Amar\", \"ppno\": \"7062338506\", \"cliId\": \"\", \"email\": \"newsycpl@gmail.com\", \"ename\": \"Jeremy Lane\", \"madd1\": \"134 Melody Ln NW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"550 Redmond Rd NW\", \"pcpnpi\": \"\", \"pcpzip\": \"30165\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"Rome\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7062338507\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP added\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:25:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 14:37:24\"}', NULL, NULL, '{\"memberId\": \"0006641471001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Wed, 15 May 2024 16:38:43 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThank you for the assessment.\\n1. In the assessment of diagnosis,musculoskeletal- please add information about his knee pain.\\n2. The assessment of diagnosis, hematology is blank, please update\\n3.  In the pain assessment- this should be completed since the member is being treated for back and knee pain. The frequency of pain\\nis able to be selected , and you can comment on what his pain level is when it occurs. \\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 15 May 2024 23:17:01 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you\"}, \"mailId\": \"\"}], \"memberName\": \"Christian Lane\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/10/2024 11:00AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/7/2024 @ 02:45 PM\", \"result\": 0, \"comment\": \"SCHEDULED FAITH ON 5/10 @ 11 - PET IN HOME (CAT), PARK IN DRIVEWAY OR IN FRONT OF HOME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/22/2024 @ 08:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/23/2024 @ 08:01 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006641471001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006641471001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006641471001\", \"scheduleDate\": \"2024-5-10T11:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-22-2024 20:01:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-07-2024 14:45:44\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:36:52\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"bfd6b6bc-1f7c-11ef-8a35-1b71753f7cc3\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-5-10T11:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:01:22', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006641471001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006641471001_Lane, Christian_05102024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:36:52\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Amar, Singh_0006641471001_05102024.pdf\"}', 'ACA_0006641471001_Lane, Christian_05102024', NULL, 'PCP_Amar, Singh_0006641471001_05102024', NULL, '[{\"date\": \"2024-05-10T18:52:17.680Z\", \"signature\": \"data:image/png;base64,[encoded data, 23400 characters]\"}, {\"date\": \"2024-05-15T23:17:01.545Z\", \"signature\": \"data:image/png;base64,[encoded data, 23388 characters]\"}]', '2024-05-10T12:00', 'Member_Summary_0006641471001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006641471001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006641471001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:36:53\"}', NULL, NULL, NULL, NULL);
