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
(673, NULL, NULL, NULL, '0004190950001', '272925', '', '21881792', 'Dung', 'Nguyen', '', '{\"DOB\": 20475, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1194176446, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"NHI-KIEU NGUYEN\", \"PCP_Phone\": 7702199000, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1956-01-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1439 JESSE JEWELL PKWY NE STE 102\", \"Screening_IHA\": \"No\", \"member_id_two\": 272925, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3755 Windsor Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305040000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3755 Windsor Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Last_name\": \"Nguyen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dung\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"dnguyen37@mail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789971054, \"Member_Identification_Number\": \"0004190950001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:40\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T12:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-07-19T16:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T13:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T19:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T12:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-15T11:36\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-23T09:55\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-23T09:55\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T11:36\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T19:24\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T12:55\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-07-19T16:09\", \"reportStatus_date\": \"2024-07-19T16:09\"}]', '{\"utc\": [{\"date\": \"2024-07-19T16:09\", \"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:55:13\", \"value\": [{\"add\": \"3755 Windsor Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1956-01-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789971054, \"zip\": 305040000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0004190950001\", \"mzip\": 30504, \"name\": \"Dung Nguyen\", \"plan\": \"Alliant\", \"pphy\": \"NHI-KIEU NGUYEN\", \"ppno\": 7702199000, \"cliId\": \"\", \"email\": \"dnguyen37@mail.com\", \"ename\": \"\", \"madd1\": \"3755 Windsor Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1439 JESSE JEWELL PKWY NE STE 102\", \"pcpnpi\": 1194176446, \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', '{\"utc\": [{\"date\": \"2024-07-19T16:09\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 12:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 05:18 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/19/2024 @ 04:09 PM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 12:55 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 07:24 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 07:24 PM\"}, {\"date\": \"6/4/2024 @ 01:32 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/11/2024 @ 01:32 PM\"}, {\"date\": \"5/15/2024 @ 11:36 AM\", \"result\": 14, \"comment\": \"MEMBER WORKS DURING DAY - NEED LATE EVENING CALL BACK. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/17/2024 @ 11:36 AM\"}, {\"date\": \"4/23/2024 @ 09:55 AM\", \"result\": 6, \"comment\": \"MEMBER CURRENTLY AT WORK AND REQUESTED A CALL BACK FOR A LATER DATE AND TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/24/2024 @ 09:55 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 09:55:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-10-2024 12:55:43\", \"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:55:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(674, NULL, NULL, NULL, '0004190993001', '272929', '', '21881792', 'JOSE', 'MARTINEZ', '', '{\"DOB\": 26840, \"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\": \"1973-06-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"303 JESSE JEWELL PKWY SE STE 230\", \"Screening_IHA\": \"No\", \"member_id_two\": 272929, \"Mailing_County\": \"Hall\", \"Member_Country\": \"Hall\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4201 Amberleigh Trce\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305073313, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4201 Amberleigh Trce\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"MARTINEZ\", \"Medication_Review\": \"N\", \"Member_first_name\": \"JOSE\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"josemartinezz@yopmail.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6787259017, \"Member_Identification_Number\": \"0004190993001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 6782063810}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:40\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T18:21\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-09-06T18:18\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-23T10:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T16:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T11:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-28T15:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T18:21\", \"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-23T10:00\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T16:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T11:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-28T15:17\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T18:21\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-09-06T18:18\", \"reportStatus_date\": \"2024-09-06T18:18\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:50\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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:55:13\", \"value\": [{\"add\": \"4201 Amberleigh Trce\", \"age\": \"\", \"ano\": \"\", \"cno\": 6782063810, \"dob\": \"1973-06-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787259017, \"zip\": 305073313, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0004190993001\", \"mzip\": 30507, \"name\": \"JOSE MARTINEZ\", \"plan\": \"Alliant\", \"pphy\": \"KENT MILLER\", \"ppno\": 7705324477, \"cliId\": \"\", \"email\": \"josemartinezz@yopmail.com\", \"ename\": \"\", \"madd1\": \"4201 Amberleigh Trce\", \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/31/2024 @ 12:47 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 06:18 PM\", \"result\": 6, \"comment\": \"attempt to sched virtual appt w/Nykya Cox - member said he already had health plan then h/u\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Kelly Coash\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 02:17 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 02:54 PM\", \"result\": 3, \"comment\": \"Sixth attempt called to schedule HRA/with Debbie York LEFT VM.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 02:53 PM\", \"result\": 3, \"comment\": \"Sixth attempt called to schedule HRA/with Connie Middleton NO VM SETUP.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 06:21 PM\", \"result\": 3, \"comment\": \"07/10/2024 JC: called for HRA-Delise Adams-Virtual: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"5/28/2024 @ 03:16 PM\", \"result\": 3, \"comment\": \"NO VM SETUP - Unable to leave a message. Call attempt to schedule F2F HRA.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/29/2024 @ 03:16 PM\"}, {\"date\": \"5/15/2024 @ 11:39 AM\", \"result\": 3, \"comment\": \"NO VM SETUP - UNABLE TO LEAVE A MESSAGE. ATTEMPT TO SCHEDULE HRA. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 11:39 AM\"}, {\"date\": \"5/13/2024 @ 04:50 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED THE CALL. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 04:50 PM\"}, {\"date\": \"4/23/2024 @ 10:00 AM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED THE CALL.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/24/2024 @ 09:59 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 10:00:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:50:02\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(675, NULL, NULL, NULL, '0004195111001', '216079', '', '21881792', 'Melanie', 'Johnston', '', '{\"DOB\": 26606, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1346442019, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DALTON\", \"Pcp_Name\": \"ANGELA MCDOWELL\", \"PCP_Phone\": \"\", \"Pcp_State\": \"GA\", \"Member_City\": \"Chatsworth\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-11-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1250 BROADRICK DR\", \"Screening_IHA\": \"No\", \"member_id_two\": 216079, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"16 Deer Park Road\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307050000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"16 Deer Park Road\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Last_name\": \"Johnston\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melanie\", \"Member_Middle_name\": \"Denise\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"meljohnston72@yahoo.con\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069802180, \"Member_Identification_Number\": \"0004195111001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 7069802184}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:31:40\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:40\", \"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-04-24T16:59\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}, {\"date\": \"2024-06-18T19:06\", \"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-04-24T16:59\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-18T19:06\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:55:13\", \"value\": [{\"add\": \"16 Deer Park Road\", \"age\": \"\", \"ano\": \"\", \"cno\": 7069802184, \"dob\": \"1972-11-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069802180, \"zip\": 307050000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 1, \"insh\": \"0004195111001\", \"mzip\": 30705, \"name\": \"Melanie Denise Johnston\", \"plan\": \"Alliant\", \"pphy\": \"ANGELA MCDOWELL\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"meljohnston72@yahoo.con\", \"ename\": \"\", \"madd1\": \"16 Deer Park Road\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1250 BROADRICK DR\", \"pcpnpi\": 1346442019, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DALTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"6/18/2024 @ 07:06 PM\", \"result\": 4, \"comment\": \"06/18/2024 JC: called for HRA-Delise Adams-Virtual: per perv note -  wrong number \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"4/24/2024 @ 04:58 PM\", \"result\": 4, \"comment\": \"INVALID CONTACT - CALLER STATED NUMBER NO LONGER BELONGS TO MEMBER - WRONG NUMBER. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 16:58:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-18-2024 19:06:09\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(676, NULL, NULL, NULL, '0004195950001', '325299', '', '26056802', 'Rafique', 'Ahmed', '', '{\"DOB\": 24633, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1386619526, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BRASELTON\", \"Pcp_Name\": \"ROBERT KELLY\", \"PCP_Phone\": 6783436195, \"Pcp_State\": \"GA\", \"Member_City\": \"Braselton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Braselton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-06-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1515 RIVER PL STE 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 325299, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5940 Hackberry Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305170000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5940 Hackberry Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30517, \"Member_Last_name\": \"Ahmed\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rafique\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rafique_ahmed30@hotmail.com\", \"Member_Suspect_Codes\": \"2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7188649458, \"Member_Identification_Number\": \"0004195950001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:40\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T19:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-10T14:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-04T18:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-25T17:33\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T19:16\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-10T14:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-04T18:11\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-25T17:33\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:30\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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:55:14\", \"value\": [{\"add\": \"5940 Hackberry Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-06-10\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7188649458, \"zip\": 305170000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Braselton\", \"gend\": 0, \"insh\": \"0004195950001\", \"mzip\": 30517, \"name\": \"Rafique Ahmed\", \"plan\": \"Alliant\", \"pphy\": \"ROBERT KELLY\", \"ppno\": 6783436195, \"cliId\": \"\", \"email\": \"rafique_ahmed30@hotmail.com\", \"ename\": \"\", \"madd1\": \"5940 Hackberry Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Braselton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1515 RIVER PL STE 100\", \"pcpnpi\": 1386619526, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BRASELTON\", \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"6/25/2024 @ 05:33 PM\", \"result\": 6, \"comment\": \"06/25/2024 JC: called for HRA-Deborah (Debbie) York-Virtual: member req call back busy, asked to be c/b next week in the evening time to schedule \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/9/2024 @ 05:33 PM\"}, {\"date\": \"6/4/2024 @ 06:11 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/11/2024 @ 06:10 PM\"}, {\"date\": \"5/10/2024 @ 02:12 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule IHA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/14/2024 @ 02:12 PM\"}, {\"date\": \"4/25/2024 @ 07:16 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/9/2024 @ 07:16 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:16:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-11-2024 00:30:21\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(677, NULL, NULL, NULL, '0004195950002', '325300', '', NULL, 'Showkat', 'Ahamed', '', '{\"DOB\": 25555, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1588985626, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BRASELTON\", \"Pcp_Name\": \"Lesley Algert\", \"PCP_Phone\": 7702197777, \"Pcp_State\": \"GA\", \"Member_City\": \"Braselton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Braselton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-12-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1515 RIVER PL STE 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 325300, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"5940 Hackberry Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305170000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"5940 Hackberry Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30517, \"Member_Last_name\": \"Ahamed\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Showkat\", \"Member_Middle_name\": \"Ara\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"184, 20, 21, 22, 56\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0004195950002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:55:14\", \"value\": [{\"add\": \"5940 Hackberry Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1969-12-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 305170000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Braselton\", \"gend\": 1, \"insh\": \"0004195950002\", \"mzip\": 30517, \"name\": \"Showkat Ara Ahamed\", \"plan\": \"Alliant\", \"pphy\": \"Lesley Algert\", \"ppno\": 7702197777, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"5940 Hackberry Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Braselton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1515 RIVER PL STE 100\", \"pcpnpi\": 1588985626, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BRASELTON\", \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:30:40\", \"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:55:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(678, NULL, NULL, NULL, '0004196330001', '281593', '', '2661185', 'LENTON', 'MARTIN', '', '{\"DOB\": 22039, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1356341119, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ATHENS\", \"Pcp_Name\": \"Jing Dong\", \"PCP_Phone\": 7065469290, \"Pcp_State\": \"GA\", \"Member_City\": \"TOCCOA\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"TOCCOA\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-05-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"651 S MILLEDGE AVE\", \"Screening_IHA\": \"No\", \"member_id_two\": 281593, \"Mailing_County\": \"STEPHENS\", \"Member_Country\": \"STEPHENS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"230 EMILY ST\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30577, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"230 EMILY ST\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30577, \"Member_Last_name\": \"MARTIN\", \"Medication_Review\": \"N\", \"Member_first_name\": \"LENTON\", \"Member_Middle_name\": \"HOWARD\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"1, 130, 21, 30, 48, 62\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4044029535, \"Member_Identification_Number\": \"0004196330001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-31T00:00\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-12-16T00:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T01:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-31T00:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-08T12:34\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-05-16T17:01\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-08T12:34\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T17:01\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T01:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-31T00:00\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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:55:14\", \"value\": [{\"add\": \"230 EMILY ST\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-05-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4044029535, \"zip\": 30577, \"add2\": \"\", \"add3\": \"\", \"city\": \"TOCCOA\", \"gend\": 0, \"insh\": \"0004196330001\", \"mzip\": 30577, \"name\": \"LENTON HOWARD MARTIN\", \"plan\": \"Alliant\", \"pphy\": \"Jing Dong\", \"ppno\": 7065469290, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"230 EMILY ST\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"TOCCOA\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"651 S MILLEDGE AVE\", \"pcpnpi\": 1356341119, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ATHENS\", \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"12/18/2024 @ 09:28 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/17/2024 @ 10:19 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/12/2024 @ 11:07 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/11/2024 @ 12:04 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"12/10/2024 @ 12:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/25/2024 @ 01:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/27/2024 @ 09:30 AM\"}, {\"date\": \"11/6/2024 @ 05:23 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"11/08/2024 @ 09:30 AM\"}, {\"date\": \"5/16/2024 @ 05:01 PM\", \"result\": 14, \"comment\": \"SCHEDULING VIRTUAL APPTS. PREVIOUS NOTE FROM 5/8 STATE MEMBER DOES NOT HAVE VIRTUAL CAPABILITIES. PLACED MEMBER AS A F2F CALL BACK FOR A LATER DATE AND TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 05:01 PM\"}, {\"date\": \"5/8/2024 @ 12:34 PM\", \"result\": 14, \"comment\": \"Member doesn\'t have capabilities to do a virtual appt. He just had eye surgery to remove cataracts and would like a call back to schedule a F2F when available. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/15/2024 @ 12:33 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-08-2024 12:34:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"12-31-2024 00:00:02\", \"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:55:14', 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
(679, 93442164, 44829497, '56716210', '0004207231001', '329483', '', '20099125', 'Robert', 'Grizzle', '', '{\"DOB\": 23411, \"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\": 1023421930, \"Pcp_Zip\": \"30096\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"DULUTH\", \"Pcp_Name\": \"SINAN HADDAD\", \"PCP_Phone\": \"6786804295\", \"Pcp_State\": \"GA\", \"Member_City\": \"Lula\", \"Office_Name\": \"Guilford Clinic\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lula\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-02-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1630 PLEASANT HILL RD STE 340\", \"Screening_IHA\": \"No\", \"member_id_two\": 329483, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"6786804295\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6400 Narramore Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305540000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6400 Narramore Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30554, \"Member_Last_name\": \"Grizzle\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"r_grizzle@bellsouth.net\", \"Member_Suspect_Codes\": \"130, 132, 20, 21, 217, 56\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7709055727, \"Member_Identification_Number\": \"0004207231001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-28-2024 11:18:19\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-28 11:18:19\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-24T20:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-27T17:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-27T18:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-28T11:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-08-14T13:25\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-08-14T13:25\", \"reportStatus_date\": \"2024-08-14T13:25\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-08-26T19:01\", \"reportStatus_date\": \"2024-08-24T20:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-28T11:18\", \"reportStatus_date\": \"2024-08-28T11:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-28T11:18\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-08-14T13:25\", \"username\": null}, {\"date\": \"2024-08-14T13:25\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-22T22:06\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-26T17:17\", \"username\": \"PFrey1\"}], \"readyForQa\": [{\"date\": \"2024-08-24T20:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-24T20:43\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-26T18:53\", \"username\": \"mscanlon1\"}, {\"date\": \"2024-08-26T18:56\", \"username\": \"mscanlon1\"}, {\"date\": \"2024-08-26T18:59\", \"username\": \"mscanlon1\"}, {\"date\": \"2024-08-27T08:13\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-27T18:26\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-27T17:56\", \"username\": \"mscanlon1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-27T18:26\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-26T19:01\", \"username\": \"mscanlon1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"12:04:19\", \"value\": [{\"add\": \"6400 Narramore Way\", \"age\": 60, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1964-02-04\", \"eno\": \"7705406716\", \"lob\": \"On Exchange\", \"pno\": 7709055727, \"zip\": 305540000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lula\", \"gend\": 0, \"insh\": \"0004207231001\", \"mzip\": 30554, \"name\": \"Robert Grizzle\", \"plan\": \"Alliant\", \"pphy\": \"SINAN HADDAD\", \"ppno\": \"6786804295\", \"race\": \"\", \"cliId\": \"\", \"email\": \"r_grizzle@bellsouth.net\", \"ename\": \"Loretta Grizzle\", \"madd1\": \"6400 Narramore Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lula\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1630 PLEASANT HILL RD STE 340\", \"pcpnpi\": \"\", \"pcpzip\": \"30096\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"DULUTH\", \"pcpname\": \"Guilford Clinic\", \"program\": \"ACA\", \"evalDate\": \"2024-08-23 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"6786804295\", \"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\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-22-2024\", \"time\": \"22:06:49\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-13-2025 12:04:19\"}', NULL, NULL, '{\"memberId\": \"0004207231001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Meredyth Scanlon\", \"queryData\": [{\"date\": \"Mon, 26 Aug 2024 22:47:58 GMT\", \"name\": \"Meredyth \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n1. Long term use states member is on a steroid and statin. I am so sorry but I didn\'t see either. Can you add or remove for the long term use.\\nThank you \\nMeredyth\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 27 Aug 2024 12:13:12 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Whoops, not sure how that happened. Removed them. Thank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Robert Grizzle\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/23/2024 08:00 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"m.scanlon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"8/14/2024 @ 01:25 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Delise on  8/23 at 8am. Doxy link texted. Member using phone\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004207231001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0004207231001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0004207231001\", \"scheduleDate\": \"2024-8-23T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"08-14-2024 13:25:00\", \"schedulerId\": \"20099125\", \"schedulerLeadId\": \"20099125\"}]}', '{\"date\": \"08-14-2024 13:25:48\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-08-28 11:18:17\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"c0b96883-6550-11ef-bd3a-ad2ec2c3940e\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-8-23T08:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:14', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004207231001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004207231001_Grizzle, Robert_08232024.pdf\", \"ftp_upload_date\": \"2024-08-28 11:18:17\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_HADDAD, SINAN_0004207231001_08232024.pdf\"}', 'ACA_0004207231001_Grizzle, Robert_08232024', NULL, 'PCP_HADDAD, SINAN_0004207231001_08232024', NULL, '[{\"date\": \"2024-08-25T00:43:23.368Z\", \"signature\": \"data:image/png;base64,[encoded data, 23500 characters]\"}, {\"date\": \"2024-08-27T12:13:12.264Z\", \"signature\": \"data:image/png;base64,[encoded data, 23496 characters]\"}]', '2024-08-23T09:22', 'Member_Summary_0004207231001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004207231001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004207231001.pdf\", \"member_ftp_upload_date\": \"2024-08-28 11:18:19\"}', 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
(680, NULL, NULL, NULL, '0004210153001', '261437', '', '2661185', 'Jodye', 'Baker', '', '{\"DOB\": 25479, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1669467601, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"ROME\", \"Pcp_Name\": \"Amar Singh\", \"PCP_Phone\": 7622351000, \"Pcp_State\": \"GA\", \"Member_City\": \"Silver Creek\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Silver Creek\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1969-10-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"550 REDMOND RD NW\", \"Screening_IHA\": \"No\", \"member_id_two\": 261437, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3 Grayfield Dr SE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 301730000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3 Grayfield Dr SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30173, \"Member_Last_name\": \"Baker\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jodye\", \"Member_Middle_name\": \"Diane\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"baker3469@comcast.net\", \"Member_Suspect_Codes\": \"127, 130, 160, 161.2, 21, 28, 57, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"7062353469\", \"Member_Identification_Number\": \"0004210153001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-18T15:32\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-01T13:10\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-07T17:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T13:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-14T15:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-18T15:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-01T13:10\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T17:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T15:03\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-18T15:32\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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\": \"07-16-2024\", \"time\": \"03:21:14\", \"value\": [{\"add\": \"3 Grayfield Dr SE\", \"age\": \"\", \"ano\": \"\", \"cno\": null, \"dob\": \"1969-10-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7062353469, \"zip\": 301730000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Silver Creek\", \"gend\": 1, \"insh\": \"0004210153001\", \"mzip\": 30173, \"name\": \"Jodye Diane Baker\", \"plan\": \"Alliant\", \"pphy\": \"Amar Singh\", \"ppno\": 7622351000, \"cliId\": \"\", \"email\": \"baker3469@comcast.net\", \"ename\": \"\", \"madd1\": \"3 Grayfield Dr SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Silver Creek\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"550 REDMOND RD NW\", \"pcpnpi\": 1669467601, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"ROME\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-16-2024\", \"time\": \"03:21:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-16-2024 03:21:14\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/13/2024 @ 11:44 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/12/2024 @ 11:45 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:36 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 03:29 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 03:30 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 03:17 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/  Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/7/2024 @ 01:07 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F or virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/24/2024 @ 05:48 PM\", \"result\": 3, \"comment\": \"06/24/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/18/2024 @ 03:32 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/14/2024 @ 03:03 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 @ 03:02 PM\"}, {\"date\": \"6/12/2024 @ 10:02 AM\", \"result\": 3, \"comment\": \"06/12/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/25/2024 @ 10:02 AM\"}, {\"date\": \"5/7/2024 @ 05:11 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH E. 5/10.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 05:11 PM\"}, {\"date\": \"5/1/2024 @ 01:10 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/2/2024 @ 01:10 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-01-2024 13:10:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-18-2024 15:32:27\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 13}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(681, NULL, NULL, NULL, '0004211529001', '273054', '', '2661185', 'GLENDA', 'MULFORD', '', '{\"DOB\": 23218, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1972506012, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"YOUNG HARRIS\", \"Pcp_Name\": \"PAULA BOYLE\", \"PCP_Phone\": 7067396873, \"Pcp_State\": \"GA\", \"Member_City\": \"Young Harris\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Young Harris\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-07-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1155 MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 273054, \"Mailing_County\": \"UNION\", \"Member_Country\": \"UNION\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"444 Mountain Top View Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30582, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"444 Mountain Top View Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30582, \"Member_Last_name\": \"MULFORD\", \"Medication_Review\": \"N\", \"Member_first_name\": \"GLENDA\", \"Member_Middle_name\": \"GAIL\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mountainlistings@gmail.com\", \"Member_Suspect_Codes\": \"21, 30, 48, 56, 57, 74\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069709780, \"Member_Identification_Number\": \"0004211529001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-05-08T12:54\", \"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-08T12:54\", \"reportStatus_date\": \"2024-05-08T12:54\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-08T12:54\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:55:15\", \"value\": [{\"add\": \"444 Mountain Top View Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-07-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069709780, \"zip\": 30582, \"add2\": \"\", \"add3\": \"\", \"city\": \"Young Harris\", \"gend\": 1, \"insh\": \"0004211529001\", \"mzip\": 30582, \"name\": \"GLENDA GAIL MULFORD\", \"plan\": \"Alliant\", \"pphy\": \"PAULA BOYLE\", \"ppno\": 7067396873, \"cliId\": \"\", \"email\": \"mountainlistings@gmail.com\", \"ename\": \"\", \"madd1\": \"444 Mountain Top View Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Young Harris\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1155 MAIN ST\", \"pcpnpi\": 1972506012, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"YOUNG HARRIS\", \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-08T12:54\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/8/2024 @ 12:54 PM\", \"result\": 9, \"comment\": \"Member not interested in having HRA -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-08-2024 12:54:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:30:40\", \"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:55:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(682, NULL, NULL, NULL, '0004213008001', '267721', '', '21881792', 'James', 'Devries', '', '{\"DOB\": 33596, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1700299419, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"RINGGOLD\", \"Pcp_Name\": \"ERIN SIMPSON\", \"PCP_Phone\": 4236972000, \"Pcp_State\": \"GA\", \"Member_City\": \"Ringgold\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Ringgold\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1991-12-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4700 BATTLEFIELD PKWY STE 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 267721, \"Mailing_County\": \"CATOOSA\", \"Member_Country\": \"CATOOSA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"204 Old Salem Church Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307360000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"204 Old Salem Church Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30736, \"Member_Last_name\": \"Devries\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"Colton\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"sethdevvvv@gmail.com\", \"Member_Suspect_Codes\": \"1, 161.2, 23, 56, 57, 84, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4238830183, \"Member_Identification_Number\": \"0004213008001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 4234435212}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T18:36\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T13:42\", \"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-10T18:20\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-15T15:06\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-01T19:09\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-19T10:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-08-26T17:48\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-24T14:04\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-05-31T18:37\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-24T14:04\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-31T18:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T13:42\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T15:06\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-01T19:09\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T10:52\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-26T17:48\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-15T05:42\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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\": \"08-14-2024\", \"time\": \"15:18:17\", \"value\": [{\"add\": \"204 Old Salem Church Rd\", \"age\": 32, \"ano\": \"\", \"cno\": 4234435212, \"dob\": \"1991-12-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4238830183, \"zip\": 307360000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Ringgold\", \"gend\": 0, \"insh\": \"0004213008001\", \"mzip\": 30736, \"name\": \"James Colton Devries\", \"plan\": \"Alliant\", \"pphy\": \"ERIN SIMPSON\", \"ppno\": 4236972000, \"cliId\": \"\", \"email\": \"sethdevvvv@gmail.com\", \"ename\": \"\", \"madd1\": \"204 Old Salem Church Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Ringgold\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4700 BATTLEFIELD PKWY STE 200\", \"pcpnpi\": 1700299419, \"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\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-14-2024\", \"time\": \"15:18:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-14-2024 15:18:17\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:39 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:33 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 02:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:54 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/26/2024 @ 05:48 PM\", \"result\": 10, \"comment\": \"Primary number no longer in service. Call attempt to schedule a HRA w/ Deborah York (Debbie).\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 10:52 AM\", \"result\": 10, \"comment\": \"DISCONNECTED -Primary number no longer in service. Call attempt to schedule a virtual HRA Nykya Cox  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 07:09 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 03:06 PM\", \"result\": 10, \"comment\": \"07/15/2024 JC: called for HRA-Connie Middleton-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 06:20 PM\", \"result\": 10, \"comment\": \"Called to set up HRA with Faith Enwefah DISCONNETED\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 10:42 AM\", \"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/27/2024 @ 10:40 AM\"}, {\"date\": \"5/31/2024 @ 06:37 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Deborah York - member is currently at work and requests a call back prior to noon  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/7/2024 @ 06:37 PM\"}, {\"date\": \"5/31/2024 @ 06:36 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Deborah York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/7/2024 @ 06:36 PM\"}, {\"date\": \"4/24/2024 @ 02:04 PM\", \"result\": 6, \"comment\": \"MEMBER STATED HE IS AT WORK AND DID NOT WANT TO UPDATE HIS ADDRESS DURING CALL. REQUESTED A CALL BACK FOR A LATER TIME. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/26/2024 @ 02:04 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 14:04:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-15-2024 05:42:27\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 14}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(683, NULL, NULL, NULL, '0004214863001', '295647', '', '26056802', 'Karl', 'Kohl', '', '{\"DOB\": 23797, \"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\": \"Oakwood\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Newnan\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-02-24\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 295647, \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4923 Oak Meadow Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305660000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"11 Willington way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30265, \"Member_Last_name\": \"Kohl\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Karl\", \"Member_Middle_name\": \"Christopher\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kkohl31812@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4043130512, \"Member_Identification_Number\": \"0004214863001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:31:41\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-11-01T15:23\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T18:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-27T11:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-01T15:23\", \"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-13T12:20\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-08-28T11:13\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-30T18:57\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T12:20\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-28T11:13\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-01T15:23\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:55:16\", \"value\": [{\"add\": \"4923 Oak Meadow Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-02-24\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4043130512, \"zip\": 305660000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Oakwood\", \"gend\": 0, \"insh\": \"0004214863001\", \"mzip\": 30265, \"name\": \"Karl Christopher Kohl\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"kkohl31812@gmail.com\", \"ename\": \"\", \"madd1\": \"11 Willington way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Newnan\", \"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:22:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"11/1/2024 @ 03:23 PM\", \"result\": 1, \"comment\": \"Called Member to set up virtual HRA dead air--LB\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"\"}, {\"date\": \"8/28/2024 @ 11:13 AM\", \"result\": 6, \"comment\": \"Called to schedule Virtual HRA with Delise Adams CALL BACK. requesting letter to be resent\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"9/6/2024 @ 11:12 AM\"}, {\"date\": \"8/27/2024 @ 11:12 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a HRA w/ Delise Adams. 9/06 - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/28/2024 @ 11:12 AM\"}, {\"date\": \"5/13/2024 @ 12:20 PM\", \"result\": 6, \"comment\": \"5/13/24 GM: Called to Schedule Virtual HRA with Sally Key member requested call back in a couple days \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"5/20/2024 @ 12:19 PM\"}, {\"date\": \"4/30/2024 @ 06:57 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 06:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 18:57:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-01-2024 15:23:51\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(684, NULL, NULL, NULL, '0004214942003', '286508', '', '2661185', 'kelly', 'van mill', '', '{\"DOB\": 26622, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1083943773, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"HIAWASSEE\", \"Pcp_Name\": \"ELIZABETH DYER\", \"PCP_Phone\": 7067396873, \"Pcp_State\": \"GA\", \"Member_City\": \"Hiawassee\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Hiawassee\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-11-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"110 S MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 286508, \"Mailing_County\": \"TOWNS\", \"Member_Country\": \"TOWNS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7005 Black Bear Trl\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30546, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"7005 Black Bear Trl\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30546, \"Member_Last_name\": \"van mill\", \"Medication_Review\": \"N\", \"Member_first_name\": \"kelly\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21, 56, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 5618764744, \"Member_Identification_Number\": \"0004214942003\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:41\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-08T12:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T17:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T11:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-06-05T15:21\", \"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-08T12:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T11:56\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-05T15:21\", \"reportStatus_date\": \"2024-06-05T15:21\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-05T15:21\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:55:16\", \"value\": [{\"add\": \"7005 Black Bear Trl\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-11-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 5618764744, \"zip\": 30546, \"add2\": \"\", \"add3\": \"\", \"city\": \"Hiawassee\", \"gend\": 1, \"insh\": \"0004214942003\", \"mzip\": 30546, \"name\": \"kelly van mill\", \"plan\": \"Alliant\", \"pphy\": \"ELIZABETH DYER\", \"ppno\": 7067396873, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"7005 Black Bear Trl\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Hiawassee\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"110 S MAIN ST\", \"pcpnpi\": 1083943773, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"HIAWASSEE\", \"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:22:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:44\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-05T15:21\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"6/5/2024 @ 03:21 PM\", \"result\": 9, \"comment\": \"REFUSAL - Member declined offer to schedule HRA in 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/20/2024 @ 11:56 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/22/2024 @ 11:56 AM\"}, {\"date\": \"5/16/2024 @ 05:03 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 05:03 PM\"}, {\"date\": \"5/8/2024 @ 12:57 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/9/2024 @ 12:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-08-2024 12:57:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:30:40\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:16', 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
(685, 3285757, 44829497, '62685179', '0004215618001', '281609', '', '2661185', 'EDGAR', 'PLUMMER', '', '{\"DOB\": 22668, \"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\": 1912993569, \"Pcp_Zip\": \"30105\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"ARMUCHEE\", \"Pcp_Name\": \"Frank Hampton\", \"PCP_Phone\": \"7062351156\", \"Pcp_State\": \"GA\", \"Member_City\": \"Rome\", \"Office_Name\": \"Harbin Clinic Family Medicine Armuchee\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-01-22\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"5470 MARTHA BERRY HWY NE\", \"Screening_IHA\": \"No\", \"member_id_two\": 281609, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"7062919391\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"823 Old River Rd SW\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 301650000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"823 Old River Rd SW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30165, \"Member_Last_name\": \"PLUMMER\", \"Medication_Review\": \"N\", \"Member_first_name\": \"EDGAR\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"130, 142, 146, 160, 162, 20, 21, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7068446691, \"Member_Identification_Number\": \"0004215618001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 7062920797}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-06-2024 11:47:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-06 11:47:52\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-01T15:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-02T20:27\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-03T13:40\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T11:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-22T18:05\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-04-22T18:49\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-07T12:35\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-14T13:55\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-18T14:43\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-24T15:07\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-22T18:49\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-07T12:35\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-14T13:55\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-24T15:07\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-22T18:05\", \"reportStatus_date\": \"2024-07-22T18:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-03T13:40\", \"reportStatus_date\": \"2024-08-03T13:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-06T11:47\", \"reportStatus_date\": \"2024-08-06T11:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-06T11:47\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-07-22T18:05\", \"username\": null}, {\"date\": \"2024-07-22T18:05\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-01T07:35\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-08-01T15:47\", \"username\": \"TFerness2\"}], \"readyForQa\": [{\"date\": \"2024-08-01T15:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-08-01T15:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-08-02T06:17\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-03T13:40\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-02T20:27\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-03T13:40\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-02T00:10\", \"username\": \"BClark\"}, {\"date\": \"2024-08-02T06:17\", \"username\": \"FEnwefah\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-12-2024\", \"time\": \"14:11:25\", \"value\": [{\"add\": \"823 Old River Rd SW\", \"age\": 62, \"ano\": \"\", \"cno\": 7062920797, \"dob\": \"1962-01-22\", \"eno\": \"706 3315868\", \"lob\": \"On Exchange\", \"pno\": 7068446691, \"zip\": 301650000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 0, \"insh\": \"0004215618001\", \"mzip\": 30165, \"name\": \"EDGAR PLUMMER\", \"plan\": \"Alliant\", \"pphy\": \"Frank Hampton\", \"ppno\": \"7062351156\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Kim Bronson\", \"madd1\": \"823 Old River Rd SW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"5470 MARTHA BERRY HWY NE\", \"pcpnpi\": 1912993569, \"pcpzip\": \"30105\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Divorced\", \"pcpFlag\": 0, \"pcpcity\": \"ARMUCHEE\", \"pcpname\": \"Harbin Clinic Family Medicine Armuchee\", \"program\": \"ACA\", \"pcpfaxno\": \"7062919391\", \"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\": \"08-01-2024\", \"time\": \"07:35:20\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-12-2024 14:12:41\"}', NULL, NULL, '{\"memberId\": \"0004215618001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Fri, 02 Aug 2024 04:10:47 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nThank you for your thorough assessment!\\n\\n1) Under preventative care, can you please select \\\"no\\\" for colonoscopy since it has been more than 3 years (you can keep the 7 years comment, method, and recommendation for one)\\n2) Under medications, long term use, is Eliquis used long term? If so, can you please select the anticoagulant category\\n3) Can you please add to the summary if you reviewed the previously documented conditions\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 02 Aug 2024 10:17:57 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"EDGAR PLUMMER\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/01/2024 11:30 AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/22/2024 @ 06:05 PM\", \"result\": 0, \"comment\": \"Scheduled a virtual HRA w/ Faith E on 8/1 @ 11:30 - texted link to member. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/24/2024 @ 03:07 PM\", \"result\": 10, \"comment\": \"06/24/2024 JC: called for HRA-Nykya Cox-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/18/2024 @ 02:43 PM\", \"result\": 10, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: DISC \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/2/2024 @ 02:42 PM\"}, {\"date\": \"6/14/2024 @ 01:55 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/21/2024 @ 01:55 PM\"}, {\"date\": \"5/7/2024 @ 12:35 PM\", \"result\": 10, \"comment\": \"DISCONNECTED\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 12:35 PM\"}, {\"date\": \"4/22/2024 @ 06:49 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/23/2024 @ 06:49 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004215618001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0004215618001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0004215618001\", \"scheduleDate\": \"2024-8-1T11:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-22-2024 18:49:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-22-2024 18:05:18\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2024-08-06 11:47:51\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"3cbe69f1-540b-11ef-a05d-593578d91fdd\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-8-1T11:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:16', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004215618001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004215618001_PLUMMER, EDGAR_08012024.pdf\", \"ftp_upload_date\": \"2024-08-06 11:47:49\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Hampton, Frank_0004215618001_08012024.pdf\"}', 'ACA_0004215618001_PLUMMER, EDGAR_08012024', NULL, 'PCP_Hampton, Frank_0004215618001_08012024', NULL, '[{\"date\": \"2024-08-01T19:29:59.923Z\", \"signature\": \"data:image/png;base64,[encoded data, 23416 characters]\"}, {\"date\": \"2024-08-02T10:17:56.749Z\", \"signature\": \"data:image/png;base64,[encoded data, 23404 characters]\"}]', '2024-08-01T12:30', 'Member_Summary_0004215618001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004215618001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004215618001.pdf\", \"member_ftp_upload_date\": \"2024-08-06 11:47:52\"}', 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
(686, NULL, NULL, NULL, '0004219727001', '298252', '', '21881792', 'Shannon', 'Tyler', '', '{\"DOB\": 23779, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1558332916, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"Cecil Beehler\", \"PCP_Phone\": 7702199245, \"Pcp_State\": \"GA\", \"Member_City\": \"Rabun\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Wiley\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-02-06\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"30 COTTONWOOD ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 298252, \"Member_Country\": \"Rabun\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"222 mcCall Lane\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305250000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 66\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30581, \"Member_Last_name\": \"Tyler\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shannon\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tracytyler0206@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064901659, \"Member_Identification_Number\": \"0004219727001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-17T12:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T16:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-04T09:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T19:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-12T19:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T12:38\", \"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-31T16:57\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-04T09:34\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T12:38\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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:55:16\", \"value\": [{\"add\": \"222 mcCall Lane\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-02-06\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064901659, \"zip\": 305250000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rabun\", \"gend\": 1, \"insh\": \"0004219727001\", \"mzip\": 30581, \"name\": \"Shannon Tyler\", \"plan\": \"Alliant\", \"pphy\": \"Cecil Beehler\", \"ppno\": 7702199245, \"cliId\": \"\", \"email\": \"tracytyler0206@gmail.com\", \"ename\": \"\", \"madd1\": \"PO Box 66\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Wiley\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"30 COTTONWOOD ST\", \"pcpnpi\": 1558332916, \"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:22:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/12/2024 @ 11:39 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/11/2024 @ 11:33 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/7/2024 @ 02:42 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 11:30 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Debbie York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 12:38 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/12/2024 @ 07:19 PM\", \"result\": 3, \"comment\": \"06/12/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/26/2024 @ 07:19 PM\"}, {\"date\": \"6/12/2024 @ 07:17 PM\", \"result\": 3, \"comment\": \"06/12/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/26/2024 @ 07:17 PM\"}, {\"date\": \"6/4/2024 @ 09:34 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/5/2024 @ 09:34 AM\"}, {\"date\": \"5/31/2024 @ 04:57 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 04:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 16:57:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-17-2024 12:38:22\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(687, NULL, NULL, NULL, '0004219727002', '298253', '', '21881792', 'Stephen', 'Tyler', '', '{\"DOB\": 23081, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1558332916, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"Cecil Beehler\", \"PCP_Phone\": 7702199245, \"Pcp_State\": \"GA\", \"Member_City\": \"Rabun\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Wiley\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1963-03-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"30 COTTONWOOD ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 298253, \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"222 mcCall Lane\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305250000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 66\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30581, \"Member_Last_name\": \"Tyler\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephen\", \"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\": 7064901659, \"Member_Identification_Number\": \"0004219727002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:42\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:42\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T14:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T16:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-04T09:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T12:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-25T17:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T14:49\", \"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-31T16:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-04T09:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T12:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-25T17:37\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T14:49\"}]', '{\"utc\": [{\"date\": \"2024-09-06T18:18\", \"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:55:17\", \"value\": [{\"add\": \"222 mcCall Lane\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1963-03-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064901659, \"zip\": 305250000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rabun\", \"gend\": 0, \"insh\": \"0004219727002\", \"mzip\": 30581, \"name\": \"Stephen Tyler\", \"plan\": \"Alliant\", \"pphy\": \"Cecil Beehler\", \"ppno\": 7702199245, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"PO Box 66\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Wiley\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"30 COTTONWOOD ST\", \"pcpnpi\": 1558332916, \"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:22:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/7/2024 @ 02:44 PM\", \"result\": 13, \"comment\": \"just hung up.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"11/6/2024 @ 02:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 03:52 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 11:32 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Debbie York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 02:49 PM\", \"result\": 3, \"comment\": \"07/03/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/25/2024 @ 05:37 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 @ 05:37 PM\"}, {\"date\": \"6/17/2024 @ 12:39 PM\", \"result\": 3, \"comment\": \"06/17/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/1/2024 @ 12:39 PM\"}, {\"date\": \"6/4/2024 @ 09:37 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/5/2024 @ 09:37 AM\"}, {\"date\": \"5/31/2024 @ 04:56 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 04:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 16:56:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-03-2024 14:49:26\", \"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:55:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(688, NULL, NULL, NULL, '0004220584001', '339328', '', '21881792', 'Rhonda', 'Navarro', '', '{\"DOB\": 23879, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1770663379, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"WENDELL TURNER\", \"PCP_Phone\": 7705341230, \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-05-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"303 JESSE JEWELL PKWY SE STE 320\", \"Screening_IHA\": \"No\", \"member_id_two\": 339328, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"838 River Estates Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305280000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"838 River Estates Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Navarro\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Rhonda\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"rhondan1@gmail.com\", \"Member_Suspect_Codes\": \"114, 115, 139, 142, 56, 57\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4046619103, \"Member_Identification_Number\": \"0004220584001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-17-2024 00:00:12\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-05-17 00:00:12\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-01T15:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-09T15:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-01T15:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-09T15:41\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:55:17\", \"value\": [{\"add\": \"838 River Estates Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-05-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4046619103, \"zip\": 305280000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0004220584001\", \"mzip\": 30528, \"name\": \"Rhonda Navarro\", \"plan\": \"Alliant\", \"pphy\": \"WENDELL TURNER\", \"ppno\": 7705341230, \"cliId\": \"\", \"email\": \"rhondan1@gmail.com\", \"ename\": \"\", \"madd1\": \"838 River Estates Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"303 JESSE JEWELL PKWY SE STE 320\", \"pcpnpi\": 1770663379, \"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:22:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"5/9/2024 @ 03:41 PM\", \"result\": 3, \"comment\": \"Called member to set up F2F HRA with Delise \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Christina Medina\", \"callbackDate\": \"5/16/2024 @ 03:40 PM\"}, {\"date\": \"5/1/2024 @ 03:59 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/2/2024 @ 03:59 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-01-2024 15:59:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:30:40\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 0, \"sortOrder\": 1715842083}', 1, NULL, NULL, NULL, NULL, '2024-05-01', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:17', 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
(689, 54394968, 44829497, '37129221', '0004228505001', '293628', '', '21881792', 'CARMEN', 'REIMUNDI', '', '{\"DOB\": 27206, \"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\": 1346220258, \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Zack Dillard\", \"PCP_Phone\": \"7702972200\", \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-06-26\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 JESSE JEWELL PKWY SE, Ste. 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 293628, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7705348139\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2419 Old Thompson Bridge Rd Apt K6\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305010000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2419 Old Thompson Bridge Rd Apt K6\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"REIMUNDI\", \"Medication_Review\": \"N\", \"Member_first_name\": \"CARMEN\", \"Member_Middle_name\": \"ARACELIS\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"Carmenaracelis2@gmail.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6782109686, \"Member_Identification_Number\": \"0004228505001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-09-2024 09:55:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-09 09:55:18\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-23T10:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T16:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-17T13:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-08T18:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-08T19:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-09T09:55\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-13T17:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-15T15:41\", \"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-23T10:02\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-13T17:07\", \"reportStatus_date\": \"2024-05-13T17:07\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-05-17T16:20\", \"reportStatus_date\": \"2024-05-17T13:44\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 8, \"hraStatus_date\": \"2024-05-30T17:05\", \"reportStatus_date\": null}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 6, \"hraStatus_date\": \"2024-06-07T14:45\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-08T19:33\", \"reportStatus_date\": \"2024-07-08T19:33\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-09T09:55\", \"reportStatus_date\": \"2024-07-09T09:55\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-09T09:55\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-13T17:07\", \"username\": null}, {\"date\": \"2024-05-13T17:07\", \"username\": null}, {\"date\": \"2024-05-15T15:41\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-17T09:15\", \"username\": \"SKey\"}], \"qaAssigned\": [{\"date\": \"2024-05-17T15:16\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-06-24T09:50\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-17T09:17\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:20\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:23\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:26\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:29\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:32\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:35\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:38\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:41\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:44\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:47\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:50\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:51\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:51\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:52\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:53\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:53\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:55\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:56\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:57\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:58\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:59\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T09:59\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:02\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:02\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:05\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:06\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:08\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:11\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:11\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:14\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:14\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:16\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:16\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:17\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:17\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:18\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T10:20\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T13:36\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T13:39\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T13:42\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T13:44\", \"username\": \"SKey\"}, {\"date\": \"2024-05-17T13:44\", \"username\": \"SKey\"}, {\"date\": \"2024-05-29T10:06\", \"username\": \"SKey\"}, {\"date\": \"2024-05-29T12:30\", \"username\": \"SKey\"}, {\"date\": \"2024-05-30T17:04\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-06-07T14:45\", \"username\": \"SKey\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-08T19:33\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-08T18:29\", \"username\": \"CHembrick2\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-08T19:33\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-17T16:20\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-29T10:51\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-30T17:05\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-08-2025\", \"time\": \"02:20:24\", \"value\": [{\"add\": \"2419 Old Thompson Bridge Rd Apt K6\", \"age\": 50, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-06-26\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6782109686, \"zip\": 305010000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0004228505001\", \"mzip\": 30501, \"name\": \"CARMEN ARACELIS REIMUNDI\", \"plan\": \"Alliant\", \"pphy\": \"Zack Dillard\", \"ppno\": \"7702972200\", \"race\": \"\", \"cliId\": \"\", \"email\": \"Carmenaracelis2@gmail.com\", \"ename\": \"\", \"madd1\": \"2419 Old Thompson Bridge Rd Apt K6\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 JESSE JEWELL PKWY SE, Ste. 200\", \"pcpnpi\": 1346220258, \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-05-16 01:15 PM\", \"evalName\": \"Sallie Key, FNP\", \"pcpfaxno\": \"7705348139\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Hispanic\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-17-2024\", \"time\": \"09:15:19\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-08-2025 02:20:24\"}', NULL, NULL, '{\"memberId\": \"0004228505001\", \"clinician\": \"Sallie Key\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Fri, 17 May 2024 20:20:57 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Sallie,\\nThank you for the assessment. \\n1. In the medical history, yes is answered for specialists, but there are none listed. Please use the green plus sign to drop down lines so details can be added\\n2.  Family history is blank\\n3. In the preventative care section, please add the method for breast cancer and colorectal screenings she had done\\n4.  In the medication section, please remove any medication that is no longer active using the pink minus sign\\n- In the long term use question, the member is on a statin and ASA- if these are  long term use, please select.\\n5.  The member is on ASA for CAD, but this condition is not addressed in the assessment of diagnosis, cardiovasuclar. There is a comment in the HRA that she saw a \\ncardiologist- What was she seen for? There is mention of a heart murmur in the physical exam.\\n6.  In the assessment of diagnosis, GI- \\\"other\\\" dx is selected, but there is nothing documented. \\nAlso, the member is taking Bentyl for stomach pain- please add any details.\\n7. The member is taking meclizine- Can you please address the reason she is taking this BID?\\n8.  In the assessment of diagnosis, neuro/psych, \\\"other\\\" diagnosis is selected , but there is nothing documented. If you were trying to add a comment about Zoloft use, you can use the \\ncomment bubble instead, so a blank dx does not drop down.\\n9.  IN the assessment of diagnosis, endocrine, DM, the question about complications is blank. Please update\\n- Is she followed by podiatry? In the phsyical exam, decreased sensation was reported on foot exam. Please add any details if this was discussed, any recommendations made.\\n10.  In the physical exam, otoscopic exam and heel to toe are blank. If these were not assessed , please add a comment.\\n11.  In the minicog, please select the members answers.\\n12. In the PAT form, hypothyroid and nontoxic goiter were listed. Is she being treated or followed for these conditions?\\nI am sending an email with screen shots for clarifications. We can plan to meet to review these query requests.\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 29 May 2024 14:06:28 GMT\", \"name\": \"Sallie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 29 May 2024 14:51:53 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Sallie,\\nThank you for the updates, there are still several items that need to be addressed.\\n1. The family history is blank. Please use the comment bubble to  address if the member was not able to answer\\n2.  In the medication section, add the reason and frequency for sucralfate\\n- Add the reason for Doxyxycline\\n- in the Long term use question, the member is on a statin and ASA. If these are long term use, please select.\\n3. The member is taking ASA for CAD, please add In the assessment of diagnosis, cardiovascular.\\n4. The member is seeing a GI specialist for Gastroparesis and Divertic. Please address these conditions in the Assessment of diagnosis, GI. Is the gastroparesis \\nsecondary to Diabetes? \\n- She is taking Sucralfate , bentyl and meclizine- please address in this system as well\\n5.  In the assessment of diagnosis, neuro/psych, remove the \\\"other \\\" dx which is blank, and use the comment bubble for your comment about zoloft. Leaving a blank dx\\ncauses confusion for the coders.\\nPlease reach out with any questions,\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 29 May 2024 16:30:44 GMT\", \"name\": \"Sallie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Have these not been addressed? I\'ve given all the information available.\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 30 May 2024 21:05:16 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Sallie,\\nYou did make some updates, but there are still items that need to be addressed.\\n1. In the medication section, add the reason and frequency for sucralfate\\n- Add the reason for Doxyxycline\\n- in the Long term use question, the member is on a statin and ASA. If these are long term use, please select.\\n3. The member is taking ASA for CAD, please add In the assessment of diagnosis, cardiovascular.\\n4. The member is seeing a GI specialist for Gastroparesis and Divertic. Please address these conditions in the Assessment of diagnosis, GI. Is the gastroparesis \\nsecondary to Diabetes?  \\n- The Other dx in this system is blank. \\n5.  In the assessment of diagnosis, neuro/psych, remove the \\\"other \\\" dx which is blank, and use the comment bubble for your comment about zoloft. Leaving a blank dx\\ncauses confusion for the coders.\\nPlease reach out with any questions,\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 07 Jun 2024 18:45:29 GMT\", \"name\": \"Sallie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"CARMEN REIMUNDI\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/16/2024 01:15PM\", \"clinicianMailId\": \"s.key@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/13/2024 @ 05:07 PM\", \"result\": 0, \"comment\": \"5/13/24 GM: Called to Schedule Virtual HRA with Sally Key. SCHEDULED WIFE CARMEN REIMUNDI FOR 5/16/24 F2F PM BLOCK, AND DAMIAN MERCADO IS SCHEDULED FOR 5/31/24 10:30 AM VIRTUAL  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"5/13/2024 @ 04:54 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED THE CALL PRIOR TO/AFTER GREETING. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 04:54 PM\"}, {\"date\": \"4/23/2024 @ 10:02 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/24/2024 @ 10:02 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004228505001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"37129221\", \"memberId\": \"0004228505001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"37129221\", \"memberId\": \"0004228505001\", \"scheduleDate\": \"2024-5-16T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 10:02:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-15-2024 15:41:47\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-07-09 09:55:16\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"df0af3db-3dfa-11ef-b982-a58ec300796a\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'In Person', '2024-5-16T12:30', '2024-12-31', '2024-05-16T13:15', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:17', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004228505001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004228505001_REIMUNDI, CARMEN_05162024.pdf\", \"ftp_upload_date\": \"2024-07-09 09:55:16\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Dillard, Zack_0004228505001_05162024.pdf\"}', 'ACA_0004228505001_REIMUNDI, CARMEN_05162024', NULL, 'PCP_Dillard, Zack_0004228505001_05162024', NULL, '[{\"date\": \"2024-05-17T17:44:32.194Z\", \"signature\": \"data:image/png;base64,[encoded data, 22652 characters]\"}, {\"date\": \"2024-05-29T14:06:28.665Z\", \"signature\": \"data:image/png;base64,[encoded data, 22680 characters]\"}, {\"date\": \"2024-05-29T16:30:44.096Z\", \"signature\": \"data:image/png;base64,[encoded data, 22668 characters]\"}, {\"date\": \"2024-06-07T18:45:29.017Z\", \"signature\": \"data:image/png;base64,[encoded data, 22736 characters]\"}]', '2024-05-16T14:10', 'Member_Summary_0004228505001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004228505001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004228505001.pdf\", \"member_ftp_upload_date\": \"2024-07-09 09:55:17\"}', 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
(690, 3285757, 44829497, '56716210', '0004228505002', '293629', '', '21881792', 'Damian', 'Hernandez Mercado', '', '{\"DOB\": 27140, \"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\": 1952398406, \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Ayham Haddad\", \"PCP_Phone\": 7705320800, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-04-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1080 DAWSONVILLE HWY\", \"Screening_IHA\": \"No\", \"member_id_two\": 293629, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"4047955596\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2419 Old Thompson Bridge Rd Apt K6\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305010000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2419 Old Thompson Bridge Rd Apt K6\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"Hernandez Mercado\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Damian\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6782109686, \"Member_Identification_Number\": \"0004228505002\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-13-2024 08:59:03\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-13 08:59:03\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-23T10:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T12:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T13:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T18:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-03T08:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-06T22:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-07T12:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-13T08:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-13T17:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-19T16:18\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-05-31T16:19\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-23T10:04\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-13T17:07\", \"reportStatus_date\": \"2024-05-13T17:07\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-05-31T16:19\", \"reportStatus_date\": \"2024-05-31T16:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T12:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-13T13:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T18:45\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-19T16:18\", \"reportStatus_date\": \"2024-07-19T16:18\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 8, \"hraStatus_date\": \"2024-08-05T23:14\", \"reportStatus_date\": \"2024-08-03T08:56\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-07T12:54\", \"reportStatus_date\": \"2024-08-07T12:54\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-13T08:59\", \"reportStatus_date\": \"2024-08-13T08:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-31T16:19\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-13T08:59\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-13T17:07\", \"username\": null}, {\"date\": \"2024-05-13T17:07\", \"username\": null}, {\"date\": \"2024-07-19T16:18\", \"username\": null}, {\"date\": \"2024-07-19T16:18\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-08-01T22:25\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-05T12:03\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-03T08:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-03T08:56\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-06T16:02\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-07T12:54\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-06T22:28\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-07T12:54\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-05T23:14\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"11:51:42\", \"value\": [{\"add\": \"2419 Old Thompson Bridge Rd Apt K6\", \"age\": 50, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-04-21\", \"eno\": \"6782109686\", \"lob\": \"On Exchange\", \"pno\": 6782109686, \"zip\": 305010000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0004228505002\", \"mzip\": 30501, \"name\": \"Damian Hernandez Mercado\", \"plan\": \"Alliant\", \"pphy\": \"Ayham Haddad\", \"ppno\": 7705320800, \"race\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"Carmen  Reimuidi\", \"madd1\": \"2419 Old Thompson Bridge Rd Apt K6\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1080 DAWSONVILLE HWY\", \"pcpnpi\": 1952398406, \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-08-02 03:00 PM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"4047955596\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"]], \"comment\": [[\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]]}, \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"08-01-2024\", \"time\": \"22:25:08\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"03-11-2025 02:57:03\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-31T16:19\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"SKey\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0004228505002\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Tue, 06 Aug 2024 03:14:38 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\nThank you for your thorough assessment!\\n\\n1) Under medications can you please select the medication for vitamin D deficiency\\n2) Can you please add food disparity/housing to CM referral and add to the summary please\\n3) Can you please add GERD to the assessment of diagnosis\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 06 Aug 2024 20:02:27 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Corrections made. Thank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Damian Hernandez Mercado\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/02/2024 03:00 PM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/19/2024 @ 04:18 PM\", \"result\": 0, \"comment\": \"scheduled HRA with delise adams on 8/2 at 3pm text link to member alternate number 6788613796\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/21/2024 @ 06:45 PM\", \"result\": 1, \"comment\": \"Dead air, line did not ring, nothing was heard. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/30/2024 @ 06:44 PM\"}, {\"date\": \"6/13/2024 @ 01:26 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/20/2024 @ 01:26 PM\"}, {\"date\": \"6/10/2024 @ 12:15 PM\", \"result\": 3, \"comment\": \"LVM F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/13/2024 @ 12:15 PM\"}, {\"date\": \"5/13/2024 @ 05:07 PM\", \"result\": 0, \"comment\": \"5/13/24 GM: Called to Schedule Virtual HRA with Sally Key. SCHEDULED WIFE CARMEN REIMUNDI FOR 5/16/24 F2F PM BLOCK, AND DAMIAN MERCADO IS SCHEDULED FOR 5/31/24 10:30 AM VIRTUAL \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"4/23/2024 @ 10:04 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/24/2024 @ 10:04 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0004228505002\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0004228505002\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0004228505002\", \"scheduleDate\": \"2024-8-2T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 10:04:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"05-31-2024 16:19:39\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-19-2024 16:18:30\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 0, NULL, '[{\"date\": \"2024-08-13 08:59:01\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"cfd3f406-5973-11ef-93a5-d5eea26f4b64\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-8-2T15:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:55:17', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004228505002\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0004228505002_Hernandez Mercado, Damian_08022024.pdf\", \"ftp_upload_date\": \"2024-08-13 08:59:00\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Haddad, Ayham_0004228505002_08022024.pdf\"}', 'ACA_0004228505002_Hernandez Mercado, Damian_08022024', NULL, 'PCP_Haddad, Ayham_0004228505002_08022024', NULL, '[{\"date\": \"2024-08-03T12:56:49.627Z\", \"signature\": \"data:image/png;base64,[encoded data, 23512 characters]\"}, {\"date\": \"2024-08-06T20:02:27.497Z\", \"signature\": \"data:image/png;base64,[encoded data, 23520 characters]\"}]', '2024-08-02T16:42', 'Member_Summary_0004228505002.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0004228505002\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0004228505002.pdf\", \"member_ftp_upload_date\": \"2024-08-13 08:59:03\"}', NULL, NULL, NULL, NULL);
