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
(2288, NULL, NULL, NULL, '0007336118001', '410483', '', '21881792', 'Karen', 'Queen', '', '{\"DOB\": 28317, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Epworth\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Epworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-07-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 410483, \"Mailing_County\": \"FANNIN\", \"Member_Country\": \"FANNIN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"119 Lottie Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30541, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"119 Lottie Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30541, \"Member_Last_name\": \"Queen\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Karen\", \"Member_Middle_name\": \"Renee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"stephenq_een@yahoo.com\", \"Member_Suspect_Codes\": 75, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064551102, \"Member_Identification_Number\": \"0007336118001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:15\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:15\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-05-31T15:23\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-31T15:23\", \"reportStatus_date\": \"2024-05-31T15:23\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-31T15:23\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:23\", \"value\": [{\"add\": \"119 Lottie Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-07-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064551102, \"zip\": 30541, \"add2\": \"\", \"add3\": \"\", \"city\": \"Epworth\", \"gend\": 1, \"insh\": \"0007336118001\", \"mzip\": 30541, \"name\": \"Karen Renee Queen\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"stephenq_een@yahoo.com\", \"ename\": \"\", \"madd1\": \"119 Lottie Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Epworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:42\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-31T15:23\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/31/2024 @ 03:23 PM\", \"result\": 9, \"comment\": \"REFUSAL - Member declined offer to schedule HRA in 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-31-2024 15:23:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:56\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2289, NULL, NULL, NULL, '0007336177001', '412289', '', '26056802', 'Sheena', 'Henderson', '', '{\"DOB\": 32547, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Ellaville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Ellaville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1989-02-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412289, \"Mailing_County\": \"SCHLEY\", \"Member_Country\": \"SCHLEY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6647 Ga 26 West\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31806, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6647 Ga 26 West\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31806, \"Member_Last_name\": \"Henderson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Sheena\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"srhenderson21@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7063304926, \"Member_Identification_Number\": \"0007336177001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:15\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:15\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-12-16T00:28\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-16T12:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T15:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T11:37\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-01T16:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-17T15:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-31T18:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-12-16T00:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-07-03T12:54\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-07-11T09:33\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T15:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T11:37\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T16:23\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-03T12:54\", \"reportStatus_date\": \"2024-07-03T12:54\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-07-11T09:33\", \"reportStatus_date\": \"2024-07-11T09:33\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T15:51\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-31T18:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:52\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-12-16T00:28\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:33\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-03T12:54\", \"username\": null}, {\"date\": \"2024-07-03T12:54\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:24\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-09-2024\", \"time\": \"15:24:53\", \"value\": [{\"add\": \"6647 Ga 26 West\", \"age\": 35, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1989-02-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7063304926, \"zip\": 31806, \"add2\": \"\", \"add3\": \"\", \"city\": \"Ellaville\", \"gend\": 1, \"insh\": \"0007336177001\", \"mzip\": 31806, \"name\": \"Sheena Henderson\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"srhenderson21@gmail.com\", \"ename\": \"\", \"madd1\": \"6647 Ga 26 West\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Ellaville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-09-2024\", \"time\": \"15:24:53\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"10-05-2024 18:37:56\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-07-11T09:33\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 04:21 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 03:13 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"8/10/2024 @ 06:58 PM\"}, {\"date\": \"7/17/2024 @ 03:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/18/2024 @ 03:51 PM\"}, {\"date\": \"7/3/2024 @ 12:54 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/1/2024 @ 04:23 PM\", \"result\": 3, \"comment\": \"Unable to leave a message. Call attempt to schedule virtual HRA w/ Delise Adams. \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"7/2/2024 @ 04:22 PM\"}, {\"date\": \"5/21/2024 @ 11:37 AM\", \"result\": 3, \"comment\": \"MAILBOX FULL - UNABLE TO LEAVE A MESSAGE.\", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 11:37 AM\"}, {\"date\": \"5/17/2024 @ 03:29 PM\", \"result\": 3, \"comment\": \"Called member to set up Virtual HRA with Sallie Key \", \"inBound\": false, \"noAnswer\": 1, \"scheduler\": \"Tinera Henderson\", \"callbackDate\": \"5/24/2024 @ 03:29 PM\"}, {\"date\": \"5/16/2024 @ 12:37 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 @ 12:37 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-16-2024 12:37:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"07-11-2024 09:33:50\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"12-16-2024 00:28:36\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, 'Virtual', NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:24', 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
(2290, 57818338, 44829497, '56716210', '0007342414001', '415355', '', '26056802', 'Christy', 'Murphy', '', '{\"DOB\": 29746, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30833\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"Wrens\", \"Pcp_Name\": \"Nancy Cox\", \"PCP_Phone\": \"7065476409\", \"Member_City\": \"Gibson\", \"Office_Name\": \"Wrens Physician Health Group\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gibson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1981-06-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"400 Canterbury Dr \", \"Screening_IHA\": \"No\", \"member_id_two\": 415355, \"Mailing_County\": \"GLASCOCK\", \"Member_Country\": \"GLASCOCK\", \"PCP_Fax_Number\": \"7065479870\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1266 GA Highway 102 E\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": 30810, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1266 GA Highway 102 E\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30810, \"Member_Last_name\": \"Murphy\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Christy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"chrismarie2600@gmail.com\", \"Member_Suspect_Codes\": \"21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7064664045, \"Member_Identification_Number\": \"0007342414001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"(706) 595-6637\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"08-13-2024 08:59:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-08-13 08:59:44\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-16T12:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T15:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-21T11:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-08-06T09:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-07T20:52\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-08T13:10\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-08-13T08:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-28T13:24\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-31T19:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-07-16T13:51\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-17T15:53\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [{\"date\": \"2024-07-11T09:43\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-17T15:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-21T11:39\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-28T13:24\", \"reportStatus_date\": \"2024-06-28T13:24\"}, {\"text\": \"Virtual No Show\", \"type\": \"ReportStatus\", \"status\": 23, \"hraStatus\": 19, \"hraStatus_date\": \"2024-07-11T09:43\", \"reportStatus_date\": \"2024-07-11T09:43\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-17T15:53\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-08-05T22:27\", \"reportStatus_date\": \"2024-07-31T19:07\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-08-08T13:10\", \"reportStatus_date\": \"2024-08-08T13:10\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-08-13T08:59\", \"reportStatus_date\": \"2024-08-13T08:59\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:43\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-08-13T08:59\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-28T13:24\", \"username\": null}, {\"date\": \"2024-06-28T13:24\", \"username\": null}, {\"date\": \"2024-07-31T19:07\", \"username\": null}, {\"date\": \"2024-07-31T19:07\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-08-05T22:27\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-08-06T11:47\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-08-06T09:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-06T09:53\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-07T12:48\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-08-08T13:10\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-08-07T20:52\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-08-08T13:10\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-08-06T20:59\", \"username\": \"JSilverio\"}, {\"date\": \"2024-08-07T12:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-07T12:44\", \"username\": \"DAdams\"}, {\"date\": \"2024-08-07T12:47\", \"username\": \"DAdams\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"08-19-2024\", \"time\": \"17:45:52\", \"value\": [{\"add\": \"1266 GA Highway 102 E\", \"age\": 43, \"ano\": \"\", \"cno\": \"(706) 595-6637\", \"dob\": \"1981-06-09\", \"eno\": \"7069147402\", \"lob\": \"On Exchange\", \"pno\": 7064664045, \"zip\": 30810, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gibson\", \"gend\": 1, \"insh\": \"0007342414001\", \"mzip\": 30810, \"name\": \"Christy Murphy\", \"plan\": \"Alliant\", \"pphy\": \"Nancy Cox\", \"ppno\": \"7065476409\", \"race\": \"\", \"cliId\": \"\", \"email\": \"chrismarie2600@gmail.com\", \"ename\": \"Sandra Pierce\", \"madd1\": \"1266 GA Highway 102 E\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gibson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"400 Canterbury Dr \", \"pcpnpi\": \"\", \"pcpzip\": \"30833\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"Wrens\", \"pcpname\": \"Wrens Physician Health Group\", \"program\": \"ACA\", \"evalDate\": \"2024-8-6 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7065479870\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"07-09-2024\", \"time\": \"15:30:27\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-19-2024 17:45:52\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-07-11T09:43\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, '{\"memberId\": \"0007342414001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 07 Aug 2024 00:59:26 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Please add that member would like to start NA to the CM Referral.\\n2.  Home Safety Tug was not completed please add comment why.\\n3.  Home Safety have you ever physically or felt emotionally abused by someone answered yes.  Please add comment with info r/t to this question.\\nThanks\\nJudi\\n\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 07 Aug 2024 16:48:58 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Member declined assistance with finding a support group. Stated she will return to the NA group she used in the past. Added this to HRA and will update the CM referral.\\n2. Cord under rug is not in a walking area, member has no history of falls, and she was pain-free today. Added the rationale to the HRA. \\n3. Member was reluctant to answer the question and I did not want to bring up past hurts. Added to HRA.\\nThank you\"}, \"mailId\": \"\"}], \"memberName\": \"Christy Murphy\", \"codingAnalyst\": \"\", \"dateOfService\": \"08/06/2024 08:00 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"7/31/2024 @ 07:07 PM\", \"result\": 0, \"comment\": \"Called to schedule HRA  w/ DELISE ADAMS members scheduled for 08/06/24 at 8:00am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 03:53 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/18/2024 @ 03:53 PM\"}, {\"date\": \"7/16/2024 @ 01:51 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/17/2024 @ 01:51 PM\"}, {\"date\": \"6/28/2024 @ 01:24 PM\", \"result\": 0, \"comment\": \"06/28/2024 JC: called for HRA-Faith Enwefah-Virtual: member called back to scheduled for 7/10/2024 @ 4:00pm - 5:00pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"5/21/2024 @ 11:39 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 11:39 AM\"}, {\"date\": \"5/17/2024 @ 03:31 PM\", \"result\": 3, \"comment\": \"Called member to set up Virtual HRA with Sallie Key \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tinera Henderson\", \"callbackDate\": \"5/24/2024 @ 03:31 PM\"}, {\"date\": \"5/16/2024 @ 12:38 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 12:38 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007342414001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007342414001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007342414001\", \"scheduleDate\": \"2024-8-6T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-16-2024 12:38:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"07-11-2024 09:43:27\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-31-2024 19:07:28\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2024-08-13 08:59:42\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"e8552606-5973-11ef-aee8-3b33ad3ea55e\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-8-6T08:00', '2024-12-31', '2024-08-06T08:00', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:24', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007342414001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007342414001_Murphy, Christy_08062024.pdf\", \"ftp_upload_date\": \"2024-08-13 08:59:42\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Cox, Nancy_0007342414001_08062024.pdf\"}', 'ACA_0007342414001_Murphy, Christy_08062024', NULL, 'PCP_Cox, Nancy_0007342414001_08062024', NULL, '[{\"date\": \"2024-08-06T13:53:48.097Z\", \"signature\": \"data:image/png;base64,[encoded data, 23512 characters]\"}, {\"date\": \"2024-08-07T16:48:58.625Z\", \"signature\": \"data:image/png;base64,[encoded data, 23476 characters]\"}]', '2024-08-06T08:36', 'Member_Summary_0007342414001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007342414001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007342414001.pdf\", \"member_ftp_upload_date\": \"2024-08-13 08:59:43\"}', 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
(2291, NULL, NULL, NULL, '0007343071001', '335111', '', '26056802', 'Tammy', 'Shedd', '', '{\"DOB\": 28722, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1225300494, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"DEMOREST\", \"Pcp_Name\": \"DEREK KLEMM\", \"PCP_Phone\": 7067544348, \"Pcp_State\": \"GA\", \"Member_City\": \"Cornelia\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cornelia\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-08-20\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"396 HISTORIC HIGHWAY 441 N\", \"Screening_IHA\": \"No\", \"member_id_two\": 335111, \"Mailing_County\": \"HABERSHAM\", \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"112 Heritage Gardens Dr\", \"Member_Address2\": \"Apt 112B\", \"Member_Zip_Code\": 305310000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"112 Heritage Gardens Dr\", \"Mailing_Address2\": \"Apt 112B\", \"Mailing_Zip_Code\": 30531, \"Member_Last_name\": \"Shedd\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tammy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tshedd1978@gmail.com\", \"Member_Suspect_Codes\": 120, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065198532, \"Member_Identification_Number\": \"0007343071001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-21-2024 00:00:13\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-06-21 00:00:13\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-05T13:56\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-05T13:56\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:25\", \"value\": [{\"add\": \"112 Heritage Gardens Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-08-20\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065198532, \"zip\": 305310000, \"add2\": \"Apt 112B\", \"add3\": \"\", \"city\": \"Cornelia\", \"gend\": 1, \"insh\": \"0007343071001\", \"mzip\": 30531, \"name\": \"Tammy Shedd\", \"plan\": \"Alliant\", \"pphy\": \"DEREK KLEMM\", \"ppno\": 7067544348, \"cliId\": \"\", \"email\": \"tshedd1978@gmail.com\", \"ename\": \"\", \"madd1\": \"112 Heritage Gardens Dr\", \"madd2\": \"Apt 112B\", \"madd3\": \"\", \"mcity\": \"Cornelia\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"396 HISTORIC HIGHWAY 441 N\", \"pcpnpi\": 1225300494, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"DEMOREST\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:42\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"6/5/2024 @ 01:56 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 01:56 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-05-2024 13:56:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:56\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', '{\"orderType\": 0, \"sortOrder\": 1718174621}', 1, NULL, NULL, NULL, NULL, '2024-08-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2292, NULL, NULL, NULL, '0007344612001', '407276', '', '2661185', 'Thomas', 'Hale', '', '{\"DOB\": 25193, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Rome\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Rome\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-12-21\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 407276, \"Mailing_County\": \"FLOYD\", \"Member_Country\": \"FLOYD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"313 Burnett Ferry Rd SW\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30165, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"313 Burnett Ferry Rd SW\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30165, \"Member_Last_name\": \"Hale\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Thomas\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"todd1x11@bellsouth.net\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7865126667, \"Member_Identification_Number\": \"0007344612001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:15\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:15\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-23T12:42\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-04-23T12:42\", \"reportStatus_date\": \"2024-04-23T12:42\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-23T12:42\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:25\", \"value\": [{\"add\": \"313 Burnett Ferry Rd SW\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-12-21\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7865126667, \"zip\": 30165, \"add2\": \"\", \"add3\": \"\", \"city\": \"Rome\", \"gend\": 0, \"insh\": \"0007344612001\", \"mzip\": 30165, \"name\": \"Thomas Hale\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"todd1x11@bellsouth.net\", \"ename\": \"\", \"madd1\": \"313 Burnett Ferry Rd SW\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Rome\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:42\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-23T12:42\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/23/2024 @ 12:42 PM\", \"result\": 9, \"comment\": \"Member refusal, he informed me he doesn\'t need this appt -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-23-2024 12:42:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"04-22-2024 00:31:56\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2293, NULL, NULL, NULL, '0007347049001', '406116', '', '26056802', 'Robert', 'Blankenship', '', '{\"DOB\": 26877, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Flowery Branch\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Flowery Branch\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-08-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 406116, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"6298 Gaines Ferry Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30542, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"6298 Gaines Ferry Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30542, \"Member_Last_name\": \"Blankenship\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Robert\", \"Member_Middle_name\": \"Louis\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"carrie@rlblandscapes.com\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6789087340, \"Member_Identification_Number\": \"0007347049001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:34:15\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:15\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-26T17:30\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T18:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T18:42\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [{\"date\": \"2024-05-10T16:31\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-11T18:17\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-16T12:49\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-07-31T13:52\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-26T17:30\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-10T16:31\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T18:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T18:42\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T18:17\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T12:49\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-31T13:52\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-11-11T00:45\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:33\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-03T12:54\", \"username\": null}, {\"date\": \"2024-07-03T12:54\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:24\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:25\", \"value\": [{\"add\": \"6298 Gaines Ferry Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-08-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6789087340, \"zip\": 30542, \"add2\": \"\", \"add3\": \"\", \"city\": \"Flowery Branch\", \"gend\": 0, \"insh\": \"0007347049001\", \"mzip\": 30542, \"name\": \"Robert Louis Blankenship\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"carrie@rlblandscapes.com\", \"ename\": \"\", \"madd1\": \"6298 Gaines Ferry Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Flowery Branch\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:42\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"10/30/2024 @ 04:38 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 01:52 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 12:49 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 06:17 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 06:42 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 06:41 PM\"}, {\"date\": \"6/3/2024 @ 06:43 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/10/2024 @ 06:43 PM\"}, {\"date\": \"5/10/2024 @ 04:31 PM\", \"result\": 10, \"comment\": \"DISCONNECTED - Members primary number no longer in service. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 04:14 PM\"}, {\"date\": \"4/26/2024 @ 05:30 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - No VM Setup  \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/10/2024 @ 05:30 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 17:30:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"11-11-2024 00:45:20\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2294, NULL, NULL, NULL, '0007347289001', '414127', '', '21881792', 'Larry', 'Glass', '', '{\"DOB\": 27372, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-12-09\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 414127, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"71 Harpers Run\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30117, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"71 Harpers Run\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30117, \"Member_Last_name\": \"Glass\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Larry\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"glasslarry2@gmail.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7707561760, \"Member_Identification_Number\": \"0007347289001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:15\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T12:53\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T17:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-06T15:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-13T14:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-17T16:18\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T12:53\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T17:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-06T15:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-17T16:18\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T12:53\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:33\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-03T12:54\", \"username\": null}, {\"date\": \"2024-07-03T12:54\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:24\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:25\", \"value\": [{\"add\": \"71 Harpers Run\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-12-09\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7707561760, \"zip\": 30117, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 0, \"insh\": \"0007347289001\", \"mzip\": 30117, \"name\": \"Larry Glass\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"glasslarry2@gmail.com\", \"ename\": \"\", \"madd1\": \"71 Harpers Run\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:42\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:42\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 10:42 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/30/2024 @ 10:08 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/29/2024 @ 09:37 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 05:37 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 05:40 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 02:12 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a F2F HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 12:53 PM\", \"result\": 3, \"comment\": \"07/03/2024 JC: called for HRA-Delise Adams-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/17/2024 @ 04:18 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/18/2024 @ 04:18 PM\"}, {\"date\": \"6/13/2024 @ 02:57 PM\", \"result\": 3, \"comment\": \"06/13/2024 JC: called for HRA-Faith Enwefah-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/20/2024 @ 02:57 PM\"}, {\"date\": \"5/6/2024 @ 03:43 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE FAITH 5/8.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/10/2024 @ 03:42 PM\"}, {\"date\": \"4/29/2024 @ 05:12 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 05:12 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 17:12:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-03-2024 12:53:05\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:25', 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
(2295, 2888643, 44829497, '62685179', '0007349537001', '409926', '', '26056802', 'RANDY', 'HARDMAN', '', '{\"DOB\": 25756, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30677\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Watkinsville\", \"Pcp_Name\": \"Dr. Toby M. Bond\", \"PCP_Phone\": \"7065489655\", \"Member_City\": \"Greensboro\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Greensboro\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-07-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1181 Langford Dr Ste 105\", \"Screening_IHA\": \"No\", \"member_id_two\": 409926, \"Mailing_County\": \"GREENE\", \"Member_Country\": \"GREENE\", \"PCP_Fax_Number\": \"7065489672\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1161 Old Bethany Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30642, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1161 Old Bethany Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30642, \"Member_Last_name\": \"HARDMAN\", \"Medication_Review\": \"N\", \"Member_first_name\": \"RANDY\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"joathillc@gmail.com\", \"Member_Suspect_Codes\": \"1, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7706806001, \"Member_Identification_Number\": \"0007349537001\", \"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:38:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:38:54\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-22T10:17\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-23T12:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-24T11:29\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T10:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T12:08\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:38\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-16T12:51\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-20T15:18\", \"reportStatus_date\": \"2024-05-16T12:51\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-24T12:34\", \"reportStatus_date\": \"2024-05-24T11:29\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:38\", \"reportStatus_date\": \"2024-05-31T14:38\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:38\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-16T12:51\", \"username\": null}, {\"date\": \"2024-05-16T12:51\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-20T15:18\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-22T12:56\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-24T11:29\", \"username\": \"JessicaSAdmin\"}], \"readyForQa\": [{\"date\": \"2024-05-21T12:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:33\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:48\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:51\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T13:57\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T14:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:54\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T16:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T09:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T10:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T11:29\", \"username\": \"JessicaSAdmin\"}, {\"date\": \"2024-05-24T11:32\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-24T12:34\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-28T12:08\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-23T12:28\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-24T11:27\", \"username\": \"JessicaSAdmin\"}, {\"date\": \"2024-05-28T10:18\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-28T12:08\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-24T11:33\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-02-2024\", \"time\": \"14:15:33\", \"value\": [{\"add\": \"1161 Old Bethany Rd\", \"age\": 53, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-07-07\", \"eno\": \"706 3190513\", \"lob\": \"On Exchange\", \"pno\": 7706806001, \"zip\": 30642, \"add2\": \"\", \"add3\": \"\", \"city\": \"Greensboro\", \"gend\": 0, \"insh\": \"0007349537001\", \"mzip\": 30642, \"name\": \"RANDY HARDMAN\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Toby M. Bond\", \"ppno\": \"7065489655\", \"cliId\": \"\", \"email\": \"joathillc@gmail.com\", \"ename\": \"Heather Hardman\", \"madd1\": \"1161 Old Bethany Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Greensboro\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1181 Langford Dr Ste 105\", \"pcpnpi\": \"\", \"pcpzip\": \"30677\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"Watkinsville\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7065489672\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"PCP added\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-17-2024\", \"time\": \"17:54:39\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-02-2024 14:15:33\"}', NULL, NULL, '{\"memberId\": \"0007349537001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"\", \"queryData\": [{\"date\": \"Fri, 24 May 2024 15:27:52 GMT\", \"name\": \"JessicaSAdmin\", \"role\": \"admin\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nIn the assessment of diagnosis, GI, pancreatitis dx- The coders requested clarification regarding this condition.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 24 May 2024 15:33:19 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi FAith,\\nThe member was hosptialized in Oct 2023 for pancreatitis in the medical history section. In the assessment of diagnosis, GI pancreatitis dx, is active,\\n\\\"no\\\" to recurrent episodes. The coders wanted to clarify that this is an \\\"acute\\\" condition? There is a comment that she is having testing done in June. \\nThank you\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 24 May 2024 16:34:43 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"RANDY HARDMAN\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/21/2024 02:00 AM\", \"clinicianMailId\": \"\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/16/2024 @ 12:51 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/ Faith Enwefah on 5/21 @ 2pm - sent via sms\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007349537001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007349537001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007349537001\", \"scheduleDate\": \"2024-5-21T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-16-2024 12:51:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-16-2024 12:51:14\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:38:52\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"07169c81-1f7d-11ef-8dfc-b3d587943d9c\\\",\\\"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-21T14:00', '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:26', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007349537001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007349537001_HARDMAN, RANDY_05212024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:38:51\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Bond, Tobi_0007349537001_05212024.pdf\"}', 'ACA_0007349537001_HARDMAN, RANDY_05212024', NULL, 'PCP_Bond, Tobi_0007349537001_05212024', NULL, '[{\"date\": \"2024-05-22T14:17:24.545Z\", \"signature\": \"data:image/png;base64,[encoded data, 23372 characters]\"}, {\"date\": \"2024-05-24T16:34:43.357Z\", \"signature\": \"data:image/png;base64,[encoded data, 23384 characters]\"}]', '2024-05-21T15:00', 'Member_Summary_0007349537001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007349537001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007349537001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:38:53\"}', 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
(2296, NULL, NULL, NULL, '0007350649001', '405514', '', '21881792', 'Priscilla', 'Tolbert', '', '{\"DOB\": 28682, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Carrollton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Carrollton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-07-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 405514, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"212 Old Airport Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30116, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"212 Old Airport Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30116, \"Member_Last_name\": \"Tolbert\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Priscilla\", \"Member_Middle_name\": \"E\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"pltol3@charter.net\", \"Member_Suspect_Codes\": 82, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4042131436, \"Member_Identification_Number\": \"0007350649001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T17:16\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-05-06T15:47\", \"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-29T17:16\"}, {\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-06T15:47\", \"reportStatus_date\": \"2024-05-06T15:47\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-06T15:47\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:26\", \"value\": [{\"add\": \"212 Old Airport Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-07-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4042131436, \"zip\": 30116, \"add2\": \"\", \"add3\": \"\", \"city\": \"Carrollton\", \"gend\": 1, \"insh\": \"0007350649001\", \"mzip\": 30116, \"name\": \"Priscilla E Tolbert\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"pltol3@charter.net\", \"ename\": \"\", \"madd1\": \"212 Old Airport Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Carrollton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:43\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-06T15:47\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/6/2024 @ 03:47 PM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED OFFER TO SCHEDULE IHA IN 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/29/2024 @ 05:16 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL.  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 05:16 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 17:16:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:56\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2297, NULL, NULL, NULL, '0007353169001', '413769', '', '21881792', 'Katie', 'Wood', '', '{\"DOB\": 34520, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Jefferson\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Jefferson\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1994-07-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413769, \"Mailing_County\": \"JACKSON\", \"Member_Country\": \"JACKSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"371 Old Mill Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30549, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"371 Old Mill Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30549, \"Member_Last_name\": \"Wood\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Katie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Kodymwood@icloud.com\", \"Member_Suspect_Codes\": 212, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7702622662, \"Member_Identification_Number\": \"0007353169001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:34:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-05T10:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T18:20\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-21T17:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [{\"date\": \"2024-07-01T16:28\", \"text\": \"Wrong Number\", \"method\": \"api\", \"status\": 7}], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-06T18:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-21T17:28\"}, {\"text\": \"Wrong Number\", \"type\": \"ReportStatus\", \"status\": 7, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-01T16:28\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:26\", \"value\": [{\"add\": \"371 Old Mill Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1994-07-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7702622662, \"zip\": 30549, \"add2\": \"\", \"add3\": \"\", \"city\": \"Jefferson\", \"gend\": 1, \"insh\": \"0007353169001\", \"mzip\": 30549, \"name\": \"Katie Wood\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"Kodymwood@icloud.com\", \"ename\": \"\", \"madd1\": \"371 Old Mill Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Jefferson\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 4, \"callLog\": [{\"date\": \"7/1/2024 @ 04:28 PM\", \"result\": 4, \"comment\": \"Caller stated number no longer belongs to member - Wrong number. Call to schedule virtual HRA w/ Delise Adams.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"6/21/2024 @ 05:28 PM\", \"result\": 3, \"comment\": \"06/21/2024 JC: called for HRA-Nykya Cox-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/28/2024 @ 05:28 PM\"}, {\"date\": \"6/6/2024 @ 03:20 PM\", \"result\": 3, \"comment\": \"06/06/2024 JC: called for HRA-Faith Enwefah: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"6/10/2024 @ 03:20 PM\"}, {\"date\": \"6/5/2024 @ 10:31 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/6/2024 @ 10:30 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-05-2024 10:31:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-01-2024 16:28:41\", \"status\": 2, \"details\": \"disconnected/wrong number\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:26', 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
(2298, 2888643, 44829497, '62685179', '0007356808001', '405542', '', '21881792', 'Laura', 'Payne', '', '{\"DOB\": 37082, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"30153\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Rockmart\", \"Pcp_Name\": \"Dr. Terrell Jenrette\", \"PCP_Phone\": \"7706847846\", \"Member_City\": \"Temple\", \"Office_Name\": \"Atrium Health Floyd Primary Care Family Medicine Rockmart\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Temple\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2001-07-10\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1650 Chattahoochee Dr.\", \"Screening_IHA\": \"No\", \"member_id_two\": 405542, \"Mailing_County\": \"CARROLL\", \"Member_Country\": \"CARROLL\", \"PCP_Fax_Number\": \"7706848294\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"134 Temple terrace\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30179, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"134 Temple terrace\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30179, \"Member_Last_name\": \"Payne\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Laura\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"lauraapayne197@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6782607375, \"Member_Identification_Number\": \"0007356808001\", \"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:39:00\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:39:01\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-29T13:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-13T18:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-20T15:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-21T08:26\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-23T08:47\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-23T11:11\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:39\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-06T13:11\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-05-10T14:39\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-29T13:09\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-06T13:11\", \"reportStatus_date\": \"2024-05-06T13:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-13T18:47\", \"reportStatus_date\": \"2024-05-13T18:47\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 7, \"hraStatus_date\": \"2024-05-20T15:42\", \"reportStatus_date\": \"2024-05-20T15:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-23T11:11\", \"reportStatus_date\": \"2024-05-23T11:11\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:39\", \"reportStatus_date\": \"2024-05-31T14:39\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:39\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-06T13:11\", \"username\": null}, {\"date\": \"2024-05-06T13:11\", \"username\": null}, {\"date\": \"2024-05-10T14:39\", \"username\": null}, {\"date\": \"2024-05-10T14:39\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-12T06:09\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-14T08:55\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-21T08:26\", \"username\": \"JessicaSAdmin\"}], \"readyForQa\": [{\"date\": \"2024-05-12T06:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:57\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T11:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:01\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:16\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T12:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T17:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:27\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:33\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:36\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:39\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:42\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:45\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-13T18:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T02:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T11:23\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-17T11:26\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-17T11:29\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-20T15:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-21T08:26\", \"username\": \"JessicaSAdmin\"}, {\"date\": \"2024-05-21T08:30\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-21T10:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-23T08:45\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-23T11:11\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-20T15:42\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-23T08:47\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-23T11:11\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-15T18:03\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-17T02:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T02:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-17T11:32\", \"username\": \"JSilverio\"}, {\"date\": \"2024-05-21T08:30\", \"username\": \"JScanlonQAL\"}, {\"date\": \"2024-05-21T10:18\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-02-2024\", \"time\": \"14:44:54\", \"value\": [{\"add\": \"134 Temple terrace\", \"age\": 22, \"ano\": \"\", \"cno\": \"\", \"dob\": \"2001-07-10\", \"eno\": \"706 407 3705\", \"lob\": \"On Exchange\", \"pno\": 6782607375, \"zip\": 30179, \"add2\": \"\", \"add3\": \"\", \"city\": \"Temple\", \"gend\": 1, \"insh\": \"0007356808001\", \"mzip\": 30179, \"name\": \"Laura Payne\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Terrell Jenrette\", \"ppno\": \"7706847846\", \"race\": \"\", \"cliId\": \"\", \"email\": \"lauraapayne197@gmail.com\", \"ename\": \"Loretta Beavers\", \"madd1\": \"134 Temple terrace\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Temple\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1650 Chattahoochee Dr.\", \"pcpnpi\": \"\", \"pcpzip\": \"30153\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"Rockmart\", \"pcpname\": \"Atrium Health Floyd Primary Care Family Medicine Rockmart\", \"program\": \"ACA\", \"evalDate\": \"2024-05-13 11:30 AM\", \"evalName\": \"Faith Enwefah, NP\", \"pcpfaxno\": \"7706848294\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"Added \", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-12-2024\", \"time\": \"06:09:45\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-02-2024 14:44:54\"}', NULL, NULL, '{\"memberId\": \"0007356808001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Wed, 15 May 2024 22:03:15 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Med form reports dasetta 1 35 28 and ondansetron for suspect seizure D/O but it is not reported in the HRA.\\n2.  assessment of diagnosis please add PCOS to endocrine.\\n3.  med list please add diagnosis for medroxyprogesterone.\\nThanks\\nJudi \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 17 May 2024 06:15:39 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved \\nThank you.\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 17 May 2024 15:32:26 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  PAT  form reports dasetta 1 35 28 , oxycodone 325-5 and ondansetron filled 3/24 but it is not reported in the HRA.  Should it be added to the HRA med list and pain section to report opioid usage?\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 20 May 2024 19:03:26 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Hi Judi,\\nThe patient said she took the oxycodone when she had her surgery in March but no longer taking the medication.\\nThank you.\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 12:30:04 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nIn the medication section, long term use- Insulin is selected, but  there is no insulin listed in the med list. Please review \\nand make any updates. \\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 14:15:24 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Tue, 21 May 2024 14:18:48 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"Hi Faith,\\nMedication- LT use question. Thank you for removing insulin, but the question appears blank. Can you select none if that is correct?\\nThank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 23 May 2024 12:45:20 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Laura Payne\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/13/2024 11:30 AM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"5/10/2024 @ 02:39 PM\", \"result\": 12, \"comment\": \"Member is rescheduled from 5/14/24 to 5/13/24 with Faith Q.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"\"}, {\"date\": \"5/6/2024 @ 01:11 PM\", \"result\": 0, \"comment\": \"SCHEDULED FAITH 5/14 - MULTIPLE PETS IN THE HOME. PARK IN DRIVEWAY\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"4/29/2024 @ 01:09 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/30/2024 @ 01:09 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007356808001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007356808001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007356808001\", \"scheduleDate\": \"2024-5-13T14:38\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 13:09:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"05-10-2024 14:39:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:38:58\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"0b1ae68e-1f7d-11ef-8dfc-7f7e1535ee7b\\\",\\\"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-13T14:38', '2024-12-31', '2024-05-13T11:30', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:27', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007356808001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007356808001_Payne, Laura_05132024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:38:58\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Jenrette, Terrell_0007356808001_05132024.pdf\"}', 'ACA_0007356808001_Payne, Laura_05132024', NULL, 'PCP_Jenrette, Terrell_0007356808001_05132024', NULL, '[{\"date\": \"2024-05-13T22:47:41.819Z\", \"signature\": \"data:image/png;base64,[encoded data, 23352 characters]\"}, {\"date\": \"2024-05-17T06:15:38.629Z\", \"signature\": \"data:image/png;base64,[encoded data, 23392 characters]\"}, {\"date\": \"2024-05-20T19:03:26.134Z\", \"signature\": \"data:image/png;base64,[encoded data, 23396 characters]\"}, {\"date\": \"2024-05-21T14:15:24.109Z\", \"signature\": \"data:image/png;base64,[encoded data, 23396 characters]\"}, {\"date\": \"2024-05-23T12:45:19.465Z\", \"signature\": \"data:image/png;base64,[encoded data, 23404 characters]\"}]', '2024-05-13T12:30', 'Member_Summary_0007356808001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007356808001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007356808001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:39:00\"}', NULL, NULL, NULL, NULL);
INSERT INTO `HRA_member_client_009_2024` (`id`, `qa_id`, `coder_id`, `nurse_id`, `member_id`, `member_id_two`, `member_unique_id`, `scheduler_id`, `firstname`, `lastname`, `hicn`, `memberinfo`, `clientid`, `year`, `hra`, `hraStatus`, `isPafViewed`, `examReview`, `memStatus`, `reportStatus`, `currentStatus`, `reportStatusHistory`, `reportHraStatusWeekly`, `hraStatusHistory`, `hraFileUpdatedHistory`, `cancelHistory`, `versioning`, `query_form`, `scheduler`, `schedulerDetails`, `schedulerCallHraStatus`, `schedulerCallLogDetails`, `schedulerCallOrder`, `availForSchedule`, `importTrackerDetails`, `pcp_fax_response`, `VisitType`, `scheduleDate`, `termDate`, `EvaluationDate`, `refusalLetterDate`, `sentToAvility`, `invoiceDate`, `reportNotes`, `admin_idno`, `created_on`, `updated_on`, `isDownload`, `DownloadDate`, `utcfiles`, `Ftp_upload_status`, `pdf_file_name`, `client_ftp_upload_status`, `summary_pdf_file_name`, `referralForm`, `clinician_signature`, `exam_finished_date`, `member_pdf_file_name`, `member_ftp_upload_status`, `utcLetterDownloadDate`, `declineLetterDownloadDate`, `addendum_clinician_signature`, `omwDate`) VALUES
(2299, NULL, NULL, NULL, '0007357043001', '412920', '', '26056802', 'Amy', 'Westbrook', '', '{\"DOB\": 26910, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Harrison\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Harrison\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1973-09-03\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 412920, \"Mailing_County\": \"WASHINGTON\", \"Member_Country\": \"WASHINGTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"225 Jennie Lee Poole Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31035, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"225 Jennie Lee Poole Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31035, \"Member_Last_name\": \"Westbrook\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Amy\", \"Member_Middle_name\": \"Elizabeth\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"libbywestbrook1973@gmail.com\", \"Member_Suspect_Codes\": \"21, 74\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4783578549, \"Member_Identification_Number\": \"0007357043001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-16T12:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T15:31\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [{\"date\": \"2024-05-20T12:01\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-05-20T12:01\", \"reportStatus_date\": \"2024-05-20T12:01\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-05-20T12:01\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:27\", \"value\": [{\"add\": \"225 Jennie Lee Poole Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1973-09-03\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4783578549, \"zip\": 31035, \"add2\": \"\", \"add3\": \"\", \"city\": \"Harrison\", \"gend\": 1, \"insh\": \"0007357043001\", \"mzip\": 31035, \"name\": \"Amy Elizabeth Westbrook\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"libbywestbrook1973@gmail.com\", \"ename\": \"\", \"madd1\": \"225 Jennie Lee Poole Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Harrison\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:43\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-05-20T12:01\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"5/20/2024 @ 12:01 PM\", \"result\": 9, \"comment\": \"MEMBER RETURNED CALL - DECLINED OFFER TO SCHEDULE VIRTUAL HRA. \", \"inBound\": true, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/17/2024 @ 03:31 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/21/2024 @ 03:31 PM\"}, {\"date\": \"5/16/2024 @ 12:55 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 12:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-16-2024 12:55:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-22-2024 00:31:56\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 3}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2300, NULL, NULL, NULL, '0007357153001', '417838', '', '2661185', 'Gonzalo', 'Baires', '', '{\"DOB\": 23791, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-02-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 417838, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3518 Sugar Hillway\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30507, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3518 Sugar Hillway\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30507, \"Member_Last_name\": \"Baires\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Gonzalo\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"gbaires@icloud.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4702348220, \"Member_Identification_Number\": \"0007357153001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-06-11T13:48\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-16T10:12\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T12:48\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-07T14:17\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T13: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-04-25T15:17\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T10:12\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T12:48\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T14:17\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T13:48\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:33\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-03T12:54\", \"username\": null}, {\"date\": \"2024-07-03T12:54\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:24\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:27\", \"value\": [{\"add\": \"3518 Sugar Hillway\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-02-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4702348220, \"zip\": 30507, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0007357153001\", \"mzip\": 30507, \"name\": \"Gonzalo Baires\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"gbaires@icloud.com\", \"ename\": \"\", \"madd1\": \"3518 Sugar Hillway\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 01:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 05:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/31/2024 @ 04:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 11:22 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Tiana Proctor.  - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 04:21 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Connie Middleton. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/22/2024 @ 01:15 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 01:48 PM\", \"result\": 3, \"comment\": \"LVM F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/7/2024 @ 02:17 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/10/2024 @ 02:17 PM\"}, {\"date\": \"5/29/2024 @ 12:48 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/29/2024 @ 12:48 PM\"}, {\"date\": \"5/16/2024 @ 10:12 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 10:12 AM\"}, {\"date\": \"4/25/2024 @ 03:17 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 03:17 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 15:17:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"06-11-2024 13:48:18\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 11}', '{\"orderType\": 0, \"sortOrder\": 1730527615}', 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2301, 57818338, 44829497, '56716210', '0007358425001', '411507', '', '26056802', 'Melissa', 'Meister', '', '{\"DOB\": 33369, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": null, \"Pcp_City\": \"\", \"Pcp_Name\": \"doesn\'t have one\", \"PCP_Phone\": \"\", \"Member_City\": \"Baldwin\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Baldwin\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1991-05-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 411507, \"Member_Country\": \"HABERSHAM\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"127 Switzerland Avenue\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30511, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO BOX 626\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30511, \"Member_Last_name\": \"Meister\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Melissa\", \"Member_Middle_name\": \"Braswell\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"melissameister4321@gmail.com\", \"Member_Suspect_Codes\": 211, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 4783965543, \"Member_Identification_Number\": \"0007358425001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-09-2024 09:56:24\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-07-09 09:56:24\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-05T13:04\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-06-29T14:41\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-02T00:04\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-02T14:20\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-07-09T09:56\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-19T13:35\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-05T13:04\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-19T13:35\", \"reportStatus_date\": \"2024-06-19T13:35\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-06-29T14:41\", \"reportStatus_date\": \"2024-06-29T14:41\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-07-02T14:20\", \"reportStatus_date\": \"2024-07-02T14:20\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-07-09T09:56\", \"reportStatus_date\": \"2024-07-09T09:56\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-07-09T09:56\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-06-19T13:35\", \"username\": null}, {\"date\": \"2024-06-19T13:35\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-06-27T23:43\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-07-01T13:17\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-06-29T14:41\", \"username\": \"DAdams\"}, {\"date\": \"2024-06-29T14:41\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-07-02T14:20\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-07-02T00:04\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-07-02T14:20\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-29-2024\", \"time\": \"14:41:24\", \"value\": [{\"add\": \"127 Switzerland Avenue\", \"age\": 33, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1991-05-11\", \"eno\": \"7064919637\", \"lob\": \"On Exchange\", \"pno\": 4783965543, \"zip\": 30511, \"add2\": \"\", \"add3\": \"\", \"city\": \"Baldwin\", \"gend\": 1, \"insh\": \"0007358425001\", \"mzip\": 30511, \"name\": \"Melissa Braswell Meister\", \"plan\": \"Alliant\", \"pphy\": \"doesn\'t have one\", \"ppno\": \"\", \"race\": \"\", \"cliId\": \"\", \"email\": \"melissameister4321@gmail.com\", \"ename\": \"Nerik Meister\", \"madd1\": \"PO BOX 626\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Baldwin\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-06-28 08:10 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-27-2024\", \"time\": \"23:43:38\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"08-01-2024 16:24:10\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"6/19/2024 @ 01:35 PM\", \"result\": 0, \"comment\": \"06/19/2024 JC: called for HRA-Delise Adams-Virtual: scheduled for 6/28/2024 @ 8am - 9am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 01:04 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 01:04 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007358425001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0007358425001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0007358425001\", \"scheduleDate\": \"2024-6-28T08:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-05-2024 13:04:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"06-19-2024 13:35:10\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-07-09 09:56:23\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"06acad41-3dfb-11ef-a70b-0d0881c1295c\\\",\\\"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-28T08:00', '2024-12-31', '2024-06-28T08:10', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:28', NULL, NULL, NULL, NULL, NULL, 'ACA_0007358425001_Meister, Melissa_06282024', NULL, 'PCP_one, doesn\'t have_0007358425001_06282024', NULL, '[{\"date\": \"2024-06-29T18:41:24.546Z\", \"signature\": \"data:image/png;base64,[encoded data, 23504 characters]\"}]', '2024-06-28T08:39', 'Member_Summary_0007358425001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007358425001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007358425001.pdf\", \"member_ftp_upload_date\": \"2024-07-09 09:56:24\"}', 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
(2302, NULL, NULL, NULL, '0007361176001', '413944', '', '2661185', 'Adrian', 'Campillo', '', '{\"DOB\": 28562, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-03-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 413944, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1182 Enota Circle\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30501, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1182 Enota Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"Campillo\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Adrian\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"campilloadrian56@yahoo.com\", \"Member_Suspect_Codes\": 1, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 9567408530, \"Member_Identification_Number\": \"0007361176001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:34:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:34:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-08-19T17:14\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T15:19\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-08-19T17:14\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-05-16T10:15\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-10T14:43\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-30T11:51\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T15:19\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-16T10:15\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T14:43\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-30T11:51\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T17:14\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-07-11T09:33\", \"username\": \"TFerness2\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-07-03T12:54\", \"username\": null}, {\"date\": \"2024-07-03T12:54\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-09T15:24\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"06:03:28\", \"value\": [{\"add\": \"1182 Enota Circle\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-03-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 9567408530, \"zip\": 30501, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0007361176001\", \"mzip\": 30501, \"name\": \"Adrian A Campillo\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"campilloadrian56@yahoo.com\", \"ename\": \"\", \"madd1\": \"1182 Enota Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:26:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:26:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 04:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 05:14 PM\", \"result\": 13, \"comment\": \"Called to Schedule Virtual HRA with Debbie caller disconnected.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 11:51 AM\", \"result\": 6, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/31/2024 @ 11:51 AM\"}, {\"date\": \"7/10/2024 @ 02:43 PM\", \"result\": 6, \"comment\": \"Called to set up HRA with Faith Enwefah member does not speak english needs spanish callback.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/16/2024 @ 02:43 PM\"}, {\"date\": \"5/16/2024 @ 10:15 AM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED- MEMBER WILL NEED AN INTERPRETER \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 10:15 AM\"}, {\"date\": \"4/25/2024 @ 03:19 PM\", \"result\": 13, \"comment\": \"Caller disconnected during my intro- MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"4/26/2024 @ 03:19 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 15:19:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-19-2024 17:14:41\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:28', 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
(2303, 50892900, 44829497, '62685179', '0007361242001', '418041', '', '26056802', 'Colette', 'Woods', '', '{\"DOB\": 22844, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \"Dr. Ibrismov-phone # not in service\", \"PCP_Phone\": \"\", \"Member_City\": \"Athens\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Athens\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1962-07-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 418041, \"Mailing_County\": \"CLARKE\", \"Member_Country\": \"CLARKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1505 Danielsville Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30601, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1505 Danielsville Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30601, \"Member_Last_name\": \"Woods\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Colette\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"colette_woods_ccsd@yahoo.com\", \"Member_Suspect_Codes\": \"130, 21, 56\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7066127641, \"Member_Identification_Number\": \"0007361242001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"06-11-2024 11:16:23\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-06-11 11:16:23\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-16T12:57\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-26T04:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-03T07:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-03T13:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-06-11T11:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-17T15:40\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-05-17T15:40\", \"reportStatus_date\": \"2024-05-17T15:40\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-26T04:59\", \"reportStatus_date\": \"2024-05-26T04:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-06-03T13:06\", \"reportStatus_date\": \"2024-06-03T13:06\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-06-11T11:16\", \"reportStatus_date\": \"2024-06-11T11:16\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-06-11T11:16\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-17T15:40\", \"username\": null}, {\"date\": \"2024-05-17T15:40\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-24T07:35\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-28T08:21\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-24T07:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T07:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T15:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:05\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:08\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:11\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:14\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:20\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:23\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:26\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:32\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:35\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:38\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:41\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:44\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:47\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:50\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T16:53\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:00\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-24T17:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-26T04:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-26T04:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-28T18:54\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-29T05:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-30T14:28\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-06-03T13:06\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-06-03T07:37\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-06-03T13:06\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-28T18:55\", \"username\": \"fcopeland1\"}, {\"date\": \"2024-05-30T09:23\", \"username\": \"fcopeland1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-16-2024\", \"time\": \"16:06:29\", \"value\": [{\"add\": \"1505 Danielsville Rd\", \"age\": 62, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1962-07-17\", \"eno\": \"7062244225\", \"lob\": \"On Exchange\", \"pno\": 7066127641, \"zip\": 30601, \"add2\": \"\", \"add3\": \"\", \"city\": \"Athens\", \"gend\": 1, \"insh\": \"0007361242001\", \"mzip\": 30601, \"name\": \"Colette Woods\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Ibrismov-phone # not in service\", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"colette_woods_ccsd@yahoo.com\", \"ename\": \"Susan kesler\", \"madd1\": \"1505 Danielsville Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Athens\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"Added PCP, but member does not know the PCP phone number.\", \"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-24-2024\", \"time\": \"07:35:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-16-2024 16:06:29\"}', NULL, NULL, '{\"memberId\": \"0007361242001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"Tue, 28 May 2024 22:59:46 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"GU-\\\"other\\\"-\\\"symptoms\\\"-appears blank-please add comment \", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 29 May 2024 09:29:13 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nFaith Enwefah\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 30 May 2024 13:28:01 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Thanks Faith...just one more revision please:\\n\\nGI-\\\"other\\\"-\\\"symptom\\\" (regarding \\\"fatty liver\\\")-appears blank-please select \\\"none\\\" if there are no current symptoms.\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 30 May 2024 18:28:15 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"Colette Woods\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/24/2024 03:30 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"fcopeland@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/17/2024 @ 03:40 PM\", \"result\": 0, \"comment\": \"Scheduled Virtual HRA w/Faith Enwefah for 5/24/24 @ 3:30pm. Sent confirmation email to colette_woods_ccsd@yahoo.com and Colette will be using her iPhone or computer for the appt. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}, {\"date\": \"5/16/2024 @ 12:57 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/23/2024 @ 12:57 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0007361242001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0007361242001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0007361242001\", \"scheduleDate\": \"2024-5-24T15:30\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-16-2024 12:57:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-17-2024 15:40:37\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-06-11 11:16:20\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"8ee1ba00-2805-11ef-bb02-45f323283d45\\\",\\\"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-24T15:30', '2024-07-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 06:03:28', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007361242001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0007361242001_Woods, Colette_05242024.pdf\", \"ftp_upload_date\": \"2024-06-11 11:16:20\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_ibrismov, Dr_0007361242001_05242024.pdf\"}', 'ACA_0007361242001_Woods, Colette_05242024', NULL, 'PCP_ibrismov, Dr_0007361242001_05242024', NULL, '[{\"date\": \"2024-05-26T08:59:28.318Z\", \"signature\": \"data:image/png;base64,[encoded data, 23448 characters]\"}, {\"date\": \"2024-05-29T09:29:12.961Z\", \"signature\": \"data:image/png;base64,[encoded data, 23428 characters]\"}, {\"date\": \"2024-05-30T18:28:15.393Z\", \"signature\": \"data:image/png;base64,[encoded data, 23452 characters]\"}]', '2024-05-24T16:30', 'Member_Summary_0007361242001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0007361242001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0007361242001.pdf\", \"member_ftp_upload_date\": \"2024-06-11 11:16:22\"}', NULL, NULL, NULL, NULL);
