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
(1430, 57818338, 44829497, '83326555', '0005789321001', '364802', '', '2661185', 'Megan', 'Guthmiller', '', '{\"DOB\": 34034, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1780625293, \"Pcp_Zip\": \"30528\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"CLEVELAND\", \"Pcp_Name\": \"DENISE WORKMAN\", \"PCP_Phone\": 7063488763, \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1993-03-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"55 CANTRELL RD STE 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 364802, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"7063481931\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"169 Leafview Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30528, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"169 Leafview Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Guthmiller\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Megan\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"guthmiller.megan@yahoo.com\", \"Member_Suspect_Codes\": \"21, 22, 84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7069694784, \"Member_Identification_Number\": \"0005789321001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-24-2024 10:49:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-09-24 10:49:01\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:34\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-22T18:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T18:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T12:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-23T16:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T14:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-09-18T10:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-22T17:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-22T22:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-09-24T10:49\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-20T10:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T18:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T12:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T16:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T14:55\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-22T18:45\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-20T10:45\", \"reportStatus_date\": \"2024-08-20T10:45\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-09-22T22:36\", \"reportStatus_date\": \"2024-09-22T22:36\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-09-24T10:49\", \"reportStatus_date\": \"2024-09-24T10:49\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-09-24T10:49\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-20T10:45\", \"username\": null}, {\"date\": \"2024-08-20T10:45\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-09-17T13:36\", \"username\": \"CMiddleton\"}], \"qaAssigned\": [{\"date\": \"2024-09-18T12:56\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-09-18T10:56\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-18T10:56\", \"username\": \"CMiddleton\"}, {\"date\": \"2024-09-20T11:17\", \"username\": \"CMiddleton\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-09-22T22:36\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-09-22T17:39\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-09-22T22:36\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-09-19T20:25\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"16:21:23\", \"value\": [{\"add\": \"169 Leafview Dr\", \"age\": 31, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1993-03-06\", \"eno\": \"605-366-7377\", \"lob\": \"On Exchange\", \"pno\": 7069694784, \"zip\": 30528, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0005789321001\", \"mzip\": 30528, \"name\": \"Megan Guthmiller\", \"plan\": \"Alliant\", \"pphy\": \"DENISE WORKMAN\", \"ppno\": 7063488763, \"race\": \"\", \"cliId\": \"\", \"email\": \"guthmiller.megan@yahoo.com\", \"ename\": \"Brenda Guthmiller\", \"madd1\": \"169 Leafview Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"55 CANTRELL RD STE 100\", \"pcpnpi\": 1780625293, \"pcpzip\": \"30528\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"CLEVELAND\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-09-18 10:00 AM\", \"evalName\": \"Connie Middleton, FNP\", \"pcpfaxno\": \"7063481931\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"09-17-2024\", \"time\": \"13:36:07\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-13-2025 16:21:23\"}', NULL, NULL, '{\"memberId\": \"0005789321001\", \"clinician\": \"Connie Middleton\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Fri, 20 Sep 2024 00:25:22 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  AOD Neuropsych med list reports epilepsy please add.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 20 Sep 2024 15:17:35 GMT\", \"name\": \"Connie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Patient stated that Lamotrigine was for her bipolar disorder only.  Updated.\"}, \"mailId\": \"\"}], \"memberName\": \"Megan Guthmiller\", \"codingAnalyst\": \"\", \"dateOfService\": \"09/18/2024 10:00 AM\", \"clinicianMailId\": \"c.middleton@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/20/2024 @ 10:45 AM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Connie Middleton on 9/18 at 10am, link texted, member using phone\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:54 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/22/2024 @ 06:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 04:04 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:34 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 02:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 02:55 PM\"}, {\"date\": \"5/23/2024 @ 04:58 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/30/2024 @ 04:58 PM\"}, {\"date\": \"5/16/2024 @ 12:39 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:39 PM\"}, {\"date\": \"4/25/2024 @ 06:37 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 06:37 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005789321001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"83326555\", \"memberId\": \"0005789321001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"83326555\", \"memberId\": \"0005789321001\", \"scheduleDate\": \"2024-9-18T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 18:37:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-20-2024 10:45:15\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 0, NULL, '[{\"date\": \"2024-09-24 10:48:59\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"220661e5-7a84-11ef-b7bd-6764f233caf2\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-9-18T10:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:01', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005789321001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005789321001_Guthmiller, Megan_09182024.pdf\", \"ftp_upload_date\": \"2024-09-24 10:48:59\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_WORKMAN, DENISE_0005789321001_09182024.pdf\"}', 'ACA_0005789321001_Guthmiller, Megan_09182024', NULL, 'PCP_WORKMAN, DENISE_0005789321001_09182024', NULL, '[{\"date\": \"2024-09-18T14:56:24.752Z\", \"signature\": \"data:image/png;base64,[encoded data, 24304 characters]\"}, {\"date\": \"2024-09-20T15:17:33.371Z\", \"signature\": \"data:image/png;base64,[encoded data, 24196 characters]\"}]', '2024-09-18T10:55', 'Member_Summary_0005789321001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005789321001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005789321001.pdf\", \"member_ftp_upload_date\": \"2024-09-24 10:49:00\"}', 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
(1431, NULL, NULL, NULL, '0005789981001', '259852', '', '21881792', 'Candy', 'Parton', '', '{\"DOB\": 33739, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1891087177, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATSWORTH\", \"Pcp_Name\": \"CYNTHIA THOMPSON HALL\", \"PCP_Phone\": 7066951820, \"Pcp_State\": \"GA\", \"Member_City\": \"RESACA\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Resaca\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-05-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"106 HOSPITAL DR STE 2\", \"Screening_IHA\": \"No\", \"member_id_two\": 259852, \"Mailing_County\": \"Whitfield\", \"Member_Country\": \"Whitfield\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5083 CLINE ROAD\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307350000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5083 Cline Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30735, \"Member_Last_name\": \"Parton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Candy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"candyparton29900@gmail.com\", \"Member_Suspect_Codes\": \"19, 21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062189111, \"Member_Identification_Number\": \"0005789981001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-11-06T14:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T14:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T13:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-06T14:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-08-23T11:30\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-14T12:56\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T14:27\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T12:56\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-23T11:30\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T13:57\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-06T14:41\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:01\", \"value\": [{\"add\": \"5083 CLINE ROAD\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-05-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062189111, \"zip\": 307350000, \"add2\": \"\", \"add3\": \"\", \"city\": \"RESACA\", \"gend\": 1, \"insh\": \"0005789981001\", \"mzip\": 30735, \"name\": \"Candy Parton\", \"plan\": \"Alliant\", \"pphy\": \"CYNTHIA THOMPSON HALL\", \"ppno\": 7066951820, \"cliId\": \"\", \"email\": \"candyparton29900@gmail.com\", \"ename\": \"\", \"madd1\": \"5083 Cline Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Resaca\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"106 HOSPITAL DR STE 2\", \"pcpnpi\": 1891087177, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATSWORTH\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 02:41 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 01:57 PM\", \"result\": 3, \"comment\": \"LVM to schedule with Connie Middleton for HRA-LLA \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 01:57 PM\"}, {\"date\": \"8/23/2024 @ 11:30 AM\", \"result\": 14, \"comment\": \"Called to Schedule Virtual HRA with Debbie but member requested a F2F call back for November\'s calendar\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"10/31/2024 @ 11:30 AM\"}, {\"date\": \"6/14/2024 @ 12:56 PM\", \"result\": 6, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: member req call back in a few months not needed at the moment \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"8/14/2024 @ 12:56 PM\"}, {\"date\": \"4/25/2024 @ 02:27 PM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/26/2024 @ 02:27 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 14:27:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-06-2024 14:41:43\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1432, NULL, NULL, NULL, '0005794474001', '363329', '', '2661185', 'Faye', 'McMillian', '', '{\"DOB\": 21888, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1205850435, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"THOMASVILLE\", \"Pcp_Name\": \"Johnny Belenchia\", \"PCP_Phone\": 2292282000, \"Pcp_State\": \"GA\", \"Member_City\": \"Bainbridge\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Bainbridge\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-12-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"2705 E PINETREE BLVD STE C\", \"Screening_IHA\": \"No\", \"member_id_two\": 363329, \"Mailing_County\": \"DECATUR\", \"Member_Country\": \"DECATUR\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"314 Mcmillan Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 39819, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"314 Mcmillan Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 39819, \"Member_Last_name\": \"McMillian\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Faye\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"strongwoman5484@gmail.com\", \"Member_Suspect_Codes\": \"130, 142, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294002948, \"Member_Identification_Number\": \"0005794474001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:03\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T16:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T11:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T15:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T16:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T16:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T15:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T16:15\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:03\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-11-11T11:37\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-10-30T09:46\", \"username\": null}, {\"date\": \"2024-10-30T09:46\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-08T01:15\", \"username\": \"DAdams\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:02\", \"value\": [{\"add\": \"314 Mcmillan Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-12-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294002948, \"zip\": 39819, \"add2\": \"\", \"add3\": \"\", \"city\": \"Bainbridge\", \"gend\": 1, \"insh\": \"0005794474001\", \"mzip\": 39819, \"name\": \"Faye McMillian\", \"plan\": \"Alliant\", \"pphy\": \"Johnny Belenchia\", \"ppno\": 2292282000, \"cliId\": \"\", \"email\": \"strongwoman5484@gmail.com\", \"ename\": \"\", \"madd1\": \"314 Mcmillan Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Bainbridge\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"2705 E PINETREE BLVD STE C\", \"pcpnpi\": 1205850435, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"THOMASVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 12:19 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 @ 11:40 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 06:57 PM\", \"result\": 3, \"comment\": \"07/16/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 04:15 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH  DEBBIE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 04:14 PM\"}, {\"date\": \"5/20/2024 @ 03:57 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 03:57 PM\"}, {\"date\": \"5/17/2024 @ 11:30 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 11:30 AM\"}, {\"date\": \"5/10/2024 @ 04:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 04:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 16:57:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:03:34\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1433, NULL, NULL, NULL, '0005794671001', '373802', '', '2661185', 'Shawn', 'Grace', '', '{\"DOB\": 32647, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1083937908, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MOULTRIE\", \"Pcp_Name\": \"GARY SWARTZENTRUBER\", \"PCP_Phone\": 2298919016, \"Pcp_State\": \"GA\", \"Member_City\": \"Moultrie\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Moultrie\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1989-05-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"8 LAUREL CT\", \"Screening_IHA\": \"No\", \"member_id_two\": 373802, \"Mailing_County\": \"COLQUITT\", \"Member_Country\": \"COLQUITT\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"813 6th St SE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31768, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"813 6th St SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31768, \"Member_Last_name\": \"Grace\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shawn\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"warsonicshawn@gmail.com\", \"Member_Suspect_Codes\": \"120, 142, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294290861, \"Member_Identification_Number\": \"0005794671001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-05-10T17:00\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}, {\"date\": \"2024-05-17T11:31\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}, {\"date\": \"2024-06-20T18:31\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T17:00\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-17T11:31\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T18:31\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:02\", \"value\": [{\"add\": \"813 6th St SE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1989-05-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294290861, \"zip\": 31768, \"add2\": \"\", \"add3\": \"\", \"city\": \"Moultrie\", \"gend\": 0, \"insh\": \"0005794671001\", \"mzip\": 31768, \"name\": \"Shawn Grace\", \"plan\": \"Alliant\", \"pphy\": \"GARY SWARTZENTRUBER\", \"ppno\": 2298919016, \"cliId\": \"\", \"email\": \"warsonicshawn@gmail.com\", \"ename\": \"\", \"madd1\": \"813 6th St SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Moultrie\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"8 LAUREL CT\", \"pcpnpi\": 1083937908, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MOULTRIE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"6/20/2024 @ 06:31 PM\", \"result\": 4, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"5/17/2024 @ 11:31 AM\", \"result\": 4, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Wrong Number\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 05:00 PM\", \"result\": 4, \"comment\": \"Person who answered informed me that I had the wrong number. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 17:00:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-20-2024 18:31:02\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1434, NULL, NULL, NULL, '0005796348002', '341958', '', NULL, 'Juan', 'Martinez', '', '{\"DOB\": 23479, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1760467013, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CUMMING\", \"Pcp_Name\": \"SOHEL MOMIN\", \"PCP_Phone\": 7708440877, \"Pcp_State\": \"GA\", \"Member_City\": \"gainsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"gainsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-04-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1400 NORTHSIDE FORSYTH DR STE 240\", \"Screening_IHA\": \"No\", \"member_id_two\": 341958, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2714 summer creek\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305070000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2714 summer creek\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"Martinez\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Juan\", \"Member_Middle_name\": \"P\", \"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\": \"0005796348002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:02\", \"value\": [{\"add\": \"2714 summer creek\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-04-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 305070000, \"add2\": \"\", \"add3\": \"\", \"city\": \"gainsville\", \"gend\": 0, \"insh\": \"0005796348002\", \"mzip\": 30507, \"name\": \"Juan P Martinez\", \"plan\": \"Alliant\", \"pphy\": \"SOHEL MOMIN\", \"ppno\": 7708440877, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"2714 summer creek\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"gainsville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1400 NORTHSIDE FORSYTH DR STE 240\", \"pcpnpi\": 1760467013, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CUMMING\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1435, NULL, NULL, NULL, '0005803015002', '371056', '', NULL, 'Larry', 'Cook', '', '{\"DOB\": 30663, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1983-12-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 371056, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"177 Quail Hollow Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30116, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"177 Quail Hollow Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30116, \"Member_Last_name\": \"Cook\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Larry\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0005803015002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:56\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:56\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:02\", \"value\": [{\"add\": \"177 Quail Hollow Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1983-12-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 30116, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 0, \"insh\": \"0005803015002\", \"mzip\": 30116, \"name\": \"Larry Cook\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"177 Quail Hollow Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1436, NULL, NULL, NULL, '0005804952001', '332730', '', '26056802', 'Jackie', 'Norton', '', '{\"DOB\": 23199, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1285620450, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DAHLONEGA\", \"Pcp_Name\": \"KIMBERLY KURTZ\", \"PCP_Phone\": 7068676005, \"Pcp_State\": \"GA\", \"Member_City\": \"Dahlonega\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-07-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1300 S CHESTATEE\", \"Screening_IHA\": \"No\", \"member_id_two\": 332730, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"157 Cane Mill Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305330000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"157 Cane Mill Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Last_name\": \"Norton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jackie\", \"Member_Middle_name\": \"Elizabeth\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"bizenorton@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9104650956, \"Member_Identification_Number\": \"0005804952001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 9103672809}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-16T14:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-24T18:46\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-03T13:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-14T15:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-16T14:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-21T19:13\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-10T13:36\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-03T13:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-14T15:11\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T19:13\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T13:36\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T14:41\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-07-24T18:46\", \"reportStatus_date\": \"2024-07-24T18:46\"}]', '{\"utc\": [{\"date\": \"2024-07-24T18:46\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:03\", \"value\": [{\"add\": \"157 Cane Mill Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": 9103672809, \"dob\": \"1963-07-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9104650956, \"zip\": 305330000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 1, \"insh\": \"0005804952001\", \"mzip\": 30533, \"name\": \"Jackie Elizabeth Norton\", \"plan\": \"Alliant\", \"pphy\": \"KIMBERLY KURTZ\", \"ppno\": 7068676005, \"cliId\": \"\", \"email\": \"bizenorton@gmail.com\", \"ename\": \"\", \"madd1\": \"157 Cane Mill Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1300 S CHESTATEE\", \"pcpnpi\": 1285620450, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DAHLONEGA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', '{\"utc\": [{\"date\": \"2024-07-24T18:46\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/31/2024 @ 11:00 AM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:14 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 11:58 AM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/24/2024 @ 06:46 PM\", \"result\": 6, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F: member req call back busy \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 02:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 01:36 PM\", \"result\": 6, \"comment\": \"Called to set up HRA with Faith Enwefah member requested a callback.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/12/2024 @ 01:36 PM\"}, {\"date\": \"5/21/2024 @ 07:13 PM\", \"result\": 6, \"comment\": \"Call back tomorrow, member was busy at a client\'s house. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/22/2024 @ 07:13 PM\"}, {\"date\": \"5/14/2024 @ 03:11 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 03:11 PM\"}, {\"date\": \"5/3/2024 @ 01:15 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/17/2024 @ 01:15 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-03-2024 13:15:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-16-2024 14:41:09\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1437, NULL, NULL, NULL, '0005809465004', '375273', '', NULL, 'Clarence', 'Pippin', '', '{\"DOB\": 39603, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1053578427, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ALBANY\", \"Pcp_Name\": \"Dennis Twedt\", \"PCP_Phone\": 2294327444, \"Pcp_State\": \"GA\", \"Member_City\": \"Albany\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Albany\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2008-06-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1909 ABERDEEN RD STE 106\", \"Screening_IHA\": \"No\", \"member_id_two\": 375273, \"Member_Country\": \"DOUGHERTY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4421 Lacosta Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31721, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 3330\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31706, \"Member_Last_name\": \"Pippin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Clarence\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 161.2, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0005809465004\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:03\", \"value\": [{\"add\": \"4421 Lacosta Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2008-06-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 31721, \"add2\": \"\", \"add3\": \"\", \"city\": \"Albany\", \"gend\": 0, \"insh\": \"0005809465004\", \"mzip\": 31706, \"name\": \"Clarence M Pippin\", \"plan\": \"Alliant\", \"pphy\": \"Dennis Twedt\", \"ppno\": 2294327444, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO Box 3330\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Albany\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1909 ABERDEEN RD STE 106\", \"pcpnpi\": 1053578427, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ALBANY\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:03', 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
(1438, NULL, NULL, NULL, '0005811634001', '358718', '', '2661185', 'Marvin', 'Wells', '', '{\"DOB\": 21964, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1487865754, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Sandersville\", \"Pcp_Name\": \"MARC RHODES\", \"PCP_Phone\": 7067218623, \"Pcp_State\": \"GA\", \"Member_City\": \"Davisboro\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Davisboro\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-02-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"610 Sparta Road\", \"Screening_IHA\": \"No\", \"member_id_two\": 358718, \"Member_Country\": \"WASHINGTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"61 Daniels Lane\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 310180000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 176\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31018, \"Member_Last_name\": \"Wells\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Marvin\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"loisdnls@yahoo.com\", \"Member_Suspect_Codes\": \"127, 130, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4783574726, \"Member_Identification_Number\": \"0005811634001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-12T16:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T16:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-16T18:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-30T10:56\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-06-08T13:06\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-05-10T17:33\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-19T11:02\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T17:33\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-30T10:56\", \"reportStatus_date\": \"2024-05-30T10:56\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-06-08T13:06\", \"reportStatus_date\": \"2024-06-08T13:06\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T16:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T18:57\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T11:02\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-06-08T13:06\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-30T10:56\", \"username\": null}, {\"date\": \"2024-05-30T10:56\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-08T10:27\", \"username\": \"NCox\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-08-2024\", \"time\": \"10:27:59\", \"value\": [{\"add\": \"61 Daniels Lane\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-02-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4783574726, \"zip\": 310180000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Davisboro\", \"gend\": 0, \"insh\": \"0005811634001\", \"mzip\": 31018, \"name\": \"Marvin Wells\", \"plan\": \"Alliant\", \"pphy\": \"MARC RHODES\", \"ppno\": 7067218623, \"cliId\": \"\", \"email\": \"loisdnls@yahoo.com\", \"ename\": \"\", \"madd1\": \"PO Box 176\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Davisboro\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"610 Sparta Road\", \"pcpnpi\": 1487865754, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"Sandersville\", \"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\": \"06-08-2024\", \"time\": \"10:27:59\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-08-2024 10:27:59\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-06-08T13:06\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 01:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 11:02 AM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED - Member busy at the time of call and requested a call back at a later date and time. Call attempt to schedule a virtual HRA w/ Nykya Cox. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/20/2024 @ 03:02 PM\"}, {\"date\": \"7/16/2024 @ 06:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/17/2024 @ 06:57 PM\"}, {\"date\": \"7/2/2024 @ 06:04 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/9/2024 @ 06:04 PM\"}, {\"date\": \"6/15/2024 @ 04:42 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 04:42 PM\"}, {\"date\": \"6/12/2024 @ 04:21 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting.  Call attempt to reschedule virtual HRA.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 04:21 PM\"}, {\"date\": \"5/30/2024 @ 10:56 AM\", \"result\": 0, \"comment\": \"SCHEDULED NYKYA COX ON 6/8 @ 10:30 - VIRTUAL - TEXTED LINK TO MEMBERS PHONE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 05:33 PM\", \"result\": 6, \"comment\": \"Call back monday so member can know his schedule -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/13/2024 @ 05:33 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 17:33:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"06-08-2024 13:06:29\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-11-2024 00:43:01\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1439, NULL, NULL, NULL, '0005815404001', '370650', '', '2661185', 'Abigail', 'Eaton', '', '{\"DOB\": 33641, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1780046052, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"David Holmes\", \"PCP_Phone\": 4787449683, \"Pcp_State\": \"GA\", \"Member_City\": \"Gray\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gray\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-02-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"682 HEMLOCK ST STE 300\", \"Screening_IHA\": \"No\", \"member_id_two\": 370650, \"Mailing_County\": \"JONES\", \"Member_Country\": \"JONES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"633 Little Creek Trl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31032, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"633 Little Creek Trl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31032, \"Member_Last_name\": \"Eaton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Abigail\", \"Member_Middle_name\": \"Lauren\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"abby.eaton43@gmail.com\", \"Member_Suspect_Codes\": \"209, 48, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7706569445, \"Member_Identification_Number\": \"0005815404001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-08T19:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-15T17:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-07-17T13:08\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-29T13:04\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T13:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-08T19:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T17:27\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-07-17T13:08\", \"reportStatus_date\": \"2024-07-17T13:08\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-07-17T13:08\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:04\", \"value\": [{\"add\": \"633 Little Creek Trl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-02-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7706569445, \"zip\": 31032, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gray\", \"gend\": 1, \"insh\": \"0005815404001\", \"mzip\": 31032, \"name\": \"Abigail Lauren Eaton\", \"plan\": \"Alliant\", \"pphy\": \"David Holmes\", \"ppno\": 4787449683, \"cliId\": \"\", \"email\": \"abby.eaton43@gmail.com\", \"ename\": \"\", \"madd1\": \"633 Little Creek Trl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gray\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"682 HEMLOCK ST STE 300\", \"pcpnpi\": 1780046052, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MACON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-07-17T13:08\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"7/17/2024 @ 01:08 PM\", \"result\": 9, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:27 PM\", \"result\": 3, \"comment\": \"07/15/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/29/2024 @ 05:26 PM\"}, {\"date\": \"7/11/2024 @ 01:12 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/12/2024 @ 01:12 PM\"}, {\"date\": \"7/8/2024 @ 07:09 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/9/2024 @ 07:09 PM\"}, {\"date\": \"4/29/2024 @ 01:04 PM\", \"result\": 6, \"comment\": \"Call back June 3rd. Abby is going to be traveling and would like a call back. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/3/2024 @ 01:01 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 13:04:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1440, NULL, NULL, NULL, '0005816252001', '346797', '', '2661185', 'David', 'Johnson', '', '{\"DOB\": 24442, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1477565810, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"MICHELE EDWARDS-PASCHAL\", \"PCP_Phone\": 4787830200, \"Pcp_State\": \"GA\", \"Member_City\": \"Hawkinsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hawkinsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-12-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"5437 BOWMAN RD STE 126\", \"Screening_IHA\": \"No\", \"member_id_two\": 346797, \"Mailing_County\": \"PULASKI\", \"Member_Country\": \"PULASKI\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"16 Lovers Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 310360000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"16 Lovers Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31036, \"Member_Last_name\": \"Johnson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"David\", \"Member_Middle_name\": \"James\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"djj400@gmail.com\", \"Member_Suspect_Codes\": \"13, 161.2, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4782904784, \"Member_Identification_Number\": \"0005816252001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-05-10T17:40\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-10T17:40\", \"reportStatus_date\": \"2024-05-10T17:40\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-10T17:40\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:04\", \"value\": [{\"add\": \"16 Lovers Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-12-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4782904784, \"zip\": 310360000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hawkinsville\", \"gend\": 0, \"insh\": \"0005816252001\", \"mzip\": 31036, \"name\": \"David James Johnson\", \"plan\": \"Alliant\", \"pphy\": \"MICHELE EDWARDS-PASCHAL\", \"ppno\": 4787830200, \"cliId\": \"\", \"email\": \"djj400@gmail.com\", \"ename\": \"\", \"madd1\": \"16 Lovers Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hawkinsville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"5437 BOWMAN RD STE 126\", \"pcpnpi\": 1477565810, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MACON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:39\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-10T17:40\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/10/2024 @ 05:40 PM\", \"result\": 9, \"comment\": \"Member refusal, not interested. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 17:40:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:15\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1441, NULL, NULL, NULL, '0005817055002', '382586', '', '543416', 'Donna', 'Ashburn', '', '{\"DOB\": 23907, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1154308740, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"RINGGOLD\", \"Pcp_Name\": \"CHRISTOPHER GREENE\", \"PCP_Phone\": 7068614990, \"Pcp_State\": \"GA\", \"Member_City\": \"Tunnel\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Tunnel\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-06-14\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4700 BATTLEFIELD PKWY STE 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 382586, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1148 Keys Road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30755, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1148 Keys Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30755, \"Member_Last_name\": \"Ashburn\", \"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\": \"7069656465\", \"Member_Identification_Number\": \"0005817055002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"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-06-14T17:44\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-18T17:08\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-20T18:34\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-27T16:18\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-09T17:37\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-23T15:13\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-01T17:31\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-14T17:44\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T18:34\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T16:18\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:37\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-23T15:13\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-01T17:31\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-06-08T13:06\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-30T10:56\", \"username\": null}, {\"date\": \"2024-05-30T10:56\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-08T10:27\", \"username\": \"NCox\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:28\", \"value\": [{\"add\": \"1148 Keys Road\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-06-14\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069656465, \"zip\": 30755, \"add2\": \"\", \"add3\": \"\", \"city\": \"Tunnel\", \"gend\": 1, \"insh\": \"0005817055002\", \"mzip\": 30755, \"name\": \"Donna Ashburn\", \"plan\": \"Alliant\", \"pphy\": \"CHRISTOPHER GREENE\", \"ppno\": 7068614990, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1148 Keys Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Tunnel\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4700 BATTLEFIELD PKWY STE 200\", \"pcpnpi\": 1154308740, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"RINGGOLD\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-21-2024\", \"time\": \"01:15:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:28\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"11/6/2024 @ 05:28 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 05:31 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"7/23/2024 @ 03:13 PM\", \"result\": 10, \"comment\": \"Members primary number no longer in service. Call to schedule a HRA w/ Nykya Cox.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:37 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/27/2024 @ 04:18 PM\", \"result\": 10, \"comment\": \"DISCONNECTED VIRTUAL VISIT WITH DEBBIE MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"7/1/2024 @ 04:18 PM\"}, {\"date\": \"6/20/2024 @ 06:34 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/27/2024 @ 06:34 PM\"}, {\"date\": \"6/18/2024 @ 05:08 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/19/2024 @ 05:08 PM\"}, {\"date\": \"6/14/2024 @ 05:44 PM\", \"result\": 10, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/17/2024 @ 05:43 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-14-2024 17:44:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"11-15-2024 05:44:30\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:04', 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
(1442, 57818338, 44829497, '96917241', '0005817993001', '364337', '', '16281210', 'Cynthia', 'Puckett', '', '{\"DOB\": 23081, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1285927491, \"Pcp_Zip\": \"30161\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"ROME\", \"Pcp_Name\": \"Amanda Reeves\", \"PCP_Phone\": \"7062953961\", \"Pcp_State\": \"GA\", \"Member_City\": \"Rome\", \"Office_Name\": \"Atrium Health Floyd Primary Care Internal & Family Medicine\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-03-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"123 THREE RIVERS DR NE\", \"Screening_IHA\": \"No\", \"member_id_two\": 364337, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"7062953979\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"157 Kellett Rd NE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30165, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"157 Kellett Rd NE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30165, \"Member_Last_name\": \"Puckett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Cynthia\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7066766857, \"Member_Identification_Number\": \"0005817993001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-16-2024 10:54:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-16 10:54:56\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T14:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T19:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-14T14:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-18T14:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-05T11:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-09T18:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-10T12:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-16T10:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-24T15:26\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-04T14:54\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T14:01\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-24T15:26\", \"reportStatus_date\": \"2024-06-24T15:26\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-07-08T20:49\", \"reportStatus_date\": \"2024-07-05T11:39\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-10T12:38\", \"reportStatus_date\": \"2024-07-10T12:38\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-16T10:54\", \"reportStatus_date\": \"2024-07-16T10:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-16T10:54\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-24T15:26\", \"username\": null}, {\"date\": \"2024-06-24T15:26\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-05T10:46\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-07-08T12:44\", \"username\": \"PFrey1\"}, {\"date\": \"2024-07-09T10:19\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-07-05T11:39\", \"username\": \"NCox\"}, {\"date\": \"2024-07-05T11:39\", \"username\": \"NCox\"}, {\"date\": \"2024-07-08T20:48\", \"username\": \"CHembrick2\"}, {\"date\": \"2024-07-09T10:18\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-10T12:38\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-09T18:07\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-10T12:38\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-07-08T20:49\", \"username\": \"CHembrick2\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-10-2024\", \"time\": \"16:40:30\", \"value\": [{\"add\": \"157 Kellett Rd NE\", \"age\": 61, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-03-11\", \"eno\": \"7062954744\", \"lob\": \"On Exchange\", \"pno\": 7066766857, \"zip\": 30165, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 1, \"insh\": \"0005817993001\", \"mzip\": 30165, \"name\": \"Cynthia Puckett\", \"plan\": \"Alliant\", \"pphy\": \"Amanda Reeves\", \"ppno\": \"7062953961\", \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Buddy Puckett\", \"madd1\": \"157 Kellett Rd NE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"123 THREE RIVERS DR NE\", \"pcpnpi\": 1285927491, \"pcpzip\": \"30161\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"ROME\", \"pcpname\": \"Atrium Health Floyd Primary Care Internal & Family Medicine\", \"program\": \"ACA\", \"evalDate\": \"2024-07-05 10:30 AM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"7062953979\", \"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\": [[\"Baptist\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-05-2024\", \"time\": \"10:46:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-10-2024 16:40:30\"}', NULL, NULL, '{\"memberId\": \"0005817993001\", \"clinician\": \"Nykya Cox\", \"qaAnalyst\": \"Candace Hembrick\", \"queryData\": [{\"date\": \"Tue, 09 Jul 2024 00:49:56 GMT\", \"name\": \"Candace \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Nykya,\\nThank you so much for this great assessment.  I have a few areas that need to be addressed before I am able to send this to coding. \\nMedications\\n- For the Lancets - dose/units \\\"N/A\\\"\\n- In the OTC section for Tylenol under \\\"date\\\" please put the date of assessment and under \\\"dose/unit\\\" you can put 1-2 tablets or unknown\\nAOD\\n- Under Endocrine please add the diagnosis \\\"Hypothyroidism\\\" since the member is taking Levothyroxine\\nExam Review\\n- In the Musculoskeletal section  under ROM was the member\'s foot decreased ROM in their right foot or is everything normal.  Please comment. \\n- In the Neurologic section please comment in \\\"indicate cranial nerve deficit found\\\" if none please put \\\"none\\\"\\n     - Please make a selection for coordination. \\nHome Safety & Personal Goals \\n- Under member gait you put normal but in the Exam Review section under \\\"member gait\\\" you  notated \\\"normal\\\" could you please clarify which one so they match?  \\nIf you have any questions please let me know and I will be happy to help.  Thank you so much for all that you do for our members.\\n\\nCandace Hembrick, FNP-C\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 09 Jul 2024 14:18:52 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Cynthia Puckett\", \"codingAnalyst\": \"\", \"dateOfService\": \"07/05/2024 10:30 AM\", \"clinicianMailId\": \"n.cox@focuscares.com\", \"qaAnalystMailId\": \"candacehembrick@gmail.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/24/2024 @ 03:26 PM\", \"result\": 0, \"comment\": \"06/24/2024 JC: called for HRA-Nykya Cox-Virtual: scheduled for 07/05/2024 @ 10:30am - 11:30am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/18/2024 @ 02:57 PM\", \"result\": 3, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/2/2024 @ 02:57 PM\"}, {\"date\": \"6/14/2024 @ 02:01 PM\", \"result\": 3, \"comment\": \"06/14/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 02:01 PM\"}, {\"date\": \"6/11/2024 @ 04:26 PM\", \"result\": 13, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: caller hung up, \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/24/2024 @ 04:26 PM\"}, {\"date\": \"6/4/2024 @ 02:54 PM\", \"result\": 3, \"comment\": \"called and left a VM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Cathy Reyes\", \"callbackDate\": \"6/5/2024 @ 02:54 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005817993001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0005817993001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0005817993001\", \"scheduleDate\": \"2024-7-5T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 14:54:00\", \"schedulerId\": \"16281210\", \"schedulerLeadId\": \"16281210\"}]}', '{\"date\": \"06-24-2024 15:26:18\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-07-16 10:54:55\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"5ce171af-4383-11ef-a293-8b51ef504b49\\\",\\\"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-5T10:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:05', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005817993001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005817993001_Puckett, Cynthia_07052024.pdf\", \"ftp_upload_date\": \"2024-07-16 10:54:54\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Reeves, Amanda_0005817993001_07052024.pdf\"}', 'ACA_0005817993001_Puckett, Cynthia_07052024', NULL, 'PCP_Reeves, Amanda_0005817993001_07052024', NULL, '[{\"date\": \"2024-07-05T15:39:50.334Z\", \"signature\": \"data:image/png;base64,[encoded data, 25488 characters]\"}, {\"date\": \"2024-07-09T14:18:52.152Z\", \"signature\": \"data:image/png;base64,[encoded data, 25532 characters]\"}]', '2024-07-05T11:39', 'Member_Summary_0005817993001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005817993001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005817993001.pdf\", \"member_ftp_upload_date\": \"2024-07-16 10:54:55\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(1443, NULL, NULL, NULL, '0005819243001', '234343', '', '21881792', 'Shelia', 'Jenkins', '', '{\"DOB\": 24970, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1063567675, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"KENT MILLER\", \"PCP_Phone\": 7705324477, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-05-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"303 JESSE JEWELL PKWY SE STE 230\", \"Screening_IHA\": \"No\", \"member_id_two\": 234343, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5377 Elrod Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305060000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5377 Elrod Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30506, \"Member_Last_name\": \"Jenkins\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shelia\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Jenkinsshelia1968@gmail.com\", \"Member_Suspect_Codes\": \"160, 161.2, 21, 28, 30, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6787767016, \"Member_Identification_Number\": \"0005819243001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:57\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-29T16:22\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T17:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T15:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T09:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T13:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-29T16:22\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-07-10T13:37\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T17:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T15:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T09:27\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T13:59\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T13:37\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-29T16:22\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-06-08T13:06\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-05-30T10:56\", \"username\": null}, {\"date\": \"2024-05-30T10:56\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-08T10:27\", \"username\": \"NCox\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:05\", \"value\": [{\"add\": \"5377 Elrod Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-05-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787767016, \"zip\": 305060000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0005819243001\", \"mzip\": 30506, \"name\": \"Shelia Jenkins\", \"plan\": \"Alliant\", \"pphy\": \"KENT MILLER\", \"ppno\": 7705324477, \"cliId\": \"\", \"email\": \"Jenkinsshelia1968@gmail.com\", \"ename\": \"\", \"madd1\": \"5377 Elrod Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"303 JESSE JEWELL PKWY SE STE 230\", \"pcpnpi\": 1063567675, \"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:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 01:15 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 10:04 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 @ 01:39 PM\", \"result\": 3, \"comment\": \"  Called to set up HRA with Faith Enwefah Left voicemail. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 04:22 PM\", \"result\": 3, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm or w/NP Faith Enwefah lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 01:37 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/10/2024 @ 01:59 PM\", \"result\": 3, \"comment\": \"LVM F2F  VISIT WITH DELISE 06/13 MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/13/2024 @ 01:59 PM\"}, {\"date\": \"5/29/2024 @ 09:27 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 @ 09:27 AM\"}, {\"date\": \"5/15/2024 @ 03:26 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 03:26 PM\"}, {\"date\": \"4/25/2024 @ 05:17 PM\", \"result\": 3, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/10/2024 @ 05:16 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 15:26:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-29-2024 16:22:38\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1444, NULL, NULL, NULL, '0005820697001', '365871', '', '2661185', 'Rico', 'Griffin', '', '{\"DOB\": 30714, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1306816467, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Lajos Toth\", \"PCP_Phone\": 7705334770, \"Pcp_State\": \"GA\", \"Member_City\": \"Lula\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lula\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-02-02\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 JESSE JEWELL PKWY SE STE 300\", \"Screening_IHA\": \"No\", \"member_id_two\": 365871, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5566 Hood St\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": 30554, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5566 Hood St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30554, \"Member_Last_name\": \"Griffin\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rico\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"VGPANNELL89@yahoo.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"5402660633\", \"Member_Identification_Number\": \"0005820697001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:57\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:44\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-29T16:38\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-08-05T07:12\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-05-01T17:52\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-05-14T12:10\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-10T13:41\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-01T17:52\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-14T12:10\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T13:41\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-29T16:38\", \"reportStatus_date\": \"2024-07-29T16:38\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-08-05T07:12\", \"reportStatus_date\": \"2024-08-05T07:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:44\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-05T07:12\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-29T16:38\", \"username\": null}, {\"date\": \"2024-07-29T16:38\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-02T07:26\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-29-2024\", \"time\": \"17:38:06\", \"value\": [{\"add\": \"5566 Hood St\", \"age\": 40, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1984-02-02\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"5402660633\", \"zip\": 30554, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lula\", \"gend\": 0, \"insh\": \"0005820697001\", \"mzip\": 30554, \"name\": \"Rico Griffin\", \"plan\": \"Alliant\", \"pphy\": \"Lajos Toth\", \"ppno\": 7705334770, \"cliId\": \"\", \"email\": \"VGPANNELL89@yahoo.com\", \"ename\": \"\", \"madd1\": \"5566 Hood St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lula\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 JESSE JEWELL PKWY SE STE 300\", \"pcpnpi\": 1306816467, \"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\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-29-2024\", \"time\": \"17:38:06\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-02-2024 13:08:37\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-08-05T07:12\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 02:00 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 01:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 10:46 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 04:38 PM\", \"result\": 0, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm or w/NP Faith Enwefah member scheduled for 08/02 @11:30 am with Faith Enwefah.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 01:41 PM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED - Member not available. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/11/2024 @ 01:41 PM\"}, {\"date\": \"5/14/2024 @ 12:10 PM\", \"result\": 6, \"comment\": \"CALLER UPDATED PHONE NUMBER - CALL BACK AT A LATER DATE AND TIME.  5402046594 - NOT MEMBERS PRIMARY NUMBER. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:10 PM\"}, {\"date\": \"5/1/2024 @ 05:52 PM\", \"result\": 6, \"comment\": \"Call back, member not home. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/2/2024 @ 05:52 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-01-2024 17:52:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"08-05-2024 07:12:31\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"12-16-2024 00:44:19\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1445, NULL, NULL, NULL, '0005820921001', '375502', '', '21881792', 'Stacy', 'Ramey', '', '{\"DOB\": 30260, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1942287453, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"RINGGOLD\", \"Pcp_Name\": \"David Denman\", \"PCP_Phone\": 7068614990, \"Pcp_State\": \"GA\", \"Member_City\": \"Ft Oglethorpe\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Ft Oglethorpe\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1982-11-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4700 BATTLEFIELD PKWY STE 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 375502, \"Mailing_County\": \"CATOOSA\", \"Member_Country\": \"CATOOSA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"12 Talley Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30742, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"12 Talley Cir\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30742, \"Member_Last_name\": \"Ramey\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stacy\", \"Member_Middle_name\": \"Nicole\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"stacyalady@comcast.net\", \"Member_Suspect_Codes\": \"161.2, 21, 30\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4234888548, \"Member_Identification_Number\": \"0005820921001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-30T11:09\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-04-30T11:09\", \"reportStatus_date\": \"2024-04-30T11:09\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-30T11:09\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:06\", \"value\": [{\"add\": \"12 Talley Cir\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1982-11-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4234888548, \"zip\": 30742, \"add2\": \"\", \"add3\": \"\", \"city\": \"Ft Oglethorpe\", \"gend\": 1, \"insh\": \"0005820921001\", \"mzip\": 30742, \"name\": \"Stacy Nicole Ramey\", \"plan\": \"Alliant\", \"pphy\": \"David Denman\", \"ppno\": 7068614990, \"cliId\": \"\", \"email\": \"stacyalady@comcast.net\", \"ename\": \"\", \"madd1\": \"12 Talley Cir\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Ft Oglethorpe\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4700 BATTLEFIELD PKWY STE 200\", \"pcpnpi\": 1942287453, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"RINGGOLD\", \"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:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-30T11:09\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/30/2024 @ 11:09 AM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IHA IN 2024.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 11:09:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:16\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1446, NULL, NULL, NULL, '0005821276001', '385918', '', '21881792', 'Abbey', 'Flood', '', '{\"DOB\": 35492, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1619952686, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BLUE RIDGE\", \"Pcp_Name\": \"Magdalena Kowalski\", \"PCP_Phone\": 7063782235, \"Pcp_State\": \"GA\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1997-03-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"101 RIVERSTONE VISTA SUITE 215\", \"Screening_IHA\": \"No\", \"member_id_two\": 385918, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2289 Bowers Rd NE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30721, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2289 Bowers Rd NE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30721, \"Member_Last_name\": \"Flood\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Abbey\", \"Member_Middle_name\": \"Michala\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"abbeyo2015@gmail.com\", \"Member_Suspect_Codes\": \"120, 75\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068476517, \"Member_Identification_Number\": \"0005821276001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-24T09:32\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-04-24T09:32\", \"reportStatus_date\": \"2024-04-24T09:32\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-24T09:32\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:06\", \"value\": [{\"add\": \"2289 Bowers Rd NE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1997-03-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068476517, \"zip\": 30721, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 1, \"insh\": \"0005821276001\", \"mzip\": 30721, \"name\": \"Abbey Michala Flood\", \"plan\": \"Alliant\", \"pphy\": \"Magdalena Kowalski\", \"ppno\": 7063782235, \"cliId\": \"\", \"email\": \"abbeyo2015@gmail.com\", \"ename\": \"\", \"madd1\": \"2289 Bowers Rd NE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"101 RIVERSTONE VISTA SUITE 215\", \"pcpnpi\": 1619952686, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BLUE RIDGE\", \"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:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-24T09:32\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/24/2024 @ 09:32 AM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER FOR HRA IN 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 09:32:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:16\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1447, NULL, NULL, NULL, '0005822261001', '380478', '', '2661185', 'Terica', 'Callaway', '', '{\"DOB\": 33723, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1669572970, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"THOMASVILLE\", \"Pcp_Name\": \"Michael Schmidt\", \"PCP_Phone\": 2294164421, \"Pcp_State\": \"GA\", \"Member_City\": \"Blakely\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Blakely\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1992-04-29\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"454 SMITH AVE\", \"Screening_IHA\": \"No\", \"member_id_two\": 380478, \"Mailing_County\": \"EARLY\", \"Member_Country\": \"EARLY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"18420 E South Blvd Lot 27\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 39823, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"18420 E South Blvd Lot 27\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 39823, \"Member_Last_name\": \"Callaway\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Terica\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"teri.callaway26@outlook.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2292215866, \"Member_Identification_Number\": \"0005822261001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T17:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T11:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T16:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-28T18:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:07\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-08-17T13:31\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T17:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T16:01\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-28T18:37\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:07\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-17T13:31\", \"reportStatus_date\": \"2024-08-17T13:31\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-08-17T13:31\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:06\", \"value\": [{\"add\": \"18420 E South Blvd Lot 27\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1992-04-29\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2292215866, \"zip\": 39823, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blakely\", \"gend\": 1, \"insh\": \"0005822261001\", \"mzip\": 39823, \"name\": \"Terica L Callaway\", \"plan\": \"Alliant\", \"pphy\": \"Michael Schmidt\", \"ppno\": 2294164421, \"cliId\": \"\", \"email\": \"teri.callaway26@outlook.com\", \"ename\": \"\", \"madd1\": \"18420 E South Blvd Lot 27\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Blakely\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"454 SMITH AVE\", \"pcpnpi\": 1669572970, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"THOMASVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-08-17T13:31\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/17/2024 @ 01:31 PM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Faith but member refused on 05/14/2024\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"07/16/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:07 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/28/2024 @ 06:37 PM\", \"result\": 3, \"comment\": \"06/28/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/12/2024 @ 06:37 PM\"}, {\"date\": \"5/20/2024 @ 04:01 PM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE A MESSAGE\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 04:00 PM\"}, {\"date\": \"5/17/2024 @ 11:35 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Mailbox Full\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 11:35 AM\"}, {\"date\": \"5/10/2024 @ 05:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 05:42 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 17:42:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:07:38\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:06', 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
(1448, 50892900, 44829497, '62685179', '0005823195001', '364439', '', '2661185', 'Michael', 'Baker', '', '{\"DOB\": 30276, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1386710085, \"Pcp_Zip\": \"30525\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"Dr. EDWARD FREDERICKSON\", \"PCP_Phone\": \"7062120390\", \"Pcp_State\": \"GA\", \"Member_City\": \"Rabun Gap\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rabun Gap\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1982-11-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"156 N MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 364439, \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"7069609209\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"13 Discover Cir\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30568, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"436 Sims way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30568, \"Member_Last_name\": \"Baker\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Michael\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"ann.baker47@gmail.com\", \"Member_Suspect_Codes\": \"81, 82, 87.1, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 8137631342, \"Member_Identification_Number\": \"0005823195001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:33:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:33:52\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-14T15:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-16T13:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-17T09:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-10T17:53\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-10T17:54\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-12T06:41\", \"reportStatus_date\": \"2024-05-10T17:54\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-17T09:19\", \"reportStatus_date\": \"2024-05-17T09:19\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:33\", \"reportStatus_date\": \"2024-05-31T14:33\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:33\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-10T17:53\", \"username\": null}, {\"date\": \"2024-05-10T17:54\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-11T19:39\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-14T17:05\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-12T06:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-12T06:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T12:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T13:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T14:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:16\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-14T15:48\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-17T09:19\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-16T13:42\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-17T09:19\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-28-2024\", \"time\": \"16:19:41\", \"value\": [{\"add\": \"13 Discover Cir\", \"age\": 41, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1982-11-21\", \"eno\": \"8137631342\", \"lob\": \"On Exchange\", \"pno\": 8137631342, \"zip\": 30568, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rabun Gap\", \"gend\": 0, \"insh\": \"0005823195001\", \"mzip\": 30568, \"name\": \"Michael Baker\", \"plan\": \"Alliant\", \"pphy\": \"Dr. EDWARD FREDERICKSON\", \"ppno\": \"7062120390\", \"cliId\": \"\", \"email\": \"ann.baker47@gmail.com\", \"ename\": \"Ann Baker \", \"madd1\": \"436 Sims way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rabun Gap\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"156 N MAIN ST\", \"pcpnpi\": 1386710085, \"pcpzip\": \"30525\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"CLAYTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7069609209\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"19:39:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-28-2024 16:19:41\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/10/2024 @ 05:53 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Faith Enwefah for 5/14/24 @12:15pm. Spoke w/member\'s mother, Ann to schedule who is his caretaker. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005823195001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0005823195001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0005823195001\", \"scheduleDate\": \"2024-5-14T12:15\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 17:53:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-10-2024 17:53:59\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:33:51\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"537f4490-1f7c-11ef-a344-45af70d7d474\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-5-14T12:15', '2024-12-31', '2024-05-14T11:15', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:06', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005823195001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005823195001_Baker, Michael_05142024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:33:50\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_FREDERICKSON, EDWARD_0005823195001_05142024.pdf\"}', 'ACA_0005823195001_Baker, Michael_05142024', NULL, 'PCP_FREDERICKSON, EDWARD_0005823195001_05142024', NULL, '[{\"date\": \"2024-05-14T19:48:35.676Z\", \"signature\": \"data:image/png;base64,[encoded data, 23424 characters]\"}]', '2024-05-14T12:15', 'Member_Summary_0005823195001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005823195001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005823195001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:33:52\"}', NULL, NULL, NULL, NULL),
(1449, NULL, NULL, NULL, '0005827590001', '371840', '', '2661185', 'Scott', 'Williams', '', '{\"DOB\": 31298, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1548223779, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"TIMOTHY BECK\", \"PCP_Phone\": 7067820016, \"Pcp_State\": \"GA\", \"Member_City\": \"Clarkesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1985-09-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"189 BO JAMES ST STE 105\", \"Screening_IHA\": \"No\", \"member_id_two\": 371840, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"320 Windsong Ridge Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30523, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"320 Windsong Ridge Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Last_name\": \"Williams\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Scott\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"swilliams@mycovenanthomes.com\", \"Member_Suspect_Codes\": 56, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7272264410, \"Member_Identification_Number\": \"0005827590001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T16:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T11:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-23T12:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T14:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:35\", \"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-25T16:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T11:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-23T12:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T14:15\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:35\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-05T07:12\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-29T16:38\", \"username\": null}, {\"date\": \"2024-07-29T16:38\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-02T07:26\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:07\", \"value\": [{\"add\": \"320 Windsong Ridge Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1985-09-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7272264410, \"zip\": 30523, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 0, \"insh\": \"0005827590001\", \"mzip\": 30523, \"name\": \"Scott Williams\", \"plan\": \"Alliant\", \"pphy\": \"TIMOTHY BECK\", \"ppno\": 7067820016, \"cliId\": \"\", \"email\": \"swilliams@mycovenanthomes.com\", \"ename\": \"\", \"madd1\": \"320 Windsong Ridge Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"189 BO JAMES ST STE 105\", \"pcpnpi\": 1548223779, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CLAYTON\", \"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:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 11:39 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 11:07 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/5/2024 @ 06:08 PM\", \"result\": 3, \"comment\": \"attempt to sched virtual appt w/Delise Adams\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 12:45 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Connie Middleton LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 03:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 04:06 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:35 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/20/2024 @ 02:14 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 02:14 PM\"}, {\"date\": \"5/23/2024 @ 12:00 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/30/2024 @ 11:59 AM\"}, {\"date\": \"5/16/2024 @ 11:00 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/16/2024 @ 11:00 AM\"}, {\"date\": \"4/25/2024 @ 04:34 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 04:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:34:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 17:35:14\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:07', 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
(1450, NULL, NULL, NULL, '0005828261001', '342291', '', '543416', 'Jennifer', 'McClure', '', '{\"DOB\": 29537, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1679557805, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DEMOREST\", \"Pcp_Name\": \"WILLIAM WEAVER\", \"PCP_Phone\": 7067548518, \"Pcp_State\": \"GA\", \"Member_City\": \"Clarkesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Clarkesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1980-11-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"541 HISTORIC HWY 441 N\", \"Screening_IHA\": \"No\", \"member_id_two\": 342291, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"269 Timber Ridge Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305230000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"269 Timber Ridge Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30523, \"Member_Last_name\": \"McClure\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jennifer\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"jlmcclure@bellsouth.net\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6786436318, \"Member_Identification_Number\": \"0005828261001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-06T15:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T14:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T12:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-06-26T16:25\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2024-08-07T13:50\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-06T15:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T12:59\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-26T16:25\", \"reportStatus_date\": \"2024-06-26T16:25\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-07T13:50\", \"reportStatus_date\": \"2024-08-07T13:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-26T16:25\", \"username\": null}, {\"date\": \"2024-08-07T13:50\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:07\", \"value\": [{\"add\": \"269 Timber Ridge Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1980-11-12\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6786436318, \"zip\": 305230000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Clarkesville\", \"gend\": 1, \"insh\": \"0005828261001\", \"mzip\": 30523, \"name\": \"Jennifer McClure\", \"plan\": \"Alliant\", \"pphy\": \"WILLIAM WEAVER\", \"ppno\": 7067548518, \"cliId\": \"\", \"email\": \"jlmcclure@bellsouth.net\", \"ename\": \"\", \"madd1\": \"269 Timber Ridge Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Clarkesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"541 HISTORIC HWY 441 N\", \"pcpnpi\": 1679557805, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DEMOREST\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-26T16:25\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-08-07T13:50\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/7/2024 @ 01:50 PM\", \"result\": 9, \"comment\": \"MEMBER PREVIOUSLY REFUSED - Member refused to schedule HRA on 6/26.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/26/2024 @ 04:25 PM\", \"result\": 9, \"comment\": \"Refusal, member not interested. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}, {\"date\": \"6/21/2024 @ 12:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/28/2024 @ 12:59 PM\"}, {\"date\": \"6/20/2024 @ 02:16 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/24/2024 @ 02:16 PM\"}, {\"date\": \"6/6/2024 @ 12:38 PM\", \"result\": 3, \"comment\": \"06/06/2024 JC: called for HRA-Faith Enwefah: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/7/2024 @ 12:38 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-06-2024 12:38:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"04-22-2024 00:31:16\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1451, 55499828, 44829497, '72903859', '0005829098001', '379198', '', '2661185', 'CHARLES', 'HARPER', '', '{\"DOB\": 23021, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1043221492, \"Pcp_Zip\": \"31510\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"ALMA\", \"Pcp_Name\": \"HARRISON CARTER\", \"PCP_Phone\": 9126327300, \"Pcp_State\": \"GA\", \"Member_City\": \"Broxton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Broxton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-01-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1126 W 12TH ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 379198, \"Mailing_County\": \"COFFEE\", \"Member_Country\": \"COFFEE\", \"PCP_Fax_Number\": \"9126321326\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1617 Roses Creek Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31519, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1617 Roses Creek Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31519, \"Member_Last_name\": \"HARPER\", \"Medication_Review\": \"N\", \"Member_first_name\": \"CHARLES\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"cmharper1963@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 9123810562, \"Member_Identification_Number\": \"0005829098001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-16-2024 10:55:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-16 10:55:07\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T17:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T16:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-15T16:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-09T14:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-10T11:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-10T12:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-16T10:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-17T11:40\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-02T18:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-06-10T10:34\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T17:56\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-17T11:40\", \"reportStatus_date\": \"2024-05-17T11:40\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-23T11:04\", \"reportStatus_date\": null}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-06-10T10:34\", \"reportStatus_date\": \"2024-06-10T10:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-15T16:49\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-02T18:11\", \"reportStatus_date\": \"2024-07-02T18:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-10T12:41\", \"reportStatus_date\": \"2024-07-10T12:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-16T10:55\", \"reportStatus_date\": \"2024-07-16T10:55\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-16T10:55\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-17T11:40\", \"username\": null}, {\"date\": \"2024-05-17T11:40\", \"username\": null}, {\"date\": \"2024-07-02T18:11\", \"username\": null}, {\"date\": \"2024-07-02T18:11\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-23T10:45\", \"username\": \"DYork\"}, {\"date\": \"2024-07-09T13:19\", \"username\": \"DYork\"}], \"qaAssigned\": [{\"date\": \"2024-07-10T09:43\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-05-23T10:45\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:46\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:46\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:49\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:49\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:49\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:52\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:55\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:58\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T10:58\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T11:02\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T11:04\", \"username\": \"DYork\"}, {\"date\": \"2024-07-09T14:40\", \"username\": \"DYork\"}, {\"date\": \"2024-07-09T14:40\", \"username\": \"DYork\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-10T12:41\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-10T11:07\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-10T12:41\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-10T10:34\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"09-10-2024\", \"time\": \"16:33:30\", \"value\": [{\"add\": \"1617 Roses Creek Rd\", \"age\": 61, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-01-10\", \"eno\": \"912-592-3653\", \"lob\": \"On Exchange\", \"pno\": 9123810562, \"zip\": 31519, \"add2\": \"\", \"add3\": \"\", \"city\": \"Broxton\", \"gend\": 0, \"insh\": \"0005829098001\", \"mzip\": 31519, \"name\": \"CHARLES HARPER\", \"plan\": \"Alliant\", \"pphy\": \"HARRISON CARTER\", \"ppno\": 9126327300, \"race\": \"\", \"cliId\": \"\", \"email\": \"cmharper1963@gmail.com\", \"ename\": \"Debbie Harper\", \"madd1\": \"1617 Roses Creek Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Broxton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1126 W 12TH ST\", \"pcpnpi\": 1043221492, \"pcpzip\": \"31510\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"ALMA\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-07-09 01:28 PM\", \"evalName\": \"Deborah York, FNP\", \"pcpfaxno\": \"9126321326\", \"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\": \"05-20-2024\", \"time\": \"15:45:26\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"09-10-2024 16:33:30\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-10T10:34\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/2/2024 @ 06:11 PM\", \"result\": 0, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/15/2024 @ 04:49 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 04:49 PM\"}, {\"date\": \"6/12/2024 @ 04:24 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL TO RESCHEDULE - Call attempt to reschedule virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/13/2024 @ 04:24 PM\"}, {\"date\": \"5/17/2024 @ 11:40 AM\", \"result\": 0, \"comment\": \"SCHEDULED DEBBIE Y ON 5/23 @ 11 - TEXTED LINK TO MEMBERS PHONE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 05:56 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 05:56 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005829098001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"72903859\", \"memberId\": \"0005829098001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"72903859\", \"memberId\": \"0005829098001\", \"scheduleDate\": \"2024-7-9T13:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 17:56:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"06-10-2024 10:34:41\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:11:05\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, '[{\"date\": \"2024-07-16 10:55:06\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"63860932-4383-11ef-a70b-35890e6237d0\\\",\\\"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-9T13:30', '2024-12-31', '2024-07-09T13:28', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:07', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005829098001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005829098001_HARPER, CHARLES_07092024.pdf\", \"ftp_upload_date\": \"2024-07-16 10:55:05\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_CARTER, HARRISON_0005829098001_07092024.pdf\"}', 'ACA_0005829098001_HARPER, CHARLES_07092024', NULL, 'PCP_CARTER, HARRISON_0005829098001_07092024', NULL, '[{\"date\": \"2024-07-09T18:40:13.424Z\", \"signature\": \"data:image/png;base64,[encoded data, 23324 characters]\"}]', '2024-07-09T14:07', 'Member_Summary_0005829098001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005829098001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005829098001.pdf\", \"member_ftp_upload_date\": \"2024-07-16 10:55:06\"}', 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
(1452, NULL, NULL, NULL, '0005830969002', '364663', '', '2661185', 'Mark', 'Fortner', '', '{\"DOB\": 25126, \"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\": \"Dahlonega\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dahlonega\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-10-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 364663, \"Mailing_County\": \"LUMPKIN\", \"Member_Country\": \"LUMPKIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"136 Coolidge Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30533, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"136 Coolidge Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30533, \"Member_Last_name\": \"Fortner\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Mark\", \"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\": \"7064295550\", \"Member_Identification_Number\": \"0005830969002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T15:34\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-21T14:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-26T17:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T12:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-28T15:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T15:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-21T14:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-28T15:37\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T15:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-05T07:12\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-29T16:38\", \"username\": null}, {\"date\": \"2024-07-29T16:38\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-02T07:26\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"01:15:28\", \"value\": [{\"add\": \"136 Coolidge Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-10-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064295550, \"zip\": 30533, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dahlonega\", \"gend\": 0, \"insh\": \"0005830969002\", \"mzip\": 30533, \"name\": \"Mark Fortner\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"136 Coolidge Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dahlonega\", \"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:28\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:28\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 10:16 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 12:00 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/24/2024 @ 06:49 PM\", \"result\": 3, \"comment\": \"07/24/2024 JC: called for HRA-Delise Adams-Virtual/F2F: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 03:34 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/28/2024 @ 03:37 PM\", \"result\": 3, \"comment\": \"06/28/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/12/2024 @ 03:37 PM\"}, {\"date\": \"6/27/2024 @ 12:49 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 12:49 PM\"}, {\"date\": \"6/26/2024 @ 05:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/29/2024 @ 05:40 PM\"}, {\"date\": \"6/21/2024 @ 02:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/24/2024 @ 02:42 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-21-2024 14:43:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 15:34:33\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1453, NULL, NULL, NULL, '0005837124001', '205121', '', '543416', 'Sandra', 'Guardado', '', '{\"DOB\": 27732, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1942218086, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"DALTON\", \"Pcp_Name\": \"PABLO PEREZ\", \"PCP_Phone\": 7062772321, \"Pcp_State\": \"GA\", \"Member_City\": \"Tunnel Hill\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Tunnel Hill\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-12-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1102 W WAUGH ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 205121, \"Mailing_County\": \"Whitfield\", \"Member_Country\": \"Whitfield\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"541 Sagamore Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307550000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"541 Sagamore Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30755, \"Member_Last_name\": \"Guardado\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sandra\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"sandraguardado@gmail.com\", \"Member_Suspect_Codes\": \"13, 21, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7062715615, \"Member_Identification_Number\": \"0005837124001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-01T18:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-26T10:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-20T12:42\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-08-26T07:43\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [{\"date\": \"2024-07-11T13:14\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-15T17:28\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-30T17:42\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-11-06T17:30\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-07-01T18:17\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T17:28\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-30T17:42\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 19, \"hraStatus_date\": \"2024-08-26T07:43\", \"reportStatus_date\": \"2024-08-26T10:41\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-06T17:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-08-26T07:43\", \"username\": \"FEnwefah\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-08-20T12:42\", \"username\": null}, {\"date\": \"2024-08-20T12:42\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-23T08:33\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-23-2024\", \"time\": \"08:33:01\", \"value\": [{\"add\": \"541 Sagamore Dr\", \"age\": 48, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-12-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062715615, \"zip\": 307550000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Tunnel Hill\", \"gend\": 1, \"insh\": \"0005837124001\", \"mzip\": 30755, \"name\": \"Sandra Guardado\", \"plan\": \"Alliant\", \"pphy\": \"PABLO PEREZ\", \"ppno\": 7062772321, \"cliId\": \"\", \"email\": \"sandraguardado@gmail.com\", \"ename\": \"\", \"madd1\": \"541 Sagamore Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Tunnel Hill\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1102 W WAUGH ST\", \"pcpnpi\": 1942218086, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DALTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-23-2024\", \"time\": \"08:33:01\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-23-2024 10:10:39\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-08-26T07:43\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"FEnwefah\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"11/6/2024 @ 05:30 PM\", \"result\": 6, \"comment\": \"will need an interpreter... does not speak English \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"11/14/2024 @ 05:29 PM\"}, {\"date\": \"8/26/2024 @ 10:41 AM\", \"result\": 13, \"comment\": \"Caller answered the call prior to asking for member -- call attempt to reschedule - virtual no show 8/23 @ 10. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/27/2024 @ 10:41 AM\"}, {\"date\": \"8/20/2024 @ 12:42 PM\", \"result\": 0, \"comment\": \"Scheduled - member was forwarded text message with details of the appt.  Member asked for an interpreter, but still scheduled the appointment and updated the type of device she will use. She will use an iPhone to complete the assessment. Texted member the details of the appointment w/ Faith E on 8/23 @ 10. Caller then disconnected the call. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 05:42 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS member requested to be called back next week. reminder set.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"8/6/2024 @ 03:42 PM\"}, {\"date\": \"7/15/2024 @ 05:28 PM\", \"result\": 6, \"comment\": \"Member requested/will need an interpreter.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/16/2024 @ 05:28 PM\"}, {\"date\": \"7/11/2024 @ 01:14 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/Connie Middleton CALLBACK SPANISH SPEAKING ONLY. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/15/2024 @ 01:14 PM\"}, {\"date\": \"7/11/2024 @ 01:13 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/Connie Middleton CALLBACK SPANISH SPEAKING ONLY.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/22/2024 @ 01:11 PM\"}, {\"date\": \"7/1/2024 @ 06:17 PM\", \"result\": 3, \"comment\": \"07/01/2024 JC: called for HRA-Faith Enwefah-Virtual: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/2/2024 @ 06:16 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005837124001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0005837124001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0005837124001\", \"scheduleDate\": \"2024-8-23T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"07-01-2024 18:17:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}, {\"date\": \"08-26-2024 07:43:16\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"08-26-2024 07:43:16\", \"status\": 0, \"details\": \"scheduled member moved to no show/cancellation\", \"disabled\": false, \"notification\": {\"type\": 1, \"value\": \"\", \"previous_status\": 1}}', '{\"attemptCount\": 8}', '{\"orderType\": 0, \"sortOrder\": 1731567181}', 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:08', 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
(1454, 55499828, 44829497, '56716210', '0005848891002', '266562', '', '21881792', 'Lisa', 'Pritchett', '', '{\"DOB\": 25332, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1255327052, \"Pcp_Zip\": \"30705\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"CHATSWORTH\", \"Pcp_Name\": \"ROBERT COOK\", \"PCP_Phone\": 7066954546, \"Pcp_State\": \"GA\", \"Member_City\": \"Chatsworth\", \"Office_Name\": \"AdventHealth Medical Group Family Medicine at Chatsworth\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-05-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"100 HOSPITAL DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 266562, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"7065173969\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"175 Zion Hill Church Road\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": 307050000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"175 Zion Hill Church Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Last_name\": \"Pritchett\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Lisa\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 142, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": \"7064830712\", \"Member_Identification_Number\": \"0005848891002\", \"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:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-06 11:48:33\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T09:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-25T15:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-15T17:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-30T19:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-31T11:01\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-31T12:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T11:48\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-03T13:06\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-06T18:20\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-17T14:33\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-07T09:41\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-03T12:25\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-11T13:17\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T09:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-06T18:20\", \"reportStatus_date\": \"2024-05-06T18:20\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-07T09:41\", \"reportStatus_date\": \"2024-05-07T09:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-25T15:23\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T17:29\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-17T14:33\", \"reportStatus_date\": \"2024-07-17T14:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-31T12:33\", \"reportStatus_date\": \"2024-07-31T12:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-06T11:48\", \"reportStatus_date\": \"2024-08-06T11:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-06T11:48\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-03T13:06\", \"username\": null}, {\"date\": \"2024-05-03T13:06\", \"username\": null}, {\"date\": \"2024-05-06T18:20\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2024-07-17T14:33\", \"username\": null}, {\"date\": \"2024-07-17T14:33\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-06T16:16\", \"username\": \"DYork\"}, {\"date\": \"2024-07-30T06:38\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-07-31T09:24\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-07-30T19:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-07-30T19:53\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-31T12:33\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-31T11:01\", \"username\": \"HBeck\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-31T12:33\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-07T09:41\", \"username\": \"DYork\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-13-2024\", \"time\": \"11:43:25\", \"value\": [{\"add\": \"175 Zion Hill Church Road\", \"age\": 55, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-05-09\", \"eno\": \"2242\", \"lob\": \"On Exchange\", \"pno\": \"7064830712\", \"zip\": 307050000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 1, \"insh\": \"0005848891002\", \"mzip\": 30705, \"name\": \"Lisa Pritchett\", \"plan\": \"Alliant\", \"pphy\": \"ROBERT COOK\", \"ppno\": 7066954546, \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Charles Pritchett\", \"madd1\": \"175 Zion Hill Church Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"100 HOSPITAL DR\", \"pcpnpi\": 1255327052, \"pcpzip\": \"30705\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"CHATSWORTH\", \"pcpname\": \"AdventHealth Medical Group Family Medicine at Chatsworth\", \"program\": \"ACA\", \"evalDate\": \"2024-07-30 08:15 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7065173969\", \"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\": [[\"Baptist\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-13-2024 11:52:14\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-07T09:41\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"DYork\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"7/30/2024 @ 05:44 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:33 PM\", \"result\": 0, \"comment\": \"scheduled hra with delise adam on 7/30 at 8am sent link via text \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:29 PM\", \"result\": 3, \"comment\": \"07/15/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/29/2024 @ 05:29 PM\"}, {\"date\": \"7/11/2024 @ 01:17 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/Connie Middleton MEMBER NOT AVAILABLE.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/11/2024 @ 02:16 PM\"}, {\"date\": \"6/25/2024 @ 03:23 PM\", \"result\": 3, \"comment\": \"06/25/2024 JC: called for HRA-Deborah (Debbie) York-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/9/2024 @ 03:23 PM\"}, {\"date\": \"5/3/2024 @ 01:06 PM\", \"result\": 0, \"comment\": \"SCHEDULED DEBBIE Y ON 5/7 - PET IN HOME, PARK IN DRIVEWAY\", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/3/2024 @ 12:25 PM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED - MEMBER NOT AVAILABLE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/9/2024 @ 12:24 PM\"}, {\"date\": \"4/25/2024 @ 09:11 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/25/2024 @ 09:11 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0005848891002\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0005848891002\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0005848891002\", \"scheduleDate\": \"2024-7-30T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 09:11:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"05-07-2024 09:41:15\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-17-2024 14:33:49\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 0, NULL, '[{\"date\": \"2024-08-06 11:48:31\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"54da4a9a-540b-11ef-a293-c5837d0c9dc3\\\",\\\"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-30T08:00', '2024-12-31', '2024-07-30T08:15', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:08', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005848891002\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0005848891002_Pritchett, Lisa_07302024.pdf\", \"ftp_upload_date\": \"2024-08-06 11:48:31\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_COOK, ROBERT_0005848891002_07302024.pdf\"}', 'ACA_0005848891002_Pritchett, Lisa_07302024', NULL, 'PCP_COOK, ROBERT_0005848891002_07302024', NULL, '[{\"date\": \"2024-07-30T23:53:02.072Z\", \"signature\": \"data:image/png;base64,[encoded data, 23468 characters]\"}]', '2024-07-30T08:56', 'Member_Summary_0005848891002.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0005848891002\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0005848891002.pdf\", \"member_ftp_upload_date\": \"2024-08-06 11:48:32\"}', NULL, NULL, NULL, NULL),
(1455, NULL, NULL, NULL, '0005848928001', '388146', '', '21881792', 'Timothy', 'Holland', '', '{\"DOB\": 21742, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1841200375, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CALHOUN\", \"Pcp_Name\": \"Kisa Seymore\", \"PCP_Phone\": 4237026899, \"Pcp_State\": \"GA\", \"Member_City\": \"Calhoun\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Calhoun\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-07-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"400 TIMMS RD NE\", \"Screening_IHA\": \"No\", \"member_id_two\": 388146, \"Mailing_County\": \"GORDON\", \"Member_Country\": \"GORDON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2324 McDaniel Station Rd SW\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30701, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2324 McDaniel Station Rd SW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30701, \"Member_Last_name\": \"Holland\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Timothy\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"13, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7706081860, \"Member_Identification_Number\": \"0005848928001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:32:58\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:32:58\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-22T09:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T16:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-03T15:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T13:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T15:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-22T09:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-10-30T09:51\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T16:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-03T15:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T15:11\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-22T09:45\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-10-30T09:51\", \"reportStatus_date\": \"2024-10-30T09:51\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-10-30T09:51\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:09\", \"value\": [{\"add\": \"2324 McDaniel Station Rd SW\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-07-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7706081860, \"zip\": 30701, \"add2\": \"\", \"add3\": \"\", \"city\": \"Calhoun\", \"gend\": 0, \"insh\": \"0005848928001\", \"mzip\": 30701, \"name\": \"Timothy R Holland\", \"plan\": \"Alliant\", \"pphy\": \"Kisa Seymore\", \"ppno\": 4237026899, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"2324 McDaniel Station Rd SW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Calhoun\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"400 TIMMS RD NE\", \"pcpnpi\": 1841200375, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CALHOUN\", \"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:40\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:40\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-10-30T09:51\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"10/30/2024 @ 09:51 AM\", \"result\": 9, \"comment\": \"called for HRA-Virtual - Connie Middleton-GA, RN,NP : refusal\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 04:29 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 @ 04:42 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"6/22/2024 @ 09:45 AM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox or Faith Enwefah \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 03:11 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 03:11 PM\"}, {\"date\": \"6/13/2024 @ 01:24 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/19/2024 @ 01:24 PM\"}, {\"date\": \"5/3/2024 @ 03:02 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE DEBBIE Y. 5/7 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/8/2024 @ 03:02 PM\"}, {\"date\": \"4/25/2024 @ 04:34 PM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/26/2024 @ 04:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 16:34:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-22-2024 09:45:52\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', '{\"orderType\": 0, \"sortOrder\": 1730268406}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
