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
(4994, NULL, NULL, NULL, '0008192202001', '432949', '', '84929813', 'Matthew', 'Wells', '', '{\"DOB\": 28996, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Flowery Branch\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1979-05-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 432949, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6763 Big Sky Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"6763 Big Sky Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Wells\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Matthew\", \"Member_Middle_name\": \"Joseph\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mattwells4@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789331758, \"Member_Identification_Number\": \"0008192202001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:38:47\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:47\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-14T13:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T11:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T10:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T17:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-10T17:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-14T13:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T11:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T17:12\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-14T13:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-06T05:55\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-27T12:16\", \"username\": null}, {\"date\": \"2024-08-27T12:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T07:44\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:13\", \"value\": [{\"add\": \"6763 Big Sky Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1979-05-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789331758, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 0, \"insh\": \"0008192202001\", \"mzip\": 30542, \"name\": \"Matthew Joseph Wells\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mattwells4@gmail.com\", \"ename\": \"\", \"madd1\": \"6763 Big Sky Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:13\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 09:22 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/14/2024 @ 01:41 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/10/2024 @ 05:51 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 05:51 PM\"}, {\"date\": \"8/28/2024 @ 05:12 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/6/2024 @ 05:12 PM\"}, {\"date\": \"8/27/2024 @ 10:02 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/3/2024 @ 10:01 AM\"}, {\"date\": \"8/9/2024 @ 11:13 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/16/2024 @ 11:13 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 11:13:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"10-14-2024 13:41:38\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4995, 57818338, 44829497, '56716210', '0008192327001', '436567', '', '21881792', 'Jon', 'Woodward', '', '{\"DOB\": 23006, \"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\": \"30534\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Dawsonville\", \"Pcp_Name\": \"Johan Koo\", \"Rank_All\": \"\", \"PCP_Phone\": \"7062163238\", \"Pcp_State\": \"\", \"Member_City\": \"Dahlonega\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-12-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"108 Prominence Court, Suite 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 436567, \"Mailing_County\": \"\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"7062165285\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1530 Long Branch Rd\", \"Member_Address2\": \"Site 14\", \"Member_Address3\": \"32 Grant Rd\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"32 Grant Rd W\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Woodward\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jon\", \"Member_Middle_name\": \"Eric\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"foxmire@yahoo.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 3366891825, \"Member_Identification_Number\": \"0008192327001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"10-22-2024 12:35:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-22 12:35:19\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-07T17:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-22T17:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T16:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-10-15T17:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-17T14:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-18T01:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-22T12:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-10T13:59\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-07T17:08\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-23T16:07\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-10T13:59\", \"reportStatus_date\": \"2024-10-10T13:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-10-18T01:39\", \"reportStatus_date\": \"2024-10-18T01:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-22T12:35\", \"reportStatus_date\": \"2024-10-22T12:35\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-22T12:35\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-10-10T13:59\", \"username\": null}, {\"date\": \"2024-10-10T13:59\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-10-15T01:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-10-16T12:34\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-10-15T17:24\", \"username\": \"DAdams\"}, {\"date\": \"2024-10-15T17:24\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-10-18T01:39\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-10-17T14:44\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-10-18T01:39\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-07-2025\", \"time\": \"12:31:26\", \"value\": [{\"add\": \"1530 Long Branch Rd\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-12-26\", \"eno\": \"3366891854\", \"lob\": \"On Exchange\", \"pno\": 3366891825, \"zip\": 30533, \"add2\": \"Site 14\", \"add3\": \"32 Grant Rd\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0008192327001\", \"mzip\": 30534, \"name\": \"Jon Eric Woodward\", \"plan\": \"Alliant\", \"pphy\": \"Johan Koo\", \"ppno\": \"7062163238\", \"race\": \"\", \"cliId\": \"\", \"email\": \"foxmire@yahoo.com\", \"ename\": \"Cindy Woodward\", \"madd1\": \"32 Grant Rd W\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"108 Prominence Court, Suite 200\", \"pcpnpi\": \"\", \"pcpzip\": \"30534\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Dawsonville\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-10-15 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7062165285\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Christian\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"10-15-2024\", \"time\": \"01:32:34\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-07-2025 12:31:26\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/10/2024 @ 01:59 PM\", \"result\": 0, \"comment\": \"Scheduled Delise Adams on 10/15 @ 8 - emailed doxy link to foxmire@yahoo.com - member will use their desktop - member added mailing address: 32 Grant Rd, Dawsonville - 30534\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/23/2024 @ 04:07 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Delise Adams 9/13. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 04:07 PM\"}, {\"date\": \"8/22/2024 @ 05:16 PM\", \"result\": 13, \"comment\": \"Called to schedule Virtual HRA with Delise Adams Caller Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"8/29/2024 @ 05:16 PM\"}, {\"date\": \"8/7/2024 @ 05:08 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Jansen Helm. - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/8/2024 @ 05:07 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0008192327001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0008192327001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0008192327001\", \"scheduleDate\": \"2024-10-15T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-07-2024 17:08:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-10-2024 13:59:02\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2024-10-22 12:35:17\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"9f1e740c-9093-11ef-a281-83a633345cbd\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-10-15T08:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:13', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008192327001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0008192327001_Woodward, Jon_10152024.pdf\", \"ftp_upload_date\": \"2024-10-22 12:35:17\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Koo, Johan_0008192327001_10152024.pdf\"}', 'ACA_0008192327001_Woodward, Jon_10152024', NULL, 'PCP_Koo, Johan_0008192327001_10152024', NULL, '[{\"date\": \"2024-10-15T21:24:55.331Z\", \"signature\": \"data:image/png;base64,[encoded data, 23424 characters]\"}]', '2024-10-15T09:22', 'Member_Summary_0008192327001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008192327001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0008192327001.pdf\", \"member_ftp_upload_date\": \"2024-10-22 12:35:18\"}', 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
(4996, 3285757, 44829497, '83326555', '0008193289001', '430661', '', '84929813', 'Angela', 'Yancey', '', '{\"DOB\": 26214, \"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\": \"3114\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Canton\", \"Pcp_Name\": \"Nasir Ali Ashghar\", \"Rank_All\": \"\", \"PCP_Phone\": \"7066929768\", \"Pcp_State\": \"\", \"Member_City\": \"Resaca\", \"Office_Name\": \"Prestige Medical Group\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Resaca\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1971-10-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"3755 Sixes Rd. Suite 300 \", \"Screening_IHA\": \"No\", \"member_id_two\": 430661, \"Mailing_County\": \"GORDON\", \"Member_Country\": \"GORDON\", \"PCP_Fax_Number\": \"7066924040\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1603 County Line Road\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30735, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"1603 County Line Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30735, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Yancey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angela\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"yanceyclan@bellsouth.net\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6782834595, \"Member_Identification_Number\": \"0008193289001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"10-01-2024 12:20:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-01 12:20:52\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-13T15:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-25T14:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-28T23:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-29T00:35\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-01T12:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-20T17:23\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-13T15:31\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-20T17:23\", \"reportStatus_date\": \"2024-08-20T17:23\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-29T00:35\", \"reportStatus_date\": \"2024-09-29T00:35\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-01T12:20\", \"reportStatus_date\": \"2024-10-01T12:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-01T12:20\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-20T17:23\", \"username\": null}, {\"date\": \"2024-08-20T17:23\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-25T11:52\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [{\"date\": \"2024-09-25T15:04\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-09-25T14:17\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-25T14:17\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-27T13:51\", \"username\": \"CMiddleton\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-29T00:35\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-28T23:06\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-29T00:35\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-26T10:58\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"16:22:15\", \"value\": [{\"add\": \"1603 County Line Road\", \"age\": 53, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1971-10-08\", \"eno\": \"6788988054\", \"lob\": \"On Exchange\", \"pno\": 6782834595, \"zip\": 30735, \"add2\": \"\", \"add3\": \"\", \"city\": \"Resaca\", \"gend\": 1, \"insh\": \"0008193289001\", \"mzip\": 30735, \"name\": \"Angela Yancey\", \"plan\": \"Alliant\", \"pphy\": \"Nasir Ali Ashghar\", \"ppno\": \"7066929768\", \"race\": \"\", \"cliId\": \"\", \"email\": \"yanceyclan@bellsouth.net\", \"ename\": \"Tony Yancey \", \"madd1\": \"1603 County Line Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Resaca\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"3755 Sixes Rd. Suite 300 \", \"pcpnpi\": \"\", \"pcpzip\": \"3114\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Canton\", \"pcpname\": \"Prestige Medical Group\", \"program\": \"ACA\", \"evalDate\": \"2024-09-25 01:00 PM\", \"evalName\": \"Connie Middleton, FNP\", \"pcpfaxno\": \"7066924040\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-25-2024\", \"time\": \"11:52:02\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-13-2025 16:22:15\"}', NULL, NULL, '{\"memberId\": \"0008193289001\", \"clinician\": \"Connie Middleton\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Thu, 26 Sep 2024 14:58:56 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Connie,\\nThank you for your thorough assessment!\\n\\n1) Under assessment of dx can you please add dx of HLD r/t medication use of a statin\\n2) Under pain section, can you please answer yes or no for acute pain\\n3) Under home safety question asking about preventing member from making changes can you please select other\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 27 Sep 2024 17:51:15 GMT\", \"name\": \"Connie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Done\"}, \"mailId\": \"\"}], \"memberName\": \"Angela Yancey\", \"codingAnalyst\": \"\", \"dateOfService\": \"09/25/2024 01:00 PM\", \"clinicianMailId\": \"c.middleton@focuscares.com\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/20/2024 @ 05:23 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Connie for 09/25/2024 @ 1:00PM via Dozy.me. Sent email with appointment information to yanceyclan@bellsouth.net\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/13/2024 @ 03:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"8/20/2024 @ 03:30 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0008193289001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"83326555\", \"memberId\": \"0008193289001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"83326555\", \"memberId\": \"0008193289001\", \"scheduleDate\": \"2024-9-25T13:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 15:31:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"08-20-2024 17:23:56\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-10-01 12:20:50\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"1fdd985a-8011-11ef-bcbd-475d0321c5ff\\\",\\\"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-9-25T13:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:14', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008193289001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0008193289001_Yancey, Angela_09252024.pdf\", \"ftp_upload_date\": \"2024-10-01 12:20:50\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Dr. Ashghar_0008193289001_09252024.pdf\"}', 'ACA_0008193289001_Yancey, Angela_09252024', NULL, 'PCP_, Dr. Ashghar_0008193289001_09252024', NULL, '[{\"date\": \"2024-09-25T18:17:09.021Z\", \"signature\": \"data:image/png;base64,[encoded data, 24292 characters]\"}, {\"date\": \"2024-09-27T17:51:14.195Z\", \"signature\": \"data:image/png;base64,[encoded data, 24272 characters]\"}]', '2024-09-25T14:16', 'Member_Summary_0008193289001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008193289001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0008193289001.pdf\", \"member_ftp_upload_date\": \"2024-10-01 12:20:51\"}', 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
(4997, NULL, NULL, NULL, '0008193291001', '430718', '', '21881792', 'Denise', 'Lawrence', '', '{\"DOB\": 22683, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Carrollton\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-02-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430718, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"42 Spence Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"42 Spence Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Lawrence\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Denise\", \"Member_Middle_name\": \"Michelle\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"15dmtpasley@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6784698036, \"Member_Identification_Number\": \"0008193291001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:47\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:47\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T12:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T16:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-28T16:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-15T14:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T12:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T16:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-15T14:04\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-06T05:55\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-27T12:16\", \"username\": null}, {\"date\": \"2024-08-27T12:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T07:44\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:14\", \"value\": [{\"add\": \"42 Spence Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-02-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6784698036, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0008193291001\", \"mzip\": 30117, \"name\": \"Denise Michelle Lawrence\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"15dmtpasley@gmail.com\", \"ename\": \"\", \"madd1\": \"42 Spence Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:14\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 10:51 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:12 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 09:59 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/15/2024 @ 02:04 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/16/2024 @ 02:04 PM\"}, {\"date\": \"8/28/2024 @ 04:56 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"9/4/2024 @ 04:55 PM\"}, {\"date\": \"8/27/2024 @ 04:13 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 @ 04:13 PM\"}, {\"date\": \"8/9/2024 @ 12:24 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Faith Enwefah. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/12/2024 @ 12:24 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 12:24:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:32:55\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4998, NULL, NULL, NULL, '0008194756001', '433950', '', '33985161', 'Kenneth', 'Ray', '', '{\"DOB\": 28254, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Milledgeville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Milledgeville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-05-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433950, \"Mailing_County\": \"BALDWIN\", \"Member_Country\": \"BALDWIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2242 Queens Court\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31061, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"2242 Queens Court\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31061, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Ray\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kenneth\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4784430015, \"Member_Identification_Number\": \"0008194756001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:47\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:47\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T09:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-30T15:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-17T12:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-11-22T13:56\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T09:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T15:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T12:58\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-11-22T13:56\", \"reportStatus_date\": \"2024-11-22T13:56\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T13:56\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:15\", \"value\": [{\"add\": \"2242 Queens Court\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-05-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4784430015, \"zip\": 31061, \"add2\": \"\", \"add3\": \"\", \"city\": \"Milledgeville\", \"gend\": 0, \"insh\": \"0008194756001\", \"mzip\": 31061, \"name\": \"Kenneth Ray\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"2242 Queens Court\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Milledgeville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:15\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-11-22T13:56\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"12/19/2024 @ 04:37 PM\", \"result\": 4, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 01:56 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/17/2024 @ 12:58 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 12:58 PM\"}, {\"date\": \"9/30/2024 @ 03:02 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/1/2024 @ 03:02 PM\"}, {\"date\": \"8/15/2024 @ 09:22 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\": \"8/16/2024 @ 09:22 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 09:22:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"12-19-2024 16:37:44\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:15', 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
(4999, 3285757, 44829497, '56716210', '0008196016001', '435827', '', '99038484', 'James', 'Gaines', '', '{\"DOB\": 37435, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dawsonville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2002-06-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435827, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"603 Old Kerns Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"603 Old Kerns Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gaines\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"Austin\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"k1ngjamess@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7068893229, \"Member_Identification_Number\": \"0008196016001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"10-01-2024 12:20:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-10-01 12:20:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-21T12:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T17:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T20:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-10-01T12:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-09T13:58\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-08-23T10:02\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-08-20T06:38\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-09T13:58\", \"reportStatus_date\": \"2024-08-09T13:58\"}, {\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-23T10:02\", \"reportStatus_date\": \"2024-08-23T10:02\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-09-23T22:45\", \"reportStatus_date\": \"2024-09-21T12:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-24T20:15\", \"reportStatus_date\": \"2024-09-24T20:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-10-01T12:20\", \"reportStatus_date\": \"2024-10-01T12:20\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-10-01T12:20\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-09T13:58\", \"username\": null}, {\"date\": \"2024-08-09T13:58\", \"username\": null}, {\"date\": \"2024-08-23T10:02\", \"username\": null}, {\"date\": \"2024-08-23T10:02\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-20T11:34\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-09-23T09:49\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-09-21T12:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-21T12:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-09-24T16:28\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-24T20:15\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-24T17:08\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-24T20:15\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-23T22:45\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-20T06:38\", \"username\": \"JHelm\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"11-25-2024\", \"time\": \"13:55:38\", \"value\": [{\"add\": \"603 Old Kerns Rd\", \"age\": 22, \"ano\": \"\", \"cno\": \"\", \"dob\": \"2002-06-28\", \"eno\": \"7065029853\", \"lob\": \"On Exchange\", \"pno\": 7068893229, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 0, \"insh\": \"0008196016001\", \"mzip\": 30534, \"name\": \"James Austin Gaines\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"k1ngjamess@icloud.com\", \"ename\": \"Kenneth Belchez\", \"madd1\": \"603 Old Kerns Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-9-20 11:30 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"needs one\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-03-2024\", \"time\": \"10:50:48\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"11-25-2024 13:55:38\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-20T06:38\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"JHelm\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"0008196016001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Tue, 24 Sep 2024 02:45:29 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\nThank you for your thorough assessment!\\n\\n1) Under preventative care, can you please select yes or no for osteoporosis screening\\n2) Can you add dx of alopecia to the assessment of dx r/t medication use\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 24 Sep 2024 20:28:59 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrections made. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"James Gaines\", \"codingAnalyst\": \"\", \"dateOfService\": \"09/20/2024 11:30 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"8/23/2024 @ 10:02 AM\", \"result\": 12, \"comment\": \"Re-scheduled F2F HRA with Delise on 9/20 at 11:30am. Member has pets but will be put away during visit, also has a dirt driveway\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/9/2024 @ 01:58 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA with Jansen for 08/19/2024 @ 2:00PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0008196016001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0008196016001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0008196016001\", \"scheduleDate\": \"2024-9-20T11:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 13:58:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}, {\"date\": \"08-20-2024 06:39:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"08-23-2024 10:02:24\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-10-01 12:20:55\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"226d921a-8011-11ef-870a-0fa4bbfb4acf\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-9-20T11:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:15', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008196016001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0008196016001_Gaines, James_09202024.pdf\", \"ftp_upload_date\": \"2024-10-01 12:20:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP__0008196016001_09202024.pdf\"}', 'ACA_0008196016001_Gaines, James_09202024', NULL, 'PCP__0008196016001_09202024', NULL, '[{\"date\": \"2024-09-21T16:06:41.843Z\", \"signature\": \"data:image/png;base64,[encoded data, 23476 characters]\"}, {\"date\": \"2024-09-24T20:28:59.312Z\", \"signature\": \"data:image/png;base64,[encoded data, 23512 characters]\"}]', '2024-09-20T13:00', 'Member_Summary_0008196016001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008196016001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0008196016001.pdf\", \"member_ftp_upload_date\": \"2024-10-01 12:20:55\"}', 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
(5000, NULL, NULL, NULL, '0008197115001', '432036', '', '21881792', 'Chevillette', 'Basil', '', '{\"DOB\": 25027, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Carrollton\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-07-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 432036, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"212 Cedar St\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"212 Cedar St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Basil\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Chevillette\", \"Member_Middle_name\": \"Elizabeth\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"cebasil3002@gmail.com\", \"Member_Suspect_Codes\": \"11, 12\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6787632249, \"Member_Identification_Number\": \"0008197115001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:47\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-08-09T12:28\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-09T12:28\", \"reportStatus_date\": \"2024-08-09T12:28\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-08-09T12:28\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:16\", \"value\": [{\"add\": \"212 Cedar St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-07-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787632249, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0008197115001\", \"mzip\": 30117, \"name\": \"Chevillette Elizabeth Basil\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"cebasil3002@gmail.com\", \"ename\": \"\", \"madd1\": \"212 Cedar St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:16\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-08-09T12:28\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/9/2024 @ 12:28 PM\", \"result\": 9, \"comment\": \"Member declined offer to schedule HRA in 2024. - Refused \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 12:28:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-08-2024 00:34:23\", \"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', '07-08-2024 01:41:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5001, NULL, NULL, NULL, '0008209295001', '432450', '', '21881792', 'Bonnie', 'Passmore', '', '{\"DOB\": 22096, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Cleveland\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-06-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 432450, \"Mailing_County\": \"\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"53 Nelson Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"PO Box 1734\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Passmore\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Bonnie\", \"Member_Middle_name\": \"Angela\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bonnellok@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065803410, \"Member_Identification_Number\": \"0008209295001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-22T15:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T15:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T15:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-23T15:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-06T05:55\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-27T12:16\", \"username\": null}, {\"date\": \"2024-08-27T12:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T07:44\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:16\", \"value\": [{\"add\": \"53 Nelson Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-06-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065803410, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0008209295001\", \"mzip\": 30528, \"name\": \"Bonnie Angela Passmore\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"bonnellok@gmail.com\", \"ename\": \"\", \"madd1\": \"PO Box 1734\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:16\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 02:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 01:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/23/2024 @ 03:09 PM\", \"result\": 1, \"comment\": \"Called to schedule Virtual HRA with Delise Adams DEAD AIR \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/3/2024 @ 03:09 PM\"}, {\"date\": \"8/23/2024 @ 03:06 PM\", \"result\": 1, \"comment\": \"Called to schedule Virtual HRA with Delise Adams DEAD AIR \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/3/2024 @ 03:06 PM\"}, {\"date\": \"8/22/2024 @ 03:49 PM\", \"result\": 1, \"comment\": \"DEAD AIR -  Call answered but no sound on call. Call to schedule a HRA w/ Delise Adams.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 03:49 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-22-2024 15:49:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:43:37\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5002, 57818338, 44829497, '56716210', '0008210707001', '431611', '', '20099125', 'Dayna', 'Dean', '', '{\"DOB\": 30756, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"can\'t recall name\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"Medlink\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-03-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 431611, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4106 Elm Grove Ave\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"4106 Elm Grove Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Dean\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dayna\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Daynadean33@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7702433841, \"Member_Identification_Number\": \"0008210707001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-03-2024 12:42:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-03 12:42:12\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-25T22:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-27T21:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-28T13:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-03T12:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-14T11:58\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-14T11:58\", \"reportStatus_date\": \"2024-08-14T11:58\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-08-25T22:12\", \"reportStatus_date\": \"2024-08-25T22:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-28T13:01\", \"reportStatus_date\": \"2024-08-28T13:01\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-03T12:42\", \"reportStatus_date\": \"2024-09-03T12:42\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-03T12:42\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-14T11:58\", \"username\": null}, {\"date\": \"2024-08-14T11:58\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-22T22:07\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-26T17:07\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-08-25T22:12\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-25T22:12\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-28T13:01\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-27T21:04\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-28T13:01\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"10-22-2024\", \"time\": \"16:51:20\", \"value\": [{\"add\": \"4106 Elm Grove Ave\", \"age\": 40, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-03-15\", \"eno\": \"4043684151\", \"lob\": \"On Exchange\", \"pno\": 7702433841, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0008210707001\", \"mzip\": 30501, \"name\": \"Dayna Dean\", \"plan\": \"Alliant\", \"pphy\": \"can\'t recall name\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"Daynadean33@gmail.com\", \"ename\": \"Jamie Youngker\", \"madd1\": \"4106 Elm Grove Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Separated\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"Medlink\", \"program\": \"ACA\", \"evalDate\": \"2024-8-23 3:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-22-2024\", \"time\": \"22:07:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-22-2024 16:51:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/14/2024 @ 11:58 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Delise on 8/23 at 3pm. Member will be using phone, texted doxy link.   \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0008210707001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0008210707001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0008210707001\", \"scheduleDate\": \"2024-8-23T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 11:58:00\", \"schedulerId\": \"20099125\", \"schedulerLeadId\": \"20099125\"}]}', '{\"date\": \"08-14-2024 11:58:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-09-03 12:42:11\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"772bb26e-6a13-11ef-989d-a9d90eeec041\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-8-23T15:00', '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:17', NULL, NULL, NULL, NULL, NULL, 'ACA_0008210707001_Dean, Dayna_08232024', NULL, 'PCP_name, can\'t recall_0008210707001_08232024', NULL, '[{\"date\": \"2024-08-26T02:12:43.568Z\", \"signature\": \"data:image/png;base64,[encoded data, 23476 characters]\"}]', '2024-08-23T15:40', 'Member_Summary_0008210707001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008210707001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0008210707001.pdf\", \"member_ftp_upload_date\": \"2024-09-03 12:42:12\"}', 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
(5003, NULL, NULL, NULL, '0008210827002', '435466', '', NULL, 'KENNA', 'SEAY', '', '{\"DOB\": 31323, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Carrollton\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-10-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435466, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"345 Old Camp Church Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"345 Old Camp Church Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"SEAY\", \"Medication_Review\": \"N\", \"Member_first_name\": \"KENNA\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0008210827002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:17\", \"value\": [{\"add\": \"345 Old Camp Church Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-10-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0008210827002\", \"mzip\": 30117, \"name\": \"KENNA SEAY\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"345 Old Camp Church Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:17\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:34:24\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5004, 57818338, 44829497, '56716210', '0008213768001', '434175', '', '21881792', 'Victor', 'Duff', '', '{\"DOB\": 26742, \"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\": \"30542\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"Flowery Branch\", \"Pcp_Name\": \"Paul Cerny\", \"Rank_All\": \"\", \"PCP_Phone\": \"7709659222\", \"Pcp_State\": \"\", \"Member_City\": \"Clermont\", \"Office_Name\": \"NGMC\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clermont\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-03-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4919 Atlanta Hwy\", \"Screening_IHA\": \"No\", \"member_id_two\": 434175, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7709658811\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6590 Pond View Ct\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30527, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"6590 Pond View Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30527, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Duff\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Victor\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"jason@incelectric.com\", \"Member_Suspect_Codes\": \"48\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7708265804, \"Member_Identification_Number\": \"0008213768001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-28-2024 11:21:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-28 11:21:31\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-16T18:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-20T12:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-20T13:12\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-28T11:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-14T16:39\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-08-16T18:06\", \"reportStatus_date\": \"2024-08-16T18:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-20T13:12\", \"reportStatus_date\": \"2024-08-20T13:12\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-28T11:21\", \"reportStatus_date\": \"2024-08-28T11:21\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-28T11:21\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-14T16:39\", \"username\": null}, {\"date\": \"2024-08-14T16:39\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-15T23:40\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-19T10:56\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-16T18:06\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-16T18:06\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-20T13:12\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-20T12:11\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-20T13:12\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"10-15-2024\", \"time\": \"13:46:45\", \"value\": [{\"add\": \"6590 Pond View Ct\", \"age\": 51, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-03-19\", \"eno\": \"7069824699\", \"lob\": \"On Exchange\", \"pno\": 7708265804, \"zip\": 30527, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clermont\", \"gend\": 0, \"insh\": \"0008213768001\", \"mzip\": 30527, \"name\": \"Victor Duff\", \"plan\": \"Alliant\", \"pphy\": \"Paul Cerny\", \"ppno\": \"7709659222\", \"race\": \"\", \"cliId\": \"\", \"email\": \"jason@incelectric.com\", \"ename\": \"Aundrea Duff\", \"madd1\": \"6590 Pond View Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clermont\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4919 Atlanta Hwy\", \"pcpnpi\": \"\", \"pcpzip\": \"30542\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": \"\", \"pcpcity\": \"Flowery Branch\", \"pcpname\": \"NGMC\", \"program\": \"ACA\", \"evalDate\": \"2024-8-16 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7709658811\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-15-2024\", \"time\": \"23:40:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-15-2024 13:46:45\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/14/2024 @ 04:39 PM\", \"result\": 0, \"comment\": \"Scheduled Delise Adams on 8/16 @ 8 - member will use their iPhone and texted Doxy link to member. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0008213768001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0008213768001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0008213768001\", \"scheduleDate\": \"2024-8-16T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 16:39:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-14-2024 16:39:25\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-08-28 11:21:30\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"33d18525-6551-11ef-a421-5dc574f5d6f6\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-8-16T08:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:18', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008213768001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0008213768001_Duff, Victor_08162024.pdf\", \"ftp_upload_date\": \"2024-08-28 11:21:30\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Cerny, Paul_0008213768001_08162024.pdf\"}', 'ACA_0008213768001_Duff, Victor_08162024', NULL, 'PCP_Cerny, Paul_0008213768001_08162024', NULL, '[{\"date\": \"2024-08-16T22:06:32.707Z\", \"signature\": \"data:image/png;base64,[encoded data, 23492 characters]\"}]', '2024-08-16T08:43', 'Member_Summary_0008213768001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008213768001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0008213768001.pdf\", \"member_ftp_upload_date\": \"2024-08-28 11:21:31\"}', NULL, NULL, NULL, NULL),
(5005, NULL, NULL, NULL, '0008222297001', '433187', '', '33985161', 'angelia', 'rumph', '', '{\"DOB\": 27765, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Warner Robins\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warner Robins\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1976-01-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433187, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"523 N Davis Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31093, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"523 N Davis Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31093, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"rumph\", \"Medication_Review\": \"N\", \"Member_first_name\": \"angelia\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4783424376, \"Member_Identification_Number\": \"0008222297001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 4784448374}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-15T09:23\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-09-13T16:40\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-09-30T15:03\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-10-17T13:00\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T09:23\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T16:40\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T15:03\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T13:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-06T05:55\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-27T12:16\", \"username\": null}, {\"date\": \"2024-08-27T12:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T07:44\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:18\", \"value\": [{\"add\": \"523 N Davis Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": 4784448374, \"dob\": \"1976-01-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4783424376, \"zip\": 31093, \"add2\": \"\", \"add3\": \"\", \"city\": \"Warner Robins\", \"gend\": 1, \"insh\": \"0008222297001\", \"mzip\": 31093, \"name\": \"angelia rumph\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"523 N Davis Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Warner Robins\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:18\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/13/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 07:25 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 06:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/17/2024 @ 01:00 PM\", \"result\": 10, \"comment\": \"Call attempt to schedule an HRA - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 01:00 PM\"}, {\"date\": \"9/30/2024 @ 03:03 PM\", \"result\": 10, \"comment\": \"Call attempt to schedule an HRA - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/1/2024 @ 03:03 PM\"}, {\"date\": \"9/13/2024 @ 04:40 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule an HRA - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/16/2024 @ 04:40 PM\"}, {\"date\": \"8/15/2024 @ 09:23 AM\", \"result\": 10, \"comment\": \"DISCONNECTED -Primary number no longer in service. Call attempt to schedule a virtual HRA Nykya Cox  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/16/2024 @ 09:23 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 09:23:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"12-16-2024 00:49:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:18', 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
(5006, NULL, NULL, NULL, '0008223457001', '435815', '', '47262451', 'Janice', 'Mcleod', '', '{\"DOB\": 22111, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Mc Rae Helena\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Mc Rae Helena\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-07-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435815, \"Mailing_County\": \"TELFAIR\", \"Member_Country\": \"TELFAIR\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"60 S Second Ave\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31055, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"60 S Second Ave\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31055, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mcleod\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Janice\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"janicemcleod3@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2293158360, \"Member_Identification_Number\": \"0008223457001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-11-01T13:34\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-13T12:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-30T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-17T13:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-01T13:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-01T13:34\", \"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-09-13T12:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T15:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T13:02\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-01T13:34\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:18\", \"value\": [{\"add\": \"60 S Second Ave\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-07-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2293158360, \"zip\": 31055, \"add2\": \"\", \"add3\": \"\", \"city\": \"Mc Rae Helena\", \"gend\": 1, \"insh\": \"0008223457001\", \"mzip\": 31055, \"name\": \"Janice Mcleod\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"janicemcleod3@gmail.com\", \"ename\": \"\", \"madd1\": \"60 S Second Ave\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Mc Rae Helena\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:18\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 01:34 PM\", \"result\": 3, \"comment\": \"6 attempt Vm msg-LB\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 01:32 PM\", \"result\": 1, \"comment\": \"6 attempt dear air-LB\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"11/29/2024 @ 01:32 PM\"}, {\"date\": \"10/17/2024 @ 01:02 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 01:01 PM\"}, {\"date\": \"9/30/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/1/2024 @ 03:05 PM\"}, {\"date\": \"9/13/2024 @ 12:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/20/2024 @ 12:14 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"09-13-2024 12:14:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"11-01-2024 13:34:11\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5007, NULL, NULL, NULL, '0008226676001', '430028', '', '21881792', 'Nicole', 'Cislak', '', '{\"DOB\": 32122, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Villa Rica\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1987-12-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 430028, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"34 S Villa Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"34 S Villa Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Cislak\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nicole\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45383, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"nicolelovesbabyshane23@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4708602281, \"Member_Identification_Number\": \"0008226676001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-08-13T16:47\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-28T12:59\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-29T10:48\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-10-15T14:06\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-13T16:47\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T10:48\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-15T14:06\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:47\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-06T05:55\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-27T12:16\", \"username\": null}, {\"date\": \"2024-08-27T12:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T07:44\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:19\", \"value\": [{\"add\": \"34 S Villa Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1987-12-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4708602281, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 1, \"insh\": \"0008226676001\", \"mzip\": 30180, \"name\": \"Nicole Cislak\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"nicolelovesbabyshane23@gmail.com\", \"ename\": \"\", \"madd1\": \"34 S Villa Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:19\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/13/2024 @ 12:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:41 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 07:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 05:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/15/2024 @ 02:06 PM\", \"result\": 10, \"comment\": \"Call attempt to schedule an HRA - Disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/16/2024 @ 02:06 PM\"}, {\"date\": \"8/29/2024 @ 10:48 AM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a HRA w/ Faith Enwefah. - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/30/2024 @ 10:47 AM\"}, {\"date\": \"8/28/2024 @ 12:59 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a HRA w/ Faith Enwefah. - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/30/2024 @ 12:59 PM\"}, {\"date\": \"8/13/2024 @ 04:47 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a virtual HRA w/ Faith Enwefah.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/14/2024 @ 04:47 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 16:47:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 00:49:24\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5008, NULL, NULL, NULL, '0008232667001', '434342', '', '21881792', 'Dale', 'Miller', '', '{\"DOB\": 23053, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Cleveland\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-02-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 434342, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"290 Hudson Quarry Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"290 Hudson Quarry Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Miller\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dale\", \"Member_Middle_name\": \"Franklin\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dalefmiller@live.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6788656747, \"Member_Identification_Number\": \"0008232667001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-09-24T12:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-25T15:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-10-03T12:42\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-09-25T15:56\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-03T12:42\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-06T05:55\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-27T12:16\", \"username\": null}, {\"date\": \"2024-08-27T12:16\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-05T07:44\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:19\", \"value\": [{\"add\": \"290 Hudson Quarry Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-02-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6788656747, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 0, \"insh\": \"0008232667001\", \"mzip\": 30528, \"name\": \"Dale Franklin Miller\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dalefmiller@live.com\", \"ename\": \"\", \"madd1\": \"290 Hudson Quarry Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:19\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 02:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 01:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/3/2024 @ 12:42 PM\", \"result\": 6, \"comment\": \"Member stated has busy schedule - Call member back in 3 weeks to attempt to schedule.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/24/2024 @ 12:41 PM\"}, {\"date\": \"9/25/2024 @ 03:56 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 03:56 PM\"}, {\"date\": \"9/24/2024 @ 12:56 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/25/2024 @ 12:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"09-24-2024 12:56:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:43:38\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5009, NULL, NULL, NULL, '0008232708001', '435211', '', '84929813', 'Kenneth', 'Parrish', '', '{\"DOB\": 24351, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"PCP_Phone\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Tunnel Hill\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Tunnel Hill\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-09-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435211, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"404 N Lakeshore Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30755, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"404 N Lakeshore Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30755, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Parrish\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kenneth\", \"Member_Middle_name\": \"Eugene\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"KennethParrish8@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069347509, \"Member_Identification_Number\": \"0008232708001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"0\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:38:48\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:48\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-08-21T10:44\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-08-21T11:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-09-11T09:23\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-08-21T10:17\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2024-09-04T15:23\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2024-09-14T13:21\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-13T16:48\", \"reportStatus_date\": \"2024-08-13T16:48\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-21T11:09\", \"reportStatus_date\": \"2024-08-21T11:09\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-09-04T15:23\", \"reportStatus_date\": \"2024-09-04T15:23\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-09-14T13:21\", \"reportStatus_date\": \"2024-09-14T13:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T11:09\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": \"admin\"}], \"inProgress\": [{\"date\": \"2024-08-21T09:24\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-13T10:50\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"username\": null}, {\"date\": \"2024-09-04T15:23\", \"username\": \"PFrey1\"}, {\"date\": \"2024-09-14T13:21\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-13-2024\", \"time\": \"10:50:25\", \"value\": [{\"add\": \"404 N Lakeshore Dr\", \"age\": 58, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-09-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069347509, \"zip\": 30755, \"add2\": \"\", \"add3\": \"\", \"city\": \"Tunnel Hill\", \"gend\": 0, \"insh\": \"0008232708001\", \"mzip\": 30755, \"name\": \"Kenneth Eugene Parrish\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"KennethParrish8@gmail.com\", \"ename\": \"\", \"madd1\": \"404 N Lakeshore Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Tunnel Hill\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-21-2024\", \"time\": \"09:24:37\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-13-2024 10:50:33\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": \"0\"}, {\"date\": \"2024-09-04T15:23\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}, {\"date\": \"2024-09-14T13:21\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": \"0\"}]}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/6/2024 @ 05:34 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/13/2024 @ 02:35 PM\", \"result\": 14, \"comment\": \"Member needs to cx hra tomorrow due to being called in to work member would like call back to RS  - LLA \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/30/2024 @ 02:34 PM\"}, {\"date\": \"9/11/2024 @ 09:23 AM\", \"result\": 0, \"comment\": \"Scheduled by Alyia on 8/21/24 but not updated.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tema Ferness\", \"callbackDate\": \"\"}, {\"date\": \"8/21/2024 @ 10:44 AM\", \"result\": 0, \"comment\": \"Scheduled f2f w/ connie 9/14/24 at 11:30am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/13/2024 @ 04:48 PM\", \"result\": 0, \"comment\": \"scheduled virtual appt with connie for 8/21 @ 10am. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-13-2024 16:48:00\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}, {\"date\": \"08-21-2024 10:17:22\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}, {\"date\": \"09-04-2024 15:23:55\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}, {\"date\": \"09-14-2024 13:21:03\", \"schedulerId\": \"84929813\", \"schedulerLeadId\": \"84929813\"}]}', '{\"date\": \"09-14-2024 13:21:03\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, 'In Person', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5010, NULL, NULL, NULL, '0008233877001', '431621', '', '21881792', 'KEVIN', 'HERNANDEZ', '', '{\"DOB\": 38024, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dahlonega\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2004-02-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 431621, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"458 Fortner Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"458 Fortner Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"HERNANDEZ\", \"Medication_Review\": \"N\", \"Member_first_name\": \"KEVIN\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dayanaradelacruz@outlook.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6782688008, \"Member_Identification_Number\": \"0008233877001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2026 23:30:35\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2026-01-01 23:30:34\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-22T17:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-23T16:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-30T11:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-30T10:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-23T16:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-30T11:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-30T10:20\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:07\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:20\", \"value\": [{\"add\": \"458 Fortner Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2004-02-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782688008, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0008233877001\", \"mzip\": 30533, \"name\": \"KEVIN HERNANDEZ\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dayanaradelacruz@outlook.com\", \"ename\": \"\", \"madd1\": \"458 Fortner Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:20\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 11:48 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 11:31 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:20 AM\", \"result\": 13, \"comment\": \"called for HRA-Virtual - Connie Middleton-GA, RN,NP : caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"10/31/2024 @ 10:19 AM\"}, {\"date\": \"8/30/2024 @ 11:21 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams NO VM SETUP \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/6/2024 @ 11:21 AM\"}, {\"date\": \"8/23/2024 @ 04:09 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Delise Adams 9/13. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 04:09 PM\"}, {\"date\": \"8/22/2024 @ 05:18 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Delise Adams 9/13. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/23/2024 @ 05:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-22-2024 17:18:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 01:07:00\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2025-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5011, NULL, NULL, NULL, '0008233976001', '433582', '', '47262451', 'Kaitlyn', 'Gerow', '', '{\"DOB\": 38161, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Pitts\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Pitts\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2004-06-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433582, \"Mailing_County\": \"WILCOX\", \"Member_Country\": \"WILCOX\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"590 Chestnut Ln\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31072, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"590 Chestnut Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31072, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Gerow\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kaitlyn\", \"Member_Middle_name\": \"Alexis\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kaitlynrgerow19@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294060780, \"Member_Identification_Number\": \"0008233976001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T18:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-16T13:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-13T15:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-07T14:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T18:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-16T13:45\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-13T15:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-07T14:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:42\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:39\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T11:09\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": \"admin\"}], \"inProgress\": [{\"date\": \"2024-08-21T09:24\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-13T10:50\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"username\": null}, {\"date\": \"2024-09-04T15:23\", \"username\": \"PFrey1\"}, {\"date\": \"2024-09-14T13:21\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:21\", \"value\": [{\"add\": \"590 Chestnut Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2004-06-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294060780, \"zip\": 31072, \"add2\": \"\", \"add3\": \"\", \"city\": \"Pitts\", \"gend\": 1, \"insh\": \"0008233976001\", \"mzip\": 31072, \"name\": \"Kaitlyn Alexis Gerow\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kaitlynrgerow19@gmail.com\", \"ename\": \"\", \"madd1\": \"590 Chestnut Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Pitts\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:21\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 02:42 PM\", \"result\": 13, \"comment\": \"caller d/c\'d call after I explained everything to her and asked if she would be interested and time of day accommodating to her schedule and she just hung up.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:39 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/13/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/17/2024 @ 03:05 PM\"}, {\"date\": \"8/16/2024 @ 01:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/21/2024 @ 01:45 PM\"}, {\"date\": \"8/9/2024 @ 06:12 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"8/12/2024 @ 02:12 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 18:12:00\", \"schedulerId\": \"47262451\", \"schedulerLeadId\": \"47262451\"}]}', '{\"date\": \"12-16-2024 00:39:59\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(5012, NULL, NULL, NULL, '0008235085001', '435943', '', '33985161', 'Jessica', 'Brown', '', '{\"DOB\": 33704, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Cochran\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cochran\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-04-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435943, \"Mailing_County\": \"BLECKLEY\", \"Member_Country\": \"BLECKLEY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"137 Malgene Drive Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31014, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"137 Malgene Drive Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31014, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Brown\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jessica\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jb6427495@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4782982786, \"Member_Identification_Number\": \"0008235085001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T09:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-12T12:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-30T15:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-17T13:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T09:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-12T12:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-30T15:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-17T13:04\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:35\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T11:09\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": \"admin\"}], \"inProgress\": [{\"date\": \"2024-08-21T09:24\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-13T10:50\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"username\": null}, {\"date\": \"2024-09-04T15:23\", \"username\": \"PFrey1\"}, {\"date\": \"2024-09-14T13:21\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:21\", \"value\": [{\"add\": \"137 Malgene Drive Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-04-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4782982786, \"zip\": 31014, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cochran\", \"gend\": 1, \"insh\": \"0008235085001\", \"mzip\": 31014, \"name\": \"Jessica Brown\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"jb6427495@gmail.com\", \"ename\": \"\", \"madd1\": \"137 Malgene Drive Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cochran\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:21\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 02:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 01:58 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/17/2024 @ 01:04 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/18/2024 @ 01:04 PM\"}, {\"date\": \"9/30/2024 @ 03:13 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/1/2024 @ 03:13 PM\"}, {\"date\": \"9/12/2024 @ 12:18 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/13/2024 @ 12:18 PM\"}, {\"date\": \"8/15/2024 @ 09:24 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\": \"8/16/2024 @ 09:24 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 09:24:00\", \"schedulerId\": \"33985161\", \"schedulerLeadId\": \"33985161\"}]}', '{\"date\": \"11-11-2024 00:35:38\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5013, NULL, NULL, NULL, '0008238312001', '433552', '', '26056802', 'Willie', 'Barnes', '', '{\"DOB\": 22573, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Harlem\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Harlem\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-10-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433552, \"Mailing_County\": \"\", \"Member_Country\": \"COLUMBIA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"440 G R Tucker Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30814, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"PO Box 224\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30814, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Barnes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Willie\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"williebarnes49@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7066991637, \"Member_Identification_Number\": \"0008238312001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-15T14:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-10-25T12:03\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T14:10\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-25T12:03\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:22\", \"value\": [{\"add\": \"440 G R Tucker Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-10-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7066991637, \"zip\": 30814, \"add2\": \"\", \"add3\": \"\", \"city\": \"Harlem\", \"gend\": 0, \"insh\": \"0008238312001\", \"mzip\": 30814, \"name\": \"Willie Barnes\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"williebarnes49@yahoo.com\", \"ename\": \"\", \"madd1\": \"PO Box 224\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Harlem\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:22\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:22\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"10/25/2024 @ 12:03 PM\", \"result\": 6, \"comment\": \"Member stated he may switch plans by the end of year. Explained reason for call - call back member at a later date and time - Call attempt to schedule an HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/28/2024 @ 12:03 PM\"}, {\"date\": \"8/15/2024 @ 02:10 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Connie Middleton\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"8/22/2024 @ 02:10 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 14:10:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"08-08-2024 00:34:24\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1730098564}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41: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
(5014, 57818338, 44829497, '96917241', '0008238340001', '434250', '', '99038484', 'Janice', 'Watkins', '', '{\"DOB\": 22674, \"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\": \"30753\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Trion \", \"Pcp_Name\": \"Wayne Richey \", \"Rank_All\": \"\", \"PCP_Phone\": \"706-734-7302\", \"Pcp_State\": \"\", \"Member_City\": \"Summerville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Summerville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-01-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"160 Central Ave \", \"Screening_IHA\": \"No\", \"member_id_two\": 434250, \"Mailing_County\": \"CHATTOOGA\", \"Member_Country\": \"CHATTOOGA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"422 Rossville Blvd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30747, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"422 Rossville Blvd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30747, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Watkins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Janice\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"jjdon106@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7067280829, \"Member_Identification_Number\": \"0008238340001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'0', '{\"date\": \"01-07-2025 19:11:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2025-01-07 19:11:47\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": {\"0\": {\"date\": \"2024-08-15T15:33\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, \"2\": {\"date\": \"2024-12-10T12:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, \"3\": {\"date\": \"2024-12-16T01:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}}, \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-12-31T13:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2025-01-03T01:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2025-01-03T16:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2025-01-07T19:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-12-20T09:49\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-12-23T11:52\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-10-15T16:44\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-15T15:33\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-15T16:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:43\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:09\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-12-23T11:52\", \"reportStatus_date\": \"2024-12-23T11:52\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2025-01-03T16:42\", \"reportStatus_date\": \"2025-01-03T16:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2025-01-07T19:11\", \"reportStatus_date\": \"2025-01-07T19:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2025-01-07T19:11\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T11:09\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": \"admin\"}, {\"date\": \"2024-12-20T09:49\", \"username\": null}, {\"date\": \"2024-12-20T09:49\", \"username\": null}, {\"date\": \"2024-12-23T11:52\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-21T09:24\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-13T10:50\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-12-31T13:35\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2025-01-01T22:00\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-12-31T13:56\", \"username\": \"NCox\"}, {\"date\": \"2024-12-31T13:56\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2025-01-03T16:42\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2025-01-03T01:13\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2025-01-03T16:42\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"username\": null}, {\"date\": \"2024-09-04T15:23\", \"username\": \"PFrey1\"}, {\"date\": \"2024-09-14T13:21\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-30-2025\", \"time\": \"14:53:46\", \"value\": [{\"add\": \"422 Rossville Blvd\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-01-28\", \"eno\": \"7069786592\", \"lob\": \"On Exchange\", \"pno\": 7067280829, \"zip\": 30747, \"add2\": \"\", \"add3\": \"\", \"city\": \"Summerville\", \"gend\": 1, \"insh\": \"0008238340001\", \"mzip\": 30747, \"name\": \"Janice Watkins\", \"plan\": \"Alliant\", \"pphy\": \"Wayne Richey \", \"ppno\": \"706-734-7302\", \"race\": \"\", \"cliId\": \"\", \"email\": \"jjdon106@gmail.com\", \"ename\": \"Donald Watkins \", \"madd1\": \"422 Rossville Blvd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Summerville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"160 Central Ave \", \"pcpnpi\": \"\", \"pcpzip\": \"30753\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Trion \", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-12-31 01:30 PM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [true], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"12-31-2024\", \"time\": \"13:35:13\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-30-2025 14:53:46\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"12/20/2024 @ 09:49 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA Nykya Cox on 12/31 @ 130pm - doxy via iphone - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 12:11 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED THE CALL VIRTUAL MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"11/25/2024 @ 12:58 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 03:38 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/08/2024 @ 09:30 AM\"}, {\"date\": \"10/15/2024 @ 04:44 PM\", \"result\": 6, \"comment\": \"Member in the middle of eating and requested a call back - Call attempt to schedule an HRA.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/16/2024 @ 04:44 PM\"}, {\"date\": \"8/15/2024 @ 03:33 PM\", \"result\": 13, \"comment\": \"Called to Schedule Virtual HRA with Debbie caller disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/22/2024 @ 03:33 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0008238340001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0008238340001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0008238340001\", \"scheduleDate\": \"2024-12-30T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-15-2024 15:33:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"12-23-2024 11:52:53\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2025-01-07 19:11:45\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"2525e763-cd55-11ef-837c-d9efab6195d5\\\",\\\"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-12-31T13:30', '2024-12-31T00:00', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:22', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008238340001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0008238340001_Watkins, Janice_12312024.pdf\", \"ftp_upload_date\": \"2025-01-07 19:11:44\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Wayne Richey_0008238340001_12312024.pdf\"}', 'ACA_0008238340001_Watkins, Janice_12312024', NULL, 'PCP_, Wayne Richey_0008238340001_12312024', NULL, '[{\"date\": \"2024-12-31T18:56:31.081Z\", \"signature\": \"data:image/png;base64,[encoded data, 25452 characters]\"}]', '2024-12-31T13:56', 'Member_Summary_0008238340001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0008238340001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0008238340001.pdf\", \"member_ftp_upload_date\": \"2025-01-07 19:11:46\"}', NULL, NULL, NULL, NULL),
(5015, NULL, NULL, NULL, '0008238418001', '436178', '', '99038484', 'Sherry', 'Millholland', '', '{\"DOB\": 24731, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Dawsonville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-09-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 436178, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"110 Yellow road lane\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30534, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"110 Yellow road lane\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Millholland\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sherry\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ssmillholland@bellsouth.net\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7703551787, \"Member_Identification_Number\": \"0008238418001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-09T13:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-10T16:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-26T13:08\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-10-14T12:57\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-09T13:59\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T13:08\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-14T12:57\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T11:09\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": \"admin\"}], \"inProgress\": [{\"date\": \"2024-08-21T09:24\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-13T10:50\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"username\": null}, {\"date\": \"2024-09-04T15:23\", \"username\": \"PFrey1\"}, {\"date\": \"2024-09-14T13:21\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:23\", \"value\": [{\"add\": \"110 Yellow road lane\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-09-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7703551787, \"zip\": 30534, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0008238418001\", \"mzip\": 30534, \"name\": \"Sherry Millholland\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ssmillholland@bellsouth.net\", \"ename\": \"\", \"madd1\": \"110 Yellow road lane\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:23\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/31/2024 @ 02:31 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 02:08 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/14/2024 @ 12:57 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/15/2024 @ 12:57 PM\"}, {\"date\": \"10/10/2024 @ 04:51 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 04:51 PM\"}, {\"date\": \"8/26/2024 @ 01:08 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA with Delise Adams. Member requesting a call back tomorrow, she was going to a doctors appointment.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/2/2024 @ 01:08 PM\"}, {\"date\": \"8/9/2024 @ 01:59 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Jansen no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/16/2024 @ 01:59 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-09-2024 13:59:00\", \"schedulerId\": \"99038484\", \"schedulerLeadId\": \"99038484\"}]}', '{\"date\": \"11-11-2024 00:43:41\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:23', 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
(5016, NULL, NULL, NULL, '0008240913001', '435471', '', '21881792', 'Nancy', 'Witham', '', '{\"DOB\": 21881, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Clarkesville\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-11-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435471, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"579 Stonebank Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"579 Stonebank Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Witham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Nancy\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"nwitha005@gmail.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7067250041, \"Member_Identification_Number\": \"0008240913001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"11-22-2024 23:30:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-11-22 23:30:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-29T11:52\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-14T16:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-23T15:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-25T14:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-03T11:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-29T11:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-14T16:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-23T15:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-09-25T14:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-03T11:27\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-29T11:52\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:23\", \"value\": [{\"add\": \"579 Stonebank Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-11-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7067250041, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 1, \"insh\": \"0008240913001\", \"mzip\": 30523, \"name\": \"Nancy D Witham\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"nwitha005@gmail.com\", \"ename\": \"\", \"madd1\": \"579 Stonebank Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:23\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:23\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 11:52 AM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/3/2024 @ 11:27 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/4/2024 @ 11:27 AM\"}, {\"date\": \"9/25/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/26/2024 @ 02:11 PM\"}, {\"date\": \"9/23/2024 @ 03:21 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA with Delise--LVM-LLA \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/26/2024 @ 03:21 PM\"}, {\"date\": \"8/14/2024 @ 04:03 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/15/2024 @ 04:03 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 16:03:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"10-29-2024 11:52:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5017, NULL, NULL, NULL, '0008242094001', '435859', '', '21881792', 'Bryan', 'Mason', '', '{\"DOB\": 36031, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Eastanollee\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Eastanollee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1998-08-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 435859, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"76 Country View Dr\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30538, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"76 Country View Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30538, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Mason\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Bryan\", \"Member_Middle_name\": \"C\", \"Plan_Effective_Date\": 45474, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"masonbryan78@yahoo.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068946656, \"Member_Identification_Number\": \"0008242094001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:43\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-24T17:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:43\", \"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-10-24T17:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:52\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:40\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-13T16:48\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T10:44\", \"username\": null}, {\"date\": \"2024-08-21T11:09\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": null}, {\"date\": \"2024-09-11T09:23\", \"username\": \"admin\"}], \"inProgress\": [{\"date\": \"2024-08-21T09:24\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-13T10:50\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-08-21T10:17\", \"username\": null}, {\"date\": \"2024-09-04T15:23\", \"username\": \"PFrey1\"}, {\"date\": \"2024-09-14T13:21\", \"username\": null}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:24\", \"value\": [{\"add\": \"76 Country View Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1998-08-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068946656, \"zip\": 30538, \"add2\": \"\", \"add3\": \"\", \"city\": \"Eastanollee\", \"gend\": 0, \"insh\": \"0008242094001\", \"mzip\": 30538, \"name\": \"Bryan C Mason\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"masonbryan78@yahoo.com\", \"ename\": \"\", \"madd1\": \"76 Country View Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Eastanollee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:24\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/6/2024 @ 11:49 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/22/2024 @ 11:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/03/2024 @ 09:30 AM\"}, {\"date\": \"10/31/2024 @ 02:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/02/2024 @ 09:30 AM\"}, {\"date\": \"10/30/2024 @ 02:36 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/01/2024 @ 09:30 AM\"}, {\"date\": \"10/24/2024 @ 05:22 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/25/2024 @ 05:22 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"10-24-2024 17:22:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 00:43:21\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5018, NULL, NULL, NULL, '0008244007001', '433177', '', '21881792', 'Emily', 'Bramlett', '', '{\"DOB\": 35464, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Rockmart\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rockmart\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1997-02-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433177, \"Mailing_County\": \"POLK\", \"Member_Country\": \"POLK\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"948 Brock Rd\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30153, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"948 Brock Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30153, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Bramlett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Emily\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Emilybrumbelow44@icloud.com\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7705469418, \"Member_Identification_Number\": \"0008244007001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T01:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-12T16:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-29T13:43\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-29T17:23\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-08-12T16:21\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-29T17:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:09\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:24\", \"value\": [{\"add\": \"948 Brock Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1997-02-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7705469418, \"zip\": 30153, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rockmart\", \"gend\": 1, \"insh\": \"0008244007001\", \"mzip\": 30153, \"name\": \"Emily Bramlett\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Emilybrumbelow44@icloud.com\", \"ename\": \"\", \"madd1\": \"948 Brock Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rockmart\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:24\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/19/2024 @ 04:52 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED THE CALL MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 04:20 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/9/2024 @ 04:58 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/25/2024 @ 10:46 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 06:20 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/03/2024 @ 09:30 AM\"}, {\"date\": \"8/29/2024 @ 05:23 PM\", \"result\": 6, \"comment\": \"Returned requested call back to schedule Virtual HRA with Faith but member requested a call back for tomorrow 08/30/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/30/2024 @ 05:21 PM\"}, {\"date\": \"8/29/2024 @ 01:43 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Faith but member requested a call back today after 5:00PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/29/2024 @ 02:43 PM\"}, {\"date\": \"8/12/2024 @ 04:21 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/13/2024 @ 04:21 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-12-2024 16:21:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 01:09:16\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5019, NULL, NULL, NULL, '0008245132002', '431146', '', NULL, 'Allen', 'Merrell', '', '{\"DOB\": 24663, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Talking Rock\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Talking Rock\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-07-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 431146, \"Mailing_County\": \"PICKENS\", \"Member_Country\": \"PICKENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"93 Arbor Hills Pl\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30175, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"93 Arbor Hills Pl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30175, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Merrell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Allen\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45413, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0008245132002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:38:49\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:38:49\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:24\", \"value\": [{\"add\": \"93 Arbor Hills Pl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-07-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30175, \"add2\": \"\", \"add3\": \"\", \"city\": \"Talking Rock\", \"gend\": 0, \"insh\": \"0008245132002\", \"mzip\": 30175, \"name\": \"Allen Merrell\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"93 Arbor Hills Pl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Talking Rock\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:24\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:24\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:34:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5020, NULL, NULL, NULL, '0008245278001', '434636', '', NULL, 'Tammie', 'Ardister', '', '{\"DOB\": 28471, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Lexington\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lexington\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-12-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 434636, \"Mailing_County\": \"OGLETHORPE\", \"Member_Country\": \"OGLETHORPE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"760 Athens Rd Apt D2\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 30648, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"760 Athens Rd Apt D2\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30648, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"Ardister\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tammie\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45505, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tdickerson3577@gmail.com\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063714432, \"Member_Identification_Number\": \"0008245278001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-11-2024 00:00:26\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-09-11 00:00:26\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:25\", \"value\": [{\"add\": \"760 Athens Rd Apt D2\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-12-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063714432, \"zip\": 30648, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lexington\", \"gend\": 1, \"insh\": \"0008245278001\", \"mzip\": 30648, \"name\": \"Tammie Ardister\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"tdickerson3577@gmail.com\", \"ename\": \"\", \"madd1\": \"760 Athens Rd Apt D2\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lexington\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:25\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:34:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-08-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5021, NULL, NULL, NULL, '0008246510002', '433734', '', NULL, 'LILLIAN', 'JARRETT', '', '{\"DOB\": 21797, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"Pcp_City\": \"\", \"Pcp_Name\": \"\", \"Rank_All\": \"\", \"Pcp_State\": \"\", \"Member_City\": \"Baconton\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Baconton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-09-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 433734, \"Mailing_County\": \"MITCHELL\", \"Member_Country\": \"MITCHELL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3648 Magnolia Ln\", \"Member_Address2\": \"\", \"Member_Language\": \"\", \"Member_Zip_Code\": 31716, \"Pain_Assessment\": \"N\", \"Care_Coordinator\": \"\", \"Mailing_Address1\": \"3648 Magnolia Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31716, \"Member_Ethnicity\": \"\", \"Member_Last_name\": \"JARRETT\", \"Medication_Review\": \"N\", \"Member_first_name\": \"LILLIAN\", \"Member_Middle_name\": \"\", \"Plan_Effective_Date\": 45444, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Identification_Number\": \"0008246510002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-11-2024 00:00:26\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-09-11 00:00:26\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"08-07-2024\", \"time\": \"01:41:25\", \"value\": [{\"add\": \"3648 Magnolia Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-09-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 31716, \"add2\": \"\", \"add3\": \"\", \"city\": \"Baconton\", \"gend\": 1, \"insh\": \"0008246510002\", \"mzip\": 31716, \"name\": \"LILLIAN JARRETT\", \"plan\": \"Alliant\", \"pphy\": \"\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3648 Magnolia Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Baconton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpFlag\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-07-2024\", \"time\": \"01:41:25\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-07-2024 01:41:25\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"08-08-2024 00:34:25\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-08-31', NULL, NULL, NULL, NULL, NULL, '123456789', '07-08-2024 01:41:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
