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
(454, NULL, NULL, NULL, '0003704476001', '270010', '', '21881792', 'MARK', 'BRUCE', '', '{\"DOB\": 22037, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1407943301, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DAWSONVILLE\", \"Pcp_Name\": \"RAMZI GHOSN\", \"PCP_Phone\": 7062658002, \"Pcp_State\": \"GA\", \"Member_City\": \"DAWSONVILLE\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DAWSONVILLE\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-05-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"73 PRESTIGE LN STE 103\", \"Screening_IHA\": \"No\", \"member_id_two\": 270010, \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6610 DAWSONVILLE HWY\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305340000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"P.O BOX 934\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Last_name\": \"BRUCE\", \"Medication_Review\": \"N\", \"Member_first_name\": \"MARK\", \"Member_Middle_name\": \"LESTER\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"131, 132, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7707815502, \"Member_Identification_Number\": \"0003704476001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:17\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-10T12:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-09-06T13:35\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-14T15:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T19:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-28T11:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-10T12:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-14T15:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T19:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-28T11:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T12:48\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-09-06T13:34\", \"reportStatus_date\": \"2024-09-06T13:34\"}]', '{\"utc\": [{\"date\": \"2024-09-06T13:34\", \"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:54:13\", \"value\": [{\"add\": \"6610 DAWSONVILLE HWY\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-05-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7707815502, \"zip\": 305340000, \"add2\": \"\", \"add3\": \"\", \"city\": \"DAWSONVILLE\", \"gend\": 0, \"insh\": \"0003704476001\", \"mzip\": 30534, \"name\": \"MARK LESTER BRUCE\", \"plan\": \"Alliant\", \"pphy\": \"RAMZI GHOSN\", \"ppno\": 7062658002, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"P.O BOX 934\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DAWSONVILLE\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"73 PRESTIGE LN STE 103\", \"pcpnpi\": 1407943301, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DAWSONVILLE\", \"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:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:33\"}', '{\"utc\": [{\"date\": \"2024-09-06T13:34\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 01:09 PM\", \"result\": 3, \"comment\": \"called for HRA-Virtual - Faith Enwefah-GA, RN,NP : LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 01:08 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/6/2024 @ 01:34 PM\", \"result\": 6, \"comment\": \"Member not available. Call attempt to schedule an HRA.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 01:26 PM\", \"result\": 3, \"comment\": \"07/29/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/10/2024 @ 12:48 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"5/28/2024 @ 11:09 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/29/2024 @ 11:09 AM\"}, {\"date\": \"5/21/2024 @ 07:26 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/27/2024 @ 07:26 PM\"}, {\"date\": \"5/14/2024 @ 03:34 PM\", \"result\": 3, \"comment\": \"VM LEFT BY LS ON 5/3\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 03:34 PM\"}, {\"date\": \"5/14/2024 @ 03:34 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 03:34 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-14-2024 15:34:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-10-2024 12:48:19\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', '{\"orderType\": 0, \"sortOrder\": 1730441194}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(455, NULL, NULL, NULL, '0003704833001', '261885', '', '21881792', 'CHIRAG', 'PATEL', '', '{\"DOB\": 30964, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1609033216, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DALTON\", \"Pcp_Name\": \"Sergio Quijano\", \"PCP_Phone\": 4044460600, \"Pcp_State\": \"GA\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"DALTON\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1984-10-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"302 POINT NORTH PL\", \"Screening_IHA\": \"No\", \"member_id_two\": 261885, \"Mailing_County\": \"WHITFIELD\", \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1815 Canterbury NW\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30720, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1815 CANTERBURY NW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30720, \"Member_Last_name\": \"PATEL\", \"Medication_Review\": \"N\", \"Member_first_name\": \"CHIRAG\", \"Member_Middle_name\": \"V\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"chiragdmj@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 8643534672, \"Member_Identification_Number\": \"0003704833001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 8643534672}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2026 23:30:25\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2026-01-01 23:30:25\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-23T14:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-02T10:06\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-05-22T10:28\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-23T14:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-02T10:06\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-22T10:28\", \"reportStatus_date\": \"2024-05-22T10:28\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-22T10:28\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:54:13\", \"value\": [{\"add\": \"1815 Canterbury NW\", \"age\": \"\", \"ano\": \"\", \"cno\": 8643534672, \"dob\": \"1984-10-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 8643534672, \"zip\": 30720, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 0, \"insh\": \"0003704833001\", \"mzip\": 30720, \"name\": \"CHIRAG V PATEL\", \"plan\": \"Alliant\", \"pphy\": \"Sergio Quijano\", \"ppno\": 4044460600, \"cliId\": \"\", \"email\": \"chiragdmj@gmail.com\", \"ename\": \"\", \"madd1\": \"1815 CANTERBURY NW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"DALTON\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"302 POINT NORTH PL\", \"pcpnpi\": 1609033216, \"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:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:33\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-22T10:28\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/22/2024 @ 10:28 AM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IN 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/2/2024 @ 10:06 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL   \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/9/2024 @ 10:06 AM\"}, {\"date\": \"4/23/2024 @ 02:56 PM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/23/2024 @ 02:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 14:56:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:30:30\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '2025-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(456, NULL, NULL, NULL, '0003705103001', '300736', '', '2661185', 'Kathryn', 'Vento', '', '{\"DOB\": 22779, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1962408997, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"COMMERCE\", \"Pcp_Name\": \"VERONICA PATTERSON\", \"PCP_Phone\": 7063567800, \"Pcp_State\": \"GA\", \"Member_City\": \"Carnesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carnesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-05-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"641 HOSPITAL RD STE 4\", \"Screening_IHA\": \"No\", \"member_id_two\": 300736, \"Member_Country\": \"Franklin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7955 Royston Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305210000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 562\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30521, \"Member_Last_name\": \"Vento\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Kathryn\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"katvento@windstream.net\", \"Member_Suspect_Codes\": \"130, 161.2, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063843594, \"Member_Identification_Number\": \"0003705103001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 6789360552}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:18\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-05-20T10:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-08-17T17:07\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-07T18:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-10T12:47\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T12:54\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T16:21\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T10:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-08-31T17:08\", \"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-13T12:54\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T10:40\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-08-17T17:07\", \"reportStatus_date\": \"2024-08-17T17:07\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-08-31T17:08\", \"reportStatus_date\": \"2024-08-31T17:08\"}]', '{\"utc\": [{\"date\": \"2024-08-17T17:07\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-08-31T17:08\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:54:13\", \"value\": [{\"add\": \"7955 Royston Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": 6789360552, \"dob\": \"1962-05-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063843594, \"zip\": 305210000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carnesville\", \"gend\": 1, \"insh\": \"0003705103001\", \"mzip\": 30521, \"name\": \"Kathryn A Vento\", \"plan\": \"Alliant\", \"pphy\": \"VERONICA PATTERSON\", \"ppno\": 7063567800, \"cliId\": \"\", \"email\": \"katvento@windstream.net\", \"ename\": \"\", \"madd1\": \"PO Box 562\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carnesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"641 HOSPITAL RD STE 4\", \"pcpnpi\": 1962408997, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"COMMERCE\", \"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:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:33\"}', '{\"utc\": [{\"date\": \"2024-08-17T17:07\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-08-31T17:08\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"8/31/2024 @ 05:08 PM\", \"result\": 9, \"comment\": \"Called to Schedule Virtual HRA with Faith but member refused.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 05:07 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Faith but member requested a call back.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 02:07 PM\", \"result\": 3, \"comment\": \"NO VM SETUP - UNABLE TO LEAVE A MESSAGE. CALL ATTEMPT TO SCHEDULE VIRTUAL HRA.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/20/2024 @ 10:40 AM\", \"result\": 3, \"comment\": \"NO VM SETUP - UNABLE TO LEAVE A MESSAGE. CALL ATTEMPT TO SCHEDULE VIRTUAL HRA.  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/16/2024 @ 04:21 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - No VM Setup \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 04:21 PM\"}, {\"date\": \"5/13/2024 @ 12:54 PM\", \"result\": 7, \"comment\": \"line was busy 5/13/24 GM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"5/20/2024 @ 12:53 PM\"}, {\"date\": \"5/10/2024 @ 12:47 PM\", \"result\": 1, \"comment\": \"Dead air, no answer- MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/13/2024 @ 12:47 PM\"}, {\"date\": \"5/7/2024 @ 06:39 PM\", \"result\": 1, \"comment\": \"Line rang, no answer, no VM options. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/8/2024 @ 06:39 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-07-2024 18:39:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-20-2024 10:40:04\", \"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:54:13', 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
(457, 50892900, 44829497, '72903859', '0003709371001', '262832', '', '2661185', 'Jerry', 'Powell', '', '{\"DOB\": 22555, \"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\": 1033115142, \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Dr. Casey Bolton, PA\", \"PCP_Phone\": \"7067548066\", \"Pcp_State\": \"GA\", \"Member_City\": \"Toccoa\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Toccoa\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-10-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 JESSE JEWELL PKWY SE\", \"Screening_IHA\": \"No\", \"member_id_two\": 262832, \"Mailing_County\": \"Stephens\", \"Member_Country\": \"Stephens\", \"PCP_Fax_Number\": \"7705334727\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1229 Joe Carter Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305770000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1229 Joe Carter Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30577, \"Member_Last_name\": \"Powell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jerry\", \"Member_Middle_name\": \"Lee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"jerrypowell@windstream.net\", \"Member_Suspect_Codes\": \"110, 13, 130, 154, 183, 184, 187, 188, 20, 21, 23, 34, 35.2, 36, 37.2, 42, 6, 74, 75\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7063083420, \"Member_Identification_Number\": \"0003709371001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:30:36\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:30:36\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-23T08:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T17:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T23:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-07T18:49\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-05-21T12:55\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-05-21T11:50\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-13T09:04\", \"reportStatus_date\": \"2024-05-07T18:49\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-27T13:45\", \"reportStatus_date\": \"2024-05-23T08:53\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:30\", \"reportStatus_date\": \"2024-05-31T14:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-05-21T11:50\", \"username\": \"SKey\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:30\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-07T18:49\", \"username\": null}, {\"date\": \"2024-05-07T18:49\", \"username\": null}, {\"date\": \"2024-05-21T12:55\", \"username\": null}, {\"date\": \"2024-05-21T12:55\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-09T14:57\", \"username\": \"SKey\"}, {\"date\": \"2024-05-21T19:11\", \"username\": \"DYork\"}], \"qaAssigned\": [{\"date\": \"2024-05-23T10:20\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-13T08:55\", \"username\": \"SKey\"}, {\"date\": \"2024-05-13T08:58\", \"username\": \"SKey\"}, {\"date\": \"2024-05-13T09:01\", \"username\": \"SKey\"}, {\"date\": \"2024-05-13T09:04\", \"username\": \"SKey\"}, {\"date\": \"2024-05-13T09:04\", \"username\": \"SKey\"}, {\"date\": \"2024-05-21T19:12\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T13:56\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T13:58\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T13:59\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:02\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:05\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:08\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:10\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:11\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:14\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:16\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:17\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:17\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:20\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:23\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:25\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:26\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:29\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:32\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:35\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:38\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:38\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:39\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:39\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:40\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:44\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:46\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:49\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:50\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:52\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:53\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:56\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:59\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T14:59\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:02\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:05\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:05\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:07\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:08\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:09\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:11\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:14\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:14\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:15\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:17\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:19\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:20\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:22\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:23\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:24\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:26\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:27\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:29\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:30\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T15:30\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:20\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:23\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:23\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:23\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:24\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:25\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:26\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:26\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:28\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:29\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:30\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:32\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:33\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:35\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:37\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:38\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:38\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:40\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:42\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:44\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:48\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:49\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:50\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:52\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:53\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:54\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:56\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:56\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:56\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:56\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:58\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T20:59\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T21:01\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T21:01\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T21:02\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T21:02\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T21:03\", \"username\": \"DYork\"}, {\"date\": \"2024-05-22T21:03\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:08\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:11\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:14\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:17\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:19\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:20\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:20\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:22\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:22\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:23\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:26\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:28\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:29\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:29\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:29\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:30\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:30\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:30\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:31\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:32\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:32\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:39\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:39\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:40\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:41\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:43\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:43\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:43\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:44\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:44\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:44\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:44\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:47\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:49\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:50\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:51\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:51\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:53\", \"username\": \"DYork\"}, {\"date\": \"2024-05-23T08:53\", \"username\": \"DYork\"}, {\"date\": \"2024-05-27T09:44\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-27T10:35\", \"username\": \"DYork\"}, {\"date\": \"2024-05-27T11:39\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-27T13:45\", \"username\": \"DYork\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-28T23:16\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-28T17:53\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-28T23:16\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-27T09:44\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-27T11:40\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-27T13:44\", \"username\": \"DYork\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-14-2025\", \"time\": \"15:37:06\", \"value\": [{\"add\": \"1229 Joe Carter Rd\", \"age\": 63, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-10-01\", \"eno\": \"706-491-2138\", \"lob\": \"On Exchange\", \"pno\": 7063083420, \"zip\": 305770000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Toccoa\", \"gend\": 0, \"insh\": \"0003709371001\", \"mzip\": 30577, \"name\": \"Jerry Lee Powell\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Casey Bolton, PA\", \"ppno\": \"7067548066\", \"race\": \"\", \"cliId\": \"\", \"email\": \"jerrypowell@windstream.net\", \"ename\": \"Lesa Bolman\", \"madd1\": \"1229 Joe Carter Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Toccoa\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 JESSE JEWELL PKWY SE\", \"pcpnpi\": \"\", \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-05-22 02:05 PM\", \"evalName\": \"Deborah York, FNP\", \"pcpfaxno\": \"7705334727\", \"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\": \"05-11-2024\", \"time\": \"03:22:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-14-2025 15:37:06\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-05-21T11:50\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"SKey\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0003709371001\", \"clinician\": \"Deborah York\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"Mon, 27 May 2024 13:49:07 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Deborah,\\n    Thanks for all you do for our members!  Please review the following, reconcile, and re-submit within 24hrs:\\nENDOCRINE-CKD secondary to diabetes-\\\"stage\\\" appears blank, please choose one of the available options (i.e. unknown); \\\"treatment\\\" appears blank, please choose one of the available options.   These details are warranted for coding.\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 27 May 2024 14:35:41 GMT\", \"name\": \"Deborah \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 27 May 2024 15:44:36 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Deborah,\\n    I just received your revision request, however, the CKD section still appears blank (?), can you ensure the data is saving(?).  It is indicated that the member has \\\"CKD Stage 2\\\" in the assessor\'s comments which will need to be documented as requested above. The \\\"treatment\\\" section also remains blank.  Thanks again.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 27 May 2024 17:45:23 GMT\", \"name\": \"Deborah \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"I\'m completing again. If it\'s still blank, I don\'t know what the problem is. \"}, \"mailId\": \"\"}], \"memberName\": \"Jerry Powell\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/22/2024 02:05 PM\", \"clinicianMailId\": \"debbiey331@yahoo.com\", \"qaAnalystMailId\": \"fcopeland@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"5/21/2024 @ 12:55 PM\", \"result\": 12, \"comment\": \"RESCHEDULED W/ DEBBIE Y ON 5/22 @ 2. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/7/2024 @ 06:49 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Sallie Key for 5/13/24 @ 9:00am.-MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0003709371001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"72903859\", \"memberId\": \"0003709371001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"72903859\", \"memberId\": \"0003709371001\", \"scheduleDate\": \"2024-5-22T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-07-2024 18:49:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-21-2024 11:50:52\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-21-2024 12:55:45\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:30:34\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"de921a7a-1f7b-11ef-bd71-e5d200c12aa1\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-5-22T14:00', '2024-12-31', '2024-05-22T14:05', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:14', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003709371001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0003709371001_Powell, Jerry_05222024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:30:34\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_PA, Casey Bolton,_0003709371001_05222024.pdf\"}', 'ACA_0003709371001_Powell, Jerry_05222024', NULL, 'PCP_PA, Casey Bolton,_0003709371001_05222024', NULL, '[{\"date\": \"2024-05-23T12:53:07.017Z\", \"signature\": \"data:image/png;base64,[encoded data, 23332 characters]\"}, {\"date\": \"2024-05-27T14:35:41.712Z\", \"signature\": \"data:image/png;base64,[encoded data, 23292 characters]\"}, {\"date\": \"2024-05-27T17:45:23.427Z\", \"signature\": \"data:image/png;base64,[encoded data, 23304 characters]\"}]', '2024-05-22T15:25', 'Member_Summary_0003709371001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003709371001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0003709371001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:30:35\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(458, NULL, NULL, NULL, '0003709642002', '270043', '', '26056802', 'James', 'Kelly', '', '{\"DOB\": 25697, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1093870354, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CEDARTOWN\", \"Pcp_Name\": \"TODD ROBINSON\", \"PCP_Phone\": 7622351000, \"Pcp_State\": \"GA\", \"Member_City\": \"Rome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-05-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"14 CHEROKEE RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 270043, \"Mailing_County\": \"Floyd\", \"Member_Country\": \"Floyd\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"16 Maplewood Sq SE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 301610000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"16 Maplewood Sq SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30161, \"Member_Last_name\": \"Kelly\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Member_Middle_name\": \"Edward\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"142, 161.2\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"9048749589\", \"Member_Identification_Number\": \"0003709642002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:18\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-09T17:15\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-18T14:35\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T13:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-28T14:52\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T17:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-06-14T13:53\", \"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-06-14T13:53\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T13:19\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-28T14:52\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T17:15\"}]', '{\"utc\": [{\"date\": \"2024-09-06T13:34\", \"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\": \"06-21-2024\", \"time\": \"01:15:17\", \"value\": [{\"add\": \"16 Maplewood Sq SE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-05-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9048749589, \"zip\": 301610000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 0, \"insh\": \"0003709642002\", \"mzip\": 30161, \"name\": \"James Edward Kelly\", \"plan\": \"Alliant\", \"pphy\": \"TODD ROBINSON\", \"ppno\": 7622351000, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"16 Maplewood Sq SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"14 CHEROKEE RD\", \"pcpnpi\": 1093870354, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CEDARTOWN\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-21-2024\", \"time\": \"01:15:17\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:17\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 02:53 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/10/2024 @ 01:56 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/  Nykya Cox \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 05:50 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 05:15 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH  OR w/ DELISE ADAMS \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/28/2024 @ 02:52 PM\", \"result\": 3, \"comment\": \"06/28/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/12/2024 @ 02:52 PM\"}, {\"date\": \"6/20/2024 @ 01:19 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBBIE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/24/2024 @ 01:19 PM\"}, {\"date\": \"6/18/2024 @ 02:35 PM\", \"result\": 3, \"comment\": \"06/18/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/21/2024 @ 02:35 PM\"}, {\"date\": \"6/14/2024 @ 01:53 PM\", \"result\": 4, \"comment\": \"Called to schedule Virtual HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-14-2024 13:53:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-09-2024 17:15:44\", \"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:54:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(459, NULL, NULL, NULL, '0003710663001', '270049', '', '21881792', 'Sonya', 'Daves', '', '{\"DOB\": 22228, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1861541898, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BLAIRSVILLE\", \"Pcp_Name\": \"THOMAS KARISNY\", \"PCP_Phone\": 7067452158, \"Pcp_State\": \"GA\", \"Member_City\": \"Morganton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Morganton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-11-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"202 HOSPITAL RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 270049, \"Mailing_County\": \"Fannin\", \"Member_Country\": \"Fannin\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2210 Daves Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305600000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2210 Daves Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30560, \"Member_Last_name\": \"Daves\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sonya\", \"Member_Middle_name\": \"Morrow\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mammydaves@yahoo.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068385966, \"Member_Identification_Number\": \"0003710663001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:18\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-11-01T14:02\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-31T16:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T17:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-07T15:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-11-01T14:02\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-07-08T13:52\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-25T15:01\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-03T17:02\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T15:57\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-25T15:01\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-08T13:52\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-01T14:02\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:54:14\", \"value\": [{\"add\": \"2210 Daves Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-11-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068385966, \"zip\": 305600000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Morganton\", \"gend\": 1, \"insh\": \"0003710663001\", \"mzip\": 30560, \"name\": \"Sonya Morrow Daves\", \"plan\": \"Alliant\", \"pphy\": \"THOMAS KARISNY\", \"ppno\": 7067452158, \"cliId\": \"\", \"email\": \"mammydaves@yahoo.com\", \"ename\": \"\", \"madd1\": \"2210 Daves Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Morganton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"202 HOSPITAL RD\", \"pcpnpi\": 1861541898, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BLAIRSVILLE\", \"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:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:33\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/1/2024 @ 02:02 PM\", \"result\": 3, \"comment\": \"6 attempt left msg-LB\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"\"}, {\"date\": \"7/8/2024 @ 01:52 PM\", \"result\": 14, \"comment\": \"F2F - CALLBACK - Member does not have virtual capabilities. Call back to schedule F2F HRA at a later time.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/10/2024 @ 01:52 PM\"}, {\"date\": \"6/25/2024 @ 03:01 PM\", \"result\": 6, \"comment\": \"06/25/2024 JC: called for HRA-Deborah (Debbie) York-Virtual: member req call back not home \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/9/2024 @ 03:01 PM\"}, {\"date\": \"6/7/2024 @ 03:57 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED VIRTUAL VISIT FOR FAITH ON 6/17 MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 03:57 PM\"}, {\"date\": \"6/3/2024 @ 05:02 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\": \"6/4/2024 @ 05:00 PM\"}, {\"date\": \"5/31/2024 @ 04:38 PM\", \"result\": 3, \"comment\": \"NO VM SETUP - Unable to leave a message. Call attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 04:38 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 16:38:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-01-2024 14:02:40\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54: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
(460, 57818338, 44829497, '62685179', '0003722873001', '313211', '', '21881792', 'Devendra', 'Patel', '', '{\"DOB\": 25035, \"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\": 1578626602, \"Pcp_Zip\": \"30134\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"DOUGLASVILLE\", \"Pcp_Name\": \"Saurabh Desai\", \"PCP_Phone\": 7709490555, \"Pcp_State\": \"GA\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-07-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"6025 PROFESSIONAL PKWY, Ste. 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 313211, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"7709498824\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1235 Mandeville Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 301170000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1235 Mandeville Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Patel\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Devendra\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"dpatel0716@aol.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4047971348, \"Member_Identification_Number\": \"0003722873001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 4047190973}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-25-2024 09:47:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-25 09:47:11\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T14:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T14:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-18T17:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-20T15:07\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-20T15:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-25T09:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-13T14:02\", \"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-29T14:56\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T14:32\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-13T14:02\", \"reportStatus_date\": \"2024-06-13T14:02\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-20T15:17\", \"reportStatus_date\": \"2024-06-20T15:17\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-25T09:47\", \"reportStatus_date\": \"2024-06-25T09:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-25T09:47\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-13T14:02\", \"username\": null}, {\"date\": \"2024-06-13T14:02\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-18T15:07\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-06-19T09:44\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-18T17:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-18T17:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-20T10:48\", \"username\": \"JSilverio\"}, {\"date\": \"2024-06-20T11:56\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-20T15:17\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-20T15:07\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-20T15:17\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-06-20T10:50\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-23-2024\", \"time\": \"15:35:14\", \"value\": [{\"add\": \"1235 Mandeville Rd\", \"age\": 56, \"ano\": \"\", \"cno\": 4047190973, \"dob\": \"1968-07-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4047971348, \"zip\": 301170000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 0, \"insh\": \"0003722873001\", \"mzip\": 30117, \"name\": \"Devendra Patel\", \"plan\": \"Alliant\", \"pphy\": \"Saurabh Desai\", \"ppno\": 7709490555, \"cliId\": \"\", \"email\": \"dpatel0716@aol.com\", \"ename\": \"Rita Patel\", \"madd1\": \"1235 Mandeville Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"6025 PROFESSIONAL PKWY, Ste. 200\", \"pcpnpi\": 1578626602, \"pcpzip\": \"30134\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"DOUGLASVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7709498824\", \"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\": \"06-18-2024\", \"time\": \"15:07:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-23-2024 15:35:14\"}', NULL, NULL, '{\"memberId\": \"0003722873001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Thu, 20 Jun 2024 14:50:26 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Exam Review neurologic sitting to standing needs answer .  Thanks Judi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 20 Jun 2024 15:56:52 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Devendra Patel\", \"codingAnalyst\": \"\", \"dateOfService\": \"06/18/2024 03:00 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/13/2024 @ 02:02 PM\", \"result\": 0, \"comment\": \"Scheduled virtual HRA w/ Faith on 6/18 @ 3 - texted link to member\'s phone.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/6/2024 @ 02:32 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 02:32 PM\"}, {\"date\": \"4/29/2024 @ 02:56 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 02:56 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0003722873001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0003722873001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0003722873001\", \"scheduleDate\": \"2024-6-18T15:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 14:56:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-13-2024 14:02:46\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-06-25 09:47:10\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6b593b3f-32f9-11ef-989e-3b2d8cf5b6d7\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-6-18T15:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:14', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003722873001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0003722873001_Patel, Devendra_06182024.pdf\", \"ftp_upload_date\": \"2024-06-25 09:47:09\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Desai, Saurabh_0003722873001_06182024.pdf\"}', 'ACA_0003722873001_Patel, Devendra_06182024', NULL, 'PCP_Desai, Saurabh_0003722873001_06182024', NULL, '[{\"date\": \"2024-06-18T21:07:49.873Z\", \"signature\": \"data:image/png;base64,[encoded data, 23420 characters]\"}, {\"date\": \"2024-06-20T15:56:51.658Z\", \"signature\": \"data:image/png;base64,[encoded data, 23408 characters]\"}]', '2024-06-18T16:00', 'Member_Summary_0003722873001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003722873001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0003722873001.pdf\", \"member_ftp_upload_date\": \"2024-06-25 09:47:10\"}', 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
(461, NULL, NULL, NULL, '0003725112001', '314718', '', '2661185', 'JAYESHKUMAR', 'PATEL', '', '{\"DOB\": 23719, \"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\": \"Rome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-12-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"550 REDMOND RD NW\", \"Screening_IHA\": \"No\", \"member_id_two\": 314718, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"15 Chateau Dr SE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30161, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"15 Chateau Dr SE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30161, \"Member_Last_name\": \"PATEL\", \"Medication_Review\": \"N\", \"Member_first_name\": \"JAYESHKUMAR\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"JANKIPATEL275@HOTMAIL.COM\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 8643239899, \"Member_Identification_Number\": \"0003725112001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 8642794549}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:18\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-06-04T13:53\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}, {\"date\": \"2024-06-11T17:50\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-22T17:34\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-22T17:34\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-04T13:53\", \"reportStatus_date\": \"2024-06-04T13:53\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-06-11T17:50\", \"reportStatus_date\": \"2024-06-11T17:50\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-06-04T13:53\", \"username\": null}, {\"date\": \"2024-06-11T17:50\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:54:15\", \"value\": [{\"add\": \"15 Chateau Dr SE\", \"age\": \"\", \"ano\": \"\", \"cno\": 8642794549, \"dob\": \"1964-12-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 8643239899, \"zip\": 30161, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 0, \"insh\": \"0003725112001\", \"mzip\": 30161, \"name\": \"JAYESHKUMAR PATEL\", \"plan\": \"Alliant\", \"pphy\": \"AMAR SINGH\", \"ppno\": 7622351000, \"cliId\": \"\", \"email\": \"JANKIPATEL275@HOTMAIL.COM\", \"ename\": \"\", \"madd1\": \"15 Chateau Dr SE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"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\": \"05-11-2024\", \"time\": \"03:22:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:33\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-06-04T13:53\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}, {\"date\": \"2024-06-11T17:50\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 6, \"callLog\": [{\"date\": \"7/31/2024 @ 03:38 PM\", \"result\": 6, \"comment\": \"well need an interpreter \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"8/1/2024 @ 03:38 PM\"}, {\"date\": \"6/11/2024 @ 02:50 PM\", \"result\": 9, \"comment\": \"06/11/2024 JC: called for HRA- Faith Enwefah - Virtual: per perv note - Daughter Janki said her dad sees doctors every 3 months and will not need HRA for the year. She also isnt able to go help with appt because she lives in a different state. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/4/2024 @ 01:53 PM\", \"result\": 9, \"comment\": \"6/4/24 GM: Calling to schedule HRA w Faith 6/12 OR 6/13.  Daughter Janki said her dad sees doctors every 3 months and will not need HRA for the year. She also isnt able to go help with appt because she lives in a different state.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"4/22/2024 @ 05:34 PM\", \"result\": 6, \"comment\": \"Spoke w/member\'s daughter, Janki (pronounced like Jan-key), she pays the bills and takes care of things for her father. She lives about 4 hours from father and would have to help with the appt. She\'s going to speak with him and ask what he\'d like to do and give us a call back. I told her if I don\'t hear from her I will call her back on Friday. It\'s hard for her to get to him on week days a lot because she has kids so they\'d have to work out a good time as well. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 05:28 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-22-2024 17:34:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:30:30\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', '{\"orderType\": 0, \"sortOrder\": 1722495241}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(462, 57818338, 44829497, '62685179', '0003726673001', '270138', '', '2661185', 'Vaughn', 'Estes', '', '{\"DOB\": 24365, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1386710085, \"Pcp_Zip\": \"30525\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"EDWARD FREDERICKSON\", \"PCP_Phone\": \"7062120390\", \"Pcp_State\": \"GA\", \"Member_City\": \"Sky Valley\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Sky Valley\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-09-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"156 N MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 270138, \"Mailing_County\": \"RABUN\", \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"7069609209\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"169 Alex Mtn\", \"Member_Address2\": 436, \"Member_Zip_Code\": 30537, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"169 Alex Mtn\", \"Mailing_Address2\": 436, \"Mailing_Zip_Code\": 30537, \"Member_Last_name\": \"Estes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Vaughn\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"vaughn296@gmail.com\", \"Member_Suspect_Codes\": \"130, 21, 22, 75\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7703284692, \"Member_Identification_Number\": \"0003726673001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-23-2024 11:15:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-23 11:15:04\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-07T18:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T16:27\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-07-09T13:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-10T13:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-10T14:21\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-23T11:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-20T10:35\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-06-25T15:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-06-07T13:44\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-07T18:51\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-20T10:35\", \"reportStatus_date\": \"2024-05-20T10:35\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-29T05:37\", \"reportStatus_date\": null}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-06-07T13:44\", \"reportStatus_date\": \"2024-06-07T13:44\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-25T15:07\", \"reportStatus_date\": \"2024-06-25T15:07\"}, {\"text\": null, \"type\": \"HraStatus\", \"status\": null, \"hraStatus\": 2, \"hraStatus_date\": \"2024-07-08T14:03\", \"reportStatus_date\": null}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-10T14:21\", \"reportStatus_date\": \"2024-07-10T14:21\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-23T11:15\", \"reportStatus_date\": \"2024-07-23T11:15\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-06-07T13:44\", \"username\": \"AWalsh\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-23T11:15\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-20T10:35\", \"username\": null}, {\"date\": \"2024-05-20T10:35\", \"username\": null}, {\"date\": \"2024-06-25T15:07\", \"username\": null}, {\"date\": \"2024-06-25T15:07\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-29T05:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-08T14:03\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-07-09T14:21\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-07-09T13:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-09T13:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-07-10T09:08\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-10T14:21\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-10T13:34\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-10T14:21\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-07-09T19:06\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-06-2024\", \"time\": \"16:49:33\", \"value\": [{\"add\": \"169 Alex Mtn\", \"age\": 57, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-09-15\", \"eno\": \"404 313 2100\", \"lob\": \"On Exchange\", \"pno\": 7703284692, \"zip\": 30537, \"add2\": 436, \"add3\": \"\", \"city\": \"Sky Valley\", \"gend\": 0, \"insh\": \"0003726673001\", \"mzip\": 30537, \"name\": \"Vaughn Estes\", \"plan\": \"Alliant\", \"pphy\": \"EDWARD FREDERICKSON\", \"ppno\": \"7062120390\", \"cliId\": \"\", \"email\": \"vaughn296@gmail.com\", \"ename\": \"Kammy Estes\", \"madd1\": \"169 Alex Mtn\", \"madd2\": 436, \"madd3\": \"\", \"mcity\": \"Sky Valley\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"156 N MAIN ST\", \"pcpnpi\": 1386710085, \"pcpzip\": \"30525\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"CLAYTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7069609209\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-29-2024\", \"time\": \"05:37:14\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-06-2024 16:49:33\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-06-07T13:44\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"AWalsh\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0003726673001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Tue, 09 Jul 2024 23:06:23 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Medications psoriasis topical cream please add dose.  \\n2.  Home Safety members gait needs answer.\\nThanks\\nJudi \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 10 Jul 2024 13:08:07 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Thank you.\\nResolved\"}, \"mailId\": \"\"}], \"memberName\": \"Vaughn Estes\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/29/2024 10:30 AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/25/2024 @ 03:07 PM\", \"result\": 0, \"comment\": \"SCHEDULED VISIT WITH FAITH ON 7/9 AT 10:30AM SENDING LINK VIA TEXT \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"5/20/2024 @ 10:35 AM\", \"result\": 0, \"comment\": \"SCHEDULED FAITH E. ON 5/29 @ 12:30 - TEXTED DOXY LINK TO MEMBERS PHONE. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/16/2024 @ 04:27 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - VM Full \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 04:26 PM\"}, {\"date\": \"5/7/2024 @ 06:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/8/2024 @ 06:51 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0003726673001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0003726673001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0003726673001\", \"scheduleDate\": \"2024-7-9T10:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-07-2024 18:51:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"06-07-2024 13:44:17\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-25-2024 15:07:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2024-07-16 09:48:55\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"24c95506-437a-11ef-bda0-69acdc22076c\\\",\\\"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}}, {\"date\": \"2024-07-16 10:56:33\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"97540f57-4383-11ef-a545-6f76626a1271\\\",\\\"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}}, {\"date\": \"2024-07-23 10:53:56\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"63020201-4903-11ef-a545-ff7e1c275f31\\\",\\\"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\": \"null\"}, {\"date\": \"2024-07-23 11:15:02\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"55b98e6a-4906-11ef-b982-03217023803e\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-7-9T10:30', '2024-12-31', '2024-05-29T10:30', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:15', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003726673001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0003726673001_Estes, Vaughn_07092024.pdf\", \"ftp_upload_date\": \"2024-07-23 11:15:02\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_FREDERICKSON, EDWARD_0003726673001_07092024.pdf\"}', 'ACA_0003726673001_Estes, Vaughn_07092024', NULL, 'PCP_FREDERICKSON, EDWARD_0003726673001_07092024', NULL, '[{\"date\": \"2024-07-09T17:37:52.479Z\", \"signature\": \"data:image/png;base64,[encoded data, 23404 characters]\"}, {\"date\": \"2024-07-10T13:08:07.063Z\", \"signature\": \"data:image/png;base64,[encoded data, 23444 characters]\"}]', '2024-07-09T11:30', 'Member_Summary_0003726673001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003726673001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0003726673001.pdf\", \"member_ftp_upload_date\": \"2024-07-23 11:15:03\"}', 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
(463, NULL, NULL, NULL, '0003726673003', '257342', '', '543416', 'Tammy', 'Estes', '', '{\"DOB\": 24069, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1386710085, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"EDWARD FREDERICKSON\", \"PCP_Phone\": 7067824799, \"Pcp_State\": \"GA\", \"Member_City\": \"Sky Valley\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Sky Valley\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-11-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"156 N MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 257342, \"Mailing_County\": \"RABUN\", \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"169 Alex Mtn\", \"Member_Address2\": 436, \"Member_Zip_Code\": 30537, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"169 Alex Mtn\", \"Mailing_Address2\": 436, \"Mailing_Zip_Code\": 30537, \"Member_Last_name\": \"Estes\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tammy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"2028305308\", \"Member_Identification_Number\": \"0003726673003\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:18\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T14:09\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-12T19:00\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T12:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-20T13:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-25T15:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T14:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-17T12:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-20T13:18\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-25T15:09\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T14:09\"}]', '{\"utc\": [{\"date\": \"2024-09-06T13:34\", \"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\": \"06-21-2024\", \"time\": \"01:15:18\", \"value\": [{\"add\": \"169 Alex Mtn\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-11-23\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2028305308, \"zip\": 30537, \"add2\": 436, \"add3\": \"\", \"city\": \"Sky Valley\", \"gend\": 1, \"insh\": \"0003726673003\", \"mzip\": 30537, \"name\": \"Tammy Estes\", \"plan\": \"Alliant\", \"pphy\": \"EDWARD FREDERICKSON\", \"ppno\": 7067824799, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"169 Alex Mtn\", \"madd2\": 436, \"madd3\": \"\", \"mcity\": \"Sky Valley\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"156 N MAIN ST\", \"pcpnpi\": 1386710085, \"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\": \"06-21-2024\", \"time\": \"01:15:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 01:15:18\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"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:30 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:28 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA with Delise Adams LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lana Malone\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 12:29 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 07:15 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 02:09 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/25/2024 @ 03:09 PM\", \"result\": 3, \"comment\": \"06/25/2024 JC: called for HRA-Deborah (Debbie) York-Virtual: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/9/2024 @ 03:08 PM\"}, {\"date\": \"6/20/2024 @ 01:18 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Nykya Cox \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/27/2024 @ 01:18 PM\"}, {\"date\": \"6/17/2024 @ 12:32 PM\", \"result\": 3, \"comment\": \"06/17/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/21/2024 @ 12:31 PM\"}, {\"date\": \"6/12/2024 @ 07:00 PM\", \"result\": 3, \"comment\": \"06/12/2024 JC: called for HRA-Faith Enwefah-Virtual: No VM set up \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/13/2024 @ 07:00 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-12-2024 19:00:00\", \"schedulerId\": \"543416\", \"schedulerLeadId\": \"543416\"}]}', '{\"date\": \"07-03-2024 14:09:38\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 12}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(464, 57818338, 44829497, '96917241', '0003730378001', '270159', '', '21881792', 'Alexander', 'Pearce', '', '{\"DOB\": 25871, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1982643177, \"Pcp_Zip\": \"30701\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"Calhoun \", \"Pcp_Name\": \"Victoria Chung\", \"PCP_Phone\": \"(706) 625-0333\", \"Pcp_State\": \"GA\", \"Member_City\": \"Resaca\", \"Office_Name\": \"Advent Health Owasa Family Practice \", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Resaca\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-10-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"109 Hospital Drive \", \"Screening_IHA\": \"No\", \"member_id_two\": 270159, \"Mailing_County\": \"Whitfield\", \"Member_Country\": \"Whitfield\", \"PCP_Fax_Number\": \"7066251269\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"504 Thornberry Dr\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": 307350000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"504 Thornberry Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30735, \"Member_Last_name\": \"Pearce\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Alexander\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"tammyp2000@yahoo.com\", \"Member_Suspect_Codes\": \"130, 132, 142, 160, 161.2, 21, 30, 75\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"7062632137\", \"Member_Identification_Number\": \"0003730378001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 7065815248}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'0', '{\"date\": \"01-01-2025 22:00:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2025-01-01 22:00:59\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-23T10:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-09T13:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-12-21T13:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-28T09:58\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-12-29T14:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2025-01-01T22:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-12-09T16:43\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-04-25T13:15\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-08-20T13:09\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T13:15\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-23T10:46\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-09T13:11\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-12-09T16:43\", \"reportStatus_date\": \"2024-12-09T16:43\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-12-21T13:05\", \"reportStatus_date\": \"2024-12-21T13:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-12-29T14:23\", \"reportStatus_date\": \"2024-12-29T14:23\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2025-01-01T22:00\", \"reportStatus_date\": \"2025-01-01T22:00\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2025-01-01T22:00\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-12-09T16:43\", \"username\": null}, {\"date\": \"2024-12-09T16:43\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-12-21T12:04\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-12-23T08:54\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-12-21T13:05\", \"username\": \"NCox\"}, {\"date\": \"2024-12-21T13:05\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-12-29T14:23\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-12-28T09:58\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-12-29T14:23\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-16-2025\", \"time\": \"15:53:24\", \"value\": [{\"add\": \"504 Thornberry Dr\", \"age\": 54, \"ano\": \"\", \"cno\": 7065815248, \"dob\": \"1970-10-30\", \"eno\": \"7065815248\", \"lob\": \"On Exchange\", \"pno\": \"7062632137\", \"zip\": 307350000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Resaca\", \"gend\": 0, \"insh\": \"0003730378001\", \"mzip\": 30735, \"name\": \"Alexander A Pearce\", \"plan\": \"Alliant\", \"pphy\": \"Victoria Chung\", \"ppno\": \"(706) 625-0333\", \"race\": \"\", \"cliId\": \"\", \"email\": \"tammyp2000@yahoo.com\", \"ename\": \"Tammy Pearce \", \"madd1\": \"504 Thornberry Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Resaca\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"109 Hospital Drive \", \"pcpnpi\": \"\", \"pcpzip\": \"30701\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"Calhoun \", \"pcpname\": \"Advent Health Owasa Family Practice \", \"program\": \"ACA\", \"evalDate\": \"2024-12-21 12:00 PM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"7066251269\", \"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\": [true], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"12-21-2024\", \"time\": \"12:04:47\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-24-2025 08:54:38\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"12/9/2024 @ 04:43 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA with Nykya on December 21st at 12:00PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Fantashia Beckford\", \"callbackDate\": \"\"}, {\"date\": \"10/9/2024 @ 01:11 PM\", \"result\": 3, \"comment\": \"LVM to schedule with Connie Middleton for HRA-LLA\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Laura Anguiano\", \"callbackDate\": \"10/16/2024 @ 01:11 PM\"}, {\"date\": \"8/23/2024 @ 10:46 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a f2f/virtual HRA w/Deborah York.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"8/26/2024 @ 10:46 AM\"}, {\"date\": \"8/20/2024 @ 01:09 PM\", \"result\": 6, \"comment\": \"Called to Schedule Virtual HRA with Connie but member requested a call back this afternoon around 4:00PM\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"8/20/2024 @ 02:09 PM\"}, {\"date\": \"4/25/2024 @ 01:15 PM\", \"result\": 14, \"comment\": \"MEMBER NOT AVAILABLE UNTIL LATE EVENING AFTER 7 P.M.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/10/2024 @ 01:15 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0003730378001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0003730378001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0003730378001\", \"scheduleDate\": \"2024-12-21T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 13:15:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"12-09-2024 16:43:19\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', NULL, 0, NULL, NULL, 'Virtual', '2024-12-21T12:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:16', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003730378001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0003730378001_Pearce, Alexander_12212024.pdf\", \"ftp_upload_date\": \"2025-01-01 22:00:57\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Chung, Victoria_0003730378001_12212024.pdf\"}', 'ACA_0003730378001_Pearce, Alexander_12212024', NULL, 'PCP_Chung, Victoria_0003730378001_12212024', NULL, '[{\"date\": \"2024-12-21T18:05:32.309Z\", \"signature\": \"data:image/png;base64,[encoded data, 25456 characters]\"}]', '2024-12-21T13:05', 'Member_Summary_0003730378001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003730378001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0003730378001.pdf\", \"member_ftp_upload_date\": \"2025-01-01 22:00:59\"}', 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
(465, 57818338, 44829497, '62685179', '0003736728001', '218844', '', '21881792', 'Gregory', 'DENT', '', '{\"DOB\": 24224, \"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\": 1003896416, \"Pcp_Zip\": \"31210\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"Dr. FREDDY GATON\", \"PCP_Phone\": 4784710089, \"Pcp_State\": \"GA\", \"Member_City\": \"Roberta\", \"Office_Name\": \"North Macon Family Health Associates\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Roberta\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-04-27\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"540 CHARTER BLVD STE 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 218844, \"Mailing_County\": \"Crawford\", \"Member_Country\": \"Crawford\", \"PCP_Fax_Number\": \"4784710708\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"77 Beech Blvd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 310780000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"77 Beech Blvd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31078, \"Member_Last_name\": \"DENT\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gregory\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"GREGORYDENT84@GMAIL.COM\", \"Member_Suspect_Codes\": \"130, 138, 139, 142, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4782837885, \"Member_Identification_Number\": \"0003736728001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-18-2024 23:11:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-18 23:11:00\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T16:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-17T11:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T22:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T22:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-18T23:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-10T13:22\", \"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-30T16:53\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-10T13:22\", \"reportStatus_date\": \"2024-06-10T13:22\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-06-17T11:14\", \"reportStatus_date\": \"2024-06-17T11:14\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-18T23:11\", \"reportStatus_date\": \"2024-06-18T23:11\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-18T23:11\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-10T13:22\", \"username\": null}, {\"date\": \"2024-06-10T13:22\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-16T05:50\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-06-17T19:12\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-06-17T11:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-06-17T11:14\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-18T22:43\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-18T22:06\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-18T22:43\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-24-2025\", \"time\": \"00:22:25\", \"value\": [{\"add\": \"77 Beech Blvd\", \"age\": 58, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-04-27\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4782837885, \"zip\": 310780000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Roberta\", \"gend\": 0, \"insh\": \"0003736728001\", \"mzip\": 31078, \"name\": \"Gregory DENT\", \"plan\": \"Alliant\", \"pphy\": \"Dr. FREDDY GATON\", \"ppno\": 4784710089, \"cliId\": \"\", \"email\": \"GREGORYDENT84@GMAIL.COM\", \"ename\": \"\", \"madd1\": \"77 Beech Blvd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Roberta\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"540 CHARTER BLVD STE 100\", \"pcpnpi\": 1003896416, \"pcpzip\": \"31210\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"MACON\", \"pcpname\": \"North Macon Family Health Associates\", \"program\": \"ACA\", \"pcpfaxno\": \"4784710708\", \"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\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-16-2024\", \"time\": \"05:50:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"04-24-2025 03:42:16\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/10/2024 @ 10:22 AM\", \"result\": 0, \"comment\": \"06/10/2024 JC: called for HRA- Faith Enwefah - Virtual: - Virtual: scheduled for 06/17/2024 @ 9am-10am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"4/30/2024 @ 04:53 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/1/2024 @ 04:53 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0003736728001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0003736728001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0003736728001\", \"scheduleDate\": \"2024-6-17T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 16:53:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-10-2024 13:22:40\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-06-18 23:10:58\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"8cbf1eaa-2de9-11ef-aa38-f91266509c20\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-6-17T09:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:16', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003736728001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0003736728001_DENT, Gregory_06172024.pdf\", \"ftp_upload_date\": \"2024-06-18 23:10:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_GATON, FREDDY_0003736728001_06172024.pdf\"}', 'ACA_0003736728001_DENT, Gregory_06172024', NULL, 'PCP_GATON, FREDDY_0003736728001_06172024', NULL, '[{\"date\": \"2024-06-17T15:14:52.645Z\", \"signature\": \"data:image/png;base64,[encoded data, 23356 characters]\"}]', '2024-06-17T10:02', 'Member_Summary_0003736728001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003736728001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0003736728001.pdf\", \"member_ftp_upload_date\": \"2024-06-18 23:10:59\"}', NULL, NULL, NULL, NULL),
(466, NULL, NULL, NULL, '0003737335001', '212739', '', '21881792', 'Charles', 'Barker', '', '{\"DOB\": 25197, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1013302561, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DALTON\", \"Pcp_Name\": \"ALEJANDRA STAUBS\", \"PCP_Phone\": \"\", \"Pcp_State\": \"GA\", \"Member_City\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dalton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-12-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1107 MEMORIAL DR STE G2\", \"Screening_IHA\": \"No\", \"member_id_two\": 212739, \"Mailing_County\": \"Whitfield\", \"Member_Country\": \"Whitfield\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1120 Good Hope Rd NE\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307210000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1120 Good Hope Rd NE\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30721, \"Member_Last_name\": \"Barker\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Charles\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ceb2568@gmail.com\", \"Member_Suspect_Codes\": \"130, 146, 20, 21, 22\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064832742, \"Member_Identification_Number\": \"0003737335001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:31:18\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:31:18\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-08-02T12:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [{\"date\": \"2024-05-22T10:30\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}, {\"date\": \"2024-06-11T15:04\", \"text\": \"F2F Call Back\", \"method\": \"api\", \"status\": 10}], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-04-23T15:00\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-23T15:00\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-22T10:30\"}, {\"text\": \"F2F Call Back\", \"type\": \"ReportStatus\", \"status\": 10, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T15:04\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-02T12:19\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:41\"}]', '{\"utc\": [{\"date\": \"2024-09-06T13:34\", \"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:54:16\", \"value\": [{\"add\": \"1120 Good Hope Rd NE\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-12-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064832742, \"zip\": 307210000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 0, \"insh\": \"0003737335001\", \"mzip\": 30721, \"name\": \"Charles Barker\", \"plan\": \"Alliant\", \"pphy\": \"ALEJANDRA STAUBS\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"ceb2568@gmail.com\", \"ename\": \"\", \"madd1\": \"1120 Good Hope Rd NE\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dalton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1107 MEMORIAL DR STE G2\", \"pcpnpi\": 1013302561, \"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:33\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:22:33\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 10:24 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 12:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"8/9/2024 @ 12:19 PM\"}, {\"date\": \"6/11/2024 @ 03:04 PM\", \"result\": 14, \"comment\": \"4/23 - member requested a call back in fall.  - placed member as a F2F call back. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 03:03 PM\"}, {\"date\": \"5/22/2024 @ 10:30 AM\", \"result\": 14, \"comment\": \"PREVIOUS CALL MEMBER STATED DUE TO CURRENT SCHEDULE CAN NOT COMMIT TO A DATE AND TIME. MEMBER REQUESTED A CALL BACK IN THE FALL. PLACED MEMBER AS A F2F CALLBACK. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"8/26/2024 @ 10:30 AM\"}, {\"date\": \"4/23/2024 @ 03:00 PM\", \"result\": 6, \"comment\": \"MEMBER STATED THAT DUE TO CURRENT SCHEDULE CAN NOT COMMIT TO A DATE AND TIME. MEMBER REQUESTED A CALL BACK IN THE FALL. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"9/3/2024 @ 03:00 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 15:00:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"11-11-2024 00:41:54\", \"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:54: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
(467, 50892900, 44829497, '96917241', '0003741338001', '243213', '', '26056802', 'Richard', 'Russell', '', '{\"DOB\": 22090, \"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\": 1245323468, \"Pcp_Zip\": \"30143\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"JASPER\", \"Pcp_Name\": \"Dr. ANIL YADAV\", \"PCP_Phone\": 7066929768, \"Pcp_State\": \"GA\", \"Member_City\": \"Jasper\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Jasper\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1960-06-23\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"51 GORDON RD STE 201\", \"Screening_IHA\": \"No\", \"member_id_two\": 243213, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"7066924040\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"859 Lower Sassafras Pkwy\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30143, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"859 Lower Sassafras Pkwy\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30143, \"Member_Last_name\": \"Russell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Richard\", \"Member_Middle_name\": \"Philip\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"erinlearussell@gmail.com\", \"Member_Suspect_Codes\": \"21, 56, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 2059025342, \"Member_Identification_Number\": \"0003741338001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"05-31-2024 14:30:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:30:42\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-15T12:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-18T18:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-24T08:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-24T08:57\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:30\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-15T17:45\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-16T15:52\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-18T18:31\", \"reportStatus_date\": \"2024-05-18T18:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-24T08:57\", \"reportStatus_date\": \"2024-05-24T08:57\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:30\", \"reportStatus_date\": \"2024-05-31T14:30\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:30\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-15T17:45\", \"username\": null}, {\"date\": \"2024-05-15T17:45\", \"username\": null}, {\"date\": \"2024-05-16T15:52\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-18T10:47\", \"username\": \"NCox\"}], \"qaAssigned\": [{\"date\": \"2024-05-19T11:46\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-18T10:50\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T10:53\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T10:56\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T10:59\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:02\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:05\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:08\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:11\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:14\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:17\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:20\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:23\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:26\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:29\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:31\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:32\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:32\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:36\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:39\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:42\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:44\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:44\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T11:44\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:17\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:20\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:23\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:26\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:29\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:31\", \"username\": \"NCox\"}, {\"date\": \"2024-05-18T18:31\", \"username\": \"NCox\"}, {\"date\": \"2024-05-22T17:32\", \"username\": \"NCox\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-24T08:57\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-24T08:18\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-24T08:57\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-21T13:17\", \"username\": \"fcopeland1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-28-2024\", \"time\": \"13:03:35\", \"value\": [{\"add\": \"859 Lower Sassafras Pkwy\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1960-06-23\", \"eno\": \"2059025342\", \"lob\": \"On Exchange\", \"pno\": 2059025342, \"zip\": 30143, \"add2\": \"\", \"add3\": \"\", \"city\": \"Jasper\", \"gend\": 0, \"insh\": \"0003741338001\", \"mzip\": 30143, \"name\": \"Richard Philip Russell\", \"plan\": \"Alliant\", \"pphy\": \"Dr. ANIL YADAV\", \"ppno\": 7066929768, \"race\": \"\", \"cliId\": \"\", \"email\": \"erinlearussell@gmail.com\", \"ename\": \"Erin Russell \", \"madd1\": \"859 Lower Sassafras Pkwy\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Jasper\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"51 GORDON RD STE 201\", \"pcpnpi\": 1245323468, \"pcpzip\": \"30143\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"JASPER\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-5-18 10:30 AM\", \"evalName\": \"Nykya Cox, FNP\", \"pcpfaxno\": \"7066924040\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Jewish\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-17-2024\", \"time\": \"17:35:18\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-28-2024 13:03:35\"}', NULL, NULL, '{\"memberId\": \"0003741338001\", \"clinician\": \"Nykya Cox\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"Tue, 21 May 2024 17:21:49 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1. DEMOGRAPHICS-Marital Status-appears blank\\n2. EMERGENCY CONTACT-please contact the member to obtain data or indicate \\\"unknown.\\\"  This is a required field\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 22 May 2024 21:32:48 GMT\", \"name\": \"Nykya \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}], \"memberName\": \"Richard Russell\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/18/2024 10:30 AM\", \"clinicianMailId\": \"n.cox@focuscares.com\", \"qaAnalystMailId\": \"fcopeland@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/15/2024 @ 05:45 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Nykya Cox on 5/18 - 9am - 1130am - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"5/15/2024 @ 12:25 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Nykea Cox - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/22/2024 @ 12:25 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0003741338001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0003741338001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0003741338001\", \"scheduleDate\": \"2024-5-18T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 12:25:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-16-2024 15:52:55\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:30:40\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"e22c5831-1f7b-11ef-8dfc-c72e6b0395f1\\\",\\\"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-18T10:30', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:54:16', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003741338001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0003741338001_Russell, Richard_05182024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:30:40\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_YADAV, ANIL_0003741338001_05182024.pdf\"}', 'ACA_0003741338001_Russell, Richard_05182024', NULL, 'PCP_YADAV, ANIL_0003741338001_05182024', NULL, '[{\"date\": \"2024-05-18T22:31:35.492Z\", \"signature\": \"data:image/png;base64,[encoded data, 25480 characters]\"}, {\"date\": \"2024-05-22T21:32:48.619Z\", \"signature\": \"data:image/png;base64,[encoded data, 25488 characters]\"}]', '2024-05-18T11:40', 'Member_Summary_0003741338001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0003741338001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0003741338001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:30:42\"}', NULL, NULL, NULL, NULL);
