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
(1780, NULL, NULL, NULL, '0006456850001', '387068', '', '26056802', 'donna', 'gowen', '', '{\"DOB\": 26786, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1376809665, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"LEXINGTON\", \"Pcp_Name\": \"Loretta Duggan\", \"PCP_Phone\": 7067438171, \"Pcp_State\": \"GA\", \"Member_City\": \"Rayle\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rayle\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-05-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"247 UNION POINT ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 387068, \"Mailing_County\": \"WILKES\", \"Member_Country\": \"WILKES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1167 bartram trace road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30660, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1167 bartram trace road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30660, \"Member_Last_name\": \"gowen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"donna\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064013574, \"Member_Identification_Number\": \"0006456850001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"10-15-2024 00:30:10\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-10-15 00:30:09\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-14T12:16\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-05-30T14:04\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-14T12:16\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T14:04\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:48\", \"value\": [{\"add\": \"1167 bartram trace road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-05-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064013574, \"zip\": 30660, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rayle\", \"gend\": 1, \"insh\": \"0006456850001\", \"mzip\": 30660, \"name\": \"donna gowen\", \"plan\": \"Alliant\", \"pphy\": \"Loretta Duggan\", \"ppno\": 7067438171, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1167 bartram trace road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rayle\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"247 UNION POINT ST\", \"pcpnpi\": 1376809665, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"LEXINGTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:56\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:56\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"5/30/2024 @ 02:04 PM\", \"result\": 6, \"comment\": \"Previous call notes - member not available until after 3 p.m. - will need a late evening call back. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 02:04 PM\"}, {\"date\": \"5/14/2024 @ 12:16 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA w/ Nykea Cox -  Call Back- Member is at work and wishes to be called after 3pm\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 04:16 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 12:16:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:31\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1717138257}', 1, NULL, NULL, NULL, NULL, '2024-09-30', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:48', 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
(1781, 57818338, 44829497, '62685179', '0006458000001', '383890', '', '21881792', 'Crystal', 'Emory', '', '{\"DOB\": 29948, \"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\": \"30180\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Villa Rica\", \"Pcp_Name\": \"Dr. Sharon Tuckett\", \"PCP_Phone\": \"7708123839\", \"Member_City\": \"Villa Rica\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Villa Rica\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-12-28\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"101 Quartz Dr Ste 201\", \"Screening_IHA\": \"No\", \"member_id_two\": 383890, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"7704563846\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"234 Taylor Ridge Trl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30180, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"234 Taylor Ridge Trl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30180, \"Member_Last_name\": \"Emory\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Crystal\", \"Member_Middle_name\": \"D\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"crystal_emory@yahoo.com\", \"Member_Suspect_Codes\": 88, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4042904399, \"Member_Identification_Number\": \"0006458000001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-02-2024 11:50:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-02 11:50:05\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T11:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T12:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-25T16:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-27T20:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-28T14:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-02T11:50\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-14T18:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-06-14T18:58\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T11:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T12:19\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-14T18:57\", \"reportStatus_date\": \"2024-06-14T18:58\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-28T14:24\", \"reportStatus_date\": \"2024-06-28T14:24\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-02T11:50\", \"reportStatus_date\": \"2024-07-02T11:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-02T11:50\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-14T18:57\", \"username\": null}, {\"date\": \"2024-06-14T18:58\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-25T07:46\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-06-26T09:42\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-25T16:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-25T16:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-27T11:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-27T11:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-27T14:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-27T14:38\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-28T14:24\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-27T20:55\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-28T14:24\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-26T21:41\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-27T11:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-27T13:54\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-27T14:38\", \"username\": \"FEnwefah\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-30-2024\", \"time\": \"11:48:53\", \"value\": [{\"add\": \"234 Taylor Ridge Trl\", \"age\": 42, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1981-12-28\", \"eno\": \"404 2904437\", \"lob\": \"On Exchange\", \"pno\": 4042904399, \"zip\": 30180, \"add2\": \"\", \"add3\": \"\", \"city\": \"Villa Rica\", \"gend\": 1, \"insh\": \"0006458000001\", \"mzip\": 30180, \"name\": \"Crystal D Emory\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Sharon Tuckett\", \"ppno\": \"7708123839\", \"cliId\": \"\", \"email\": \"crystal_emory@yahoo.com\", \"ename\": \"Michael Emory\", \"madd1\": \"234 Taylor Ridge Trl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Villa Rica\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"101 Quartz Dr Ste 201\", \"pcpnpi\": \"\", \"pcpzip\": \"30180\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Villa Rica\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7704563846\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"Pcp added\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-25-2024\", \"time\": \"07:46:51\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-30-2024 11:48:53\"}', NULL, NULL, '{\"memberId\": \"0006458000001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 27 Jun 2024 01:41:28 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD neuropsych PHQ9 score is 14 Depression is not reported as a diagnosis and it is not being treated.  Please add need for assistance with depression to the CM referral.  2.  PDC and PAT form reports major depression d/o treated with escitalopram. fatty liver and palpitations should they be added to the HRA?  3.  pain reports no vital signs reports pain 1/10 which is correct?  Thanks Judi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 27 Jun 2024 15:01:58 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 27 Jun 2024 17:54:39 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  PDC reports suicidal ideations .  Was this addressed at the HRA assessment visit?  Please add a comment in the PHQ9 section of the HRA regarding the MDD and suicidal ideations.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 27 Jun 2024 18:38:28 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Crystal Emory\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/25/2024 12:00 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/14/2024 @ 06:57 PM\", \"result\": 0, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: scheduled for 06/25/2024 @ 12pm - 1pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"5/6/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 12:19 PM\"}, {\"date\": \"4/29/2024 @ 11:59 AM\", \"result\": 3, \"comment\": \"LEFT VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 11:59 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006458000001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006458000001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006458000001\", \"scheduleDate\": \"2024-6-25T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 11:59:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-14-2024 18:57:59\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-07-02 11:50:03\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"bed99ef9-388a-11ef-a545-3d362bc9da01\\\",\\\"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-6-25T12:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:48', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006458000001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006458000001_Emory, Crystal_06252024.pdf\", \"ftp_upload_date\": \"2024-07-02 11:50:02\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, Dr. Sharon_0006458000001_06252024.pdf\"}', 'ACA_0006458000001_Emory, Crystal_06252024', NULL, 'PCP_, Dr. Sharon_0006458000001_06252024', NULL, '[{\"date\": \"2024-06-25T20:56:45.883Z\", \"signature\": \"data:image/png;base64,[encoded data, 23456 characters]\"}, {\"date\": \"2024-06-27T15:01:55.083Z\", \"signature\": \"data:image/png;base64,[encoded data, 23376 characters]\"}, {\"date\": \"2024-06-27T18:38:25.612Z\", \"signature\": \"data:image/png;base64,[encoded data, 23480 characters]\"}]', '2024-06-25T13:00', 'Member_Summary_0006458000001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006458000001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006458000001.pdf\", \"member_ftp_upload_date\": \"2024-07-02 11:50:04\"}', 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
(1782, NULL, NULL, NULL, '0006458044001', '385314', '', '2661185', 'Lisa', 'LaPree', '', '{\"DOB\": 22995, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1164683058, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"KATHRYN DUDAS\", \"PCP_Phone\": 7702199460, \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-12-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1856 THOMPSON BRIDGE RD STE 14\", \"Screening_IHA\": \"No\", \"member_id_two\": 385314, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"292 Hood Acres Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"292 Hood Acres Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"LaPree\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lisa\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"156, 161.2, 20, 21, 75\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068786295, \"Member_Identification_Number\": \"0006458044001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-29T13:46\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-10-10T12:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-29T13:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-04-25T19:01\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-05-16T12:49\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-22T14:36\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T19:01\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T12:49\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-22T14:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-10T12:26\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-29T13:46\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:49\", \"value\": [{\"add\": \"292 Hood Acres Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-12-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068786295, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0006458044001\", \"mzip\": 30528, \"name\": \"Lisa LaPree\", \"plan\": \"Alliant\", \"pphy\": \"KATHRYN DUDAS\", \"ppno\": 7702199460, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"292 Hood Acres Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1856 THOMPSON BRIDGE RD STE 14\", \"pcpnpi\": 1164683058, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:56\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:56\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 01:46 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/10/2024 @ 12:26 PM\", \"result\": 1, \"comment\": \"No sound on call. Call attempt to schedule an HRA. - Dead air \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 12:26 PM\"}, {\"date\": \"8/22/2024 @ 02:36 PM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA with Delise Adams Per previous in tool notes, member needs an appt after 5pm or a weekend appt. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/2/2024 @ 02:36 PM\"}, {\"date\": \"5/16/2024 @ 12:49 PM\", \"result\": 14, \"comment\": \"PREVIOUS CALL ON 4/25 - MEMBER WILL NEED A LATE EVENING APPT. OR WEEKEND APPT. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:48 PM\"}, {\"date\": \"4/25/2024 @ 07:01 PM\", \"result\": 14, \"comment\": \"Member works until 5:00pm. Will need a later appt time or a weekend. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 07:01 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:01:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"10-29-2024 13:46:44\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1783, NULL, NULL, NULL, '0006461184001', '402974', '', '26056802', 'ELLEN', 'KERRIGAN', '', '{\"DOB\": 23434, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"SANDERSVILLE\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"SANDERSVILLE\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-02-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 402974, \"Mailing_County\": \"WASHINGTON\", \"Member_Country\": \"WASHINGTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"291 JORDAN MEDDOW LANE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31082, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"291 JORDAN MEDDOW LANE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31082, \"Member_Last_name\": \"KERRIGAN\", \"Medication_Review\": \"N\", \"Member_first_name\": \"ELLEN\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"DAYSPRING386@AOL.COM\", \"Member_Suspect_Codes\": \"160, 48\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2394436938, \"Member_Identification_Number\": \"0006461184001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:54\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T12:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T13:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-29T16:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T13:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T13:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-29T16:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:54\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:49\", \"value\": [{\"add\": \"291 JORDAN MEDDOW LANE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-02-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2394436938, \"zip\": 31082, \"add2\": \"\", \"add3\": \"\", \"city\": \"SANDERSVILLE\", \"gend\": 1, \"insh\": \"0006461184001\", \"mzip\": 31082, \"name\": \"ELLEN KERRIGAN\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"DAYSPRING386@AOL.COM\", \"ename\": \"\", \"madd1\": \"291 JORDAN MEDDOW LANE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"SANDERSVILLE\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:56\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:56\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 03:12 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 03:08 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/  Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 05:59 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 02:12 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/29/2024 @ 04:11 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w HRA w/ Faith Enwefah or Deborah York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/6/2024 @ 04:11 PM\"}, {\"date\": \"6/10/2024 @ 10:30 AM\", \"result\": 3, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/16/2024 @ 10:30 AM\"}, {\"date\": \"5/17/2024 @ 01:15 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah -LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 01:15 PM\"}, {\"date\": \"5/14/2024 @ 12:18 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykea Cox - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/21/2024 @ 12:18 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 12:18:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-02-2024 18:54:51\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1784, NULL, NULL, NULL, '0006466169001', '410338', '', '26056802', 'Debbie', 'Bloodworth', '', '{\"DOB\": 22215, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Pineview\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Pineview\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-10-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410338, \"Mailing_County\": \"PULASKI\", \"Member_Country\": \"PULASKI\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1624 Pineview Pitts Hwy\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31071, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1624 Pineview Pitts Hwy\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31071, \"Member_Last_name\": \"Bloodworth\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Debbie\", \"Member_Middle_name\": \"Lynn\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"debbie3.bloodworth@gmail.com\", \"Member_Suspect_Codes\": \"11, 12\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2299383602, \"Member_Identification_Number\": \"0006466169001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-17T14:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-10T13:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T17:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T18:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-17T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T12:38\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-30T20:14\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-14T12:38\", \"reportStatus_date\": \"2024-05-14T12:38\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-30T20:14\", \"reportStatus_date\": \"2024-05-30T20:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T13:14\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T18:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:55\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T14:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T12:38\", \"username\": null}, {\"date\": \"2024-05-14T12:38\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-30T20:14\", \"username\": \"NCox\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:49\", \"value\": [{\"add\": \"1624 Pineview Pitts Hwy\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-10-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2299383602, \"zip\": 31071, \"add2\": \"\", \"add3\": \"\", \"city\": \"Pineview\", \"gend\": 1, \"insh\": \"0006466169001\", \"mzip\": 31071, \"name\": \"Debbie Lynn Bloodworth\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"debbie3.bloodworth@gmail.com\", \"ename\": \"\", \"madd1\": \"1624 Pineview Pitts Hwy\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Pineview\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:56\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:56\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-30T20:14\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 02:38 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"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/10/2024 @ 11:24 AM\", \"result\": 14, \"comment\": \"F2F CALL BACK-Member would like a callback at later time and date. attempt to scheduled virtual HRA W/ Deborah York tried to map Delise Adams too far  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:00 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 02:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 06:55 PM\"}, {\"date\": \"6/15/2024 @ 06:34 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 06:34 PM\"}, {\"date\": \"6/12/2024 @ 05:12 PM\", \"result\": 3, \"comment\": \"06/12/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/18/2024 @ 05:12 PM\"}, {\"date\": \"6/10/2024 @ 10:14 AM\", \"result\": 3, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/14/2024 @ 10:13 AM\"}, {\"date\": \"5/14/2024 @ 12:38 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/ Nykya Cox on 5/30 @ 330pm - doxy - cell phone \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 12:38:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"05-30-2024 20:14:31\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-17-2024 14:14:35\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1785, NULL, NULL, NULL, '0006466249001', '412744', '', NULL, 'Max', 'Nicholson', '', '{\"DOB\": 29690, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Chatsworth\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-04-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412744, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2220 Ball Ground Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30705, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2220 Ball Ground Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Last_name\": \"Nicholson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Max\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"nicholsonallen32@gmail.com\", \"Member_Suspect_Codes\": \"1, 130, 184, 188, 20, 21, 217, 22, 30\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065816926, \"Member_Identification_Number\": \"0006466249001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-01-2024 00:00:12\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-05-01 00:00:12\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:50\", \"value\": [{\"add\": \"2220 Ball Ground Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1981-04-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065816926, \"zip\": 30705, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 0, \"insh\": \"0006466249001\", \"mzip\": 30705, \"name\": \"Max A Nicholson\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"nicholsonallen32@gmail.com\", \"ename\": \"\", \"madd1\": \"2220 Ball Ground Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:31\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-04-08', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1786, NULL, NULL, NULL, '0006468880002', '415267', '', NULL, 'Ransler', 'Basham', '', '{\"DOB\": 23442, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Bethlehem\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bethlehem\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-03-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415267, \"Mailing_County\": \"WALTON\", \"Member_Country\": \"WALTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7330 Raleigh Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30620, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7330 Raleigh Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30620, \"Member_Last_name\": \"Basham\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ransler\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0006468880002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:50\", \"value\": [{\"add\": \"7330 Raleigh Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-03-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30620, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bethlehem\", \"gend\": 0, \"insh\": \"0006468880002\", \"mzip\": 30620, \"name\": \"Ransler Basham\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"7330 Raleigh Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bethlehem\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:32\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1787, NULL, NULL, NULL, '0006470671001', '392212', '', '26056802', 'Tony', 'Pisani', '', '{\"DOB\": 24159, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1447365762, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ATLANTA\", \"Pcp_Name\": \"CHRISTINE ZURAWSKI\", \"PCP_Phone\": 6784353040, \"Pcp_State\": \"GA\", \"Member_City\": \"Maysville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Maysville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-02-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"275 COLLIER RD NW STE 450\", \"Screening_IHA\": \"No\", \"member_id_two\": 392212, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1248 Unity Church Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30558, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1248 Unity Church Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30558, \"Member_Last_name\": \"Pisani\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tony\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tony_pisani@randdrealty.com\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062961132, \"Member_Identification_Number\": \"0006470671001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 7065407261}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-29T17:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-29T17:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-04-29T17:31\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-04-30T17:06\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-13T10:40\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-27T17:22\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-10T14:13\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T17:31\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-04-30T17:06\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T10:40\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T17:22\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-29T17:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-14T12:38\", \"username\": null}, {\"date\": \"2024-05-14T12:38\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-30T20:14\", \"username\": \"NCox\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:50\", \"value\": [{\"add\": \"1248 Unity Church Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": 7065407261, \"dob\": \"1966-02-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062961132, \"zip\": 30558, \"add2\": \"\", \"add3\": \"\", \"city\": \"Maysville\", \"gend\": 0, \"insh\": \"0006470671001\", \"mzip\": 30558, \"name\": \"Tony A Pisani\", \"plan\": \"Alliant\", \"pphy\": \"CHRISTINE ZURAWSKI\", \"ppno\": 6784353040, \"cliId\": \"\", \"email\": \"tony_pisani@randdrealty.com\", \"ename\": \"\", \"madd1\": \"1248 Unity Church Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Maysville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"275 COLLIER RD NW STE 450\", \"pcpnpi\": 1447365762, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ATLANTA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:30 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 02:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 01:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 05:48 PM\", \"result\": 3, \"comment\": \"07/29/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:13 PM\", \"result\": 10, \"comment\": \"07/10/2024 MB:: called for HRA-Nykya-Virtual: DISC\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 05:22 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 05:22 PM\"}, {\"date\": \"5/13/2024 @ 10:40 AM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/16/2024 @ 10:40 AM\"}, {\"date\": \"4/30/2024 @ 05:06 PM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 05:06 PM\"}, {\"date\": \"4/29/2024 @ 05:31 PM\", \"result\": 10, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/13/2024 @ 05:31 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 17:31:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-29-2024 17:48:01\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:50', 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
(1788, NULL, NULL, NULL, '0006472340001', '407201', '', '21881792', 'Gerardo', 'Carbajal Aguilar', '', '{\"DOB\": 32043, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1987-09-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407201, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3836 Celtic Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3836 Celtic Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"Carbajal Aguilar\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gerardo\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gerardo0923a@gmail.com\", \"Member_Suspect_Codes\": \"1, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6788221704, \"Member_Identification_Number\": \"0006472340001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-02T14:05\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T16:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-02T14:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-05-15T16:58\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:44\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T16:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T16:51\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-02T14:05\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:51\", \"value\": [{\"add\": \"3836 Celtic Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1987-09-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6788221704, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0006472340001\", \"mzip\": 30507, \"name\": \"Gerardo Carbajal Aguilar\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"gerardo0923a@gmail.com\", \"ename\": \"\", \"madd1\": \"3836 Celtic Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/31/2024 @ 02:05 PM\", \"result\": 13, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : caller disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:48 AM\", \"result\": 3, \"comment\": \"NO VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 02:05 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - No VM setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/10/2024 @ 04:51 PM\", \"result\": 3, \"comment\": \"LVM F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:15 PM\", \"result\": 3, \"comment\": \"No answer, no VM options. -MR\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/13/2024 @ 07:15 PM\"}, {\"date\": \"5/29/2024 @ 10:34 AM\", \"result\": 3, \"comment\": \"NO VM SETUP - Unable to leave a message. Call attempt to schedule F2F HRA.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 10:34 AM\"}, {\"date\": \"5/15/2024 @ 04:58 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 04:57 PM\"}, {\"date\": \"4/25/2024 @ 03:44 PM\", \"result\": 3, \"comment\": \"LS First call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:44 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 16:58:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"08-02-2024 14:05:20\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1789, NULL, NULL, NULL, '0006473896001', '420507', '', '21881792', 'Kelly', 'Ketchum', '', '{\"DOB\": 29089, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Roopville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Roopville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1979-08-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 420507, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"680 Milligan Creek Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30170, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"680 Milligan Creek Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30170, \"Member_Last_name\": \"Ketchum\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kelly\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"KRAZYKELLY1979@GMAIL.COM\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6786759784, \"Member_Identification_Number\": \"0006473896001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:29\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:47\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T09:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-09-06T13:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-19T14:10\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-06T16:06\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-09-04T11:43\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-06T16:06\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-19T14:10\", \"reportStatus_date\": \"2024-08-19T14:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 19, \"hraStatus_date\": \"2024-09-04T11:43\", \"reportStatus_date\": \"2024-09-06T13:53\"}, {\"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-16T00:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-04T11:43\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-19T14:10\", \"username\": null}, {\"date\": \"2024-08-19T14:10\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-03T15:15\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-03-2024\", \"time\": \"15:15:57\", \"value\": [{\"add\": \"680 Milligan Creek Rd\", \"age\": 45, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1979-08-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6786759784, \"zip\": 30170, \"add2\": \"\", \"add3\": \"\", \"city\": \"Roopville\", \"gend\": 1, \"insh\": \"0006473896001\", \"mzip\": 30170, \"name\": \"Kelly Ketchum\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"KRAZYKELLY1979@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"680 Milligan Creek Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Roopville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-03-2024\", \"time\": \"15:15:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-04-2024 11:42:21\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-09-04T11:43\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": null, \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/6/2024 @ 03:03 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 01:53 PM\", \"result\": 13, \"comment\": \"Member was scheduled for HRA with Connie 9/4/2024 was a no show called member not sure if member could not hear me member disconnected call-LLA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"9/13/2024 @ 01:52 PM\"}, {\"date\": \"8/19/2024 @ 02:10 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Connie Middleton on 9/4 at 11:30. Link was texted, member using phone. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"5/6/2024 @ 04:06 PM\", \"result\": 14, \"comment\": \"MEMBER REQUESTED A CALL BACK IN A MONTH TO ATTEMPT TO SCHEDULE THEN. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/6/2024 @ 04:06 PM\"}, {\"date\": \"4/30/2024 @ 09:24 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 09:24 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 09:24:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"09-04-2024 11:43:27\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-16-2024 00:47:57\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1790, NULL, NULL, NULL, '0006475010001', '410656', '', '26056802', 'Pamela', 'Chandler', '', '{\"DOB\": 23602, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Lavonia\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lavonia\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-08-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410656, \"Mailing_County\": \"FRANKLIN\", \"Member_Country\": \"FRANKLIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"487 Bill Miller Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30553, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"487 Bill Miller Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30553, \"Member_Last_name\": \"Chandler\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Pamela\", \"Member_Middle_name\": \"Gail\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"chandlerpam27@gmail.com\", \"Member_Suspect_Codes\": 160, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7067167198, \"Member_Identification_Number\": \"0006475010001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:29\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-05-14T13:05\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-17T13:19\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-20T18:49\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-29T16:14\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-09T13:25\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-29T17:50\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-20T18:49\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-29T16:14\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T13:25\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-29T17:50\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:41\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-04T11:43\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-19T14:10\", \"username\": null}, {\"date\": \"2024-08-19T14:10\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-03T15:15\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:51\", \"value\": [{\"add\": \"487 Bill Miller Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-08-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7067167198, \"zip\": 30553, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lavonia\", \"gend\": 1, \"insh\": \"0006475010001\", \"mzip\": 30553, \"name\": \"Pamela Gail Chandler\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"chandlerpam27@gmail.com\", \"ename\": \"\", \"madd1\": \"487 Bill Miller Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lavonia\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:18 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:16 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 09:54 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 05:50 PM\", \"result\": 10, \"comment\": \"07/29/2024 JC: called for HRA-Delise Adams-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 01:25 PM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/29/2024 @ 04:14 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w HRA w/ Faith Enwefah or Deborah York \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/6/2024 @ 04:14 PM\"}, {\"date\": \"5/20/2024 @ 06:49 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 06:49 PM\"}, {\"date\": \"5/17/2024 @ 01:19 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah  Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 01:19 PM\"}, {\"date\": \"5/14/2024 @ 01:05 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Nykea Cox - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/28/2024 @ 01:05 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 13:05:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-15-2024 05:41:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1791, NULL, NULL, NULL, '0006476281001', '408795', '', '26056802', 'Donald', 'Ward', '', '{\"DOB\": 22797, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Buford\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buford\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-05-31\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 408795, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5854 Waterfall Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30518, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5854 Waterfall Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30518, \"Member_Last_name\": \"Ward\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Donald\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dward5854@bellsouth.net\", \"Member_Suspect_Codes\": \"56, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7703562040, \"Member_Identification_Number\": \"0006476281001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T15:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-26T18:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T09:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T17:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T15:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-26T18:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T09:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T13:21\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T17:00\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T15:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-09-04T11:43\", \"username\": null}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-19T14:10\", \"username\": null}, {\"date\": \"2024-08-19T14:10\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-03T15:15\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:52\", \"value\": [{\"add\": \"5854 Waterfall Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-05-31\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7703562040, \"zip\": 30518, \"add2\": \"\", \"add3\": \"\", \"city\": \"Buford\", \"gend\": 0, \"insh\": \"0006476281001\", \"mzip\": 30518, \"name\": \"Donald Ward\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"dward5854@bellsouth.net\", \"ename\": \"\", \"madd1\": \"5854 Waterfall Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buford\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 04:00 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 02:59 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 07:17 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 06:44 PM\", \"result\": 3, \"comment\": \"SIXTH ATTEMPT Called to schedule HRA w/Debbie York LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 03:32 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton left Voicemail. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 05:00 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 05:00 PM\"}, {\"date\": \"6/3/2024 @ 01:21 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/10/2024 @ 01:21 PM\"}, {\"date\": \"5/13/2024 @ 09:39 AM\", \"result\": 1, \"comment\": \"DEAD AIR - NO SOUND ON CALL\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/16/2024 @ 09:39 AM\"}, {\"date\": \"4/26/2024 @ 06:28 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/10/2024 @ 06:28 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 18:28:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-11-2024 15:32:11\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1792, NULL, NULL, NULL, '0006481412001', '406069', '', '26056802', 'Johanna', 'Teague', '', '{\"DOB\": 27583, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Winder\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Winder\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-07-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406069, \"Mailing_County\": \"BARROW\", \"Member_Country\": \"BARROW\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"901 Dogwood Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30680, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"901 Dogwood Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30680, \"Member_Last_name\": \"Teague\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Johanna\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"joey7875@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6093051510, \"Member_Identification_Number\": \"0006481412001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":1,\"cancelText\":\"Provider Cancellation\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T12:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-10T12:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:57\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-04-29T14:07\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-04-30T12:24\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-29T14:07\", \"reportStatus_date\": \"2024-04-29T14:07\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-04-30T12:24\", \"reportStatus_date\": \"2024-04-30T12:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-10T12:40\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:45\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:57\", \"username\": null}, {\"date\": \"2024-04-25T16:57\", \"username\": null}, {\"date\": \"2024-04-29T14:07\", \"username\": null}, {\"date\": \"2024-04-29T14:07\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:24\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:52\", \"value\": [{\"add\": \"901 Dogwood Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-07-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6093051510, \"zip\": 30680, \"add2\": \"\", \"add3\": \"\", \"city\": \"Winder\", \"gend\": 1, \"insh\": \"0006481412001\", \"mzip\": 30680, \"name\": \"Johanna M Teague\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"joey7875@gmail.com\", \"ename\": \"\", \"madd1\": \"901 Dogwood Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Winder\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:24\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"Provider Cancellation\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/6/2024 @ 06:17 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 12:40 PM\", \"result\": 3, \"comment\": \"ATTEMPT TO RESCHEDULE - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/13/2024 @ 12:40 PM\"}, {\"date\": \"5/10/2024 @ 12:40 PM\", \"result\": 3, \"comment\": \"PREVIOUS ATTEMPT TO RESCHEDULE ON 5/8 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 12:39 PM\"}, {\"date\": \"5/10/2024 @ 12:39 PM\", \"result\": 3, \"comment\": \"previous attempt to reschedule on 5/9 - MR\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 01:39 PM\"}, {\"date\": \"4/29/2024 @ 02:07 PM\", \"result\": 12, \"comment\": \"Rescheduled F2F HRA w/ Sallie Key on 5/13 @ 130pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/25/2024 @ 04:57 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Sallie Key on 4/29 @ 130pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:57:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"04-30-2024 12:24:08\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"12-16-2024 00:49:47\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, 'In Person', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:52', 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
(1793, NULL, NULL, NULL, '0006487301001', '387541', '', '2661185', 'Craig', 'Jackson', '', '{\"DOB\": 22441, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1952398406, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Ayham Haddad\", \"PCP_Phone\": 7705320800, \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-06-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1080 DAWSONVILLE HWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 387541, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5036 Highway 75 S\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5036 Highway 75 S\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Jackson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Craig\", \"Member_Middle_name\": \"Newton\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"cnj1961.cj@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068090028, \"Member_Identification_Number\": \"0006487301001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T14:11\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T19:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T12:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T12:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T15:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T19:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T12:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T12:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T15:06\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:57\", \"username\": null}, {\"date\": \"2024-04-25T16:57\", \"username\": null}, {\"date\": \"2024-04-29T14:07\", \"username\": null}, {\"date\": \"2024-04-29T14:07\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:24\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:52\", \"value\": [{\"add\": \"5036 Highway 75 S\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-06-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068090028, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 0, \"insh\": \"0006487301001\", \"mzip\": 30528, \"name\": \"Craig Newton Jackson\", \"plan\": \"Alliant\", \"pphy\": \"Ayham Haddad\", \"ppno\": 7705320800, \"cliId\": \"\", \"email\": \"cnj1961.cj@gmail.com\", \"ename\": \"\", \"madd1\": \"5036 Highway 75 S\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1080 DAWSONVILLE HWY\", \"pcpnpi\": 1952398406, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 01:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 10:51 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 06:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 03:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 03:06 PM\"}, {\"date\": \"5/24/2024 @ 12:46 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 12:46 PM\"}, {\"date\": \"5/16/2024 @ 12:50 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/20/2024 @ 12:50 PM\"}, {\"date\": \"4/25/2024 @ 07:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 07:04 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:04:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-10-2024 14:11:58\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:52', 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
(1794, 2888643, 44829497, '96917241', '0006487999001', '408006', '', '26056802', 'Kerry', 'Smith', '', '{\"DOB\": 28550, \"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\": \"30143\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Jasper\", \"Pcp_Name\": \"Dr. Sanjay Serrao\", \"PCP_Phone\": \"706-299-2200\", \"Member_City\": \"Talking Rock\", \"Office_Name\": \"Piedmont Physicians of Mountainside - Internal Medicine\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Talking Rock\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-03-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"220 Jl White Dr Suite 150\", \"Screening_IHA\": \"No\", \"member_id_two\": 408006, \"Mailing_County\": \"PICKENS\", \"Member_Country\": \"PICKENS\", \"PCP_Fax_Number\": \"7062992214\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"10669 Highway 53 W\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30175, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"10669 Highway 53 W\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30175, \"Member_Last_name\": \"Smith\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kerry\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"beautiful.flowers.ks@gmail.com\", \"Member_Suspect_Codes\": \"130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6782341540, \"Member_Identification_Number\": \"0006487999001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:36:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:36:08\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-18T19:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-22T08:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-22T10:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-14T19:49\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-14T19:50\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-16T15:53\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-20T21:03\", \"reportStatus_date\": \"2024-05-18T19:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-22T10:39\", \"reportStatus_date\": \"2024-05-22T10:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:36\", \"reportStatus_date\": \"2024-05-31T14:36\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:36\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-14T19:49\", \"username\": null}, {\"date\": \"2024-05-14T19:50\", \"username\": null}, {\"date\": \"2024-05-16T15:53\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-18T14:05\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-05-19T11:45\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-18T14:08\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:11\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:13\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:16\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:20\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:23\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:25\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:29\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:32\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:35\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T14:37\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:34\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:37\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:40\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:43\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:47\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T19:18\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T19:19\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T19:19\", \"username\": \"NCox\"}, {\"date\": \"2024-05-20T21:03\", \"username\": \"NCox\"}, {\"date\": \"2024-05-21T21:30\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-22T10:39\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-22T08:14\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-22T10:39\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-20T08:07\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-21T10:31\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"13:35:20\", \"value\": [{\"add\": \"10669 Highway 53 W\", \"age\": 46, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-03-01\", \"eno\": \"6787735981\", \"lob\": \"On Exchange\", \"pno\": 6782341540, \"zip\": 30175, \"add2\": \"\", \"add3\": \"\", \"city\": \"Talking Rock\", \"gend\": 1, \"insh\": \"0006487999001\", \"mzip\": 30175, \"name\": \"Kerry Smith\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Sanjay Serrao\", \"ppno\": \"706-299-2200\", \"race\": \"\", \"cliId\": \"\", \"email\": \"beautiful.flowers.ks@gmail.com\", \"ename\": \"Susan Smith\", \"madd1\": \"10669 Highway 53 W\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Talking Rock\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"220 Jl White Dr Suite 150\", \"pcpnpi\": \"\", \"pcpzip\": \"30143\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"Jasper\", \"pcpname\": \"Piedmont Physicians of Mountainside - Internal Medicine\", \"program\": \"ACA\", \"evalDate\": \"2024-5-18 1:30 PM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"7062992214\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Christian \"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-16-2024\", \"time\": \"10:34:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 13:43:38\"}', NULL, NULL, '{\"memberId\": \"0006487999001\", \"clinician\": \"Nykya Cox\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Mon, 20 May 2024 12:07:18 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Nykya,\\nThank you for the assessment.\\n1. In the demographics, please add the marital status\\n2.  In the self assessment and social history section, the member does not have advanced care planning. Please make sure to discuss what advanced care planning is with members, \\nand check off if that is provided. Also, check off that item in the recommendation section.\\n3.  IN the preventative care section, breast cancer screening- the member had done in 2021. Please check off if you recommend she follow up with provider for this screening. I did \\nnotice she is BRCA -1 positive. We want to make sure any recommendations are selected so they carry over to the members plan of care that is created.\\n4.  In the medication list, please add the reason for each medication\\n- If education was provided regarding compliance, please check off \\n5.  The member is taking thyroid medication. Please add this condition to the assessment of diagnosis, endocrine for accurate coding.\\n6.  In the assessment of diagnosis, endocrine, Diabetes, the symptoms question is blank. Please select appopriate answer.\\n7.  In the vital signs section, recommendations- Please check off nutrition/wt mgmt, as this was discussed with the member\\n8. In the physical exam, cardiovascular, there are a few blank items. Please address.\\n9. I noticed the member 02 sat was only 92%. Did she mention if this was normal for her? Does she check this at home?\\n- in the assessment of dx, cardiovascular, peripheral edema was selected under sx- Did she have this on exam? or is the medication managing this?\\n10. Please consider a CM referral for nutrition/wt mgmt and 02 sat of 92.\\nIs she due to f/u with cardiology soon?\\nWe can meet to review this query later today.\\nThank you,\\nJessica\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 01:03:39 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 14:31:23 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"HI Nykya,\\nThe HRA looks good. A CM referral was sent for 02 sat and nutrition/wt mgmt. Can you add a comment to the summary about that?\\nAlso, the date/times at the end of the HRA reflect a 3 hour time frame. Please review and make any updates.\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 22 May 2024 01:30:32 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Kerry Smith\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/18/2024 01:30PM\", \"clinicianMailId\": \"n.cox@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/14/2024 @ 07:49 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Nykya Cox on 5/18 12pm - 330pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006487999001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0006487999001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0006487999001\", \"scheduleDate\": \"2024-5-18T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 19:49:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-16-2024 15:53:20\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:36:07\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"[{\\\"fax_id\\\":\\\"ed1a0e51-a3a7-424e-b058-3c2f6b16e41c\\\",\\\"destination_fax_number\\\":\\\"17062992214\\\"}]\", \"fax_transmission_response\": {\"response\": \"{\\\"transaction_id\\\":\\\"5df8423d-f5b2-11f0-88e4-51761c5240b0\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"UNAUTHORIZED\\\",\\\"developer_message\\\":\\\"Access token expired\\\",\\\"user_message\\\":\\\"Authentication token is expired.\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 401}}]', 'In Person', '2024-5-18T13:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:52', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006487999001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006487999001_Smith, Kerry_05182024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:36:06\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Serrao, Dr. Sanjay_0006487999001_05182024.pdf\"}', 'ACA_0006487999001_Smith, Kerry_05182024', NULL, 'PCP_Serrao, Dr. Sanjay_0006487999001_05182024', NULL, '[{\"date\": \"2024-05-18T23:19:56.318Z\", \"signature\": \"data:image/png;base64,[encoded data, 25516 characters]\"}, {\"date\": \"2024-05-21T01:03:38.742Z\", \"signature\": \"data:image/png;base64,[encoded data, 25496 characters]\"}, {\"date\": \"2024-05-22T01:30:31.511Z\", \"signature\": \"data:image/png;base64,[encoded data, 25492 characters]\"}]', '2024-05-18T15:00', 'Member_Summary_0006487999001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006487999001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006487999001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:36:08\"}', 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
(1795, NULL, NULL, NULL, '0006488191001', '415489', '', '21881792', 'Savannah', 'McConnell', '', '{\"DOB\": 35285, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1996-08-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 415489, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5022 Elrod Place\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30506, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5022 Elrod Place\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"McConnell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Savannah\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"savannahleigh0021@gmail.com\", \"Member_Suspect_Codes\": 211, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062638792, \"Member_Identification_Number\": \"0006488191001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-13-2024 00:00:11\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-07-13 00:00:11\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T17:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T17:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:13\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:53\", \"value\": [{\"add\": \"5022 Elrod Place\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1996-08-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062638792, \"zip\": 30506, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006488191001\", \"mzip\": 30506, \"name\": \"Savannah L McConnell\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"savannahleigh0021@gmail.com\", \"ename\": \"\", \"madd1\": \"5022 Elrod Place\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"7/10/2024 @ 02:13 PM\", \"result\": 3, \"comment\": \"07/10/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:20 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 07:19 PM\"}, {\"date\": \"5/29/2024 @ 10:36 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:36 AM\"}, {\"date\": \"5/15/2024 @ 05:00 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 05:00 PM\"}, {\"date\": \"4/25/2024 @ 03:43 PM\", \"result\": 3, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:43 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 17:00:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:32\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-06-25', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1796, NULL, NULL, NULL, '0006488309001', '420104', '', '26056802', 'Brittney', 'Wood', '', '{\"DOB\": 30277, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Lakemont\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lakemont\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1982-11-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 420104, \"Mailing_County\": \"RABUN\", \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"178 McKay Road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30552, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"178 McKay Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30552, \"Member_Last_name\": \"Wood\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Brittney\", \"Member_Middle_name\": \"G\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"woodbrit7@gmail.com\", \"Member_Suspect_Codes\": 82, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6782796452, \"Member_Identification_Number\": \"0006488309001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T18:10\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T13:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T13:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T18:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-29T16:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T18:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-20T18:55\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-29T16:17\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T18:10\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-04-25T16:57\", \"username\": null}, {\"date\": \"2024-04-25T16:57\", \"username\": null}, {\"date\": \"2024-04-29T14:07\", \"username\": null}, {\"date\": \"2024-04-29T14:07\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:24\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:53\", \"value\": [{\"add\": \"178 McKay Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1982-11-22\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782796452, \"zip\": 30552, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lakemont\", \"gend\": 1, \"insh\": \"0006488309001\", \"mzip\": 30552, \"name\": \"Brittney G Wood\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"woodbrit7@gmail.com\", \"ename\": \"\", \"madd1\": \"178 McKay Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lakemont\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:17 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:14 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 09:45 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 01:20 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 02:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 06:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 06:10 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/29/2024 @ 04:17 PM\", \"result\": 1, \"comment\": \"Called to schedule Virtual HRA w HRA w/ Faith Enwefah or Deborah York \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/6/2024 @ 04:17 PM\"}, {\"date\": \"5/20/2024 @ 06:55 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 06:55 PM\"}, {\"date\": \"5/17/2024 @ 01:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/20/2024 @ 01:21 PM\"}, {\"date\": \"5/14/2024 @ 01:08 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykea Cox - lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/21/2024 @ 01:08 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 13:08:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-03-2024 18:10:50\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:53', 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
(1797, 3285757, 44829497, '56716210', '0006489089002', '404467', '', '21881792', 'Jeffrey', 'Hall', '', '{\"DOB\": 26413, \"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\": \"31093\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Warner Robins\", \"Pcp_Name\": \"Robb Fulton\", \"PCP_Phone\": \"4787874266\", \"Member_City\": \"Warner Robins\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warner Robins\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-04-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"207 GREEN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 404467, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"4787874199\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"100 Wellington Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31093, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"100 Wellington Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31093, \"Member_Last_name\": \"Hall\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jeffrey\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 3865855582, \"Member_Identification_Number\": \"0006489089002\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-06-2024 11:48:45\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-06 11:48:45\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-12T17:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T18:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T13:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-31T13:32\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-02T20:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-03T13:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T11:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-29T16:26\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-17T14:21\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-07-15T15:46\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-15T18:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T13:25\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-29T16:26\", \"reportStatus_date\": \"2024-06-29T16:26\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-07-15T15:46\", \"reportStatus_date\": \"2024-07-15T15:46\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-17T14:21\", \"reportStatus_date\": \"2024-07-17T14:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-03T13:36\", \"reportStatus_date\": \"2024-08-03T13:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-06T11:48\", \"reportStatus_date\": \"2024-08-06T11:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-15T15:46\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-06T11:48\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-29T16:26\", \"username\": null}, {\"date\": \"2024-06-29T16:26\", \"username\": null}, {\"date\": \"2024-07-17T14:21\", \"username\": null}, {\"date\": \"2024-07-17T14:21\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-14T19:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-30T09:34\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-01T09:58\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-07-31T13:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-07-31T13:32\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-02T10:58\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-03T13:36\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-02T20:43\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-03T13:36\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-01T21:03\", \"username\": \"BClark\"}, {\"date\": \"2024-08-01T23:51\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-13-2024\", \"time\": \"12:13:57\", \"value\": [{\"add\": \"100 Wellington Way\", \"age\": 52, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-04-24\", \"eno\": \"4789550139\", \"lob\": \"On Exchange\", \"pno\": 3865855582, \"zip\": 31093, \"add2\": \"\", \"add3\": \"\", \"city\": \"Warner Robins\", \"gend\": 0, \"insh\": \"0006489089002\", \"mzip\": 31093, \"name\": \"Jeffrey Hall\", \"plan\": \"Alliant\", \"pphy\": \"Robb Fulton\", \"ppno\": \"4787874266\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Wendy Hall\", \"madd1\": \"100 Wellington Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Warner Robins\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"207 GREEN ST\", \"pcpnpi\": \"\", \"pcpzip\": \"31093\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Warner Robins\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-7-30 3:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"4787874199\", \"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\": \"07-14-2024\", \"time\": \"19:51:15\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-13-2024 12:13:57\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-07-15T15:46\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0006489089002\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Fri, 02 Aug 2024 01:03:50 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise, \\nThank you for your thorough assessment!\\n\\n1) Can you please correct the date of assessment, start to finish doesn\'t match up.\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 02 Aug 2024 03:51:31 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Can you also click \\\"self reported\\\" under vital signs for pain. Thank you\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 02 Aug 2024 14:58:36 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrections made. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Jeffrey Hall\", \"codingAnalyst\": \"\", \"dateOfService\": \"07/30/2024 03:05 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/17/2024 @ 02:21 PM\", \"result\": 0, \"comment\": \"scheduled with delise on 7/30 at 3pm sent link via text \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/29/2024 @ 04:26 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/ Faith Enwefah on 7/15 @ 10am - doxy - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"6/21/2024 @ 01:25 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 01:25 PM\"}, {\"date\": \"6/15/2024 @ 06:37 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 06:37 PM\"}, {\"date\": \"6/12/2024 @ 05:14 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 05:13 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006489089002\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006489089002\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006489089002\", \"scheduleDate\": \"2024-7-30T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-12-2024 17:14:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"07-15-2024 15:46:15\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-17-2024 14:21:58\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-08-06 11:48:43\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"5c2952e6-540b-11ef-b4e9-63e57947918e\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-7-30T15:00', '2024-12-31', '2024-07-30T15:05', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:53', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006489089002\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006489089002_Hall, Jeffrey_07302024.pdf\", \"ftp_upload_date\": \"2024-08-06 11:48:43\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Fulton, Robb_0006489089002_07302024.pdf\"}', 'ACA_0006489089002_Hall, Jeffrey_07302024', NULL, 'PCP_Fulton, Robb_0006489089002_07302024', NULL, '[{\"date\": \"2024-07-31T17:32:10.846Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}, {\"date\": \"2024-08-02T14:58:35.788Z\", \"signature\": \"data:image/png;base64,[encoded data, 23488 characters]\"}]', '2024-07-30T15:50', 'Member_Summary_0006489089002.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006489089002\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006489089002.pdf\", \"member_ftp_upload_date\": \"2024-08-06 11:48:44\"}', 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
(1798, NULL, NULL, NULL, '0006492485001', '295377', '', '2661185', 'Rosemarie', 'Mataro', '', '{\"DOB\": 30373, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1194162883, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLEVELAND\", \"Pcp_Name\": \"William Koeppel\", \"PCP_Phone\": \"\", \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Helen\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1983-02-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"17 WHITE ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 295377, \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"35 Dutchman Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 547\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30545, \"Member_Last_name\": \"Mataro\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rosemarie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"Rosiemataro@aol.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6782328420, \"Member_Identification_Number\": \"0006492485001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":1,\"cancelText\":\"Cancelled due to appointment time confusion.\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-20T11:26\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T19:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T12:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-24T12:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T18:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-18T18:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-24T14:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-01T14:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-20T11:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-26T17:10\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-01T15:30\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-07-02T11:15\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T19:05\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T12:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-24T12:48\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-01T15:30\", \"reportStatus_date\": \"2024-07-01T15:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2024-07-02T11:15\", \"reportStatus_date\": \"2024-07-03T18:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-18T18:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-24T14:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-01T14:28\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-20T11:26\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-07-01T15:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-02T01:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:15\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-02-2024\", \"time\": \"01:32:10\", \"value\": [{\"add\": \"35 Dutchman Way\", \"age\": 41, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1983-02-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782328420, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0006492485001\", \"mzip\": 30545, \"name\": \"Rosemarie Mataro\", \"plan\": \"Alliant\", \"pphy\": \"William Koeppel\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Rosiemataro@aol.com\", \"ename\": \"\", \"madd1\": \"PO Box 547\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Helen\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"17 WHITE ST\", \"pcpnpi\": 1194162883, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CLEVELAND\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-02-2024\", \"time\": \"01:32:10\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-02-2024 05:21:34\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:15\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TOdleAdmin\", \"hraStatus\": 3, \"cancelText\": \"Cancelled due to appointment time confusion.\", \"cancelStatus\": 1}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 02:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 01:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 11:26 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 02:28 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"8/15/2024 @ 02:27 PM\"}, {\"date\": \"7/24/2024 @ 02:31 PM\", \"result\": 3, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/31/2024 @ 02:31 PM\"}, {\"date\": \"7/18/2024 @ 06:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/19/2024 @ 06:21 PM\"}, {\"date\": \"7/3/2024 @ 06:12 PM\", \"result\": 3, \"comment\": \"07/03/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/17/2024 @ 06:12 PM\"}, {\"date\": \"6/26/2024 @ 05:10 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/Delise Adams for 7/2/24 @ 11:30am. The address is 273 Carrie Cox Dr, Helen GA. Rosemarie would like to meet at her job, she works at a Resort Club (Alpine Crest Resort Club Of Helen) and she said she will be able to provide a secure location. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}, {\"date\": \"5/24/2024 @ 12:48 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 12:48 PM\"}, {\"date\": \"5/16/2024 @ 12:53 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:53 PM\"}, {\"date\": \"4/25/2024 @ 07:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 07:05 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:05:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"07-02-2024 11:15:54\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-20-2024 11:26:29\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, 'In Person', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1799, NULL, NULL, NULL, '0006493844002', '411076', '', '26056802', 'SERGIO', 'ANDRADE', '', '{\"DOB\": 24993, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-06-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411076, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3450 Dennis Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30504, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3450 Dennis Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Last_name\": \"ANDRADE\", \"Medication_Review\": \"N\", \"Member_first_name\": \"SERGIO\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"6784500392\", \"Member_Identification_Number\": \"0006493844002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-13T17:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-06-21T14:15\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-27T15:25\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-02T13:56\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-10T13:34\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-19T13:23\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-13T17:01\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T14:15\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T15:25\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T13:56\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T13:34\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-19T13:23\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:51\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-07-01T15:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-02T01:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:15\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:31\", \"value\": [{\"add\": \"3450 Dennis Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-06-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6784500392, \"zip\": 30504, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0006493844002\", \"mzip\": 30504, \"name\": \"SERGIO ANDRADE\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"3450 Dennis Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-21-2024\", \"time\": \"01:15:31\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:31\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:07 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/19/2024 @ 01:23 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 01:34 PM\", \"result\": 10, \"comment\": \"Called to set up HRA with faith Enwefah line Disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 01:56 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 01:56 PM\"}, {\"date\": \"6/27/2024 @ 03:25 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 03:25 PM\"}, {\"date\": \"6/21/2024 @ 02:15 PM\", \"result\": 10, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 02:15 PM\"}, {\"date\": \"6/13/2024 @ 05:01 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/20/2024 @ 05:01 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-13-2024 17:01:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-11-2024 00:51:24\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1800, NULL, NULL, NULL, '0006494403001', '390541', '', '2661185', 'Melissa', 'Mercer', '', '{\"DOB\": 28197, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1396730222, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ARMUCHEE\", \"Pcp_Name\": \"ROBERT SMITH\", \"PCP_Phone\": 7622351000, \"Pcp_State\": \"GA\", \"Member_City\": \"Rome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-03-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"5470 MARTHA BERRY HWY NE\", \"Screening_IHA\": \"No\", \"member_id_two\": 390541, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"48 Chateau Dr SE Apt 6B\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30161, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"48 Chateau Dr SE Apt 6B\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30161, \"Member_Last_name\": \"Mercer\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melissa\", \"Member_Middle_name\": \"BROOKE\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mbm0805@aol.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064835739, \"Member_Identification_Number\": \"0006494403001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:30\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:30\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T17:53\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-22T19:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-07T14:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T19:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-29T17:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T17:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-22T19:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T14:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T19:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-29T17:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-07-01T15:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-02T01:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:15\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:54\", \"value\": [{\"add\": \"48 Chateau Dr SE Apt 6B\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-03-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064835739, \"zip\": 30161, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 1, \"insh\": \"0006494403001\", \"mzip\": 30161, \"name\": \"Melissa BROOKE Mercer\", \"plan\": \"Alliant\", \"pphy\": \"ROBERT SMITH\", \"ppno\": 7622351000, \"cliId\": \"\", \"email\": \"mbm0805@aol.com\", \"ename\": \"\", \"madd1\": \"48 Chateau Dr SE Apt 6B\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"5470 MARTHA BERRY HWY NE\", \"pcpnpi\": 1396730222, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ARMUCHEE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 03:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 02:33 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/  Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/7/2024 @ 12:42 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 01:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:53 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/29/2024 @ 05:11 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah or Deborah York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"7/6/2024 @ 05:11 PM\"}, {\"date\": \"6/11/2024 @ 04:43 PM\", \"result\": 3, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/24/2024 @ 04:43 PM\"}, {\"date\": \"5/7/2024 @ 02:31 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH E. 5/10.   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 02:30 PM\"}, {\"date\": \"4/22/2024 @ 07:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/23/2024 @ 07:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-22-2024 19:56:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-09-2024 17:53:42\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1801, NULL, NULL, NULL, '0006495185001', '412105', '', '21881792', 'Heidi', 'McFarland', '', '{\"DOB\": 26566, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-09-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412105, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1378 Lakeshore Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1378 Lakeshore Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"McFarland\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Heidi\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"hem42499@hotmail.com\", \"Member_Suspect_Codes\": \"11, 12\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4048499884, \"Member_Identification_Number\": \"0006495185001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-22T12:22\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T17:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T14:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-22T12:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T17:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:22\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:14\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T12:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-07-01T15:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-02T01:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:15\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:55\", \"value\": [{\"add\": \"1378 Lakeshore Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-09-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4048499884, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006495185001\", \"mzip\": 30501, \"name\": \"Heidi McFarland\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"hem42499@hotmail.com\", \"ename\": \"\", \"madd1\": \"1378 Lakeshore Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/11/2024 @ 11:07 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 01:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 12:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:50 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 02:10 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Connie Middleton. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 12:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 02:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:22 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 07:22 PM\"}, {\"date\": \"5/29/2024 @ 10:38 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:38 AM\"}, {\"date\": \"5/15/2024 @ 05:02 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 05:02 PM\"}, {\"date\": \"4/25/2024 @ 03:42 PM\", \"result\": 3, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:42 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 17:02:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-22-2024 12:22:19\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1802, NULL, NULL, NULL, '0006495993001', '406360', '', '21881792', 'TYLER', 'CLINE', '', '{\"DOB\": 33402, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1991-06-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406360, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3077 BURTON CIR\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3077 BURTON CIR\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"CLINE\", \"Medication_Review\": \"N\", \"Member_first_name\": \"TYLER\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"TYJ.CLINESR@GMAIL.COM\", \"Member_Suspect_Codes\": \"120, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9182193986, \"Member_Identification_Number\": \"0006495993001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:31\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:31\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-22T12:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T10:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T19:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T12:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-22T12:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T10:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-06T19:24\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T12:05\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T12:24\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-06-26T17:10\", \"username\": null}, {\"date\": \"2024-07-01T15:30\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-02T01:32\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-07-02T11:15\", \"username\": \"TOdleAdmin\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:00:55\", \"value\": [{\"add\": \"3077 BURTON CIR\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1991-06-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9182193986, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0006495993001\", \"mzip\": 30507, \"name\": \"TYLER CLINE\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"TYJ.CLINESR@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"3077 BURTON CIR\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:57\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:57\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 02:11 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:51 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 02:12 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Connie Middleton. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 12:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 12:05 PM\", \"result\": 3, \"comment\": \"LVM F2F WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 07:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 07:24 PM\"}, {\"date\": \"5/29/2024 @ 10:41 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:41 AM\"}, {\"date\": \"5/29/2024 @ 10:39 AM\", \"result\": 3, \"comment\": \"5/15  - SR - Left a voicemail\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 10:39 AM\"}, {\"date\": \"4/25/2024 @ 03:41 PM\", \"result\": 3, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/9/2024 @ 03:41 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-29-2024 10:39:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-22-2024 12:24:27\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:00:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
